MySQL Forums
Forum List  »  InnoDB

Assertion failure
Posted by: ludovic lugo
Date: December 20, 2021 04:40AM

Hi
I have all my servers with latest version of mysql 8.0.27 and cpanel, sometimes when i try to import a sql file from another server sometimes it crashes mysql when creating the indexes and adding keys, the error log sais:

2021-12-20T09:57:09.649680Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: ddl0builder.cc:1495:n >= IO_BLOCK_SIZE thread 140505506866944

In older versions this was a bug and as i understand it should be fixed in mysql 8.

my.cnf file is:

[mysqld]
performance-schema=0
key_buffer_size = 384M
connect_timeout=30
table_open_cache=1024
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 100
max_connections=1000
max_user_connections=500
max_allowed_packet = 1G
open_files_limit=100000
default-storage-engine=InnoDB
innodb_file_per_table=1
wait_timeout = 60
interactive_timeout=60
lock_wait_timeout = 60
innodb_buffer_pool_size = 64G
innodb_buffer_pool_instances = 65
join_buffer_size=8M
sql_mode="NO_ENGINE_SUBSTITUTION"
default-authentication-plugin=mysql_native_password
collation-server = utf8_unicode_ci
character-set-server = utf8
disable-log-bin=1
innodb_log_file_size = 8G
[mysqldump]
quick
max_allowed_packet = 1G

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 350M
read_buffer = 4M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Options: ReplyQuote


Subject
Views
Written By
Posted
Assertion failure
2704
December 20, 2021 04:40AM
839
December 20, 2021 11:12AM
759
December 21, 2021 01:20AM
685
December 21, 2021 02:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.