Percona Server moved to https://jira.percona.com/projects/PS

mysql_install_db not working properly with percona server

Bug #1170024 reported by Jay Janssen on 2013-04-17

This bug affects 5 people

	Status	Importance	Assigned to	Milestone
Percona Server moved to https://jira.percona.com/projects/PS	Invalid	Undecided	Unassigned
5.1	Invalid	Undecided	Unassigned
5.5	Fix Released	Critical	Alexey Bychko	Percona Server moved to https://jira.percona.com/projects/PS 5.5.30-30.2
5.6	Invalid	Undecided	Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC	Fix Released	Critical	Alexey Bychko	Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC 5.5.30-23.7.4-2

Bug Description

I am installing Percona server on a clean Centos 6.4 VM that is i686 with yum from the Percona apt repo:

Running Transaction
  Installing : Percona-Server-shared-55-5.5.30-rel30.2.500.rhel6.i686 1/9
  Installing : 1:perl-Pod-Escapes-1.04-130.el6_4.i686 2/9
  Installing : 3:perl-version-0.77-130.el6_4.i686 3/9
  Installing : 1:perl-Module-Pluggable-3.90-130.el6_4.i686 4/9
  Installing : 4:perl-libs-5.10.1-130.el6_4.i686 5/9
  Installing : 1:perl-Pod-Simple-3.13-130.el6_4.i686 6/9
  Installing : 4:perl-5.10.1-130.el6_4.i686 7/9
  Installing : Percona-Server-client-55-5.5.30-rel30.2.500.rhel6.i686 8/9
  Installing : Percona-Server-server-55-5.5.30-rel30.2.500.rhel6.i686 9/9
