CQRLOG runs slow

10 posts / 0 new
Last post
in3klq
CQRLOG runs slow

Hi to all!

Using Cqrlog Ver: 2.5.2 on ubuntu 20.04.3 Gnome 3.36.8

I Trying to understand this little problem I think occurred after a system update released last week.

When I open CQRLog I get a pop-up message saying "CQRLog is not responding" and I can choose to click "Force Quit" and "Wait". I click on wait, I wait about 30 -40 seconds and Cqrlog opens regularly!

if I run the cqrlog program from the console, this happens:

cqrlog --debug
Gtk-Message: 17:07:41.281: Failed to load module "canberra-gtk-module"

Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

OS:
Linux version 5.11.0-40-generic (buildd@lgw01-amd64-010) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #44~20.04.2-Ubuntu SMP Tue Oct 26 18:07:44 UTC 2021
/usr/bin/mysqld
2021-11-14 17:08:11 0 [Note] /usr/sbin/mysqld (mysqld 10.3.31-MariaDB-0ubuntu0.20.04.1) starting as process 5353 ...

Please note the time to run!

I found on the forum, a post of mine from May you can read that the execution of the program was a few seconds ..

cqrlog --debug
Gtk-Message: 19:00:42.975: Failed to load module "canberra-gtk-module"
Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****
OS:
Linux version 5.8.0-53-generic (buildd@lcy01-amd64-012) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #60~20.04.1-Ubuntu SMP Thu May 6 09:52:46 UTC 2021
/usr/bin/mysqld
2021-05-30 19:00:45 0 [Note] /usr/sbin/mysqld (mysqld 10.3.29-MariaDB-0ubuntu0.20.04.1) starting as process 2547 ...

I ask the Linux experts, why I believe that the problem is not in Cqrlog and if it is possible to fix it to improve the time of the run of cqrlog?
Vy tnx for any help!

73 Giuliano in3klq

oh1kh
CQRLOG runs slow

Hi Giuliano!

I assume you have "Save log data to local machine" checked at Database connection window.
You may even have "Open recent log after program start" checked at same window.

Make a test. If you have "Open recent log after program start" checked and your cqrlog opens right away to NewQSO uncheck that one first.
Select "NewQSO/File/Open or create new log" to get to Database connection window and uncheck "Open recent log after program start", then push Cancel button to get back to NewQSO and there press Quit button to close cqrlog.

Now next start opens to Database connection window. If you did not have "Open recent log after program start" checked your cqrlog starts already to Database connection window.
Now we can do a test.

Uncheck "Save log data to local machine" . Be sure that "Remember me" and "Auto connect" are NOT checked.
Then close Database connection window pressing button Cancel.

Start cqrlog again. Does it now take as long time as before?

For me it takes 3-4sec to open without "Save log data to local machine" (that is what I use as I have external sql server for logs)
If I check "Save log data to local machine" startup takes 7-8sec because cqrlog has to start a new MariaDB sql server thread for logs.

If that helps you have to find out why starting a new MariaDB thread takes so long after system update.

If there is no difference then the reason must be elsewhere.

Check "Save log data to local machine" to see your logs again. It will say "local database is not running. Do you want to start it?" Say YES, when question disappears your logs should be again there,

--
Saku
OH1KH

sp3rxo
sp3rxo's picture
Check autostart

Hi Giuliano,
Also check what you have in startup applications. In my case it was Dropbox which makes my both computers - Win and Ubuntu quite busy on start.

<p>SlaveckM, SP3RXO</p>

in3klq
Check autostart

tnx Salveck for your reply but i not have startup applications. another app (firefox vlc ecc. ) run quickly..
73 Giuliano in3klq

File: 

in3klq
CQRLOG runs slow

Hi Saku and thanks for the quick reply!

Yes I confirm I have both options inserted "Open recent log after program start" and "Save log data to local machine".

I changed the steps as your indication but nothing changes for the run time.
I made some captures while starting the program and the wait > 30 sec, occurs between points 1 and 2. see picture.

I'm sorry because it runs in less than 3-4 seconds before!
Can the pop-up message error screen be removed?
That would be a solution for me ..

I agree.. there are log programs under Windows that take much longer to start!

73 and tnx Giuliano in3klq

File: 

oh1kh
CQRLOG runs slow

OK Giuliano!

Then it must be something else than cqrlog starting MariDB server at start.
You can not remove the popup. It comes from Linux system when it notices cqrlog does not run as expected.

If it started after system update try to run update again to see if there has been new updates to fix previous ones. Very seldom this how ever happens that some update is faulty.

For the gtk error see this link if that gives any help.:
https://askubuntu.com/questions/342202/failed-to-load-module-canberra-gt...

