Getting repeated errors in EM log stating that the DB is not avavilable
1/24/19 02:21:37.296 PM GMT [ERROR] [Thread-41] [Manager.AppMap] org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from aca_acl]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "aca_acl" does not exist Position: 15 ..... Caused by: org.postgresql.util.PSQLException: ERROR: relation "aca_acl" does not exist Position: 15 ...... 1/24/19 02:21:37.297 PM GMT [INFO] [Thread-41] [Manager.AppMap] DB is not available. Next attempt to retry to connect in 15 seconds.
Cause
The message in this case is not entirely correct as the database is available but the syetem is interpretting the fact that a DB related function is failing as an DB down situation. Other DB activities were proceeding correctly.
The key in this case is the message ERROR: relation "aca_acl" does not exist - this indicates a missing table in the database
Environment
APM 10.7 with Postgres DB
Resolution
Use the following SQL to identfy the tables present
SELECT tablename FROM pg_catalog.pg_tables where tableowner='admin' order by tablename; tablename
Provide the result to support who will provide required SQL to recreate missing tables