error - NullPointerException

ia9 years ago

Hi,

First of all, this is a great script, thank you for all your continuing work!

Now, I am using an Ulbotech tracker. I spent many hours trying to get it to work in text mode until I found a post where you say only binary mode works.

Switching to binary did the trick, the database now updates.

However, I believe not all data is being inserted and I have these errors in my log file:

2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  INFO: [2BD4E515] disconnected
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:181 < ExtendedObjectDecoder:39 < ...)

I am using the 3.3 release, downloaded from github, and mysql database.

Do you know what the problem might be?

Thanks!

Anton Tananaev9 years ago

Please provide full log, not just error messages.

ia9 years ago

Here's an extract:

2016-02-16 18:33:38  INFO: [0ABE2798] connected
2016-02-16 18:33:40 DEBUG: [0ABE2798: 5072 < 212.5.158.130] HEX: f8010108679650230642039e562748010e0293317801a9e28f0016007200bf03040a42000004040000742b0506038417762204070d31055e410c2369310d00311c06090553017101221001016c89f8f8010108679650230642039e562752010e0293307101a9e6060015007400f70f03040a42000004040000742b05060385177a2204070d310561410c1dce310d00311c06090553017101221001019a99f8f8010108679650230642039e56275c010e02932e9801a9e7b600080097008303040a42000004040000742b0506038617832204070d310561410c0c64310d00311c06090553017101221001012764f8f8010108679650230642039e562766010e02932e7201a9e8c800030000009403040a42000004040000742b0506038a17872204070d310563410c0cf4310d00311c0609055301710122100101193bf8f8010108679650230642039e562770010e02932f3001a9e7310016015a008303040a42000004040000742b05060386178b2204070d310565410c16d8310d00311c0609055301710122100101a18af8f8010108679650230642039e56277a010e029330ec01a9e4490024012400fa03040a42000004040000742b0506038017902204070d310567410c1e97310d00311c06090553017101221001011fa5f8f8010108679650230642039e562784010e029331fa01a9e289000a015e009403040a42000004040000742b0506038717902205070d31056a410c0c97310d00311c0609055301710122100101c200f8f8010108679650230642039e56278e010e0293329901a9e33200060000009403040a42000004040000742b0506038617982205070d31056b410c103a310d00311c0609055301710122100101fc83f8f8010108679650230642039e562798010e029332a401a9e3a400010000009403040a42000004040000742b0506038117a12205070d31056d410c0c8c310d00311c06090553017101221001015863f8f8010108679650230642039e5627a2010e029332be01a9e33a00020000008303040a42000004040000742b05060387179c2205070d31056d410c1666310d00311c0609055301710122100101090ff8f8010108679650230642039e5627a9010e0293328301a9e34a00030000009403040842000004040000742b0506035e179c2205070d31056d410c0000310d00311c06090553017101221005f0000002001307f8f8010108679650230642039e5627ac010e0293327801a9e39e00070049009403040842000004040000742b0506035b17a12205070d31056d410c0000310d00311c06090553017101221001016caef8f8010108679650230642039e5627ba010e0293321f01a9e4020003000000cc03040a42000004040000742c0506038b17a52205090553017101221005f0000002003cf0f8f80101
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  INFO: [0ABE2798] disconnected
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:40  WARN: [0ABE2798] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:181 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:41  INFO: [2BD4E515] connected
2016-02-16 18:33:43 DEBUG: [2BD4E515: 5072 < 212.5.158.130] HEX: f8010108679650230642039e562748010e0293317801a9e28f0016007200bf03040a42000004040000742b0506038417762204070d31055e410c2369310d00311c06090553017101221001016c89f8f8010108679650230642039e562752010e0293307101a9e6060015007400f70f03040a42000004040000742b05060385177a2204070d310561410c1dce310d00311c06090553017101221001019a99f8f8010108679650230642039e56275c010e02932e9801a9e7b600080097008303040a42000004040000742b0506038617832204070d310561410c0c64310d00311c06090553017101221001012764f8f8010108679650230642039e562766010e02932e7201a9e8c800030000009403040a42000004040000742b0506038a17872204070d310563410c0cf4310d00311c0609055301710122100101193bf8f8010108679650230642039e562770010e02932f3001a9e7310016015a008303040a42000004040000742b05060386178b2204070d310565410c16d8310d00311c0609055301710122100101a18af8f8010108679650230642039e56277a010e029330ec01a9e4490024012400fa03040a42000004040000742b0506038017902204070d310567410c1e97310d00311c06090553017101221001011fa5f8f8010108679650230642039e562784010e029331fa01a9e289000a015e009403040a42000004040000742b0506038717902205070d31056a410c0c97310d00311c0609055301710122100101c200f8f8010108679650230642039e56278e010e0293329901a9e33200060000009403040a42000004040000742b0506038617982205070d31056b410c103a310d00311c0609055301710122100101fc83f8f8010108679650230642039e562798010e029332a401a9e3a400010000009403040a42000004040000742b0506038117a12205070d31056d410c0c8c310d00311c06090553017101221001015863f8f8010108679650230642039e5627a2010e029332be01a9e33a00020000008303040a42000004040000742b05060387179c2205070d31056d410c1666310d00311c0609055301710122100101090ff8f8010108679650230642039e5627a9010e0293328301a9e34a00030000009403040842000004040000742b0506035e179c2205070d31056d410c0000310d00311c06090553017101221005f0000002001307f8f8010108679650230642039e5627ac010e0293327801a9e39e00070049009403040842000004040000742b0506035b17a12205070d31056d410c0000310d00311c06090553017101221001016caef8f8010108679650230642039e5627ba010e0293321f01a9e4020003000000cc03040a42000004040000742c0506038b17a52205090553017101221005f0000002003cf0f8f80101
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  INFO: [2BD4E515] disconnected
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:43  WARN: [2BD4E515] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:181 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:44  INFO: [0EA54886] connected
2016-02-16 18:33:46 DEBUG: [0EA54886: 5072 < 212.5.158.130] HEX: f8010108679650230642039e562748010e0293317801a9e28f0016007200bf03040a42000004040000742b0506038417762204070d31055e410c2369310d00311c06090553017101221001016c89f8f8010108679650230642039e562752010e0293307101a9e6060015007400f70f03040a42000004040000742b05060385177a2204070d310561410c1dce310d00311c06090553017101221001019a99f8f8010108679650230642039e56275c010e02932e9801a9e7b600080097008303040a42000004040000742b0506038617832204070d310561410c0c64310d00311c06090553017101221001012764f8f8010108679650230642039e562766010e02932e7201a9e8c800030000009403040a42000004040000742b0506038a17872204070d310563410c0cf4310d00311c0609055301710122100101193bf8f8010108679650230642039e562770010e02932f3001a9e7310016015a008303040a42000004040000742b05060386178b2204070d310565410c16d8310d00311c0609055301710122100101a18af8f8010108679650230642039e56277a010e029330ec01a9e4490024012400fa03040a42000004040000742b0506038017902204070d310567410c1e97310d00311c06090553017101221001011fa5f8f8010108679650230642039e562784010e029331fa01a9e289000a015e009403040a42000004040000742b0506038717902205070d31056a410c0c97310d00311c0609055301710122100101c200f8f8010108679650230642039e56278e010e0293329901a9e33200060000009403040a42000004040000742b0506038617982205070d31056b410c103a310d00311c0609055301710122100101fc83f8f8010108679650230642039e562798010e029332a401a9e3a400010000009403040a42000004040000742b0506038117a12205070d31056d410c0c8c310d00311c06090553017101221001015863f8f8010108679650230642039e5627a2010e029332be01a9e33a00020000008303040a42000004040000742b05060387179c2205070d31056d410c1666310d00311c0609055301710122100101090ff8f8010108679650230642039e5627a9010e0293328301a9e34a00030000009403040842000004040000742b0506035e179c2205070d31056d410c0000310d00311c06090553017101221005f0000002001307f8f8010108679650230642039e5627ac010e0293327801a9e39e00070049009403040842000004040000742b0506035b17a12205070d31056d410c0000310d00311c06090553017101221001016caef8f8010108679650230642039e5627ba010e0293321f01a9e4020003000000cc03040a42000004040000742c0506038b17a52205090553017101221005f0000002003cf0f8f80101
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  INFO: [0EA54886] disconnected
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:173 < ExtendedObjectDecoder:39 < ...)
2016-02-16 18:33:46  WARN: [0EA54886] error - NullPointerException (Extensible:56 < UlbotechProtocolDecoder:63 < *:181 < ExtendedObjectDecoder:39 < ...)
Anton Tananaev9 years ago

