>
> You have to use the file log not syslog - as syslog will cut off the
> messages.
Ah, I have it now :)
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Error:[db]
db_query(+351): SQLException:
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Error:[db]
db_query(+352): failed query [SELECT mb.messageblk_idnr FROM
dbmail_messageblks mb LEFT JOIN dbmail_physmessage pm ON mb.physmessage_id =
pm.id WHERE pm.id IS NULL]
Full log attached.
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_connect(+191): db at url:
[mysql://127.0.0.1/dbmail?user=user&password=pwd&charset=utf8&unix-socket=/var/run/mysqld/mysqld.sock]
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_connect(+211): database connection pool started with [5] connections, max
[20]
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_con_close(+275): [0x9ada938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Debug:[auth]
auth_load_driver(+48): no value for library_directory, using default []
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Debug:[auth]
auth_load_driver(+64): looking for auth_sql as libauth_sql.so
Setting DELETE status for deleted messages...
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_con_get(+257): [0x9ada938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_exec(+312): [0x9ada938] [UPDATE dbmail_messages SET status = 3 WHERE status
= 2]
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
log_query_time(+290): last query took [0.001] seconds
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_con_close(+275): [0x9ada938] connection to pool
Ok. Messages set for deletion.
Re-calculating used quota for all users...
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_con_get(+257): [0x9ada938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_query(+344): [0x9ada938] [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 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
log_query_time(+290): last query took [0.016] seconds
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Database:[db]
db_con_close(+275): [0x9ada938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14624]: [0x9ad7b08] Debug:[db]
dm_quota_rebuild(+973): quotum is already up to date
Ok. Used quota updated for all users.
Maintenance done. No errors found.
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_connect(+191): db at url:
[mysql://127.0.0.1/dbmail?user=user&password=pwd&charset=utf8&unix-socket=/var/run/mysqld/mysqld.sock]
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_connect(+211): database connection pool started with [5] connections, max
[20]
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_con_close(+275): [0x8af4938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Debug:[auth]
auth_load_driver(+48): no value for library_directory, using default []
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Debug:[auth]
auth_load_driver(+64): looking for auth_sql as libauth_sql.so
Deleting messages with DELETE status...
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_con_get(+257): [0x8af4938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_exec(+312): [0x8af4938] [DELETE FROM dbmail_messages WHERE status=3]
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
log_query_time(+290): last query took [0.000] seconds
Jul 13 17:20:05 flecha dbmail-util[14626]: [0x8af1b08] Database:[db]
db_con_close(+275): [0x8af4938] connection to pool
Ok. Messages deleted.
Maintenance done. No errors found.
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_connect(+191): db at url:
[mysql://127.0.0.1/dbmail?user=user&password=pwd&charset=utf8&unix-socket=/var/run/mysqld/mysqld.sock]
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_connect(+207): run a database connection reaper thread every [60] seconds
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_connect(+211): database connection pool started with [5] connections, max
[20]
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_close(+275): [0x980c938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Debug:[auth]
auth_load_driver(+48): no value for library_directory, using default []
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Debug:[auth]
auth_load_driver(+64): looking for auth_sql as libauth_sql.so
Repairing DBMAIL messageblocks integrity...
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_get(+257): [0x980c938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_query(+344): [0x980c938] [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 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Error:[db]
db_query(+351): SQLException:
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Error:[db]
db_query(+352): failed query [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 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_close(+275): [0x980c938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Debug:[db]
db_icheck_messageblks(+1193): no lost messageblocks
Ok. Found [0] unconnected messageblks.
Repairing DBMAIL physmessage integrity...
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_get(+257): [0x980c938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_query(+344): [0x980c938] [SELECT COUNT(*) FROM dbmail_physmessage p LEFT
JOIN dbmail_messages m ON p.id = m.physmessage_id WHERE m.message_idnr IS NULL]
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
log_query_time(+290): last query took [0.005] seconds
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_close(+275): [0x980c938] connection to pool
Ok. Found [0] unconnected physmessages.
Repairing DBMAIL mimeparts integrity...
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_get(+257): [0x980c938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_query(+344): [0x980c938] [SELECT COUNT(*) FROM dbmail_mimeparts p LEFT JOIN
dbmail_partlists l ON p.id = l.part_id WHERE l.physmessage_id IS NULL]
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
log_query_time(+290): last query took [0.045] seconds
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_close(+275): [0x980c938] connection to pool
Ok. Found [0] unconnected mimeparts.
Repairing DBMAIL message integrity...
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_get(+257): [0x980c938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_query(+344): [0x980c938] [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 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
log_query_time(+290): last query took [0.002] seconds
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_close(+275): [0x980c938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Debug:[db]
db_icheck_messages(+1277): no lost messages
Ok. Found [0] unconnected messages.
Repairing DBMAIL mailbox integrity...
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_get(+257): [0x980c938] connection from pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_query(+344): [0x980c938] [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 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
log_query_time(+290): last query took [0.001] seconds
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Database:[db]
db_con_close(+275): [0x980c938] connection to pool
Jul 13 17:20:05 flecha dbmail-util[14628]: [0x9809b08] Debug:[db]
db_icheck_mailboxes(+1307): no lost mailboxes
Ok. Found [0] unconnected mailboxes.
Maintenance done. No errors found.
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
