Robert_Borowicz

UIM - MySQL upgrade

Discussion created by Robert_Borowicz on May 13, 2015

UIM 8.2 requires MySQL newer than 5.1.73 which is what I installed 8.0 onto.  I've upgraded MySQL 5.1.73 using yum to 5.5-43 and that completed fine. But now starting up 8.0 I have a unusable/corrupted table:

 

May 13 08:56:26:475 [140128563226368] de: data_engine [LSV] [LSV] - Execute1(query) - Error: [LSV] thread_id: 54, error: Execute1(quer

y): Cannot load from mysql.proc. The table is probably corrupted (errno:1548)

May 13 08:56:26:475 [140128563226368] de: lastsamplevalue_thread - ExecuteSync() returned: error (1)

May 13 08:56:48:857 [140128584206080] de: [QOS Definition Metric] thread_id: 13, query failed: call `spn_de_UpdateQosDefMetric` (123,'

M533818ABE18C991CFC51E1271FD881E4',0,@pErrorMessage,@pReturnCode);, took 0 ms

May 13 08:56:48:857 [140128584206080] de: data_engine [QOS Definition Metric] [QOS Definition Metric] - Execute1(query) - Error: [QOS

Definition Metric] thread_id: 13, error: Execute1(query): Cannot load from mysql.proc. The table is probably corrupted (errno:1548)

May 13 08:56:48:857 [140128584206080] de: qos_definition_metric_db_write - error: [[QOS Definition Metric] thread_id: 13, error: Execu

te1(query): Cannot load from mysql.proc. The table is probably corrupted (errno:1548)] sp: [ spn_de_UpdateQosDefMetric ]

May 13 08:56:48:857 [140128584206080] de: qos_definition_metric_db_write - Output Parameters returned from SP....size: 0

May 13 08:56:55:707 [140128563226368] de: [LSV] thread_id: 64, query failed: call spn_de_UpdateQosSnapshot (1,0,@pErrorMessage,@pRetur

nCode), took 0 ms

 

Anybody else seen this?

 

Support has not seen this issue in the past.

 

Thanks

 

-Rob

Outcomes