startup very slow on remote sometimes

2 posts / 0 new
Last post
f1rad
startup very slow on remote sometimes

Hi !
the cqrlog database is on my main pc (for backup reason) and i use cqrlog on my "radio" pc with local network.
Often, the startup is ok, somes seconds but from time to time the startup is more than 1 hour !
Nothing with the --debug=1 flag :
$ cqrlog --debug=1
Gtk-Message: 18:01:24.920: Failed to load module "atk-bridge"

**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.2
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.2
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 115701 LoTW users
Loaded 113723 eQSL users
Loaded 42080 SCP calls
*
User home directory: /home/XXXXXX/
Program home directory: /home/XXXXXXX/.config/cqrlog/
Data directory: /home/XXXXXXX/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
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

oh1kh
startup very slow on remote sometimes

Hi!
Using database in different PC should not make any harm.
I run database in ham pc mysql server (I am not using the default protected mode DB of cqrlog) and acccess to it via localhost:3306.

That database will replicate to my server pc via WiFi. At server side I run cqrweblog so I can access logs also via web. And If I do server will replicate new qsos bank to ham pc next time I start it.
Has worked fine for years now.

I have also tested to run cqrlog at remote location connecting to server's database via internet/OpenVpn. Works, but slows quite a lot, specially if new DXCC/QSLMGR is downloaded.
How ever also in this case cqrlog starts quick enough.

I suspect that you have some problems with Gtk as the GtK-Message should not be there.
You can put that line to google and see what you find.

This are some of the first hits I got:
https://askubuntu.com/questions/548557/how-to-install-gail-and-atk-bridge
https://dev1galaxy.org/viewtopic.php?id=1815

At what point of your debug list the long delay happens?

--
Saku
OH1KH