chown: invalid user: `mysql'
Cannot change ownership of the database directories to the 'mysql'
user. Check that you have the necessary permissions and try again.
Percona Server is distributed with several useful UDF (User Defined Function) from Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more details
  Verifying : 1:perl-Pod-Escapes-1.04-130.el6_4.i686 1/9
  Verifying : Percona-Server-shared-55-5.5.30-rel30.2.500.rhel6.i686 2/9
  Verifying : 3:perl-version-0.77-130.el6_4.i686 3/9
  Verifying : 1:perl-Module-Pluggable-3.90-130.el6_4.i686 4/9
  Verifying : Percona-Server-server-55-5.5.30-rel30.2.500.rhel6.i686 5/9
  Verifying : Percona-Server-client-55-5.5.30-rel30.2.500.rhel6.i686 6/9
  Verifying : 1:perl-Pod-Simple-3.13-130.el6_4.i686 7/9
  Verifying : 4:perl-libs-5.10.1-130.el6_4.i686 8/9
  Verifying : 4:perl-5.10.1-130.el6_4.i686 9/9

Installed:
Percona-Server-server-55.i686 0:5.5.30-rel30.2.500.rhel6

I get an error when I try to start mysql, because /var/lib/mysql/mysql does not have any system tables in it. I'm guessing the mysql_install_db failed here. Can anyone confirm this?

Tags:

Related branches

lp:~abychko/percona-server/bug1170024-5.5

Rejected for merging into lp:percona-server/5.5

Ignacio Nin (community): Disapprove on 2013-05-13

Laurynas Biveinis (community): Needs Information on 2013-04-18

lp:~raghavendra-prabhu/percona-xtradb-cluster/release-5.5.30 (Merged)

lp:~percona-core/percona-xtradb-cluster/release-5.5.30

Merged into lp:percona-xtradb-cluster/percona-xtradb-cluster-5.5 at revision 387

Ignacio Nin (community): Approve on 2013-04-24

Vadim Tkachenko: Pending requested 2013-04-24

Diff: 52455 lines (+21054/-18542)

438 files modified

Makefile (+2/-2)
Makefile.ps (+2/-2)
Percona-Server/.bzrignore (+2/-0)
Percona-Server/CMakeLists.txt (+2/-0)
Percona-Server/README (+1/-1)
Percona-Server/VERSION (+1/-1)
Percona-Server/client/mysql.cc (+14/-21)
Percona-Server/client/mysqlbinlog.cc (+4/-0)
Percona-Server/client/mysqldump.c (+163/-60)
Percona-Server/client/mysqltest.cc (+1/-1)
Percona-Server/cmake/wsrep.cmake (+1/-1)
Percona-Server/configure.cmake (+4/-3)
Percona-Server/extra/yassl/src/handshake.cpp (+7/-1)
Percona-Server/include/m_string.h (+40/-0)
Percona-Server/include/my_sys.h (+5/-0)
Percona-Server/include/mysql/service_my_snprintf.h (+1/-0)
Percona-Server/include/mysql/thread_pool_priv.h (+1/-0)
Percona-Server/include/mysql_com.h (+4/-0)
Percona-Server/include/violite.h (+14/-0)
Percona-Server/include/welcome_copyright_notice.h (+2/-2)
Percona-Server/mysql-test/CMakeLists.txt (+4/-2)
Percona-Server/mysql-test/collections/default.daily (+1/-1)
Percona-Server/mysql-test/collections/default.experimental (+0/-5)
Percona-Server/mysql-test/collections/default.push (+6/-5)
Percona-Server/mysql-test/collections/default.release.in (+4/-4)
Percona-Server/mysql-test/include/delete_innodb_bitmaps.inc (+0/-11)
Percona-Server/mysql-test/include/get_binlog_dump_thread_id.inc (+0/-22)
Percona-Server/mysql-test/include/have_pool_of_threads.inc (+4/-0)
Percona-Server/mysql-test/include/log_cleanup.inc (+1/-0)
Percona-Server/mysql-test/include/log_start.inc (+0/-16)
Percona-Server/mysql-test/include/log_stop.inc (+0/-7)
Percona-Server/mysql-test/include/mysqld--help.inc (+1/-1)
Percona-Server/mysql-test/include/not_threadpool.inc (+1/-1)
Percona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc (+0/-50)
Percona-Server/mysql-test/include/percona_slow_log_verbosity_grep.inc (+26/-0)
Percona-Server/mysql-test/include/percona_slow_query_log_rate.inc (+5/-10)
Percona-Server/mysql-test/include/query_response_time-replication.inc (+2/-1)
Percona-Server/mysql-test/lib/My/ConfigFactory.pm (+14/-2)
Percona-Server/mysql-test/lib/My/SafeProcess/CMakeLists.txt (+1/-1)
Percona-Server/mysql-test/lib/My/SafeProcess/safe_process.cc (+12/-8)
Percona-Server/mysql-test/lib/My/SafeProcess/safe_process.pl (+0/-166)
Percona-Server/mysql-test/lib/mtr_cases.pm (+5/-12)
Percona-Server/mysql-test/lib/mtr_report.pm (+11/-1)
Percona-Server/mysql-test/mysql-test-run.pl (+89/-64)
Percona-Server/mysql-test/r/aborted_clients.result (+10/-0)
Percona-Server/mysql-test/r/create_delayed.result (+3/-0)
Percona-Server/mysql-test/r/ddl_i18n_koi8r.result (+8/-8)
Percona-Server/mysql-test/r/ddl_i18n_utf8.result (+8/-8)
Percona-Server/mysql-test/r/group_min_max_innodb.result (+1/-1)
Percona-Server/mysql-test/r/have_pool_of_threads.require (+2/-0)
Percona-Server/mysql-test/r/mysqlbinlog.result (+32/-0)
Percona-Server/mysql-test/r/mysqld--help-notwin.result (+10/-3)
Percona-Server/mysql-test/r/mysqld--help-win.result (+8/-1)
Percona-Server/mysql-test/r/mysqldump.result (+86/-13)
Percona-Server/mysql-test/r/percona_bug1127008.result (+28/-0)
Percona-Server/mysql-test/r/percona_bug643149.result (+0/-21)
Percona-Server/mysql-test/r/percona_innodb_version.result (+1/-1)
Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result (+0/-35)
Percona-Server/mysql-test/r/percona_log_slow_filter.result (+0/-16)
Percona-Server/mysql-test/r/percona_log_slow_innodb.result (+42/-0)
Percona-Server/mysql-test/r/percona_log_slow_query_plan.result (+268/-0)
Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result (+46/-0)
Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result (+0/-19)
Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result (+0/-45)
Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result (+0/-25)
Percona-Server/mysql-test/r/percona_log_slow_verbosity.result (+0/-16)
Percona-Server/mysql-test/r/percona_long_query_time.result (+0/-33)
Percona-Server/mysql-test/r/percona_min_examined_row_limit.result (+1/-1)
Percona-Server/mysql-test/r/percona_mysqldump_innodb_optimize_keys.result (+83/-0)
Percona-Server/mysql-test/r/percona_server_variables_debug.result (+13/-1)
Percona-Server/mysql-test/r/percona_server_variables_release.result (+11/-1)
Percona-Server/mysql-test/r/percona_slow_extended_error_on_quit.result (+23/-168)
Percona-Server/mysql-test/r/percona_slow_extended_log_error.result (+0/-10)
Percona-Server/mysql-test/r/percona_slow_query_log_rate.result (+45/-69)
Percona-Server/mysql-test/r/percona_slow_query_log_timestamp_always.result (+0/-41)
Percona-Server/mysql-test/r/percona_slow_query_log_timestamp_precision.result (+0/-18)
Percona-Server/mysql-test/r/percona_slow_query_log_use_global_control.result (+0/-18)
Percona-Server/mysql-test/r/pool_of_threads.result (+2169/-0)
Percona-Server/mysql-test/r/pool_of_threads_high_prio_tickets.result (+2169/-0)
Percona-Server/mysql-test/r/select.result (+2/-2)
Percona-Server/mysql-test/r/user_var-binlog.result (+2/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_base64_flag.result (+2/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_mysqlbinlog2.result (+54/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_mysqlbinlog_row.result (+2/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_mysqlbinlog_row_innodb.result (+8/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_mysqlbinlog_row_myisam.result (+8/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_mysqlbinlog_row_trans.result (+2/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_row_ctype_ucs.result (+2/-0)
Percona-Server/mysql-test/suite/binlog/r/binlog_stm_ctype_ucs.result (+2/-0)
Percona-Server/mysql-test/suite/binlog/r/percona_bug1162085.result (+6/-0)
Percona-Server/mysql-test/suite/binlog/t/percona_bug1162085.test (+30/-0)
Percona-Server/mysql-test/suite/engines/funcs/r/rpl_row_until.result (+59/-211)
Percona-Server/mysql-test/suite/engines/funcs/t/disabled.def (+0/-2)
Percona-Server/mysql-test/suite/engines/funcs/t/rpl_row_until.test (+114/-78)
Percona-Server/mysql-test/suite/innodb/r/innodb-index.result (+1/-1)
Percona-Server/mysql-test/suite/innodb/r/innodb_bug14147491.result (+17/-0)
Percona-Server/mysql-test/suite/innodb/r/innodb_bug14676111.result (+53/-0)
Percona-Server/mysql-test/suite/innodb/r/innodb_mysql.result (+4/-4)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp.result (+14/-12)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_1105726.result (+3/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_crash.result (+35/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_debug.result (+24/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_flush.result (+19/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_log_block_size.result (+6/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_no_restart.result (+0/-7)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_requests.result (+76/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_page_bmp_requests_no_innodb.result (+3/-0)
Percona-Server/mysql-test/suite/innodb/r/percona_changed_pages.result (+4/-3)
Percona-Server/mysql-test/suite/innodb/r/percona_log_block_size.result (+10/-0)
Percona-Server/mysql-test/suite/innodb/t/innodb_bug14147491-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/innodb_bug14147491.test (+75/-0)
Percona-Server/mysql-test/suite/innodb/t/innodb_bug14676111.test (+128/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp-master.opt (+1/-1)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp.test (+57/-63)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_1105726-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_1105726.test (+5/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_crash-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_crash.test (+85/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_debug-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_debug.test (+57/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_flush.test (+93/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_log_block_size.test (+36/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_no_restart-master.opt (+0/-1)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_no_restart.test (+0/-29)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_requests-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_requests.test (+200/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_requests_no_innodb-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_page_bmp_requests_no_innodb.test (+7/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_changed_pages.test (+12/-10)
Percona-Server/mysql-test/suite/innodb/t/percona_log_block_size-master.opt (+1/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_log_block_size.test (+40/-0)
Percona-Server/mysql-test/suite/parts/r/partition_alter4_innodb.result (+24/-24)
Percona-Server/mysql-test/suite/perfschema/r/start_server_no_waits_history.result (+63/-0)
Percona-Server/mysql-test/suite/perfschema/r/start_server_no_waits_history_long.result (+63/-0)
Percona-Server/mysql-test/suite/perfschema/r/start_server_nothing.result (+122/-0)
Percona-Server/mysql-test/suite/perfschema/t/pool_of_threads-master.opt (+1/-1)
Percona-Server/mysql-test/suite/perfschema/t/start_server_no_waits_history-master.opt (+2/-0)
Percona-Server/mysql-test/suite/perfschema/t/start_server_no_waits_history.test (+14/-0)
Percona-Server/mysql-test/suite/perfschema/t/start_server_no_waits_history_long-master.opt (+2/-0)
Percona-Server/mysql-test/suite/perfschema/t/start_server_no_waits_history_long.test (+14/-0)
Percona-Server/mysql-test/suite/perfschema/t/start_server_nothing-master.opt (+19/-0)
Percona-Server/mysql-test/suite/perfschema/t/start_server_nothing.test (+30/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_bug31076.result (+2/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_bug68490.result (+8/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_mdev382.result (+4/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_percona_crash_resistant_rpl.result (+18/-9)
Percona-Server/mysql-test/suite/rpl/r/rpl_report_port.result (+2/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_rotate_logs.result (+11/-23)
Percona-Server/mysql-test/suite/rpl/r/rpl_row_mysqlbinlog.result (+10/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_sp.result (+2/-0)
Percona-Server/mysql-test/suite/rpl/r/rpl_trigger_bug67504.result (+28/-0)
Percona-Server/mysql-test/suite/rpl/t/disabled.def (+0/-1)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug31076.test (+2/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490-master.opt (+1/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490-slave.opt (+2/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_bug68490.test (+21/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_percona_crash_resistant_rpl.test (+33/-22)
Percona-Server/mysql-test/suite/rpl/t/rpl_report_port.test (+6/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_rotate_logs.test (+52/-7)
Percona-Server/mysql-test/suite/rpl/t/rpl_trigger_bug67504-slave.opt (+1/-0)
Percona-Server/mysql-test/suite/rpl/t/rpl_trigger_bug67504.test (+49/-0)
Percona-Server/mysql-test/suite/sys_vars/r/all_vars.result (+6/-6)
Percona-Server/mysql-test/suite/sys_vars/r/extra_max_connections_basic.result (+43/-0)
Percona-Server/mysql-test/suite/sys_vars/r/extra_port_basic.result (+21/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_limit_optimistic_insert_debug_basic.result (+58/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_print_all_deadlocks_basic.result (+22/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_trx_purge_view_update_only_debug_basic.result (+61/-0)
Percona-Server/mysql-test/suite/sys_vars/r/ndb_log_update_as_write_basic.result (+0/-14)
Percona-Server/mysql-test/suite/sys_vars/r/ndb_log_updated_only_basic.result (+0/-14)
Percona-Server/mysql-test/suite/sys_vars/r/pseudo_slave_mode_basic.result (+119/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_high_prio_tickets_basic.result (+47/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_idle_timeout_basic.result (+47/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_max_threads_basic.result (+47/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_min_threads_basic.result (+49/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_oversubscribe_basic.result (+47/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_size_basic.result (+41/-0)
Percona-Server/mysql-test/suite/sys_vars/r/thread_pool_stall_limit_basic.result (+47/-0)
Percona-Server/mysql-test/suite/sys_vars/t/extra_max_connections_basic.test (+42/-0)
Percona-Server/mysql-test/suite/sys_vars/t/extra_port_basic.test (+21/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_limit_optimistic_insert_debug_basic.test (+50/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_print_all_deadlocks_basic.test (+48/-0)
Percona-Server/mysql-test/suite/sys_vars/t/innodb_trx_purge_view_update_only_debug_basic.test (+53/-0)
Percona-Server/mysql-test/suite/sys_vars/t/ndb_log_update_as_write_basic.test (+0/-216)
Percona-Server/mysql-test/suite/sys_vars/t/ndb_log_updated_only_basic.test (+0/-216)
Percona-Server/mysql-test/suite/sys_vars/t/pseudo_slave_mode_basic.test (+168/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_cache_size_func.test (+1/-2)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_high_prio_tickets_basic.test (+43/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_idle_timeout_basic.test (+43/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_max_threads_basic.test (+42/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_min_threads_basic.test (+43/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_oversubscribe_basic.test (+43/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_size_basic.test (+47/-0)
Percona-Server/mysql-test/suite/sys_vars/t/thread_pool_stall_limit_basic.test (+43/-0)
Percona-Server/mysql-test/t/aborted_clients.test (+28/-0)
Percona-Server/mysql-test/t/create_delayed.test (+34/-0)
Percona-Server/mysql-test/t/disabled.def (+1/-0)
Percona-Server/mysql-test/t/mysqldump.test (+9/-3)
Percona-Server/mysql-test/t/percona_bug1127008.test (+28/-0)
Percona-Server/mysql-test/t/percona_innodb_version.test (+1/-1)
Percona-Server/mysql-test/t/percona_log_slow_admin_statements.test (+0/-20)
Percona-Server/mysql-test/t/percona_log_slow_filter.test (+0/-26)
Percona-Server/mysql-test/t/percona_log_slow_innodb.test (+82/-0)
Percona-Server/mysql-test/t/percona_log_slow_query_plan.test (+302/-0)
Percona-Server/mysql-test/t/percona_log_slow_query_plan_qc.test (+71/-0)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb-slave.opt (+0/-1)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb.test (+0/-42)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-slave.opt (+0/-1)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements.test (+0/-117)
Percona-Server/mysql-test/t/percona_log_slow_sp_statements.test (+0/-29)
Percona-Server/mysql-test/t/percona_log_slow_verbosity.test (+0/-19)
Percona-Server/mysql-test/t/percona_long_query_time.test (+0/-25)
Percona-Server/mysql-test/t/percona_min_examined_row_limit.test (+0/-35)
Percona-Server/mysql-test/t/percona_mysqldump_innodb_optimize_keys.test (+48/-0)
Percona-Server/mysql-test/t/percona_slow_extended_error_on_quit.test (+0/-87)
Percona-Server/mysql-test/t/percona_slow_extended_log_error.test (+0/-15)
Percona-Server/mysql-test/t/percona_slow_query_log_rate.test (+10/-3)
Percona-Server/mysql-test/t/percona_slow_query_log_timestamp_always.test (+0/-34)
Percona-Server/mysql-test/t/percona_slow_query_log_timestamp_precision.test (+0/-25)
Percona-Server/mysql-test/t/percona_slow_query_log_use_global_control.test (+0/-28)
Percona-Server/mysql-test/t/pool_of_threads.cnf (+15/-0)
Percona-Server/mysql-test/t/pool_of_threads.test (+80/-0)
Percona-Server/mysql-test/t/pool_of_threads_high_prio_tickets.cnf (+16/-0)
Percona-Server/mysql-test/t/pool_of_threads_high_prio_tickets.test (+19/-0)
Percona-Server/mysys/errors.c (+18/-6)
Percona-Server/mysys/mf_cache.c (+5/-3)
Percona-Server/mysys/mf_pack.c (+5/-4)
Percona-Server/mysys/my_access.c (+64/-0)
Percona-Server/mysys/my_error.c (+22/-0)
Percona-Server/mysys/my_lib.c (+6/-4)
Percona-Server/mysys/my_write.c (+4/-0)
Percona-Server/mysys/thr_lock.c (+5/-1)
Percona-Server/mysys/thr_rwlock.c (+1/-1)
Percona-Server/packaging/WiX/custom_ui.wxs (+2/-2)
Percona-Server/packaging/rpm-uln/mysql.spec.sh (+26/-11)
Percona-Server/patch_info/optimizer_fix.info (+0/-8)
Percona-Server/plugin/percona-pam-for-mysql/CMakeLists.txt (+5/-0)
Percona-Server/scripts/clustercheck.sh (+28/-16)
Percona-Server/scripts/fill_help_tables.sql (+2094/-9)
Percona-Server/scripts/mysqlchk.sh (+1/-1)
Percona-Server/scripts/mysqld_safe.sh (+36/-20)
Percona-Server/scripts/wsrep_sst_rsync.sh (+6/-5)
Percona-Server/scripts/wsrep_sst_xtrabackup.sh (+3/-11)
Percona-Server/sql-common/client.c (+3/-3)
Percona-Server/sql/CMakeLists.txt (+8/-1)
Percona-Server/sql/event_scheduler.cc (+0/-1)
Percona-Server/sql/field.cc (+4/-4)
Percona-Server/sql/filesort.cc (+4/-3)
Percona-Server/sql/ha_partition.cc (+20/-2)
Percona-Server/sql/handler.cc (+44/-18)
Percona-Server/sql/handler.h (+5/-0)
Percona-Server/sql/item_cmpfunc.cc (+11/-11)
Percona-Server/sql/item_func.cc (+21/-8)
Percona-Server/sql/item_func.h (+16/-2)
Percona-Server/sql/item_subselect.cc (+2/-1)
Percona-Server/sql/item_sum.cc (+9/-6)
Percona-Server/sql/item_xmlfunc.cc (+5/-1)
Percona-Server/sql/lex.h (+1/-0)
Percona-Server/sql/log.cc (+49/-23)
Percona-Server/sql/log_event.cc (+17/-6)
Percona-Server/sql/log_event.h (+16/-2)
Percona-Server/sql/mdl.cc (+5/-1)
Percona-Server/sql/mdl.h (+8/-2)
Percona-Server/sql/mysqld.cc (+314/-297)
Percona-Server/sql/mysqld.h (+5/-0)
Percona-Server/sql/net_serv.cc (+6/-2)
Percona-Server/sql/opt_range.cc (+5/-23)
Percona-Server/sql/protocol.cc (+1/-1)
Percona-Server/sql/rpl_utility.cc (+7/-2)
Percona-Server/sql/scheduler.cc (+41/-48)
Percona-Server/sql/scheduler.h (+18/-4)
Percona-Server/sql/signal_handler.cc (+5/-4)
Percona-Server/sql/slave.cc (+8/-9)
Percona-Server/sql/sql_admin.cc (+24/-4)
Percona-Server/sql/sql_base.cc (+133/-40)
Percona-Server/sql/sql_base.h (+28/-2)
Percona-Server/sql/sql_cache.cc (+15/-15)
Percona-Server/sql/sql_class.cc (+87/-88)
Percona-Server/sql/sql_class.h (+20/-22)
Percona-Server/sql/sql_client.cc (+1/-0)
Percona-Server/sql/sql_connect.cc (+19/-25)
Percona-Server/sql/sql_db.cc (+1/-1)
Percona-Server/sql/sql_insert.cc (+18/-1)
Percona-Server/sql/sql_parse.cc (+169/-90)
Percona-Server/sql/sql_prepare.cc (+45/-11)
Percona-Server/sql/sql_reload.cc (+16/-0)
Percona-Server/sql/sql_repl.cc (+4/-0)
Percona-Server/sql/sql_select.cc (+55/-31)
Percona-Server/sql/sql_select.h (+15/-1)
Percona-Server/sql/sql_table.cc (+132/-107)
Percona-Server/sql/sql_yacc.yy (+15/-2)
Percona-Server/sql/strfunc.cc (+1/-1)
Percona-Server/sql/sys_vars.cc (+199/-5)
Percona-Server/sql/threadpool.h (+72/-0)
Percona-Server/sql/threadpool_common.cc (+277/-0)
Percona-Server/sql/threadpool_unix.cc (+1691/-0)
Percona-Server/sql/threadpool_win.cc (+763/-0)
Percona-Server/sql/transaction.cc (+17/-3)
Percona-Server/sql/tztime.cc (+3/-18)
Percona-Server/sql/wsrep_hton.cc (+6/-0)
Percona-Server/sql/wsrep_sst.cc (+1/-1)
Percona-Server/sql/wsrep_utils.cc (+2/-4)
Percona-Server/storage/archive/ha_archive.cc (+7/-6)
Percona-Server/storage/heap/hp_delete.c (+14/-4)
Percona-Server/storage/innobase/btr/btr0btr.c (+50/-26)
Percona-Server/storage/innobase/btr/btr0cur.c (+59/-60)
Percona-Server/storage/innobase/btr/btr0pcur.c (+6/-7)
Percona-Server/storage/innobase/btr/btr0sea.c (+1/-4)
Percona-Server/storage/innobase/buf/buf0buf.c (+129/-183)
Percona-Server/storage/innobase/buf/buf0flu.c (+32/-17)
Percona-Server/storage/innobase/buf/buf0lru.c (+143/-80)
Percona-Server/storage/innobase/buf/buf0rea.c (+9/-9)
Percona-Server/storage/innobase/dict/dict0dict.c (+3/-3)
Percona-Server/storage/innobase/dict/dict0load.c (+2/-1)
Percona-Server/storage/innobase/fil/fil0fil.c (+90/-84)
Percona-Server/storage/innobase/fsp/fsp0fsp.c (+15/-30)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+256/-151)
Percona-Server/storage/innobase/handler/handler0alter.cc (+0/-2)
Percona-Server/storage/innobase/handler/i_s.cc (+4/-3)
Percona-Server/storage/innobase/ibuf/ibuf0ibuf.c (+1/-1)
Percona-Server/storage/innobase/include/btr0btr.ic (+1/-1)
Percona-Server/storage/innobase/include/btr0cur.h (+5/-0)
Percona-Server/storage/innobase/include/btr0cur.ic (+13/-0)
Percona-Server/storage/innobase/include/buf0buf.h (+46/-8)
Percona-Server/storage/innobase/include/buf0buf.ic (+35/-16)
Percona-Server/storage/innobase/include/buf0flu.ic (+1/-1)
Percona-Server/storage/innobase/include/buf0lru.h (+4/-8)
Percona-Server/storage/innobase/include/data0type.ic (+7/-25)
Percona-Server/storage/innobase/include/fil0fil.h (+15/-0)
Percona-Server/storage/innobase/include/fut0fut.ic (+1/-4)
Percona-Server/storage/innobase/include/lock0lock.h (+11/-3)
Percona-Server/storage/innobase/include/log0log.h (+12/-4)
Percona-Server/storage/innobase/include/log0log.ic (+19/-4)
Percona-Server/storage/innobase/include/log0online.h (+37/-9)
Percona-Server/storage/innobase/include/mtr0mtr.h (+2/-0)
Percona-Server/storage/innobase/include/mtr0mtr.ic (+21/-0)
Percona-Server/storage/innobase/include/os0file.h (+2/-0)
Percona-Server/storage/innobase/include/read0read.h (+24/-9)
Percona-Server/storage/innobase/include/read0read.ic (+18/-25)
Percona-Server/storage/innobase/include/rem0rec.h (+42/-38)
Percona-Server/storage/innobase/include/srv0srv.h (+42/-3)
Percona-Server/storage/innobase/include/sync0sync.h (+2/-0)
Percona-Server/storage/innobase/include/trx0purge.h (+5/-0)
Percona-Server/storage/innobase/include/trx0sys.h (+38/-0)
Percona-Server/storage/innobase/include/trx0sys.ic (+26/-20)
Percona-Server/storage/innobase/include/trx0trx.h (+39/-7)
Percona-Server/storage/innobase/include/trx0trx.ic (+4/-4)
Percona-Server/storage/innobase/include/univ.i (+9/-13)
Percona-Server/storage/innobase/lock/lock0lock.c (+245/-122)
Percona-Server/storage/innobase/log/log0log.c (+13/-6)
Percona-Server/storage/innobase/log/log0online.c (+255/-64)
Percona-Server/storage/innobase/log/log0recv.c (+11/-4)
Percona-Server/storage/innobase/mtr/mtr0mtr.c (+35/-4)
Percona-Server/storage/innobase/os/os0file.c (+5/-5)
Percona-Server/storage/innobase/read/read0read.c (+104/-104)
Percona-Server/storage/innobase/rem/rem0rec.c (+191/-66)
Percona-Server/storage/innobase/row/row0ins.c (+9/-5)
Percona-Server/storage/innobase/row/row0merge.c (+99/-30)
Percona-Server/storage/innobase/row/row0mysql.c (+7/-0)
Percona-Server/storage/innobase/row/row0sel.c (+16/-13)
Percona-Server/storage/innobase/row/row0umod.c (+3/-0)
Percona-Server/storage/innobase/row/row0undo.c (+1/-1)
Percona-Server/storage/innobase/row/row0upd.c (+50/-12)
Percona-Server/storage/innobase/row/row0vers.c (+3/-3)
Percona-Server/storage/innobase/srv/srv0srv.c (+192/-83)
Percona-Server/storage/innobase/srv/srv0start.c (+5/-0)
Percona-Server/storage/innobase/trx/trx0purge.c (+29/-4)
Percona-Server/storage/innobase/trx/trx0rec.c (+20/-0)
Percona-Server/storage/innobase/trx/trx0roll.c (+4/-4)
Percona-Server/storage/innobase/trx/trx0sys.c (+10/-1)
Percona-Server/storage/innobase/trx/trx0trx.c (+204/-48)
Percona-Server/storage/myisam/mi_open.c (+6/-0)
Percona-Server/storage/myisam/mi_search.c (+9/-6)
Percona-Server/storage/perfschema/pfs_events_waits.cc (+6/-0)
Percona-Server/strings/ctype-simple.c (+9/-11)
Percona-Server/strings/decimal.c (+17/-16)
Percona-Server/strings/my_vsnprintf.c (+2/-0)
Percona-Server/support-files/mysql.spec.sh (+0/-1)
Percona-Server/vio/vio.c (+24/-1)
Percona-Server/vio/vio_priv.h (+5/-0)
Percona-Server/vio/viosocket.c (+78/-1)
UDF/configure.ac (+1/-0)
build/build-binary.sh (+56/-5)
build/build-dpkg.sh (+1/-1)
build/build-rpm.sh (+7/-7)
build/build-shared-compat-rpm.sh (+1/-1)
build/debian/additions/innotop/InnoDBParser.pm (+0/-1089)
build/debian/additions/innotop/changelog.innotop (+0/-318)
build/debian/additions/innotop/innotop (+0/-9485)
build/debian/additions/innotop/innotop.1 (+0/-2086)
build/debian/control (+14/-2)
build/debian/percona-xtradb-cluster-client-5.5.dirs (+0/-1)
build/debian/percona-xtradb-cluster-client-5.5.docs (+0/-1)
build/debian/percona-xtradb-cluster-client-5.5.install (+0/-3)
build/debian/percona-xtradb-cluster-client-5.5.lintian-overrides (+0/-2)
build/debian/percona-xtradb-cluster-client-5.5.menu (+0/-2)
build/debian/percona-xtradb-cluster-server-5.5.docs (+2/-2)
build/debian/percona-xtradb-cluster-server-5.5.postinst (+9/-1)
build/debian/rules (+60/-50)
build/percona-shared-compat.spec (+5/-1)
build/percona-xtradb-cluster.spec (+53/-45)
doc-ps/source/conf.py (+1/-1)
doc-ps/source/flexibility/buff_read_ahead_area.rst (+36/-0)
doc-ps/source/flexibility/improved_memory_engine.rst (+190/-0)
doc-ps/source/flexibility/innodb_files_extend.rst (+24/-0)
doc-ps/source/flexibility/mysqldump_ignore_create_error.rst (+22/-0)
doc-ps/source/index.rst (+5/-2)
doc-ps/source/installation.rst (+7/-3)
doc-ps/source/management/changed_page_tracking.rst (+12/-2)
doc-ps/source/management/innodb_buffer_pool_shm.rst (+0/-26)
doc-ps/source/management/innodb_expanded_fast_index_creation.rst (+4/-2)
doc-ps/source/management/innodb_kill_idle_trx.rst (+23/-0)
doc-ps/source/management/innodb_lru_dump_restore.rst (+1/-1)
doc-ps/source/management/pam_plugin.rst (+72/-0)
doc-ps/source/management/sql_no_fcache.rst (+0/-34)
doc-ps/source/management/udf_maatkit.rst (+0/-48)
doc-ps/source/management/udf_percona_toolkit.rst (+54/-0)
doc-ps/source/performance/binary_group_commit.rst (+45/-0)
doc-ps/source/performance/handlersocket.rst (+0/-109)
doc-ps/source/performance/innodb_doublewrite_path.rst (+0/-87)
doc-ps/source/performance/innodb_fast_checksum.rst (+1/-1)
doc-ps/source/performance/innodb_numa_support.rst (+6/-6)
doc-ps/source/performance/innodb_purge_thread.rst (+0/-7)
doc-ps/source/performance/query_cache_enhance.rst (+89/-0)
doc-ps/source/performance/threadpool.rst (+159/-0)
doc-ps/source/release-notes/Percona-Server-5.5.15-21.0.rst (+1/-1)
doc-ps/source/release-notes/Percona-Server-5.5.24-26.0.rst (+1/-1)
doc-ps/source/release-notes/Percona-Server-5.5.28-29.3.rst (+1/-1)
doc-ps/source/release-notes/Percona-Server-5.5.29-29.4.rst (+1/-1)
doc-ps/source/release-notes/Percona-Server-5.5.29-30.0.rst (+65/-0)
doc-ps/source/release-notes/Percona-Server-5.5.30-30.1.rst (+30/-0)
doc-ps/source/release-notes/release-notes_index.rst (+35/-0)
doc-ps/source/reliability/innodb_corrupt_table_action.rst (+52/-0)
doc-ps/source/scalability/innodb_io_55.rst (+286/-0)
doc-ps/source/upstream-bug-fixes.rst (+55/-13)
policy/apparmor/usr.sbin.mysqld (+116/-0)
policy/apparmor/usr.sbin.mysqld.local (+2/-0)
policy/selinux/percona-xtradb-cluster.fc (+7/-0)
policy/selinux/percona-xtradb-cluster.te (+73/-0)

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-04-17:

Download full text (3.9 KiB)

Possible regression from:

revno: 463.1.1 [merge]
     fixes bug: https://launchpad.net/bugs/710799
     committer: Alexey Bychko <email address hidden>
     branch nick: bug710799-5.5
     timestamp: Thu 2013-03-07 19:45:40 +0700
     message:
       fix for bug 710799, version 5.5
       [-] disabled uncongitional manual creation of /var/lib/mysql/*
       [+] added conditional call of mysql_install_db, only for clean installation, but not for upgrade
       [+] added debug possibility for %post
     diff:
     === modified file 'build/percona-server.spec'
     --- build/percona-server.spec 2013-02-26 16:40:25 +0000
     +++ build/percona-server.spec 2013-03-07 12:45:40 +0000
     @@ -710,13 +710,16 @@
      fi

      %post -n Percona-Server-server%{product_suffix}
     -
     +if [ X${PERCONA_DEBUG} == X1 ]; then
     + set -x
     +fi
      # ATTENTION: Parts of this are duplicated in the "triggerpostun" !

      mysql_datadir=%{mysqldatadir}
      NEW_VERSION=%{mysql_version}-%{release}
      STATUS_FILE=$mysql_datadir/RPM_UPGRADE_MARKER

     +if [ $1 -eq 1 ]; then
      # ----------------------------------------------------------------------
      # Create data directory if needed, check whether upgrade or install
      # ----------------------------------------------------------------------
     @@ -734,8 +737,11 @@
         # If the directory exists, we may assume it is an upgrade.
         echo "MySQL RPM upgrade to version $NEW_VERSION" >> $STATUS_FILE
      fi
     -if [ ! -d $mysql_datadir/test ] ; then mkdir $mysql_datadir/test; fi
     +if [ ! -d $mysql_datadir/test ]; then
     + mkdir $mysql_datadir/test;
     +fi
     +%{_bindir}/mysql_install_db --rpm --user=%{mysqld_user}
     +fi
      # ----------------------------------------------------------------------
      # Make MySQL start/shutdown automatically when the machine does it.
      # ----------------------------------------------------------------------
     @@ -761,26 +767,19 @@
      usermod -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true

      # ----------------------------------------------------------------------
     +# Initiate databases if needed
     +# ----------------------------------------------------------------------
     +# ----------------------------------------------------------------------
     +# Upgrade databases if needed would go here - but it cannot be automated yet
     +# ----------------------------------------------------------------------
     +
     +# ----------------------------------------------------------------------
      # Change permissions so that the user that will run the MySQL daemon
      # owns all database files.
      # ----------------------------------------------------------------------
      chown -R %{mysqld_user}:%{mysqld_group} $mysql_datadir

      # ----------------------------------------------------------------------
     -# Initiate databases if needed
     -# ----------------------------------------------------------------------
     -
     -# ----------------------------------------------------------------------
     -# Upgrade databases...

Possible regression from:

revno: 463.1.1 [merge]
     fixes bug: https://launchpad.net/bugs/710799
     committer: Alexey Bychko <alexey.bychko@percona.com>
     branch nick: bug710799-5.5
     timestamp: Thu 2013-03-07 19:45:40 +0700
     message:
       fix for bug 710799, version 5.5
       [-] disabled uncongitional manual creation of /var/lib/mysql/*
       [+] added conditional call of mysql_install_db, only for clean installation, but not for upgrade
       [+] added debug possibility for %post
     diff:
     === modified file 'build/percona-server.spec'
     --- build/percona-server.spec       2013-02-26 16:40:25 +0000
     +++ build/percona-server.spec       2013-03-07 12:45:40 +0000
     @@ -710,13 +710,16 @@
      fi
      
      %post -n Percona-Server-server%{product_suffix}
     -
     +if [ X${PERCONA_DEBUG} == X1 ]; then
     +        set -x
     +fi
      # ATTENTION: Parts of this are duplicated in the "triggerpostun" !
      
      mysql_datadir=%{mysqldatadir}
      NEW_VERSION=%{mysql_version}-%{release}
      STATUS_FILE=$mysql_datadir/RPM_UPGRADE_MARKER
      
     +if [ $1 -eq 1 ]; then
      # ----------------------------------------------------------------------
      # Create data directory if needed, check whether upgrade or install
      # ----------------------------------------------------------------------
     @@ -734,8 +737,11 @@
         # If the directory exists, we may assume it is an upgrade.
         echo "MySQL RPM upgrade to version $NEW_VERSION" >> $STATUS_FILE
      fi
     -if [ ! -d $mysql_datadir/test ] ; then mkdir $mysql_datadir/test; fi
     +if [ ! -d $mysql_datadir/test ]; then 
     +        mkdir $mysql_datadir/test; 
     +fi
     +%{_bindir}/mysql_install_db --rpm --user=%{mysqld_user}
     +fi 
      # ----------------------------------------------------------------------
      # Make MySQL start/shutdown automatically when the machine does it.
      # ----------------------------------------------------------------------
     @@ -761,26 +767,19 @@
      usermod -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true
      
      # ----------------------------------------------------------------------
     +# Initiate databases if needed
     +# ----------------------------------------------------------------------
     +# ----------------------------------------------------------------------
     +# Upgrade databases if needed would go here - but it cannot be automated yet
     +# ----------------------------------------------------------------------
     +
     +# ----------------------------------------------------------------------
      # Change permissions so that the user that will run the MySQL daemon
      # owns all database files.
      # ----------------------------------------------------------------------
      chown -R %{mysqld_user}:%{mysqld_group} $mysql_datadir
      
      # ----------------------------------------------------------------------
     -# Initiate databases if needed
     -# ----------------------------------------------------------------------
     -
     -# ----------------------------------------------------------------------
     -# Upgrade databases if needed would go here - but it cannot be automated yet
     -# ----------------------------------------------------------------------
     -
     -# ----------------------------------------------------------------------
     -# Change permissions again to fix any new files.
     -# ----------------------------------------------------------------------
     -chown -R %{mysqld_user}:%{mysqld_group} $mysql_datadir
     -
     -# ----------------------------------------------------------------------
      # Fix permissions for the permission database so that only the user
      # can read them.
      # ----------------------------------------------------------------------
         ------------------------------------------------------------

which was fix for https://bugs.launchpad.net/percona-server/+bug/710799

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-04-17:

The bug is:

=================================================================

if [ $1 -eq 1 ]; then
# ----------------------------------------------------------------------
# Create data directory if needed, check whether upgrade or install
# ----------------------------------------------------------------------
if [ ! -d $mysql_datadir ] ; then mkdir -m 755 $mysql_datadir; fi
if [ -f $STATUS_FILE ] ; then
SERVER_TO_START=`grep '^SERVER_TO_START=' $STATUS_FILE | cut -c17-`
else
SERVER_TO_START=''
fi
# echo "Analyzed: SERVER_TO_START=$SERVER_TO_START"
if [ ! -d $mysql_datadir/mysql ] ; then
mkdir $mysql_datadir/mysql;
echo "MySQL RPM installation of version $NEW_VERSION" >> $STATUS_FILE
else
# If the directory exists, we may assume it is an upgrade.
echo "MySQL RPM upgrade to version $NEW_VERSION" >> $STATUS_FILE
fi
if [ ! -d $mysql_datadir/test ]; then
        mkdir $mysql_datadir/test;
fi
%{_bindir}/mysql_install_db --rpm --user=%{mysqld_user}
fi
# ----------------------------------------------------------------------
# Make MySQL start/shutdown automatically when the machine does it.
# ----------------------------------------------------------------------
# NOTE: This still needs to be debated. Should we check whether these links
# for the other run levels exist(ed) before the upgrade?
# use chkconfig on Enterprise Linux and newer SuSE releases
if [ -x /sbin/chkconfig ] ; then
        /sbin/chkconfig --add mysql
# use insserv for older SuSE Linux versions
elif [ -x /sbin/insserv ] ; then
        /sbin/insserv %{_sysconfdir}/init.d/mysql
fi

# ----------------------------------------------------------------------
# Create a MySQL user and group. Do not report any problems if it already
# exists.
# ----------------------------------------------------------------------
groupadd -r %{mysqld_group} 2> /dev/null || true
useradd -M -r -d $mysql_datadir -s /bin/bash -c "MySQL server" \
-g %{mysqld_group} %{mysqld_user} 2> /dev/null || true
# The user may already exist, make sure it has the proper group nevertheless
# (BUG#12823)
usermod -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true

=======================================================================================

when %{_bindir}/mysql_install_db --rpm --user=%{mysqld_user} is called

the user won't exist since it is a clean install.

It should be moved to its original position.

The bug is:

=================================================================

if [ $1 -eq 1 ]; then
# ----------------------------------------------------------------------
# Create data directory if needed, check whether upgrade or install
# ----------------------------------------------------------------------
if [ ! -d $mysql_datadir ] ; then mkdir -m 755 $mysql_datadir; fi
if [ -f $STATUS_FILE ] ; then
	SERVER_TO_START=`grep '^SERVER_TO_START=' $STATUS_FILE | cut -c17-`
else
	SERVER_TO_START=''
fi
# echo "Analyzed: SERVER_TO_START=$SERVER_TO_START"
if [ ! -d $mysql_datadir/mysql ] ; then
	mkdir $mysql_datadir/mysql;
	echo "MySQL RPM installation of version $NEW_VERSION" >> $STATUS_FILE
else
	# If the directory exists, we may assume it is an upgrade.
	echo "MySQL RPM upgrade to version $NEW_VERSION" >> $STATUS_FILE
fi
if [ ! -d $mysql_datadir/test ]; then 
        mkdir $mysql_datadir/test; 
fi
%{_bindir}/mysql_install_db --rpm --user=%{mysqld_user}
fi 
# ----------------------------------------------------------------------
# Make MySQL start/shutdown automatically when the machine does it.
# ----------------------------------------------------------------------
# NOTE: This still needs to be debated. Should we check whether these links
# for the other run levels exist(ed) before the upgrade?
# use chkconfig on Enterprise Linux and newer SuSE releases
if [ -x /sbin/chkconfig ] ; then
        /sbin/chkconfig --add mysql
# use insserv for older SuSE Linux versions
elif [ -x /sbin/insserv ] ; then
        /sbin/insserv %{_sysconfdir}/init.d/mysql
fi

# ----------------------------------------------------------------------
# Create a MySQL user and group. Do not report any problems if it already
# exists.
# ----------------------------------------------------------------------
groupadd -r %{mysqld_group} 2> /dev/null || true
useradd -M -r -d $mysql_datadir -s /bin/bash -c "MySQL server" \
  -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true
# The user may already exist, make sure it has the proper group nevertheless
# (BUG#12823)
usermod -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true

=======================================================================================

when %{_bindir}/mysql_install_db --rpm --user=%{mysqld_user} is called

the user won't exist since it is a clean install.

It should be moved to its original position.

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-04-17:

The workaround would be to manually do

groupadd -r %{mysqld_group} 2> /dev/null || true
useradd -M -r -d $mysql_datadir -s /bin/bash -c "MySQL server" \
-g %{mysqld_group} %{mysqld_user} 2> /dev/null || true
# The user may already exist, make sure it has the proper group nevertheless
# (BUG#12823)
usermod -g %{mysqld_group} %{mysqld_user} 2> /dev/null || true

before doing yum install (in case of clean install)

Raghavendra D Prabhu (raghavendra-prabhu) on 2013-04-17

Changed in percona-xtradb-cluster:
importance:	Undecided → Critical

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-04-17:

As per the reporter,

doing :

mysql_install_db --user=mysql + service mysql start

manually should also do.

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-04-17:

This is because the users/groups are created anyways, only the mysql_install_db fails.

Ignacio Nin (ignacio-nin) on 2013-04-17

Changed in percona-server:
importance:	Undecided → Critical
status:	New → Confirmed
Changed in percona-xtradb-cluster:
status:	New → Confirmed

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-04-18:

Fix released in Percona-XtraDB-Cluster 5.5.30-23.7.4.404

Changed in percona-xtradb-cluster:
status:	Confirmed → Fix Released

Raghavendra D Prabhu (raghavendra-prabhu) on 2013-04-18

Changed in percona-xtradb-cluster:
assignee:	nobody → Alexey Bychko (abychko)

Raghavendra D Prabhu (raghavendra-prabhu) on 2013-04-19

Changed in percona-xtradb-cluster:
milestone:	none → 5.5.30-23.7.4-2

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2013-04-30:

Apparently the fix doesn't work as intended or is incomplete, see bug #1174426.

Jaime Sicam (jssicam) on 2013-05-11

tags:

added: i31262

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-23:

Does this bug require further followup for 5.6 GA? Setting 56qual ftm until we're sure.

tags:

added: 56qual

Revision history for this message

Ignacio Nin (ignacio-nin) wrote on 2013-09-24:

Not reproducible in 5.6, setting to Invalid as is fixed in all other versions.

Revision history for this message

Ernestas (ernetas) wrote on 2014-02-10:

#10

I amm able to reproduce this for Percona 5.6 on clean Ubuntu 12.04.3 virtual machines.

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2014-02-11:

#11

Ernestas,

Can you provide more details of this - logs etc.? The bug was reported for
CentOS/RPM and was due to regression from https://launchpad.net/bugs/710799. Also, 710799 was not ported to PS 5.6 (but it is in PXC 5.6 though, along with fix of 710799), so this issue is not there for RPM either (for PS5.6).

Revision history for this message

Valerii Kravchuk (valerii-kravchuk) wrote on 2014-02-21:

#12

Waiting for more details (including exact 5.6.x version used) from Ernestas.

Evgeny Makarov (just3fix) on 2014-03-27

information type:

Public → Public Security

Laurynas Biveinis (laurynas-biveinis) on 2014-03-28

information type:

Public Security → Public

Revision history for this message

Roel Van de Paar (roel11) wrote on 2015-03-19:

#13

Closing out this open bug for 5.6 by s/incomplete/invalid/ until counter proof is shown.

tags:

removed: 56qual

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-18:

#14

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-923

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

#15

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2939

Report a bug

This report contains Public information

Everyone can see this information.

Duplicates of this bug

Bug #1168437

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.