Upon starting cqrlog I get this error message:
: Error executing query: Unknown database 'cqrlog001'.Press OK to ignore and risk data corruption.Press Cancel to kill the program.
and here are the messages from the console:
use cqrlog001TApplication.HandleException : Error executing query: Unknown database 'cqrlog001' Stack trace: $083A2215 $08450D15 $08452110 $08423BC3 $084247D9 $080EEECA $081671FB $08267416 $082C290F $082C3056 $082C35A1 $082C281A $0806CEC6 $0825C95F $08339DE7 $08344860 $B70ADC57
after hitting cancel the console reports:
Closing BandMap windowClosing DXCluster windowClosing TRXControl windowClosing GrayLine windowEnd dmDXCCComplete end dmDXCCClosing dDXCCClosing dData/home/vittorio/.config/cqrlog/database/ik1rac.pidCommand: kill 3953140301 17:14:32 [Note] /usr/sbin/mysqld: Normal shutdown140301 17:14:32 InnoDB: Starting shutdown...WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?Closing ini file ...An unhandled exception occurred at $FFFFFFFF :EAccessViolation : $FFFFFFFF $0806CEC6 $0825C95F $08082F99 $082654B8 $0825AA19 $0825A97F $08085ACA $08259412 $0826D36E $0826A900 $0808114F $08084D39 $0808C0C4 $0805E16F $B6CCDE46------------------------------------
Using cqrlog 1.4.1-1 on Debian 7.4
Any help is appreciated
73s de IK1RAC, Vittorio
Sat, 2014-03-01 16:19
#1
Error executing query: Unknown database 'cqrlog001'
Hi Vittorio,
could you paste here what cqrlog writes to console when start, please? Did you have any data in it?
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr,
thanks for the reply.
DB is no empty at all but I should have backups.
Here is what happens when I launch cqrlog executable.: everything seems to be fine till I select the DB.
vittorio@ik1rac:~$ cqrlog Loading libssl: /usr/lib/i386-linux-gnu/libssl.so.1.0.0Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so.1.0.0Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18Loaded 51464 LoTW usersLoaded 60718 eQSL users*User home directory: /home/vittorio/Program home directory: /home/vittorio/.config/cqrlog/Data directory: /home/vittorio/.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/*/usr/sbin/mysqld --defaults-file=/home/vittorio/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/vittorio/.config/cqrlog/database/ --socket=/home/vittorio/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K140305 21:36:20 [Note] Plugin 'FEDERATED' is disabled.140305 21:36:20 InnoDB: The InnoDB memory heap is disabled140305 21:36:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins140305 21:36:20 InnoDB: Compressed tables use zlib 1.2.7140305 21:36:20 InnoDB: Using Linux native AIO140305 21:36:20 InnoDB: Initializing buffer pool, size = 128.0M140305 21:36:20 InnoDB: Completed initialization of buffer pool140305 21:36:20 InnoDB: highest supported file format is Barracuda.140305 21:36:20 InnoDB: Waiting for the background threads to start140305 21:36:21 InnoDB: 5.5.35 started; log sequence number 1595675140305 21:36:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000140305 21:36:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';140305 21:36:21 [Note] Server socket created on IP: '0.0.0.0'.140305 21:36:21 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them140305 21:36:21 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist140305 21:36:21 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure140305 21:36:21 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure140305 21:36:21 [Note] /usr/sbin/mysqld: ready for connections.Version: '5.5.35-0+wheezy1' socket: '/home/vittorio/.config/cqrlog/database/sock' port: 64000 (Debian)select * from tables where table_schema = 'cqrlog_common'SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nruse cqrlog001TApplication.HandleException : Error executing query: Unknown database 'cqrlog001' Stack trace: $083A2215 $08450D15 $08452110 $08423BC3 $084247D9 $080EEECA $081671FB $08267416 $082C290F $082C3056 $082C35A1 $082C281A $0806CEC6 $0825C95F $08339DE7 $08344860 $B70D8C57Closing BandMap windowClosing DXCluster windowClosing TRXControl windowClosing GrayLine windowEnd dmDXCCComplete end dmDXCCClosing dDXCCClosing dData/home/vittorio/.config/cqrlog/database/ik1rac.pidCommand: kill 3723140305 21:37:02 [Note] /usr/sbin/mysqld: Normal shutdown140305 21:37:02 InnoDB: Starting shutdown...WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?Closing ini file ...An unhandled exception occurred at $FFFFFFFF :EAccessViolation : $FFFFFFFF $0806CEC6 $0825C95F $08082F99 $082654B8 $0825AA19 $0825A97F $08085ACA $08259412 $0826D36E $0826A900 $0808114F $08084D39 $0808C0C4 $0805E16F $B6CF8E46vittorio@ik1rac:~$ 140305 21:37:03 InnoDB: Shutdown completed; log sequence number 1595675140305 21:37:03 [Note] /usr/sbin/mysqld: Shutdown complete
Hi Vittorio,
could you send me gzipped .config/cqrlog directory, please? Maybe the database is corrupted.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com