MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 14th, 2013, 11:43 PM
Fabian1234 Fabian1234 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Posts: 2 Fabian1234 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 12 sec
Reputation Power: 0
The Pid File Error

Hello Guys,
i have a Pid file error since i upgraded to Version 5.6.9 rc.
First of all my.cnf:
Code:
port     = 3306
socket   = /var/lib/mysql/mysql.sock
#skip-locking
#skip-networking
#skip-innodb


#key_buffer=16M
#max_allowed_packet=1M
#table_cache=64
#sort_buffer=512K
#net_buffer_length=8K
#myisam_sort_buffer_size=8M
#server-id      = 1

# Point the following paths to different dedicated disks
#tmpdir  = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=4M
#set-variable   = bdb_max_lock=10000

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

Next Command:
Code:

[root@s16579201 mysql]# vi /etc/my.cnf
[root@s16579201 mysql]# tail -f /var/log/mysqld.log
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'MEMORY'
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'MRG_MYISAM'
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'MyISAM'
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'sha256_password'
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'mysql_old_password'
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'mysql_native_password'
2013-01-15 04:13:42 19691 [Note] Shutting down plugin 'binlog'
2013-01-15 04:13:42 19691 [Note] /usr/sbin/mysqld: Shutdown complete

130115 04:13:42 mysqld_safe mysqld from pid file /var/lib/mysql/s16579201.onlinehome-server.info.pid ended

Well i tried everything on google....really everything. I also reinstalled....cant figure it out. Would be nice if u can give me a hint.
Fabian

Reply With Quote
  #2  
Old January 15th, 2013, 05:16 AM
SimonJM SimonJM is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
 
Join Date: Mar 2006
Posts: 2,107 SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level) 
Time spent in forums: 1 Month 1 Week 1 Day 3 h 57 m 31 sec
Reputation Power: 1485
Am I missing something obvious here, like an actual error or error message? I don't spend much time looking through mysql logs but that looks like the log of a mysql session that was shutdown cleanly.
__________________
The moon on the one hand, the dawn on the other:
The moon is my sister, the dawn is my brother.
The moon on my left and the dawn on my right.
My brother, good morning: my sister, good night.
-- Hilaire Belloc

Reply With Quote
  #3  
Old January 15th, 2013, 02:13 PM
Fabian1234 Fabian1234 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Posts: 2 Fabian1234 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 12 sec
Reputation Power: 0
Well i solved the problem; but i cant say how. I try to explain a bit:
The first thing i did is, to check the my.cnf. My.cnf is pretty hard to handle and DONT DO ANYTHING there if u are not conform with it.
The second thing i did was the command:
serivce mysql start --skip-grant
Nothing special here. The server started (some innoDB tables were corrupted). Then in /var/lib/mysql there was an error file (yourhost.err). I just deleted this file. Normally you would think, that this doesent change anything. But for me it worked (even if i really dont know, if that was the reason).
Well maybe it helps someone

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > The Pid File Error

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap