mysql::server recipe fails to start mysql after install and breaks chef run

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical Critical
  • Resolution: Fixed
  • Component/s: None
  • Labels:
    None
  • Environment:

    Ubuntu 8.04, Chef 0.7.0

Description

When running the mysql::server recipe to install the packages, it fails to start the server after installs the apt pkg.

Below is a log of the output.

####

[Mon, 15 Jun 2009 13:26:36 -0400] INFO: Installing package[mysql-server] version 5.0.51a-3ubuntu5.4
[Mon, 15 Jun 2009 13:26:36 -0400] DEBUG: Executing apt-get -q -y install mysql-server=5.0.51a-3ubuntu5.4
[Mon, 15 Jun 2009 13:27:08 -0400] DEBUG: ---- Begin output of apt-get -q -y install mysql-server=5.0.51a-3ubuntu5.4 ----
[Mon, 15 Jun 2009 13:27:08 -0400] DEBUG: STDOUT: Reading package lists...
Building dependency tree...
Reading state information...
The following extra packages will be installed:
mysql-server mysql-server-5.0
Suggested packages:
mysql-doc-5.0 tinyca
Recommended packages:
libhtml-template-perl mailx
The following NEW packages will be installed:
mysql-server mysql-server-5.0
Preconfiguring packages ...
0 upgraded, 2 newly installed, 0 to remove and 11 not upgraded.
Need to get 0B/28.1MB of archives.
After this operation, 89.3MB of additional disk space will be used.
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 35530 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.4_amd64.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.51a-3ubuntu5.4_all.deb) ...
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.4) ...

  • Stopping MySQL database server mysqld
    ...done.
    ls: cannot access /sys/module/apparmor: No such file or directory
    ls: cannot access /sys/module/apparmor: No such file or directory
    ls: cannot access /sys/module/apparmor: No such file or directory
    $Loading AppArmor module: Failed.
    invoke-rc.d: initscript apparmor, action "force-reload" failed.
  • Starting MySQL database server mysqld
    ...fail!
    invoke-rc.d: initscript mysql, action "start" failed.
    dpkg: error processing mysql-server-5.0 (--configure):
    subprocess post-installation script returned error exit status 1
    dpkg: dependency problems prevent configuration of mysql-server:
    mysql-server depends on mysql-server-5.0; however:
    Package mysql-server-5.0 is not configured yet.
    dpkg: error processing mysql-server (--configure):
    dependency problems - leaving unconfigured
    Errors were encountered while processing:
    mysql-server-5.0
    mysql-server
    [Mon, 15 Jun 2009 13:27:08 -0400] DEBUG: STDERR: E: Sub-process /usr/bin/dpkg returned an error code (1)
    [Mon, 15 Jun 2009 13:27:08 -0400] DEBUG: ---- End output of apt-get -q -y install mysql-server=5.0.51a-3ubuntu5.4 ----
    [Mon, 15 Jun 2009 13:27:08 -0400] ERROR: package[mysql-server] (/srv/chef/cache/cookbooks/mysql/recipes/server.rb line 40) had an error:
    apt-get -q -y install mysql-server=5.0.51a-3ubuntu5.4 returned 100, expected 0
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/mixin/command.rb:157:in `run_command'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/mixin/command.rb:133:in `chdir'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/mixin/command.rb:133:in `run_command'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/provider/package/apt.rb:68:in `install_package'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/provider/package.rb:60:in `action_install'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:87:in `send'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:87:in `converge'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:85:in `each'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:85:in `converge'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/resource_collection.rb:58:in `each'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/resource_collection.rb:57:in `each'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:63:in `converge'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/client.rb:373:in `converge'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/client.rb:81:in `run'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application/client.rb:163:in `run_application'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application/client.rb:161:in `loop'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application/client.rb:161:in `run_application'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application.rb:53:in `run'/usr/lib/ruby/gems/1.8/gems/chef-0.7.0/bin/chef-client:26/usr/bin/chef-client:19:in `load'/usr/bin/chef-client:19
    [Mon, 15 Jun 2009 13:27:08 -0400] ERROR: Chef::Exceptions::Exec
    [Mon, 15 Ju
    n 2009 13:27:08 -0400] FATAL: apt-get -q -y install mysql-server=5.0.51a-3ubuntu5.4 returned 100, expected 0
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/mixin/command.rb:157:in `run_command'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/mixin/command.rb:133:in `chdir'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/mixin/command.rb:133:in `run_command'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/provider/package/apt.rb:68:in `install_package'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/provider/package.rb:60:in `action_install'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:87:in `send'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:87:in `converge'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:85:in `each'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:85:in `converge'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/resource_collection.rb:58:in `each'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/resource_collection.rb:57:in `each'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/runner.rb:63:in `converge'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/client.rb:373:in `converge'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/client.rb:81:in `run'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application/client.rb:163:in `run_application'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application/client.rb:161:in `loop'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application/client.rb:161:in `run_application'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/lib/chef/application.rb:53:in `run'
    /usr/lib/ruby/gems/1.8/gems/chef-0.7.0/bin/chef-client:26
    /usr/bin/chef-client:19:in `load'
    /usr/bin/chef-client:19

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Nathan Brown added a comment -