It works for me. What version of Traccar are you using?

ia9 years ago

3.3

Anton Tananaev9 years ago

Try this version:

https://www.dropbox.com/s/cgmlansv32j3ii0/tracker-server.jar?dl=0

ia9 years ago

Yay, those errors are now gone!

I have a couple new ones though...

2016-02-16 21:38:35  INFO: [BB7D6A2F] connected
2016-02-16 21:38:36 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: 2a545330312c38363739363530323330363432303323
2016-02-16 21:42:51 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e565454010e0293328301a9e2770000000000aa030400400000040400007432050603391710220f1005f000000040f5d7f8
2016-02-16 21:42:54 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e56545b010e0293328001a9e2900001000000920304024000000404000074320506038f170b220f1005f000000200508bf8
2016-02-16 21:43:09 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e56546b010e029332b801a9e27c0002000000cf03040200000004040000743d050603861707220f1005f00000004012caf8
2016-02-16 21:43:21 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e565471010e029332a501a9e25f0001000000990304024200000404000074400506038c170b220f1005f0000000428cd4f8
2016-02-16 21:44:02 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e56547b010e029332ad01a9e29e00050000009203040242000004040000744605060384170b220f10010132adf8
2016-02-16 21:44:05 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e565485010e0293333401a9e35500070023009203040242000004040000745905060388170b220f1001018f09f8f8010108679650230642039e56548f010e029333e101a9e537000a003600cf0304024200000404000074780506037f1710220f100101985cf8f8010108679650230642039e565499010e0293326101a9e709000e00a000cf0304024200000404000074990506038a1710220f100101e194f8f8010108679650230642039e56549b010e0293327201a9e7d2000c009a00ec0304020200000404000074a1050603881710220f1005f000000040a1e4f8f8010108679650230642031e5654a3010e029331a101a9e8770010009801350304020200000404000074c30506038b1710220f10010128aaf8
2016-02-16 21:44:05  WARN: Incorrect string value: '\xD0\x94-\xD1\x80 ...' for column 'address' at row 1 - SQLException (... < QueryBuilder:431 < DataManager:306 < DefaultDataHandler:27 < ...)
2016-02-16 21:44:19 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e5654b2010e02932ecc01a9e9be000d00bd009203040242000004040000750e050603871710220f1005f000000040754ef8
2016-02-16 21:44:31 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e5654bc010e02932e0901a9e7fc000700f300920304024200000404000075340506038c1710220f1001016114f8
2016-02-16 21:44:39 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e5654c6010e02932c6101a9e72c001500be009203040242000004040000755d050603881710220f10010131aef8
2016-02-16 21:44:39  WARN: Incorrect string value: '\xD0\x93\xD0\xB0\xD0\xB1...' for column 'address' at row 1 - SQLException (... < QueryBuilder:431 < DataManager:306 < DefaultDataHandler:27 < ...)
2016-02-16 21:44:49 DEBUG: [BB7D6A2F: 5072 < 212.5.158.139] HEX: f8010108679650230642039e5654d0010e02932b7201a9e6160002000000b203040242000004040000758a0506038c1710220f100101d1f3f8

It then goes on without error...

Anton Tananaev9 years ago

See the following thread:

https://www.traccar.org/forums/topic/mysql-error-change/

ia9 years ago

It works!! Thank you so much for your help.

Here is the solution that worked for me. The database collation was indeed not utf8 but latin1. So:

ALTER SCHEMA my_database DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8mb4_general_ci ; 

ALTER TABLE all_of_them CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Did the trick beautifully!