[Bug 251160] Re: Mythbuntu CC fails to shutdown MySQL when adding primary server role.
Paul
b01 at westhouseit.co.uk
Thu Jul 24 09:53:12 BST 2008
My apologies, should have done that in the first place:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: To do so, start the server,
then issue the following commands:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: /usr/bin/mysqladmin -u root
password 'new-password'
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: /usr/bin/mysqladmin -u root
-h ubuntu password 'new-password'
Jul 23 15:14:23 ubuntu mysqld_safe[13096]:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: Alternatively you can run:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]:
/usr/bin/mysql_secure_installation
Jul 23 15:14:23 ubuntu mysqld_safe[13096]:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: which will also give you the
option of removing the test
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: databases and anonymous user
created by default. This is
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: strongly recommended for
production servers.
Jul 23 15:14:23 ubuntu mysqld_safe[13096]:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: See the manual for more
instructions.
Jul 23 15:14:23 ubuntu mysqld_safe[13096]:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: Please report any problems
with the /usr/bin/mysqlbug script!
Jul 23 15:14:23 ubuntu mysqld_safe[13096]:
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: The latest information about
MySQL is available on the web at
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: http://www.mysql.com
Jul 23 15:14:23 ubuntu mysqld_safe[13096]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Jul 23 15:14:23 ubuntu mysqld_safe[13164]: ERROR: 1046 No database selected
Jul 23 15:14:23 ubuntu mysqld_safe[13164]: 080723 15:14:23 [ERROR] Aborting
Jul 23 15:14:23 ubuntu mysqld_safe[13164]:
Jul 23 15:14:23 ubuntu mysqld_safe[13164]: 080723 15:14:23 [Note]
/usr/sbin/mysqld: Shutdown complete
Jul 23 15:14:23 ubuntu mysqld_safe[13164]:
Jul 23 15:14:26 ubuntu mysqld_safe[13310]: started
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: The first specified data
file ./ibdata1 did not exist:
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: a new database to be created!
Jul 23 15:14:26 ubuntu mysqld[13314]: 080723 15:14:26 InnoDB: Setting
file ./ibdata1 size to 10 MB
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Database physically writes
the file full: wait...
Jul 23 15:14:26 ubuntu mysqld[13314]: 080723 15:14:26 InnoDB: Log file
./ib_logfile0 did not exist: new to be created
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Setting log file
./ib_logfile0 size to 5 MB
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Database physically writes
the file full: wait...
Jul 23 15:14:26 ubuntu mysqld[13314]: 080723 15:14:26 InnoDB: Log file
./ib_logfile1 did not exist: new to be created
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Setting log file
./ib_logfile1 size to 5 MB
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Database physically writes
the file full: wait...
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Doublewrite buffer not
found: creating new
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Doublewrite buffer created
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Creating foreign key
constraint system tables
Jul 23 15:14:26 ubuntu mysqld[13314]: InnoDB: Foreign key constraint
system tables created
Jul 23 15:14:26 ubuntu mysqld[13314]: 080723 15:14:26 InnoDB: Started;
log sequence number 0 0
Jul 23 15:14:26 ubuntu mysqld[13314]: 080723 15:14:26 [Note]
/usr/sbin/mysqld: ready for connections.
Jul 23 15:14:26 ubuntu mysqld[13314]: Version: '5.0.51a-3ubuntu5.1'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13350]: Upgrading MySQL
tables if necessary.
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]: Looking for
'mysql' in: /usr/bin/mysql
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]: Looking for
'mysqlcheck' in: /usr/bin/mysqlcheck
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]: Running
'mysqlcheck'...
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.columns_priv OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.db OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.func OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.help_category OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.help_keyword OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.help_relation OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.help_topic OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.host OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.proc OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.procs_priv OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.tables_priv OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.time_zone OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.time_zone_leap_second OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.time_zone_name OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.time_zone_transition OK
Jul 23 15:14:27 ubuntu /etc/mysql/debian-start[13357]:
mysql.time_zone_transition_type OK
Jul 23 15:14:33 ubuntu mysqld_safe[13526]: Number of processes running
now: 1
Jul 23 15:14:33 ubuntu mysqld_safe[13534]: mysqld process hanging, pid
13312 - killed
Jul 23 15:14:33 ubuntu mysqld_safe[13537]: restarted
Jul 23 15:14:33 ubuntu mysqld[13541]: InnoDB: The log sequence number in
ibdata files does not match
Jul 23 15:14:33 ubuntu mysqld[13541]: InnoDB: the log sequence number in
the ib_logfiles!
Jul 23 15:14:33 ubuntu mysqld[13541]: 080723 15:14:33 InnoDB: Database
was not shut down normally!
Jul 23 15:14:33 ubuntu mysqld[13541]: InnoDB: Starting crash recovery.
Jul 23 15:14:33 ubuntu mysqld[13541]: InnoDB: Reading tablespace
information from the .ibd files...
Jul 23 15:14:33 ubuntu mysqld[13541]: InnoDB: Restoring possible
half-written data pages from the doublewrite
Jul 23 15:14:33 ubuntu mysqld[13541]: InnoDB: buffer...
Jul 23 15:14:33 ubuntu mysqld[13541]: 080723 15:14:33 InnoDB: Started;
log sequence number 0 43655
Jul 23 15:14:33 ubuntu mysqld[13541]: 080723 15:14:33 [Note]
/usr/sbin/mysqld: ready for connections.
Jul 23 15:14:33 ubuntu mysqld[13541]: Version: '5.0.51a-3ubuntu5.1'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Jul 23 15:14:34 ubuntu /etc/init.d/mysql[13564]: 1 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 23 15:14:34 ubuntu /etc/init.d/mysql[13564]: mysqld is alive
Jul 23 15:14:34 ubuntu /etc/init.d/mysql[13564]:
Jul 23 15:18:08 ubuntu mysqld[13541]: 080723 15:18:08 [Note]
/usr/sbin/mysqld: Normal shutdown
Jul 23 15:18:08 ubuntu mysqld[13541]:
Jul 23 15:18:08 ubuntu mysqld[13541]: 080723 15:18:08 InnoDB: Starting
shutdown...
Jul 23 15:18:09 ubuntu mysqld[13541]: 080723 15:18:09 InnoDB: Shutdown
completed; log sequence number 0 43655
Jul 23 15:18:09 ubuntu mysqld[13541]: 080723 15:18:09 [Note]
/usr/sbin/mysqld: Shutdown complete
Jul 23 15:18:09 ubuntu mysqld[13541]:
The shutdown at the end was my manual stop before removing and reinstalling.
Thanks,
Paul
Mathias Gug wrote:
> On Wed, Jul 23, 2008 at 02:26:34PM -0000, Paul wrote:
>
>> ** Attachment added: "DpkgTerminalLog.gz"
>> http://launchpadlibrarian.net/16254151/DpkgTerminalLog.gz
>>
>
> Could you have a look in /var/log/daemon.log? There should be more info
> about the failure to stop the mysql daemon
>
> status incomplete
>
>
--
Mythbuntu CC fails to shutdown MySQL when adding primary server role.
https://bugs.launchpad.net/bugs/251160
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.
More information about the Ubuntu-server-bugs
mailing list