How can I get a server up when our AWS RDS is rejecting connections from it after an upgrade ? Currently our confluence server ahs been down for 5 hours after I ran an updated from LTS '7.13.0' to LTS '7.13.4' ?
We used the binary upgrade method.
I reviewed the https://confluence.atlassian.com/doc/upgrading-confluence-4578.html
But, we are dead in the water. Any suggestions ?
Known errors: AWS RDS is not liking the errors from Conflunce and being blocked:
ERROR 1129 (HY000): Host '10.128.1.101' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
I can not flush the hosts. A reboot of RDS didn't fix this.
It seems confluence is sending errors to our RDS instance and getting blocked.
earlier errors:
systemctl restart confluence; tail -f /var/atlassian/confluence/logs/catalina.out
2022-03-04 08:29:36,626 ERROR [Catalina-utility-1] [confluence.impl.setup.DefaultBootstrapDatabaseAccessor] getBootstrapData Unable to open database connection during bootstrap.
java.sql.SQLException: The connection property 'useSSL' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value ''false' is not in this set.
[root@confluence0p ~]# systemctl restart confluence; tail -f /var/atlassian/confluence/logs/catalina.out | grep -i error
log4j:ERROR Could not find value for key log4j.appender.luceneQuery
log4j:ERROR Could not instantiate appender named "luceneQuery".
2022-03-04 08:37:21,398 ERROR [Catalina-utility-1] [confluence.impl.setup.DefaultBootstrapDatabaseAccessor] getBootstrapData Unable to open database connection during bootstrap.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
04-Mar-2022 08:39:13.103 SEVERE [http-nio-8080-exec-9] org.apache.catalina.core.StandardHostValve.custom Exception Processing ErrorPage[errorCode=500, location=/500page.jsp]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
