Duplicate entry for key 1

Moderator: crythias

Locked
breun
Znuny newbie
Posts: 2
Joined: 20 Feb 2012, 13:18
Znuny Version: Three

Duplicate entry for key 1

Post by breun »

We're seeing error messages like these in /var/log/messages:
OTRS-CGI-1[19587]: [Error][Kernel::System::Ticket::Article::ArticleFlagSet][Line:3035]: Duplicate entry '79173' for key 1, SQL: 'INSERT INTO article_flag (article_id, article_key, article_value, create_time, create_by) VALUES (?, ?, ?, '2012-10-29 10:22:58' , ?)'
And correspodning error messages like these in /var/log/httpd/error_log:
-e: DBD::mysql::db do failed: Duplicate entry '79173' for key 1 at /opt/otrs//Kernel/System/DB.pm line 478.
What could be wrong? Working in the user interface everything seems to work fine, but these error messages are worrying us.
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Duplicate entry for key 1

Post by jojo »

your databaase seems to be crashed
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Duplicate entry for key 1

Post by jojo »

so you should repair and optimze your tables
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked