bei Start: sql Fehl...
 
Benachrichtigungen
Alles entfernen

bei Start: sql Fehler, Version: RC 1

2 Beiträge
1 Benutzer
0 Reactions
879 Aufrufe
(@dererik)
Eminent Member
Beigetreten: vor 9 Jahren
Beiträge: 23
Topic starter   [#2380]

Hallo,

beim Start der neuesten 2er Version:

JVM terminated. Exit code=1
/usr/bin/java
-DREFRESH_BUNDLES=false
-Dorg.eclipse.e4.ui.css.dynamic=true
-jar /usr/share/fakturama2//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
-os linux
-ws gtk
-arch x86_64
-showsplash
-launcher /usr/share/fakturama2/Fakturama
-name Fakturama
--launcher.library /usr/share/fakturama2//plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.550.v20170928-1359/eclipse_1629.so
-startup /usr/share/fakturama2//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.overrideVmargs
-exitdata 111800f
-clean
-vm /usr/bin/java
-vmargs
-DREFRESH_BUNDLES=false
-Dorg.eclipse.e4.ui.css.dynamic=true
-jar /usr/share/fakturama2//plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar

auf der Konsole:
WARNING: Extender - Refreshing disabled - entities in bundle com.sebulli.fakturama.model may not be woven
[Server@3b920bdc]: Initiating startup sequence...
[Server@3b920bdc]: Server socket opened successfully in 13 ms.
[Server@3b920bdc]: Database [index=0, id=0, db=file:/home/erik/Seafile/ebooks/fakturama.work/Database/Database, alias=fakdbneu] opened successfully in 1101 ms.
[Server@3b920bdc]: Startup sequence completed in 1117 ms.
[Server@3b920bdc]: 2017-12-29 12:19:39.409 HSQLDB server 2.4.0 is online on port 9002
[Server@3b920bdc]: To close normally, connect and execute SHUTDOWN SQL
[Server@3b920bdc]: From command line, use [Ctrl]+[C] to abort abruptly
INFO 29.12.17 12:19: liquibase: Successfully acquired change log lock
INFO 29.12.17 12:19: liquibase: Reading from PUBLIC.DATABASECHANGELOG
SEVERE 29.12.17 12:19: liquibase: /changelog/db.changelog-master.xml: /changelog/db.changelog-2.0.xml::1510081018595-1::rheydenr (generated): Change Set /changelog/db.changelog-2.0.xml::1510081018595-1::rheydenr (generated) failed. Error: object name already exists: FKT_ADDRESS in statement [CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))] [Failed SQL: CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))]
INFO 29.12.17 12:19: liquibase: /changelog/db.changelog-2.0.xml::1510081018595-1::rheydenr (generated): Successfully released change log lock
liquibase.exception.MigrationFailedException: Migration failed for change set /changelog/db.changelog-2.0.xml::1510081018595-1::rheydenr (generated):
Reason: liquibase.exception.DatabaseException: object name already exists: FKT_ADDRESS in statement [CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))] [Failed SQL: CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:605)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at com.sebulli.fakturama.dbservice.impl.DbUpdateService.updateDatabase(DbUpdateService.java:79)
at com.sebulli.fakturama.LifecycleManager.checksBeforeStartup(LifecycleManager.java:157)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:55)
at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:305)
at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:233)
at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:107)
at org.eclipse.e4.ui.internal.workbench.swt.E4Application.lambda$0(E4Application.java:239)
at java.util.Optional.ifPresent(Optional.java:159)
at org.eclipse.e4.ui.internal.workbench.swt.E4Application.createE4Workbench(E4Application.java:235)
at org.eclipse.e4.ui.internal.workbench.swt.E4Application.start(E4Application.java:149)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
at org.eclipse.equinox.launcher.Main.main(Main.java:1472)
Caused by: liquibase.exception.DatabaseException: object name already exists: FKT_ADDRESS in statement [CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))] [Failed SQL: CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1273)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:568)
... 31 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists: FKT_ADDRESS in statement [CREATE TABLE "PUBLIC"."FKT_ADDRESS" ("ID" BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1) NOT NULL, "CITY" VARCHAR(255), "CITYADDON" VARCHAR(255), "COUNTRYCODE" VARCHAR(255), "DATEADDED" date, "DELETED" BOOLEAN DEFAULT FALSE, "MANUALADDRESS" VARCHAR(255), "MODIFIED" date, "MODIFIEDBY" VARCHAR(255), "NAME" VARCHAR(255), "STREET" VARCHAR(255), "VALIDFROM" date, "VALIDTO" date, "ZIP" VARCHAR(255), CONSTRAINT "PK_FKT_ADDRESS" PRIMARY KEY ("ID"))]
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
... 36 more
12:19:44.091 [com.sebulli.fakturama.log.LogbackAdapter@611a990b] ERROR com.sebulli.fakturama.common - Can't show the error message in Error View because no EventBroker is available!
12:19:44.111 [com.sebulli.fakturama.log.LogbackAdapter@611a990b] ERROR com.sebulli.fakturama.common - couldn't create or update database!

danke für Hilfe!

gruss
erik



   
Zitat
(@dererik)
Eminent Member
Beigetreten: vor 9 Jahren
Beiträge: 23
Topic starter  

noch präziser:

die Version startet, leeres Verzeichnis, alles gut.

Beim Wechsel in das mit der Vorgängerversion (2) erstellte Verzeichnis treten die Fehler auf.

gruss
erik



   
AntwortZitat
Teilen: