Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,673
Community Members
 
Community Events
176
Community Groups

server down after LTS upgrade: AWS RDS blocking the msyql client

Edited

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)

 

 

 

1 comment

Did you ever figure this out?

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events