1

Topic: Error duplicate updatelog_pkey

======== Required information ====
- iRedMail version: 0.8.5
- iRedAdmin-Pro: 1.3.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Linux/BSD distribution name and version: Debian 7 64bit
- Related log if you're reporting an issue:
====
Hi, today is appeared this text in admin: "Error: Error while checking new version of iRedAdmin-Pro: duplicate key value violates unique constraint "updatelog_pkey" DETAIL: Key (date)=(2013-11-21) already exists."

http://i42.tinypic.com/5wz4o1.png

releated log (..postgresql/postgresql-9.1-main.log):
...
2013-11-21 17:01:53 CET LOG:  unexpected EOF on client connection
2013-11-21 17:01:53 CET LOG:  could not receive data from client: Connection reset by peer
2013-11-21 17:01:53 CET LOG:  unexpected EOF on client connection
2013-11-21 17:18:00 CET ERROR:  duplicate key value violates unique constraint "updatelog_pkey"
2013-11-21 17:18:00 CET DETAIL:  Key (date)=(2013-11-21) already exists.
2013-11-21 17:18:00 CET STATEMENT:  INSERT INTO updatelog (date) VALUES ('2013-11-21')
2013-11-21 17:19:10 CET LOG:  could not receive data from client: Connection reset by peer
2013-11-21 17:19:10 CET LOG:  unexpected EOF on client connection
...

thanks

2

Re: Error duplicate updatelog_pkey

Does it happen every time you access iRedAdmin-Pro?

It's strange why you get a "connection reset by peer" error in a Country outside China mainland.

3

Re: Error duplicate updatelog_pkey

ZhangHuangbin wrote:

Does it happen every time you access iRedAdmin-Pro?

seems not
but the strange thing is that today is appear again

ZhangHuangbin wrote:

It's strange why you get a "connection reset by peer" error in a Country outside China mainland.

my complete postgres log: http://pastebin.com/2SRThiPm

4

Re: Error duplicate updatelog_pkey

I have no idea at all. Not sure what the problem is. So sorry about this trouble.

5

Re: Error duplicate updatelog_pkey

*) What's your Amavisd version?
*) Did you try to delete Amavisd database, then re-create it?

6

Re: Error duplicate updatelog_pkey

ZhangHuangbin wrote:

*) What's your Amavisd version?

amavisd-new 2.7.1-2

ZhangHuangbin wrote:

*) Did you try to delete Amavisd database, then re-create it?

how to do it?

thank you for your help

7

Re: Error duplicate updatelog_pkey

*) Delete database "amavisd".
*) Create new database "amavisd", then import SQL structure here: https://bitbucket.org/zhb/iredmail/src/ … .7.0.pgsql