<div dir="ltr"><div><div><div><div><div>Hi,<br></div>we are recognizing internally a strange behaviour with push notifications.<br></div>Aerogear server seems to be no more reachable and looking in jboss (wildfly) logs for some explanations, we founds some ups database table are crashed and "need" to be repaired.<br></div>Have you ever experienced this scenario and eventually could you suggest me an approach to solve it? Googling about the error messages, someone suggest to repair tables using a specific command; otherwise i could drop the crashed tabled and creating them using the sql creation code from another running installation of unified push database. Crashed tables seem to be variant_metric_info and push_message_info.<br><br></div>Thanks anyway for your important support and for the time you'll spend reading this mail.<br></div>Federico.<br><div><div><br>
<p class="MsoNormal"><span lang="EN-US">08:51:26,167
WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1)
SQL Error: 126, SQLState: HY000</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">08:51:26,214
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1)
Incorrect key file for table '.\unifiedpush\variant_metric_info.MYI'; try to
repair it</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">08:51:26,230
WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1)
Table 'variant_metric_info' is marked as crashed and should be repaired</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Caused by:
java.sql.SQLException: Incorrect key file for table
'.\unifiedpush\variant_metric_info.MYI'; try to repair it<br><br></span></p><p class="MsoNormal"><span lang="EN-US">Here about reparing tables: </span>
</p><p class="MsoNormal"><a href="https://stackoverflow.com/questions/4357270/table-is-marked-as-crashed-and-should-be-repaired">https://stackoverflow.com/questions/4357270/table-is-marked-as-crashed-and-should-be-repaired</a>
</p>
<p class="MsoNormal"><br><span lang="EN-US"></span></p>
</div></div></div>