Error executing query: Unknown database 'cqrlog001'

4 posts / 0 new
Last post
ik1rac
ik1rac's picture
Error executing query: Unknown database 'cqrlog001'

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
 
 
 

ok2cqr
ok2cqr's picture
Re: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

ik1rac
ik1rac's picture
Re:Error executing query: Unknown database 'cqrlog001'

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
 
 

ok2cqr
ok2cqr's picture
Re:Error executing query: Unknown database 'cqrlog001'

Hi Vittorio,
 
could you send me gzipped  .config/cqrlog directory, please? Maybe the database is corrupted.
 
73 Petr, OK2CQR