Hi,
ich versuche, mit Jameica 2.8.4 und Hibiscus 2.8.23 ein Konto zu löschen, das ich bei der Bank geschlossen habe und dessen Umsätze ich nicht mehr benötigt. Dabei wird eine Fehlermeldung angezeigt, und am Terminal findet sich Folgendes:
Wie kann ich das lösen?
Vielen Dank und schöne Grüße,
Peter
ich versuche, mit Jameica 2.8.4 und Hibiscus 2.8.23 ein Konto zu löschen, das ich bei der Bank geschlossen habe und dessen Umsätze ich nicht mehr benötigt. Dabei wird eine Fehlermeldung angezeigt, und am Terminal findet sich Folgendes:
Code
[Sat Apr 18 14:31:49 CEST 2020][ERROR][main][de.willuhn.jameica.hbci.gui.action.KontoDelete.handleAction] unable to delete konto
java.rmi.RemoteException: delete failed; nested exception is:
org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle zu sperren
Timeout trying to lock table ; SQL statement:
delete from UMSATZ where ID = 9326 [50200-196]
at de.willuhn.datasource.db.AbstractDBObject.delete(AbstractDBObject.java:397)
at de.willuhn.jameica.hbci.server.AbstractHibiscusDBObject.delete(AbstractHibiscusDBObject.java:83)
at de.willuhn.jameica.hbci.server.UmsatzImpl.delete(UmsatzImpl.java:552)
at de.willuhn.jameica.hbci.server.KontoImpl.delete(KontoImpl.java:270)
at de.willuhn.jameica.hbci.gui.action.KontoDelete.handleAction(KontoDelete.java:66)
at de.willuhn.jameica.gui.parts.ContextMenu$1.handleEvent(ContextMenu.java:183)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5797)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1374)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5051)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4583)
at de.willuhn.jameica.gui.GUI.loop(GUI.java:916)
at de.willuhn.jameica.gui.GUI.init(GUI.java:327)
at de.willuhn.jameica.system.Application.init(Application.java:145)
at de.willuhn.jameica.system.Application.newInstance(Application.java:87)
at de.willuhn.jameica.Main.main(Main.java:75)
Caused by: org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle zu sperren
Timeout trying to lock table ; SQL statement:
delete from UMSATZ where ID = 9326 [50200-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.command.Command.filterConcurrentUpdate(Command.java:310)
at org.h2.command.Command.executeUpdate(Command.java:262)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:136)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:121)
at de.willuhn.datasource.db.AbstractDBObject.delete(AbstractDBObject.java:372)
... 15 more
Caused by: org.h2.jdbc.JdbcSQLException: Zeile nicht gefunden beim Löschen von Index "PUBLIC.IDX_UMSATZ_VALUTA: ( /* key:6610 */ 9326, 11, NULL, NULL, NULL, 35.0, 'KREF+2019-03-07T15:38:47:00', '80', STRINGDECODE('KREF+2019-03-07T15:38:47:00\n80\nSVWZ+VRK7992820477561750\n'), DATE '2019-03-15', DATE '2019-03-15', 26139.1, '993202', 'OnlBanking-Euro-LS-Sammler', 'NONREF', NULL, 1360113061, NULL, NULL, '192', NULL, NULL, NULL, NULL, NULL, NULL)"
Row not found when trying to delete from index "PUBLIC.IDX_UMSATZ_VALUTA: ( /* key:6610 */ 9326, 11, NULL, NULL, NULL, 35.0, 'KREF+2019-03-07T15:38:47:00', '80', STRINGDECODE('KREF+2019-03-07T15:38:47:00\n80\nSVWZ+VRK7992820477561750\n'), DATE '2019-03-15', DATE '2019-03-15', 26139.1, '993202', 'OnlBanking-Euro-LS-Sammler', 'NONREF', NULL, 1360113061, NULL, NULL, '192', NULL, NULL, NULL, NULL, NULL, NULL)" [90112-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:233)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:336)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:245)
at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:192)
at org.h2.table.RegularTable.removeRow(RegularTable.java:389)
at org.h2.command.dml.Delete.update(Delete.java:95)
at org.h2.command.CommandContainer.update(CommandContainer.java:101)
at org.h2.command.Command.executeUpdate(Command.java:260)
... 18 more
java.rmi.RemoteException: delete failed; nested exception is:
org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle zu sperren
Timeout trying to lock table ; SQL statement:
delete from UMSATZ where ID = 9326 [50200-196]
at de.willuhn.datasource.db.AbstractDBObject.delete(AbstractDBObject.java:397)
at de.willuhn.jameica.hbci.server.AbstractHibiscusDBObject.delete(AbstractHibiscusDBObject.java:83)
at de.willuhn.jameica.hbci.server.UmsatzImpl.delete(UmsatzImpl.java:552)
at de.willuhn.jameica.hbci.server.KontoImpl.delete(KontoImpl.java:270)
at de.willuhn.jameica.hbci.gui.action.KontoDelete.handleAction(KontoDelete.java:66)
at de.willuhn.jameica.gui.parts.ContextMenu$1.handleEvent(ContextMenu.java:183)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5797)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1374)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5051)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4583)
at de.willuhn.jameica.gui.GUI.loop(GUI.java:916)
at de.willuhn.jameica.gui.GUI.init(GUI.java:327)
at de.willuhn.jameica.system.Application.init(Application.java:145)
at de.willuhn.jameica.system.Application.newInstance(Application.java:87)
at de.willuhn.jameica.Main.main(Main.java:75)
Caused by: org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle zu sperren
Timeout trying to lock table ; SQL statement:
delete from UMSATZ where ID = 9326 [50200-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.command.Command.filterConcurrentUpdate(Command.java:310)
at org.h2.command.Command.executeUpdate(Command.java:262)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:136)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:121)
at de.willuhn.datasource.db.AbstractDBObject.delete(AbstractDBObject.java:372)
... 15 more
Caused by: org.h2.jdbc.JdbcSQLException: Zeile nicht gefunden beim Löschen von Index "PUBLIC.IDX_UMSATZ_VALUTA: ( /* key:6610 */ 9326, 11, NULL, NULL, NULL, 35.0, 'KREF+2019-03-07T15:38:47:00', '80', STRINGDECODE('KREF+2019-03-07T15:38:47:00\n80\nSVWZ+VRK7992820477561750\n'), DATE '2019-03-15', DATE '2019-03-15', 26139.1, '993202', 'OnlBanking-Euro-LS-Sammler', 'NONREF', NULL, 1360113061, NULL, NULL, '192', NULL, NULL, NULL, NULL, NULL, NULL)"
Row not found when trying to delete from index "PUBLIC.IDX_UMSATZ_VALUTA: ( /* key:6610 */ 9326, 11, NULL, NULL, NULL, 35.0, 'KREF+2019-03-07T15:38:47:00', '80', STRINGDECODE('KREF+2019-03-07T15:38:47:00\n80\nSVWZ+VRK7992820477561750\n'), DATE '2019-03-15', DATE '2019-03-15', 26139.1, '993202', 'OnlBanking-Euro-LS-Sammler', 'NONREF', NULL, 1360113061, NULL, NULL, '192', NULL, NULL, NULL, NULL, NULL, NULL)" [90112-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:233)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:336)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:245)
at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:192)
at org.h2.table.RegularTable.removeRow(RegularTable.java:389)
at org.h2.command.dml.Delete.update(Delete.java:95)
at org.h2.command.CommandContainer.update(CommandContainer.java:101)
at org.h2.command.Command.executeUpdate(Command.java:260)
... 18 more
Wie kann ich das lösen?
Vielen Dank und schöne Grüße,
Peter