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 "Øystein Grøvlen (JIRA)" <ji...@apache.org> on 2007/07/12 15:01:08 UTC
[jira] Created: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
-------------------------------------------------------------------
Key: DERBY-2931
URL: https://issues.apache.org/jira/browse/DERBY-2931
Project: Derby
Issue Type: Bug
Affects Versions: 10.3.1.1
Environment: Soft upgrade
Reporter: Øystein Grøvlen
1. Created at database system/wombat with ij version 10.2
2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Øystein Grøvlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512366 ]
Øystein Grøvlen commented on DERBY-2931:
----------------------------------------
I applied Mike's patch, and the jdbcapi/ConcurrencyTest now runs without errors. Thanks, for fixing this in such a short time! (This fix also seems to have got rid of the serialization errors I saw in the BlobClob4BlobTest).
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512273 ]
Knut Anders Hatlen commented on DERBY-2931:
-------------------------------------------
Thanks for writing the test case, Kathey. It looks good, but I was wondering whether it would be better to put it in BasicSetup rather than in Changes10_3. When it is in Changes10_3, it is only tested for upgrades from Derby<10.3, so if something similar sneaks in in future releases, we might miss it.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Øystein Grøvlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512099 ]
Øystein Grøvlen commented on DERBY-2931:
----------------------------------------
If I boot the database in ij after running the ConcurrencyTest and try to drop the table, I get:
ij version 10.3
ij> connect 'jdbc:derby:system/wombat';
ij> drop table t1;
ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored
java.sql.SQLException: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
at org.apache.derby.tools.ij.main(Unknown Source)
Caused by: java.sql.SQLException: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 18 more
Caused by: java.sql.SQLException: Java exception: ': java.io.EOFException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
... 15 more
Caused by: java.io.EOFException
at org.apache.derby.iapi.services.io.ArrayInputStream.readUnsignedByte(Unknown Source)
at org.apache.derby.iapi.services.io.CompressedNumber.readInt(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.ConglomerateUtil.readCollationIdArray(Unknown Source)
at org.apache.derby.impl.store.access.heap.Heap.localReadExternal(Unknown Source)
at org.apache.derby.impl.store.access.heap.Heap.readExternalFromArray(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.access.heap.HeapConglomerateFactory.readConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
at org.apache.derby.impl.sql.execute.DDLConstantAction.lockTableForDDL(Unknown Source)
at org.apache.derby.impl.sql.execute.DropTableConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 11 more
ERROR XJ001: Java exception: ': java.io.EOFException'.
java.sql.SQLException: Java exception: ': java.io.EOFException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
at org.apache.derby.tools.ij.main(Unknown Source)
Caused by: java.sql.SQLException: Java exception: ': java.io.EOFException'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 19 more
Caused by: java.io.EOFException
at org.apache.derby.iapi.services.io.ArrayInputStream.readUnsignedByte(Unknown Source)
at org.apache.derby.iapi.services.io.CompressedNumber.readInt(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.ConglomerateUtil.readCollationIdArray(Unknown Source)
at org.apache.derby.impl.store.access.heap.Heap.localReadExternal(Unknown Source)
at org.apache.derby.impl.store.access.heap.Heap.readExternalFromArray(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.access.heap.HeapConglomerateFactory.readConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)
at org.apache.derby.impl.sql.execute.DDLConstantAction.lockTableForDDL(Unknown Source)
at org.apache.derby.impl.sql.execute.DropTableConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 11 more
ij>
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2931:
--------------------------------------
Fix Version/s: (was: 11.0.0.0)
10.4.0.0
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Fix For: 10.3.1.2, 10.4.0.0
>
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren resolved DERBY-2931.
---------------------------------------
Resolution: Fixed
Fix Version/s: 11.0.0.0
10.3.1.3
marking fixed
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Fix For: 10.3.1.3, 11.0.0.0
>
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512123 ]
Knut Anders Hatlen commented on DERBY-2931:
-------------------------------------------
I see the same error when soft upgrading from 10.1.3.1 to 10.3.1.1, but not from 10.1.3.1 to 10.2.2.0.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-2931:
--------------------------------------
Priority: Blocker (was: Major)
Increasing priority to 'Blocker' since this seems like a serious error that users are likely to hit, and it might potentially corrupt existing databases.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Priority: Blocker
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali reassigned DERBY-2931:
-------------------------------------
Assignee: Mike Matrigali
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2931:
----------------------------------
I've checked in fixes and updates to the upgrade test for both trunk and branch. I not going to mark it fixed until Oystein has a chance to check it out in his test. The changes to the upgrade test definitely showed the bug and were fixed by the checkin. I included Kathy's test case in the upgrade changes as well as a slightly different test I had written.
I think the comments about putting the test in the basic class rather than 10.3 also apply to my test case but I won't have a chance to get to that for a bit.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2931:
----------------------------------
I'm looking at it now. The stack indicates readExternal is looking for collation information, but in a soft upgraded table there should not be any.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512121 ]
Knut Anders Hatlen commented on DERBY-2931:
-------------------------------------------
I found that the bug can be reproduced with these three steps:
1. Create a database with 10.2:
ij version 10.2
ij> connect 'jdbc:derby:db;create=true';
ij> exit;
2. Connect to the same database with 10.3 in soft upgrade mode and create a table, then exit ij:
ij version 10.3
ij> connect 'jdbc:derby:db';
ij> create table t (x int);
0 rows inserted/updated/deleted
ij> exit;
3. Connect with 10.3 again and try to fetch the contents of the table:
ij version 10.3
ij> connect 'jdbc:derby:db';
ij> select * from t;
ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted to read more data than was originally stored
ERROR XJ001: Java exception: ': java.io.EOFException'.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Øystein Grøvlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Øystein Grøvlen closed DERBY-2931.
----------------------------------
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.4
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Fix For: 10.3.1.4, 10.4.0.0
>
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-2931:
----------------------------------
Component/s: Store
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.3.1.4
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Fix For: 10.3.1.4, 10.4.1.3
>
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-2931:
----------------------------------
Attachment: DERBY-2931_test_case_diff.txt
This is a test case for this issue. I accidentally posted to the wrong issue.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2931:
--------------------------------------
Fix Version/s: (was: 10.3.1.3)
10.3.1.2
3rd time setting fixin.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Fix For: 10.3.1.2, 10.4.0.0
>
> Attachments: DERBY-2931_test_case_diff.txt, derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2931) jdbcapi/ConcurrencyTest not able to
drop table in soft upgrade mode
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-2931:
----------------------------------
Attachment: derby2931.diff
derby2931.diff is proposed fix for derby2931 for the trunk. Mostly comment changes and fixes the format id version used for accessing old format Heap's,
it was incorrectly using the new one. To reproduce you need to create pre-10.3 base table, and then in 10.3 somehow access that table not from cache.
Easiest is to shut down and startup again in a soft upgrade db, but bug would also happen if you managed to access enough tables to age out the created table from the container cache.
So far I have run upgrade tests against fix applied to 10.3 branch and hand tested the change against the repro case that Knut describes in this JIRA entry.
> jdbcapi/ConcurrencyTest not able to drop table in soft upgrade mode
> -------------------------------------------------------------------
>
> Key: DERBY-2931
> URL: https://issues.apache.org/jira/browse/DERBY-2931
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.3.1.1
> Environment: Soft upgrade
> Reporter: Øystein Grøvlen
> Assignee: Mike Matrigali
> Priority: Blocker
> Attachments: derby2931.diff
>
>
> 1. Created at database system/wombat with ij version 10.2
> 2. Ran jdbcapi/ConcurrencyTest with same current directory. All test cases but the first test fail with:
> 30) testTruncateDuringScan(org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest)junit.framework.ComparisonFailure: 'drop table t1' failed with unexpected SQL State expected:<[42Y55]> but was:<[XSDA7]>
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:70)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.SURDataModelSetup.createDataModel(SURDataModelSetup.java:125)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest.setUp(ConcurrencyTest.java:54)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.