Search code examples
databasequeueintegrityotrs

Delete a queue via Database

Currently I run some tests with OTRS.

I searched for a possibility to delete the waste queues and found somewhere a tip to do that via deleting the records in the database.

Proceed:

  • Removing constraint:

    ALTER TABLE queue_standard_response DROP FOREIGN KEY ‘FK_queue_standard_response_queue_id_id’;

  • Deleting the records

    For one thing in the queue table, and for another thing in the queue_standard_response table.

  • ADD constraint again

    ALTER TABLE queue_standard_response ADD CONSTRAINT FK_queue_standard_response_queue_id_id FOREIGN KEY (queue_id) REFERENCES queue (id);

The problem is, that I still see the deleted queues in Queue Manager also after clearing the browser cache. Out of which table is OTRS fetching these information?

Do someone have a solution?

Solution

  • It's the local OTRS application cache. If you'd run bin/otrs.DeleteCache.pl on the command line, you'd be fine.