If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > mysql crash IMPORTANT

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-02-04, 11:20
comby comby is offline
Registered User
 
Join Date: Mar 2004
Posts: 4
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
Reply With Quote
  #2 (permalink)  
Old 03-02-04, 11:28
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Re: mysql crash IMPORTANT

Quote:
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 ???
Reply With Quote
  #3 (permalink)  
Old 03-02-04, 11:31
comby comby is offline
Registered User
 
Join Date: Mar 2004
Posts: 4
gentoo / mysql 4.0.17
Reply With Quote
  #4 (permalink)  
Old 03-02-04, 11:33
comby comby is offline
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old 03-03-04, 08:57
archm archm is offline
Registered User
 
Join Date: Mar 2004
Location: Germany
Posts: 15
How

Do you start the mysql daemon ???

pls send the init.d

best regards,
archm
Reply With Quote
  #6 (permalink)  
Old 03-03-04, 09:09
ika ika is offline
Registered User
 
Join Date: Oct 2003
Location: Slovakia
Posts: 482
Quote:
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?
Reply With Quote
  #7 (permalink)  
Old 03-03-04, 09:33
archm archm is offline
Registered User
 
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
Reply With Quote
  #8 (permalink)  
Old 03-03-04, 13:04
comby comby is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On