nasadil jsem k testování verzi 1.6.pre-release, ale hned na začátku, po spuštění aplikace, jsem narazil na následující problém s databází:
[altoeditor-api] | 2026-03-10 11:57:17,666 INFO: Config is in /home/alto/.altoEditor/application.conf
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:17,679 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:17,679 INFO: Akubra storage set: ObjectStore (/srv/altoeditor-data/objectStore) exists: true pattern: ##/##. DataStreamStore (/srv/altoeditor-data/datastreamStore) exists: true pattern: ##/##.
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:17,844 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:17,843 INFO: Instance of database cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabase registered with instanceid=AltoEditorDatabase
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:17,853 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:17,852 WARN: Table BATCH already has a Timestamp column. DataType of column UPDATE_DATE should be DATETIME.
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,117 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,117 INFO: Instance of database cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV4 registered with instanceid=AltoEditorDatabaseV4
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,118 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,118 WARN: Table BATCH already has a Timestamp column. DataType of column UPDATE_DATE should be DATETIME.
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,122 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,122 INFO: Adding alter statmement for column BATCH.OCR_ENGINE.
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,122 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,122 INFO: Adding alter statmement for column DIGITALOBJECT.LOCK.
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,127 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,125 ERROR: org.postgresql.util.PSQLException: ERROR: column "ocr_engine" of relation "batch" already exists
[altoeditor-api] | org.postgresql.util.PSQLException: ERROR: column "ocr_engine" of relation "batch" already exists
[altoeditor-api] | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
[altoeditor-api] | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
[altoeditor-api] | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:356)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:341)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:317)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:290)
[altoeditor-api] | at org.apache.empire.db.DBDatabaseDriver.executeSQL(DBDatabaseDriver.java:565)
[altoeditor-api] | at org.apache.empire.db.DBSQLScript.executeAll(DBSQLScript.java:327)
[altoeditor-api] | at org.apache.empire.db.DBSQLScript.executeAll(DBSQLScript.java:355)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV3.upgradeDdl(AltoEditorDatabaseV3.java:186)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV3.upgradeToVersion4(AltoEditorDatabaseV3.java:164)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV4.upgradeToVersion5(AltoEditorDatabaseV4.java:157)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabase.init(AltoEditorDatabase.java:168)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.EmpireDaoFactory.init(EmpireDaoFactory.java:44)
[altoeditor-api] | at cz.inovatika.altoEditor.server.AltoEditorInitializer.initDb(AltoEditorInitializer.java:209)
[altoeditor-api] | at cz.inovatika.altoEditor.server.AltoEditorInitializer.start(AltoEditorInitializer.java:55)
[altoeditor-api] | at cz.inovatika.altoEditor.server.Run.main(Run.java:13)
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,128 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,128 INFO: An Error occured. Message is: The database operation failed. Native error is: ERROR: column "ocr_engine" of relation "batch" already exists
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,129 DEBG 'alto_editor' stdout output:
[altoeditor-api] | 2026-03-10 11:57:18,128 ERROR: The database operation failed. Native error is: ERROR: column "ocr_engine" of relation "batch" already exists
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,129 DEBG 'alto_editor' stdout output:
[altoeditor-api] | org.apache.empire.db.exceptions.EmpireSQLException: The database operation failed. Native error is: ERROR: column "ocr_engine" of relation "batch" already exists
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,129 DEBG 'alto_editor' stdout output:
[altoeditor-api] | at org.apache.empire.db.DBSQLScript.executeAll(DBSQLScript.java:336)
[altoeditor-api] | at org.apache.empire.db.DBSQLScript.executeAll(DBSQLScript.java:355)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV3.upgradeDdl(AltoEditorDatabaseV3.java:186)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV3.upgradeToVersion4(AltoEditorDatabaseV3.java:164)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabaseV4.upgradeToVersion5(AltoEditorDatabaseV4.java:157)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.AltoEditorDatabase.init(AltoEditorDatabase.java:168)
[altoeditor-api] | at cz.inovatika.altoEditor.db.empireDb.EmpireDaoFactory.init(EmpireDaoFactory.java:44)
[altoeditor-api] | at cz.inovatika.altoEditor.server.AltoEditorInitializer.initDb(AltoEditorInitializer.java:209)
[altoeditor-api] | at cz.inovatika.altoEditor.server.AltoEditorInitializer.start(AltoEditorInitializer.java:55)
[altoeditor-api] | at cz.inovatika.altoEditor.server.Run.main(Run.java:13)
[altoeditor-api] | Caused by: org.postgresql.util.PSQLException: ERROR: column "ocr_engine" of relation "batch" already exists
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:18,130 DEBG 'alto_editor' stdout output:
[altoeditor-api] | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
[altoeditor-api] | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
[altoeditor-api] | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:356)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:341)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:317)
[altoeditor-api] | at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:290)
[altoeditor-api] | at org.apache.empire.db.DBDatabaseDriver.executeSQL(DBDatabaseDriver.java:565)
[altoeditor-api] | at org.apache.empire.db.DBSQLScript.executeAll(DBSQLScript.java:327)
[altoeditor-api] | ... 9 more
[altoeditor-api] |
[altoeditor-api] | 2026-03-10 11:57:22,135 INFO success: alto_editor entered RUNNING state, process has stayed up for > than 5 seconds (startsecs)
což předpokládám, že může souviset s úpravami ohledně zamykání, které bylo zmíněno v seznamu řešených issues.
Předesílám, že je tam databáze pro předchozí verzi 1.5. Co s tím?
Zdravím,
nasadil jsem k testování verzi 1.6.pre-release, ale hned na začátku, po spuštění aplikace, jsem narazil na následující problém s databází:
což předpokládám, že může souviset s úpravami ohledně zamykání, které bylo zmíněno v seznamu řešených issues.
Předesílám, že je tam databáze pro předchozí verzi 1.5. Co s tím?
MD