QueueMetrics forum

QueueMetrics => MySQL storage and Qloaderd/Uniloader => Topic started by: jacobusvn on May 22, 2009, 21:05:05

Title: The file sql:P001|P02 does not exist
Post by: jacobusvn on May 22, 2009, 21:05:05

I have a QM server where QM stopped working today and I found the database to be corrupted and managed to repair it but now every time I what to view report in QM I get the following error:

Alert: The file sql:P001|P02 does not exist

I don't know where to even start looking for the problem.

Please help if you can.

Many Thanks

Title: Re: The file sql:P001|P02 does not exist
Post by: QueueMetrics on May 23, 2009, 09:16:53

Most likely: Qm gets an error back from the database when trying to read the queue_log table.

Try connecting to the QM database from a MySQL interface and issue a

Code: [Select]

select * from queue_log limit 0,100
and see if you get data out of it.

Title: Re: The file sql:P001|P02 does not exist
Post by: jacobusvn on May 23, 2009, 10:37:57

queue_log table was corrupt.

A repair fixed my  problem.

I didn’t look in the mysql log.

Thanks

Title: Re: The file sql:P001|P02 does not exist
Post by: QueueMetrics on May 25, 2009, 10:02:53

That's okay.  ;D