Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysql
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_get(+257): [0x9e10d70] connection from pool
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_exec(+312): [0x9e10d70] [UPDATE dbmail_messages SET status = 3 WHERE status = 2]
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] log_query_time(+290): last query took [0.064] seconds
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_get(+257): [0x9e10d70] connection from pool
Jul 19 17:00:57 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_query(+344): [0x9e10d70] [SELECT usr.user_idnr, SUM(pm.messagesize), usr.curmail_size FROM dbmail_users usr LEFT JOIN dbmail_mailboxe
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] log_query_time(+290): last query took [2.280] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Debug:[db] user_idnr_is_delivery_user_idnr(+803): looking up user_idnr for [__@!internal_delivery_user!@__]
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_get(+257): [0x9e10d70] connection from pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_stmt_prepare(+397): [0x9e10d70] [SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower(?)]
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_stmt_set_str(+405): [0x9e10470] 1:[__@!internal_delivery_user!@__]
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_get(+257): [0x9e10d70] connection from pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_exec(+312): [0x9e10d70] [UPDATE dbmail_users SET curmail_size = 123622081 WHERE user_idnr = 53]
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] log_query_time(+290): last query took [0.026] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_get(+257): [0x9e10d70] connection from pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_exec(+312): [0x9e10d70] [UPDATE dbmail_users SET curmail_size = 144136107 WHERE user_idnr = 12]
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] log_query_time(+290): last query took [0.000] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_get(+257): [0x9e10d70] connection from pool
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_exec(+312): [0x9e10d70] [UPDATE dbmail_users SET curmail_size = 69633269 WHERE user_idnr = 9]
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] log_query_time(+290): last query took [0.000] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24726]: [0x9e0bb08] Database:[db] db_con_close(+275): [0x9e10d70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysql
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_con_close(+275): [0x894cd70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_con_get(+257): [0x894cd70] connection from pool
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_exec(+312): [0x894cd70] [DELETE FROM dbmail_messages WHERE status=3]
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] log_query_time(+290): last query took [0.689] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24730]: [0x8947b08] Database:[db] db_con_close(+275): [0x894cd70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysql
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:01:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_query(+344): [0x8af6d70] [SELECT mb.messageblk_idnr FROM dbmail_messageblks mb LEFT JOIN dbmail_physmessage pm ON mb.physmessage_id =
Jul 19 17:01:01 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [0.524] seconds
Jul 19 17:01:01 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:01:01 lira dbmail/maintenance[24732]: [0x8af1b08] Debug:[db] db_icheck_messageblks(+1193): no lost messageblocks
Jul 19 17:01:01 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:01:01 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_query(+344): [0x8af6d70] [SELECT COUNT(*) FROM dbmail_physmessage p LEFT JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE m.me
Jul 19 17:01:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [1.204] seconds
Jul 19 17:01:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:01:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:01:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_exec(+312): [0x8af6d70] [DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages)]
Jul 19 17:01:22 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [19.986] seconds
Jul 19 17:01:22 lira dbmail/maintenance[24732]: [0x8af1b08] Info:[db] log_query_time(+296): slow query [DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages)] took [19.986] s
Jul 19 17:01:22 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:01:22 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:01:22 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_query(+344): [0x8af6d70] [SELECT COUNT(*) FROM dbmail_mimeparts p LEFT JOIN dbmail_partlists l ON p.id = l.part_id WHERE l.physmessag
Jul 19 17:03:14 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [111.609] seconds
Jul 19 17:03:14 lira dbmail/maintenance[24732]: [0x8af1b08] 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
Jul 19 17:03:14 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:03:14 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:03:14 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_exec(+312): [0x8af6d70] [DELETE FROM dbmail_mimeparts WHERE id NOT IN (SELECT part_id FROM dbmail_partlists)]
Jul 19 17:05:03 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_connect(+191): db at url: [mysql://localhost/postfix?user=userdb&password=passdb&charset=utf8&unix-socket=/var/run/mysql
Jul 19 17:05:03 lira dbmail/maintenance[24761]: [0x8d83b08] Info:[db] db_connect(+203): database connection pool created with maximum connections of [60]
Jul 19 17:05:03 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_connect(+211): database connection pool started with [5] connections, max [60]
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_con_close(+275): [0x8d88d70] connection to pool
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Debug:[auth] auth_load_driver(+51): library_directory is [/usr/local/lib/dbmail]
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Debug:[auth] auth_load_driver(+64): looking for auth_sql as /usr/local/lib/dbmail/libauth_sql.so
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_con_get(+257): [0x8d88d70] connection from pool
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_exec(+312): [0x8d88d70] [DELETE FROM dbmail_pbsp WHERE since < TIMESTAMP('2009-07-19 16:30:04')]
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] log_query_time(+290): last query took [0.339] seconds
Jul 19 17:05:04 lira dbmail/maintenance[24761]: [0x8d83b08] Database:[db] db_con_close(+275): [0x8d88d70] connection to pool
Jul 19 17:08:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [286.621] seconds
Jul 19 17:08:00 lira dbmail/maintenance[24732]: [0x8af1b08] Warning:[db] log_query_time(+292): slow query [DELETE FROM dbmail_mimeparts WHERE id NOT IN (SELECT part_id FROM dbmail_partlists)] took [286.621] seconds
Jul 19 17:08:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:08:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:08:00 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_query(+344): [0x8af6d70] [SELECT msg.message_idnr FROM dbmail_messages msg LEFT JOIN dbmail_mailboxes mbx ON msg.mailbox_idnr=mbx.mai
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [1.229] seconds
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Debug:[db] db_icheck_messages(+1277): no lost messages
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_get(+257): [0x8af6d70] connection from pool
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_query(+344): [0x8af6d70] [SELECT mbx.mailbox_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_users usr ON mbx.owner_idnr=usr.user_idn
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] log_query_time(+290): last query took [0.088] seconds
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Database:[db] db_con_close(+275): [0x8af6d70] connection to pool
Jul 19 17:08:02 lira dbmail/maintenance[24732]: [0x8af1b08] Debug:[db] db_icheck_mailboxes(+1307): no lost mailboxes