informations about boot sequence (Re: F15 - mysql start problem)

Michał Piotrowski mkkp4x4 at gmail.com
Mon May 9 18:09:45 UTC 2011


2011/5/9 Tom Lane <tgl at redhat.com>:
> Reindl Harald <h.reindl at thelounge.net> writes:
>> Am 09.05.2011 19:09, schrieb Michał Piotrowski:
>>> W dniu 9 maja 2011 18:10 użytkownik Michal Schmidt
>>> <mschmidt at redhat.com> napisał:
>>>> Are you sure that none of these services can deal with the network
>>>> connection coming up later?
>
>>> I don't know. It appears that MySQL can't deal with that
>
>> i wonder that mysqld should need network in every case since  most setups out there using
>> only  sockets for mysql-connections and it is a valid use-case having mysql on machines
>> without any network
>
> I did some quick tests and it seemed that the plain-vanilla
> configuration of both postgres and mysql would start all right in F15.
> However, it's definitely possible to configure postgres in a way that
> requires it to do DNS lookups at startup, and I verified that that will
> fail in the current state of F15.  I'm less familiar with all of mysql's
> options but I wouldn't be surprised if there's comparable issues there.
>
> I'd be interested to know whether the OP was using a vanilla my.cnf or
> something custom, and exactly what failure mode he saw.

In my case

[mysqld]
datadir=/home/data/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
bind-address = 192.168.101.200
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server = utf8
collation-server = utf8_general_ci

[mysql]
default-character-set=utf8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


MySQL exited with code 1

mysqld.service - SYSV: MySQL database server.
         Loaded: loaded (/etc/rc.d/init.d/mysqld)
         Active: failed since Mon, 09 May 2011 08:15:44 +0200; 4min 32s ago
        Process: 549 ExecStart=/etc/rc.d/init.d/mysqld start
(code=exited, status=1/FAILURE)
         CGroup: name=systemd:/system/mysqld.service

Here is a fragment from log

110509  8:15:41 [Note] Plugin 'FEDERATED' is disabled.
110509  8:15:41 InnoDB: The InnoDB memory heap is disabled
110509  8:15:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110509  8:15:41 InnoDB: Compressed tables use zlib 1.2.5
110509  8:15:41 InnoDB: Using Linux native AIO
110509  8:15:41 InnoDB: Initializing buffer pool, size = 128.0M
110509  8:15:41 InnoDB: Completed initialization of buffer pool
110509  8:15:41 InnoDB: highest supported file format is Barracuda.
110509  8:15:42  InnoDB: Waiting for the background threads to start
110509  8:15:43 InnoDB: 1.1.5 started; log sequence number 48965389142
110509  8:15:43 [ERROR] Can't start server: Bind on TCP/IP port:
Cannot assign requested address
110509  8:15:43 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
110509  8:15:43 [ERROR] Aborting

110509  8:15:43  InnoDB: Starting shutdown...
110509  8:15:44  InnoDB: Shutdown completed; log sequence number 48965389142
110509  8:15:44 [Note] /usr/libexec/mysqld: Shutdown complete


>
>                        regards, tom lane
>
> --
> devel mailing list
> devel at lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/devel
>



-- 
Best regards,
Michal

http://eventhorizon.pl/


More information about the devel mailing list