Upgrade to SD6 from 5507 Failing
My upgrade to version 6 keeps failing and rolling back... anyone have any pointers here?
<SNIP>
Modifying Table = RelatedSolutions, Column = SOLUTIONID bigint(19) NOT NULL defa
ult '0'
Modifying Table = RelatedSolutions, Column = OTHERSOLUTION bigint(19) NOT NULL d
efault '0'
Modifying Table = ReportSubModules, Column = CRITERIA varchar(250) NOT NULL defa
ult ''
Modifying Table = Announcement, Column = CREATEDDATE bigint(19) NOT NULL default
'0'
Modifying Table = Announcement, Column = USERID bigint(19) NOT NULL default '0'
Modifying Table = Announcement, Column = MESSAGE text NOT NULL
Modifying Table = CustomReport_Folder, Column = FOLDER_DESC varchar(250) NOT NUL
L default ''
Modifying Table = CustomReport_Details, Column = REPORT_DESC varchar(250) NOT NU
LL default ''
java.sql.SQLException: Communication link failure: java.net.SocketException, und
erlying cause: Connection reset
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Connection reset
STACKTRACE:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read1(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1313)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1460)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1635)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
Mar 3, 2007 2:09:59 PM com.adventnet.servicedesk.updatemgr.util.SDPreProcessor i
nstall
INFO: Problem during installation of patch
java.sql.SQLException: Communication link failure: java.net.SocketException, und
erlying cause: Connection reset
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Connection reset
STACKTRACE:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read1(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1313)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1460)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1635)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
reverting in preprocessor
=======================================================
Error : Please wait reverting to old build!!!
1. Renaming modified mysql
2. Extracting backup mysql
Mar 3, 2007 2:10:04 PM com.adventnet.j2ee.deployment.service.internal.JarExtract
or extract
INFO: Extraction for C:\AdventNet\ME\ServiceDesk\mysql.zip to C:\AdventNet\ME\S
erviceDesk\mysql
=======================================================
Mar 3, 2007 2:10:06 PM com.adventnet.servicedesk.updatemgr.util.SDPreProcessor <
init>
SEVERE: Inside SDPreProcessor.
<SNIP>
Modifying Table = RelatedSolutions, Column = SOLUTIONID bigint(19) NOT NULL defa
ult '0'
Modifying Table = RelatedSolutions, Column = OTHERSOLUTION bigint(19) NOT NULL d
efault '0'
Modifying Table = ReportSubModules, Column = CRITERIA varchar(250) NOT NULL defa
ult ''
Modifying Table = Announcement, Column = CREATEDDATE bigint(19) NOT NULL default
'0'
Modifying Table = Announcement, Column = USERID bigint(19) NOT NULL default '0'
Modifying Table = Announcement, Column = MESSAGE text NOT NULL
Modifying Table = CustomReport_Folder, Column = FOLDER_DESC varchar(250) NOT NUL
L default ''
Modifying Table = CustomReport_Details, Column = REPORT_DESC varchar(250) NOT NU
LL default ''
java.sql.SQLException: Communication link failure: java.net.SocketException, und
erlying cause: Connection reset
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Connection reset
STACKTRACE:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read1(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1313)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1460)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1635)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
Mar 3, 2007 2:09:59 PM com.adventnet.servicedesk.updatemgr.util.SDPreProcessor i
nstall
INFO: Problem during installation of patch
java.sql.SQLException: Communication link failure: java.net.SocketException, und
erlying cause: Connection reset
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Connection reset
STACKTRACE:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.io.BufferedInputStream.fill(Unknown Source)
at java.io.BufferedInputStream.read1(Unknown Source)
at java.io.BufferedInputStream.read(Unknown Source)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1313)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1460)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1635)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1106)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1200)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2084)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2034)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1249)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1195)
at org.enhydra.jdbc.core.CoreStatement.executeUpdate(CoreStatement.java:
117)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.changeColumnS
ize(SDPreProcessor.java:822)
at com.adventnet.servicedesk.updatemgr.util.SDPreProcessor.install(SDPre
Processor.java:646)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPreInstallation(
Unzipper.java:309)
at com.adventnet.tools.update.installer.Unzipper.invokePreInstallationCl
asses(Unzipper.java:136)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPat
ch.java:274)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:2
24)
at java.lang.Thread.run(Unknown Source)
reverting in preprocessor
=======================================================
Error : Please wait reverting to old build!!!
1. Renaming modified mysql
2. Extracting backup mysql
Mar 3, 2007 2:10:04 PM com.adventnet.j2ee.deployment.service.internal.JarExtract
or extract
INFO: Extraction for C:\AdventNet\ME\ServiceDesk\mysql.zip to C:\AdventNet\ME\S
erviceDesk\mysql
=======================================================
Mar 3, 2007 2:10:06 PM com.adventnet.servicedesk.updatemgr.util.SDPreProcessor <
init>
SEVERE: Inside SDPreProcessor.