-- 8.0.17 rm -rf 96373/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/96373 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96373 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96373/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1 & bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.17 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> set global slow_query_log = ON; Query OK, 0 rows affected (0.06 sec) mysql> set global log_output = 'TABLE'; Query OK, 0 rows affected (0.00 sec) mysql> select * from mysql.slow_log; Empty set (36.48 sec) -- gdb session gdb -p 1405 /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld 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-8.0.17/bin/mysqld...done. Attaching to program: /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld, process 1405 Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done. [New LWP 1452] [New LWP 1447] [New LWP 1446] [New LWP 1445] [New LWP 1444] [New LWP 1443] [New LWP 1442] [New LWP 1441] [New LWP 1440] [New LWP 1437] [New LWP 1435] [New LWP 1434] [New LWP 1433] [New LWP 1432] [New LWP 1431] [New LWP 1430] [New LWP 1429] [New LWP 1428] [New LWP 1427] [New LWP 1426] [New LWP 1425] [New LWP 1424] [New LWP 1423] [New LWP 1422] [New LWP 1421] [New LWP 1420] [New LWP 1419] [New LWP 1418] [New LWP 1417] [New LWP 1416] [New LWP 1415] [New LWP 1414] [New LWP 1413] [New LWP 1412] [New LWP 1411] [New LWP 1410] [New LWP 1409] [New LWP 1408] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Loaded symbols for /lib64/libpthread.so.0 Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/librt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/librt.so.1 Reading symbols from /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/libssl.so.1.0.0...(no debugging symbols found)...done. Loaded symbols for /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/libssl.so.1.0.0 Reading symbols from /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/libcrypto.so.1.0.0...(no debugging symbols found)...done. Loaded symbols for /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/libcrypto.so.1.0.0 Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libaio.so.1...Reading symbols from /lib64/libaio.so.1...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libaio.so.1 Reading symbols from /lib64/libnuma.so.1...Reading symbols from /lib64/libnuma.so.1...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libnuma.so.1 Reading symbols from /export/umesh/utils/GCC-7.3.0/lib64/libstdc++.so.6...done. Loaded symbols for /export/umesh/utils/GCC-7.3.0/lib64/libstdc++.so.6 Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libm.so.6 Reading symbols from /export/umesh/utils/GCC-7.3.0/lib64/libgcc_s.so.1...done. Loaded symbols for /export/umesh/utils/GCC-7.3.0/lib64/libgcc_s.so.1 Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libfreebl3.so...Reading symbols from /lib64/libfreebl3.so...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libfreebl3.so 0x00007fa22dfc900d in poll () from /lib64/libc.so.6 warning: File "/export/umesh/utils/GCC-7.3.0/lib64/libstdc++.so.6.0.24-gdb.py" auto-loading has been declined by your `auto-load safe-path' set to "$debugdir:$datadir/auto-load:/usr/bin/mono-gdb.py". To enable execution of this file add add-auto-load-safe-path /export/umesh/utils/GCC-7.3.0/lib64/libstdc++.so.6.0.24-gdb.py line to your configuration file "/home/umshastr/.gdbinit". To completely disable this security protection add set auto-load safe-path / line to your configuration file "/home/umshastr/.gdbinit". For more information about this security protection see the "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: info "(gdb)Auto-loading safe path" Missing separate debuginfos, use: debuginfo-install glibc-2.17-78.0.1.el7.x86_64 libaio-0.3.109-12.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) b mysql_execute_command Breakpoint 1 at 0xe1d0e0: file ../../mysql-8.0.17/sql/sql_parse.cc, line 2612. (gdb) c Continuing. [Switching to Thread 0x7fa218122700 (LWP 1452)] Breakpoint 1, mysql_execute_command(THD*, bool) () at ../../mysql-8.0.17/sql/sql_parse.cc:2612 2612 ../../mysql-8.0.17/sql/sql_parse.cc: No such file or directory. (gdb) p thd->start_time.tv_sec = 1555826389 $1 = 1555826389 (gdb) p thd->start_utime = (longlong)1555826389*1000000 $2 = 1555826389000000 (gdb) c Continuing. Breakpoint 1, mysql_execute_command(THD*, bool) () at ../../mysql-8.0.17/sql/sql_parse.cc:2612 2612 in ../../mysql-8.0.17/sql/sql_parse.cc (gdb) c Continuing. - CLI session mysql> select * from mysql.slow_log; ERROR 1194 (HY000): Table 'slow_log' is marked as crashed and should be repaired mysql>