Just checked the syslogd and found this...

Jun 15 14:00:18 staging mysqld[6805]: 090615 12:00:18 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'

Show
Nathan Brown added a comment - Just checked the syslogd and found this... Jun 15 14:00:18 staging mysqld [6805] : 090615 12:00:18 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated'
Hide
Permalink
Nathan Brown added a comment -

Removed the skip-federated in the my.cnf template for the MySQL version I am running.

Now I get this...

Jun 15 14:28:20 staging mysqld_safe[9317]: ERROR: 1046 No database selected
Jun 15 14:28:20 staging mysqld_safe[9317]: 090615 14:28:20 [ERROR] Aborting

Still tracking down where the database needs to be selected for the install.

##

Jun 15 14:28:20 staging mysqld_safe[9252]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jun 15 14:28:20 staging mysqld_safe[9252]: To do so, start the server, then issue the following commands:
Jun 15 14:28:20 staging mysqld_safe[9252]: /usr/bin/mysqladmin -u root password 'new-password'
Jun 15 14:28:20 staging mysqld_safe[9252]: /usr/bin/mysqladmin -u root -h staging password 'new-password'
Jun 15 14:28:20 staging mysqld_safe[9252]:
Jun 15 14:28:20 staging mysqld_safe[9252]: Alternatively you can run:
Jun 15 14:28:20 staging mysqld_safe[9252]: /usr/bin/mysql_secure_installation
Jun 15 14:28:20 staging mysqld_safe[9252]:
Jun 15 14:28:20 staging mysqld_safe[9252]: which will also give you the option of removing the test
Jun 15 14:28:20 staging mysqld_safe[9252]: databases and anonymous user created by default. This is
Jun 15 14:28:20 staging mysqld_safe[9252]: strongly recommended for production servers.
Jun 15 14:28:20 staging mysqld_safe[9252]:
Jun 15 14:28:20 staging mysqld_safe[9252]: See the manual for more instructions.
Jun 15 14:28:20 staging mysqld_safe[9252]:
Jun 15 14:28:20 staging mysqld_safe[9252]: Please report any problems with the /usr/bin/mysqlbug script!
Jun 15 14:28:20 staging mysqld_safe[9252]:
Jun 15 14:28:20 staging mysqld_safe[9252]: The latest information about MySQL is available on the web at
Jun 15 14:28:20 staging mysqld_safe[9252]: http://www.mysql.com
Jun 15 14:28:20 staging mysqld_safe[9252]: Support MySQL by buying support/licenses at http://shop.mysql.com
Jun 15 14:28:20 staging mysqld_safe[9317]: ERROR: 1046 No database selected
Jun 15 14:28:20 staging mysqld_safe[9317]: 090615 14:28:20 [ERROR] Aborting
Jun 15 14:28:20 staging mysqld_safe[9317]:
Jun 15 14:28:20 staging mysqld_safe[9317]: 090615 14:28:20 [Note] /usr/sbin/mysqld: Shutdown complete
Jun 15 14:28:20 staging mysqld_safe[9317]:
Jun 15 14:28:20 staging mysqld_safe[9438]: started
Jun 15 14:28:20 staging mysqld[9441]: InnoDB: Error: pthread_create returned 12
Jun 15 14:28:20 staging mysqld_safe[9443]: ended
Jun 15 14:28:34 staging /etc/init.d/mysql[9578]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 15 14:28:34 staging /etc/init.d/mysql[9578]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jun 15 14:28:34 staging /etc/init.d/mysql[9578]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jun 15 14:28:34 staging /etc/init.d/mysql[9578]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jun 15 14:28:34 staging /etc/init.d/mysql[9578]:

