Skip to content

Instantly share code, notes, and snippets.

@jmkgreen

jmkgreen/mysql.log

Created August 3, 2017 09:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jmkgreen/75b99fe98cf1d16a99895e78dae47cce to your computer and use it in GitHub Desktop.
Save jmkgreen/75b99fe98cf1d16a99895e78dae47cce to your computer and use it in GitHub Desktop.
Download ZIP
Keycloak MySQL log
Raw
mysql.log
jamesg@svc1:~/keycloak-stack$ docker service logs keycloak_mysql
keycloak_mysql.1.c2fclstg2s16@virt-a | Initializing database
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:37:54.059592Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:04.962645Z 0 [Warning] InnoDB: New log files created, LSN=45790
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:07.482795Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:07.804237Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 13207854-7827-11e7-9f18-02420a670705.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:08.383821Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:08.445021Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.668831Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.668879Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.668891Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.670155Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.670177Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.670752Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.672191Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:38:35.672773Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | Database initialized
keycloak_mysql.1.c2fclstg2s16@virt-a | Initializing certificates
keycloak_mysql.1.c2fclstg2s16@virt-a | Generating a 2048 bit RSA private key
keycloak_mysql.1.c2fclstg2s16@virt-a | ...........................................................................................+++
keycloak_mysql.1.c2fclstg2s16@virt-a | ........................+++
keycloak_mysql.1.c2fclstg2s16@virt-a | unable to write 'random state'
keycloak_mysql.1.c2fclstg2s16@virt-a | writing new private key to 'ca-key.pem'
keycloak_mysql.1.c2fclstg2s16@virt-a | -----
keycloak_mysql.1.c2fclstg2s16@virt-a | Generating a 2048 bit RSA private key
keycloak_mysql.1.c2fclstg2s16@virt-a | ..................................................................+++
keycloak_mysql.1.c2fclstg2s16@virt-a | ............................................+++
keycloak_mysql.1.c2fclstg2s16@virt-a | unable to write 'random state'
keycloak_mysql.1.c2fclstg2s16@virt-a | writing new private key to 'server-key.pem'
keycloak_mysql.1.c2fclstg2s16@virt-a | -----
keycloak_mysql.1.c2fclstg2s16@virt-a | Generating a 2048 bit RSA private key
keycloak_mysql.1.c2fclstg2s16@virt-a | ...........................................................................................................................................................................................................................+++
keycloak_mysql.1.c2fclstg2s16@virt-a | .......................................................................+++
keycloak_mysql.1.c2fclstg2s16@virt-a | unable to write 'random state'
keycloak_mysql.1.c2fclstg2s16@virt-a | writing new private key to 'client-key.pem'
keycloak_mysql.1.c2fclstg2s16@virt-a | -----
keycloak_mysql.1.c2fclstg2s16@virt-a | Certificates initialized
keycloak_mysql.1.c2fclstg2s16@virt-a | MySQL init process in progress...
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.514832Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.544748Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 90 ...
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627028Z 0 [Note] InnoDB: PUNCH HOLE support available
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627055Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627062Z 0 [Note] InnoDB: Uses event mutexes
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627070Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627078Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627085Z 0 [Note] InnoDB: Using Linux native AIO
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627463Z 0 [Note] InnoDB: Number of pools: 1
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.627612Z 0 [Note] InnoDB: Using CPU crc32 instructions
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.629443Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.641822Z 0 [Note] InnoDB: Completed initialization of buffer pool
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.643573Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:03.782877Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:04.239855Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:04.251381Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
keycloak_mysql.1.c2fclstg2s16@virt-a | MySQL init process in progress...
keycloak_mysql.1.c2fclstg2s16@virt-a | MySQL init process in progress...
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.138197Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.148206Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.148226Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.150609Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2543799
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.151040Z 0 [Note] Plugin 'FEDERATED' is disabled.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.152951Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.337730Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.339022Z 0 [Warning] CA certificate ca.pem is self signed.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.363129Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170803 8:39:06
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.448828Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.448868Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.448887Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.449019Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.449038Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.449071Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.566715Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.566893Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.942346Z 0 [Note] Event Scheduler: Loaded 0 events
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.942580Z 0 [Note] mysqld: ready for connections.
keycloak_mysql.1.c2fclstg2s16@virt-a | Version: '5.7.19' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.942595Z 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.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:06.942599Z 0 [Note] Beginning of list of non-natively partitioned tables
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:07.564441Z 0 [Note] End of list of non-natively partitioned tables
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:12.206830Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4058ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
keycloak_mysql.1.c2fclstg2s16@virt-a | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
keycloak_mysql.1.c2fclstg2s16@virt-a | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:33.611007Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9107ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
keycloak_mysql.1.c2fclstg2s16@virt-a | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980815Z 5 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980868Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980895Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980906Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980919Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980972Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:35.980987Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | mysql: [Warning] Using a password on the command line interface can be insecure.
keycloak_mysql.1.c2fclstg2s16@virt-a | mysql: [Warning] Using a password on the command line interface can be insecure.
keycloak_mysql.1.c2fclstg2s16@virt-a | mysql: [Warning] Using a password on the command line interface can be insecure.
keycloak_mysql.1.c2fclstg2s16@virt-a | mysql: [Warning] Using a password on the command line interface can be insecure.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.079939Z 9 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.079981Z 9 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.080788Z 9 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.080801Z 9 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.080822Z 9 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.088040Z 9 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.088064Z 9 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a |
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.090672Z 0 [Note] Giving 0 client threads a chance to die gracefully
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.090693Z 0 [Note] Shutting down slave threads
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.090697Z 0 [Note] Forcefully disconnecting 0 remaining clients
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.090702Z 0 [Note] Event Scheduler: Purging the queue. 0 events
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.090754Z 0 [Note] Binlog end
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109919Z 0 [Note] Shutting down plugin 'ngram'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109934Z 0 [Note] Shutting down plugin 'ARCHIVE'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109941Z 0 [Note] Shutting down plugin 'partition'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109946Z 0 [Note] Shutting down plugin 'BLACKHOLE'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109953Z 0 [Note] Shutting down plugin 'MyISAM'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109965Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109973Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109983Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.109992Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110009Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110014Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110019Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110027Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110032Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110037Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110045Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110050Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110056Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110063Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110070Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110078Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110084Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110089Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110097Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110102Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110107Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110111Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110119Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110125Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110132Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110137Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110143Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110148Z 0 [Note] Shutting down plugin 'INNODB_CMP'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110154Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110159Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110168Z 0 [Note] Shutting down plugin 'INNODB_TRX'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110174Z 0 [Note] Shutting down plugin 'InnoDB'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110227Z 0 [Note] InnoDB: FTS optimize thread exiting.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.110287Z 0 [Note] InnoDB: Starting shutdown...
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.214334Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:36.244230Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170803 8:39:36
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.921053Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12148587
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934326Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934351Z 0 [Note] Shutting down plugin 'CSV'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934361Z 0 [Note] Shutting down plugin 'MEMORY'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934366Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934401Z 0 [Note] Shutting down plugin 'sha256_password'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934412Z 0 [Note] Shutting down plugin 'mysql_native_password'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.934618Z 0 [Note] Shutting down plugin 'binlog'
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:39.935322Z 0 [Note] mysqld: Shutdown complete
keycloak_mysql.1.c2fclstg2s16@virt-a |
keycloak_mysql.1.c2fclstg2s16@virt-a |
keycloak_mysql.1.c2fclstg2s16@virt-a | MySQL init process done. Ready for start up.
keycloak_mysql.1.c2fclstg2s16@virt-a |
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.122479Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.220868Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 1 ...
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515326Z 0 [Note] InnoDB: PUNCH HOLE support available
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515359Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515366Z 0 [Note] InnoDB: Uses event mutexes
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515371Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515379Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515387Z 0 [Note] InnoDB: Using Linux native AIO
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515680Z 0 [Note] InnoDB: Number of pools: 1
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.515785Z 0 [Note] InnoDB: Using CPU crc32 instructions
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.517502Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.527411Z 0 [Note] InnoDB: Completed initialization of buffer pool
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.529271Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:40.719939Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.211745Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.224344Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.814669Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.820710Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.820733Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.821502Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 12148587
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.822137Z 0 [Note] Plugin 'FEDERATED' is disabled.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.831146Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.973659Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.974960Z 0 [Warning] CA certificate ca.pem is self signed.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.977337Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.977375Z 0 [Note] IPv6 is available.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.977392Z 0 [Note] - '::' resolves to '::';
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:41.977420Z 0 [Note] Server socket created on IP: '::'.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.083525Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.083573Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.083601Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.083609Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.083621Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.340017Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.340050Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:42.606853Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170803 8:39:42
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:43.013023Z 0 [Note] Event Scheduler: Loaded 0 events
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:43.013485Z 0 [Note] mysqld: ready for connections.
keycloak_mysql.1.c2fclstg2s16@virt-a | Version: '5.7.19' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:43.013504Z 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.
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:43.013508Z 0 [Note] Beginning of list of non-natively partitioned tables
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:39:43.552762Z 0 [Note] End of list of non-natively partitioned tables
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:40:07.575864Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7752ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:43:17.834707Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4078ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:43:52.596874Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4226ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:44:57.281635Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5370ms. The settings might not be optimal. (flushed=142 and evicted=0, during the time.)
keycloak_mysql.1.c2fclstg2s16@virt-a | 2017-08-03T08:45:04.589052Z 4 [Note] Aborted connection 4 to db: 'keycloak' user: 'keycloak' host: '10.103.7.3' (Got an error reading communication packets)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment