[DERBY-2804] predicatesIntoViews.sql fails (intermittently?) with SAVEPOINT error w/ IBM 15 on Linux.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.2.1, 10.4.1.3
• Component/s: Test
• Environment: IBM 1.5, Windows 2000 Professional.
• Bug behavior facts: Regression Test Failure
• Assignee: Unassigned
• Reporter: A B
• Created: 11/Jun/07 20:55
• Updated: 29/Jun/09 22:57
• Resolved: 06/Feb/08 16:46

Description

Saw this failure while running derbyall on a Windows machine with ibm15. It appears to be intermittent. Note that this could potentially be related to DERBY-2773, as that issue shows the same error and is also intermittent...

Stack trace is as follows (unfortunately, no line number because this was with insane jars):

Failed Statement is: --echo == Create Scheme Types ClassificationScheme ====================================;

insert into xr.repositoryobjectversion (
id,
resourceid,
name,
versionName,
folderid,
uri,
versionuri,
description,
ownerid,
creatorid,
versiondate,
changedate,
previousversion
) values (
'0a6a053e-1837-48dc-b7c4-11082c8c3b35',
'1a07217d-3a90-4266-bc7e-1e493ea22b8f',
'Classification Scheme Types', '1.0',
'225924f8-1a72-42c9-a58d-05b41d8415ce',
'Classification+Scheme+Types',
'1.0/Classification+Scheme+Types/1.0',
'Valid values for the ClassificationSchemeType property of a Classification Scheme',
'26747154-0dfc-46af-a85d-1dc30c230c4e',
'26747154-0dfc-46af-a85d-1dc30c230c4e',
CURRENT TIMESTAMP, CURRENT TIMESTAMP,
null
)
ERROR 3B501: A SAVEPOINT with the passed name already exists in the current transaction.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.store.raw.xact.Xact.setSavePoint(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.setSavePoint(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericStatementContext.setSavePoint(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.RowTriggerExecutor.fireTrigger(Unknown Source)
at org.apache.derby.impl.sql.execute.TriggerEventActivator.notifyEvent(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.fireAfterTriggers(Unknown Source)
at org.apache.derby.impl.sql.execute.UpdateResultSet.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.RowTriggerExecutor.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.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.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)
Cleanup action completed

Issue Links

• is related to: DERBY-2773 testGrantRevokeDDL(org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeDDLTest) throws java.sql.SQLException: The exception 'java.sql.SQLException: A SAVEPOINT with the passed name already exists in the current transaction.'
• relates to: DERBY-3093 Intermittent transaction failure caused by internal duplicate savepoint name for triggers