[ Traccar ] [ 5.4.0 ] GPS tracking system OpenSource

This is the best place for community developers to publish their genius work. Your Apps enrich the QNAP Turbo NAS.
Post Reply
mechanimal82
Know my way around
Posts: 136
Joined: Thu Feb 10, 2011 10:20 pm

Re: [ Traccar ] [ 3.10.0 ] GPS tracking system OpenSource

Post by mechanimal82 »

QNAP_Stephane wrote:it miss QJDK8 on your system

for intel/amd based

FW < 4.3 = x86
FW >4.3 = x86_64
It doesn't appear a 64bit JDK has been built... Any chance of compiling one???

http://forum.qnapclub.fr/topic/8111-qjd ... ment-37571
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Traccar ] [ 3.10.0 ] GPS tracking system OpenSource

Post by QNAP_Stephane »

---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
User avatar
Zeiti
Starting out
Posts: 17
Joined: Sat Feb 02, 2008 3:33 am
Location: Germany

Re: [ Traccar ] [ 3.10.0 ] GPS tracking system OpenSource

Post by Zeiti »

I have a problem on my new TS231P. I installed Traccar. The webinterface starts. I can configure everything. But a portscan shows no open ports.
When I start traccar on the commanline with

Code: Select all

/etc/init.d/traccar.sh restart
, I get then following error:

Code: Select all

/etc/init.d/traccar.sh restart
/share/CACHEDEV1_DATA/.qpkg/traccar/bin/ps: error while loading shared libraries: libprocps.so.6: cannot open shared object file: No such file or directory
traccar is stopped.
[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:187)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:167)
	at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:99)
	at org.h2.engine.Database.getPageStore(Database.java:2468)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at org.traccar.database.DataManager.initDatabase(DataManager.java:115)
	at org.traccar.database.DataManager.<init>(DataManager.java:70)
	at org.traccar.Context.init(Context.java:198)
	at org.traccar.Main.main(Main.java:35)
Caused by: java.lang.IllegalStateException: The file is locked: nio:/share/CACHEDEV1_DATA/.qpkg/traccar/data/database.mv.db [1.4.193/7]
	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765)
	at org.h2.mvstore.FileStore.open(FileStore.java:173)
	at org.h2.mvstore.MVStore.<init>(MVStore.java:348)
	at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2923)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
	... 26 more
Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at org.traccar.database.DataManager.initDatabase(DataManager.java:115)
	at org.traccar.database.DataManager.<init>(DataManager.java:70)
	at org.traccar.Context.init(Context.java:198)
	at org.traccar.Main.main(Main.java:35)
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:187)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:167)
	at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:99)
	at org.h2.engine.Database.getPageStore(Database.java:2468)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
	... 6 more
Caused by: java.lang.IllegalStateException: The file is locked: nio:/share/CACHEDEV1_DATA/.qpkg/traccar/data/database.mv.db [1.4.193/7]
	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765)
	at org.h2.mvstore.FileStore.open(FileStore.java:173)
	at org.h2.mvstore.MVStore.<init>(MVStore.java:348)
	at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2923)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
	... 26 more
[~] # 
Can anybody tell me the problem or help me?
TS231P, 3TB
TS-109pro 2.0.1 0324T, 1TB, DDNS, WEB, FTP, NFS, 100GB/s, MTU 1500
Optware/Ipkg, SVN, Mantis
trisonic
Starting out
Posts: 13
Joined: Thu Jun 15, 2017 5:49 am

Re: [ Traccar ] [ 3.10.0 ] GPS tracking system OpenSource

Post by trisonic »

could you update the package to the latest version?

thanks
mquast
Starting out
Posts: 15
Joined: Wed Jun 02, 2010 9:32 pm

Re: [ Traccar ] [ 3.10.0 ] GPS tracking system OpenSource

Post by mquast »

Hello.

I have a fresh install of Traccar with QJDK8 on my TS-469. Traccar web UI works on port 18082, but no port 5001-5129 seems to be listening on the QNAP (checked with SSH netstat -a).
The logs gives many "Null pointer exceptions".

Can somebody assist?

Thanks,
Michael

Part of the log:

INFO 6/18/17 7:38 PM: liquibase: ./schema/changelog-master.xml: changelog-3.10::changelog-3.7-mssql::author: Marking ChangeSet: changelog-3.10::changelog-3.7-mssql::author ran despite precondition failure due to onFail='MARK_RAN':
./schema/changelog-master.xml : DBMS Precondition failed: expected mssql, got h2

