Cannot start Drizzle on an alternate port using init script
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Undecided
|
Unassigned | ||
7.0 |
Fix Released
|
High
|
Monty Taylor |
Bug Description
I am unable to start Drizzle when trying to specify a MySQL port via the config file:
root@mcp:~# cat /etc/drizzle/
datadir = /var/lib/drizzle
pid-file = /var/lib/
#mysql-
[mysql-protocol]
port = 3307
bind-address = 127.0.0.1
root@mcp:~# /etc/init.
* Starting Drizzle database server drizzled
...done.
root@mcp:~# /etc/init.
* Drizzle is stopped.
root@mcp:~# tail -5 /var/log/
Listening on :::4427
bind() failed with errno: 98
Do you already have another drizzled running?
Error getting file descriptorsAborting
/usr/sbin/drizzled: Shutdown complete
Starting drizzle up manually using the config file also fails:
root@mcp:~# drizzled --defaults-
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins.
101004 19:30:44 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 180594
101004 19:30:44 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 180840
InnoDB: Last MySQL binlog file position 0 0, file name UNUSED
101004 19:30:44 InnoDB Plugin 1.0.4 started; log sequence number 180840
Listening on 0.0.0.0:4427
Listening on :::4427
bind() failed with errno: 98
Do you already have another drizzled running?
Error getting file descriptorsAborting
drizzled: Shutdown complete
Nothing is listening on 3307 currently:
root@mcp:~# netstat -nptl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 2401/sshd
tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 11367/apache2
tcp 0 0 0.0.0.0:3784 0.0.0.0:* LISTEN 10118/ventrilo_srv
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 27885/mysqld
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 11367/apache2
tcp 0 0 0.0.0.0:3312 0.0.0.0:* LISTEN 2620/searchd
tcp6 0 0 :::22 :::* LISTEN 2401/sshd
This is on Lucid (10.04) using nightly built PPA DEBs:
root@mcp:~# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 10.04.1 LTS
Release: 10.04
Codename: lucid
root@mcp:~# cat /etc/apt/
#deb http://
deb http://
This _should_ be fixed in the current trunk - but I need to figure out how to add a test for it to the test system. Turns out there was a bug in boost in lucid.
Can you try it out and see if it's working now?