[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