The following are the last messages I get before the process stalls when I run dbmail-util -tf dbmail.conf:
Feb 24 11:02:22 LAMZ1LAPS001N1 lt-dbmail-util[23300]: [0x93e9008] Database:[db] db_con_get(+263): [0x93f40f8] connection from pool Feb 24 11:02:22 LAMZ1LAPS001N1 lt-dbmail-util[23300]: [0x93e9008] Database:[db] db_query(+363): [0x93f40f8] [SELECT p.id FROM dbmail_mimeparts p LEFT JOIN dbmail_partlists l ON p.id = l.part_id WHERE l.part_id IS NULL] Feb 24 11:02:48 LAMZ1LAPS001N1 lt-dbmail-util[23300]: [0x93e9008] Database:[db] log_query_time(+307): last query took [26.136] seconds Feb 24 11:02:48 LAMZ1LAPS001N1 lt-dbmail-util[23300]: [0x93e9008] Notice:[db] log_query_time(+311): slow query [SELECT p.id FROM dbmail_mimeparts p LEFT JOIN dbmail_partlists l ON p.id = l.part_id WHERE l.part_id IS NULL] took [26.136] seconds The dbmail-util options c b p d and s all appear to work well. I just can't get "t" to work and I can't push these changes through to our production database until I'm sure of things. We used to have about 6.4 million messages in the database. Could the number of things being deleted somehow be causing a problem? We are trying to run the process to clean the database and cut it down to about 200k messages. From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of Gray, Patrick Sent: Monday, February 24, 2014 10:52 AM To: DBMail mailinglist Subject: Re: [Dbmail] Dbmail-util functionality problems This is in reference to this post: http://dbmail.10918.n7..nabble.com/Dbmail-util-functionality-problems-td33908.html From: dbmail-boun...@dbmail.org<mailto:dbmail-boun...@dbmail.org> [mailto:dbmail-boun...@dbmail.org] On Behalf Of Gray, Patrick Sent: Monday, February 24, 2014 10:48 AM To: DBMail mailinglist (dbmail@dbmail.org<mailto:dbmail@dbmail.org>) Subject: Re: [Dbmail] Dbmail-util functionality problems Hello Everyone, It's been a while since I last updated on this problem. After I grabbed the dbmail 3.1.10 version that Paul said should fix the problem, I tried compiling and running it, but the IMAP processes somehow spun out of control and I decided not to update. Is there a solution to make the dbmail-util -t problem work on dbmail version 3.1.7? Would there be a huge problem if I compiled version 3.1.10 and used its dbmail-util on my current database? Thanks for your time.
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
