I see the following error in my Alarms page...

Table temp.temp_tables was determined to be corrupted. Scrutinizer attempted to automatically repair the table. The result of the repair was: Repair Failed. If you have on-demand antivirus scanning enabled, it is highly recommended that you disable on-demand scanning of the Scrutinizer directory and all subdirectories.

No antivirus software is running.

When I go to attempt to view an interface I get the following message...

Oops! Scrutinizer is confused.

A request you made has returned data that Scrutinizer wasn't expecting.

Please click here to reload your current view.

Technical Information

Function Call: updateGraphAndTable()
Parameters:
Time: Mon 28-Jun 2010 23:03:39 UTC
XMLHttpRequest.readyState:4
Additional information: Scrutinizer 7.5.1.7498 (Scrutinizer)

There are more than 1 set of fingers in this pie, and it is possible they tried to free up some disk space and caused this condition. Any assistance would be appreciated.

Reece Boucher

Hello Reese,

Can you tell me what version of Scrutinizer you are running? And, when you get the Oops error, does it happen right away or does it take a while as if the report is timing out.

Thanks,
Scott

Scott,

7.5.1 is the version. The message takes about 10-15 sec to appear.

Reece...

Hello,

First, let's try to repair the temp.temp_tables database table if it's still corrupted.

Open a command prompt on the server and run: mysql -u root -p
That will come to a password prompt. This is where you enter the mysql root password, which defaults to blank if you didn't change it. If you haven't changed it, just hit enter at the password prompt.

Then enter:
repair table temp.temp_tables;
If it comes back with Msg_text field of OK, then the next step is to upgrade Scrutinizer to the latest released version, which is v7.7.1, available for download at:
http://www.plixer.com/support/availableUpdates.php

- Joanne

Hi All,

I get exactly the same message, I followed the advice given and I get the following message from mysql

mysql> repair table temp.temp_tables;
+------------------+--------+----------+----------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+----------------------------------------+
| temp.temp_tables | repair | Error | Table 'temp.temp_tables' doesn't exist |
| temp.temp_tables | repair | error | Corrupt |
+------------------+--------+----------+----------------------------------------+
2 rows in set (0.00 sec)

What can I do now?

Hi Reece,

Did you try upgrading to v7.7.1?

If you'd be interested that I take a closer look at the issue in a gotoMeeting, please send me your contact information at junest@plixer.com.

Thanks

yes, I upgraded to v7.7.1

It is the weekend now here so can we arrange a Goto early next week?

Hi, that would be fine.

Looks like the temp.temp_tables db table is missing and we'd like to replace that for you.

You can either email junest@plixer.com your contact info and we'll contact you, or call us at (207) 324-8805 x4 for customer support, or x3 if you are evaluating/presales support.

- Joanne