My URL: jdbc:h2:./vmiDCDB;MVCC=TRUE;LOCK_TIMEOUT=10000;
On Friday, January 30, 2015 at 7:35:52 AM UTC-8, Meni Hillel wrote: > > I've encountered same issue. > > Exception in thread "main" org.h2.jdbc.JdbcSQLException: General error: > "java.lang.RuntimeException: rowCount expected 17483 got 93586 T65.I140" > [50000-175] > > How do I recover out of this? > > On Friday, November 6, 2009 at 11:26:31 PM UTC-8, Thomas Mueller wrote: >> >> Hi, >> >> What is the database URL? What options do you use? Is this using the >> page store file format? >> >> Regards, >> Thomas >> >> >> >> On Wed, Nov 4, 2009 at 10:31 AM, Carl Sayres <[email protected]> wrote: >> > >> > I deleted a few thousand rows, then tried to insert one. Got the >> > following exception: >> > >> > 11-04 04:17:11 jdbc[2]: SQLException >> > org.h2.jdbc.JdbcSQLException: General error: >> > java.lang.RuntimeException: rowCount expected 30845 got 31428 >> > PLAYERSEASON.FK_PLAYERSEASON_1_INDEX_B; SQL statement: >> > insert into public.PlayerSeason (Id, PlayerId, SeasonId, TeamId, >> > Active, Number, Position, Salary) values (null, ?, ?, ?, ?, ?, ?, ?) >> > [50000-122] >> > at org.h2.message.Message.getSQLException(Message.java:106) >> > at org.h2.message.Message.convert(Message.java:283) >> > at org.h2.table.TableData.addRow(TableData.java:149) >> > at org.h2.command.dml.Insert.insertRows(Insert.java:119) >> > at org.h2.command.dml.Insert.update(Insert.java:82) >> > at >> org.h2.command.CommandContainer.update(CommandContainer.java:72) >> > at org.h2.command.Command.executeUpdate(Command.java:209) >> > at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal >> > (JdbcPreparedStatement.java:139) >> > at org.h2.jdbc.JdbcPreparedStatement.executeUpdate >> > (JdbcPreparedStatement.java:128) >> > at org.hibernate.id.IdentityGenerator >> > $GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94) >> > at >> org.hibernate.id.insert.AbstractReturningDelegate.performInsert >> > (AbstractReturningDelegate.java:57) >> > at org.hibernate.persister.entity.AbstractEntityPersister.insert >> > (AbstractEntityPersister.java:2186) >> > at org.hibernate.persister.entity.AbstractEntityPersister.insert >> > (AbstractEntityPersister.java:2666) >> > at org.hibernate.action.EntityIdentityInsertAction.execute >> > (EntityIdentityInsertAction.java:71) >> > at >> org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) >> > at >> > >> org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate >> > (AbstractSaveEventListener.java:321) >> > at org.hibernate.event.def.AbstractSaveEventListener.performSave >> > (AbstractSaveEventListener.java:204) >> > at >> > org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId >> > (AbstractSaveEventListener.java:130) >> > at >> > >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId >> >> >> > (DefaultSaveOrUpdateEventListener.java:210) >> > at >> > >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient >> > (DefaultSaveOrUpdateEventListener.java:195) >> > at >> > >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate >> >> > (DefaultSaveOrUpdateEventListener.java:117) >> > at >> > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate >> > (DefaultSaveOrUpdateEventListener.java:93) >> > at >> org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java: >> > 534) >> > at >> org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:526) >> > at >> org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:522) >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> > at sun.reflect.NativeMethodAccessorImpl.invoke >> > (NativeMethodAccessorImpl.java:39) >> > at sun.reflect.DelegatingMethodAccessorImpl.invoke >> > (DelegatingMethodAccessorImpl.java:25) >> > at java.lang.reflect.Method.invoke(Method.java:597) >> > at org.hibernate.context.ThreadLocalSessionContext >> > $TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java: >> > 342) >> > at $Proxy0.saveOrUpdate(Unknown Source) >> > at >> com.fastmodel.fastscout.stats.Stats.updatePlayerInfo(Stats.java: >> > 731) >> > at com.fastmodel.fastscout.stats.Stats.updateTeamAndPlayerInfo >> > (Stats.java:667) >> > at com.fastmodel.fastscout.stats.Stats.main(Stats.java:71) >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> > at sun.reflect.NativeMethodAccessorImpl.invoke >> > (NativeMethodAccessorImpl.java:39) >> > at sun.reflect.DelegatingMethodAccessorImpl.invoke >> > (DelegatingMethodAccessorImpl.java:25) >> > at java.lang.reflect.Method.invoke(Method.java:597) >> > at >> com.intellij.rt.execution.application.AppMain.main(AppMain.java: >> > 90) >> > Caused by: java.lang.RuntimeException: rowCount expected 30845 got >> > 31428 PLAYERSEASON.FK_PLAYERSEASON_1_INDEX_B >> > at org.h2.message.Message.throwInternalError(Message.java:186) >> > at org.h2.table.TableData.checkRowCount(TableData.java:160) >> > at org.h2.table.TableData.addRow(TableData.java:131) >> > ... 36 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]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
