dovecot - Aug 2012 - ot: mysql auth worker failure ?

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

Am 03.08.2012 15:32, schrieb Voytek Eymont:
> 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
states clearly that a table is missing
> looking at mysqld.log, all i see is:
> no failure were noticed or reported, except for log items
> 
> any thoughts ?
why should mysqld report a error if a nonsystem table is mising
> I might have been importing (phpmyadmin) some 3 or 4 databases around that
> time, surely that wouldn't cause such issue ?
what about connect directly to mysqld and
look if the table exists and review your import
dump-files if they did drop tables?

however, this is not a dovecot issue

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20120803/b52524b0/attachment-0004.bin>

On Fri, August 3, 2012 11:36 pm, Reindl Harald wrote:
> states clearly that a table is missing
> what about connect directly to mysqld and look if the table exists and
> review your import dump-files if they did drop tables?
auth-worker(28335): Error: mysql: Query failed, retrying: Table
'postfix.users' doesn't exist

Reindl , thanks

oops, I clearly mis-interpreted what happened...
looking at mysql tables, I don't have such table, and, it seems I'm not
using it in my sql:

grep users dovecot-sql.conf
grep users dovecot*
conf.d]# grep users auth-sql*
auth-sql.conf:# Authentication for SQL users. Included from auth.conf.
auth-sql.conf.ext:# Authentication for SQL users. Included from auth.conf.
conf.d]# grep users 10-auth.conf
# If you want to allow master users to log in by specifying the master
# Username to use for users logging in with ANONYMOUS SASL mechanism
# allow both system users (/etc/passwd) and virtual users to login without
# duplicating the system users into virtual database.


where could that be called from ?

-- 
Voytek Eymont