CQRLOG starts the freezes

2 posts / 0 new
Last post
CQRLOG starts the freezes

After starting CQRLog I get an exception. I can choose a log and it displays normally then freezes.

So far:
Installed the Linux Mint (Ubuntu) version of CQRLog
I have installed mariadb-server over mysql
Reinstalled CQRLog
Reinstalled mariadb-server

Below is the debug output from CQRLog

73 de Graeme ZL2APV

Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****

Linux version 5.15.0-52-generic (buildd@lcy02-amd64-032) (gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #58-Ubuntu SMP Thu Oct 13 08:03:55 UTC 2022
SSL libraries:
Loaded 179909 LoTW users
Loaded 158514 eQSL users
Loaded 59943 SCP calls
p.Executable: kill Parameters: 5095

User home directory: /home/gvj/
Program home directory: /home/gvj/.config/cqrlog/
Data directory: /home/gvj/.config/cqrlog/database/
Memebers directory: /home/gvj/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
56 us states loaded
Grid map created
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/gvj/.config/cqrlog/database/mysql.cnf

Trying to connect to database
TMySQL57Connection : Server connect failed.
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: 18 cDB_MAIN_VER: 18
select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.bands

RigCtldArgs:-m 2 -t 4532
RunRigCtld: FALSE
RigPoll: 500
RigId: 2

Not started rigctld process. (Run is set FALSE)
Connected to rigctld @ localhost:4532
Radio1 CW settings:
CW init keyer type:1
Last error nr: 9
Last error desc:Bad file number
Speed: 30
CW keyer reloaded by TRControl radio1 change

RotCtldArgs:-m 1 -t 4533
RunRotCtld: FALSE
RotPoll: 500
RotId: 1

Not started rotctld process. (Run is set FALSE)
Connected to rotctld @ localhost:4533
FreqmemSql:select id,freq,mode,bandwidth,info from freqmem order by id

FreqmemFirst:0 FreqmemLast:0
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 (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND (qsl_r = 'Q')) as foo

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

Wrong image format
Sending: fmv

Please enter your call:

Local users = 108

Current spot rate is 16308 per hour

ZL2APV de SK1MMR-1 08-Nov-2022 19:59Z >

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

DX de KM3T-#: 21010.0 PS7DX CW 8 dB 19 WPM CQ 1959Z
Signal: 8*
*Freq: 21010.0*
call: PS7DX spotter:KM3T stren: 8 freq: 21010.0 band: 15M Lat: 39.98N Long: 76.88W
Hello Graeme, this is ZL2ARN-10 in Waikanae, Kapiti Coast, New Zealand
running DXSpider V1.55 build 249
Capabilities: ve7cc
Welcome to the South Pacific DXSpider Cluster Network
This Cluster is running on a Raspberry Pi4, and is using
The DXSpider User Manual can be found at:-
Nodes: 13/408 Users [Loc/Clr]: 14/4615 Max: 25/6957 - Uptime: 29d 38m
Please enter your QTH, set/qth
Please enter your location with set/location or set/qra
Please enter your Home Node, set/homenode
ZL2APV de ZL2ARN-10 8-Nov-2022 1959Z dxspider >
pos: 48 len:48
Chat : line is cluster prompt!
Sending: fmv

DX de KM3T-#: 14032.4 KA1EFO CW 9 dB 22 WPM CQ Found - PS7DX
select id_cqrlog_main from cqrlog_main where (callsign= :callsign) and (band = :band) and (mode = :mode) and (str_to_date(concat(qsodate, ' ',time_on), '%Y-%m-%d %H:%i')) > str_to_date(:last_date_time, '%Y-%m-%d %H:%i')

Found - KA1EFO
select 1959Z
Signal: 9*
*Freq: 14032.4*
call: KA1EFO spotter:KM3T stren: 9 freq: 14032.4 band: 20M Lat: 39.98N Long: 76.88W
Sending: fmv

Sending: fmv

[FORMS.PP] ExceptionOccurred
Exception=Access violation
Stack trace:
[FORMS.PP] ExceptionOccurred

CQRLOG starts the freezes


Forms.PP exception is one of errors that actually comes from GTK (graphics handler) and it is a bit hard to catch. Is your Mint a new one? Could it have GTK3 that runs GTK2 programs (like Cqrlog) in some kind of legacy mode?

What I am seeing is that you use rigctld model #2 Net Hamlib rigcld as rig. How ever there is no connection to any (outside) running rigctld as the polling "fmv" does not get any response.

Also it seems that CW keyer is defined as Winkeyer but there is no I/O port for device .

These are things that *may* cause problems. I have found source code parts where control (rig, cq key, etc.) are tried to access even when initialization has failed. I can not remember what versions have those fixes.

I suggest following:

Compile Cqrlog from GitHub source. You will get latest 2.6.0 version from there. Here are some examples how it happens:
New Ubuntu and latest cqrlog https://www.cqrlog.com/node/2984
Mint 20 Cinnamon and new cqrlog https://www.cqrlog.com/node/2998

If you do not want to compile you find a newupdate.zip that holds newupdate.sh script that can backup and update your current version of Cqrlog. From there you find also version 2.6.0. See : https://github.com/OH1KH/cqrlog/tree/loc_testing/compiled

You could also try QT5 graphics version of Cqrlog. Either by self compile or via update script. Then you need to install packages
libqt5pas1 libqt5pas-dev before trying. They may also install some dependency packages automated.

Version 2.6.0 has several fixes and you can also define rig model #1 Hamlib dummy for use if you do not have CAT connected radio.
That way you can enter used mode and frequency via TRXControl that is easier way to get right values to NewQSO for logging.