You are not logged in. Please login or register.
iRedMail → iRedMail Support → mysql error
Hi
i have this error in /var/log/mail.log from amavis
!)WARN save_info_preliminary: sql exec: err=1205, HY000, DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at (eval 115) line 166, <GEN43> line 2084
It's correct?
thks
Enrico
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.
Looks like your MySQL server is busy.
Try to increase max-connections in mysql config file my.cnf.
Looks like your MySQL server is busy.
Try to increase max-connections in mysql config file my.cnf.
this my settings.. set-variable = max_connections= 2048
when i upgrade iredadmin to version 1.5 there is a amavisd tread that block the table..
bye Enrico
it's a normal situation that i have table msgs 6.6 GB and msgrcpt 3.4 GB?
i have set AMAVISD_REMOVE_MAILLOG_IN_DAYS and AMAVISD_REMOVE_QUARANTINED_IN_DAYS to 2 days..
when i click on dashboard i waiting for 700/800 seconds..
Bye
Are you running iRedMail with MySQL backend and have iRedAPD running? If so, could you please try this step to fix it?
http://www.iredmail.org/forum/post9059.html#p9059
http://www.iredmail.org/forum/post9059.html#p9059
i run iRedAPD but i have iredmail with ldap backend..
http://www.iredmail.org/forum/post9059.html#p9059
i run iRedAPD but i have iredmail with ldap backend..
any ideas?
it's a normal situation that i have table msgs 6.6 GB and msgrcpt 3.4 GB?
i have set AMAVISD_REMOVE_MAILLOG_IN_DAYS and AMAVISD_REMOVE_QUARANTINED_IN_DAYS to 2 days..
when i click on dashboard i waiting for 700/800 seconds..
So many records.
Can you try logging into iRedAdmin-Pro, then accessing 'System -> Sent Mails/Received Mails/Quarantined Mails'? It will delete records which are orlder than 2 days automatically.
If the load time of Dashboard page still too long (we should reduce it to less than 10-30 seconds), please do contact me again.
Casa.it wrote:it's a normal situation that i have table msgs 6.6 GB and msgrcpt 3.4 GB?
i have set AMAVISD_REMOVE_MAILLOG_IN_DAYS and AMAVISD_REMOVE_QUARANTINED_IN_DAYS to 2 days..
when i click on dashboard i waiting for 700/800 seconds..So many records.
Can you try logging into iRedAdmin-Pro, then accessing 'System -> Sent Mails/Received Mails/Quarantined Mails'? It will delete records which are orlder than 2 days automatically.If the load time of Dashboard page still too long (we should reduce it to less than 10-30 seconds), please do contact me again.
Hi Zhang
no records are not delete, this situation make the system slow, all querys to mysql are slow.
Can you help me? i make a downgrade from 1.5 because the situation was worse.
Bye
Hi Casa.
Can you try to delete old quarantined mails manually, and see whether it will be faster after deleted?
Here's SQL command used to delete old quarantined mails:
http://www.iredmail.org/wiki/index.php? … s.Manually
Hi Casa.
Can you try to delete old quarantined mails manually, and see whether it will be faster after deleted?
Here's SQL command used to delete old quarantined mails:
http://www.iredmail.org/wiki/index.php? … s.Manually
The quarantine mails are not a problem i delete mails day by day, for me the problem is sent/receive mail.
Bye
The quarantine mails are not a problem i delete mails day by day, for me the problem is sent/receive mail.
Try this:
http://www.iredmail.org/wiki/index.php? … g.Manually
Casa.it wrote:The quarantine mails are not a problem i delete mails day by day, for me the problem is sent/receive mail.
Try this:
http://www.iredmail.org/wiki/index.php? … g.Manually
I killed the query after 50 minutes is not finished... can troncate the table msgs and msgrcpt??
Bye
I killed the query after 50 minutes is not finished... can troncate the table msgs and msgrcpt??
Truncate whole table (msgs, msgrcpt) will also delete quarantined mails.
You can try to release/delete quarantined mails first, then truncate tables msgs and msgrcpt.
Casa.it wrote:I killed the query after 50 minutes is not finished... can troncate the table msgs and msgrcpt??
Truncate whole table (msgs, msgrcpt) will also delete quarantined mails.
You can try to release/delete quarantined mails first, then truncate tables msgs and msgrcpt.
ok now the situation is fast, and i have upgrade to iredadmin 1.5, how can I prevent this happen again?
Thks
Enrico
how can I prevent this happen again?
Setup a crontab job, delete from msgs/msgrcpt in a regular intervals.
Casa.it wrote:how can I prevent this happen again?
Setup a crontab job, delete from msgs/msgrcpt in a regular intervals.
with this istruction? http://www.iredmail.org/wiki/index.php? … g.Manually
it's possible to insert this such as a feature?
Thks..
with this istruction? http://www.iredmail.org/wiki/index.php? … g.Manually
Yes.
Older records should be deleted automatically when you access "System -> Sent/Received/Quarantined Mails" in iRedAdmin-Pro, it must be a bug, and i will try to solve it in next release.
it's possible to insert this such as a feature?
Will try.
Casa.it wrote:with this istruction? http://www.iredmail.org/wiki/index.php? … g.Manually
Yes.
Older records should be deleted automatically when you access "System -> Sent/Received/Quarantined Mails" in iRedAdmin-Pro, it must be a bug, and i will try to solve it in next release.
it's possible to insert this such as a feature?
Will try.
Thanks for your help!
iRedMail → iRedMail Support → mysql error
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 2 official extensions. Copyright © 2003–2010 PunBB.
Generated in 0.021 seconds (58% PHP - 42% DB) with 11 queries