Data stop coming in MYSQL database

sachin5 years ago

this is the log file content, thank you in advance for your support.

FINEST|29879/0|Service traccar|19-01-02 00:35:33|[qtp448313346-73716] WARN org.eclipse.jetty.http.HttpParser - Illegal character 0x16 in state=START for buffer HeapByteBuffer@2$
FINEST|29879/0|Service traccar|19-01-02 00:35:33|[qtp448313346-73716] WARN org.eclipse.jetty.http.HttpParser - badMessage: 400 Illegal character 0x16 for HttpChannelOverHttp@5d$
FINEST|29879/0|Service traccar|19-01-02 05:36:59|[qtp448313346-74146] WARN org.eclipse.jetty.http.HttpParser - Illegal character 0x16 in state=START for buffer HeapByteBuffer@4$
FINEST|29879/0|Service traccar|19-01-02 05:36:59|[qtp448313346-74146] WARN org.eclipse.jetty.http.HttpParser - badMessage: 400 Illegal character 0x16 for HttpChannelOverHttp@40$
FINEST|29879/0|Service traccar|19-01-02 05:46:52|[New I/O worker #9] WARN com.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Connection com.mysql.jdbc.JDBC4Connection@4895$
FINEST|29879/0|Service traccar|19-01-02 05:46:52|[New I/O worker #10] WARN com.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Connection com.mysql.jdbc.JDBC4Connection@397$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
FINEST|29879/0|Service traccar|19-01-02 05:46:53|
FINEST|29879/0|Service traccar|19-01-02 05:46:53|The last packet successfully received from the server was 4,404 milliseconds ago.  The last packet sent successfully to the ser$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at sun.reflect.GeneratedConstructorAccessor126.newInstance(Unknown Source)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3459)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3900)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.database.QueryBuilder.executeUpdate(QueryBuilder.java:477)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.database.DataManager.addObject(DataManager.java:448)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.DefaultDataHandler.handlePosition(DefaultDataHandler.java:27)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.BaseDataHandler.decode(BaseDataHandler.java:29)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:66)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:68)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:68)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.GeocoderHandler$1.onFailure(GeocoderHandler.java:75)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.geocoder.JsonGeocoder.handleResponse(JsonGeocoder.java:69)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.geocoder.JsonGeocoder.access$000(JsonGeocoder.java:34)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.traccar.geocoder.JsonGeocoder$2.onCompleted(JsonGeocoder.java:96)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.AsyncCompletionHandler.onCompleted(AsyncCompletionHandler.java:55)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.providers.netty.future.NettyResponseFuture.getContent(NettyResponseFuture.java:177)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.providers.netty.future.NettyResponseFuture.done(NettyResponseFuture.java:214)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.providers.netty.handler.HttpProtocol.finishUpdate(HttpProtocol.java:194)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.providers.netty.handler.HttpProtocol.handleChunk(HttpProtocol.java:451)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.providers.netty.handler.HttpProtocol.handle(HttpProtocol.java:474)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at com.ning.http.client.providers.netty.handler.Processor.messageReceived(Processor.java:88)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:$
FINEST|29879/0|Service traccar|19-01-02 05:46:53|       at org.jboss.netty.handler.codec.http.HttpContentDecoder.messageReceived(HttpContentDecoder.java:135)
Anton Tananaev5 years ago

Try increasing MySQL connection timeout.

sachin5 years ago

Hi,

Next day it start coming.
Can you tell if i want to see what hexa response i am getting from device, where and how i can see, as in mysql it is storing after converting like this

{"sat":3,"ignition":true,"distance":28.01,"totalDistance":8828045.36,"motion":true}

Regards