Database Table Error

Mohan lal4 years ago

I'm using Traccar server from last 1 year but last couple of days suddenly i'm getting following error:

2020-05-30 12:10:05  WARN: Event save error - Table 'traccar_db.td' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:458 < NotificationManager:65 < ...)
2020-05-30 12:10:05  WARN: [32f15fef] error - An existing connection was forcibly closed by the remote host - IOException (...)
2020-05-30 12:10:05  INFO: [32f15fef] disconnected
2020-05-30 12:10:05  WARN: Event save error - Table 'traccar_db.td' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:458 < NotificationManager:65 < ...)

What's the solution for it?

Thanks

Anton Tananaev4 years ago

Why would it look for td table? Sounds like you have some customization that you forgot to mention.

Mohan lal4 years ago

Hello Anton,
customization done by you. I asked to you and you did this.
Data need to send a URL and you added forwarded URL with query string. Nothing else.

Application running on Windows server.

Thanks

Anton Tananaev4 years ago

Well, you still have to clearly mention. I only provide free support here for official version. If you need support with your custom version, we have paid support services.

Mohan lal4 years ago

But that time i paid to you and told you that i'll use it for my personal device tracking.

Anton Tananaev4 years ago

If you have some complaint about paid work, it's also can be done via support email.

Mohan lal4 years ago

Last time you gave me paid support for AIS-140 and it was for same version on which i'm getting this Warning alert.

2020-06-11 10:54:58  WARN: [519d70ab] error - An existing connection was forcibly closed by the remote host - IOException (...)
2020-06-11 10:54:58  INFO: [519d70ab] disconnected
2020-06-11 10:54:58  WARN: Event save error - Table 'traccar_db.td' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:458 < NotificationManager:65 < ...)
2020-06-11 10:54:58  INFO: [4d02ea93: gt06 < 185.15.14.132] HEX: 78780a134406040000009f759b0d0a
2020-06-11 10:54:58  INFO: [4d02ea93: gt06 > 185.15.14.132] HEX: 78780513009f94060d0a
2020-06-11 10:54:58  INFO: [5871d672: its < 117.243.10.98] HEX: 244e524d2c524f41445250412c322e334149532c4e522c30312c4c2c3836393836373033353938353933382c2c312c31313036323032302c3130353530362c31392e38373737323333332c4e2c37352e33313736333636372c452c302e302c3138382e30302c31352c3632322e322c312e30302c302e36302c43656c6c4f6e65204d616861726173687472612c312c312c31342e322c342e322c302c432c31372c3430342c36362c323533442c354232342c31372c323533442c363731352c31362c323533442c354135422c31312c323533442c354132392c31302c323533442c354245332c313130302c30302c302c302c3031303631372c35303932302e3430302c2c2c2c2c355f355f355f352c39304132433030332a
2020-06-11 10:54:58  INFO: [4d02ea93] id: 358657100308050, time: 2020-06-11 10:52:57, lat: 26.18052, lon: 78.15198, course: 192.0
2020-06-11 10:54:58  INFO: [5871d672] id: 869867035985938, time: 2020-06-11 10:55:06, lat: 19.87772, lon: 75.31764, course: 188.0
2020-06-11 10:54:58  WARN: [a635b51f] error - An existing connection was forcibly closed by the remote host - IOException (...)
2020-06-11 10:54:58  INFO: [a635b51f] disconnected
2020-06-11 10:54:58  WARN: Event save error - Table 'traccar_db.td' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:480 < DataManager:458 < NotificationManager:65 < ...)
2020-06-11 10:54:58  INFO: [5d1fbd1d] connected

Most issue i'm facing that some time device stop and it does not come online even data getting the server. It's happened randomly.
sometime happen new device could not come online?

Please help for this.

Mohan lal4 years ago

Uninstalled the application and installed latest version again. Now above issue has been resolved. Now i'm facing following issues:

 WARN: [df0aed68] error - readerIndex(8) + length(1) exceeds writerIndex(8): PooledSlicedByteBuf(ridx: 8, widx: 8, cap: 8/8, unwrapped: PooledDirectByteBuf(ridx: 8, widx: 8, cap: 1024)) - IndexOutOfBoundsException (... < Gt06ProtocolDecoder:216 < *:727 < *:524 < *:1198 < ExtendedObjectDecoder:51 < ... < WrapperContext:102 < ...)
2020-06-13 11:03:01  INFO: [df0aed68] disconnected
2020-06-13 11:03:01  INFO: [68a39562] connected
2020-06-13 11:03:01  INFO: [965a005f] connected
2020-06-13 11:03:01  INFO: [d1ef7a46] connected
2020-06-13 11:03:01  INFO: [d1ef7a46: h02 < 223.180.224.58] HEX: 2a48512c3836353230353033363339373639322c563023
2020-06-13 11:03:01  INFO: [d1ef7a46: h02 > 223.180.224.58] HEX: 2a48512c3836353230353033363339373639322c563023
2020-06-13 11:03:01  INFO: [71ea5435] connected
2020-06-13 11:03:01  INFO: [965a005f: gt06 < 223.224.72.154] HEX: 78780d01086144204002630601c309440d0a
2020-06-13 11:03:01  INFO: [965a005f: gt06 > 223.224.72.154] HEX: 7878050101c3251a0d0a
2020-06-13 11:03:01  WARN: [c2dbbd92] error - An existing connection was forcibly closed by the remote host - IOException (...)
2020-06-13 11:03:01  INFO: [c2dbbd92] disconnected
2020-06-13 11:03:01  INFO: [0297f7c7] connected
2020-06-13 11:03:01  WARN: [a92fced4] error - An existing connection was forcibly closed by the remote host - IOException (...)
2020-06-13 11:03:01  INFO: [a92fced4] disconnected
2020-06-13 11:03:01  INFO: [71d3d5fe] connected
2020-06-13 11:03:01  WARN: [651fb677] error - An existing connection was forcibly closed by the remote host - IOException (...)
2020-06-13 11:03:01  INFO: [651fb677] disconnected

Two issues are coming one forcibly closed and another readerIndex(8). What is the solution?

Anton Tananaev4 years ago

Look like device issues to me.