Dump file has been kept on hod03

 ls -l /usr/local/support/bugs/community/88863/
total 7816
-rw-r--r--+ 1 umshastr common 7950848 Dec 12 07:20 mysql-bug-data-88863.tar


 -- 5.6.38  - affected
 
rm -rf 88863
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/88863
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/88863 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3307 --log-error=$PWD/88863/log.err 2>&1 &


[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.38: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test < /tmp/test_table_init.dump
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.38:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.38: bunzip2 < /tmp/load_data_1_mln.sql.bz2 | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test

^^ Without waiting it to complete, initiated in another terminal

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.38: while : ; do echo 'select count(*) from test_table WHERE recno < 1000000000;' |bin/mysql -uroot -S /tmp/mysql_ushastry.sock test ; sleep 5 ; done
count(*)
180901
count(*)
219242
count(*)
1
count(*)
295541
count(*)
1
count(*)
1
count(*)
408212
count(*)
1
count(*)
484509
count(*)
523084
count(*)
1
count(*)
598357
count(*)
637105
count(*)
1
count(*)
1
count(*)
750113
count(*)
1
count(*)
826733
count(*)
864986
count(*)
1
count(*)
940912
count(*)
1
count(*)
1
count(*)
1000000
count(*)
1000000
count(*)
1000000

 -- 5.7.20 - affected
 
rm -rf 88863
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/88863 
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/88863 --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=$PWD/88863/log.err 2>&1 &

-- Session 1

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test < /tmp/test_table_init.dump
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bunzip2 < /tmp/load_data_1_mln.sql.bz2 | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test

^^ Without waiting it to complete, initiated in another terminal

-- Session 2

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: while : ; do echo 'select count(*) from test_table WHERE recno < 1000000000;' |bin/mysql -uroot -S /tmp/mysql_ushastry.sock test ; sleep 5 ; done
count(*)
15304
count(*)
48957
count(*)
82863
count(*)
116661
count(*)
151234
count(*)
185627
count(*)
219579
count(*)
253803
count(*)
288273
count(*)
322097
count(*)
356286
count(*)
390763
count(*)
425141
count(*)
460283
count(*)
494917
count(*)
530439
count(*)
566068
count(*)
1
count(*)
1
count(*)
668794
count(*)
1
count(*)
1
count(*)
1
count(*)
805148
count(*)
840937
count(*)
1
count(*)
910017
count(*)
1
count(*)
1
count(*)
1
count(*)
1
count(*)
1
count(*)
1
count(*)
1000000
count(*)
1000000
count(*)
1
count(*)
1000000
count(*)
1000000
count(*)
1000000
count(*)
1
count(*)
1
^C

-- 5.5.59 -- not affected



[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.59-linux-glibc2.12-x86_64: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test < /tmp/test_table_init.dump
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.59-linux-glibc2.12-x86_64: bunzip2 < /tmp/load_data_1_mln.sql.bz2 | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test




[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.59-linux-glibc2.12-x86_64: while : ; do echo 'select count(*) from test_table WHERE recno < 1000000000;' |bin/mysql -uroot -S /tmp/mysql_ushastry.sock test ; sleep 5 ; done
count(*)
44837
count(*)
82752
count(*)
120653
count(*)
158767
count(*)
197089
count(*)
235049
count(*)
274009
count(*)
312432
count(*)
351490
count(*)
390574
count(*)
429228
count(*)
467386
count(*)
506484
count(*)
546138
count(*)
585178
count(*)
624677
count(*)
663900
count(*)
703008
count(*)
742181
count(*)
782568
count(*)
822637
count(*)
862189
count(*)
902198
count(*)
942423
count(*)
983404
count(*)
1000000
count(*)
1000000
count(*)
1000000
count(*)
1000000
count(*)
1000000
count(*)
1000000
count(*)
1000000


-- 5.6.39  - affected

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.39: cat docs/INFO_SRC
commit: a91263a00f8d59c8b5b4775b3b035f03c76f7c34
date: 2017-12-06 13:19:57 +0530
build-date: 2017-12-09 08:33:45 +0100
short: a91263a
branch: mysql-5.6.39-release

MySQL source 5.6.39

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.39: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test < /tmp/test_table_init.dump
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.39: bunzip2 < /tmp/load_data_1_mln.sql.bz2 | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test


[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.39: while : ; do echo 'select count(*) from test_table WHERE recno < 1000000000;' |bin/mysql -uroot -S /tmp/mysql_ushastry.sock test ; sleep 5 ; done
count(*)
26281
count(*)
66056
count(*)
1
count(*)
145168
count(*)
184982
count(*)
1
count(*)
264161
count(*)
1
count(*)
344103
count(*)
1
count(*)
1
count(*)
463317
count(*)
503930
count(*)
1
count(*)
583307