bei Start: sql Fehler, Version: RC 1

geschrieben von dererik 
Willkommen! Anmelden Ein neues Profil erzeugen Suche
bei Start: sql Fehler, Version: RC 1
29. Dezember 2017 12:25
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"winking smiley)] [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"winking smiley)]
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"winking smiley)] [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"winking smiley)]
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"winking smiley)] [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"winking smiley)]
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"winking smiley)]
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
Re: bei Start: sql Fehler, Version: RC 1 - bei Import vorheriges Verzeichniss
29. Dezember 2017 12:40
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
In diesem Forum dürfen leider nur registrierte Teilnehmer schreiben.

Klicke hier, um Dich einzuloggen