[
https://issues.apache.org/jira/browse/DERBY-4181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Myrna van Lunteren updated DERBY-4181:
--------------------------------------
Attachment: serverlog.jar
run1serverlog.jar
Attaching 2 jarred up derby.log files.
run1server.jar contains the 10.5.rc2 server's derby.log file when run with sane
jars but no derby.properties.
It shows an assert which I think is similar to the warning I saw in my insane
jar runs:
org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED Index row
(9475777.6508320800,(590,44)) not found in conglomerateid 1185Current scan =
btree = BTREE: containerid = Container(0, 1185);nKeyFields =
2;nUniqueColumns = 2;allowDuplicates = false
[....]
serverlog.jar is from a run with 10.5.rc2 and sane jars and with
derby.properties in place (both in the dir for the server and for the client:
derby.language.logStatementText=true, derby.stream.error.logSeverityLevel=0,
derby.infolog.append=tru).
This one first shows a different but I think related index AssertFailure:
ERROR 38000: The exception
'org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED last row on
left page 233 > than first row on right page 110
left last row = col[0]=4988358813.6843080000col[1]=(155,20)col[2]=214right
first row = col[0]=16968984.2552292000col[1]=(180,14)col[2]=147
BRANCH(233)(lev=1): num recs = 80
left = 106;right = 110;parent = 1;isRoot = false;left child page = 227;
last > first of
BRANCH(110)(lev=1): num recs = 96
left = 233;right = 200;parent = 1;isRoot = false;left child page = 94;'
was thrown while evaluating an expression.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
at
org.apache.derby.iapi.error.StandardException.unexpectedUserException(StandardException.java:583)
at
org.apache.derby.impl.services.reflect.DirectCall.invoke(ReflectGeneratedClass.java:164)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(ProjectRestrictResultSet.java:497)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:291)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:460)
at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:427)
at
org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:371)
at
org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(DRDAConnThread.java:6866)
at
org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(DRDAConnThread.java:6762)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:859)
at
org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
Caused by: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED
last row on left page 233 > than first row on right page 110
left last row = col[0]=4988358813.6843080000col[1]=(155,20)col[2]=214right
first row = col[0]=16968984.2552292000col[1]=(180,14)col[2]=147
BRANCH(233)(lev=1): num recs = 80
left = 106;right = 110;parent = 1;isRoot = false;left child page = 227;
last > first of
BRANCH(110)(lev=1): num recs = 96
left = 233;right = 200;parent = 1;isRoot = false;left child page = 94;
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162)
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147)
at
org.apache.derby.impl.store.access.btree.ControlRow.compareRowsOnSiblings(ControlRow.java:1532)
at
org.apache.derby.impl.store.access.btree.ControlRow.checkSiblings(ControlRow.java:1642)
at
org.apache.derby.impl.store.access.btree.ControlRow.checkGeneric(ControlRow.java:1423)
at
org.apache.derby.impl.store.access.btree.BranchControlRow.checkConsistency(BranchControlRow.java:942)
at
org.apache.derby.impl.store.access.btree.BranchControlRow.checkChildren(BranchControlRow.java:1038)
at
org.apache.derby.impl.store.access.btree.BranchControlRow.checkConsistency(BranchControlRow.java:1013)
at
org.apache.derby.impl.store.access.btree.OpenBTree.checkConsistency(OpenBTree.java:283)
at
org.apache.derby.iapi.db.ConsistencyChecker.checkTable(ConsistencyChecker.java:204)
at
org.apache.derby.catalog.SystemProcedures.SYSCS_CHECK_TABLE(SystemProcedures.java:977)
at
org.apache.derby.exe.acb05c5046x0120xd4b9xebbdx00000454210e0.e3(Unknown Source)
at
org.apache.derby.impl.services.reflect.DirectCall.invoke(ReflectGeneratedClass.java:145)
... 9 more
============= begin nested exception, level (1) ===========
org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED last row on
left page 233 > than first row on right page 110
left last row = col[0]=4988358813.6843080000col[1]=(155,20)col[2]=214right
first row = col[0]=16968984.2552292000col[1]=(180,14)col[2]=147
BRANCH(233)(lev=1): num recs = 80
left = 106;right = 110;parent = 1;isRoot = false;left child page = 227;
last > first of
BRANCH(110)(lev=1): num recs = 96
left = 233;right = 200;parent = 1;isRoot = false;left child page = 94;
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162)
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147)
at
org.apache.derby.impl.store.access.btree.ControlRow.compareRowsOnSiblings(ControlRow.java:1532)
at
org.apache.derby.impl.store.access.btree.ControlRow.checkSiblings(ControlRow.java:1642)
at
org.apache.derby.impl.store.access.btree.ControlRow.checkGeneric(ControlRow.java:1423)
at
org.apache.derby.impl.store.access.btree.BranchControlRow.checkConsistency(BranchControlRow.java:942)
at
org.apache.derby.impl.store.access.btree.BranchControlRow.checkChildren(BranchControlRow.java:1038)
at
org.apache.derby.impl.store.access.btree.BranchControlRow.checkConsistency(BranchControlRow.java:1013)
at
org.apache.derby.impl.store.access.btree.OpenBTree.checkConsistency(OpenBTree.java:283)
at
org.apache.derby.iapi.db.ConsistencyChecker.checkTable(ConsistencyChecker.java:204)
at
org.apache.derby.catalog.SystemProcedures.SYSCS_CHECK_TABLE(SystemProcedures.java:977)
at
org.apache.derby.exe.acb05c5046x0120xd4b9xebbdx00000454210e0.e3(Unknown Source)
at
org.apache.derby.impl.services.reflect.DirectCall.invoke(ReflectGeneratedClass.java:145)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(ProjectRestrictResultSet.java:497)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:291)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:460)
at
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:427)
at
org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:371)
at
org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(DRDAConnThread.java:6866)
at
org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(DRDAConnThread.java:6762)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:859)
at
org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
(Skipping thread dump because of insufficient permissions:
java.security.AccessControlException: Access denied
(java.lang.RuntimePermission getStackTrace))
============= end nested exception, level (1) ===========
followed somewhat later by:
2009-04-23 20:05:05.986 GMT Thread[DRDAConnThread_11,5,main] (XID = 94271),
(SESSIONID = 23), (DATABASE = nstestdb), (DRDAID =
NF000001.PCA5-4470665814578243875{12}), Failed Statement is: delete from
nstesttab where serialkey = ? with 1 parameters begin parameter #1: 36022 :end
parameter
org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED Index row
(9475777.6508320800,(590,44)) not found in conglomerateid 1185Current scan =
btree = BTREE: containerid = Container(0, 1185);nKeyFields =
2;nUniqueColumns = 2;allowDuplicates = false
scan direction = forward
(scan_state:SCAN_DONE
rh:null
key:null)
init_rawtran = 94271
init_hold = false
init_forUpdate = true
init_useUpdateLocks = false
init_scanColumnList = null
init_scanColumnList.size() = 0
init_template = col[0]=9484797.0792001040col[1]=(359,27)
init_startKeyValue = col[0]=9475777.6508320800col[1]=(590,44)
init_startSearchOperator = GE
init_qualifier[] = null
init_stopKeyValue = col[0]=9475777.6508320800col[1]=(590,44)
init_stopSearchOperator = GT
stat_numpages_visited = 3
stat_numrows_visited = 1
stat_numrows_qualified = 0
stat_numdeleted_rows_visited = 0
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:162)
at
org.apache.derby.shared.common.sanity.SanityManager.THROWASSERT(SanityManager.java:147)
at
org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java:351)
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.deleteDeferredRows(DeleteResultSet.java:527)
at
org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:154)
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.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1303)
at
org.apache.derby.impl.drda.DRDAStatement.execute(DRDAStatement.java:672)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTTobjects(DRDAConnThread.java:4280)
at
org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(DRDAConnThread.java:4084)
at
org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:1003)
at
org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:290)
> SQLState.LANG_IGNORE_MISSING_INDEX_ROW_DURING_DELETE during NsTest run
> -----------------------------------------------------------------------
>
> Key: DERBY-4181
> URL: https://issues.apache.org/jira/browse/DERBY-4181
> Project: Derby
> Issue Type: Bug
> Environment: Suse Linux 10, IBM 1.6 SR4
> Reporter: Myrna van Lunteren
> Fix For: 10.5.1.0, 10.5.1.1
>
> Attachments: run1serverlog.jar, serverlog.jar
>
>
> During the NsTest runs for 10.5.1.0 and 10.5.1.1 I initially ignored warnings
> showing up in the server's derby.log file:
> WARNING: While deleting a row from a table the index row for base table row
> (594,12) was not found in index with conglomerate id 1,185. This problem has
> automatically been corrected as part of the delete operation.
> However, I don't think this is a completely healthy warning, I think it
> indicates there was corruption in the index.
> I'll investigate further.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
