server# dbmail-util -a
Choosing dry-run mode. No changes will be made at this time.
Checking DBMAIL messageblocks integrity...
Ok. Found [0] unconnected messageblks.
Checking DBMAIL message integrity...
Ok. Found [0] unconnected messages.
Checking DBMAIL mailbox integrity...
Ok. Found [0] unconnected mailboxes.
Checking DBMAIL for NULL messages...
Ok. Found [0] NULL messages.
Checking DBMAIL for NULL physmessages...
Ok. Found [0] physmessages without messageblocks.
Counting messages with DELETE status...
Ok. [4379] messages have DELETE status.
Checking DBMAIL for rfcsize field...
Ok. Found [0] missing rfcsize values.
Checking DBMAIL for incorrect is_header flags...
Jul 23 18:34:46 NBMS01.netbasics dbmail-util[7469]: Warning:[db]
dbmodule.c,db_query(+151): slow que
ry [SELECT MIN(messageblk_idnr),MAX(is_header) FROM dbmail_messageblks
GROUP BY physmessage_id HAVIN
G MAX(is_header)=0] took [286] seconds
Ok. Found [0] incorrect is_header flags.
Checking DBMAIL for cached envelopes...
Ok. Found [0] missing envelope values.
Checking DBMAIL for cached header values...
Jul 23 18:35:41 NBMS01.netbasics dbmail-util[7469]: Warning:[db]
dbmodule.c,db_query(+151): slow que
ry [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 [46] seconds
Ok. Found [0] un-cached physmessages.
Counting deleted messages that need the DELETE status set...
Ok. [4341] messages need to be set for deletion.
Counting aliases with nonexistent delivery userid's...
Ok. Found [0] dangling aliases.
Vacuum and optimize not performed.
Maintenance done. No errors found.
dbmail.conf:
# $Id: dbmail.conf 2380 2006-11-18 13:35:06Z paul $
# (c) 2000-2006 IC&S, The Netherlands
#
# Configuration file for DBMAIL
[DBMAIL]
query_time_warning = 500
#
# Database settings
#
#
# Supported drivers are mysql, pgsql, sqlite.
#
driver = mysql
#
# Supported drivers are sql, ldap.
#
authdriver = sql
etc etc etc.
What's the time specified in the warning message?
On Mon, 2007-07-23 at 17:03 +0200, Anne wrote:
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
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
