Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

performance_schema DBs not being created in docker-compose #115

Closed
sparrc opened this issue Oct 27, 2015 · 1 comment
Closed

performance_schema DBs not being created in docker-compose #115

sparrc opened this issue Oct 27, 2015 · 1 comment

Comments

@sparrc
Copy link

sparrc commented Oct 27, 2015

Hello, I'm trying to run the mysql docker container via docker-compose. The MySQL container starts but I'm getting errors creating the performance_schema DBs.

As you can see from the output below, the container is up and running but I don't get the performance_schema DBs, which I need for my app.

I'm not sure if this is an upgrade caching issue, I tried recreating my docker-machine but it didn't help (I'm on OSX)

This is my docker-compose file:

mysql:
    image: mysql
    ports:
        - "3306:3306"
    environment:
        MYSQL_ALLOW_EMPTY_PASSWORD: yes

and this is my docker-compose command:

$ docker-compose --file scripts/docker-compose.yml up mysql

Which gives me the following output.

$ docker logs scripts_mysql_1
2015-10-27T20:35:58.589538Z 0 [Note] mysqld (mysqld 5.7.9) starting as process 1 ...
2015-10-27T20:35:58.601063Z 0 [Note] InnoDB: PUNCH HOLE support available
2015-10-27T20:35:58.601109Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-10-27T20:35:58.601384Z 0 [Note] InnoDB: Uses event mutexes
2015-10-27T20:35:58.601407Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2015-10-27T20:35:58.601422Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-10-27T20:35:58.601434Z 0 [Note] InnoDB: Using Linux native AIO
2015-10-27T20:35:58.601680Z 0 [Note] InnoDB: Number of pools: 1
2015-10-27T20:35:58.603937Z 0 [Note] InnoDB: Using CPU crc32 instructions
2015-10-27T20:35:58.627514Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2015-10-27T20:35:58.651439Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-10-27T20:35:58.662437Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2015-10-27T20:35:58.679629Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-10-27T20:35:58.716253Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-10-27T20:35:58.717142Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2015-10-27T20:35:58.754652Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2015-10-27T20:35:58.758061Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-10-27T20:35:58.758631Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-10-27T20:35:58.761346Z 0 [Note] InnoDB: Waiting for purge to start
2015-10-27T20:35:58.816177Z 0 [Note] InnoDB: 5.7.9 started; log sequence number 1629588
2015-10-27T20:35:58.817318Z 0 [Note] Plugin 'FEDERATED' is disabled.
2015-10-27T20:35:58.817493Z 0 [Note] InnoDB: not started
2015-10-27T20:35:58.817582Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2015-10-27T20:35:58.818054Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151027 20:35:58
2015-10-27T20:35:58.818682Z 0 [Warning] System table 'plugin' is expected to be transactional.
2015-10-27T20:35:58.822220Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2015-10-27T20:35:58.822304Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-10-27T20:35:58.822332Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2015-10-27T20:35:58.822365Z 0 [Note] IPv6 is available.
2015-10-27T20:35:58.822382Z 0 [Note]   - '::' resolves to '::';
2015-10-27T20:35:58.822395Z 0 [Note] Server socket created on IP: '::'.
2015-10-27T20:35:58.823241Z 0 [Warning] Failed to open optimizer cost constant tables

2015-10-27T20:35:58.824387Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2015-10-27T20:35:58.824408Z 0 [Warning] 'proxies_priv' entry '@ root@7603692824bf' ignored in --skip-name-resolve mode.
2015-10-27T20:35:58.825383Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2015-10-27T20:35:58.825404Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2015-10-27T20:35:58.825429Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2015-10-27T20:35:58.825440Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2015-10-27T20:35:58.825450Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2015-10-27T20:35:58.826234Z 0 [Warning] System table 'servers' is expected to be transactional.
2015-10-27T20:35:58.826722Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2015-10-27T20:35:58.826841Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2015-10-27T20:35:58.826970Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2015-10-27T20:35:58.827405Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.827516Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.828505Z 0 [ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.828858Z 0 [ERROR] Incorrect definition of table performance_schema.setup_objects: expected column 'OBJECT_TYPE' at position 0 to have type enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER', found type enum('TABLE').
2015-10-27T20:35:58.829377Z 0 [ERROR] Column count of performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68, found 73. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.829546Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.829665Z 0 [ERROR] Column count of performance_schema.events_stages_current is wrong. Expected 12, found 10. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.829796Z 0 [ERROR] Column count of performance_schema.events_stages_history is wrong. Expected 12, found 10. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.829921Z 0 [ERROR] Column count of performance_schema.events_stages_history_long is wrong. Expected 12, found 10. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.830192Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.830312Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.830691Z 0 [ERROR] Column count of performance_schema.events_statements_current is wrong. Expected 41, found 40. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.832532Z 0 [ERROR] Column count of performance_schema.events_statements_history is wrong. Expected 41, found 40. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.833393Z 0 [ERROR] Column count of performance_schema.events_statements_history_long is wrong. Expected 41, found 40. Created with MySQL 50626, now running 50709. Please use mysql_upgrade to fix this error.
2015-10-27T20:35:58.833670Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.833822Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.834207Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
2015-10-27T20:35:58.834243Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
2015-10-27T20:35:58.834283Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
2015-10-27T20:35:58.834313Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
2015-10-27T20:35:58.834344Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
2015-10-27T20:35:58.834375Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
2015-10-27T20:35:58.834407Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
2015-10-27T20:35:58.834436Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
2015-10-27T20:35:58.834466Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
2015-10-27T20:35:58.834593Z 0 [ERROR] Incorrect definition of table performance_schema.users: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.834722Z 0 [ERROR] Incorrect definition of table performance_schema.accounts: expected column 'USER' at position 0 to have type char(32), found type char(16).
2015-10-27T20:35:58.837752Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
2015-10-27T20:35:58.837792Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
2015-10-27T20:35:58.837830Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
2015-10-27T20:35:58.837860Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
2015-10-27T20:35:58.837894Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
2015-10-27T20:35:58.837924Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
2015-10-27T20:35:58.837957Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
2015-10-27T20:35:58.837989Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
2015-10-27T20:35:58.838017Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
2015-10-27T20:35:58.838047Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
2015-10-27T20:35:58.838081Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
2015-10-27T20:35:58.838112Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
2015-10-27T20:35:58.838141Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
2015-10-27T20:35:58.838169Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
2015-10-27T20:35:58.838230Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
2015-10-27T20:35:58.838264Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
2015-10-27T20:35:58.838297Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
2015-10-27T20:35:58.838326Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
2015-10-27T20:35:58.838354Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
2015-10-27T20:35:58.838382Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2015-10-27T20:35:58.838412Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2015-10-27T20:35:58.838441Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2015-10-27T20:35:58.838473Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2015-10-27T20:35:58.838500Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2015-10-27T20:35:58.838530Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2015-10-27T20:35:58.838559Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2015-10-27T20:35:58.838626Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16).
2015-10-27T20:35:58.838653Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
2015-10-27T20:35:58.838938Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2015-10-27T20:35:58.839006Z 0 [Note] mysqld: ready for connections.
Version: '5.7.9'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
@sparrc
Copy link
Author

sparrc commented Oct 27, 2015

nevermind, this seems to be a problem specific to docker-compose, I'm going to open an issue there instead

@sparrc sparrc closed this as completed Oct 27, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@sparrc