Postgres

Alex Kraft6 years ago

Не стартует демон traccar после переключения на postgres
В чем причина? с H2 стартовал без проблем.
В логе

INFO|31584/0|Service traccar|18-10-01 17:02:41|[main] INFO liquibase.executor.jvm.JdbcExecutor - UPDATE public.tc_notifications SET notificators ='web,mail,sms' WHERE web = 1 AND mail = 1 AND sms = 1
INFO|31584/0|Service traccar|18-10-01 17:02:41|[main] ERROR liquibase.changelog.ChangeSet - Change Set changelog-4.0::changelog-4.0::author failed.  Error: ERROR: operator does not exist: boolean = integer
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Position: 76 [Failed SQL: UPDATE public.tc_notifications SET notificators = 'web,mail,sms' WHERE web = 1 AND mail = 1 AND sms = 1]
INFO|31584/0|Service traccar|18-10-01 17:02:41|[main] INFO liquibase.lockservice.StandardLockService - Successfully released change log lock
INFO|31584/0|Service traccar|18-10-01 17:02:41|java.lang.reflect.InvocationTargetException
INFO|31584/0|Service traccar|18-10-01 17:02:41| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at java.lang.reflect.Method.invoke(Method.java:498)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|31584/0|Service traccar|18-10-01 17:02:41|Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set changelog-4.0::changelog-4.0::author:
INFO|31584/0|Service traccar|18-10-01 17:02:41|     Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: boolean = integer
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Position: 76 [Failed SQL: UPDATE public.tc_notifications SET notificators = 'web,mail,sms' WHERE web = 1 AND mail = 1 AND sms = 1]
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.Liquibase.update(Liquibase.java:202)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.Liquibase.update(Liquibase.java:179)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.Liquibase.update(Liquibase.java:175)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:307)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.traccar.database.DataManager.<init>(DataManager.java:88)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.traccar.Context.init(Context.java:361)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.traccar.Main.main(Main.java:35)
INFO|31584/0|Service traccar|18-10-01 17:02:41| ... 6 more
INFO|31584/0|Service traccar|18-10-01 17:02:41|Caused by: liquibase.exception.DatabaseException: ERROR: operator does not exist: boolean = integer
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Position: 76 [Failed SQL: UPDATE public.tc_notifications SET notificators = 'web,mail,sms' WHERE web = 1 AND mail = 1 AND sms = 1]
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
INFO|31584/0|Service traccar|18-10-01 17:02:41| ... 15 more
INFO|31584/0|Service traccar|18-10-01 17:02:41|Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
INFO|31584/0|Service traccar|18-10-01 17:02:41|  Position: 76
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
INFO|31584/0|Service traccar|18-10-01 17:02:41| at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
INFO|31584/0|Service traccar|18-10-01 17:02:41| ... 20 more
INFO|wrapper|Service traccar|18-10-01 17:02:41|waitpid 31584 59136
INFO|wrapper|Service traccar|18-10-01 17:02:41|exit code posix process: 59136 application(status/signal): 231/0
Anton Tananaev6 years ago

Вы поиском пользовались перед тем как задать вопрос?

https://www.traccar.org/forums/topic/traccar-40-and-postgres/

Alex Kraft6 years ago

Спасибо