What is step 21

[dterweij]

[danny@server03 acarsserv]$ ./acarsserv -j 192.168.0.91:5555
step 21
step 21
step 21
step 21
step 21
step 21
step 21
step 21

What is step 21 ?

[TLeconte]

It's an error return when calling sqlite3_step (error 21 = MISUSE).
I have to understand where is the error ....
I does not necesserely means that it does not works.

[TLeconte]

I do not reproduce it...

Do you use the very last versions ?
Do you use acarsdec or vdlm2dec as source ?
One or many sources ?

I fear it depends of the received messages.
When you see step 21, could you restart acarsserv with -v and send me the output

[dterweij]

The database file is not populated. It adds the first seen message, then the step 21 pops up.

[danny@server03 acarsserv]$ ./acarsserv -v -s -j 192.168.0.91:5555
MSG ip='192.168.0.98' chan='131725000' mode='X' reg='.G-LCYK' ack='' lbl='Q0' blk='7' msgno='M18A' flt='CJ8495' txt=''
step 21
MSG ip='192.168.0.98' chan='131725000' mode='E' reg='.PH-HXB' ack='' lbl='Q0' blk='4' msgno='S30A' flt='HV044X' txt=''

Using acarsdec

All latest versions from git pull.

I made a php test file to read some fields from Flights and Messages so i can monitor if something is added or not.

[dterweij]

Some more:

step 21
MSG ip='192.168.0.98' chan='131824999' mode='2' reg='..B-KPH' ack='' lbl='32' blk='4' msgno='M60A' flt='CX0250' txt='APR,V04,CX 250 20180221 1,0+52.725,+009.038,330,085700'
step 21
MSG ip='192.168.0.98' chan='131824999' mode='2' reg='..B-KPW' ack='' lbl='BA' blk='9' msgno='L82A' flt='CX0253' txt='/MSTEC7X.AT1..B-KPW618932DA003724'
step 21
MSG ip='192.168.0.98' chan='131725000' mode='X' reg='.D-ABOE' ack='' lbl='Q0' blk='1' msgno='S07A' flt='DE03EA' txt=''
step 21
MSG ip='192.168.0.98' chan='131725000' mode='G' reg='.D-ABOE' ack='' lbl='Q0' blk='3' msgno='S09A' flt='DE03EA' txt=''
step 21
MSG ip='192.168.0.98' chan='131824999' mode='2' reg='.PH-EXP' ack='' lbl='B9' blk='1' msgno='M14A' flt='KL1150' txt='/EHAM.TI2/024EHAMA687E'
step 21
MSG ip='192.168.0.98' chan='131824999' mode='2' reg='.PH-EXP' ack='R' lbl='_d' blk='2' msgno='M15A' flt='KL1150' txt=''
step 21
MSG ip='192.168.0.98' chan='131824999' mode='2' reg='.PH-EXP' ack='S' lbl='_d' blk='3' msgno='M16A' flt='KL1150' txt=''

[TLeconte]

???? could not find the problem.
I have commited a new version with more debug info.
If you could try it ...
The very first message is important, after the error you will have the error for each messages.

Do you have the problem without the -s ?

[dterweij]

Oh that is a bad one :)

Without -s same step 21 error.

[danny@server03 acarsserv]$ git pull
remote: Counting objects: 3, done.
remote: Compressing objects: 100% (1/1), done.
remote: Total 3 (delta 2), reused 3 (delta 2), pack-reused 0
Unpacking objects: 100% (3/3), done.
From https://github.com/TLeconte/acarsserv
   078210e..6ce3128  master     -> origin/master
Updating 078210e..6ce3128
Fast-forward
 dbmgn.c | 145 ++++++++++++++++++++++++++--------------------------------------
 1 file changed, 59 insertions(+), 86 deletions(-)


[danny@server03 acarsserv]$ make -f Makefile
cc -Wall -pthread  -I.     -c -o dbmgn.o dbmgn.c
dbmgn.c: In function ‘initdb’:
dbmgn.c:34: warning: implicit declaration of function ‘sqlite3_errstr’
dbmgn.c:34: warning: format ‘%s’ expects type ‘char *’, but argument 4 has type ‘int’
dbmgn.c:65: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:73: warning: format ‘%s’ expects type ‘char *’, but argument 4 has type ‘int’
dbmgn.c: In function ‘updatedb_st’:
dbmgn.c:91: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:98: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:105: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:114: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:121: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:128: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:134: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:143: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c: In function ‘updatedb_fl’:
dbmgn.c:163: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:169: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:175: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:180: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:189: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:195: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:200: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:205: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:210: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:221: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:227: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:232: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:237: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:242: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c: In function ‘updatedb_ms’:
dbmgn.c:259: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:265: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:271: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:281: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:286: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:291: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:296: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:301: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:306: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:311: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:316: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:321: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:326: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:331: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:336: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:341: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c:347: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
dbmgn.c: In function ‘updatedb’:
dbmgn.c:365: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’
cc -Ofast acarsserv.o dbmgn.o cJSON.o -o acarsserv -lsqlite3
dbmgn.o: In function `initdb':
dbmgn.c:(.text+0x41): undefined reference to `sqlite3_errstr'
dbmgn.c:(.text+0xf9): undefined reference to `sqlite3_errstr'
dbmgn.c:(.text+0x17f): undefined reference to `sqlite3_errstr'
dbmgn.o: In function `updatedb_st':
dbmgn.c:(.text+0x215): undefined reference to `sqlite3_errstr'
dbmgn.c:(.text+0x282): undefined reference to `sqlite3_errstr'
dbmgn.o:dbmgn.c:(.text+0x2ef): more undefined references to `sqlite3_errstr' follow
collect2: ld returned 1 exit status
make: *** [acarsserv] Error 1
[danny@server03 acarsserv]$

[danny@server03 acarsserv]$ sqlite3 --version
3.6.20

[TLeconte]

I use libsqlite3 0.8.6
sqlite3 --version
3.20.1

It seems that the function sqlite3_errstr is not available with your version. It's why there are all these compile errors.

Go back to the previous version, and what I really need is the first bad received message. (the one just after the first step 21 error., other messages are not useful for me.
Perhaps it's a problem of libsqlite3 version ....