Questions tagged with Aurora MySQL

Content language: English

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

Aurora Serverless v2 crashed with signal 11

Hello everyone! I recently migrated my MariaDB database to Aurora Serverless v2 (3 weeks ago) and today our Aurora restarted by itself at 11:22. I got the log, but I didn't understand what could have been the cause. (Because of the time zone the db hits 14:22, but it's normal). ``` 14:19:34 UTC - mysqld got signal 11 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x4000604d2000 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 4001070825a7 thread_stack 0x40000 /rdsdbbin/oscar/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2b) [0x23fac0b] /rdsdbbin/oscar/bin/mysqld(handle_fatal_signal+0x3db) [0x1262adb] linux-vdso.so.1(+0x85b) [0x400007d5a85b] /rdsdbbin/oscar/bin/mysqld(bind_fields(Item*)+0x20) [0x1077e20] /rdsdbbin/oscar/bin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x5bb) [0xff3c3b] /rdsdbbin/oscar/bin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xe7) [0xff46a7] /rdsdbbin/oscar/bin/mysqld(sp_head::execute(THD*, bool)+0x3df) [0xfea4df] /rdsdbbin/oscar/bin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x1c3) [0xfeac43] /rdsdbbin/oscar/bin/mysqld(Trigger::execute(THD*)+0x97) [0x1189617] /rdsdbbin/oscar/bin/mysqld(Trigger_chain::execute_triggers(THD*)+0x23) [0x118ac63] /rdsdbbin/oscar/bin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x4b) [0x11841eb] /rdsdbbin/oscar/bin/mysqld(fill_record_n_invoke_before_triggers(THD*, COPY_INFO*, mem_root_deque<Item*> const&, mem_root_deque<Item*> const&, TABLE*, enum_trigger_event_type, int, bool, bool*)+0x457) [0x1003017] /rdsdbbin/oscar/bin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x4a3) [0x16ce2a3] /rdsdbbin/oscar/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x62f) [0x10de1cf] /rdsdbbin/oscar/bin/mysqld(mysql_execute_command_internal(THD*, bool)+0x1fef) [0x10805ef] /rdsdbbin/oscar/bin/mysqld(mysql_execute_command(THD*, bool)+0x18b) [0x108248b] /rdsdbbin/oscar/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x383) [0x10831c3] /rdsdbbin/oscar/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x13f3) [0x1084a53] /rdsdbbin/oscar/bin/mysqld(do_command(THD*)+0x17f) [0x1085a1f] /rdsdbbin/oscar/bin/mysqld(THD_task::process_connection()+0x183) [0x12505a3] /rdsdbbin/oscar/bin/mysqld(Thread_pool::worker_loop()+0x1cb) [0x124ee0b] /rdsdbbin/oscar/bin/mysqld(Thread_pool::worker_launch(void*)+0x23) [0x124efe3] /rdsdbbin/oscar/bin/mysqld() [0x29421bf] /lib64/libpthread.so.0(+0x72ab) [0x40000954a2ab] /lib64/libc.so.6(+0xd5e5b) [0x4000098fae5b] ``` There are more logs in the following lines that I can bring if necessary. In my 'Recent Events' from the database instance I got this: ``` October 26, 2022, 11:22 (UTC-03:00) DB instance restarted ```
0
answers
0
votes
35
views
asked a month ago

Aurora reader creation dialog doesn't offer instance type options

I'm trying to create a new aurora reader for an existing aurora cluster with an existing writer instance. When I use the Add Reader option from the console the DB instance class drop-down is empty and so I can't proceed. I tried this same thing last week (in a test run) without issue. This occurs both for a newly created cluster and long running cluster. Both clusters are 5.6.mysql_aurora.1.22.3 . Looking at the developer's console in my browser (while on the Add Reader screen)I see the following errors: Uncaught TypeError: Cannot read properties of null (reading 'DBInstanceIdentifier') at t.onCreateReadReplicaClicked (chunk884.js:1:185106) at t.handleItemClick (chunk884.js:1:160188) at HTMLElement.wrappedCallback (chunk5982.js:2:2265773) at a (chunk5982.js:2:2230014) at e.__fireEvent (chunk5982.js:2:2230474) at Object.__activateItem (chunk5982.js:2:2274620) at HTMLLIElement.m (chunk5982.js:2:2301008) and a little later rds-0.js:16386 Wed Oct 19 21:03:05 GMT-500 2022 SEVERE: Uncaught Client Exception: com.google.web.bindery.event.shared.UmbrellaException: Exception caught: Exception caught: Cannot find version 5.6.mysql_aurora.1.22.3 for aurora (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID: 7d821db1-b674-430a-a24c-bf683ff28a17; Proxy: null) at Unknown.google.web.bindery.event.shared.UmbrellaException: Exception caught: Exception caught: Cannot find version 5.6.mysql_aurora.1.22.3 for aurora(Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID) Caused by: com.google.web.bindery.event.shared.UmbrellaException: Exception caught: Cannot find version 5.6.mysql_aurora.1.22.3 for aurora (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID: 7d821db1-b674-430a-a24c-bf683ff28a17; Proxy: null) at Unknown.google.web.bindery.event.shared.UmbrellaException: Exception caught: Cannot find version 5.6.mysql_aurora.1.22.3 for aurora(Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID) Caused by: java.lang.RuntimeException: Cannot find version 5.6.mysql_aurora.1.22.3 for aurora (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID: 7d821db1-b674-430a-a24c-bf683ff28a17; Proxy: null) at Unknown.lang.RuntimeException: Cannot find version 5.6.mysql_aurora.1.22.3 for aurora(Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination; Request ID) This seems to be a new error in the behavior of the Add Reader screen. Any advice?
2
answers
0
votes
90
views
asked a month ago