Mailinglist Archive: opensuse-bugs (14787 mails)

[bugzilla_noreply@xxxxxxxxxx]

https://bugzilla.novell.com/show_bug.cgi?id=223209

           Summary: mysql stop script timeout too short
           Product: openSUSE 10.2
           Version: RC 1
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Network
        AssignedTo: mmarek@xxxxxxxxxx
        ReportedBy: dmueller@xxxxxxxxxx
         QAContact: qa@xxxxxxx


the mysql stop script does a standard killproc, which sends a -TERM and after 5
seconds a KILL to the daemon. This is not enough for a busy mysql daemon to
shut down, and consequently, your database is corrupted or in an inconsistent
state afterwards. 

the example scripts, as they come with the mysql distribution, have a TERM wait
of 35 and *no* kill. the debian mysql scripts issue a "mysqladmin shutdown"
instead, which is blocking until the daemon terminated. 


Whatever you decide for, but killing a daemon after 5 seconds is dangerous to
your data consistency. 

filing against 10.2 because I just learned this the hard way, but also
applicable to SLES10 (I guess).


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.