[ERROR] Moving LOG from one computer to another

4 posts / 0 new
Last post
CT7AFR
[ERROR] Moving LOG from one computer to another

Hi everyone,

Recently I had to switch computers and moved the folder ~/.config/cqrlog from the old computer to the new one. However, when I launch CQRLOG, I get the error shown down below...
Unfortunately, I don't have any backup of my LOGs.
My system is Debian Buster with CQRLOG 2.5.2 (001)

"Error during connection to database: TMySQL57Connection : Server connect failed."

Then, opening as suggested, the file mysql.err, the last lines (earlierlines are from dates previous to installation) show:

"
2021-12-27 20:31:55 0 [Note] InnoDB: Uses event mutexes
2021-12-27 20:31:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-27 20:31:55 0 [Note] InnoDB: Number of pools: 1
2021-12-27 20:31:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-12-27 20:31:55 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-12-27 20:31:55 0 [Note] InnoDB: Using Linux native AIO
2021-12-27 20:31:55 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2021-12-27 20:31:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-27 20:31:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-12-27 20:31:55 0 [Note] InnoDB: 128 rollback segments are active.
2021-12-27 20:31:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-27 20:31:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-27 20:31:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-12-27 20:31:55 0 [Note] InnoDB: 10.5.9 started; log sequence number 82034744; transaction id 16173
2021-12-27 20:31:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-27 20:31:55 0 [Note] InnoDB: Loading buffer pool(s) from /home/emmanuel/.config/cqrlog/database/ib_buffer_pool
2021-12-27 20:31:55 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2021-12-27 20:31:55 0 [Note] Server socket created on IP: '::'.
2021-12-27 20:31:55 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2021-12-27 20:31:55 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2021-12-27 20:31:55 0 [Note] Reading of all Master_info entries succeeded
2021-12-27 20:31:55 0 [Note] Added new Master_info '' to hash table
2021-12-27 20:31:55 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.5.9-MariaDB-1' socket: '/home/emmanuel/.config/cqrlog/database/sock' port: 64000 Debian buildd-unstable
2021-12-27 20:31:55 0 [Note] InnoDB: Buffer pool(s) load completed at 211227 20:31:55
2021-12-27 20:31:56 4 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2021-12-27 20:54:20 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2021-12-27 20:54:20 0 [Note] InnoDB: FTS optimize thread exiting.
2021-12-27 20:54:20 0 [Note] InnoDB: Starting shutdown...
2021-12-27 20:54:20 0 [Note] InnoDB: Dumping buffer pool(s) to /home/emmanuel/.config/cqrlog/database/ib_buffer_pool
2021-12-27 20:54:20 0 [Note] InnoDB: Buffer pool(s) dump completed at 211227 20:54:20
2021-12-27 20:54:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-12-27 20:54:20 0 [Note] InnoDB: Shutdown completed; log sequence number 82153731; transaction id 16184
2021-12-27 20:54:20 0 [Note] /usr/sbin/mysqld: Shutdown complete
"

Thank you for any help.
73 de CT7AFR.

oh1kh
[ERROR] Moving LOG from one computer to another

Hi!

Does the new computer have same cqrlog version as the previous one?:
Or are you jumping from old cqrlog, possibly using old mysql, to new cqrlog using MariaDB? In that case there may be problem.

Did you try to start cqrlog before you moved the folder ? Did cqrlog start normally?
If you did not test that before copying the folder do rename your folder:
mv ~/.config/cqrlog ~/.config/cqrlog_moved

Then start cqrlog and check that it starts and creates a new log ok. If you have problems with that cqrlog does not work with moved folder either.
Once this check passes close cqrlog and delete current folder and rename the moved one back.
rm -rf ~/.config/cqrlog
mv ~/.config/cqrlog_moved ~/.config/cqrlog

Did you check that ownership of folder ~/.config/cqrlog is OK?
Open console and issue a command:
sudo chown -R emmanuel.emmanuel /home/emmanuel/.config/cqrlog

That should not make any harm if ownership is already in order.

If you managed to start cqrlog from "empty table" when moved folder was renamed it seems that there are differences in in database structure.
You should somehow get back to previous cqrlog version, do a full backup of qsos and log settings and then import them to this new PC's cqrlog.

Yes, I know... It might be impossible action.
But let's see first what these tests above do result.

--
Saku
OH1KH

CT7AFR
Hi Saku,

Hi Saku,
Thank you for your time.

- The previous version of CQRLOG is 2.5.1.
- Yes, I did start CQRLOG before I moved the folder. Everything started normally. I did again now and everything works fine, until I replace the new folder with the old one.
- Ownership of the folder is OK.

Now the odd thing is that I removed version 2.5.2 and installed version 2.5.1 and the errors are absolutely the same. :(
I guess I'll have to download my log from the Web, import it to CQRLOG and reinsert by hand last QSOs into database...

Anyway, thank for your help.
73 de CT7AFR, Emmanuel.

73 de CT7AFR, Emmanuel.
http://www.airlomba.net/radio/

oh1kh
[ERROR] Moving LOG from one computer to another

Oh!

2.5.1 and 2.5.2 both have MariaDB in dependencies so it shoud not be the problem that exists when jumping from Mysql to MariDB.
Now there is something else.
Please check that you have all MariaDB packages installed with this new PC:
mariadb-client-10.3 mariadb-server-10.3 libmariadb3 libmariadb-dev-compat

--
Saku
OH1KH