INFO 6/18/17 7:38 PM: liquibase: Successfully released change log lock
[main] INFO org.eclipse.jetty.util.log - Logging initialized @38421ms
[main] INFO org.eclipse.jetty.server.Server - jetty-9.2.21.v20170120
[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@2c88a3e8{/api,null,AVAILABLE}
[main] INFO org.eclipse.jetty.server.ServerConnector - Started ServerConnector@44065156{HTTP/1.1}{0.0.0.0:18082}
[main] INFO org.eclipse.jetty.server.Server - Started @110987ms
[qtp388802347-46] WARN org.eclipse.jetty.servlet.ServletHandler - /api/socket
java.lang.NullPointerException
at org.traccar.api.AsyncSocketServlet$1.createWebSocket(AsyncSocketServlet.java:37)
at org.eclipse.jetty.websocket.server.WebSocketServerFactory.acceptWebSocket(WebSocketServerFactory.java:166)
at org.eclipse.jetty.websocket.server.WebSocketServerFactory.acceptWebSocket(WebSocketServerFactory.java:153)
at org.eclipse.jetty.websocket.servlet.WebSocketServlet.service(WebSocketServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
[qtp388802347-522] WARN org.eclipse.jetty.servlet.ServletHandler - /api/socket
java.lang.NullPointerException
at org.traccar.api.AsyncSocketServlet$1.createWebSocket(AsyncSocketServlet.java:37)
at org.eclipse.jetty.websocket.server.WebSocketServerFactory.acceptWebSocket(WebSocketServerFactory.java:166)
at org.eclipse.jetty.websocket.server.WebSocketServerFactory.acceptWebSocket(WebSocketServerFactory.java:153)
at org.eclipse.jetty.websocket.servlet.WebSocketServlet.service(WebSocketServlet.java:151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:258)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
bdkacz
New here
Posts: 3
Joined: Sat Aug 19, 2017 3:23 am

Re: [ Traccar ] [ 3.10.0 ] GPS tracking system OpenSource

Post by bdkacz »

Any chance for updating to version 3.13 ?
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Traccar ] [ 3.13.0 ] GPS tracking system OpenSource

Post by QNAP_Stephane »

updated to 3.13 ;)
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
bdkacz
New here
Posts: 3
Joined: Sat Aug 19, 2017 3:23 am

Re: [ Traccar ] [ 3.13.0 ] GPS tracking system OpenSource

Post by bdkacz »

Thank you :)
bdkacz
New here
Posts: 3
Joined: Sat Aug 19, 2017 3:23 am

Re: [ Traccar ] [ 3.13.0 ] GPS tracking system OpenSource

Post by bdkacz »

Maybe update to 3.14 ? :)
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Traccar ] [ 3.14.0 ] GPS tracking system OpenSource

Post by QNAP_Stephane »

Updated ;)
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
benio
New here
Posts: 3
Joined: Mon Jan 26, 2015 3:25 pm

Re: [ Traccar ] [ 3.14.0 ] GPS tracking system OpenSource

Post by benio »

Welcome.

I install tracar on newest versions on tvs-471.

Java and package install corectly 64 bit versions.

Web portal is open and app wrks ok.

But when i try enable any protocol remove coments i get error and app not works.

Only reinstal package and original state works ok but not logging any devices.

After many tests i make test and on configuration window i click modify withoit any changes. No config changes made.

And then app stop working wit this errors.

Code: Select all


Exception in thread "main" java.util.InvalidPropertiesFormatException: org.xml.sax.SAXParseException; lineNumber: 58; columnNumber: 49; The content of elements must consist of well-formed character data or markup.
	at sun.util.xml.PlatformXmlPropertiesProvider.load(PlatformXmlPropertiesProvider.java:80)
	at java.util.Properties$XmlSupport.load(Properties.java:1201)
	at java.util.Properties.loadFromXML(Properties.java:881)
	at org.traccar.Config.load(Config.java:38)
	at org.traccar.Context.init(Context.java:269)
	at org.traccar.Main.main(Main.java:35)
Caused by: org.xml.sax.SAXParseException; lineNumber: 58; columnNumber: 49; The content of elements must consist of well-formed character data or markup.
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1465)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.startOfMarkup(XMLDocumentFragmentScannerImpl.java:2631)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2729)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:504)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:243)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:339)
	at sun.util.xml.PlatformXmlPropertiesProvider.getLoadingDoc(PlatformXmlPropertiesProvider.java:106)
	at sun.util.xml.PlatformXmlPropertiesProvider.load(PlatformXmlPropertiesProvider.java:78)
	... 5 more
  
Please help me run this app and enable protocols.

Best regards.

Lukas
User avatar
Zeiti
Starting out
Posts: 17
Joined: Sat Feb 02, 2008 3:33 am
Location: Germany

Re: [ Traccar ] [ 3.14.0 ] GPS tracking system OpenSource

