[Dovecot] ot: mysql auth worker failure ?
Voytek Eymont
voytek at sbt.net.au
Fri Aug 3 16:32:37 EEST 2012
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
More information about the dovecot
mailing list