Home > database >  Mysql innocent collapse
Mysql innocent collapse

Time:01-23

Docker mysql installation, mysql version for 8.0.22

The error log is as follows:
 
06:21:11. 416705 z 0 [System] [MY - 010229] [Server] Starting XA crash recovery...
T06:2021-01-15 and. 423080 z 0 [System] [MY - 010232] (Server) XA crash recovery finished.
T06:2021-01-15 and. 490852 z 0 [Warning] [MY - 010068] [Server] CA certificate CA. The pem is self signed.
T06:2021-01-15 and. 491004 z 0 [System] [MY - 013602]/Server Channel mysql_main configured to support TLS. Encrypted connections are now supported for this Channel.
T06:2021-01-15 and. 493318 z 0 [Warning] [MY - 011810] (Server) Insecure configuration for - pid - file: the Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a company directory.
The T06:2021-01-15 and. 506309 z 0 [System] [MY - 010931]/Server/usr/sbin/mysqld: ready for connections. Version: '8.0.22 sockets:'/var/run/mysqld/mysqld. The sock 'port: 3306 MySQL Community Server - the GPL.
Mbind: Operation not permitted
Mbind: Operation not permitted
06:22:14 UTC - mysqld got signal 11;
Most likely, you have hit a bug, but this error can also be under caused by malfunctioning hardware.
Thread pointer: 0 x7f585c000b20
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=7 f59242bfda0 thread_stack 0 x46000
The/usr/sbin/mysqld (my_print_stacktrace (unsigned char const *, unsigned long) + 0 x2e) x5616ac3f4cde [0]
The/usr/sbin/mysqld (handle_fatal_signal + 0 x31b) x5616ab7dd12b [0]
/lib/x86_64 - - the gnu/Linux libpthreads. So. 0 (+ 0 x12730 x7f593bbe7730 [0])
The/usr/sbin/mysqld (Item_splocal: : this_item () const + 0 x14) x5616ab27c7a4 [0]
The/usr/sbin/mysqld (Item_sp_variable: : val_str (String *) + 0 x20) x5616ab27eab0 [0]
The/usr/sbin/mysqld (Item_func_concat: : val_str (String *) + 0 xc4) x5616ab3f68c4 [0]
The/usr/sbin/mysqld (Item: : save_in_field_inner (Field *, bool) + 0 x7a) x5616ab28212a [0]
The/usr/sbin/mysqld (Item: : save_in_field (Field *, bool) + 0 x44) x5616ab29bfb4 [0]
/usr/sbin/mysqld (sp_eval_expr (THD *, Field *, * *) Item + 0 xa2) x5616ab54bda2 [0]
The/usr/sbin/mysqld (sp_instr_set: : exec_core (THD *, unsigned int *) + 0 x40) x5616ab562820 [0]
The/usr/sbin/mysqld (sp_lex_instr: : reset_lex_and_exec_core (THD *, unsigned int *, bool) + 0 x613) x5616ab563dd3 [0]
The/usr/sbin/mysqld (sp_lex_instr: : validate_lex_and_execute_core (THD *, unsigned int *, bool) + 0 x92) x5616ab5647d2 [0]
/usr/sbin/mysqld (sp_head: : execute (THD *, bool) + 0 x597) x5616ab5595b7 [0]
The/usr/sbin/mysqld (sp_head: : execute_trigger (THD *, MYSQL_LEX_CSTRING const& , MYSQL_LEX_CSTRING const& [0, + 0 x27a GRANT_INFO *)) x5616ab559e8a]
The/usr/sbin/mysqld (Trigger: : execute (THD *) + 0 xd3) x5616ab7a0553 [0]
The/usr/sbin/mysqld (Trigger_chain: : execute_triggers (THD *) + 0 x18) x5616ab7a1938 [0]
The/usr/sbin/mysqld (Table_trigger_dispatcher: : process_triggers (THD *, enum_trigger_event_type enum_trigger_action_time_type, bool) + 0 x46) x5616ab79b676 [0]
The/usr/sbin/mysqld (write_record (THD *, TABLE *, COPY_INFO *, COPY_INFO *) + 0 x65c) x5616ab63707c [0]
The/usr/sbin/mysqld (Sql_cmd_insert_values: : execute_inner (THD *) + 0 x7b9) x5616ab638099 [0]
The/usr/sbin/mysqld (Sql_cmd_dml: : execute (THD *) + 0 x6b8) x5616ab6e1a48 [0]
The/usr/sbin/mysqld (mysql_execute_command (THD *, bool) + 0 xaa8) x5616ab67a088 [0]
The/usr/sbin/mysqld (mysql_parse (Parser_state THD *, *) + 0 x3f8) x5616ab67e728 [0]
The/usr/sbin/mysqld (dispatch_command (THD *, COM_DATA const *, enum_server_command) + 0 x167b) x5616ab6802eb [0]
The/usr/sbin/mysqld (do_command (THD *) + 0 x174) x5616ab681874 [0]
The/usr/sbin/mysqld (+ 0 x240a218) x5616ab7c6218 [0]
The/usr/sbin/mysqld (+ 0 x35677d4) x5616ac9237d4 [0]
/lib/x86_64 - - the gnu/Linux libpthreads. So. 0 (+ 0 x7fa3 x7f593bbdcfa3 [0])
/lib/x86_64 - - the gnu/Linux libc. So. 6 + 0 x3f (clone) x7f593b3864cf [0]

Trying to get some variables.
Some Pointers may be invalid and cause the dump to abort.
F585c005c58 Query (7) : insert INTO amb_pos (time, amb_id amb_task_id, center_id, event_name, latitude and longitude, rotation, speed, status) VALUES (' 1610691723818 ', 'd154103f - a4e4 f828c2b2100-46 d9 - ba00-2', ' 'and' c7925990 fa8 4-6 BDB - 8 b7a ea4f2f16c5a 0 ', ', '36.34541151258681', 102.8539599609375 ' ', '174.77', 0.0 ' ', '7')
The Connection ID (thread ID) : 75
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Information that should help you find out what is causing the crash.
2021-01-15 06:22:15 + 00:00 [Note] [Entrypoint] : Entrypoint script for MySQL Server debian10 8.0.22-1 started.
The 2021-01-15 06:22:15 + 00:00 [Note] [Entrypoint] : Switching to dedicated user 'mysql'
2021-01-15 06:22:15 + 00:00 [Note] [Entrypoint] : Entrypoint script for MySQL Server debian10 8.0.22-1 started.
The 2021-01-15 T06: persons. 816501 z 0 [System] [MY - 010116]/Server/usr/sbin/mysqld (mysqld 8.0.22) starting as process 1
The T06:2021-01-15 persons. The 822012 z 1 [System] [MY - 013576] [InnoDB] InnoDB initialization has started.
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related