| Bug #59880 | mysqld double start was not catched in mysql5.5 | ||
|---|---|---|---|
| Submitted: | 2 Feb 2011 4:06 | Modified: | 19 Dec 2011 4:57 |
| Reporter: | ws lee | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S3 (Non-critical) |
| Version: | 5.5.8, 5.5.13 | OS: | Solaris (SunOS 5.10) |
| Assigned to: | CPU Architecture: | Any | |
[2 Feb 2011 4:06]
ws lee
[7 Feb 2011 16:23]
Valeriy Kravchuk
Thank you for the problem report. Please, upload the entire error log, db01.err, with that double start attempt in 5.5.8 logged.
[8 Feb 2011 0:59]
ws lee
To. Kravchuk thanks your replay. duble start log is below. ------------------ 110208 09:55:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/mysql5.5.8 110208 9:55:54 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Solaris atomic functions InnoDB: Compressed tables use zlib 1.2.3 110208 9:55:54 InnoDB: Initializing buffer pool, size = 100.0M 110208 9:55:54 InnoDB: Completed initialization of buffer pool 110208 9:55:54 InnoDB: highest supported file format is Barracuda. 110208 9:55:54 InnoDB: 1.1.4 started; log sequence number 1595675 110208 9:55:54 [Note] Event Scheduler: Loaded 0 events 110208 9:55:54 [Note] /usr/local/mysql5.5.8/bin/mysqld: ready for connections. Version: '5.5.8-log' socket: '/tmp/mysql5.5.8.sock' port: 3307 MySQL Community Server (GPL) 110208 09:56:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/mysql5.5.8 110208 9:56:01 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use Solaris atomic functions InnoDB: Compressed tables use zlib 1.2.3 110208 9:56:01 InnoDB: Initializing buffer pool, size = 100.0M 110208 9:56:01 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 110208 9:56:01 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. ... ... ----the below is infinitly repeated InnoDB: Unable to lock /var/lib/innodb-data/mysql5.5.8/ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files.
[8 Feb 2011 15:06]
Valeriy Kravchuk
Please, upload mysql.server script from 5.5.8 to the bug report. Looks like basedir setting is wrong/missing there.
[9 Feb 2011 3:41]
ws lee
To. Kravchuk
I attached file mysql.server.Please confirm.
I have used mysql.server with 5.5.8 tar package.
I have modified only below.
-------
43 # If you change base dir, you must also change datadir. These may get
44 # overwritten by settings in the MySQL configuration files.
45
46 basedir=/usr/local/mysql5.5.8
47 datadir=/var/lib/mysql/mysql5.5.8
-------
[23 May 2011 4:01]
ws lee
It was not fix in mysql 5.5.12 also.
[17 Dec 2011 19:24]
Valeriy Kravchuk
Please, check if this problem still happens with a newer version, 5.5.19. I do not see it with default mysql.server script in current 5.5.20.
[19 Dec 2011 0:41]
ws lee
thans for reply. It seems to solve in mysql5.5.19.
[19 Dec 2011 4:57]
Valeriy Kravchuk
Not repeatable with 5.5.19.
