Skip to content

Instantly share code, notes, and snippets.

@Cyberiaaxis
Created November 6, 2017 15:10
Show Gist options
  • Save Cyberiaaxis/4e578f35217775714391013a7f450a5f to your computer and use it in GitHub Desktop.
Save Cyberiaaxis/4e578f35217775714391013a7f450a5f to your computer and use it in GitHub Desktop.
2017-11-06T04:11:43.426284Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-11-06T04:11:43.426341Z 0 [Note] Shutting down slave threads
2017-11-06T04:11:43.426351Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-11-06T04:11:43.426362Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-11-06T04:11:43.589629Z 0 [Note] Binlog end
2017-11-06T04:11:43.886067Z 0 [Note] Shutting down plugin 'ngram'
2017-11-06T04:11:43.982321Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-11-06T04:11:43.982366Z 0 [Note] Shutting down plugin 'partition'
2017-11-06T04:11:43.982374Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-11-06T04:11:43.982380Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-11-06T04:11:43.982387Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-11-06T04:11:43.982394Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-11-06T04:11:43.982400Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-11-06T04:11:43.982406Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-11-06T04:11:43.982448Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-11-06T04:11:43.982456Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-11-06T04:11:43.982462Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-11-06T04:11:43.982467Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-11-06T04:11:43.982473Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-11-06T04:11:43.982478Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-11-06T04:11:43.982485Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-11-06T04:11:43.982490Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-11-06T04:11:43.982496Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-11-06T04:11:43.982502Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-11-06T04:11:43.982507Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-11-06T04:11:43.982513Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-11-06T04:11:43.982519Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-11-06T04:11:43.982524Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-11-06T04:11:43.982530Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-11-06T04:11:43.982536Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-11-06T04:11:43.982541Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-11-06T04:11:43.982547Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-11-06T04:11:43.982553Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-11-06T04:11:43.982559Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-11-06T04:11:43.982571Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-11-06T04:11:43.982578Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-11-06T04:11:43.982584Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-11-06T04:11:43.982590Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-11-06T04:11:43.982596Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-11-06T04:11:43.982602Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-11-06T04:11:43.982607Z 0 [Note] Shutting down plugin 'InnoDB'
2017-11-06T04:11:43.982674Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-11-06T04:11:43.982815Z 0 [Note] InnoDB: Starting shutdown...
2017-11-06T04:11:44.238060Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-11-06T04:11:44.305350Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171106 9:41:44
2017-11-06T04:11:46.641940Z 0 [Note] InnoDB: Shutdown completed; log sequence number 36332762
2017-11-06T04:11:47.321682Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-11-06T04:11:47.321718Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-11-06T04:11:47.321775Z 0 [Note] Shutting down plugin 'MEMORY'
2017-11-06T04:11:47.321784Z 0 [Note] Shutting down plugin 'CSV'
2017-11-06T04:11:47.321792Z 0 [Note] Shutting down plugin 'MyISAM'
2017-11-06T04:11:47.321804Z 0 [Note] Shutting down plugin 'sha256_password'
2017-11-06T04:11:47.321810Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-11-06T04:11:47.351136Z 0 [Note] Shutting down plugin 'binlog'
2017-11-06T04:11:47.414073Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-11-06T04:12:10.452235Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-11-06T04:12:10.452320Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-11-06T04:12:10.929796Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-11-06T04:12:11.164127Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 1074 ...
2017-11-06T04:12:12.722074Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-11-06T04:12:12.722118Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-06T04:12:12.722129Z 0 [Note] InnoDB: Uses event mutexes
2017-11-06T04:12:12.722138Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-11-06T04:12:12.722148Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-11-06T04:12:12.722161Z 0 [Note] InnoDB: Using Linux native AIO
2017-11-06T04:12:12.827083Z 0 [Note] InnoDB: Number of pools: 1
2017-11-06T04:12:12.965916Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-11-06T04:12:12.967960Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-06T04:12:13.033317Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-11-06T04:12:13.404303Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-11-06T04:12:14.024737Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-11-06T04:12:27.802634Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-06T04:12:27.802751Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-06T04:12:28.249263Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-11-06T04:12:28.250409Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-11-06T04:12:28.250428Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-11-06T04:12:28.251741Z 0 [Note] InnoDB: Waiting for purge to start
2017-11-06T04:12:28.301932Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14897ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-11-06T04:12:28.301995Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 36332762
2017-11-06T04:12:28.304232Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-06T04:12:28.304592Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-11-06T04:12:29.882827Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-11-06T04:12:29.882862Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-11-06T04:12:29.882879Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2017-11-06T04:12:29.882929Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-11-06T04:12:32.280756Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171106 9:42:32
2017-11-06T04:12:33.229755Z 0 [Note] Event Scheduler: Loaded 0 events
2017-11-06T04:12:33.229999Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.20-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2017-11-06T04:12:33.230015Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-11-06T04:12:33.230023Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-11-06T06:01:49.280745Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6549979ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-11-06T06:01:52.899383Z 0 [Note] End of list of non-natively partitioned tables
2017-11-06T06:01:52.901613Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-11-06T14:06:14.425292Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-11-06T14:06:14.498902Z 0 [Note] Shutting down slave threads
2017-11-06T14:06:14.498930Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-11-06T14:06:14.498946Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-11-06T14:06:14.499025Z 0 [Note] Binlog end
2017-11-06T14:06:14.555186Z 0 [Note] Shutting down plugin 'ngram'
2017-11-06T14:06:14.563128Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-11-06T14:06:14.563170Z 0 [Note] Shutting down plugin 'partition'
2017-11-06T14:06:14.563178Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-11-06T14:06:14.563185Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-11-06T14:06:14.563193Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-11-06T14:06:14.563200Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-11-06T14:06:14.563207Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-11-06T14:06:14.563213Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-11-06T14:06:14.563220Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-11-06T14:06:14.563226Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-11-06T14:06:14.563232Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-11-06T14:06:14.563239Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-11-06T14:06:14.563245Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-11-06T14:06:14.563252Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-11-06T14:06:14.563258Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-11-06T14:06:14.563265Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-11-06T14:06:14.563271Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-11-06T14:06:14.563277Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-11-06T14:06:14.563284Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-11-06T14:06:14.563290Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-11-06T14:06:14.563296Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-11-06T14:06:14.563303Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-11-06T14:06:14.563309Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-11-06T14:06:14.563316Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-11-06T14:06:14.563322Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-11-06T14:06:14.563329Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-11-06T14:06:14.563335Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-11-06T14:06:14.563342Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-11-06T14:06:14.563349Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-11-06T14:06:14.563356Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-11-06T14:06:14.563362Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-11-06T14:06:14.563369Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-11-06T14:06:14.563403Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-11-06T14:06:14.563412Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-11-06T14:06:14.563419Z 0 [Note] Shutting down plugin 'InnoDB'
2017-11-06T14:06:14.563526Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-11-06T14:06:14.563598Z 0 [Note] InnoDB: Starting shutdown...
2017-11-06T14:06:14.818877Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-11-06T14:06:14.875185Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 171106 19:36:14
2017-11-06T14:06:16.215989Z 0 [Note] InnoDB: Shutdown completed; log sequence number 36332790
2017-11-06T14:06:16.248025Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-11-06T14:06:16.248048Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-11-06T14:06:16.248105Z 0 [Note] Shutting down plugin 'MEMORY'
2017-11-06T14:06:16.248113Z 0 [Note] Shutting down plugin 'CSV'
2017-11-06T14:06:16.248122Z 0 [Note] Shutting down plugin 'MyISAM'
2017-11-06T14:06:16.248136Z 0 [Note] Shutting down plugin 'sha256_password'
2017-11-06T14:06:16.248154Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-11-06T14:06:16.346353Z 0 [Note] Shutting down plugin 'binlog'
2017-11-06T14:06:16.347343Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-11-06T14:06:54.097254Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-11-06T14:06:54.097346Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-11-06T14:06:54.574721Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-11-06T14:06:54.951195Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.20-0ubuntu0.16.04.1) starting as process 1081 ...
2017-11-06T14:06:55.684752Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-11-06T14:06:55.684791Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-06T14:06:55.684804Z 0 [Note] InnoDB: Uses event mutexes
2017-11-06T14:06:55.684814Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-11-06T14:06:55.684824Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-11-06T14:06:55.684834Z 0 [Note] InnoDB: Using Linux native AIO
2017-11-06T14:06:55.778823Z 0 [Note] InnoDB: Number of pools: 1
2017-11-06T14:06:55.884620Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-11-06T14:06:55.887014Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-06T14:06:55.946586Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-11-06T14:06:55.950505Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-11-06T14:06:56.206200Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-11-06T14:06:59.540502Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-06T14:06:59.540615Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-06T14:07:00.033245Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-11-06T14:07:00.034594Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-11-06T14:07:00.034615Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-11-06T14:07:00.036064Z 0 [Note] InnoDB: Waiting for purge to start
2017-11-06T14:07:00.086249Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4136ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2017-11-06T14:07:00.086296Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 36332790
2017-11-06T14:07:00.088523Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-06T14:07:00.088658Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-11-06T14:07:01.565737Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-11-06T14:07:01.565778Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-11-06T14:07:01.565795Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2017-11-06T14:07:01.565841Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-11-06T14:07:04.612032Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171106 19:37:04
2017-11-06T14:07:05.583986Z 0 [Note] Event Scheduler: Loaded 0 events
2017-11-06T14:07:05.584272Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.20-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2017-11-06T14:07:05.584292Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-11-06T14:07:05.584300Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-11-06T14:07:11.781213Z 0 [Note] End of list of non-natively partitioned tables
2017-11-06T14:07:11.783094Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-11-06T15:00:18.236949Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 2853096ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment