When I run CQRLOG fro terminal I see the following errors:
131028 11:37:42 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
131028 11:37:42 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
131028 11:37:42 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
131028 11:37:42 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
131028 11:37:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.34-0ubuntu0.12.10.1' socket: '/home/dave/.config/cqrlog/database/sock' port: 64000 (Ubuntu)
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
/usr/share/xplanet/markers
Warning: Can't load marker file /home/dave/.config/cqrlog/xplanet/marker
Warning: Can't find /home/dave/.config/cqrlog/xplanet/marker in
xplanet/markers
/home/dave/.xplanet/markers
Everything seems to be working, anyone know why I'm getting these startup errors?
Have been using version 1.6.1 successfully on Linux Mint 13 for some weeks with no issues.
A few nights ago, program would no longer load. Error message: "error during connection to database -- server connect failed."
Running cqrlog --debug=2 > debug.log from the command prompt produces:
131114 13:33:55 [Note] Plugin 'FEDERATED' is disabled.
131114 13:33:55 InnoDB: The InnoDB memory heap is disabled
131114 13:33:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131114 13:33:55 InnoDB: Compressed tables use zlib 1.2.3.4
131114 13:33:55 InnoDB: Initializing buffer pool, size = 128.0M
131114 13:33:55 InnoDB: Completed initialization of buffer pool
131114 13:33:55 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!
131114 13:33:55 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
131114 13:33:55 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name .
InnoDB: File operation call: 'opendir'.
InnoDB: Cannot continue operation.
Any advice would be greatly appreciated.
Very interesting. Could you send me whole cqrlog directory, please? It's in you home dir/.config/cqrlog
I'll look at it. Do you have auto backup enabled?
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks for your reply Petr.
I will send directory shortly, and sorry for not including my name.
73 John, ZL2JEL
I have the same problem in Ubuntu 12.04 64-bit
Is the 2nd logbook chased on Linux.
I need help, no copy of the log (I think)
Also please send me .config/cqrlog directory. I'll look at it. My email is petr@ok2cqr.com
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Mine crashed today as well, Yikes... Tom K8WDX
Mint 13 LTS...
Tom K8WDX
Tom,
could you send me result of ls -la from ~/.config/cqrlog/database, please? It's very strange. Did you install any updates? What has been changed?
Thank you!
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
I've found a solution.
Go to ~/.config/cqrlog/database. There is my.cnf file. Open it in text editor and add to the end this:
innodb_force_recovery = 3
Save the file, start the log. Directly in Database connection window click to Utils button and choose Repair log database. Now click to Cancel button. Open my.cnf file again and remo the line you've added. Save the file and start CQRLOG again. Now it should work as expected.
I don't know why, but sometimes mysql server doesn't end correctly and corrupt the database.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
I don't have a my.cnf file in my ~/.config/cqrlog/database directory?
Would this be why I can see all these startup errors in terminal?
73'd De Dave, G8FXM O/S Linux Mint 18.1 KDE Plasma 64 bit g8fxm@uksmg.org
I have the same error messages and have the file. CQRLOG starts MySQL in embbeded mode where are not any prermission and MySQL informs about that with these error messages.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks Petr, thats put my mind at rest, at least now I know there is no underlying problem I need worry about. As I said in my post, CQRLog is working fine for me, not sure why I don't have that my.cnf file though?
73'd De Dave, G8FXM O/S Linux Mint 18.1 KDE Plasma 64 bit g8fxm@uksmg.org
correction, I do have a my.cnf file, but it's empty.
73'd De Dave, G8FXM O/S Linux Mint 18.1 KDE Plasma 64 bit g8fxm@uksmg.org
Hello Petr,
today I started cqrlog (ubuntu 12.0.4 64Bit CQRLog1.6.1). But there is no Database to select at startup. In command-line I got this erros:
131122 18:01:35 [Note] Plugin 'FEDERATED' is disabled.
131122 18:01:35 InnoDB: The InnoDB memory heap is disabled
131122 18:01:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131122 18:01:35 InnoDB: Compressed tables use zlib 1.2.3.4
131122 18:01:35 InnoDB: Initializing buffer pool, size = 128.0M
131122 18:01:35 InnoDB: Completed initialization of buffer pool
131122 18:01:35 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!
131122 18:01:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
131122 18:01:35 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name .
InnoDB: File operation call: 'opendir'.
InnoDB: Cannot continue operation.
Here ls:
marcus@marcus-nimbus:~$ ls -la ~/.config/cqrlog/database
insgesamt 45080
drwxrwxr-x 5 marcus marcus 4096 Nov 22 18:01 .
drwxrwxr-x 11 marcus marcus 4096 Nov 21 19:45 ..
drwx------ 2 marcus marcus 4096 Nov 11 19:24 cqrlog001
drwx------ 2 marcus marcus 4096 Nov 15 20:37 cqrlog002
drwx------ 2 marcus marcus 4096 Nov 11 18:52 cqrlog_common
-rw-rw---- 1 marcus marcus 35651584 Nov 21 20:14 ibdata1
-rw-rw---- 1 marcus marcus 5242880 Nov 21 20:14 ib_logfile0
-rw-rw---- 1 marcus marcus 5242880 Nov 20 20:01 ib_logfile1
-rw-rw-r-- 1 marcus marcus 61 Nov 22 17:58 my.cnf
I tried
innodb_force_recovery = 3
allready...
73, Marcus (DL4VAP)
I'm sorrry, I'm not at home and have only iPad here.
You can try to increase number in innodb_force_recovery. If it won't help, backup cqrlod directory, delete it and let cqrlog to create new one. Then create new databases and close the log. Now you can replace new created database with files in the backup, but please replace only cqrlog_001, not common database. It may be broken.
Do you remember how did it happen? I'd like to find out what is happening. Thank you!
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hello Petr.
I'm not sure. Yesterday all works fine. But today nothing works. My Machine is silent. So maybe the System is still up at the time I switch the Power down....accidently.. I will try to create a new database tomorrow. But I have backups too... so nothing will be lost.
73, Marcus
This looks to me like a bug that only shows up in some 64-bit machines. But some of those above saying 'I have a problem too' didn't say whether their machine was 32 or 64 bit.
But I'm holding off on upgrading CQRLog on this 32-bit Xubuntu 12.04.3 LTS machine until we find out.
Relax and take your time, Petr. Other things are more important. Thank you for all your hard work. :-)
73 Mike
www.w0btu.com
73, Mike
www.w0btu.com
Well, I finally upgraded to 1.6.1 just now. Starts up just fine. :-)
73, Mike
www.w0btu.com
I switched my machine over to Mint 32 bit, no touble here either with 32 bit...
Tom K8WDX