[
https://issues.apache.org/jira/browse/DERBY-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550981
]
James Alan Shepherd commented on DERBY-3221:
--------------------------------------------
Well, of course, I switch back to 10.3.1.4 today, and no bug!!! So as I
thought, test case; not so much.
BUT, with the wonder that is the Eclipse local history, and the mystery that is
svn, once again the error arises.
I can't publish the full log (956k) as it contains a year's work that hasn't
been paid for yet :-( I realise that this might not go back far enough, it's
the best I can do, apologies. Still, at least anyone that comes across such
things will know that they aren't delusional.
I did try 'sync && sync' before firing up the java code, but it made no
difference. The filesystem all this is happening on has recently changed to
being a linux software raid, but other than that everything else is pretty
vanilla ext3 with nothing else accessing the dir.
derby.properties now reads:
------8<-----------
derby.stream.error.logSeverityLevel=0
derby.language.logStatementText=true
derby.infolog.append=true
------8<-----------
So, we are in a stored proc fired by a trigger. (names may have been changed to
pretext the innocent)
2007-12-12 13:22:40.326 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DRDAID = null), Executing prepared statement:
INSERT INTO SubTTTXX ( nShapeID , nSubShapeID , nColorID , nHelp ) SELECT
DISTINCT X.nColorID
, DSO.nSubShapeID , X.nColorID , (SELECT INTEGER(MAX(nHelp)+1) FROM SubTTTXX)
FROM SubTTTXX X JOIN DirectSubTTT DSO ON X.nHelp > 0 AND DSO.nShapeID =
X.nSubShapeID LEFT JOIN SubTTT SO ON SO.nShapeID = X.nShapeID AND
SO.nSubShapeID = DSO.nSu
bShapeID WHERE X.nShapeID <> DSO.nSubShapeID AND SO.nShapeID IS NULL :End
prepared statement
2007-12-12 13:22:40.330 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DRDAID = null), Cleanup action starting
2007-12-12 13:22:40.330 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DRDAID = null), Failed Statement is: INSERT INTO
SubTTTXX ( nShapeID , nSubShapeID , nColorID , nHelp ) SELECT DISTINCT
X.nShapeID , DSO
.nSubShapeID , X.nColorID , (SELECT INTEGER(MAX(nHelp)+1) FROM SubTTTXX) FROM
SubTTTXX X JOIN DirectSubTTT DSO ON X.nHelp > 0 AND DSO.nShapeID =
X.nSubShapeID LEFT JOIN SubTTT SO ON SO.nShapeID = X.nShapeID AND
SO.nSubShapeID = DSO.nSubShapeID WHE
RE X.nShapeID <> DSO.nSubShapeID AND SO.nShapeID IS NULL
ERROR XSAI2: The conglomerate (-15) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:79)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:43)
at com.xxx.zzz.kkk.sp.Template.getResult(Template.java:80)
at com.xxx.zzz.kkk.sp.SubTTT.insert(SubTTT.java:107)
at
org.apache.derby.exe.ac12564092x0116xce84xf62dx000055b50d0421.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at
org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown
Source)
at
org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801)
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218)
at
com.xxx.yyy.DbOOOFactory$DBOOO.importFromLegacyTables(DbOOOFactory.java:383)
at com.xxx.yyy.DbOOOFactory$DBOOO.access$1500(DbOOOFactory.java:94)
at
com.xxx.yyy.DbOOOFactory$DBOOO$2.doInTransactionWithoutResult(DbOOOFactory.java:352)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
at com.xxx.yyy.DbOOOFactory$DBOOO.add(DbOOOFactory.java:339)
at com.xxx.zzz.kkk.MetaJJJ.reload(MetaJJJ.java:44)
at com.xxx.zzz.kkk.MetaJJJ.startup(MetaJJJ.java:57)
at com.xxx.zzz.kkk.Start.startupZzz(Start.java:208)
at com.xxx.zzz.kkk.Start.startup(Start.java:160)
at com.xxx.start.Starter.startup(Starter.java:264)
at com.xxx.start.Main.startup(Main.java:270)
at com.xxx.start.Main.main(Main.java:199)
Cleanup action completed
2007-12-12 13:22:40.490 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DRDAID = null), Cleanup action starting
2007-12-12 13:22:40.490 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DRDAID = null), Failed Statement is: INSERT
INTO SubTTT ( nShapeID , nSubShapeID , nColorID ) SELECT DISTINCT C.nRCID ,
S.nRCID , (S
ELECT nColorID FROM Colorition WHERE nIsCCC = 1) FROM LegacySubCCC SC JOIN
LegacyCCC C ON SC.nRunID = ? AND C.nRunID = ? AND C.nICCCID = SC.nICCCID JOIN
LegacyCCC S ON S.nRunID = ? AND S.nICCCID = SC.nISubCCCID LEF
T JOIN SubTTT SO ON SO.nShapeID = C.nRCID AND SO.nSubShapeID = S.nRCID WHERE
SO.nShapeID IS NULL with 3 parameters begin parameter #1: 1 :end parameter
begin parameter #2: 1 :end parameter begin parameter #3: 1 :end parameter
ERROR 38000: The exception 'java.sql.SQLException: The conglomerate (-15)
requested does not exist.' was thrown while evaluating an expression.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.iapi.error.StandardException.unexpectedUserException(Unknown
Source)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at
org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown
Source)
at
org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801)
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218)
at
com.xxx.yyy.DbOOOFactory$DBOOO.importFromLegacyTables(DbOOOFactory.java:383)
at com.xxx.yyy.DbOOOFactory$DBOOO.access$1500(DbOOOFactory.java:94)
at
com.xxx.yyy.DbOOOFactory$DBOOO$2.doInTransactionWithoutResult(DbOOOFactory.java:352)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
at com.xxx.yyy.DbOOOFactory$DBOOO.add(DbOOOFactory.java:339)
at com.xxx.zzz.kkk.MetaJJJ.reload(MetaJJJ.java:44)
at com.xxx.zzz.kkk.MetaJJJ.startup(MetaJJJ.java:57)
at com.xxx.zzz.kkk.Start.startupZzz(Start.java:208)
at com.xxx.zzz.kkk.Start.startup(Start.java:160)
at com.xxx.start.Starter.startup(Starter.java:264)
at com.xxx.start.Main.startup(Main.java:270)
at com.xxx.start.Main.main(Main.java:199)
Caused by: java.sql.SQLException: The conglomerate (-15) requested does not
exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(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.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:79)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:43)
at com.xxx.zzz.kkk.sp.Template.getResult(Template.java:80)
at com.xxx.zzz.kkk.sp.SubTTT.insert(SubTTT.java:107)
at
org.apache.derby.exe.ac12564092x0116xce84xf62dx000055b50d0421.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
... 32 more
Caused by: java.sql.SQLException: The conglomerate (-15) requested does not
exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 50 more
Caused by: ERROR XSAI2: The conglomerate (-15) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 44 more
============= begin nested exception, level (1) ===========
java.sql.SQLException: The conglomerate (-15) requested does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(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.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:79)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:43)
at com.xxx.zzz.kkk.sp.Template.getResult(Template.java:80)
at com.xxx.zzz.kkk.sp.SubTTT.insert(SubTTT.java:107)
at
org.apache.derby.exe.ac12564092x0116xce84xf62dx000055b50d0421.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at
org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown
Source)
at
org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801)
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218)
at
com.xxx.yyy.DbOOOFactory$DBOOO.importFromLegacyTables(DbOOOFactory.java:383)
at com.xxx.yyy.DbOOOFactory$DBOOO.access$1500(DbOOOFactory.java:94)
at
com.xxx.yyy.DbOOOFactory$DBOOO$2.doInTransactionWithoutResult(DbOOOFactory.java:352)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
at com.xxx.yyy.DbOOOFactory$DBOOO.add(DbOOOFactory.java:339)
at com.xxx.zzz.kkk.MetaJJJ.reload(MetaJJJ.java:44)
at com.xxx.zzz.kkk.MetaJJJ.startup(MetaJJJ.java:57)
at com.xxx.zzz.kkk.Start.startupZzz(Start.java:208)
at com.xxx.zzz.kkk.Start.startup(Start.java:160)
at com.xxx.start.Starter.startup(Starter.java:264)
at com.xxx.start.Main.startup(Main.java:270)
at com.xxx.start.Main.main(Main.java:199)
Caused by: java.sql.SQLException: The conglomerate (-15) requested does not
exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 50 more
Caused by: ERROR XSAI2: The conglomerate (-15) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 44 more
============= end nested exception, level (1) ===========
============= begin nested exception, level (2) ===========
java.sql.SQLException: The conglomerate (-15) requested does not exist.
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.generateCsSQLException(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.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:79)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:43)
at com.xxx.zzz.kkk.sp.Template.getResult(Template.java:80)
at com.xxx.zzz.kkk.sp.SubTTT.insert(SubTTT.java:107)
at
org.apache.derby.exe.ac12564092x0116xce84xf62dx000055b50d0421.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at
org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown
Source)
at
org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801)
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218)
at
com.xxx.yyy.DbOOOFactory$DBOOO.importFromLegacyTables(DbOOOFactory.java:383)
at com.xxx.yyy.DbOOOFactory$DBOOO.access$1500(DbOOOFactory.java:94)
at
com.xxx.yyy.DbOOOFactory$DBOOO$2.doInTransactionWithoutResult(DbOOOFactory.java:352)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
at com.xxx.yyy.DbOOOFactory$DBOOO.add(DbOOOFactory.java:339)
at com.xxx.zzz.kkk.MetaJJJ.reload(MetaJJJ.java:44)
at com.xxx.zzz.kkk.MetaJJJ.startup(MetaJJJ.java:57)
at com.xxx.zzz.kkk.Start.startupZzz(Start.java:208)
at com.xxx.zzz.kkk.Start.startup(Start.java:160)
at com.xxx.start.Starter.startup(Starter.java:264)
at com.xxx.start.Main.startup(Main.java:270)
at com.xxx.start.Main.main(Main.java:199)
Caused by: ERROR XSAI2: The conglomerate (-15) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 44 more
============= end nested exception, level (2) ===========
============= begin nested exception, level (3) ===========
ERROR XSAI2: The conglomerate (-15) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:79)
at com.xxx.zzz.kkk.sp.SubTTT$1.work(SubTTT.java:43)
at com.xxx.zzz.kkk.sp.Template.getResult(Template.java:80)
at com.xxx.zzz.kkk.sp.SubTTT.insert(SubTTT.java:107)
at
org.apache.derby.exe.ac12564092x0116xce84xf62dx000055b50d0421.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at
org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at
org.apache.derby.impl.sql.execute.GenericTriggerExecutor.executeSPS(Unknown
Source)
at
org.apache.derby.impl.sql.execute.StatementTriggerExecutor.fireTrigger(Unknown
Source)
at
org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown
Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:745)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:739)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:797)
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:801)
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:218)
at
com.xxx.yyy.DbOOOFactory$DBOOO.importFromLegacyTables(DbOOOFactory.java:383)
at com.xxx.yyy.DbOOOFactory$DBOOO.access$1500(DbOOOFactory.java:94)
at
com.xxx.yyy.DbOOOFactory$DBOOO$2.doInTransactionWithoutResult(DbOOOFactory.java:352)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
at com.xxx.yyy.DbOOOFactory$DBOOO.add(DbOOOFactory.java:339)
at com.xxx.zzz.kkk.MetaJJJ.reload(MetaJJJ.java:44)
at com.xxx.zzz.kkk.MetaJJJ.startup(MetaJJJ.java:57)
at com.xxx.zzz.kkk.Start.startupZzz(Start.java:208)
at com.xxx.zzz.kkk.Start.startup(Start.java:160)
at com.xxx.start.Starter.startup(Starter.java:264)
at com.xxx.start.Main.startup(Main.java:270)
at com.xxx.start.Main.main(Main.java:199)
============= end nested exception, level (3) ===========
Cleanup action completed
2007-12-12 13:22:40.524 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DATABASE = directory:shape), (DRDAID = null),
Rolling back
2007-12-12 13:22:40.885 GMT Thread[Main,5,main] (XID = 1452), (SESSIONID = 2),
(DATABASE = directory:shape), (DRDAID = null), Committing
2007-12-12 13:22:40.893 GMT Thread[xxx-start ShutdownHook,5,main] (XID = 1452),
(SESSIONID = 2), (DATABASE = directory:shape), (DATABASE = directory:shape),
(DRDAID = null), Rolling back
2007-12-12 13:22:43.104 GMT:
Shutting down instance c013800d-0116-ce84-f62d-000055b50d04
----
(note2self: I have a patch against r192 that reproduces this, and a full copy
of the derby.log)
> "java.sql.SQLException: The conglomerate (-5) requested does not exist." from
> Derby 10.3.1.4 embedded within Eclipse 3.3 and RAD 7.0
> ------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3221
> URL: https://issues.apache.org/jira/browse/DERBY-3221
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.3.1.4
> Environment: Windows Vista Ubuntu Linux on IBM's VM (RAD 7.0)
> Reporter: Tim Halloran
>
> We are getting an SQLException when several prepared statement deletes are
> done upon an existing database. As far as we can tell this exception should
> never occur unless (evil) things like deleting the database or editing files
> occurs. This is using the embedded driver within a plug-in inside RAD 7.0
> (and Eclipse 3.3).
> I'm not sure what else to submit that might be helpful.
> java.sql.SQLException: The conglomerate (-5) requested does not exist.
> 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.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.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> com.surelogic.sierra.jdbc.LazyPreparedStatementConnection$LazyPreparedStatement.invoke(Unknown
> Source)
> at $Proxy1.execute(Unknown Source)
> at com.surelogic.sierra.jdbc.finding.FindingManager.delete(Unknown Source)
> at
> com.surelogic.sierra.jdbc.finding.ClientFindingManager.updateLocalFindings(Unknown
> Source)
> at
> com.surelogic.sierra.jdbc.project.ClientProjectManager.synchronizeProject(Unknown
> Source)
> at
> com.surelogic.sierra.client.eclipse.jobs.SynchronizeJob.synchronize(Unknown
> Source)
> at com.surelogic.sierra.client.eclipse.jobs.SynchronizeJob.run(Unknown
> Source)
> at org.eclipse.core.internal.jobs.Worker.run(Unknown Source)
> Caused by: ERROR XSAI2: The conglomerate (-5) requested does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
> Source)
> at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
> at
> org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRowCore(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.TemporaryRowHolderResultSet.getNextRow(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.IndexChanger.finish(Unknown Source)
> at org.apache.derby.impl.sql.execute.IndexSetChanger.finish(Unknown Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.finish(Unknown Source)
> at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> ... 14 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
