I've exported a sql dump file with phpMyadmin and I've been trying to import the file using Tableplus into Mysql server hosted on an Amazon ec2. Right before the import completes, Lost connection to Mysql server during query appears. I've tried setting max_allowed_packet to 500M which is around the size of sql file I'm importing. I've tried setting 80% of innodb_buffer_allow_size. I've tried reinstalling Mysql server. While importing the file with CLI, ERROR 2013 (HY000) at line X. When I check the line in VS code, it shows the ALTER TABLE command. And this is the error code from the mysql error log.
2022-01-31T15:33:57.007620Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: ddl0builder.cc:1495:n >= IO_BLOCK_SIZE thread 140466142037760
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
15:33:57 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x0
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 = 0 thread_stack 0x100000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x5618dce43011]
/usr/sbin/mysqld(handle_fatal_signal+0x31b) [0x5618dbce6b7b]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7fc11cc3a3c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7fc11c29718b]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7fc11c276859]
/usr/sbin/mysqld(+0xeb0606) [0x5618dba1c606]
/usr/sbin/mysqld(+0x27e0e48) [0x5618dd34ce48]
/usr/sbin/mysqld(ddl::Key_sort_buffer::serialize(std::pair<unsigned char*, unsigned long>, std::function<dberr_t (std::pair<unsigned char*, unsigned long>, unsigned long&)>&&)+0x2ae) [0x5618dd34832e]
/usr/sbin/mysqld(ddl::Builder::bulk_add_row(ddl::Cursor&, ddl::Row&, unsigned long, std::function<dberr_t ()>&&)+0x225) [0x5618dd351af5]
/usr/sbin/mysqld(ddl::Builder::add_row(ddl::Cursor&, ddl::Row&, unsigned long, std::function<dberr_t ()>&&)+0xb5) [0x5618dd351f45]
/usr/sbin/mysqld(+0x272a29c) [0x5618dd29629c]
/usr/sbin/mysqld(Parallel_reader::Ctx::traverse_recs(PCursor*, mtr_t*)+0x493) [0x5618dd088193]
/usr/sbin/mysqld(Parallel_reader::Ctx::traverse()+0x1ba) [0x5618dd08b19a]
/usr/sbin/mysqld(Parallel_reader::worker(Parallel_reader::Thread_ctx*)+0x2b8) [0x5618dd08f398]
/usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (Parallel_reader::*)(Parallel_reader::Thread_ctx*), Parallel_reader*, Parallel_reader::Thread_ctx*> > >::_M_run()+0xd6) [0x5618dd085ca6]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xd6de4) [0x7fc11c683de4]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7fc11cc2e609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7fc11c373293]
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.
