db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4181) SQLState.LANG_IGNORE_MISSING_INDEX_ROW_DURING_DELETE during NsTest run
Date Thu, 23 Apr 2009 21:38:30 GMT

     [ 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.


Mime
View raw message