• Anirudh Mangipudi's avatar
    Bug #16776528 RACE CONDITION CAN CAUSE MYSQLD TO REMOVE SOCKET FILE ERRANTLY · 8977c8fa
    Anirudh Mangipudi authored
    Problem Description:
    A mysqld_safe instance is started. An InnoDB crash recovery begins which takes
    few seconds to complete. During this crash recovery process happening, another
    mysqld_safe instance is started with the same server startup parameters. Since
    the mysqld's pid file is absent during the crash recovery process the second
    instance assumes there is no other process and tries to acquire a lock on the
    ibdata files in the datadir.  But this step fails and the 2nd instance keeps 
    retrying 100 times each with a delay of 1 second. Now after the 100 attempts, 
    the server goes down, but while going down it hits the mysqld_safe script's 
    cleanup section and without any check it blindly deletes the socket and pid 
    files. Since no lock is placed on the socket file, it gets deleted.
    
    Solution:
    We create a mysqld_safe.pid file in the datadir, which protects the presence 
    server instance resources by storing the mysqld_safe's process id in it. We
    place a check if the mysqld_safe.pid file is existing in the datadir. If yes
    then we check if the pid it contains is an active pid or not. If yes again,
    then the scripts logs an error saying "A mysqld_safe instance is already 
    running". Otherwise it will log the present mysqld_safe's pid into the 
    mysqld_safe.pid file.
    8977c8fa
mysqld_safe.sh 18.7 KB