CQRLOG started to behave strangely

7 posts / 0 new
Last post
dk7ob
CQRLOG started to behave strangely

Just of a sudden, CQRLOG gives this message when I open the QSO list:

TMySQL57Connection : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) as foo' at line 1.

Press OK to ignore and risk data corruption
Press Abort to kill the program.

I started cqrlog in the console woth --debug=1 and get the attached log.

I am running Kubuntu 18.04 and I'm not aware of any changes.

(cqrlog:4911): Gtk-WARNING **: 20:59:09.472: Unable to locate theme engine in module_path: "adwaita",

(cqrlog:4911): Gtk-WARNING **: 20:59:09.485: Unable to locate theme engine in module_path: "adwaita",

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/wofritz/
Program home directory: /home/wofritz/.config/cqrlog/
Data directory: /home/wofritz/.config/cqrlog/database/
Memebers directory: /home/wofritz/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/wofritz/.config/cqrlog/database/mysql.cnf --datadir=/home/wofritz/.config/cqrlog/database/ --socket=/home/wofritz/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

SELECT * FROM cqrlog_config

select * from db_version

[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

Settings:
-----------------------------------------------------
RigCtldPath:/usr/local/bin/rigctld
RigCtldArgs:-m 237 -r /dev/ttyUSBTS590 -t 4532 -s 115200
RunRigCtld: FALSE
RigDevice: /dev/ttyUSBTS590
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 237

rigctld started!
Connected to localhost:4532

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1

rotctld started!
Connected to localhost:4533
FreqmemSql:select id,freq,mode,bandwidth from freqmem order by id

FreqmemFirst:0 FreqmemLast:0
Sending: fmv

CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in ())) as foo

TApplication.HandleException TMySQL57Connection : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) as foo' at line 1
Stack trace:
$000000000091B09F
$000000000091C788
$000000000044CFA6
$0000000000431FAF
$0000000000658D8D
$000000000044F182
$0000000000664BB8
$00000000006567C1
$00000000006566F1
$0000000000452C89
$0000000000654AC7
$000000000066FB7C
$000000000066C5DE
$000000000044C9FB
$0000000000451B5C
$00000000004F3A67
$0000000000810B6D
Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlog.cfg
Deleting config file: cqrlog.cfg
Closing dData
/home/wofritz/.config/cqrlog/database/eddie.pid
Command:
kill 4916
WARNING: TMenuItem.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?

yo4fzv
Same to me

The same thing happened to me today. I use Ubuntu 18.04LTS.

yo4fzv
I paste here response from

I paste here response from cqrlog --debug=1

yo4fzv@yo4fzv-K53SM:~$ cqrlog --debug=1

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
/home/yo4fzv/.config/cqrlog/database/yo4fzv-K53SM.pid
Command:
kill 6289
*
User home directory: /home/yo4fzv/
Program home directory: /home/yo4fzv/.config/cqrlog/
Data directory: /home/yo4fzv/.config/cqrlog/database/
Memebers directory: /home/yo4fzv/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/yo4fzv/.config/cqrlog/database/mysql.cnf --datadir=/home/yo4fzv/.config/cqrlog/database/ --socket=/home/yo4fzv/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

SELECT * FROM cqrlog_config

select * from db_version

[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 1 -r -t 4532
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1

1
2
3
4
5
6

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1

rotctld started!
Connected to localhost:4533
FreqmemSql:select id,freq,mode,bandwidth from freqmem order by id

FreqmemFirst:0 FreqmemLast:0
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

select * from view_cqrlog_main_by_qsodate where qsodate >= '2018-07-08' order by qsodate,time_on

LoadForm: frmNewQSO
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in ())) as foo

TApplication.HandleException TMySQL57Connection : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) as foo' at line 1
Stack trace:
$000000000091B09F
$000000000091C788
$000000000044CFA6
$0000000000431FAF
$0000000000658D8D
$000000000044F182
$0000000000664BB8
$00000000006567C1
$00000000006566F1
$0000000000452C89
$0000000000654AC7
$000000000066FB7C
$000000000066C5DE
$000000000044C9FB
$0000000000451B5C
$00000000004F870E
$00000000006B22CA
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/yo4fzv/.config/cqrlog/database/yo4fzv-K53SM.pid
Command:
kill 8966
WARNING: TMenuItem.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
Closing ini file ...

KB9TT
Same here

Same thing happened to me tonight.
Ken
KB9TT

dk7ob
Be careful and make a backup before testing

I lost many QSOs in the data base while playing with the problem. They are also missing in the backup adif files. Fortunately I have a good adif backup file that only misses the 3 QSOs I made after the problem began and a full data base backup from June 28.

Ken, are you also running Ubuntu 18.04?

dk7ob
How to reproduce the problem

I can now reliably reproduce the problem.

When I start cqrlog with my working backup data base, it asks if new DXCC and QSL manager lists should be downloaded. If I reject this, cqrlog keeps working fine.

If I allow the downloads, leave cqrlog and start again, it gives the error message when I open the QSO list window.

I attached a file with debug output for the good and the bad case. First part is the good case, the bad case starts after the line "BAD BAD BAD ......"

File: 

oh1kh
see this thread

--
Saku
OH1KH