Skip to content

Test verze API 1.6.pre-release / problém s databází #4

@mduda100871

Description

@mduda100871

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í:

[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?

MD

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions