We're running OTRS 6.0.30 on Ubuntu 20.04 with MariaDB 10.3. I've just enabled Kernel::System::Ticket::IndexAccelerator::StaticDB following https://doc.znuny.org/legacy/manual/adm ... uning.html and have received an email that looks like this:
Code: Select all
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`ticket_index`, CONSTRAINT `FK_ticket_index_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`)) at /usr/local/src/otrs-6.0.30/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker-10 Perl: 5.30.0 OS: linux Time: Thu Aug 10 01:33:44 2023
Message: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`ticket_index`, CONSTRAINT `FK_ticket_index_ticket_id_id` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`)), SQL: '
INSERT INTO ticket_index
(ticket_id, queue_id, queue, group_id, s_lock, s_state, create_time)
VALUES (?, ?, ?, ?, ?, ?, ?)'
Traceback (86229):
Module: Kernel::System::Ticket::IndexAccelerator::StaticDB::TicketAcceleratorRebuild Line: 601
Module: Kernel::System::Ticket::TicketAcceleratorRebuild Line: 7404
Module: (eval) Line: 144
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run Line: 123
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run Line: 235
Module: (eval) Line: 330
Module: main::Start Line: 330
Module: /usr/local/otrs/bin/otrs.Daemon.pl Line: 151
Thanks.