traccar service does not start

cesaruben_ctes9 years ago

Help

STATUS | wrapper  | 2015/11/11 09:45:46 | --> Wrapper Started as Service
STATUS | wrapper  | 2015/11/11 09:45:46 | Java Service Wrapper Community Edition 64-bit 3.5.26
STATUS | wrapper  | 2015/11/11 09:45:46 |   Copyright (C) 1999-2014 Tanuki Software, Ltd. All Rights Reserved.
STATUS | wrapper  | 2015/11/11 09:45:46 |     http://wrapper.tanukisoftware.com
STATUS | wrapper  | 2015/11/11 09:45:46 | 
STATUS | wrapper  | 2015/11/11 09:45:47 | Launching a JVM...
INFO   | jvm 1    | 2015/11/11 09:45:47 | WrapperManager: Initializing...
INFO   | jvm 1    | 2015/11/11 09:45:47 | [MLog-Init-Reporter] INFO com.mchange.v2.log.MLog - MLog clients using slf4j logging.
INFO   | jvm 1    | 2015/11/11 09:45:47 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.C3P0Registry - Initializing c3p0-0.9.5.1 [built 16-June-2015 00:06:36 -0700; debug? true; trace: 10]
INFO   | jvm 1    | 2015/11/11 09:45:48 | [WrapperSimpleAppMain] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hgf4ed9c1wf0wkj1a7d9l3|4868bd35, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hgf4ed9c1wf0wkj1a7d9l3|4868bd35, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/traccarv3?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp: 
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: Encountered an error running main:
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: java.lang.NullPointerException
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.database.QueryBuilder$6.process(QueryBuilder.java:371)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.database.QueryBuilder$6.process(QueryBuilder.java:367)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.database.QueryBuilder.executeQuery(QueryBuilder.java:393)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.database.DataManager.getLatestPositions(DataManager.java:349)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.database.ConnectionManager.<init>(ConnectionManager.java:41)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.Context.init(Context.java:102)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.traccar.Main.main(Main.java:26)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at java.lang.reflect.Method.invoke(Unknown Source)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
INFO   | jvm 1    | 2015/11/11 09:45:48 | WrapperSimpleApp Error: 	at java.lang.Thread.run(Unknown Source)
STATUS | wrapper  | 2015/11/11 09:45:50 | <-- Wrapper Stopped
Anton Tananaev9 years ago

Looks like the "database.selectLatestPositions" query is missing from the config.

cesaruben_ctes9 years ago

if I turn off the service traccar mysql service starts. when you power on again traccar mysql service is turned off.

Anton Tananaev9 years ago

Do you mean staring Traccar kills MySQL server. Can you please provide evidence of that (system logs).