Exception after the update from 1.4.197 to 1.4.200

102 views

Skip to first unread message

Damian Stolarek

unread,

Oct 30, 2019, 8:28:12 AM10/30/19

to H2 Database

Hello,

I have problems with the latest version.

I get this exception after the update from 1.4.197 to 1.4.200

org.h2.jdbc.JdbcSQLTransientException: Zeile nicht gefunden beim Löschen von Index """"".I322: ( /* key:1568 */ 3019, 'AH Design 17'''' Met achtergrondlogo', STRINGDECODE('section#top div#filter { visibility: visible; }\nsection#top div#buttons { top: 20px; }\n.cLeereProdukte { visibility: hidden; } \n\nsection#top div#kundenlogo { top:0px; left:0px; width: 1680px; height: 136px; background-image:url(''Header.png''); background:color:white; }\nsection#top div#filter { visibility: visible; }\nsection#top div#buttons { top: 20px; }\n\nsection#top div#buttons { right: 2px; display: block !important; top: 1px; }\t\t\t\nbutton#warengruppenUebersicht { z-index: 100; position: absolute; top: 2px; right: 20px;}\t\nsection#top div#pleaseWait { z-index: 11; }\n\ndiv.produktBeschreibung div.inner button { width: 150px; height:60px; }\ndiv.warengruppe img { opacity: 0;}\ndiv.warengruppe { width:350px; height:100px; margin-left:auto; margin-right:auto; float:none; background-image: linear-gradient(332deg, #4cb4e9, #00BCD4); border-radius: 5.0em;}\ndiv.warengruppe span.titel { bottom: 1.1em;font-size: 4.5em; text-align: center; width: 100%; color: white; text-shadow: -1px 0 black, 0 1px black, 1px 0 black, 0 -1px black;}\nul[class*=\"" r8x3\""] { width:1280px !important; font-size: 110%; margin-left: 1.8em; margin-top: 4.5em; }\ndiv.navigator div.links,div.navigator div.rechts { width:250px; }\n\ndiv.warengruppe:nth-child(1n+4) {font-size: 84%;}\ndiv.warengruppe {margin-left: 50px;}\ndiv.Txt {text-align: left; margin-left: 40px;}\ndiv.cWarengruppen { background: url(''background.png'') no-repeat;}\n\n\n'), '', 2347, NULL, NULL, '1b8e68ba-6d57-415f-b395-1f76cb626c2a', 'AH (17 Inch) v1.0', 1556779854973, FALSE, '45ed8c87-3a3a-4e60-9246-49b0722774c6', 'fa9e3199-9245-4aa8-8ddf-044d9f261b25', 'Nick Helmsing [helmsing]')"

Row not found when trying to delete from index """"".I322: ( /* key:1568 */ 3019, 'AH Design 17'''' Met achtergrondlogo', STRINGDECODE('section#top div#filter { visibility: visible; }\nsection#top div#buttons { top: 20px; }\n.cLeereProdukte { visibility: hidden; } \n\nsection#top div#kundenlogo { top:0px; left:0px; width: 1680px; height: 136px; background-image:url(''Header.png''); background:color:white; }\nsection#top div#filter { visibility: visible; }\nsection#top div#buttons { top: 20px; }\n\nsection#top div#buttons { right: 2px; display: block !important; top: 1px; }\t\t\t\nbutton#warengruppenUebersicht { z-index: 100; position: absolute; top: 2px; right: 20px;}\t\nsection#top div#pleaseWait { z-index: 11; }\n\ndiv.produktBeschreibung div.inner button { width: 150px; height:60px; }\ndiv.warengruppe img { opacity: 0;}\ndiv.warengruppe { width:350px; height:100px; margin-left:auto; margin-right:auto; float:none; background-image: linear-gradient(332deg, #4cb4e9, #00BCD4); border-radius: 5.0em;}\ndiv.warengruppe span.titel { bottom: 1.1em;font-size: 4.5em; text-align: center; width: 100%; color: white; text-shadow: -1px 0 black, 0 1px black, 1px 0 black, 0 -1px black;}\nul[class*=\"" r8x3\""] { width:1280px !important; font-size: 110%; margin-left: 1.8em; margin-top: 4.5em; }\ndiv.navigator div.links,div.navigator div.rechts { width:250px; }\n\ndiv.warengruppe:nth-child(1n+4) {font-size: 84%;}\ndiv.warengruppe {margin-left: 50px;}\ndiv.Txt {text-align: left; margin-left: 40px;}\ndiv.cWarengruppen { background: url(''background.png'') no-repeat;}\n\n\n'), '', 2347, NULL, NULL, '1b8e68ba-6d57-415f-b395-1f76cb626c2a', 'AH (17 Inch) v1.0', 1556779854973, FALSE, '45ed8c87-3a3a-4e60-9246-49b0722774c6', 'fa9e3199-9245-4aa8-8ddf-044d9f261b25', 'Nick Helmsing [helmsing]')" [90112-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:626) ~[h2.jar:1.4.200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) ~[h2.jar:1.4.200]

at org.h2.message.DbException.get(DbException.java:205) ~[h2.jar:1.4.200]

at org.h2.message.DbException.get(DbException.java:181) ~[h2.jar:1.4.200]

at org.h2.pagestore.db.PageBtreeLeaf.remove(PageBtreeLeaf.java:231) ~[h2.jar:1.4.200]

at org.h2.pagestore.db.PageBtreeNode.remove(PageBtreeNode.java:335) ~[h2.jar:1.4.200]

at org.h2.pagestore.db.PageBtreeIndex.remove(PageBtreeIndex.java:246) ~[h2.jar:1.4.200]

at org.h2.pagestore.db.PageStoreTable.removeRow(PageStoreTable.java:272) ~[h2.jar:1.4.200]

at org.h2.pagestore.PageStore.redo(PageStore.java:1575) ~[h2.jar:1.4.200]

at org.h2.pagestore.PageStore.redoDelete(PageStore.java:1548) ~[h2.jar:1.4.200]

at org.h2.pagestore.PageLog.recover(PageLog.java:349) ~[h2.jar:1.4.200]

at org.h2.pagestore.PageStore.recover(PageStore.java:1401) ~[h2.jar:1.4.200]

at org.h2.pagestore.PageStore.openExisting(PageStore.java:364) ~[h2.jar:1.4.200]

at org.h2.pagestore.PageStore.open(PageStore.java:290) ~[h2.jar:1.4.200]

at org.h2.engine.Database.getPageStore(Database.java:2674) ~[h2.jar:1.4.200]

at org.h2.engine.Database.open(Database.java:675) ~[h2.jar:1.4.200]

at org.h2.engine.Database.openDatabase(Database.java:307) ~[h2.jar:1.4.200]

at org.h2.engine.Database.<init>(Database.java:301) ~[h2.jar:1.4.200]

at org.h2.engine.Engine.openSession(Engine.java:74) ~[h2.jar:1.4.200]

at org.h2.engine.Engine.openSession(Engine.java:192) ~[h2.jar:1.4.200]

at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171) ~[h2.jar:1.4.200]

at org.h2.engine.Engine.createSession(Engine.java:166) ~[h2.jar:1.4.200]

at org.h2.engine.Engine.createSession(Engine.java:29) ~[h2.jar:1.4.200]

at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:340) ~[h2.jar:1.4.200]

at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:173) ~[h2.jar:1.4.200]

at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:152) ~[h2.jar:1.4.200]

at org.h2.Driver.connect(Driver.java:69) ~[h2.jar:1.4.200]

at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_212]

at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_212]

at de.harting.smtportal.smtkern.db.DB.open(DB.java:95) ~[bin/:?]

at de.harting.smtportal.smtkern.Daten.createEmptyDBMapperDatabase(Daten.java:1047) ~[bin/:?]

at de.harting.smtportal.smtkern.Daten.<init>(Daten.java:83) [bin/:?]

at de.harting.smtportal.smtzentral.SMTZentral.main(SMTZentral.java:43) [bin/:?]

I think it must be a problem with the text in the database.

Can somebody help me to understand the output?

Thank you very much.

Best regards

Damian

Evgenij Ryazanov

unread,

Oct 30, 2019, 9:18:19 AM10/30/19

to H2 Database

Hello.

It looks like some kind of corruption caused by unclean shutdown. If you have a backup copy of the database before the migration, open it with 1.4.197 and use SCRIPT TO 'filename.sql' to export the database to a script. After it create a new database with 1.4.200 and execute RUNSCRIPT FROM 'filename.sql' in it.

https://h2database.com/html/tutorial.html#upgrade_backup_restore

Automatic upgrade is not always clean.

If you don't have a backup copy and 1.4.197 can't open that database too try the recover tool: