#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    2
    Rep 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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Mar 2006
    Posts
    2,450
    Rep Power
    1751
    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
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    2
    Rep 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

IMN logo majestic logo threadwatch logo seochat tools logo