- rm -rf 69926/ scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/69926 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/69926 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/69926/log.err --tmpdir=/ramdisk 2>&1 & CREATE DATABASE IF NOT EXISTS test; use test; CREATE TABLE `langlinks` ( `ll_from` int(8) unsigned NOT NULL DEFAULT '0', `ll_lang` varbinary(20) NOT NULL DEFAULT '', `ll_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`), KEY `ll_lang` (`ll_lang`,`ll_title`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Denni prehledy poctu nabidek podle licenci'; set @id:=0; insert into `langlinks` values (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) , (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) , (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) , (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)); insert into `langlinks`(`ll_from`,`ll_lang`,`ll_title`) select @id:=@id+1,RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654,RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654 from `langlinks` k1, `langlinks` k2, `langlinks` k3, `langlinks` k4,`langlinks` k5,`langlinks` k6, `langlinks` k7, `langlinks` k8, `langlinks` k9, `langlinks` k0,`langlinks` ka, `langlinks` kb, `langlinks` kc, `langlinks` kd limit 10000000; CREATE TEMPORARY TABLE IF NOT EXISTS TEMPTABLES.test LIKE langlinks; INSERT INTO TEMPTABLES.test SELECT t.ll_from, t.ll_lang, t.ll_title from langlinks t; -- [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.46: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.46 MySQL Community Server (GPL) Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'tmpdir'; +---------------+----------+ | Variable_name | Value | +---------------+----------+ | tmpdir | /ramdisk | +---------------+----------+ 1 row in set (0.00 sec) df -h /ramdisk/ Filesystem Size Used Avail Use% Mounted on tmpfs 16G 12G 4.1G 75% /ramdisk . -- mysql> CREATE DATABASE IF NOT EXISTS test; use test; CREATE TABLE `langlinks` ( `ll_from` int(8) unsigned NOT NULL DEFAULT '0', `ll_lang` varbinary(20) NOT NULL DEFAULT '', `ll_title` varbinary(255) NOT NULL DEFAULT '', UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`), KEY `ll_lang` (`ll_lang`,`ll_title`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Denni prehledy poctu nabidek podle licenci'; set @id:=0; insert into `langlinks` values (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) Query OK, 1 row affected, 1 warning (0.00 sec) mysql> use test; Database changed mysql> CREATE TABLE `langlinks` ( -> `ll_from` int(8) unsigned NOT NULL DEFAULT '0', -> `ll_lang` varbinary(20) NOT NULL DEFAULT '', -> `ll_title` varbinary(255) NOT NULL DEFAULT '', -> UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`), -> KEY `ll_lang` (`ll_lang`,`ll_title`) -> ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Denni prehledy poctu nabidek podle licenci'; Query OK, 0 rows affected (0.00 sec) mysql> mysql> set @id:=0; Query OK, 0 rows affected (0.00 sec) mysql> mysql> insert into `langlinks` values -> (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) -> , (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) -> , (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)) -> , (@id:=@id+1,(RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654),(RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654)); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> insert into `langlinks`(`ll_from`,`ll_lang`,`ll_title`) -> select @id:=@id+1,RAND() * (52.477040512464626 - 52.077090052913654) + 52.077090052913654,RAND() * (53.477040512464626 - 53.077090052913654) + 53.077090052913654 from -> `langlinks` k1, `langlinks` k2, `langlinks` k3, `langlinks` k4,`langlinks` k5,`langlinks` k6, `langlinks` k7, `langlinks` k8, `langlinks` k9, -> `langlinks` k0,`langlinks` ka, `langlinks` kb, `langlinks` kc, `langlinks` kd limit 10000000; Query OK, 10000000 rows affected (5 min 18.20 sec) Records: 10000000 Duplicates: 0 Warnings: 0 mysql> --- -- fill /ramdisk fallocate -l 2G /ramdisk/ushastry/test.img fallocate -l 2G /ramdisk/ushastry/test1.img Every 2.0s: df -h /ramdisk/ Thu Dec 5 07:57:58 2019 Filesystem Size Used Avail Use% Mounted on tmpfs 16G 16G 53M 100% /ramdisk Every 2.0s: df -h /ramdisk/ Thu Dec 5 08:05:04 2019 Filesystem Size Used Avail Use% Mounted on tmpfs 16G 16G 0 100% /ramdisk mysql> INSERT INTO TEMPTABLES.test SELECT t.ll_from, t.ll_lang, t.ll_title from langlinks t; ERROR 1146 (42S02): Table 'TEMPTABLES.test' doesn't exist mysql> CREATE TEMPORARY TABLE IF NOT EXISTS TEMPTABLES.test LIKE langlinks; Query OK, 0 rows affected (0.00 sec) mysql> mysql> INSERT INTO TEMPTABLES.test SELECT t.ll_from, t.ll_lang, t.ll_title from langlinks t; ^CCtrl-C -- sending "KILL QUERY 4" to server ... Ctrl-C -- query aborted. ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> mysql> \q Bye [1]+ Segmentation fault (core dumped) bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/69926 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/69926/log.err --tmpdir=/ramdisk 2>&1 --- extract from error log 2019-12-05 07:49:17 25979 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5b51990f-172b-11ea-bf45-0010e05f3e06. 2019-12-05 07:49:17 25979 [Note] RSA private key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.6.46/69926//private_key.pem. Some authentication plugins will not work. 2019-12-05 07:49:17 25979 [Note] RSA public key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.6.46/69926//public_key.pem. Some authentication plugins will not work. 2019-12-05 07:49:17 25979 [Note] Server hostname (bind-address): '*'; port: 3333 2019-12-05 07:49:17 25979 [Note] IPv6 is available. 2019-12-05 07:49:17 25979 [Note] - '::' resolves to '::'; 2019-12-05 07:49:17 25979 [Note] Server socket created on IP: '::'. 2019-12-05 07:49:17 25979 [Note] Event Scheduler: Loaded 0 events 2019-12-05 07:49:17 25979 [Note] bin/mysqld: ready for connections. Version: '5.6.46' socket: '/tmp/mysql_ushastry.sock' port: 3333 MySQL Community Server (GPL) 2019-12-05 07:59:30 25979 [Warning] Disk is full writing '/ramdisk/#sql657b_1_0.MYI' (Errcode: 28 - No space left on device). Waiting for someone to free space... 2019-12-05 07:59:30 25979 [Warning] Retry in 60 secs. Message reprinted in 600 secs 2019-12-05 08:00:30 25979 [ERROR] bin/mysqld: Incorrect key file for table '/ramdisk/#sql657b_1_0.MYI'; try to repair it 2019-12-05 08:00:30 25979 [ERROR] Got an error from unknown thread, /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/mi_write.c:230 2019-12-05 08:02:10 25979 [ERROR] bin/mysqld: Incorrect key file for table '/ramdisk/#sql657b_4_0.MYI'; try to repair it 2019-12-05 08:02:10 25979 [ERROR] Got an error from unknown thread, /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/mi_write.c:230 2019-12-05 08:02:10 25979 [Warning] Disk is full writing '/ramdisk/#sql657b_4_0.MYI' (Errcode: 28 - No space left on device). Waiting for someone to free space... 2019-12-05 08:02:10 25979 [Warning] Retry in 60 secs. Message reprinted in 600 secs 07:03:10 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=2 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68109 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x331d990 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 = 7f187619be98 thread_stack 0x40000 bin/mysqld(my_print_stacktrace+0x35)[0x9256c5] bin/mysqld(handle_fatal_signal+0x494)[0x6b06d4] /lib64/libpthread.so.0(+0xf130)[0x7f18a1774130] bin/mysqld[0x917bae] bin/mysqld(flush_key_blocks+0xca)[0x9187aa] bin/mysqld(flush_blocks+0x25)[0xb22e35] bin/mysqld(mi_repair_by_sort+0x1ea)[0xb2bb8a] bin/mysqld(_ZN9ha_myisam6repairEP3THDR17st_mi_check_paramb+0x8d4)[0xb20154] bin/mysqld(_ZN9ha_myisam14enable_indexesEj+0x147)[0xb20317] bin/mysqld(_ZN9ha_myisam15end_bulk_insertEv+0x61)[0xb1d571] bin/mysqld(_ZN13select_insert16abort_result_setEv+0xf9)[0x710049] bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0xda)[0x74f8da] bin/mysqld(_Z21mysql_execute_commandP3THD+0x4b7b)[0x73077b] bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x370)[0x730cd0] bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x10fe)[0x731ece] bin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6fdf3f] bin/mysqld(handle_one_connection+0x47)[0x6fe067] bin/mysqld(pfs_spawn_thread+0x12d)[0x95ef3d] /lib64/libpthread.so.0(+0x7df5)[0x7f18a176cdf5] /lib64/libc.so.6(clone+0x6d)[0x7f18a022c60d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f18440049b0): INSERT INTO TEMPTABLES.test SELECT t.ll_from, t.ll_lang, t.ll_title from langlinks t Connection ID (thread ID): 4 Status: KILL_QUERY 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. Writing a core file - backtrace (gdb) bt #0 0x00007f18a1771771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000006b062c in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/signal_handler.cc:237 #2 #3 0x0000000000917bae in unlink_block (block=0x7f18855ae030, keycache=0x2d42260) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/mysys/mf_keycache.c:1254 #4 reg_requests (count=1, block=0x7f18855ae030, keycache=0x2d42260) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/mysys/mf_keycache.c:1304 #5 flush_key_blocks_int (keycache=, file=, type=FLUSH_RELEASE) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/mysys/mf_keycache.c:3933 #6 0x00000000009187aa in flush_key_blocks (keycache=0x2d42260, file=46, type=FLUSH_RELEASE) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/mysys/mf_keycache.c:4063 #7 0x0000000000b22e35 in flush_blocks (param=0x7f1876191ca0, key_cache=0x2d42260, file=) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/mi_check.c:1934 #8 0x0000000000b2bb8a in mi_repair_by_sort (param=0x7f1876191ca0, info=0x7f184400c1a0, name=0x7f18761919c0 "/ramdisk/#sql657b_4_0", rep_quick=32768, no_copy_stat=1 '\001') at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/mi_check.c:2559 #9 0x0000000000b20154 in ha_myisam::repair (this=0x7f184400ad60, thd=0x331d990, param=..., do_optimize=) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/ha_myisam.cc:1116 #10 0x0000000000b20317 in ha_myisam::enable_indexes (this=0x7f184400ad60, mode=) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/ha_myisam.cc:1431 #11 0x0000000000b1d571 in ha_myisam::end_bulk_insert (this=0x7f184400ad60) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/myisam/ha_myisam.cc:1565 #12 0x0000000000710049 in select_insert::abort_result_set (this=0x7f18440059c8) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_insert.cc:3907 #13 0x000000000074f8da in handle_select (thd=0x331d990, result=0x7f18440059c8, setup_tables_done_option=1073741824) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_select.cc:123 #14 0x000000000073077b in mysql_execute_command (thd=0x331d990) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_parse.cc:3607 #15 0x0000000000730cd0 in mysql_parse (thd=0x331d990, rawbuf=, length=, parser_state=) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_parse.cc:6435 #16 0x0000000000731ece in dispatch_command (command=COM_QUERY, thd=0x331d990, packet=0x33216f1 "INSERT INTO TEMPTABLES.test SELECT t.ll_from, t.ll_lang, t.ll_title from langlinks t", packet_length=85) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_parse.cc:1406 #17 0x00000000006fdf3f in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_connect.cc:989 #18 0x00000000006fe067 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/sql/sql_connect.cc:906 #19 0x000000000095ef3d in pfs_spawn_thread (arg=0x328e100) at /export/home/pb2/build/sb_0-36131551-1569572120.35/mysql-5.6.46/storage/perfschema/pfs.cc:1868 #20 0x00007f18a176cdf5 in start_thread () from /lib64/libpthread.so.0 #21 0x00007f18a022c60d in clone () from /lib64/libc.so.6 (gdb)