Sorry, I mentioned the incorrect version number, I am using *1.3.168*. Earlier we also tried without MVCC but that didn't help.
Just for your information that the index which is creating the problem is on a timestamp column if that can give you some clue about the problem. We are very close to go into production and upgrading H2 does not look a preferred option. Also I read through the change log from 1.3.168 to 1.3.171 and did not see any mention for this defect being fixed so I am not quite sure if upgrading would help. I will try providing more information on this as and when I hit it again. On Monday, 13 May 2013 18:37:16 UTC+5:30, Noel Grandin wrote: > > > You're also running quite an old version of H2, updating to the latest > version would probably help. > > I would also suggest running without MVCC, it's still a little rough > around the edges. > > On 2013-05-13 14:47, Sanjeev Gour wrote: > > I am getting the following error when running a clean up routine on some > of the tables. I am using version 1.3.162. The JDBC url is configured with > the following options- > > CACHE_TYPE=LRU;PAGE_SIZE=16384;MVCC=TRUE;DB_CLOSE_DELAY=-1 > > Also tried with ";optimize_update=false" to no avail. This typically > happens when my applications runs for long hours so I don't really have an > easy test case to reproduce this problem. Is there anything else to try out > on this one? > > *org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from > index "TIMESERIES.IDX_METRIC_DATA_START_TIME*: ( /* key:18158 */ 43848, > TIMESTAMP '2013-03-27 18:30:00.0', TIMESTAMP '2013-03-27 23:10:00.0', > X'aced000573720020636f6d2e63612e63686f7275732e74696d657365726965732e54534172726179018c63d06105fca80200054a0007656e6454696d654900066c656e6774684a0009737461727454696d654c000c636c6f636b4d656d656e746f74002a4c636f6d2f63612f63686f7275732f74696d657365726965732f6e756d657269632f4d656d656e746f3b4c000b646174614d656d656e746f71007e000178700000013dae1d7940000000390000013dad1d20407372003a636f6d2e63612e63686f7275732e74696d657365726965732e6e756d657269632e4e756d62657244656c74614f7574707574244d656d656e746f7390f51c1bf5d3fc0200014c00076d656d656e746f71007e0001787073720038636f6d2e63612e63686f7275732e74696d657365726965732e6e756d657269632e4e756d626572524c454f7574707574244d656d656e746ff49d0987111300c102000549000a63757272656e74496e744a000b63757272656e744c6f6e674900066c656e67746849000473697a654c00076d656d656e746f71007e000178700000000000000000000493e000000038000000437372003c636f6d2e63612e63686f7275732e74696d657365726965732e6e756d657269632e4e756d6265725061636b696e674f7574707574244d656d656e746f40a3b5b30 > > dd1f4770c00007870770400000003737200106a6176612e7574696c2e4269745365746efd887e3934ab210200015b0004626974737400025b4a7870757200025b4a782004b512b1759302000078700000000413c39ed68e90205300000000000124f800000000000000000000000000000000787371007e00077704000000007371007e00097571007e000c000000080202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202000000000000000278')"; > > SQL statement: > > DELETE FROM timeseries.metric_data WHERE end_time < ? LIMIT 1000 > [90112-168] > > 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.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.command.dml.Delete.update(Delete.java:93) > > at > org.h2.command.CommandContainer.update(CommandContainer.java:75) > > at org.h2.command.Command.executeUpdate(Command.java:230) > > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156) > > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142) > > at > org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) > > at com.ca.chorus.db.DbExecutor$9.call(DbExecutor.java:829) > > ... 21 more > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
