docker安裝的mysql，mysql版本為8.0.22
錯誤日志如下：
06:21:11.416705Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2021-01-15T06:21:11.423080Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2021-01-15T06:21:11.490852Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-01-15T06:21:11.491004Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-01-15T06:21:11.493318Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2021-01-15T06:21:11.506309Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.22' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - 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 caused by malfunctioning hardware.
Thread pointer: 0x7f585c000b20
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 = 7f59242bfda0 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x5616ac3f4cde]
/usr/sbin/mysqld(handle_fatal_signal+0x31b) [0x5616ab7dd12b]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730) [0x7f593bbe7730]
/usr/sbin/mysqld(Item_splocal::this_item() const+0x14) [0x5616ab27c7a4]
/usr/sbin/mysqld(Item_sp_variable::val_str(String*)+0x20) [0x5616ab27eab0]
/usr/sbin/mysqld(Item_func_concat::val_str(String*)+0xc4) [0x5616ab3f68c4]
/usr/sbin/mysqld(Item::save_in_field_inner(Field*, bool)+0x7a) [0x5616ab28212a]
/usr/sbin/mysqld(Item::save_in_field(Field*, bool)+0x44) [0x5616ab29bfb4]
/usr/sbin/mysqld(sp_eval_expr(THD*, Field*, Item**)+0xa2) [0x5616ab54bda2]
/usr/sbin/mysqld(sp_instr_set::exec_core(THD*, unsigned int*)+0x40) [0x5616ab562820]
/usr/sbin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x613) [0x5616ab563dd3]
/usr/sbin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x92) [0x5616ab5647d2]
/usr/sbin/mysqld(sp_head::execute(THD*, bool)+0x597) [0x5616ab5595b7]
/usr/sbin/mysqld(sp_head::execute_trigger(THD*, MYSQL_LEX_CSTRING const&, MYSQL_LEX_CSTRING const&, GRANT_INFO*)+0x27a) [0x5616ab559e8a]
/usr/sbin/mysqld(Trigger::execute(THD*)+0xd3) [0x5616ab7a0553]
/usr/sbin/mysqld(Trigger_chain::execute_triggers(THD*)+0x18) [0x5616ab7a1938]
/usr/sbin/mysqld(Table_trigger_dispatcher::process_triggers(THD*, enum_trigger_event_type, enum_trigger_action_time_type, bool)+0x46) [0x5616ab79b676]
/usr/sbin/mysqld(write_record(THD*, TABLE*, COPY_INFO*, COPY_INFO*)+0x65c) [0x5616ab63707c]
/usr/sbin/mysqld(Sql_cmd_insert_values::execute_inner(THD*)+0x7b9) [0x5616ab638099]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x6b8) [0x5616ab6e1a48]
/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0xaa8) [0x5616ab67a088]
/usr/sbin/mysqld(mysql_parse(THD*, Parser_state*)+0x3f8) [0x5616ab67e728]
/usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x167b) [0x5616ab6802eb]
/usr/sbin/mysqld(do_command(THD*)+0x174) [0x5616ab681874]
/usr/sbin/mysqld(+0x240a218) [0x5616ab7c6218]
/usr/sbin/mysqld(+0x35677d4) [0x5616ac9237d4]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3) [0x7f593bbdcfa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7f593b3864cf]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f585c005c58): insert INTO amb_pos (time,amb_id,amb_task_id,center_id,event_name,latitude,longitude,rotation,speed,status) VALUES('1610691723818','d154103f-a4e4-46d9-ba00-2f828c2b2100',' ','c7925990-6fa8-4bdb-8b7a-0ea4f2f16c5a',' ','36.34541151258681','102.8539599609375','174.77','0.0','7')
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 8.0.22-1debian10 started.
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 8.0.22-1debian10 started.
2021-01-15T06:22:15.816501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 1
2021-01-15T06:22:15.822012Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-01-15T06:22:16.616039Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-01-15T06:22:16.691862Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-01-15T06:22:16.704055Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2021-01-15T06:22:16.710389Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2021-01-15T06:22:16.778538Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-01-15T06:22:16.778670Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-01-15T06:22:16.780946Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2021-01-15T06:22:16.792418Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.22' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
mbind: Operation not permitted
mbind: Operation not permitted
這張表的資料大概在30萬左右，創建了一個觸發器。
觸發器如下：
CREATE DEFINER=`root`@`%` TRIGGER `SYN_AMB_POS_I` AFTER INSERT ON `amb_pos` FOR EACH ROW begin
declare amb_id,amb_task_id,center_id,event_name,latitude,longitude,rotation,speed,status,time text default "null";
declare syn_source_data text default "{";
declare id text default "null";
set amb_id=cast(if(new.`amb_id` is null ,'null',concat('"',replace(replace(new.`amb_id`,'\\','\\\\'),'"','\\"'),'"')) as char);
set amb_task_id=cast(if(new.`amb_task_id` is null ,'null',concat('"',replace(replace(new.`amb_task_id`,'\\','\\\\'),'"','\\"'),'"')) as char);
set center_id=cast(if(new.`center_id` is null ,'null',concat('"',replace(replace(new.`center_id`,'\\','\\\\'),'"','\\"'),'"')) as char);
set event_name=cast(if(new.`event_name` is null ,'null',concat('"',replace(replace(new.`event_name`,'\\','\\\\'),'"','\\"'),'"')) as char);
set latitude=cast(if(new.`latitude` is null ,'null',concat('"',replace(replace(new.`latitude`,'\\','\\\\'),'"','\\"'),'"')) as char);
set longitude=cast(if(new.`longitude` is null ,'null',concat('"',replace(replace(new.`longitude`,'\\','\\\\'),'"','\\"'),'"')) as char);
set rotation=cast(if(new.`rotation` is null ,'null',concat('"',replace(replace(new.`rotation`,'\\','\\\\'),'"','\\"'),'"')) as char);
set speed=cast(if(new.`speed` is null ,'null',concat('"',replace(replace(new.`speed`,'\\','\\\\'),'"','\\"'),'"')) as char);
set status=cast(if(new.`status` is null ,'null',concat('"',replace(replace(new.`status`,'\\','\\\\'),'"','\\"'),'"')) as char);
set time=if(new.`time` is null,'null',concat('"',cast(new.`time` as char),'"'));
set id=concat(amb_id,',',time);
set id=replace(id,'"','');
set syn_source_data=https://bbs.csdn.net/topics/concat('{','"amb_id":',amb_id,',','"amb_task_id":',amb_task_id,',','"center_id":',center_id,',','"event_name":',event_name,',','"latitude":',latitude,',','"longitude":',longitude,',','"rotation":',rotation,',','"speed":',speed,',','"status":',status,',','"time":',time,',','"id":"',id,'"','}');
if 1=1 and @sync_triggers_disabled is null then
insert into syn_record_all_copy1 (syn_table_name, syn_source_data,syn_type,syn_change_json,source_id,syn_time)
values(
'ym_amb_pos'
,syn_source_data
,1
,null,id
,CURRENT_TIMESTAMP(3)
);
end if;
end
這到底是怎么回事啊，資料庫一直在重啟。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/251124.html
標籤：MySQL
上一篇：MySQL 并發update多個列會有部分列更新失敗？
下一篇：求助sql陳述句撰寫思路