Bug #77586 mysqld --initialize --skip-performance-schema fails
| Submitted: | 1 Jul 2015 16:56 | Modified: | 1 Jul 2015 20:06 |
|---|---|---|---|
| Reporter: | Axel Schwenke | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 5.7.7 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any |
[1 Jul 2015 16:56]
Axel Schwenke
[1 Jul 2015 18:20]
MySQL Verification Team
Not repeatable on Windows with 5.7.8 source build: c:\dbs\5.7>rd data /s data, Are you sure (Y/N)? y c:\dbs\5.7>dir data Volume in drive C has no label. Volume Serial Number is 484B-43B0 Directory of c:\dbs\5.7 File Not Found c:\dbs\5.7>type my.ini [mysqld] basedir=c:\dbs\5.7 datadir=c:\dbs\5.7\data performance-schema= false c:\dbs\5.7>bin\mysqld --defaults-file=c:\dbs\5.7\my.ini --initialize 2015-07-01T18:18:13.087232Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp s c:\dbs\5.7>bin\mysqld --version bin\mysqld Ver 5.7.8-rc for Win64 on x86_64 (Source distribution PULL 2015/06/05) c:\dbs\5.7>dir data\performance_schema Volume in drive C has no label. Volume Serial Number is 484B-43B0 Directory of c:\dbs\5.7\data\performance_schema 07/01/2015 03:18 PM <DIR> . 07/01/2015 03:18 PM <DIR> .. 07/01/2015 03:18 PM 8,706 accounts.frm 07/01/2015 03:18 PM 8,624 cond_instances.frm 07/01/2015 03:18 PM 61 db.opt 07/01/2015 03:18 PM 9,103 events_stages_current.frm 07/01/2015 03:18 PM 9,103 events_stages_history.frm 07/01/2015 03:18 PM 9,103 events_stages_history_long.frm 07/01/2015 03:18 PM 8,874 events_stages_summary_by_account_by_event_name.frm 07/01/2015 03:18 PM 8,844 events_stages_summary_by_host_by_event_name.frm 07/01/2015 03:18 PM 8,854 events_stages_summary_by_thread_by_event_name.frm 07/01/2015 03:18 PM 8,844 events_stages_summary_by_user_by_event_name.frm 07/01/2015 03:18 PM 8,814 events_stages_summary_global_by_event_name.frm 07/01/2015 03:18 PM 10,597 events_statements_current.frm 07/01/2015 03:18 PM 10,597 events_statements_history.frm 07/01/2015 03:18 PM 10,597 events_statements_history_long.frm 07/01/2015 03:18 PM 10,000 events_statements_summary_by_account_by_event_name.frm 07/01/2015 03:18 PM 10,102 events_statements_summary_by_digest.frm 07/01/2015 03:18 PM 9,970 events_statements_summary_by_host_by_event_name.frm 07/01/2015 03:18 PM 10,369 events_statements_summary_by_program.frm 07/01/2015 03:18 PM 9,980 events_statements_summary_by_thread_by_event_name.frm 07/01/2015 03:18 PM 9,970 events_statements_summary_by_user_by_event_name.frm 07/01/2015 03:18 PM 9,940 events_statements_summary_global_by_event_name.frm <CUT>
[1 Jul 2015 18:30]
MySQL Verification Team
On Windows the released version 5.7.7 fails how to reported:
c:\tmp>cd mysql-5.7.7-rc-winx64
c:\tmp\mysql-5.7.7-rc-winx64>bin\mysqld --performance-schema = false --initialize
2015-07-01T18:24:54.686592Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see docume
c:\tmp\mysql-5.7.7-rc-winx64>dir data
Volume in drive C has no label.
Volume Serial Number is 484B-43B0
Directory of c:\tmp\mysql-5.7.7-rc-winx64\data
07/01/2015 03:24 PM <DIR> .
07/01/2015 03:24 PM <DIR> ..
07/01/2015 03:24 PM 12,582,912 ibdata1
07/01/2015 03:24 PM 246 ib_buffer_pool
07/01/2015 03:24 PM 50,331,648 ib_logfile0
07/01/2015 03:24 PM 50,331,648 ib_logfile1
07/01/2015 03:24 PM 308 tikal.err
5 File(s) 113,246,762 bytes
2 Dir(s) 1,361,790,521,344 bytes free
c:\tmp\mysql-5.7.7-rc-winx64>rd data /s
data, Are you sure (Y/N)? y
c:\tmp\mysql-5.7.7-rc-winx64>bin\mysqld --initialize
2015-07-01T18:26:49.519582Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see docume
c:\tmp\mysql-5.7.7-rc-winx64>dir data
Volume in drive C has no label.
Volume Serial Number is 484B-43B0
Directory of c:\tmp\mysql-5.7.7-rc-winx64\data
07/01/2015 03:27 PM <DIR> .
07/01/2015 03:27 PM <DIR> ..
07/01/2015 03:27 PM 12,582,912 ibdata1
07/01/2015 03:27 PM 485 ib_buffer_pool
07/01/2015 03:27 PM 50,331,648 ib_logfile0
07/01/2015 03:26 PM 50,331,648 ib_logfile1
07/01/2015 03:26 PM <DIR> mysql
07/01/2015 03:26 PM <DIR> performance_schema
07/01/2015 03:27 PM <DIR> sys
07/01/2015 03:27 PM 461 tikal.err
5 File(s) 113,247,154 bytes
5 Dir(s) 1,361,776,447,488 bytes free
c:\tmp\mysql-5.7.7-rc-winx64>dir data\performance_schema
Volume in drive C has no label.
Volume Serial Number is 484B-43B0
Directory of c:\tmp\mysql-5.7.7-rc-winx64\data\performance_schema
07/01/2015 03:26 PM <DIR> .
07/01/2015 03:26 PM <DIR> ..
07/01/2015 03:26 PM 8,706 accounts.frm
07/01/2015 03:26 PM 8,624 cond_instances.frm
07/01/2015 03:26 PM 61 db.opt
07/01/2015 03:26 PM 9,103 events_stages_current.frm
07/01/2015 03:26 PM 9,103 events_stages_history.frm
07/01/2015 03:26 PM 9,103 events_stages_history_long.frm
07/01/2015 03:26 PM 8,874 events_stages_summary_by_account_by_event_name.frm
07/01/2015 03:26 PM 8,844 events_stages_summary_by_host_by_event_name.frm
07/01/2015 03:26 PM 8,854 events_stages_summary_by_thread_by_event_name.frm
07/01/2015 03:26 PM 8,844 events_stages_summary_by_user_by_event_name.frm
07/01/2015 03:26 PM 8,814 events_stages_summary_global_by_event_name.frm
07/01/2015 03:26 PM 10,597 events_statements_current.frm
07/01/2015 03:26 PM 10,597 events_statements_history.frm
07/01/2015 03:26 PM 10,597 events_statements_history_long.frm
07/01/2015 03:26 PM 10,000 events_statements_summary_by_account_by_event_name.frm
07/01/2015 03:26 PM 10,102 events_statements_summary_by_digest.frm
So already fixed in source.
[1 Jul 2015 19:28]
Axel Schwenke
Hi Miguel, nice to read you :) If this is fixed in upcoming 5.7.8 then ok to close this report.
[1 Jul 2015 20:06]
MySQL Verification Team
Closing since same behavior as Windows observed on Linux Centos 6.5. Thank you for the bug report.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.