I put query_time_warning = 500 in dbmail.conf under the DBMAIL section.
dbmail-util still gives me a warning. Do I need to restart anything?
thanks,
Anne
You aren't really an end-user, though. You're somewhere in the middle.
This is a message from inside the mail system saying, "Hey, the client
might be experiencing slowness, and this is a possible symptom, so the
mail administrator is going to need to take a look at this."
You can adjust the query time escalation thresholds with the following
dbmail.conf options that take integer arguments (number of seconds):
[DBMAIL]
query_time_info
query_time_message
query_time_warning
These default to 10, 20, and 30 seconds, respectively. I think if you
just raise the warning time you'll be fine.
Aaron
On Mon, 2007-07-23 at 15:00 +0200, Anne wrote:
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
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
