Hi,
we are recognizing internally a strange behaviour with push notifications.
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.
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.
Thanks anyway for your important support and for the time you'll spend reading this mail.
Federico.
08:51:26,167
WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1)
SQL Error: 126, SQLState: HY000
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
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
Caused by:
java.sql.SQLException: Incorrect key file for table
'.\unifiedpush\variant_metric_info.MYI'; try to repair it
Here about reparing tables:
https://stackoverflow.com/questions/4357270/table-is-marked-as-crashed-and-should-be-repaired
_______________________________________________
Aerogear-users mailing list
[hidden email]
https://lists.jboss.org/mailman/listinfo/aerogear-users