And when you start cqrlog from command line (to see debug) use
cqrlog --debug=1

When using that do you have more debug lines then? And how they appear? Are there some lines that come right away before the long wait or is it just so that no debug appears before the waiting time has gone?

--
Saku
OH1KH

in3klq
First of all Saku, Many TNX

First of all Saku, Many TNX for your patience!

gtk error it's ok now! tnx for the link.. but the little problem persists!

On the GNOME logs this is the capture when running cqrlog:

20:45:00 systemd: Started Application launched by gnome-shell
20:45:00 gnome-shell: Window manager warning: Buggy client sent a _NET_ACTIVE_WINDOW message with a timestamp of 0 for 0x2200031
20:45:28 cqrlog: Linux version 5.11.0-40-generic (buildd@lgw01-amd64-010) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #44~20
20:45:28 mysqld: 2021-11-17 20:45:28 0 [Note] /usr/sbin/mysqld (mysqld 10.3.31-MariaDB-0ubuntu0.20.04.1) starting as process 3375 ...

and this is the capture with the command cqrlog --debug=1

giuliano@Pc-Giuliano:~$ cqrlog --debug=1
"here it stops for ~ 30 seconds with the pop-up message error"

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

OS:
Linux version 5.11.0-40-generic (buildd@lgw01-amd64-010) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #44~20.04.2-Ubuntu SMP Tue Oct 26 18:07:44 UTC 2021
SSL libraries:
libssl.so
libcrypto.so
Loaded 164583 LoTW users
Loaded 147784 eQSL users
Loaded 34687 SCP calls
*
User home directory: /home/giuliano/
Program home directory: /home/giuliano/.config/cqrlog/
Data directory: /home/giuliano/.config/cqrlog/database/
Memebers directory: /home/giuliano/.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
/usr/bin/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/giuliano/.config/cqrlog/database/mysql.cnf
--datadir=/home/giuliano/.config/cqrlog/database/
--socket=/home/giuliano/.config/cqrlog/database/sock
--port=64000

Trying to connect to database
2021-11-17 20:29:27 0 [Note] /usr/sbin/mysqld (mysqld 10.3.31-MariaDB-0ubuntu0.20.04.1) starting as process 2872 ...
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

SELECT * FROM cqrlog_config

select * from db_version

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

-----
Saku, I don't want to stress you ;)

maybe if a new update comes out and fixes everything!
Any help, however, is welcome!

Many TNX again..
73 Giuliano in3klq

oh1kh
CQRLOG runs slow

HI Giuliano!

What I am seeing from your message it seems to be window manager problem.

20:45:00 gnome-shell: Window manager warning: Buggy client sent a _NET_ACTIVE_WINDOW message with a timestamp of 0 for 0x2200031
20:45:28 cqrlog: Linux version 5.11.0-40-generic (buildd@lgw01-amd64-010) (gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #44~20

There is 28 sec delay and it is the same moment as you have here:

giuliano@Pc-Giuliano:~$ cqrlog --debug=1
"here it stops for ~ 30 seconds with the pop-up message error"
Cqrlog Ver:2.5.2 (001) Date:2021-02-12

Also when i put Google: "gnome-shell: Window manager warning: Buggy client sent a _NET_ACTIVE_WINDOW message with a timestamp of" I get many hits, but all are from different softwares/Linuxes.

It seems that there is something with Gnome.
Could you try with another window manager that you are now using. (LXDE, KDE etc.)

Or if you can compile from source you could try to use QT5 version of cqrlog and see if that starts faster.
Install eand execute following commands in command console. The first one may install lot of dependencies so it will take some time.
sudo apt-get install lazarus git libqt5pas1 
git clone https://github.com/ok2cqr/cqrlog.git
cd cqrlog
make cqrlog_qt5
sudo make install

Or as third way; Just wait for next updates and see if they restore starting speed to value it was before this update.

 

--
Saku
OH1KH

oh1kh
CQRLOG runs slow

Ooops !

You need to install also dev package of libqt5pas. So the correct first line is
sudo apt-get install lazarus git libqt5pas1 libqt5pas-dev

--
Saku
OH1KH

in3klq
CQRLOG runs slow

Hi Saku
as always thanks for the reply ..

I am a true beginner and sure wrong.. last time I compiled a source file, I had serious problems with libraries, dependencies etc ..

I also tried at midnight during the full moon but I failed and I corrupted something .. :(

Linux never restarted ..

I had to reinstall the whole operating system .. !!

So I leave it as it is, and wait for an update .. maybe of cqrlog!

Tnx and 73's
Giuliano in3klq