CQRlog crashed big time. Can't recover. HELP!!!

2 posts / 0 new
Last post
PA2BX
PA2BX's picture
CQRlog crashed big time. Can't recover. HELP!!!

Out of the blue CQRlog crashed (honestly, was just inputting QSL data) and now nothing works. No logs to choose from. Says can't connect to database. Tried this thread: https://www.cqrlog.com/node/1296 but it won't connect to the database for a dump:

(mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/home/hans/.config/cqrlog/database/sock' (2)" when trying to connect).

Any other suggestions for a fix appreciated (been busy for three hours with this. Kind of exhausted now).

1- CQRlog started from the command line.

$cqrlog

**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

IniFile:/home/hans/.config/cqrlog/cqrlog.cfg
LocalIniFile:/home/hans/.config/cqrlog/local.cfg
160324 9:04:57 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 3949 ...

(cqrlog:3941): GLib-CRITICAL **: Source ID 13 was not found when attempting to remove it

(cqrlog:3941): GLib-CRITICAL **: Source ID 12 was not found when attempting to remove it

(cqrlog:3941): GLib-CRITICAL **: Source ID 45 was not found when attempting to remove it

(cqrlog:3941): GLib-CRITICAL **: Source ID 44 was not found when attempting to remove it

(cqrlog:3941): GLib-CRITICAL **: Source ID 50 was not found when attempting to remove it

(cqrlog:3941): GLib-CRITICAL **: Source ID 49 was not found when attempting to remove it
Closing ini file ...

2-mysql.err file latests entry

160323 23:07:37 InnoDB: The InnoDB memory heap is disabled
160323 23:07:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160323 23:07:37 InnoDB: Compressed tables use zlib 1.2.8
160323 23:07:37 InnoDB: Using Linux native AIO
160323 23:07:37 InnoDB: Initializing buffer pool, size = 80.0M
160323 23:07:37 InnoDB: Completed initialization of buffer pool
160323 23:07:37 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
160323 23:07:37 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 11 of name './cqrlog002/call_alert.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 11 of name './cqrlog_common/dxclusters.ibd' already exists in the tablespace
InnoDB: memory cache!

ok2cqr
ok2cqr's picture
Re: CQRlog crashed big time. Can't recover. HELP!!!

Could you send me the database directory to my email, please? It's in ~/.config/cqrlog, where ~ means your home directory. My email is petr@ok2cqr.com.

73 Petr, OK2CQR