You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Marin Damyanov (JIRA)" <ji...@apache.org> on 2016/05/11 10:27:13 UTC

[jira] [Comment Edited] (DERBY-6839) InvalidClassException when upgrading db from 10.10.1.1 to 10.11.1.1 or 10.12.1.1

    [ https://issues.apache.org/jira/browse/DERBY-6839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279897#comment-15279897 ] 

Marin Damyanov edited comment on DERBY-6839 at 5/11/16 10:27 AM:
-----------------------------------------------------------------

We experienced the same problem while upgrading from  10.10.2.0 to 10.12.1.1.
It seems not to be fixed at least for this scenario.
Should we wait for a fix?

Here is the stacktrace:

java.sql.SQLException: Exception during restore of a serializable or SQLData object of class 
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
	at org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Caused by: ERROR XSDA8: Exception during restore of a serializable or SQLData object of class 
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(Unknown Source)
	at org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(Unknown Source)
	at org.apache.derby.impl.store.raw.data.CachedPage.fetchFromSlot(Unknown Source)
	at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.fetch(Unknown Source)
	at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown Source)
	at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropJDBCMetadataSPSes(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSPSes(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DD_Version.doFullUpgrade(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTables(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
	at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
	at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source)
	at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
	at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source)
	... 16 more
Caused by: java.io.InvalidClassException: org.apache.derby.iapi.sql.execute.ExecRowBuilder; local class incompatible: stream classdesc serialVersionUID = -1078823466492523202, local class serialVersionUID = 9151849461018459842
	at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:621)
	at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1623)
	at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1518)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1774)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)
	at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)
	at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
	at org.apache.derby.iapi.services.io.ArrayUtil.readArrayItems(Unknown Source)
	at org.apache.derby.impl.sql.GenericStorablePreparedStatement.readExternal(Unknown Source)
	at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
	at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source)
	... 51 more


was (Author: marindamyanov):
We experienced the same problem while upgrading from  10.10.1.1 to 10.12.1.1.
It seems not to be fixed at least for this scenario.
Should we wait for a fix?

Here is the stacktrace:

java.sql.SQLException: Exception during restore of a serializable or SQLData object of class 
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
	at org.apache.derby.impl.drda.Database.makeConnection(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.getConnFromDatabaseName(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.verifyUserIdPassword(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.parseSECCHK(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.parseDRDAConnection(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
	at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
Caused by: ERROR XSDA8: Exception during restore of a serializable or SQLData object of class 
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(Unknown Source)
	at org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(Unknown Source)
	at org.apache.derby.impl.store.raw.data.CachedPage.fetchFromSlot(Unknown Source)
	at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.fetch(Unknown Source)
	at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown Source)
	at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropJDBCMetadataSPSes(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSPSes(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DD_Version.doFullUpgrade(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTables(Unknown Source)
	at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
	at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
	at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source)
	at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
	at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
	at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
	at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source)
	... 16 more
Caused by: java.io.InvalidClassException: org.apache.derby.iapi.sql.execute.ExecRowBuilder; local class incompatible: stream classdesc serialVersionUID = -1078823466492523202, local class serialVersionUID = 9151849461018459842
	at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:621)
	at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1623)
	at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1518)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1774)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)
	at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)
	at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
	at org.apache.derby.iapi.services.io.ArrayUtil.readArrayItems(Unknown Source)
	at org.apache.derby.impl.sql.GenericStorablePreparedStatement.readExternal(Unknown Source)
	at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
	at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source)
	... 51 more

> InvalidClassException when upgrading db from 10.10.1.1 to 10.11.1.1 or 10.12.1.1
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-6839
>                 URL: https://issues.apache.org/jira/browse/DERBY-6839
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.11.1.1, 10.12.1.1
>            Reporter: Eduardo Ribas
>
> When trying to upgrade a database created with version *10.10.1.1* directly to version *10.12.1.1* I get the following error:
> {code}
> Caused by: ERROR XJ040: Failed to start database '/Users/eduribas/database' with class loader sun.misc.Launcher$AppClassLoader@14dad5dc, see the next exception for details.
>     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>     at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
>     ... 43 more
> Caused by: ERROR XSDA8: Exception during restore of a serializable or SQLData object of class 
>     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>     at org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(Unknown Source)
>     at org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(Unknown Source)
>     at org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(Unknown Source)
>     at org.apache.derby.impl.store.raw.data.CachedPage.fetchFromSlot(Unknown Source)
>     at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.fetch(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropSPSDescriptor(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropJDBCMetadataSPSes(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.updateMetadataSPSes(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DD_Version.doFullUpgrade(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DD_Version.upgradeIfNeeded(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.loadDictionaryTables(Unknown Source)
>     at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.boot(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
>     at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
>     at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
>     at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
>     at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source)
>     at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
>     at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
>     at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
>     at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
>     at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
>     at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source)
>     ... 40 more
> Caused by: java.io.InvalidClassException: org.apache.derby.iapi.sql.execute.ExecRowBuilder; local class incompatible: stream classdesc serialVersionUID = -1078823466492523202, local class serialVersionUID = 9151849461018459842
>     at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:621)
>     at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1623)
>     at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1518)
>     at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1774)
>     at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1351)
>     at java.io.ObjectInputStream.readObject(ObjectInputStream.java:371)
>     at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
>     at org.apache.derby.iapi.services.io.ArrayUtil.readArrayItems(Unknown Source)
>     at org.apache.derby.impl.sql.GenericStorablePreparedStatement.readExternal(Unknown Source)
>     at org.apache.derby.iapi.services.io.FormatIdInputStream.readObject(Unknown Source)
>     at org.apache.derby.iapi.types.UserType.readExternal(Unknown Source)
>     ... 75 more
> {code}
> A similar error occurs when upgrading directly from *10.10.1.1* to *10.11.1.1*. But when I upgrade from *10.10.1.1* to *10.10.2.0* first, and then to *10.11.1.1* or *10.12.1.1*, no error occurs.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)