Announcement

Announcement Module
Collapse
No announcement yet.

BUG: Unable to install from APT (invoke-rc.d: initscript mysql, action "start" failed)

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • BUG: Unable to install from APT (invoke-rc.d: initscript mysql, action "start" failed)

    I'm using apt to install server+client. After uncompressing the packages I got a prompt asking me what the root password should be. After entering, I got an alert window saying it was unable to set the password and that I should to it after installation finished.

    The installation failed. See below for complete output from apt. I'm using Debian squeeze. How do I solve this?

    Both mysql.log and mysql.err are empty. I'm also including message in syslog.


    root@app1:/home/chrille# apt-get install percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-server-5.5 percona-xtrabackupReading package lists... DoneBuilding dependency tree Reading state information... DoneThe following extra packages will be installed: libaio1 libdbi-perl libglib2.0-0 libglib2.0-data libmysqlclient18 libnet-daemon-perl libplrpc-perl netcat-openbsd percona-xtradb-cluster-common-5.5 percona-xtradb-cluster-galera-2.x rsync shared-mime-infoSuggested packages: tinycaThe following NEW packages will be installed: libaio1 libdbi-perl libglib2.0-0 libglib2.0-data libmysqlclient18 libnet-daemon-perl libplrpc-perl netcat-openbsd percona-xtrabackup percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-common-5.5 percona-xtradb-cluster-galera-2.x percona-xtradb-cluster-server-5.5 rsync shared-mime-info0 upgraded, 15 newly installed, 0 to remove and 9 not upgraded.Need to get 81.1 MB/84.1 MB of archives.After this operation, 264 MB of additional disk space will be used.Do you want to continue [Y/n]? Get:1 http://ftp.se.debian.org/debian/ squeeze/main libnet-daemon-perl all 0.43-1 [46.6 kB]Get:2 http://ftp.se.debian.org/debian/ squeeze/main libplrpc-perl all 0.2020-2 [36.0 kB] Get:3 http://repo.percona.com/apt/ squeeze/main libmysqlclient18 amd64 5.5.24-rel26.0-256.squeeze [2,002 kB]Get:4 http://ftp.se.debian.org/debian/ squeeze/main libdbi-perl amd64 1.612-1 [883 kB]Get:5 http://ftp.se.debian.org/debian/ squeeze/main netcat-openbsd amd64 1.89-4 [36.8 kB]Get:6 http://ftp.se.debian.org/debian/ squeeze/main rsync amd64 3.0.7-2 [359 kB]Get:7 http://ftp.se.debian.org/debian/ squeeze/main libaio1 amd64 0.3.107-7 [7,928 B]Get:8 http://repo.percona.com/apt/ squeeze/main percona-xtradb-cluster-common-5.5 all 5.5.24-23.6-341.squeeze [2,824 B] Get:9 http://repo.percona.com/apt/ squeeze/main percona-xtradb-cluster-client-5.5 amd64 5.5.24-23.6-341.squeeze [19.5 MB] Get:10 http://repo.percona.com/apt/ squeeze/main percona-xtrabackup amd64 2.0.0-417.squeeze [20.5 MB] Get:11 http://repo.percona.com/apt/ squeeze/main percona-xtradb-cluster-galera-2.x amd64 112.squeeze [1,499 kB] Get:12 http://repo.percona.com/apt/ squeeze/main percona-xtradb-cluster-server-5.5 amd64 5.5.24-23.6-341.squeeze [36.2 MB] 56% [12 percona-xtradb-cluster-server-5.5 546 kB/36.2 MB 1%] 120 kB/s 4min 57s Fetched 81.1 MB in 10min 14s (132 kB/s) Preconfiguring packages ...Selecting previously deselected package libnet-daemon-perl.(Reading database ... 23379 files and directories currently installed.)Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ...Selecting previously deselected package libplrpc-perl.Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...Selecting previously deselected package libdbi-perl.Unpacking libdbi-perl (from .../libdbi-perl_1.612-1_amd64.deb) ...Selecting previously deselected package libglib2.0-0.Unpacking libglib2.0-0 (from .../libglib2.0-0_2.24.2-1_amd64.deb) ...Selecting previously deselected package libglib2.0-data.Unpacking libglib2.0-data (from .../libglib2.0-data_2.24.2-1_all.deb) ...Selecting previously deselected package netcat-openbsd.Unpacking netcat-openbsd (from .../netcat-openbsd_1.89-4_amd64.deb) ...Selecting previously deselected package rsync.Unpacking rsync (from .../rsync_3.0.7-2_amd64.deb) ...Selecting previously deselected package shared-mime-info.Unpacking shared-mime-info (from .../shared-mime-info_0.71-4_amd64.deb) ...Selecting previously deselected package libaio1.Unpacking libaio1 (from .../libaio1_0.3.107-7_amd64.deb) ...Selecting previously deselected package libmysqlclient18.Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.24-rel26.0-256.squeeze_amd64.deb) ...Selecting previously deselected package percona-xtradb-cluster-common-5.5.Unpacking percona-xtradb-cluster-common-5.5 (from .../percona-xtradb-cluster-common-5.5_5.5.24-23.6-341.squeeze_all.deb) ...Selecting previously deselected package percona-xtradb-cluster-client-5.5.Unpacking percona-xtradb-cluster-client-5.5 (from .../percona-xtradb-cluster-client-5.5_5.5.24-23.6-341.squeeze_amd64.deb) ...Selecting previously deselected package percona-xtrabackup.Unpacking percona-xtrabackup (from .../percona-xtrabackup_2.0.0-417.squeeze_amd64.deb) ...Selecting previously deselected package percona-xtradb-cluster-galera-2.x.Unpacking percona-xtradb-cluster-galera-2.x (from .../percona-xtradb-cluster-galera-2.x_112.squeeze_amd64.deb) ...Selecting previously deselected package percona-xtradb-cluster-server-5.5.Unpacking percona-xtradb-cluster-server-5.5 (from .../percona-xtradb-cluster-server-5.5_5.5.24-23.6-341.squeeze_amd64.deb) ...Processing triggers for man-db ...Processing triggers for install-info ...install-info: warning: no info dir entry in `/usr/share/info/mysql.info.gz'Setting up libnet-daemon-perl (0.43-1) ...Setting up libplrpc-perl (0.2020-2) ...Setting up libdbi-perl (1.612-1) ...Setting up libglib2.0-0 (2.24.2-1) ...Setting up libglib2.0-data (2.24.2-1) ...Setting up netcat-openbsd (1.89-4) ...update-alternatives: using /bin/nc.openbsd to provide /bin/nc (nc) in auto mode.Setting up rsync (3.0.7-2) ...update-rc.d: using dependency based boot sequencingSetting up shared-mime-info (0.71-4) ...Setting up libaio1 (0.3.107-7) ...Setting up libmysqlclient18 (5.5.24-rel26.0-256.squeeze) ...Setting up percona-xtradb-cluster-common-5.5 (5.5.24-23.6-341.squeeze) ...Setting up percona-xtradb-cluster-client-5.5 (5.5.24-23.6-341.squeeze) ...Setting up percona-xtrabackup (2.0.0-417.squeeze) ...Setting up percona-xtradb-cluster-galera-2.x (112.squeeze) ...Setting up percona-xtradb-cluster-server-5.5 (5.5.24-23.6-341.squeeze) ...Stopping MySQL (Percona XtraDB Cluster): mysqld.120609 19:22:51 [ERROR] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, s120609 19:22:51 [ERROR] AbortingStarting MySQL (Percona XtraDB Cluster) database server: mysqld . . . . . . . . . . . . . . failed!invoke-rc.d: initscript mysql, action "start" failed.dpkg: error processing percona-xtradb-cluster-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1configured to not write apport reports Errors were encountered while processing: percona-xtradb-cluster-server-5.5E: Sub-process /usr/bin/dpkg returned an error code (1)







    From syslog:


    Jun 9 19:22:51 app1 mysqld_safe[15506]: Installation of system tables failed! Examine the logs in
    Jun 9 19:22:51 app1 mysqld_safe[15506]: /var/lib/mysql for more information.
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: You can try to start the mysqld daemon with:
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: shell> /usr/sbin/mysqld --skip-grant &
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: and use the command line tool /usr/bin/mysql
    Jun 9 19:22:51 app1 mysqld_safe[15506]: to connect to the mysql database and look at the grant tables:
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: shell> /usr/bin/mysql -u root mysql
    Jun 9 19:22:51 app1 mysqld_safe[15506]: mysql> show tables
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: Try 'mysqld --help' if you have problems with paths. Using --log
    Jun 9 19:22:51 app1 mysqld_safe[15506]: gives you a log in /var/lib/mysql that may be helpful.
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: Please consult the MySQL manual section
    Jun 9 19:22:51 app1 mysqld_safe[15506]: 'Problems running mysql_install_db', and the manual section that
    Jun 9 19:22:51 app1 mysqld_safe[15506]: describes problems on your OS. Another information source are the
    Jun 9 19:22:51 app1 mysqld_safe[15506]: MySQL email archives available at http://lists.mysql.com/.
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15506]: Please check all of the above before mailing us! And remember, if
    Jun 9 19:22:51 app1 mysqld_safe[15506]: you do mail us, you MUST use the /usr/scripts/mysqlbug script!
    Jun 9 19:22:51 app1 mysqld_safe[15506]:
    Jun 9 19:22:51 app1 mysqld_safe[15548]: 120609 19:22:51 [ERROR] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, s
    Jun 9 19:22:51 app1 mysqld_safe[15548]: 120609 19:22:51 [ERROR] Aborting

  • #2
    it looks like it installed, just doesn't start. are you using ubuntu? i had to disable apparmor from monitor mysql because it was preventing it to run external scripts which wsrep needs to do.

    Comment


    • #3
      Hi,

      your configuration is wrong, try to change the bind address to 0.0.0.0 instead of 127.0.0.1 or change wsrep_sst_method to rsync for example.

      regards,

      Comment

      Working...
      X