Unsolved
This post is more than 5 years old
8 Posts
0
687
June 4th, 2013 08:00
W4N BackEnd Cache log error - Error encountered while pushing file
I am receiving the following error in my cache log
Error encountered while pushing file 'property_13703574407892135303414.mysql' into the table 'data_property' (retry #0)!
java.sql.SQLException: Table '.\apg\data_property' is marked as crashed and last (automatic?) repair failed.
Is there a way to manually fix the DB? Any ideas as to what might be the issue or where to look? I do have some atf files that havent been processed and are about 11K.
No Events found!
BenimusIQ
12 Posts
0
June 4th, 2013 16:00
Hello,
There are many possible reasons that could have caused this, so you will need to check why, such as if the box had crashed, was not shut down properly, has filesystem errors, has run out of space, etc.
In order to fix it you will need to perform some MySQL maintenance. You can try entering the MySQL client (/opt/APG/bin/mysql-client.sh) and performing a REPAIR TABLE data_property (see MySQL :: MySQL 5.0 Reference Manual :: 13.7.2.6 REPAIR TABLE Syntax).
If this does not work you will need to try things like the commandline utility mysqlcheck --auto-repair -A (you will need to pass the port information as well as the admin user/pass to this command as the APG DB doesn't typically run on the default MySQL port).
Once MySQL is fixed you will also need to stop the Backend process and fix up all the files that you need to process, it is likely these have all been set to ".failed" in the filename, and will need to be changed back before the Backend will process them.
Benjamin Johns
iQ Consult Pty Ltd