rm -rf 96501/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/96501 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96501 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96501/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 PERSIST wait_timeout = 100; Query OK, 0 rows affected (0.03 sec) mysql> mysql> system cat 96501/mysqld-auto.cnf { "Version" : 1 , "mysql_server" : { "wait_timeout" : { "Value" : "100" , "Metadata" : { "Timestamp" : 1565525465262767 , "User" : "root" , "Host" : "localhost" } } } } - restart after corrupting 96501/mysqld-auto.cnf - removed closing '"" of value cat 96501/mysqld-auto.cnf { "Version" : 1 , "mysql_server" : { "wait_timeout" : { "Value : "100" , "Metadata" : { "Timestamp" : 1565525465262767 , "User" : "root" , "Host" : "localhost" } } } } -- bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96501 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96501/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1 & [1] 31730 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.17: [1]+ Exit 1 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96501 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96501/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.17: cat 96501/log.err 2019-08-11T12:10:47.912766Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2019-08-11T12:10:47.912818Z 0 [Note] [MY-010949] [Server] Basedir set to /export/umesh/server/binaries/GABuilds/mysql-8.0.17/. 2019-08-11T12:10:48.415605Z 4 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 4 2019-08-11T12:10:47.912834Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld (mysqld 8.0.17) starting as process 31608 2019-08-11T12:10:47.921333Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2019-08-11T12:10:47.921649Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2019-08-11T12:10:47.924510Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2019-08-11T12:10:47.924540Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins 2019-08-11T12:10:47.924568Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2019-08-11T12:10:47.924579Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2019-08-11T12:10:47.924605Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11 2019-08-11T12:10:47.924958Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2019-08-11T12:10:47.925118Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions 2019-08-11T12:10:47.925781Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './;./;./' 2019-08-11T12:10:47.925856Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2019-08-11T12:10:47.926892Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files. 2019-08-11T12:10:47.927886Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 2019-08-11T12:10:47.936672Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2019-08-11T12:10:47.938081Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-08-11T12:10:48.016143Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 19353127, whereas checkpoint_lsn = 19353127 2019-08-11T12:10:48.017079Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2019-08-11T12:10:48.017354Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2019-08-11T12:10:48.017369Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2019-08-11T12:10:48.017507Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2019-08-11T12:10:48.017681Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2019-08-11T12:10:48.021146Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2019-08-11T12:10:48.021174Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1235 2019-08-11T12:10:48.031780Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2019-08-11T12:10:48.031870Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-08-11T12:10:48.048212Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2019-08-11T12:10:48.048426Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2019-08-11T12:10:48.080383Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2019-08-11T12:10:48.080729Z 1 [Note] [MY-012976] [InnoDB] 8.0.17 started; log sequence number 19353127 2019-08-11T12:10:48.089641Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80017'. 2019-08-11T12:10:48.194050Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2019-08-11T12:10:48.195108Z 1 [Note] [MY-012356] [InnoDB] Validated 6/6 tablespaces 2019-08-11T12:10:48.195578Z 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-8.0.17/96501/ib_buffer_pool 2019-08-11T12:10:48.196456Z 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 190811 14:10:48 2019-08-11T12:10:48.213188Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80017'. 2019-08-11T12:10:48.304722Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege. 2019-08-11T12:10:48.328684Z 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2019-08-11T12:10:48.328766Z 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2019-08-11T12:10:48.334470Z 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2019-08-11T12:10:48.386742Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation. 2019-08-11T12:10:48.387242Z 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-08-11T12:10:48.387261Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-08-11T12:10:48.388608Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2019-08-11T12:10:48.388663Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory. 2019-08-11T12:10:48.388677Z 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory. 2019-08-11T12:10:48.388887Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3333 2019-08-11T12:10:48.388960Z 0 [Note] [MY-010253] [Server] IPv6 is available. 2019-08-11T12:10:48.388997Z 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2019-08-11T12:10:48.389052Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2019-08-11T12:10:48.413470Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''. 2019-08-11T12:10:48.416099Z 0 [System] [MY-010931] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld: ready for connections. Version: '8.0.17' socket: '/tmp/mysql_ushastry.sock' port: 3333 MySQL Community Server - GPL. 2019-08-11T12:10:48.468639Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server' 2019-08-11T12:10:48.469187Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections' 2019-08-11T12:10:48.469251Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2019-08-11T12:10:48.469953Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33330' 2019-08-11T12:10:48.469986Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_x_ushastry.sock'' 2019-08-11T12:10:48.470001Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/tmp/mysql_x_ushastry.sock' bind-address: '::' port: 33330 2019-08-11T12:12:57.379104Z 8 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.17). 2019-08-11T12:12:57.578135Z 0 [Note] [MY-010067] [Server] Giving 1 client threads a chance to die gracefully 2019-08-11T12:12:57.578173Z 0 [Note] [MY-010117] [Server] Shutting down slave threads 2019-08-11T12:12:57.578189Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 4 2019-08-11T12:12:57.578198Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply 2019-08-11T12:12:57.578286Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped 2019-08-11T12:12:57.578299Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 0 remaining clients 2019-08-11T12:12:57.578313Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events 2019-08-11T12:12:57.579602Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting. 2019-08-11T12:12:57.582254Z 0 [Note] [MY-010120] [Server] Binlog end 2019-08-11T12:12:57.583064Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner' 2019-08-11T12:12:57.583099Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx' 2019-08-11T12:12:57.583433Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram' 2019-08-11T12:12:57.583448Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE' 2019-08-11T12:12:57.583462Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE' 2019-08-11T12:12:57.583467Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable' 2019-08-11T12:12:57.583473Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-08-11T12:12:57.583516Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM' 2019-08-11T12:12:57.583523Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' 2019-08-11T12:12:57.583538Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES' 2019-08-11T12:12:57.583545Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES' 2019-08-11T12:12:57.583551Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL' 2019-08-11T12:12:57.583556Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS' 2019-08-11T12:12:57.583561Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES' 2019-08-11T12:12:57.583566Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES' 2019-08-11T12:12:57.583571Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS' 2019-08-11T12:12:57.583577Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES' 2019-08-11T12:12:57.583582Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-08-11T12:12:57.583587Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-08-11T12:12:57.583591Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG' 2019-08-11T12:12:57.583596Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-08-11T12:12:57.583601Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED' 2019-08-11T12:12:57.583606Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-08-11T12:12:57.583611Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS' 2019-08-11T12:12:57.583616Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2019-08-11T12:12:57.583621Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-08-11T12:12:57.583626Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-08-11T12:12:57.583632Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-08-11T12:12:57.583637Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-08-11T12:12:57.583642Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-08-11T12:12:57.583646Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-08-11T12:12:57.583651Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM' 2019-08-11T12:12:57.583656Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET' 2019-08-11T12:12:57.583660Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP' 2019-08-11T12:12:57.583665Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX' 2019-08-11T12:12:57.583670Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' 2019-08-11T12:12:57.583696Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown... 2019-08-11T12:12:57.583780Z 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-8.0.17/96501/ib_buffer_pool 2019-08-11T12:12:57.584103Z 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 190811 14:12:57 2019-08-11T12:12:58.249941Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed... 2019-08-11T12:12:58.712458Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 19723663 2019-08-11T12:12:58.715352Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2019-08-11T12:12:58.715382Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY' 2019-08-11T12:12:58.715394Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV' 2019-08-11T12:12:58.715404Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner' 2019-08-11T12:12:58.715412Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password' 2019-08-11T12:12:58.715423Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password' 2019-08-11T12:12:58.715428Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password' 2019-08-11T12:12:58.715672Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog' 2019-08-11T12:12:58.718976Z 0 [System] [MY-010910] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.17/bin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL. -- even with --console, not much noticed bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96501 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ --console [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.17: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.17: