Traccar service stops inmediately after starting

Mehdisn657 years ago

ok but it seems there is a 800mb limitation for traccar database
if it's true, can you helpme to remove this limitation?

Anton Tananaev7 years ago

I don't think there are any limitations, but you shouldn't use default database anyway. Use a fully featured database like MySQL.

Mehdisn657 years ago

hello dear Anton

i changed database like this and installed myqsl on server

<entry key='database.driver'>com.mysql.jdbc.Driver</entry> 
<entry key='database.url'>jdbc:mysql://127.0.0.1:3306/mysql?allowMultiQueries=true&amp;autoReconnect=true&amp;useUnicode=yes&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>root</entry> 
<entry key='database.password'></entry>

</properties>

this is the log

WARNING|wrapper|Service traccar|17-08-29 00:16:07|YAJSW: yajsw-stable-12.09
WARNING|wrapper|Service traccar|17-08-29 00:16:07|OS   : Windows Server 2008 R2/6.1/amd64
WARNING|wrapper|Service traccar|17-08-29 00:16:07|JVM  : Oracle Corporation/1.8.0_144/C:\Program Files\Java\jre1.8.0_144/64
INFO|wrapper|Service traccar|17-08-29 00:16:07|start delay: 0
INFO|wrapper|Service traccar|17-08-29 00:16:07|started process with pid 2424
INFO|2424/0|Service traccar|17-08-29 00:16:08|[INFO] StandardFileSystemManager - Using "C:\Windows\TEMP\vfs_cache" as temporary files store.
INFO|2424/0|Service traccar|17-08-29 00:16:08|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
INFO|2424/0|Service traccar|17-08-29 00:16:09|[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
INFO|2424/0|Service traccar|17-08-29 00:16:09|INFO 8/29/17 12:16 AM: liquibase: Clearing database change log checksums
INFO|2424/0|Service traccar|17-08-29 00:16:09|INFO 8/29/17 12:16 AM: liquibase: Successfully acquired change log lock
INFO|2424/0|Service traccar|17-08-29 00:16:09|INFO 8/29/17 12:16 AM: liquibase: Creating database history table with name: mysql.DATABASECHANGELOG
INFO|2424/0|Service traccar|17-08-29 00:16:09|INFO 8/29/17 12:16 AM: liquibase: Successfully released change log lock
INFO|2424/0|Service traccar|17-08-29 00:16:09|java.lang.reflect.InvocationTargetException
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at java.lang.reflect.Method.invoke(Unknown Source)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at org.rzo.yajsw.app.WrapperJVMMain.executeMain(WrapperJVMMain.java:60)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at org.rzo.yajsw.app.WrapperJVMMain.main(WrapperJVMMain.java:43)
INFO|2424/0|Service traccar|17-08-29 00:16:09|Caused by: liquibase.exception.DatabaseException: Table 'databasechangelog' already exists [Failed SQL: CREATE TABLE mysql.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL)]
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:103)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:240)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1124)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.Liquibase.clearCheckSums(Liquibase.java:1338)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:148)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at org.traccar.database.DataManager.<init>(DataManager.java:76)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at org.traccar.Context.init(Context.java:221)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at org.traccar.Main.main(Main.java:35)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	... 6 more
INFO|2424/0|Service traccar|17-08-29 00:16:09|Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'databasechangelog' already exists
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at java.lang.reflect.Constructor.newInstance(Unknown Source)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.Util.getInstance(Util.java:408)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
INFO|2424/0|Service traccar|17-08-29 00:16:09|	... 16 more
INFO|wrapper|Service traccar|17-08-29 00:16:09|calling onStop
INFO|wrapper|Service traccar|17-08-29 00:16:09|Win service stop - timeout: 30000
INFO|wrapper|Service traccar|17-08-29 00:16:09|Win service wrapper.control -> stopping application
INFO|wrapper|Service traccar|17-08-29 00:16:09|Win service stop - after shutdown
INFO|wrapper|Service traccar|17-08-29 00:16:09|Win service stop - before notify
INFO|wrapper|Service traccar|17-08-29 00:16:09|Win service terminated
Anton Tananaev7 years ago

There is some problem with your database. Possibly the problem is with table name case:

https://github.com/liquibase/liquibase-cache/issues/1

Mehdisn657 years ago

Thanks, its ok now

last time before new installation, when i tried to add a device with Arabic character, the database was accepted and there wasn't any error about the name in database
now i'v seen this when i tried to add device with Arabic name:

Data truncation: Incorrect string value: '\xD9\x86\xD8\xA7\xD9\x85...' for column 'name' at row 1 - MysqlDataTruncation (... < QueryBuilder:475 < DataManager:217 < DeviceManager:212 < ...)

can you please help me to solve this too?

Mehdisn657 years ago

I solved the problem

i've changed the collection in structure to utf8_persian_ci in device table

thanks anyway :)