SQLinfo.ru - Все о MySQL

Форум пользователей MySQL

Задавайте вопросы, мы ответим

Вы не зашли.

#1 29.07.2018 22:35:56

nesles
Участник
Зарегистрирован: 29.07.2018
Сообщений: 2

Mysql 8 Иногда падает

Периодичность не могу определить.
Обнаружил в логе ошибок:
(my.ini ниже)


Thread pointer: 0xcfbb4e28a0
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...
7ff6c905a6d2    mysqld.exe!?my_errno@@YAHXZ()
7ffa2835da08    ucrtbase.DLL!raise()
7ffa2835e9d1    ucrtbase.DLL!abort()
7ff6c92a6a67    mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@QEAA@XZ()
7ff6c934ee08    mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@QEAA@XZ()
7ff6c91982ab    mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@QEAA@XZ()
7ff6c831fa64    mysqld.exe!?ha_index_next_same@handler@@QEAAHPEAEPEBEI@Z()
7ff6c867baf8    mysqld.exe!?join_read_last_key@@YAHPEAVQEP_TAB@@@Z()
7ff6c867f750    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6c867a08d    mysqld.exe!?erase@?$_Hash@V?$_Uset_traits@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@V?$_Uhash_compare@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@U?$hash@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@2@U?$equal_to@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@2@@2@V?$Memroot_allocator@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@@$0A@@std@@@std@@QEAA?AV?$_List_const_iterator@V?$_List_val@U?$_List_simple_types@V?$basic_string@DU?
7ff6c867f7ed    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6c867a08d    mysqld.exe!?erase@?$_Hash@V?$_Uset_traits@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@V?$_Uhash_compare@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@U?$hash@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@2@U?$equal_to@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@2@@2@V?$Memroot_allocator@V?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@@$0A@@std@@@std@@QEAA?AV?$_List_const_iterator@V?$_List_val@U?$_List_simple_types@V?$basic_string@DU?
7ff6c867f7ed    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6c8678499    mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@@_N@Z()
7ff6c867a7d7    mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff6c8589256    mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
7ff6c84ac252    mysqld.exe!?execute_show@@YA_NPEAVTHD@@PEAUTABLE_LIST@@@Z()
7ff6c84ae537    mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff6c84b12d6    mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff6c84aad98    mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff6c84abcc5    mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff6c833d068    mysqld.exe!?pop_front@?$list@PEAVChannel_info@@V?$allocator@PEAVChannel_info@@@std@@@std@@QEAAXXZ()
7ff6c943e347    mysqld.exe!??1?$lock_guard@Vmutex@std@@@std@@QEAA@XZ()
7ff6c905a66c    mysqld.exe!?my_thread_join@@YAHPEAUmy_thread_handle@@PEAPEAX@Z()
7ffa2836173d    ucrtbase.DLL!_crt_atexit()
7ffa49d613d2    KERNEL32.DLL!BaseThreadInitThunk()
7ffa4ab154e4    ntdll.dll!RtlUserThreadStart()


=========================MY.INI================

[client]
port=7750
[mysql]
no-beep
[mysqld]
port=7750
datadir = "D:/Mysql/Data"
default_authentication_plugin=mysql_native_password
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
log-output=FILE
general-log=0
general_log_file="10_20_11_5.log"
slow-query-log=1
slow_query_log_file="D:/Mysql/10_20_11_5-slow.log"
long_query_time = 15

log-error = "D:/MYSQL/ErrorLog.log"
server-id=1
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
max_connections=1500
table_open_cache=2000
tmp_table_size=16M
thread_cache_size=10
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=8M
key_buffer_size=8M
read_buffer_size=0
read_rnd_buffer_size=0
innodb_log_buffer_size=2M
innodb_buffer_pool_size=48G
innodb_log_file_size=512M
innodb_thread_concurrency=17
innodb_autoextend_increment=64
threads read and write to cached pages.
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0

back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=16M

max_connect_errors=100
open_files_limit=4161
sort_buffer_size = 1M

table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000




innodb_write_io_threads = 8

innodb_flush_neighbors = 2
character-set-server = utf8mb4

innodb_online_alter_log_max_size = 32G

innodb_page_cleaners = 8

innodb_read_io_threads = 8


disconnect_on_expired_password = off

log-bin-trust-function-creators


console

Отредактированно nesles (30.07.2018 10:51:54)

Неактивен

 

#2 30.07.2018 09:27:08

rgbeast
Администратор
MySQL Authorized Developer and DBA
Откуда: Москва
Зарегистрирован: 21.01.2007
Сообщений: 3823

Re: Mysql 8 Иногда падает

Это похоже на багу. Разместите на bugs.mysql.com

Неактивен

 

Board footer

Работает на PunBB
© Copyright 2002–2008 Rickard Andersson