Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: mysql crash IMPORTANT

    hello,

    I have a big problem, all few hours my mysql daemon crashs. Its totally random. I already changed alot in the config, but it cant be fixed so far

    here the mysqld.err log


    Code:
    mysqld process hanging, pid 22747 - killed 
    mysqld process hanging, pid 22747 - killed 
    mysqld process hanging, pid 22747 - killed 
    040225 12:53:38  mysqld restarted 
    Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line 
    040225 12:53:38  Can't start server: Bind on TCP/IP port: Address already in use 
    040225 12:53:38  Do you already have another mysqld server running on port: 3306 ? 
    040225 12:53:38  Aborting 
    
    040225 12:53:38  /usr/sbin/mysqld: Shutdown Complete 
    
    040225 12:53:38  mysqld ended
    Here my mysql config (my.cnf)

    Code:
    [client] 
    #password       = my_password 
    port            = 3306 
    socket          = /var/run/mysqld/mysqld.sock 
    
    [safe_mysqld] 
    err-log         = /var/log/mysql/mysql.err 
    
    [mysqld] 
    skip-innodb 
    user            = mysql 
    pid-file        = /var/run/mysqld/mysqld.pid 
    socket          = /var/run/mysqld/mysqld.sock 
    
    basedir         = /usr 
    datadir         = /var/lib/mysql 
    tmpdir          = /tmp 
    language        = /usr/share/mysql/english 
    skip-locking 
    set-variable    = key_buffer=16M 
    set-variable    = max_allowed_packet=1M 
    set-variable    = thread_stack=128K 
    set-variable    = key_buffer=16M 
    set-variable    = max_allowed_packet=1M 
    set-variable    = thread_stack=128K 
    set-variable    = table_cache=64 
    set-variable    = sort_buffer=512K 
    set-variable    = net_buffer_length=8K 
    set-variable    = myisam_sort_buffer_size=8M 
    set-variable    = query_cache_size=12M 
    set-variable    = max_connections=400 
    set-variable    = wait_timeout=90 
    set-variable    = interactive_timeout=90 
    set-variable    = max_connect_errors=999999 
    set-variable    = max_delayed_threads=999999 
    
    # keep secure by default! 
    bind-address    = 127.0.0.1 
    port            = 3306 
    # this can make it even more secure: 
    #skip-networking 
    
    [mysqldump] 
    quick 
    set-variable    = max_allowed_packet=1M 
    
    [mysql] 
    #no-auto-rehash # faster start of mysql but no tab completition 
    
    [isamchk] 
    set-variable    = key_buffer=16M
    I am open for everything, please reply if you have ANY idea.

    thanks alot

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: mysql crash IMPORTANT

    Originally posted by comby
    hello,

    I have a big problem, all few hours my mysql daemon crashs. Its totally random. I already changed alot in the config, but it cant be fixed so far

    here the mysqld.err log


    Code:
    mysqld process hanging, pid 22747 - killed 
    mysqld process hanging, pid 22747 - killed 
    mysqld process hanging, pid 22747 - killed 
    040225 12:53:38  mysqld restarted 
    Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line 
    040225 12:53:38  Can't start server: Bind on TCP/IP port: Address already in use 
    040225 12:53:38  Do you already have another mysqld server running on port: 3306 ? 
    040225 12:53:38  Aborting 
    
    040225 12:53:38  /usr/sbin/mysqld: Shutdown Complete 
    
    040225 12:53:38  mysqld ended
    Here my mysql config (my.cnf)

    Code:
    [client] 
    #password       = my_password 
    port            = 3306 
    socket          = /var/run/mysqld/mysqld.sock 
    
    [safe_mysqld] 
    err-log         = /var/log/mysql/mysql.err 
    
    [mysqld] 
    skip-innodb 
    user            = mysql 
    pid-file        = /var/run/mysqld/mysqld.pid 
    socket          = /var/run/mysqld/mysqld.sock 
    
    basedir         = /usr 
    datadir         = /var/lib/mysql 
    tmpdir          = /tmp 
    language        = /usr/share/mysql/english 
    skip-locking 
    set-variable    = key_buffer=16M 
    set-variable    = max_allowed_packet=1M 
    set-variable    = thread_stack=128K 
    set-variable    = key_buffer=16M 
    set-variable    = max_allowed_packet=1M 
    set-variable    = thread_stack=128K 
    set-variable    = table_cache=64 
    set-variable    = sort_buffer=512K 
    set-variable    = net_buffer_length=8K 
    set-variable    = myisam_sort_buffer_size=8M 
    set-variable    = query_cache_size=12M 
    set-variable    = max_connections=400 
    set-variable    = wait_timeout=90 
    set-variable    = interactive_timeout=90 
    set-variable    = max_connect_errors=999999 
    set-variable    = max_delayed_threads=999999 
    
    # keep secure by default! 
    bind-address    = 127.0.0.1 
    port            = 3306 
    # this can make it even more secure: 
    #skip-networking 
    
    [mysqldump] 
    quick 
    set-variable    = max_allowed_packet=1M 
    
    [mysql] 
    #no-auto-rehash # faster start of mysql but no tab completition 
    
    [isamchk] 
    set-variable    = key_buffer=16M
    I am open for everything, please reply if you have ANY idea.

    thanks alot
    OS ???
    DB version ???

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    gentoo / mysql 4.0.17

  4. #4
    Join Date
    Mar 2004
    Posts
    4
    I just watched it via SSH, again alot restarts/crashs

    Number of processes running now: 0
    040302 17:28:54 mysqld restarted

    Number of processes running now: 0
    040302 17:30:26 mysqld restarted

    Number of processes running now: 0
    040302 17:31:09 mysqld restarted

    Number of processes running now: 3
    /usr/bin/mysqld_safe: line 305: kill: (27346) - No such process
    040302 17:33:18 mysqld restarted

    Number of processes running now: 0
    040302 17:33:20 mysqld restarted

    Number of processes running now: 0
    040302 17:34:34 mysqld restarted

  5. #5
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15

    How

    Do you start the mysql daemon ???

    pls send the init.d

    best regards,
    archm

  6. #6
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by comby
    gentoo / mysql 4.0.17
    Is your DB self compiled (emerge or classic way) or is a binary version downloaded from www.mysql.com?

  7. #7
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15
    I also think it is an compilation error. Seems the pathes are wrong and mysqld is started but another one tries to start too and both processes cause the problem

  8. #8
    Join Date
    Mar 2004
    Posts
    4
    well we had a problem, I've installed the binary from mysql.com once but then I used portage, currently it use the portage installation ...

    Maybe I should remove both installations and install one new with portage? Can someone tell me how I can remove all files releated to mysqld on the server?

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •