Compile the soource code traccer in Intelligent IDE

kumar22848 years ago

Hello ,

i used MySQL database and i used my laptop.
My idea to use the software to capture the mobile GPS and to store in the MYSQL data base.
Database created in name traccar.
During compilation of code i received below warning,

Am confued with these lines
1)Failed to initialize pool: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-192]
2)The file is locked: nio:/home/kumar/kam3cob/01_sourcecode/02_tracking/traccar/traccar/target/database.mv.db [1.4.192/7]
3)org.h2.engine.why in warnings messages diplay h2.engine

/usr/lib/jvm/java-8-openjdk-amd64/bin/java -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:33015,suspend=y,server=n -Dfile.encoding=UTF-8 -classpath /usr/lib/jvm/java-8-openjdk-amd64/jre/lib/charsets.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/cldrdata.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/dnsns.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/icedtea-sound.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/jaccess.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/javax.mail.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/localedata.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/mysql-connector-java-5.1.37-bin.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/nashorn.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/sunec.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/sunjce_provider.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/sunpkcs11.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext/zipfs.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jce.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jsse.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/management-agent.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/resources.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/rt.jar:/home/kumar/kam3cob/01_sourcecode/02_tracking/traccar/traccar/target/classes:/home/kumar/.m2/repository/log4j/log4j/1.2.17/log4j-1.2.17.jar:/home/kumar/.m2/repository/joda-time/joda-time/2.9.4/joda-time-2.9.4.jar:/home/kumar/.m2/repository/com/h2database/h2/1.4.192/h2-1.4.192.jar:/home/kumar/.m2/repository/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39.jar:/home/kumar/.m2/repository/org/postgresql/postgresql/9.4.1210.jre7/postgresql-9.4.1210.jre7.jar:/home/kumar/.m2/repository/com/zaxxer/HikariCP-java7/2.4.8/HikariCP-java7-2.4.8.jar:/home/kumar/.m2/repository/org/slf4j/slf4j-api/1.7.21/slf4j-api-1.7.21.jar:/home/kumar/.m2/repository/io/netty/netty/3.10.6.Final/netty-3.10.6.Final.jar:/home/kumar/.m2/repository/com/ning/async-http-client/1.9.39/async-http-client-1.9.39.jar:/home/kumar/.m2/repository/org/slf4j/slf4j-simple/1.7.21/slf4j-simple-1.7.21.jar:/home/kumar/.m2/repository/org/glassfish/javax.json/1.0.4/javax.json-1.0.4.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-server/9.2.19.v20160908/jetty-server-9.2.19.v20160908.jar:/home/kumar/.m2/repository/javax/servlet/javax.servlet-api/3.1.0/javax.servlet-api-3.1.0.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-http/9.2.19.v20160908/jetty-http-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-io/9.2.19.v20160908/jetty-io-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-servlet/9.2.19.v20160908/jetty-servlet-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-security/9.2.19.v20160908/jetty-security-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-webapp/9.2.19.v20160908/jetty-webapp-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-xml/9.2.19.v20160908/jetty-xml-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-jndi/9.2.19.v20160908/jetty-jndi-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/jetty-util/9.2.19.v20160908/jetty-util-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/websocket/websocket-server/9.2.19.v20160908/websocket-server-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/websocket/websocket-common/9.2.19.v20160908/websocket-common-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/websocket/websocket-api/9.2.19.v20160908/websocket-api-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/websocket/websocket-client/9.2.19.v20160908/websocket-client-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/eclipse/jetty/websocket/websocket-servlet/9.2.19.v20160908/websocket-servlet-9.2.19.v20160908.jar:/home/kumar/.m2/repository/org/glassfish/jersey/containers/jersey-container-servlet/2.23.2/jersey-container-servlet-2.23.2.jar:/home/kumar/.m2/repository/org/glassfish/jersey/containers/jersey-container-servlet-core/2.23.2/jersey-container-servlet-core-2.23.2.jar:/home/kumar/.m2/repository/org/glassfish/hk2/external/javax.inject/2.5.0-b05/javax.inject-2.5.0-b05.jar:/home/kumar/.m2/repository/org/glassfish/jersey/core/jersey-common/2.23.2/jersey-common-2.23.2.jar:/home/kumar/.m2/repository/javax/annotation/javax.annotation-api/1.2/javax.annotation-api-1.2.jar:/home/kumar/.m2/repository/org/glassfish/jersey/bundles/repackaged/jersey-guava/2.23.2/jersey-guava-2.23.2.jar:/home/kumar/.m2/repository/org/glassfish/hk2/hk2-api/2.5.0-b05/hk2-api-2.5.0-b05.jar:/home/kumar/.m2/repository/org/glassfish/hk2/hk2-utils/2.5.0-b05/hk2-utils-2.5.0-b05.jar:/home/kumar/.m2/repository/org/glassfish/hk2/external/aopalliance-repackaged/2.5.0-b05/aopalliance-repackaged-2.5.0-b05.jar:/home/kumar/.m2/repository/org/glassfish/hk2/hk2-locator/2.5.0-b05/hk2-locator-2.5.0-b05.jar:/home/kumar/.m2/repository/org/javassist/javassist/3.20.0-GA/javassist-3.20.0-GA.jar:/home/kumar/.m2/repository/org/glassfish/hk2/osgi-resource-locator/1.0.1/osgi-resource-locator-1.0.1.jar:/home/kumar/.m2/repository/org/glassfish/jersey/core/jersey-server/2.23.2/jersey-server-2.23.2.jar:/home/kumar/.m2/repository/org/glassfish/jersey/core/jersey-client/2.23.2/jersey-client-2.23.2.jar:/home/kumar/.m2/repository/org/glassfish/jersey/media/jersey-media-jaxb/2.23.2/jersey-media-jaxb-2.23.2.jar:/home/kumar/.m2/repository/javax/validation/validation-api/1.1.0.Final/validation-api-1.1.0.Final.jar:/home/kumar/.m2/repository/javax/ws/rs/javax.ws.rs-api/2.0.1/javax.ws.rs-api-2.0.1.jar:/home/kumar/.m2/repository/org/glassfish/jersey/media/jersey-media-json-jackson/2.23.2/jersey-media-json-jackson-2.23.2.jar:/home/kumar/.m2/repository/org/glassfish/jersey/ext/jersey-entity-filtering/2.23.2/jersey-entity-filtering-2.23.2.jar:/home/kumar/.m2/repository/com/fasterxml/jackson/jaxrs/jackson-jaxrs-base/2.5.4/jackson-jaxrs-base-2.5.4.jar:/home/kumar/.m2/repository/com/fasterxml/jackson/core/jackson-core/2.5.4/jackson-core-2.5.4.jar:/home/kumar/.m2/repository/com/fasterxml/jackson/core/jackson-databind/2.5.4/jackson-databind-2.5.4.jar:/home/kumar/.m2/repository/com/fasterxml/jackson/jaxrs/jackson-jaxrs-json-provider/2.5.4/jackson-jaxrs-json-provider-2.5.4.jar:/home/kumar/.m2/repository/com/fasterxml/jackson/module/jackson-module-jaxb-annotations/2.5.4/jackson-module-jaxb-annotations-2.5.4.jar:/home/kumar/.m2/repository/com/fasterxml/jackson/core/jackson-annotations/2.5.4/jackson-annotations-2.5.4.jar:/home/kumar/.m2/repository/org/liquibase/liquibase-core/3.5.1/liquibase-core-3.5.1.jar:/home/kumar/.m2/repository/org/yaml/snakeyaml/1.13/snakeyaml-1.13.jar:/home/kumar/.m2/repository/javax/mail/mail/1.4.7/mail-1.4.7.jar:/home/kumar/.m2/repository/javax/activation/activation/1.1/activation-1.1.jar:/home/kumar/.m2/repository/org/jxls/jxls/2.3.0/jxls-2.3.0.jar:/home/kumar/.m2/repository/org/apache/commons/commons-jexl/2.1.1/commons-jexl-2.1.1.jar:/home/kumar/.m2/repository/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar:/home/kumar/.m2/repository/commons-beanutils/commons-beanutils/1.9.2/commons-beanutils-1.9.2.jar:/home/kumar/.m2/repository/commons-collections/commons-collections/3.2.1/commons-collections-3.2.1.jar:/home/kumar/.m2/repository/org/slf4j/jcl-over-slf4j/1.7.12/jcl-over-slf4j-1.7.12.jar:/home/kumar/.m2/repository/ch/qos/logback/logback-core/1.1.3/logback-core-1.1.3.jar:/home/kumar/.m2/repository/org/jxls/jxls-poi/1.0.11/jxls-poi-1.0.11.jar:/home/kumar/.m2/repository/org/apache/poi/poi/3.14/poi-3.14.jar:/home/kumar/.m2/repository/commons-codec/commons-codec/1.10/commons-codec-1.10.jar:/home/kumar/.m2/repository/org/apache/poi/poi-ooxml/3.14/poi-ooxml-3.14.jar:/home/kumar/.m2/repository/org/apache/poi/poi-ooxml-schemas/3.14/poi-ooxml-schemas-3.14.jar:/home/kumar/.m2/repository/org/apache/xmlbeans/xmlbeans/2.6.0/xmlbeans-2.6.0.jar:/home/kumar/.m2/repository/stax/stax-api/1.0.1/stax-api-1.0.1.jar:/home/kumar/.m2/repository/com/github/virtuald/curvesapi/1.03/curvesapi-1.03.jar:/home/kumar/Downloads/idea-IC-162.2228.15/lib/idea_rt.jar org.traccar.Main debug.xml
Connected to the target VM, address: '127.0.0.1:33015', transport: 'socket'
[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
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-192]
    at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:514)
    at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:107)
    at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71)
    at org.traccar.database.DataManager.initDatabase(DataManager.java:112)
    at org.traccar.database.DataManager.<init>(DataManager.java:67)
    at org.traccar.Context.init(Context.java:167)
    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-192]
    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:2463)
    at org.h2.engine.Database.open(Database.java:692)
    at org.h2.engine.Database.openDatabase(Database.java:270)
    at org.h2.engine.Database.<init>(Database.java:264)
    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:118)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:102)
    at org.h2.Driver.connect(Driver.java:72)
    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.HikariPool.checkFailFast(HikariPool.java:508)
    ... 6 more
