looking through logs I noticed this today:
grep mysql /var/log/maillog | grep fail Aug 3 17:35:25 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:35:57 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:36:02 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:36:23 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:36:40 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:36:50 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:40:04 dovecot: auth-worker(28335): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:41:04 dovecot: auth-worker(29721): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:41:19 dovecot: auth-worker(29721): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist Aug 3 17:41:38 dovecot: auth-worker(29721): Error: mysql: Query failed, retrying: Table 'postfix.users' doesn't exist
looking at mysqld.log, all i see is:
120721 17:58:44 InnoDB: Shutdown completed; log sequence number 0 76814 120721 17:58:44 [Note] /usr/libexec/mysqld: Shutdown complete
120721 17:58:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 120721 17:59:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120721 17:59:54 InnoDB: Initializing buffer pool, size = 8.0M 120721 17:59:54 InnoDB: Completed initialization of buffer pool 120721 17:59:54 InnoDB: Started; log sequence number 0 76814 120721 17:59:54 [Note] Event Scheduler: Loaded 0 events 120721 17:59:54 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.61' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
no failure were noticed or reported, except for log items
any thoughts ?
I might have been importing (phpmyadmin) some 3 or 4 databases around that time, surely that wouldn't cause such issue ?
-- Voytek Eymont