[
https://issues.apache.org/jira/browse/DERBY-6839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280286#comment-15280286
]
Marin Damyanov commented on DERBY-6839:
---------------------------------------
I attached 2 files. The first one contains the derby.log file and the second
one the content of table SYSSTATEMENTS.
I noticed that if I call the procedure
SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS or this procedure in combination
with this one SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE the upgrade to 10.12.1.1
is successful! As far as I've seen after I execute them the VALID flag is set
to false.
Can you let me know if this information is enough?
Is there any workaroud to this issue without executing these procedures?
I really appreciate your help and the fast reaction. We want to upgrade to
version 10.12.1.1 as soon as possible and without your help this would not be
possible.
Thak you in forward!
> 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
> Attachments: SYSSTATEMENTS.html, derby.log
>
>
> 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)
