I am using OTRS Version: 6.0.2
I am using OS: Debian 9.3 (without GUI)
I am using Database: MySQL 15.1, Distrib 10.1.26-MariaDB
I have this problem:
I'm getting these messages in the system protocol:
OTRS-CGI-10 Duplicate entry '24-Seen-2' for key 'ticket_flag_per_user', SQL: '
I looked at the syslog and there are two entries for this:
Code: Select all
Jan 5 10:20:41 XXX-otrs OTRS-CGI-10[723]: [Error][Kernel::System::Ticket::TicketFlagSet][Line:6597]: Duplicate entry '24-Seen-2' for key 'ticket_flag_per_user', SQL: '#012 INSERT INTO ticket_flag#012 (ticket_id, ticket_key, ticket_value, create_time, create_by)#012 VALUES (?, ?, ?, '2018-01-05 09:20:40', ?)'
Jan 5 10:20:41 XXX-otrs OTRS-CGI-10[751]: [Error][Kernel::System::Ticket::TicketFlagSet][Line:6597]: Duplicate entry '24-Seen-2' for key 'ticket_flag_per_user', SQL: '#012 INSERT INTO ticket_flag#012 (ticket_id, ticket_key, ticket_value, create_time, create_by)#012 VALUES (?, ?, ?, '2018-01-05 09:20:40', ?)'
Code: Select all
Jan 5 11:26:34 XXX-otrs OTRS-CGI-10[751]: [Error][Kernel::System::AuthSession::DB::DESTROY][Line:601]: Deadlock found when trying to get lock; try restarting transaction, SQL: '#012 DELETE FROM sessions#012 WHERE session_id = ?#012 AND data_key = ?#012 AND id <= ?'
Does anybody know where this is coming from and how I can prevent it?
I'm not able to reproduce it, but the message occurs several times a day, always with a different number.
I didn't do any changes to the database since the installation.
Thanks for your help.
Best regards.