Caused by: java.lang.IllegalStateException: The file is locked: nio:/home/kumar/kam3cob/01_sourcecode/02_tracking/traccar/traccar/target/database.mv.db [1.4.192/7]
    at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
    at org.h2.mvstore.FileStore.open(FileStore.java:172)
    at org.h2.mvstore.MVStore.<init>(MVStore.java:344)
    at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2893)
    at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
    ... 24 more
kumar22848 years ago

Hi,

While compiling traccar_master folder whether we need to confing traccar.xm and give build and then run linux installations ?

Anton Tananaev8 years ago

It looks like you are trying to use H2 database, not MySQL. Note that H2 database can be used only by a single process at the same time. It looks like your database file is already locked by some other process.

I don't understand the question about "installations".

kumar22848 years ago

Problem solved

[main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Started.
INFO 11/14/16 8:33 AM: liquibase: Clearing database change log checksums
INFO 11/14/16 8:33 AM: liquibase: Successfully acquired change log lock
INFO 11/14/16 8:33 AM: liquibase: Successfully released change log lock
INFO 11/14/16 8:33 AM: liquibase: Successfully acquired change log lock
INFO 11/14/16 8:33 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO 11/14/16 8:33 AM: liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO 11/14/16 8:33 AM: liquibase: Successfully released change log lock
[main] INFO org.eclipse.jetty.util.log - Logging initialized @5483ms
[main] INFO org.eclipse.jetty.server.Server - jetty-9.2.19.v20160908
[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@3f4b840d{/api,null,AVAILABLE}
[main] INFO org.eclipse.jetty.server.handler.ContextHandler - Started o.e.j.s.ServletContextHandler@2f2d52ef{/console,null,AVAILABLE}
[main] INFO org.eclipse.jetty.server.ServerConnector - Started ServerConnector@7cdbff9b{HTTP/1.1}{0.0.0.0:8082}
[main] INFO org.eclipse.jetty.server.Server - Started @8711ms

I restared traccer.