Database table problems causing 502 Error
-
Twice today, the nginx server reported a 502 error with a “Bad Gateway”. In both cases, I stopped and restarted the services to temporarily fix the problem. In the second time, I was able to access the main page but the 502 error returned when trying to access <base url>/wp-admin.
The system then reported a database table issue and asked me to allow it to try and automate its own repair. Here is the output from that attempt:
The wpkc_users table is okay.
The wpkc_usermeta table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_usermeta table. Error: 1 client is using or hasn’t closed the table properlyThe wpkc_posts table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_posts table. Error: 1 client is using or hasn’t closed the table properlyThe wpkc_comments table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_comments table. Error: 1 client is using or hasn’t closed the table properlyThe wpkc_links table is okay.
The wpkc_options table is not okay. It is reporting the following error: Table is marked as crashed. WordPress will attempt to repair this table…
Failed to repair the wpkc_options table. Error: Table is marked as crashedThe wpkc_postmeta table is not okay. It is reporting the following error: 2 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_postmeta table. Error: 2 clients are using or haven’t closed the table properlyThe wpkc_terms table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_terms table. Error: 1 client is using or hasn’t closed the table properlyThe wpkc_term_taxonomy table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_term_taxonomy table. Error: 1 client is using or hasn’t closed the table properlyThe wpkc_term_relationships table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_term_relationships table. Error: 1 client is using or hasn’t closed the table properlyThe wpkc_termmeta table is okay.
The wpkc_commentmeta table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
Failed to repair the wpkc_commentmeta table. Error: 1 client is using or hasn’t closed the table properlySome database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
wpkc_usermeta: 1 client is using or hasn’t closed the table properly
wpkc_posts: 1 client is using or hasn’t closed the table properly
wpkc_comments: 1 client is using or hasn’t closed the table properly
wpkc_options: Table is marked as crashed
wpkc_postmeta: 2 clients are using or haven’t closed the table properly
wpkc_terms: 1 client is using or hasn’t closed the table properly
wpkc_term_taxonomy: 1 client is using or hasn’t closed the table properly
wpkc_term_relationships: 1 client is using or hasn’t closed the table properly
wpkc_commentmeta: 1 client is using or hasn’t closed the table properly———————-
So, I’m asking for help on how to fix these problems.
Thanks.
The page I need help with: [log in to see the link]
The topic ‘Database table problems causing 502 Error’ is closed to new replies.