Jump to content

StandardPlugins.Database. NonQuery - SQL Monitor Problem ?


trancemode

Recommended Posts

Was wondering if anyone know what this could mean and how to fix it?

 

"StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.45-community]Out of range value for column 'PERF_VALUE' at row 1 SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC7286108406343543040615', '2010-04-20 20:30:21', '9.223372E+18')"

 

Is it basically the TC_Server_Performance causing the problem?

Or is it the ODBC ?

 

Thanks.

Link to comment
Share on other sites

Looks like that table may be corrupt. Grab the MYSql GUI tools from their website and do a repair on it.

 

Hey ECF,

 

So, I use the MYSQL GUI and did maintenance > repair

 

The SQL I was using is innoDB and I believe i get the message saying

the "The storage engine for the table doesn't support repair" or some sort.

 

and I believe innoDB auto repair it self.

 

However, should I convert innoDB storage to MYISAM?

and try the repair again?

 

thanks.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Who's Online   0 Members, 0 Anonymous, 38 Guests (See full list)

    • There are no registered users currently online
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Terms of Use