[SOLVED] Failed to create a new log (foreign key constraint fails)

1 post / 0 new
Log in or register to post comments
Sat, 2019-07-06 22:27
#1
sq6poc
[SOLVED] Failed to create a new log (foreign key constraint fails)

Hi again,

While trying to set up a new log from scratch (clean install, no previous files on the system) I'm getting the following error when trying to set up database for a new log:

insert into db_version (nr) values(15)
insert into cqrlog_common.log_list (log_nr,log_name) values (1,'Log 001')
insert into log_changes (id,cmd) values(1,'ALLDONE')
insert into upload_status (logname, id_log_changes) values ('HamQTH',1)
TApplication.HandleException TMySQL56Connection : Error executing query: Cannot add or update a child row: a foreign key constraint fails (`cqrlog001`.`upload_status`, CONSTRAINT `upload_status_ibfk_1` FOREIGN KEY (`id_log_changes`) REFERENCES `log_changes` (`id`) ON DELETE SET NULL)

Below is the beginning of debug output (I'm running Arch Linux, and have had issues reported on this forum, but this time it seems like an internal application problem). Can anyone duplicate my problem?

-- Przemek sq6poc


[przemek@corsa ~]$ cqrlog --debug=1

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

SSL libraries:
/usr/lib64/libssl.so.1.0.0
/usr/lib64/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib64/libmysqlclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************

Ctyfiles dir: /usr/share/cqrlog/ctyfiles/
Local ctyfiles dir: /home/przemek/.config/cqrlog/ctyfiles/
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/przemek/
Program home directory: /home/przemek/.config/cqrlog/
Data directory: /home/przemek/.config/cqrlog/database/
Memebers directory: /home/przemek/.config/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
/usr/sbin/mysqld --defaults-file=/home/przemek/.config/cqrlog/database/mysql.cnf --datadir=/home/przemek/.config/cqrlog/database/ --socket=/home/przemek/.config/cqrlog/database/sock --port=64000
Trying to connect to database
2019-07-06 23:17:48 0 [Note] /usr/sbin/mysqld (mysqld 10.4.6-MariaDB) starting as process 24406 ...

-- EDIT --

There seems to be a problem caused by migrating to MariaDB server ver. 10.4.6. See solution to my other problem, which I think is the same issue.

Top