We have 3 RDS MariaDB Databases (one 10.5.xx and two 10.4.xx respectively). Last Monday the databases were supposed to be updated automatically during the maintenance windows. The update did happen, a backup snapshot before the update was created and the version was increased however this also killed all the connections made to the database making the databases unusable. The same issues manifested itself today (second update)
Every connection in the MySQL-error-running.log is as follows
[Warning] Aborted connection 339 to db: 'unconnected' user: 'unauthenticated' host: '172.31.30.119' (This connection closed normally without authentication)
Also, the binlog crashes as well with the following Binlog position from crash recovery is null -1
The issues can be resolved either by updating the database version again from 10.4 to 10.5 or restoring from the before update snapshot. However, these are only solutions to the crash, and don't resolve the underlying issues. Did anyone else experience this issue and how did you resolve it?
AWS OFFICIALUpdated 2 years ago
