- Env cat /etc/*release Oracle Linux Server release 7.1 NAME="Oracle Linux Server" VERSION="7.1" ID="ol" VERSION_ID="7.1" PRETTY_NAME="Oracle Linux Server 7.1" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:1" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.1 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.1 Red Hat Enterprise Linux Server release 7.1 (Maipo) Oracle Linux Server release 7.1 - 5.7.26 debug build cat docs/INFO_SRC commit: 219340a29ccb6522a108e6bf143be9c7e18164ed date: 2019-04-13 15:27:18 +0200 build-date: 2019-04-13 15:32:29 +0200 short: 219340a branch: mysql-5.7.26-release MySQL source 5.7.26 - Terminal 1 - Start up rm -rf 95573 bin/mysqld-debug --initialize-insecure --basedir=$PWD --datadir=$PWD/95573 --log-error-verbosity=3 bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/95573 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/95573/log.err --log-error-verbosity=3 --server-id=100 --log-bin=binlog 2>&1 & [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.26: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.26-debug-log MySQL Community Server - Debug (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> create database test; Query OK, 1 row affected (0.01 sec) . - Terminal 3 - prepare [umshastr@hod03]/export/umesh/utils/2019/sysbench: bin/sysbench share/sysbench/oltp_insert.lua --threads=100 --tables=10 --table_size=1000 --db-driver=mysql --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql_ushastry.sock prepare sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Initializing worker threads... Creating table 'sbtest6'... Creating table 'sbtest2'... Creating table 'sbtest1'... Creating table 'sbtest8'... Creating table 'sbtest3'... Creating table 'sbtest10'... Creating table 'sbtest5'... Creating table 'sbtest4'... Creating table 'sbtest9'... Creating table 'sbtest7'... Inserting 1000 records into 'sbtest6' Inserting 1000 records into 'sbtest5' Inserting 1000 records into 'sbtest3' Inserting 1000 records into 'sbtest10' Inserting 1000 records into 'sbtest1' Inserting 1000 records into 'sbtest9' Inserting 1000 records into 'sbtest2' Inserting 1000 records into 'sbtest8' Inserting 1000 records into 'sbtest4' Inserting 1000 records into 'sbtest7' Creating a secondary index on 'sbtest6'... Creating a secondary index on 'sbtest5'... Creating a secondary index on 'sbtest3'... Creating a secondary index on 'sbtest4'... Creating a secondary index on 'sbtest2'... Creating a secondary index on 'sbtest10'... Creating a secondary index on 'sbtest7'... Creating a secondary index on 'sbtest1'... Creating a secondary index on 'sbtest9'... Creating a secondary index on 'sbtest8'... - - Terminal 2 - cat 95573.sh #!/bin/bash echo "Create a database test1_innodb, add data and then drop it" ( for ((i=1; i<=500; i++)); do # Check if database is up otherwise exit the loop /export/umesh/server/binaries/GABuilds/mysql-5.7.26/bin/mysqladmin ping --user=root --socket=/tmp/mysql_ushastry.sock 2>/dev/null 1>&2 if [ "$?" -ne 0 ]; then break fi /export/umesh/server/binaries/GABuilds/mysql-5.7.26/bin/mysql -uroot -S/tmp/mysql_ushastry.sock -e "CREATE DATABASE IF NOT EXISTS test1_innodb;" >/dev/null 2>&1 /export/umesh/utils/2019/sysbench/bin/sysbench /export/umesh/utils/2019/sysbench/share/sysbench/oltp_insert.lua --tables=10 --table-size=10000 --mysql-db=test1_innodb --mysql-user=root --threads=50 --db-driver=mysql --mysql-socket=/tmp/mysql_ushastry.sock prepare /export/umesh/server/binaries/GABuilds/mysql-5.7.26/bin/mysql -uroot -S/tmp/mysql_ushastry.sock -e "ALTER TABLE test1_innodb.sbtest1 ADD COLUMN b JSON AS('{"k1": "value", "k2": [10, 20]}');" >/dev/null 2>&1 /export/umesh/server/binaries/GABuilds/mysql-5.7.26/bin/mysql -uroot -S/tmp/mysql_ushastry.sock -e "ALTER TABLE test1_innodb.sbtest1 DROP COLUMN b;" >/dev/null 2>&1 /export/umesh/server/binaries/GABuilds/mysql-5.7.26/bin/mysql -uroot -S/tmp/mysql_ushastry.sock -e "DROP DATABASE test1_innodb;" >/dev/null 2>&1 done ) & - bash -x 95573.sh . . - Sysbench - 'run' - Terminal 3 bin/sysbench share/sysbench/oltp_insert.lua --time=3600 --threads=50 --tables=10 --table_size=1000 --db-driver=mysql --mysql-db=test --mysql-user=root --mysql-socket=/tmp/mysql_ushastry.sock run sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 50 Initializing random number generator from current time Initializing worker threads... Threads started! FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest9 (id, k, c, pad) VALUES (0, 500, '66920297325-53695284707-66487515972-09316402422-67746057055-00952003016-07159179818-43310303413-50386532636-73948208217', '75756000401-79429889454-99830042827-04959011892-60877266101')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest7 (id, k, c, pad) VALUES (0, 479, '62527710640-18017618619-36477381120-03945976557-64662804993-98061799954-08758695016-21479000841-25030247922-02044141765', '69616330193-98462548260-02931987023-18158922218-02383621895')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest6 (id, k, c, pad) VALUES (0, 441, '65559364311-95982776266-17572031087-73531182325-95249242295-52224268748-49978007002-81288758060-95267939937-17047514240', '06312397962-27073761824-19390638120-97195326006-17588960679')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 502, '18981001163-32747760665-87059620090-43070308019-75749876302-32584930652-22437140086-91442332837-32369613959-60725058778', '54731150484-34607961185-13601774002-11613842767-58442235231')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest4 (id, k, c, pad) VALUES (0, 500, '49044134873-99999147097-28669999502-54342036425-46875082249-67490976381-93340268447-52406640799-01728105474-77315056966', '87020305781-18072574076-48787536193-00671041295-65840697440')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 504, '47265571286-17995025839-73812459698-23541077417-01448339632-78255001829-64842346810-79349750660-81210307734-84495994318', '75804198103-60402298185-25094599394-50785283245-40532619154')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 350, '44053477611-78171806360-85006813382-98664043575-62151712983-51971169321-84304387971-75923808502-89306833463-12094746604', '22857693499-16341633596-89867427093-24756256319-15151007526')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 499, '98194393307-56815805915-53830761672-38970104042-61602790115-18741546790-57434470677-10412605051-61849154391-27598296064', '31715654181-41120601199-73759435185-37372220996-18531051794')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest5 (id, k, c, pad) VALUES (0, 502, '78417791554-55700228657-14122128341-98208039660-42863614662-34067147538-45230118805-99549790535-35146690302-88161433036', '75087866002-74413714571-97043214615-03957718010-78406627918')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest9 (id, k, c, pad) VALUES (0, 414, '67263718978-08885016339-73620957429-64407710488-22053789727-32968983007-30956190069-19306769935-27715218315-26018395005', '04267548154-73928887739-46527347992-15535228438-22347404141')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest9 (id, k, c, pad) VALUES (0, 505, '86470682162-46676272303-05634545298-44322467315-10579249568-05276594364-37165871313-90638305806-12180392273-34837889794', '80524567570-95630256860-45600022733-15101981119-19317113582')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest4 (id, k, c, pad) VALUES (0, 545, '34534495491-26269890898-96824389044-75351505958-94059386488-32850143022-23335518365-86819800559-40423677603-66174751045', '53533748808-24100746661-70112370911-49880333489-70597102946')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 505, '57450188455-66154990335-49368357356-76142046512-88060292017-46414644120-61606937638-13805818449-46795128635-39780771580', '57931332912-00584543782-52337724322-97915671218-96864452276')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 449, '70754303552-22721334579-85063967812-45657587138-32322809231-76137809301-65462107853-82667784270-43964966515-13198480036', '99700577972-35602858320-61737315987-61661180233-51992135273')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest10 (id, k, c, pad) VALUES (0, 500, '91963888374-35044535001-43320444445-09497362031-37641298399-23477178936-89503336399-15598643888-67295103770-54003222729', '76016524769-51291234589-66094255184-35252163979-56601419235')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 505, '82660025111-65481551110-03239990280-25719258609-47649664952-26979563501-14155861712-44659228336-11793576925-42540076657', '54084082640-53909301101-93051517305-82839018859-02805577944')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest10 (id, k, c, pad) VALUES (0, 504, '96682272174-65498454763-80647826548-42074494427-70448937854-56467163817-08804581584-82572773069-02930557967-16936618374', '08460202708-50887035028-68022462229-10697111869-85221289072')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest5 (id, k, c, pad) VALUES (0, 506, '59766495780-15629651632-00211842575-95536775806-70899821030-63138684444-59166241557-38499721094-67147226976-62913317903', '45945463680-21013143786-03111343079-40554976689-18301651101')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest6 (id, k, c, pad) VALUES (0, 487, '06685325164-59183560302-85314379405-31921749480-02557450862-09230468413-25998164364-44038925319-63171688709-60493222741', '69929689696-29833692119-15902729081-07786291118-50025201583')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 525, '76475777608-80682620072-70515842020-89802038376-15661135444-76891408384-82070067852-62681037039-91511099958-89947474590', '00768483140-81951971676-14284811852-47491607110-00512642263')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 505, '30319773188-04130683356-88960041459-84362052569-03805184600-43453005048-05792160411-10601606364-89665223053-70146043285', '87334247973-17237350195-98307403515-26704719940-40971543661')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest2 (id, k, c, pad) VALUES (0, 503, '09151210496-40982194249-18221308026-27943899401-10853415765-84798631901-56977111995-25172208662-39026590891-03818433247', '91476659554-62877082018-04761902389-57067286276-45282603540')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest4 (id, k, c, pad) VALUES (0, 499, '46589287588-68426294634-45210369110-84844630501-49552010046-94348101643-96097794062-02005130635-36406828861-14772428343', '97813349728-11576231882-86245374827-77772233591-71049204760')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest7 (id, k, c, pad) VALUES (0, 502, '70733437797-07971023756-65711407252-20794792902-20333960594-70622681920-74399749355-15401455191-97971497216-87582463760', '52779115967-12088487512-05204460371-86598794643-98714105374')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 570, '82449571745-14311288090-30619838311-45556199544-89516911497-90409026604-59057866131-15638749575-83644784312-18479366254', '63226352315-28461926318-84029587066-82317702892-67982626041')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 505, '17964604633-39369355968-80137877201-57877789773-06659618615-56065800071-32771225684-61762812736-90603697877-04226117197', '14648118020-75582708139-92739973104-35438463770-22003369831')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest7 (id, k, c, pad) VALUES (0, 501, '30182162633-19885955580-28680144144-36188049747-52365099653-54462362299-53468062274-16186957508-52570596209-54606094482', '17324459151-86839779195-40187669043-65125229534-60756263219')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest9 (id, k, c, pad) VALUES (0, 502, '11358484627-22022226462-53942035516-24473164597-30549363441-42346156350-59676402622-66043283295-96478846586-00866129298', '19758306307-53315925732-24086284612-58039363774-43425156858')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest9 (id, k, c, pad) VALUES (0, 502, '10246257008-80711913342-23533513555-59503172729-55803942390-57179582349-58297212784-22964786193-33452282412-84937378479', '29440813958-58800085625-44403080214-67504725424-93157174962')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 386, '46747195774-20925431975-95130344781-83048589482-29210184956-17224794679-96492691669-81272184586-78923895901-84318008106', '14579198350-26543375978-53051020341-38669108517-61872062803')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest5 (id, k, c, pad) VALUES (0, 499, '77317575547-22652924967-30153403737-68584585732-89178655510-34101454696-60930563734-73274431391-57688051843-28814711933', '53954593059-93433943474-74826725061-79590226849-86943364310')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 501, '35739357674-50458296117-68909722854-23318846408-85142343249-48829442040-03466220033-53154256711-46096677856-48760506266', '48635532187-02512034884-60036353507-39046026207-08323056683')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 500, '46392775784-69546413952-02184582686-33335333438-49205260935-69306554269-81250899337-29095839715-25173374893-83503148868', '53625675515-15227279356-09300357238-81235606982-91146392846')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest5 (id, k, c, pad) VALUES (0, 500, '79129529533-92901284151-43486459695-37353490667-20952900789-97012960023-67972773643-03537219476-16486227240-29619059785', '81088993422-05266269893-55904519181-59682950806-95091267957')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest4 (id, k, c, pad) VALUES (0, 505, '38939235500-94052344928-20333680216-79114920627-26193657473-12766606158-38057045624-18973737055-79449804896-43348014055', '73042781497-22111309291-96578059577-77690555123-61800104954')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 420, '10094896172-46486511899-68391579253-37607193125-88343065239-65598514302-84168330150-29813537517-80345299127-94211338072', '20270209327-48667353285-87348484572-74838277553-79740004979')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest8 (id, k, c, pad) VALUES (0, 505, '96884906000-28096605652-97686980181-43094036275-99629606696-14918347321-16936318571-65586205960-37549333841-94094119554', '88835192481-83116313536-34292087194-41530587380-23376937456')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest6 (id, k, c, pad) VALUES (0, 599, '37799457940-96274950777-53095359852-80984676792-15330249965-23535707574-22580149966-63430702663-25389934765-75034302215', '27151725689-31543964909-55001223249-75461683722-71284148813')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest3 (id, k, c, pad) VALUES (0, 503, '03744570543-67846275481-72216796280-00259514424-98259291534-94120853101-65604494213-19037740063-34507420912-74799519009', '69241010025-26824752739-69271192052-50998814591-18991931913')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest2 (id, k, c, pad) VALUES (0, 504, '77978138922-78836021424-61592472106-48521347736-98713366936-91163350784-91866681116-89517993079-33821280815-49478163518', '28259164402-95089719623-77027154861-66682510816-28072992542')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest7 (id, k, c, pad) VALUES (0, 504, '63159099159-97027334795-38395822596-79160172959-21639965730-35412018913-16064515911-11601517098-00194232112-42670077084', '12110730412-63748987867-21128374354-99969128572-42076053184')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest9 (id, k, c, pad) VALUES (0, 502, '01764584785-56189144506-58273336989-78565313114-23245794849-81270053857-56041413792-99823390659-08432635328-52505641932', '62515997159-11778973021-30797998925-45071304302-02234052444')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest4 (id, k, c, pad) VALUES (0, 505, '10632410653-00682246949-81344139528-62953837509-58685138980-22713786347-16913814298-55073764325-39794325934-24819621201', '41107937241-53024747885-28498625371-00149321206-59535795157')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest10 (id, k, c, pad) VALUES (0, 501, '05801204856-69824638882-01642349570-05457110940-64797431229-32846049925-81330723422-11505570013-50672950128-86285320220', '98118725034-06353657368-06172044713-41340742619-89976496123')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest4 (id, k, c, pad) VALUES (0, 503, '84059046288-24375305011-89270444783-63488399391-53054442317-63432361871-68049686525-80500693570-41556419532-35270474175', '02593953912-86590584158-62362778472-19082759763-23244346131')' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (0, 498, '75606375527-13168174722-22636058180-14920970915-31940388639-53479665072-65189077337-01938567317-26154814731-81689008373', '10992126674-15684744384-03767514191-47967747268-19591208388')' FATAL: `thread_run' function failed: share/sysbench/oltp_insert.lua:61: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest5 (id, k, c, pad) VALUES (0, 506, '27527185750-54987434480-91970844338-51574760111-26194893503-81650871772-02046956745-94214295698-26084875800-52118428330', '06508584642-64473985754-07126793272-47331549138-38902010960')' (last message repeated 5 times) FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest2 (id, k, c, pad) VALUES (0, 502, '13803162678-40794106979-31446282938-43115938090-01047985325-15139645036-73698241158-34475942104-09513585192-39003358429', '80703287690-62418096302-32198389674-23101094263-75363084069')' FATAL: `thread_run' function failed: share/sysbench/oltp_insert.lua:61: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest8 (id, k, c, pad) VALUES (0, 502, '03007075760-45730439833-12506597614-44699741957-13326243650-23131042346-15384891909-21521427426-01944982396-78246492904', '41100236524-66900525095-17252686848-76790800674-10710493219')' (last message repeated 2 times) FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest6 (id, k, c, pad) VALUES (0, 499, '26800437561-48035029580-89049867576-75598614452-96468792795-75620821259-84928349673-77351044207-42669512854-66235506218', '65844759875-07272764283-43771856830-96596683355-39828073066')' FATAL: `thread_run' function failed: share/sysbench/oltp_insert.lua:61: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query Error in my_thread_global_end(): 50 threads didn't exit - Terminal 1 - Observed that mysqld asserts - Overall - it took >30min . . mysql> \q Bye [1]+ Aborted (core dumped) bin/mysqld-debug --no-defaults --basedir=$PWD --datadir=$PWD/95573 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/95573/log.err --log-error-verbosity=3 --server-id=100 --log-bin=binlog 2>&1 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.26: gdb bin/mysqld-debug 95573/core.32648 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-64.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: ... Reading symbols from /export/umesh/server/binaries/GABuilds/mysql-5.7.26/bin/mysqld-debug...done. Illegal process-id: 95573/core.32648. [New LWP 2315] [New LWP 2320] [New LWP 2324] [New LWP 2322] [New LWP 2327] [New LWP 2326] [New LWP 2332] [New LWP 2331] [New LWP 10930] [New LWP 32660] [New LWP 32664] [New LWP 32655] [New LWP 32669] [New LWP 32659] [New LWP 32650] [New LWP 32668] [New LWP 32665] [New LWP 2350] [New LWP 32653] [New LWP 32652] [New LWP 10942] [New LWP 32721] [New LWP 32675] [New LWP 11025] [New LWP 32663] [New LWP 32651] [New LWP 10939] [New LWP 11022] [New LWP 32672] [New LWP 32648] [New LWP 1378] [New LWP 32649] [New LWP 2319] [New LWP 2317] [New LWP 1315] [New LWP 2318] [New LWP 2333] [New LWP 2334] [New LWP 2328] [New LWP 1368] [New LWP 2323] [New LWP 2339] [New LWP 32657] [New LWP 1314] [New LWP 2346] [New LWP 2335] [New LWP 1279] [New LWP 11027] [New LWP 2338] [New LWP 32654] [New LWP 2341] [New LWP 1139] [New LWP 2330] [New LWP 32662] [New LWP 2355] [New LWP 32671] [New LWP 11021] [New LWP 2354] [New LWP 2337] [New LWP 2353] [New LWP 32666] [New LWP 32674] [New LWP 2321] [New LWP 2316] [New LWP 2325] [New LWP 2348] [New LWP 2329] [New LWP 2340] [New LWP 2347] [New LWP 2345] [New LWP 32656] [New LWP 2314] [New LWP 2349] [New LWP 1348] [New LWP 2352] [New LWP 2313] [New LWP 32673] [New LWP 1289] [New LWP 32670] [New LWP 1287] [New LWP 2351] [New LWP 2342] [New LWP 2336] [New LWP 32667] [New LWP 11033] [New LWP 11032] [New LWP 32658] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `bin/mysqld-debug --no-defaults --basedir=/export/umesh/server/binaries/GABuilds'. Program terminated with signal 6, Aborted. #0 0x00007f4cc5bee771 in pthread_kill () from /lib64/libpthread.so.0 Missing separate debuginfos, use: debuginfo-install glibc-2.17-78.0.1.el7.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.3-9.el7.x86_64 libstdc++-4.8.3-9.el7.x86_64 nss-softokn-freebl-3.16.2.3-13.el7_1.x86_64 numactl-libs-2.0.9-5.el7_1.x86_64 (gdb) bt #0 0x00007f4cc5bee771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000018e3dc5 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/mysys/stacktrace.c:249 #2 0x0000000000ee01e6 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/signal_handler.cc:220 #3 #4 0x00007f4cc45e85d7 in raise () from /lib64/libc.so.6 #5 0x00007f4cc45e9cc8 in abort () from /lib64/libc.so.6 #6 0x0000000001c6d6af in ut_dbg_assertion_failed (expr=0x2387830 "(block)->index || os_atomic_increment_ulint(&(block)->n_pointers, 0) == 0", file=0x2387448 "/export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/btr/btr0sea.cc", line=1823) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000001cb9346 in btr_search_update_hash_on_insert (cursor=0x7f4c903328d0) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/btr/btr0sea.cc:1823 #8 0x0000000001c9ffe4 in btr_cur_optimistic_insert (flags=0, cursor=0x7f4c903328d0, offsets=0x7f4c903329a8, heap=0x7f4c90331920, entry=0x7f4ba40121c8, rec=0x7f4c903329a0, big_rec=0x7f4c90332998, n_ext=0, thr=0x7f4ba4016df8, mtr=0x7f4c903320a0) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/btr/btr0cur.cc:3272 #9 0x0000000001b6b857 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7f4c4801cf80, offsets_heap=0x7f4ad4027638, heap=0x7f4ad40175a8, entry=0x7f4ba40121c8, trx_id=0, thr=0x7f4ba4016df8, dup_chk_only=false) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0ins.cc:3127 #10 0x0000000001b6c3ae in row_ins_sec_index_entry (index=0x7f4c4801cf80, entry=0x7f4ba40121c8, thr=0x7f4ba4016df8, dup_chk_only=false) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0ins.cc:3382 #11 0x0000000001b6c56a in row_ins_index_entry (index=0x7f4c4801cf80, entry=0x7f4ba40121c8, thr=0x7f4ba4016df8) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0ins.cc:3431 #12 0x0000000001b6caa6 in row_ins_index_entry_step (node=0x7f4ba4016aa8, thr=0x7f4ba4016df8) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0ins.cc:3579 #13 0x0000000001b6ce0d in row_ins (node=0x7f4ba4016aa8, thr=0x7f4ba4016df8) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0ins.cc:3717 #14 0x0000000001b6d272 in row_ins_step (thr=0x7f4ba4016df8) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0ins.cc:3853 #15 0x0000000001b8b637 in row_insert_for_mysql_using_ins_graph (mysql_rec=0x7f4ba4011220 "\377\207\366\005", prebuilt=0x7f4ba40164a0) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0mysql.cc:1738 #16 0x0000000001b8bb48 in row_insert_for_mysql (mysql_rec=0x7f4ba4011220 "\377\207\366\005", prebuilt=0x7f4ba40164a0) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/row/row0mysql.cc:1859 #17 0x0000000001a337c5 in ha_innobase::write_row (this=0x7f4ba4010e10, record=0x7f4ba4011220 "\377\207\366\005") at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/innobase/handler/ha_innodb.cc:7598 #18 0x0000000000f67294 in handler::ha_write_row (this=0x7f4ba4010e10, buf=0x7f4ba4011220 "\377\207\366\005") at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/handler.cc:8062 #19 0x00000000017cb445 in write_record (thd=0x7f4ad4012340, table=0x7f4ba4010420, info=0x7f4c90333bd0, update=0x7f4c90333b50) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_insert.cc:1873 #20 0x00000000017c851c in Sql_cmd_insert::mysql_insert (this=0x7f4ad4002838, thd=0x7f4ad4012340, table_list=0x7f4ad4001c70) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_insert.cc:769 #21 0x00000000017cf051 in Sql_cmd_insert::execute (this=0x7f4ad4002838, thd=0x7f4ad4012340) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_insert.cc:3118 #22 0x00000000015985cd in mysql_execute_command (thd=0x7f4ad4012340, first_level=true) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_parse.cc:3596 #23 0x000000000159e580 in mysql_parse (thd=0x7f4ad4012340, parser_state=0x7f4c90335690) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_parse.cc:5570 #24 0x000000000159315c in dispatch_command (thd=0x7f4ad4012340, com_data=0x7f4c90335e00, command=COM_QUERY) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_parse.cc:1484 #25 0x0000000001591fa1 in do_command (thd=0x7f4ad4012340) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/sql_parse.cc:1025 #26 0x00000000016c89bd in handle_connection (arg=0x54ce840) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/sql/conn_handler/connection_handler_per_thread.cc:306 #27 0x000000000199d780 in pfs_spawn_thread (arg=0x5475500) at /export/home/pb2/build/sb_0-33648028-1555164244.06/mysql-5.7.26/storage/perfschema/pfs.cc:2190 #28 0x00007f4cc5be9df5 in start_thread () from /lib64/libpthread.so.0 #29 0x00007f4cc46a960d in clone () from /lib64/libc.so.6 (gdb) - extract from mysql error log cat 95573/log.err 2019-07-09T10:36:19.095887Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-07-09T10:36:19.096048Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2019-07-09T10:36:19.096113Z 0 [Note] bin/mysqld-debug (mysqld 5.7.26-debug-log) starting as process 32648 ... 2019-07-09T10:36:19.246520Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-07-09T10:36:19.246562Z 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-07-09T10:36:19.246570Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-07-09T10:36:19.246576Z 0 [Note] InnoDB: Uses event mutexes 2019-07-09T10:36:19.246583Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2019-07-09T10:36:19.246589Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-09T10:36:19.246595Z 0 [Note] InnoDB: Using Linux native AIO 2019-07-09T10:36:19.247110Z 0 [Note] InnoDB: Number of pools: 1 2019-07-09T10:36:19.247286Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-07-09T10:36:19.249319Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-07-09T10:36:19.324130Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-09T10:36:19.326825Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-07-09T10:36:19.340448Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-07-09T10:36:19.389588Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-09T10:36:19.389683Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-09T10:36:19.407388Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-07-09T10:36:19.416548Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-07-09T10:36:19.416568Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-07-09T10:36:19.418705Z 0 [Note] InnoDB: Waiting for purge to start 2019-07-09T10:36:19.468962Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2524985 2019-07-09T10:36:19.469205Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.26/95573/ib_buffer_pool 2019-07-09T10:36:19.469621Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-07-09T10:36:19.481506Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190709 12:36:19 2019-07-09T10:36:19.497940Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2019-07-09T10:36:19.497966Z 0 [Note] Server hostname (bind-address): '*'; port: 3333 2019-07-09T10:36:19.498041Z 0 [Note] IPv6 is available. 2019-07-09T10:36:19.498068Z 0 [Note] - '::' resolves to '::'; 2019-07-09T10:36:19.498088Z 0 [Note] Server socket created on IP: '::'. 2019-07-09T10:36:19.521761Z 0 [Note] Failed to start slave threads for channel '' 2019-07-09T10:36:19.539439Z 0 [Note] Event Scheduler: Loaded 0 events 2019-07-09T10:36:19.539809Z 0 [Note] bin/mysqld-debug: ready for connections. Version: '5.7.26-debug-log' socket: '/tmp/mysql_ushastry.sock' port: 3333 MySQL Community Server - Debug (GPL) 2019-07-09T10:49:36.261296Z 227 [Note] Aborted connection 227 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.261732Z 266 [Note] Aborted connection 266 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.261760Z 240 [Note] Aborted connection 240 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.261777Z 223 [Note] Aborted connection 223 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.262138Z 267 [Note] Aborted connection 267 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.262341Z 234 [Note] Aborted connection 234 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.262362Z 222 [Note] Aborted connection 222 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.262402Z 258 [Note] Aborted connection 258 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.262665Z 229 [Note] Aborted connection 229 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.262693Z 230 [Note] Aborted connection 230 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.262724Z 220 [Note] Aborted connection 220 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.262905Z 264 [Note] Aborted connection 264 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.263022Z 242 [Note] Aborted connection 242 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.263162Z 255 [Note] Aborted connection 255 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.263291Z 256 [Note] Aborted connection 256 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.263302Z 226 [Note] Aborted connection 226 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.264025Z 248 [Note] Aborted connection 248 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.264236Z 260 [Note] Aborted connection 260 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.264323Z 290 [Note] Aborted connection 290 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.264346Z 233 [Note] Aborted connection 233 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.264351Z 284 [Note] Aborted connection 284 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.264620Z 224 [Note] Aborted connection 224 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.264676Z 285 [Note] Aborted connection 285 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.264823Z 294 [Note] Aborted connection 294 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.264847Z 313 [Note] Aborted connection 313 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.264909Z 292 [Note] Aborted connection 292 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.265015Z 303 [Note] Aborted connection 303 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.265187Z 277 [Note] Aborted connection 277 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.265230Z 251 [Note] Aborted connection 251 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.265235Z 278 [Note] Aborted connection 278 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.265430Z 281 [Note] Aborted connection 281 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.265484Z 300 [Note] Aborted connection 300 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.265727Z 269 [Note] Aborted connection 269 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.265938Z 298 [Note] Aborted connection 298 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.265945Z 317 [Note] Aborted connection 317 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.266071Z 268 [Note] Aborted connection 268 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.266267Z 315 [Note] Aborted connection 315 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.266404Z 291 [Note] Aborted connection 291 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.266448Z 305 [Note] Aborted connection 305 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.266653Z 312 [Note] Aborted connection 312 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.266928Z 310 [Note] Aborted connection 310 to db: 'test' user: 'root' host: 'localhost' (Got an error reading communication packets) 2019-07-09T10:49:36.267113Z 246 [Note] Aborted connection 246 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.267134Z 272 [Note] Aborted connection 272 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.271666Z 299 [Note] Aborted connection 299 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.271786Z 218 [Note] Aborted connection 218 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.271866Z 282 [Note] Aborted connection 282 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272013Z 273 [Note] Aborted connection 273 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272038Z 289 [Note] Aborted connection 289 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272102Z 271 [Note] Aborted connection 271 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272159Z 314 [Note] Aborted connection 314 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272498Z 274 [Note] Aborted connection 274 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272524Z 283 [Note] Aborted connection 283 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272567Z 311 [Note] Aborted connection 311 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.272866Z 275 [Note] Aborted connection 275 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.273026Z 243 [Note] Aborted connection 243 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.273051Z 221 [Note] Aborted connection 221 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.273518Z 265 [Note] Aborted connection 265 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.273845Z 253 [Note] Aborted connection 253 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.273520Z 228 [Note] Aborted connection 228 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.275501Z 306 [Note] Aborted connection 306 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.275688Z 297 [Note] Aborted connection 297 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.275958Z 261 [Note] Aborted connection 261 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276074Z 307 [Note] Aborted connection 307 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276176Z 225 [Note] Aborted connection 225 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276421Z 259 [Note] Aborted connection 259 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276420Z 262 [Note] Aborted connection 262 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276537Z 257 [Note] Aborted connection 257 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276601Z 250 [Note] Aborted connection 250 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276708Z 296 [Note] Aborted connection 296 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276809Z 235 [Note] Aborted connection 235 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.276990Z 301 [Note] Aborted connection 301 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277034Z 304 [Note] Aborted connection 304 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277200Z 231 [Note] Aborted connection 231 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277256Z 219 [Note] Aborted connection 219 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277263Z 241 [Note] Aborted connection 241 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277349Z 232 [Note] Aborted connection 232 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277395Z 287 [Note] Aborted connection 287 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277517Z 238 [Note] Aborted connection 238 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277532Z 263 [Note] Aborted connection 263 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277556Z 279 [Note] Aborted connection 279 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277583Z 244 [Note] Aborted connection 244 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277806Z 280 [Note] Aborted connection 280 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277850Z 254 [Note] Aborted connection 254 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.277880Z 245 [Note] Aborted connection 245 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278013Z 270 [Note] Aborted connection 270 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278198Z 252 [Note] Aborted connection 252 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278232Z 237 [Note] Aborted connection 237 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278264Z 309 [Note] Aborted connection 309 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278310Z 288 [Note] Aborted connection 288 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278437Z 286 [Note] Aborted connection 286 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278486Z 236 [Note] Aborted connection 236 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278490Z 295 [Note] Aborted connection 295 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278565Z 302 [Note] Aborted connection 302 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278772Z 293 [Note] Aborted connection 293 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278776Z 247 [Note] Aborted connection 247 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.278860Z 249 [Note] Aborted connection 249 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.279645Z 308 [Note] Aborted connection 308 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.279981Z 239 [Note] Aborted connection 239 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.280078Z 316 [Note] Aborted connection 316 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09T10:49:36.281736Z 276 [Note] Aborted connection 276 to db: 'test' user: 'root' host: 'localhost' (Got an error writing communication packets) 2019-07-09 13:28:14 0x7f4c90336700 InnoDB: Assertion failure in thread 139966813529856 in file btr0sea.cc line 1823 InnoDB: Failing assertion: (block)->index || os_atomic_increment_ulint(&(block)->n_pointers, 0) == 0 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/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 11:28:14 UTC - mysqld got signal 6 ; 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. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=103 max_threads=151 thread_count=52 connection_count=52 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68203 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f4ad4012340 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 = 7f4c90335e30 thread_stack 0x40000 bin/mysqld-debug(my_print_stacktrace+0x35)[0x18e3d3e] bin/mysqld-debug(handle_fatal_signal+0x407)[0xedfff0] /lib64/libpthread.so.0(+0xf130)[0x7f4cc5bf1130] /lib64/libc.so.6(gsignal+0x37)[0x7f4cc45e85d7] /lib64/libc.so.6(abort+0x148)[0x7f4cc45e9cc8] bin/mysqld-debug[0x1c6d6af] bin/mysqld-debug(_Z32btr_search_update_hash_on_insertP9btr_cur_t+0x12e)[0x1cb9346] bin/mysqld-debug(_Z25btr_cur_optimistic_insertmP9btr_cur_tPPmPP16mem_block_info_tP8dtuple_tPPhPP9big_rec_tmP9que_thr_tP5mtr_t+0xa5e)[0x1c9ffe4] bin/mysqld-debug(_Z27row_ins_sec_index_entry_lowmmP12dict_index_tP16mem_block_info_tS2_P8dtuple_tmP9que_thr_tb+0xd38)[0x1b6b857] bin/mysqld-debug(_Z23row_ins_sec_index_entryP12dict_index_tP8dtuple_tP9que_thr_tb+0x1c4)[0x1b6c3ae] bin/mysqld-debug[0x1b6c56a] bin/mysqld-debug[0x1b6caa6] bin/mysqld-debug[0x1b6ce0d] bin/mysqld-debug(_Z12row_ins_stepP9que_thr_t+0x2c8)[0x1b6d272] bin/mysqld-debug[0x1b8b637] bin/mysqld-debug(_Z20row_insert_for_mysqlPKhP14row_prebuilt_t+0x4c)[0x1b8bb48] bin/mysqld-debug(_ZN11ha_innobase9write_rowEPh+0x709)[0x1a337c5] bin/mysqld-debug(_ZN7handler12ha_write_rowEPh+0x21c)[0xf67294] bin/mysqld-debug(_Z12write_recordP3THDP5TABLEP9COPY_INFOS4_+0xee1)[0x17cb445] bin/mysqld-debug(_ZN14Sql_cmd_insert12mysql_insertEP3THDP10TABLE_LIST+0xdde)[0x17c851c] bin/mysqld-debug(_ZN14Sql_cmd_insert7executeEP3THD+0x183)[0x17cf051] bin/mysqld-debug(_Z21mysql_execute_commandP3THDb+0x2f1b)[0x15985cd] bin/mysqld-debug(_Z11mysql_parseP3THDP12Parser_state+0x589)[0x159e580] bin/mysqld-debug(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xcc7)[0x159315c] bin/mysqld-debug(_Z10do_commandP3THD+0x4b3)[0x1591fa1] bin/mysqld-debug(handle_connection+0x1e7)[0x16c89bd] bin/mysqld-debug(pfs_spawn_thread+0x170)[0x199d780] /lib64/libpthread.so.0(+0x7df5)[0x7f4cc5be9df5] /lib64/libc.so.6(clone+0x6d)[0x7f4cc46a960d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f4ad4000980): INSERT INTO sbtest5 (id, k, c, pad) VALUES (0, 500, '79129529533-92901284151-43486459695-37353490667-20952900789-97012960023-67972773643-03537219476-16486227240-29619059785', '81088993422-05266269893-55904519181-59682950806-95091267957') Connection ID (thread ID): 430 Status: NOT_KILLED 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