search

sagarswathi / h2database

Automatically exported from code.google.com/p/h2database
0 stars 1 forks source link

JDBC exception when loading data in 1.3.166 #398

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Here's the stack from the trace file:

05-11 13:08:57 jdbc[12]: exception
org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from index "PU
BLIC.I_JSTEP_FINISH_TIME: ( /* key:3634778 */ 3634778, 0, 'Linux build', TIMESTA
MP '2012-03-11 00:50:04.428', 1331427004428, NULL, 'admin', TIMESTAMP '2012-03-1
1 03:37:55.377', 1331437075377, 'project: Accelerator', 'none', 'none', NULL, NU
LL, NULL, NULL, FALSE, NULL, FALSE, NULL, 'true', NULL, NULL, NULL, TRUE, NULL, 
NULL, NULL, 'failProcedure', 0, 0, TIMESTAMP '2012-03-11 02:14:30.873', 13314320
70873, 0, NULL, NULL, NULL, 0, 'Linux build.3634778.log', 'success', TRUE, 0, '5
.2 Accelerator-Master', 'veng2', 'procedure', 0, 0, NULL, 0, TIMESTAMP '2012-03-
11 00:50:54.985', 1331427054985, NULL, 0, TIMESTAMP '2012-03-11 00:51:10.654', 1
331427070654, 0, 'completed', 'Unix-5.1', 'Accelerator', 0, NULL, NULL, FALSE, N
ULL, NULL, 0, 6146077, 14494410, 6146078, NULL, NULL, NULL, NULL, NULL, 152482, 
3634772, NULL, NULL, NULL)"; SQL statement:
/* update com.electriccloud.commander.domain.JobStepImpl */ update ec_job_step s
et version=?, procedure_id=?, procedure_step_id=? where id=? and version=? [9011
2-166]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:225)
        at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
        at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
        at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:241)
        at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:170)
        at org.h2.table.RegularTable.removeRow(RegularTable.java:361)
        at org.h2.table.Table.updateRows(Table.java:430)
        at org.h2.command.dml.Update.update(Update.java:143)
        at org.h2.command.CommandContainer.update(CommandContainer.java:73)
        at org.h2.command.Command.executeUpdate(Command.java:226)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)

It goes on, but at application stack levels (hibernate, etc. up to my 
application).

I'll try to attach the gzipped trace file; it's 67MB.

Original issue reported on code.google.com by stamhan...@gmail.com on 11 May 2012 at 10:49

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
I turned off mvcc and tried again and it failed much faster (like in 15 minutes 
or so). I'm going to try to produce a new trace file that you can look at.

Original comment by stamhan...@gmail.com on 31 May 2012 at 9:01

GoogleCodeExporter commented 8 years ago 
Ugh. It failed, but the compressed trace file is about 64MB. This is with trace 
level 2. I couldn't get trace level 3 to work properly (in that I wanted it to 
roll over after 10GB, and it was rolling over after about 1.8GB... so I was 
losing log files when I didn't catch the roll-over in time).

I may have some sensitive data in this dump file (as I did in the last one), so 
I don't want to publish it for the world to see. I'll send Thomas a link and 
hopefully this time it'll get a little attention (I've gotten no response in 
the forums, e-mail, or this bug, and it's a little disheartening since I see 
other forum posts do get attention).

Original comment by stamhan...@gmail.com on 31 May 2012 at 11:20

GoogleCodeExporter commented 8 years ago 
I'm sorry, but I'm not able to analyze this problem.

I would need a much simpler test case.

Original comment by thomas.t...@gmail.com on 4 Jun 2012 at 5:25

GoogleCodeExporter commented 8 years ago 
Argh... I've only seen this problem happen with two different data sets (both 
of which were pretty large). Based on the error messages, and the fact that 
this is not mvcc related, would it be possible for you to add extra logging in 
parts of the code? I'd be very willing to try out h2.jar's to give you more 
information. Thanks for taking a look at this.

Original comment by stamhan...@gmail.com on 4 Jun 2012 at 10:22