lira:/var/log# /etc/cron.daily/check_mail
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysqld/mysqld.sock]
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_close(+275): [0x9c66228] connection to pool
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so

Setting DELETE status for deleted messages...
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_get(+257): [0x9c66228] connection from pool
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_exec(+312): [0x9c66228] [UPDATE dbmail_messages SET status = 3 WHERE status = 2]
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] log_query_time(+290): last query took [0.056] seconds
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_close(+275): [0x9c66228] connection to pool
Ok. Messages set for deletion.
Re-calculating used quota for all users...
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_get(+257): [0x9c66228] connection from pool
Jul 19 17:25:57 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_query(+344): [0x9c66228] [SELECT usr.user_idnr, SUM(pm.messagesize), usr.curmail_size FROM dbmail_users usr LEFT JOIN dbmail_mailboxes mbx ON mbx.owner_idnr = usr.user_idnr LEFT JOIN dbmail_messages msg ON msg.mailbox_idnr = mbx.mailbox_idnr LEFT JOIN dbmail_physmessage pm ON pm.id = msg.physmessage_id AND msg.status < 2 GROUP BY usr.user_idnr, usr.curmail_size HAVING ((SUM(pm.messagesize) <> usr.curmail_size) OR (NOT (SUM(pm.messagesize) IS NOT NULL) AND usr.curmail_size <> 0))]
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Database:[db] log_query_time(+290): last query took [3.157] seconds
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_close(+275): [0x9c66228] connection to pool
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Debug:[db] user_idnr_is_delivery_user_idnr(+803): looking up user_idnr for [__@!internal_delivery_user!@__]
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_get(+257): [0x9c66228] connection from pool
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_stmt_prepare(+397): [0x9c66228] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower(?)]
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_stmt_set_str(+405): [0x9c967f8] 1:[__@!internal_delivery_user!@__]
Jul 19 17:26:00 lira dbmail-util[24952]: [0x9c62b08] Database:[db] db_con_close(+275): [0x9c66228] connection to pool
Ok. Used quota updated for all users.

Maintenance done. No errors found.
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysqld/mysqld.sock]
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Database:[db] db_con_close(+275): [0x8541228] connection to pool
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so

Deleting messages with DELETE status...
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Database:[db] db_con_get(+257): [0x8541228] connection from pool
Jul 19 17:26:00 lira dbmail-util[24956]: [0x853db08] Database:[db] db_exec(+312): [0x8541228] [DELETE FROM dbmail_messages WHERE status=3]
Jul 19 17:26:01 lira dbmail-util[24956]: [0x853db08] Database:[db] log_query_time(+290): last query took [0.996] seconds
Jul 19 17:26:01 lira dbmail-util[24956]: [0x853db08] Database:[db] db_con_close(+275): [0x8541228] connection to pool
Ok. Messages deleted.

Maintenance done. No errors found.
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysqld/mysqld.sock]
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so

Repairing DBMAIL messageblocks integrity...
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:26:01 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_query(+344): [0x84e0228] [SELECT mb.messageblk_idnr FROM dbmail_messageblks mb LEFT JOIN dbmail_physmessage pm ON mb.physmessage_id = pm.id WHERE pm.id IS NULL]
Jul 19 17:26:02 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [0.495] seconds
Jul 19 17:26:02 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Jul 19 17:26:02 lira dbmail-util[24958]: [0x84dcb08] Debug:[db] db_icheck_messageblks(+1193): no lost messageblocks
Ok. Found [0] unconnected messageblks.

Repairing DBMAIL physmessage integrity...
Jul 19 17:26:02 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:26:02 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_query(+344): [0x84e0228] [SELECT COUNT(*) FROM dbmail_physmessage p LEFT JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE m.message_idnr IS NULL]
Jul 19 17:26:03 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [1.105] seconds
Jul 19 17:26:03 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Ok. Found [367] unconnected physmessagesJul 19 17:26:03 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:26:03 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_exec(+312): [0x84e0228] [DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages)]
Jul 19 17:26:12 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [9.298] seconds
Jul 19 17:26:12 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Ok. Orphaned physmessages deleted.

Repairing DBMAIL mimeparts integrity...
Jul 19 17:26:12 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:26:12 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_query(+344): [0x84e0228] [SELECT COUNT(*) FROM dbmail_mimeparts p LEFT JOIN dbmail_partlists l ON p.id = l.part_id WHERE l.physmessage_id IS NULL]
Jul 19 17:27:55 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [103.124] seconds
Jul 19 17:27:55 lira dbmail-util[24958]: [0x84dcb08] Warning:[db] log_query_time(+292): slow query [SELECT COUNT(*) FROM dbmail_mimeparts p LEFT JOIN dbmail_partlists l ON p.id = l.part_id WHERE l.physmessage_id IS NULL] took [103.124] seconds
Jul 19 17:27:55 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Ok. Found [967] unconnected mimepartsJul 19 17:27:55 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:27:55 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_exec(+312): [0x84e0228] [DELETE FROM dbmail_mimeparts WHERE id NOT IN (SELECT part_id FROM dbmail_partlists)]
Jul 19 17:32:45 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [290.041] seconds
Jul 19 17:32:45 lira dbmail-util[24958]: [0x84dcb08] Warning:[db] log_query_time(+292): slow query [DELETE FROM dbmail_mimeparts WHERE id NOT IN (SELECT part_id FROM dbmail_partlists)] took [290.041] seconds
Jul 19 17:32:45 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Ok. Orphaned mimeparts deleted.

Repairing DBMAIL message integrity...
Jul 19 17:32:45 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:32:45 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_query(+344): [0x84e0228] [SELECT msg.message_idnr FROM dbmail_messages msg LEFT JOIN dbmail_mailboxes mbx ON msg.mailbox_idnr=mbx.mailbox_idnr WHERE mbx.mailbox_idnr IS NULL]
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [0.613] seconds
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Debug:[db] db_icheck_messages(+1277): no lost messages
Ok. Found [0] unconnected messages.

Repairing DBMAIL mailbox integrity...
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_get(+257): [0x84e0228] connection from pool
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_query(+344): [0x84e0228] [SELECT mbx.mailbox_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_users usr ON mbx.owner_idnr=usr.user_idnr WHERE usr.user_idnr is NULL]
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Database:[db] log_query_time(+290): last query took [0.095] seconds
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Database:[db] db_con_close(+275): [0x84e0228] connection to pool
Jul 19 17:32:46 lira dbmail-util[24958]: [0x84dcb08] Debug:[db] db_icheck_mailboxes(+1307): no lost mailboxes
Ok. Found [0] unconnected mailboxes.

Maintenance done. No errors found.
lira:/var/log#