Skip to content

Instantly share code, notes, and snippets.

@azizur
Created March 30, 2017 22:26
Show Gist options
  • Select an option

  • Save azizur/2106ba15973ad9ed6d1ee137fc6a8fb0 to your computer and use it in GitHub Desktop.

Select an option

Save azizur/2106ba15973ad9ed6d1ee137fc6a8fb0 to your computer and use it in GitHub Desktop.

Revisions

  1. azizur created this gist Mar 30, 2017.
    228 changes: 228 additions & 0 deletions docker logs edx.devstack.mysql
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,228 @@
    $ docker logs edx.devstack.mysql
    Initializing database
    2017-03-30 20:23:26 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
    2017-03-30 20:23:26 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 43 ...
    2017-03-30 20:23:26 43 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2017-03-30 20:23:26 43 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-03-30 20:23:26 43 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2017-03-30 20:23:26 43 [Note] InnoDB: Memory barrier is not used
    2017-03-30 20:23:26 43 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2017-03-30 20:23:26 43 [Note] InnoDB: Using Linux native AIO
    2017-03-30 20:23:26 43 [Note] InnoDB: Using CPU crc32 instructions
    2017-03-30 20:23:26 43 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2017-03-30 20:23:26 43 [Note] InnoDB: Completed initialization of buffer pool
    2017-03-30 20:23:26 43 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
    2017-03-30 20:23:26 43 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
    2017-03-30 20:23:26 43 [Note] InnoDB: Database physically writes the file full: wait...
    2017-03-30 20:23:26 43 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
    2017-03-30 20:23:26 43 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
    2017-03-30 20:23:26 43 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
    2017-03-30 20:23:26 43 [Warning] InnoDB: New log files created, LSN=45781
    2017-03-30 20:23:26 43 [Note] InnoDB: Doublewrite buffer not found: creating new
    2017-03-30 20:23:26 43 [Note] InnoDB: Doublewrite buffer created
    2017-03-30 20:23:26 43 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-03-30 20:23:26 43 [Warning] InnoDB: Creating foreign key constraint system tables.
    2017-03-30 20:23:26 43 [Note] InnoDB: Foreign key constraint system tables created
    2017-03-30 20:23:26 43 [Note] InnoDB: Creating tablespace and datafile system tables.
    2017-03-30 20:23:26 43 [Note] InnoDB: Tablespace and datafile system tables created.
    2017-03-30 20:23:26 43 [Note] InnoDB: Waiting for purge to start
    2017-03-30 20:23:26 43 [Note] InnoDB: 5.6.35 started; log sequence number 0
    2017-03-30 20:23:28 43 [Note] Binlog end
    2017-03-30 20:23:28 43 [Note] InnoDB: FTS optimize thread exiting.
    2017-03-30 20:23:28 43 [Note] InnoDB: Starting shutdown...
    2017-03-30 20:23:29 43 [Note] InnoDB: Shutdown completed; log sequence number 1625977


    2017-03-30 20:23:29 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
    2017-03-30 20:23:29 0 [Note] /usr/sbin/mysqld (mysqld 5.6.35) starting as process 84 ...
    2017-03-30 20:23:29 84 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2017-03-30 20:23:29 84 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-03-30 20:23:29 84 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2017-03-30 20:23:29 84 [Note] InnoDB: Memory barrier is not used
    2017-03-30 20:23:29 84 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2017-03-30 20:23:29 84 [Note] InnoDB: Using Linux native AIO
    2017-03-30 20:23:29 84 [Note] InnoDB: Using CPU crc32 instructions
    2017-03-30 20:23:29 84 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2017-03-30 20:23:29 84 [Note] InnoDB: Completed initialization of buffer pool
    2017-03-30 20:23:29 84 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-03-30 20:23:29 84 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-03-30 20:23:29 84 [Note] InnoDB: Waiting for purge to start
    2017-03-30 20:23:30 84 [Note] InnoDB: 5.6.35 started; log sequence number 1625977
    2017-03-30 20:23:30 84 [Note] Binlog end
    2017-03-30 20:23:30 84 [Note] InnoDB: FTS optimize thread exiting.
    2017-03-30 20:23:30 84 [Note] InnoDB: Starting shutdown...
    2017-03-30 20:23:31 84 [Note] InnoDB: Shutdown completed; log sequence number 1625987




    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:

    /usr/bin/mysqladmin -u root password 'new-password'
    /usr/bin/mysqladmin -u root -h cbc6ae5a7ba1 password 'new-password'

    Alternatively you can run:

    /usr/bin/mysql_secure_installation

    which will also give you the option of removing the test
    databases and anonymous user created by default. This is
    strongly recommended for production servers.

    See the manual for more instructions.

    Please report any problems at http://bugs.mysql.com/

    The latest information about MySQL is available on the web at

    http://www.mysql.com

    Support MySQL by buying support/licenses at http://shop.mysql.com

    Note: new default config file not created.
    Please make sure your config file is current

    WARNING: Default config file /etc/mysql/my.cnf exists on the system
    This file will be read by default by the MySQL server
    If you do not want to use this, either remove it, or use the
    --defaults-file argument to mysqld_safe when starting the server

    Database initialized
    MySQL init process in progress...
    2017-03-30 20:23:32 0 [Note] mysqld (mysqld 5.6.35) starting as process 119 ...
    2017-03-30 20:23:32 119 [Note] Plugin 'FEDERATED' is disabled.
    2017-03-30 20:23:32 119 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2017-03-30 20:23:32 119 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-03-30 20:23:32 119 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2017-03-30 20:23:32 119 [Note] InnoDB: Memory barrier is not used
    2017-03-30 20:23:32 119 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2017-03-30 20:23:32 119 [Note] InnoDB: Using Linux native AIO
    2017-03-30 20:23:32 119 [Note] InnoDB: Using CPU crc32 instructions
    2017-03-30 20:23:32 119 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2017-03-30 20:23:32 119 [Note] InnoDB: Completed initialization of buffer pool
    2017-03-30 20:23:32 119 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-03-30 20:23:32 119 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-03-30 20:23:32 119 [Note] InnoDB: Waiting for purge to start
    2017-03-30 20:23:32 119 [Note] InnoDB: 5.6.35 started; log sequence number 1625987
    2017-03-30 20:23:32 119 [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: be786782-1586-11e7-a48f-0242ac120002.
    2017-03-30 20:23:32 119 [Warning] 'user' entry 'root@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.
    2017-03-30 20:23:32 119 [Warning] 'user' entry '@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.
    2017-03-30 20:23:32 119 [Warning] 'proxies_priv' entry '@ root@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.
    2017-03-30 20:23:32 119 [Note] Event Scheduler: Loaded 0 events
    2017-03-30 20:23:32 119 [Note] mysqld: ready for connections.
    Version: '5.6.35' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
    Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
    Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
    Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
    2017-03-30 20:23:34 119 [Warning] 'proxies_priv' entry '@ root@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.

    2017-03-30 20:23:34 119 [Note] mysqld: Normal shutdown

    2017-03-30 20:23:34 119 [Note] Giving 0 client threads a chance to die gracefully
    2017-03-30 20:23:34 119 [Note] Event Scheduler: Purging the queue. 0 events
    2017-03-30 20:23:34 119 [Note] Shutting down slave threads
    2017-03-30 20:23:34 119 [Note] Forcefully disconnecting 0 remaining clients
    2017-03-30 20:23:34 119 [Note] Binlog end
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'partition'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_METRICS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_CMP'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_LOCKS'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'INNODB_TRX'
    2017-03-30 20:23:34 119 [Note] Shutting down plugin 'InnoDB'
    2017-03-30 20:23:34 119 [Note] InnoDB: FTS optimize thread exiting.
    2017-03-30 20:23:34 119 [Note] InnoDB: Starting shutdown...
    2017-03-30 20:23:36 119 [Note] InnoDB: Shutdown completed; log sequence number 1625997
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'BLACKHOLE'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'ARCHIVE'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'MRG_MYISAM'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'MyISAM'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'CSV'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'MEMORY'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'sha256_password'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'mysql_old_password'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'mysql_native_password'
    2017-03-30 20:23:36 119 [Note] Shutting down plugin 'binlog'
    2017-03-30 20:23:36 119 [Note] mysqld: Shutdown complete


    MySQL init process done. Ready for start up.

    2017-03-30 20:23:36 0 [Note] mysqld (mysqld 5.6.35) starting as process 1 ...
    2017-03-30 20:23:36 1 [Note] Plugin 'FEDERATED' is disabled.
    2017-03-30 20:23:36 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2017-03-30 20:23:36 1 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-03-30 20:23:36 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2017-03-30 20:23:36 1 [Note] InnoDB: Memory barrier is not used
    2017-03-30 20:23:36 1 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2017-03-30 20:23:36 1 [Note] InnoDB: Using Linux native AIO
    2017-03-30 20:23:36 1 [Note] InnoDB: Using CPU crc32 instructions
    2017-03-30 20:23:36 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2017-03-30 20:23:36 1 [Note] InnoDB: Completed initialization of buffer pool
    2017-03-30 20:23:36 1 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-03-30 20:23:36 1 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-03-30 20:23:36 1 [Note] InnoDB: Waiting for purge to start
    2017-03-30 20:23:36 1 [Note] InnoDB: 5.6.35 started; log sequence number 1625997
    2017-03-30 20:23:36 1 [Note] Server hostname (bind-address): '*'; port: 3306
    2017-03-30 20:23:36 1 [Note] IPv6 is available.
    2017-03-30 20:23:36 1 [Note] - '::' resolves to '::';
    2017-03-30 20:23:36 1 [Note] Server socket created on IP: '::'.
    2017-03-30 20:23:36 1 [Warning] 'proxies_priv' entry '@ root@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.
    2017-03-30 20:23:36 1 [Note] Event Scheduler: Loaded 0 events
    2017-03-30 20:23:36 1 [Note] mysqld: ready for connections.
    Version: '5.6.35' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
    2017-03-30 20:23:52 1 [Warning] 'proxies_priv' entry '@ root@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.
    2017-03-30 21:33:26 0 [Note] mysqld (mysqld 5.6.35) starting as process 1 ...
    2017-03-30 21:33:26 1 [Note] Plugin 'FEDERATED' is disabled.
    2017-03-30 21:33:26 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2017-03-30 21:33:26 1 [Note] InnoDB: The InnoDB memory heap is disabled
    2017-03-30 21:33:26 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2017-03-30 21:33:26 1 [Note] InnoDB: Memory barrier is not used
    2017-03-30 21:33:26 1 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2017-03-30 21:33:26 1 [Note] InnoDB: Using Linux native AIO
    2017-03-30 21:33:26 1 [Note] InnoDB: Using CPU crc32 instructions
    2017-03-30 21:33:26 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2017-03-30 21:33:26 1 [Note] InnoDB: Completed initialization of buffer pool
    2017-03-30 21:33:26 1 [Note] InnoDB: Highest supported file format is Barracuda.
    2017-03-30 21:33:26 1 [Note] InnoDB: The log sequence numbers 1625997 and 1625997 in ibdata files do not match the log sequence number 23212690 in the ib_logfiles!
    2017-03-30 21:33:26 1 [Note] InnoDB: Database was not shutdown normally!
    2017-03-30 21:33:26 1 [Note] InnoDB: Starting crash recovery.
    2017-03-30 21:33:26 1 [Note] InnoDB: Reading tablespace information from the .ibd files...
    2017-03-30 21:33:27 1 [Note] InnoDB: Restoring possible half-written data pages
    2017-03-30 21:33:27 1 [Note] InnoDB: from the doublewrite buffer...
    2017-03-30 21:33:27 1 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-03-30 21:33:27 1 [Note] InnoDB: Waiting for purge to start
    2017-03-30 21:33:27 1 [Note] InnoDB: 5.6.35 started; log sequence number 23212690
    2017-03-30 21:33:27 1 [Note] Server hostname (bind-address): '*'; port: 3306
    2017-03-30 21:33:27 1 [Note] IPv6 is available.
    2017-03-30 21:33:27 1 [Note] - '::' resolves to '::';
    2017-03-30 21:33:27 1 [Note] Server socket created on IP: '::'.
    2017-03-30 21:33:27 1 [Warning] 'proxies_priv' entry '@ root@cbc6ae5a7ba1' ignored in --skip-name-resolve mode.
    2017-03-30 21:33:27 1 [Note] Event Scheduler: Loaded 0 events
    2017-03-30 21:33:27 1 [Note] mysqld: ready for connections.
    Version: '5.6.35' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)