We have this script running which calls dbmail-util. If a warning or error occurs an email is sent. Since 2.2.6 we get an email every day because of this query warning. This is kind of annoying. I'd strongly suggest you put this info under the verbose option. We end-users can't do anything with that info, right?

thanks,
Anne

I added query timing code to 2.2.6 so that we can find out which of our
queries are still taking way too long. The longest default time is 30
seconds, which bumps the query up to the WARNING (level 2).

Because this dbmail-util query is issued by the sysadmin it's not
something we'd necessarily need to work about.

Aaron

On Mon, 2007-07-16 at 08:33 +0200, Anne wrote:
Running dbmail-util, I get this warning all the time:

Checking DBMAIL for cached header values...
Jul 16 08:22:02 server.domain dbmail-util[15889]: Warning:[db] dbmodule.c,db_query(+151): slow qu ery [SELECT p.id FROM dbmail_physmessage p LEFT JOIN dbmail_headervalue h ON p.id = h.physmessage_id
 WHERE h.physmessage_id IS NULL] took [48] seconds
Ok. Found [0] un-cached physmessages.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


hi all,

I've uploaded v2.2.6-rc1

The main highlights:

- - fixes an error in the imap code that was plaguing squirrelmail users
- - support for imap IDLE
- - adds support for duplicate suppression
- - extends the capabilities of the dbmail-export tool

download:

http://www.dbmail.org/download/2.2/dbmail-2.2.6-rc1.tar.gz

debs:

deb http://debian.nfgd.net/debian stable main

full changelog:

http://nfg3.nfgs.net/cgi-bin/gitweb.cgi?p=dbmail.git;a=log;h=dbmail_2_2

- --
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGmNEG8iITvBH4zTERAo8QAJ9SqhiOYd5E1JrFPeTKsqzBnNGM3QCdHM6r
siLNKkVRrhiT6fKrZlcZiZ8=
=XpN6
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to