Show
Nathan Brown added a comment - Removed the skip-federated in the my.cnf template for the MySQL version I am running. Now I get this... Jun 15 14:28:20 staging mysqld_safe [9317] : ERROR: 1046 No database selected Jun 15 14:28:20 staging mysqld_safe [9317] : 090615 14:28:20 [ERROR] Aborting Still tracking down where the database needs to be selected for the install. ## Jun 15 14:28:20 staging mysqld_safe [9252] : PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jun 15 14:28:20 staging mysqld_safe [9252] : To do so, start the server, then issue the following commands: Jun 15 14:28:20 staging mysqld_safe [9252] : /usr/bin/mysqladmin -u root password 'new-password' Jun 15 14:28:20 staging mysqld_safe [9252] : /usr/bin/mysqladmin -u root -h staging password 'new-password' Jun 15 14:28:20 staging mysqld_safe [9252] : Jun 15 14:28:20 staging mysqld_safe [9252] : Alternatively you can run: Jun 15 14:28:20 staging mysqld_safe [9252] : /usr/bin/mysql_secure_installation Jun 15 14:28:20 staging mysqld_safe [9252] : Jun 15 14:28:20 staging mysqld_safe [9252] : which will also give you the option of removing the test Jun 15 14:28:20 staging mysqld_safe [9252] : databases and anonymous user created by default. This is Jun 15 14:28:20 staging mysqld_safe [9252] : strongly recommended for production servers. Jun 15 14:28:20 staging mysqld_safe [9252] : Jun 15 14:28:20 staging mysqld_safe [9252] : See the manual for more instructions. Jun 15 14:28:20 staging mysqld_safe [9252] : Jun 15 14:28:20 staging mysqld_safe [9252] : Please report any problems with the /usr/bin/mysqlbug script! Jun 15 14:28:20 staging mysqld_safe [9252] : Jun 15 14:28:20 staging mysqld_safe [9252] : The latest information about MySQL is available on the web at Jun 15 14:28:20 staging mysqld_safe [9252] : http://www.mysql.com Jun 15 14:28:20 staging mysqld_safe [9252] : Support MySQL by buying support/licenses at http://shop.mysql.com Jun 15 14:28:20 staging mysqld_safe [9317] : ERROR: 1046 No database selected Jun 15 14:28:20 staging mysqld_safe [9317] : 090615 14:28:20 [ERROR] Aborting Jun 15 14:28:20 staging mysqld_safe [9317] : Jun 15 14:28:20 staging mysqld_safe [9317] : 090615 14:28:20 [Note] /usr/sbin/mysqld: Shutdown complete Jun 15 14:28:20 staging mysqld_safe [9317] : Jun 15 14:28:20 staging mysqld_safe [9438] : started Jun 15 14:28:20 staging mysqld [9441] : InnoDB: Error: pthread_create returned 12 Jun 15 14:28:20 staging mysqld_safe [9443] : ended Jun 15 14:28:34 staging /etc/init.d/mysql [9578] : 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jun 15 14:28:34 staging /etc/init.d/mysql [9578] : ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jun 15 14:28:34 staging /etc/init.d/mysql [9578] : error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Jun 15 14:28:34 staging /etc/init.d/mysql [9578] : Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Jun 15 14:28:34 staging /etc/init.d/mysql [9578] :
Hide
Permalink
Joshua Timberman [Opscode] added a comment -

The mysql cookbook was tested on Ubuntu 9.04, but not 8.04. Looks like 8.04 ships with MySQL 5.0.51a-3ubuntu5.4, and 9.04 with 5.1.30really5.0.75-0u. There's my.cnf config file differences.

The thing to do would be create a separate my.cnf.erb template for 8.04, in cookbooks/mysql/template/ubuntu-8.04. If you would like to contribute a patch for this, please see http://wiki.opscode.com/display/opscode/Contributing and http://wiki.opscode.com/display/opscode/Working+with+Git

Show
Joshua Timberman [Opscode] added a comment - The mysql cookbook was tested on Ubuntu 9.04, but not 8.04. Looks like 8.04 ships with MySQL 5.0.51a-3ubuntu5.4, and 9.04 with 5.1.30really5.0.75-0u. There's my.cnf config file differences. The thing to do would be create a separate my.cnf.erb template for 8.04, in cookbooks/mysql/template/ubuntu-8.04. If you would like to contribute a patch for this, please see http://wiki.opscode.com/display/opscode/Contributing and http://wiki.opscode.com/display/opscode/Working+with+Git
Hide
Permalink
Joshua Timberman [Opscode] added a comment -

That said, I'll work on this later today or tomorrow if I get a chance.

Show
Joshua Timberman [Opscode] added a comment - That said, I'll work on this later today or tomorrow if I get a chance.
Hide
Permalink
Joshua Timberman [Opscode] added a comment -

Merged and fixed in opscode/cookbooks master, Nathaniel please pull the latest and verify. I added the ubuntu-8.04 template directory with my.cnf.erb w/o the skip-federated option.

Show
Joshua Timberman [Opscode] added a comment - Merged and fixed in opscode/cookbooks master, Nathaniel please pull the latest and verify. I added the ubuntu-8.04 template directory with my.cnf.erb w/o the skip-federated option.

People

  • Assignee:
    Joshua Timberman [Opscode]
    Reporter:
    Nathan Brown
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: