1

Topic: whitelist / blacklist internal server error

After upgrading iredadmin to version 1.4.0 I get an internal server error when opening the whitelist or blacklist under system.

I also get a lot of messages in the logwatch

Here are a few examples:

(!!)ERROR sql_storage: too many retries on storing final, info not saved: 963 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-DKwgv48KiL5D-0' for key 1 at (eval 98) line 166, <GEN14> line 60097.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-PKcGTtGKv6PG-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-ox3zi8NSzMFQ-0' for key 1 at (eval 98) line 166, <GEN14> line 9051.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qEkKIHdc47fV-0' for key 1 at (eval 98) line 166, <GEN14> line 58438.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-O8MGoXJPWMgK-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-Lb9thTCrPkWL-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-zS2ztH0NMVl5-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-SY362HIHlYH1-0' for key 1 at (eval 98) line 166, <GEN14> line 4071.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-npIY5+KDmoY6-0' for key 1 at (eval 98) line 166, <GEN14> line 40790.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-JbpUrf7uUitB-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-J9K528lFyqdi-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-8+n4Z-O-rMyn-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qDXW+q-y6ENo-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-SNyRxV-olHgu-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-8xrGm44kPQvx-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-kILAaqQqk8ax-0' for key 1 at (eval 98) line 166, <GEN14> line 764.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-MuQi9GiD+6+D-0' for key 1 at (eval 98) line 166, <GEN14> line 17012.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-4ZfURWTbpjdY-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-uR+jr1+-a2-P-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-DwFmq0pEaN1K-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-BLfQWcx2lWI8-0' for key 1 at (eval 98) line 166, <GEN14> line 9092.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-R2FixD1eEnyb-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-tNViAE8ZsjKM-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-xXOYEqMpP1ql-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-u8zbMNPT3NQU-0' for key 1 at (eval 98) line 166, <GEN14> line 3194.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-UTYCNnLg8QDN-0' for key 1 at (eval 98) line 166, <GEN14> line 5098.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qJ0q2vKl0J8y-0' for key 1 at (eval 98) line 166, <GEN14> line 99421.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-Hw+IfT1TzsxV-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-dElMoJhvWY1O-0' for key 1 at (eval 98) line 166.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-xWCpnX4EyVjF-0' for key 1 at (eval 98) line 166.: 5 Time(s)

2

Re: whitelist / blacklist internal server error

Seems your server is busy. Try to increase max connections of mysql in /etc/my.cnf (search 'max_connections' in this file), restart mysql service, and it should fix this issue.

3 (edited by veldsink 2011-02-03 18:20:15)

Re: whitelist / blacklist internal server error

max_connections is not set in this file. is there a default for this variable?

Is this also the reason for the internal server error?

I also found out that I'm unable to open de catch-all option with a domain. I get the message permission denied.

4

Re: whitelist / blacklist internal server error

You can add below settings in section [mysqld]:

set-variable = max_connections=1024

5

Re: whitelist / blacklist internal server error

I have same error message after set-variable = max_connections=1024

**Unmatched Entries**
    (!!)ERROR sql_storage: too many retries on storing final, info not saved: 125 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-wHSOCS5bMaxe-0' for key 1 at (eval 102) line 166, <GEN15> line 16070.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-SmHamhrlQMkO-0' for key 1 at (eval 102) line 166, <GEN15> line 62077.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-wh-0YfMjFicK-0' for key 1 at (eval 102) line 166, <GEN15> line 88877.: 5 Time(s)
    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-ySphir7txVU2-0' for key 1 at (eval 102) line 166, <GEN15> line 235068.: 5 Time(s)

6

Re: whitelist / blacklist internal server error

Try to increase max connections to 2048 or even larger.

7

Re: whitelist / blacklist internal server error

ZhangHuangbin wrote:

Try to increase max connections to 2048 or even larger.


I'd increase max connections, but it's seems white-list & blacklist doesn't working now.
anywhere to troubleshoot it ?

8

Re: whitelist / blacklist internal server error

jackwjy wrote:

I'd increase max connections, but it's seems white-list & blacklist doesn't working now.

What do you mean it doesn't work? Any related apache log?

9

Re: whitelist / blacklist internal server error

sample: I add @message.cmbchina.com to sender white-list,

but mail from @message.cmbchina.com still appear in Quarantined list

10

Re: whitelist / blacklist internal server error

I still can't open the whitelist or blacklist.

I also still get the "unmatched entries"errors.

11

Re: whitelist / blacklist internal server error

veldsink wrote:

I also still get the "unmatched entries"errors.

Where did you get this error message? Any other related log?

12

Re: whitelist / blacklist internal server error

I have this message in the logwatch.

13

Re: whitelist / blacklist internal server error

Did you try to increase mysql max_connections setting?
If it still happens, you have to disable it in Amavisd (@storage_sql_dsn).

14

Re: whitelist / blacklist internal server error

I had increased the mysql max_connections setting to 2048.

Now I have disabled it in Amavisd

15

Re: whitelist / blacklist internal server error

veldsink wrote:

    (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-qEkKIHdc47fV-0' for key 1 at (eval 98) line 166, <GEN14> line 58438.: 5 Time(s)

Solved:
http://www.iredmail.org/forum/topic1677 … issue.html