[jira] Commented: (DERBY-4585) IndexChanger.doDelete throws NullPointerException
[
https://issues.apache.org/jira/browse/DERBY-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12851009#action_12851009
]
Knut Anders Hatlen commented on DERBY-4585:
---
The repro started failing when DERBY-3301 was fixed.
> IndexChanger.doDelete throws NullPointerException
> -
>
> Key: DERBY-4585
> URL: https://issues.apache.org/jira/browse/DERBY-4585
> Project: Derby
> Issue Type: Bug
> Components: SQL
>Affects Versions: 10.5.3.0
> Environment: Various operating systems, Java 1.6.0_18
>Reporter: Martin Keller
> Fix For: 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0,
> 10.5.3.0, 10.6.0.0
>
> Attachments: derby-4585.tar.gz, repro.zip
>
>
> After a bunch of DELETE and DROP-Commands, the following error occurs in our
> application:
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Cleanup action starting
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Failed Statement is: DELETE FROM
> LCAPPCHILDCONTROLTITLE WHERE STRCHILDCONTROLGUID IN (SELECT STRGUID FROM
> LCAPPCHILDCONTROL WHERE STRAPPCONTROLDRGUID IN (SELECT A.STRGUID FROM
> LCAPPCONTROLDR A, LCAPPFUP B WHERE A.STRAPPFUPGUID = B.STRGUID AND
> B.STRAPPGUID = '93A720B90BB6C25703701E67D0DA75220B7D2FFC'))
> java.lang.NullPointerException
> at
> org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java:369)
> at
> org.apache.derby.impl.sql.execute.IndexChanger.delete(IndexChanger.java:544)
> at
> org.apache.derby.impl.sql.execute.IndexSetChanger.delete(IndexSetChanger.java:250)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.deleteRow(RowChangerImpl.java:476)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(DeleteResultSet.java:405)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:137)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:625)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:175)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThread.java:5022)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:750)
> at
> org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
> Cleanup action completed
> The database seems to be corrupt, after this exception has been thrown.
> As you can see, I already compiled Derby to get the line number where the
> error occurs. I must apologize for not having a sufficient test case yet, but
> the code leading to this issue is very complex. If one wants to reproduce
> this bug, I can send a download link for our product and instructions to
> reproduce the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4585) IndexChanger.doDelete throws NullPointerException
[
https://issues.apache.org/jira/browse/DERBY-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12850107#action_12850107
]
Knut Anders Hatlen commented on DERBY-4585:
---
I also see the NullPointerException when I try to run the DELETE statement with
head of trunk. I ran the database consistency checker
(http://wiki.apache.org/db-derby/DatabaseConsistencyCheck) but that didn't
reveal any structural problems in the database.
> IndexChanger.doDelete throws NullPointerException
> -
>
> Key: DERBY-4585
> URL: https://issues.apache.org/jira/browse/DERBY-4585
> Project: Derby
> Issue Type: Bug
>Affects Versions: 10.5.3.0
> Environment: Various operating systems, Java 1.6.0_18
>Reporter: Martin Keller
> Attachments: derby-4585.tar.gz
>
>
> After a bunch of DELETE and DROP-Commands, the following error occurs in our
> application:
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Cleanup action starting
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Failed Statement is: DELETE FROM
> LCAPPCHILDCONTROLTITLE WHERE STRCHILDCONTROLGUID IN (SELECT STRGUID FROM
> LCAPPCHILDCONTROL WHERE STRAPPCONTROLDRGUID IN (SELECT A.STRGUID FROM
> LCAPPCONTROLDR A, LCAPPFUP B WHERE A.STRAPPFUPGUID = B.STRGUID AND
> B.STRAPPGUID = '93A720B90BB6C25703701E67D0DA75220B7D2FFC'))
> java.lang.NullPointerException
> at
> org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java:369)
> at
> org.apache.derby.impl.sql.execute.IndexChanger.delete(IndexChanger.java:544)
> at
> org.apache.derby.impl.sql.execute.IndexSetChanger.delete(IndexSetChanger.java:250)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.deleteRow(RowChangerImpl.java:476)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(DeleteResultSet.java:405)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:137)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:625)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:175)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThread.java:5022)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:750)
> at
> org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
> Cleanup action completed
> The database seems to be corrupt, after this exception has been thrown.
> As you can see, I already compiled Derby to get the line number where the
> error occurs. I must apologize for not having a sufficient test case yet, but
> the code leading to this issue is very complex. If one wants to reproduce
> this bug, I can send a download link for our product and instructions to
> reproduce the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4585) IndexChanger.doDelete throws NullPointerException
[
https://issues.apache.org/jira/browse/DERBY-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12849272#action_12849272
]
Martin Keller commented on DERBY-4585:
--
Hi,
Rebooting the database doesn't change anything.
Corrupt means, that the statement above worked for several times until the
first exception and then never again.
I'll attach the "corrupt" database to the issue.
> IndexChanger.doDelete throws NullPointerException
> -
>
> Key: DERBY-4585
> URL: https://issues.apache.org/jira/browse/DERBY-4585
> Project: Derby
> Issue Type: Bug
>Affects Versions: 10.5.3.0
> Environment: Various operating systems, Java 1.6.0_18
>Reporter: Martin Keller
>
> After a bunch of DELETE and DROP-Commands, the following error occurs in our
> application:
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Cleanup action starting
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Failed Statement is: DELETE FROM
> LCAPPCHILDCONTROLTITLE WHERE STRCHILDCONTROLGUID IN (SELECT STRGUID FROM
> LCAPPCHILDCONTROL WHERE STRAPPCONTROLDRGUID IN (SELECT A.STRGUID FROM
> LCAPPCONTROLDR A, LCAPPFUP B WHERE A.STRAPPFUPGUID = B.STRGUID AND
> B.STRAPPGUID = '93A720B90BB6C25703701E67D0DA75220B7D2FFC'))
> java.lang.NullPointerException
> at
> org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java:369)
> at
> org.apache.derby.impl.sql.execute.IndexChanger.delete(IndexChanger.java:544)
> at
> org.apache.derby.impl.sql.execute.IndexSetChanger.delete(IndexSetChanger.java:250)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.deleteRow(RowChangerImpl.java:476)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(DeleteResultSet.java:405)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:137)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:625)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:175)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThread.java:5022)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:750)
> at
> org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
> Cleanup action completed
> The database seems to be corrupt, after this exception has been thrown.
> As you can see, I already compiled Derby to get the line number where the
> error occurs. I must apologize for not having a sufficient test case yet, but
> the code leading to this issue is very complex. If one wants to reproduce
> this bug, I can send a download link for our product and instructions to
> reproduce the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4585) IndexChanger.doDelete throws NullPointerException
[
https://issues.apache.org/jira/browse/DERBY-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12849239#action_12849239
]
Rick Hillegas commented on DERBY-4585:
--
Hi Martin,
Thanks for logging this issue. Can you answer Knut's last question: Do you
still see problems after rebooting the database? Thanks.
> IndexChanger.doDelete throws NullPointerException
> -
>
> Key: DERBY-4585
> URL: https://issues.apache.org/jira/browse/DERBY-4585
> Project: Derby
> Issue Type: Bug
>Affects Versions: 10.5.3.0
> Environment: Various operating systems, Java 1.6.0_18
>Reporter: Martin Keller
>
> After a bunch of DELETE and DROP-Commands, the following error occurs in our
> application:
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Cleanup action starting
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Failed Statement is: DELETE FROM
> LCAPPCHILDCONTROLTITLE WHERE STRCHILDCONTROLGUID IN (SELECT STRGUID FROM
> LCAPPCHILDCONTROL WHERE STRAPPCONTROLDRGUID IN (SELECT A.STRGUID FROM
> LCAPPCONTROLDR A, LCAPPFUP B WHERE A.STRAPPFUPGUID = B.STRGUID AND
> B.STRAPPGUID = '93A720B90BB6C25703701E67D0DA75220B7D2FFC'))
> java.lang.NullPointerException
> at
> org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java:369)
> at
> org.apache.derby.impl.sql.execute.IndexChanger.delete(IndexChanger.java:544)
> at
> org.apache.derby.impl.sql.execute.IndexSetChanger.delete(IndexSetChanger.java:250)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.deleteRow(RowChangerImpl.java:476)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(DeleteResultSet.java:405)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:137)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:625)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:175)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThread.java:5022)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:750)
> at
> org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
> Cleanup action completed
> The database seems to be corrupt, after this exception has been thrown.
> As you can see, I already compiled Derby to get the line number where the
> error occurs. I must apologize for not having a sufficient test case yet, but
> the code leading to this issue is very complex. If one wants to reproduce
> this bug, I can send a download link for our product and instructions to
> reproduce the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4585) IndexChanger.doDelete throws NullPointerException
[
https://issues.apache.org/jira/browse/DERBY-4585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12845927#action_12845927
]
Knut Anders Hatlen commented on DERBY-4585:
---
Hi Martin,
Could you please also post the DDL statements used to create the tables
involved in the query (including any tables with foreign key constraints
referencing LCAPPCHILDCONTROLTITLE)?
When you say that the database seems to be corrupt, which symptoms do you see?
Do you also see those problems after rebooting the database?
> IndexChanger.doDelete throws NullPointerException
> -
>
> Key: DERBY-4585
> URL: https://issues.apache.org/jira/browse/DERBY-4585
> Project: Derby
> Issue Type: Bug
>Affects Versions: 10.5.3.0
> Environment: Various operating systems, Java 1.6.0_18
>Reporter: Martin Keller
>
> After a bunch of DELETE and DROP-Commands, the following error occurs in our
> application:
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Cleanup action starting
> 2010-03-16 12:54:23.070 GMT Thread[DRDAConnThread_4,5,derby.daemons] (XID =
> 15898), (SESSIONID = 1), (DATABASE = ixintrexx), (DRDAID =
> NF01.PAA8-4469821361421447518{2}), Failed Statement is: DELETE FROM
> LCAPPCHILDCONTROLTITLE WHERE STRCHILDCONTROLGUID IN (SELECT STRGUID FROM
> LCAPPCHILDCONTROL WHERE STRAPPCONTROLDRGUID IN (SELECT A.STRGUID FROM
> LCAPPCONTROLDR A, LCAPPFUP B WHERE A.STRAPPFUPGUID = B.STRGUID AND
> B.STRAPPGUID = '93A720B90BB6C25703701E67D0DA75220B7D2FFC'))
> java.lang.NullPointerException
> at
> org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java:369)
> at
> org.apache.derby.impl.sql.execute.IndexChanger.delete(IndexChanger.java:544)
> at
> org.apache.derby.impl.sql.execute.IndexSetChanger.delete(IndexSetChanger.java:250)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.deleteRow(RowChangerImpl.java:476)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(DeleteResultSet.java:405)
> at
> org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:137)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:625)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:175)
> at
> org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLIMM(DRDAConnThread.java:5022)
> at
> org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:750)
> at
> org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
> Cleanup action completed
> The database seems to be corrupt, after this exception has been thrown.
> As you can see, I already compiled Derby to get the line number where the
> error occurs. I must apologize for not having a sufficient test case yet, but
> the code leading to this issue is very complex. If one wants to reproduce
> this bug, I can send a download link for our product and instructions to
> reproduce the problem.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
