[DERBY-5662] nstest causes ERROR X0X03: Invalid transaction state - held cursor requires same isolation level

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.9.1.0
• Component/s: Test
• Labels: derby_triage10_9
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Kristian Waagan
• Created: 16/Mar/12 10:22
• Updated: 19/Mar/12 18:33

Description

When running the nstest the test logs and, depending on the settings, derby.log contains many instances of this error:
ERROR X0X03: Invalid transaction state - held cursor requires same isolation level

Stack:
ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:268)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.setIsolationLevel(GenericLanguageConnectionContext.java:2906)
at org.apache.derby.impl.jdbc.EmbedConnection.setTransactionIsolation(EmbedConnection.java:2199)
at org.apache.derbyTesting.system.nstest.utils.DbUtil.update_one_row(DbUtil.java:374)
at org.apache.derbyTesting.system.nstest.tester.TesterObject.doIUDOperation(TesterObject.java:162)
at org.apache.derbyTesting.system.nstest.tester.Tester1.startTesting(Tester1.java:113)
at org.apache.derbyTesting.system.nstest.NsTest.run(NsTest.java:551)

I've also seen the same stack with Tester2.

To reduce verbosity in the logs, it would be good to avoid triggering this error.