We have one queue table. The data volume in this queue table very very low.
But someone tried to do a manual delete from the queue table. Now I think the queue table has been corrupted.
Some of the jobs which reads from the queue table is not able to read it, its constantly trying to read and not finding any message. Whereas some other jobs are able to queue message and dequeue it from the same queue.
My question is "Is there any way fix this issue without dropping and recreating the queue?"