StandardPlugins.Database. NonQuery - SQL Monitor Problem ?

[trancemode]

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.

[ECF]

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

[trancemode]

alright thanks. will try that out.

[trancemode]

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.

[ECF]

You should probably put in a support ticket. Luis knows more about the MYSql issue than I. He should be able to help you out a bit more.