Post by Zeiti »

Zeiti wrote:I have a problem on my new TS231P. I installed Traccar. The webinterface starts. I can configure everything. But a portscan shows no open ports.
When I start traccar on the commanline with

Code: Select all

/etc/init.d/traccar.sh restart
, I get then following error:

Code: Select all

/etc/init.d/traccar.sh restart
/share/CACHEDEV1_DATA/.qpkg/traccar/bin/ps: error while loading shared libraries: libprocps.so.6: cannot open shared object file: No such file or directory
traccar is stopped.
[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
[main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:187)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:167)
	at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:99)
	at org.h2.engine.Database.getPageStore(Database.java:2468)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at org.traccar.database.DataManager.initDatabase(DataManager.java:115)
	at org.traccar.database.DataManager.<init>(DataManager.java:70)
	at org.traccar.Context.init(Context.java:198)
	at org.traccar.Main.main(Main.java:35)
Caused by: java.lang.IllegalStateException: The file is locked: nio:/share/CACHEDEV1_DATA/.qpkg/traccar/data/database.mv.db [1.4.193/7]
	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765)
	at org.h2.mvstore.FileStore.open(FileStore.java:173)
	at org.h2.mvstore.MVStore.<init>(MVStore.java:348)
	at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2923)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
	... 26 more
Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:528)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:520)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at org.traccar.database.DataManager.initDatabase(DataManager.java:115)
	at org.traccar.database.DataManager.<init>(DataManager.java:70)
	at org.traccar.Context.init(Context.java:198)
	at org.traccar.Main.main(Main.java:35)
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:187)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:167)
	at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:99)
	at org.h2.engine.Database.getPageStore(Database.java:2468)
	at org.h2.engine.Database.open(Database.java:695)
	at org.h2.engine.Database.openDatabase(Database.java:273)
	at org.h2.engine.Database.<init>(Database.java:267)
	at org.h2.engine.Engine.openSession(Engine.java:64)
	at org.h2.engine.Engine.openSession(Engine.java:176)
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
	at org.h2.engine.Engine.createSession(Engine.java:137)
	at org.h2.engine.Engine.createSession(Engine.java:27)
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99)
	at org.h2.Driver.connect(Driver.java:69)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:428)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:499)
	... 6 more
Caused by: java.lang.IllegalStateException: The file is locked: nio:/share/CACHEDEV1_DATA/.qpkg/traccar/data/database.mv.db [1.4.193/7]
	at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765)
	at org.h2.mvstore.FileStore.open(FileStore.java:173)
	at org.h2.mvstore.MVStore.<init>(MVStore.java:348)
	at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2923)
	at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
	... 26 more
[~] # 
Can anybody tell me the problem or help me?
After a lot of updates and never get running traccar without problems I found the solution for these problems:
The script traccar.sh is not working correctly. The author added the path bin/ with the two tools kill and ps in the script.
He tried to get the absolute path and called these tools with :

Code: Select all

QPKG_ROOT=`/sbin/getcfg $QPKG_NAME Install_Path -f ${CONF}`
...
export PS=$QPKG_ROOT/bin/ps
export KILL=$QPKG_ROOT/bin/kill
...
_findpid() {
     $PS -eo 'pid,cmd'| grep 'tracker-server.jar' | grep -v grep | awk '{ print $1 }'
}

Calling ps and kill this way causes the error

Code: Select all

/share/CACHEDEV1_DATA/.qpkg/traccar/bin/ps: error while loading shared libraries: libprocps.so.6: cannot open shared object file: No such file or directory
So while trying to restart the script it cannot kill and therefore starts the service a second time. This causes the message

Code: Select all

Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-193]
I replaced the $PS and $KILL with simple ps and kill. Now the script works.
TS231P, 3TB
TS-109pro 2.0.1 0324T, 1TB, DDNS, WEB, FTP, NFS, 100GB/s, MTU 1500
Optware/Ipkg, SVN, Mantis
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Traccar ] [ 3.14.0 ] GPS tracking system OpenSource

Post by QNAP_Stephane »

I will modify this in next release
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
wifialarm
New here
Posts: 5
Joined: Sat Nov 25, 2017 6:39 pm

Re: [ Traccar ] [ 3.14.0 ] GPS tracking system OpenSource

Post by wifialarm »

Bonjour!

I have TS-228 FW 4.3.3
Try to install, but unsuccesfully - QJDK8 dependencies are only for x86. And traccar installation without these also don't work

Is there download link for other architecture?

Thanks in advance
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ Traccar ] [ 3.14.0 ] GPS tracking system OpenSource

Post by QNAP_Stephane »

next release will be for more models
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
Post Reply

Return to “Community Apps”