[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Description changed: Symptoms are: After mysql server upgrades + restarts the old mysqld_safe keeps running and consumes 100% cpu, strace shows: wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... For more info see the dupes, particularily bug 105457. Does not happen always, for reliable test case see below. This is a bug (race condition) in dash, partly fixed by http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea . This fixes the test case and mysqld_safe, but introduces another regression: http://eeek.borgchat.net/lists/dash/msg00268.html (patch for that in the thread) TEST CASE: Script in the commit message (link above). Allows to reproduce this always, even on Karmic still. - SRU JUSTIFICATION: Obviously safe patch. - - PATCH: Attached, run mysqld_safe in bash instead of dash. - - REGRESSION POTENTIAL: Minimal. 1) Bash is a superset of dash. 2) Before - dash became the default sh, bash was used, we just revert that change. + (Proposed fix of using #!/bin/bash instead of #!/bin/sh is not as + straigtforward as expected. bash called as sh goes into sh compatibility + mode, called as bash it may behave subtle differently) NOTES: mysqld_safe was replaced by an upstart job in Lucid. But Hardy has support for 3 more years, justifiying a fix. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU To manage notifications about this bug go to: https://bugs.launchpad.net/maria/+bug/675185/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
I tested the testcase in the commit on Precise and there seem to no issue there (probably fixed there). Also, it is not the right approach to change #!/bin/sh to #!/bin/bash since former invokes POSIX compatibility mode and if dash has problems on any platform, then that should be fixed rather than changing it in mysqld_safe or #!/bin/sh needs to pointed elsewhere (or with update-alternatives). Regarding the init scripts, I see that Percona Server is not packaged with upstart script (hence vulnerable to this if on a platform with a buggy dash) as mysql-server-55 does. I will open a separate issue to add that. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU To manage notifications about this bug go to: https://bugs.launchpad.net/maria/+bug/675185/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
lp:1053183 is the issue for providing upstart scripts with percona- server. ** Changed in: percona-server/5.5 Status: New = Invalid ** Changed in: percona-server/5.1 Status: New = Invalid -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU To manage notifications about this bug go to: https://bugs.launchpad.net/maria/+bug/675185/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Also affects: percona-server/5.1 Importance: Undecided Status: New ** Also affects: percona-server/5.5 Importance: Medium Status: New ** Changed in: percona-server/5.1 Assignee: (unassigned) = Ignacio Nin (ignacio-nin) ** Changed in: percona-server/5.5 Assignee: (unassigned) = Ignacio Nin (ignacio-nin) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU To manage notifications about this bug go to: https://bugs.launchpad.net/maria/+bug/675185/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Tags added: testcase -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU To manage notifications about this bug go to: https://bugs.launchpad.net/maria/+bug/675185/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Also affects: percona-server Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Package changed: mysql-dfsg-5.0 (Ubuntu) = mysql-5.1 (Ubuntu) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-5.1 in Ubuntu. https://bugs.launchpad.net/bugs/675185 Title: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Changed in: maria Milestone: None = 5.1 -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
Please get this fixed in natty first (or at least alongside). The patch looks okay as a minimal workaround, so please get it uploaded. -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
Thing is, mysqld_safe isn't used anymore since Lucid as upstart has taken over (the file is still there though). ** Description changed: Symptoms are: After mysql server upgrades + restarts the old mysqld_safe keeps running and consumes 100% cpu, strace shows: wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... For more info see the dupes, particularily bug 105457. Does not happen always, for reliable test case see below. - This is a bug (race condition) in dash, fixed by + This is a bug (race condition) in dash, partly fixed by http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea - . + . This fixes the test case and mysqld_safe, but introduces another + regression: http://eeek.borgchat.net/lists/dash/msg00268.html (patch for + that in the thread) TEST CASE: Script in the commit message (link above). Allows to reproduce this always, even on Karmic still. SRU JUSTIFICATION: Obviously safe patch. PATCH: Attached, run mysqld_safe in bash instead of dash. REGRESSION POTENTIAL: Minimal. 1) Bash is a superset of dash. 2) Before dash became the default sh, bash was used, we just revert that change. NOTES: mysqld_safe will be replaced by an upstart job. But Hardy has support for 3 more years, justifiying a fix. ** Description changed: Symptoms are: After mysql server upgrades + restarts the old mysqld_safe keeps running and consumes 100% cpu, strace shows: wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... For more info see the dupes, particularily bug 105457. Does not happen always, for reliable test case see below. This is a bug (race condition) in dash, partly fixed by http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea . This fixes the test case and mysqld_safe, but introduces another regression: http://eeek.borgchat.net/lists/dash/msg00268.html (patch for that in the thread) TEST CASE: Script in the commit message (link above). Allows to reproduce this always, even on Karmic still. SRU JUSTIFICATION: Obviously safe patch. PATCH: Attached, run mysqld_safe in bash instead of dash. REGRESSION POTENTIAL: Minimal. 1) Bash is a superset of dash. 2) Before dash became the default sh, bash was used, we just revert that change. - NOTES: mysqld_safe will be replaced by an upstart job. But Hardy has - support for 3 more years, justifiying a fix. + NOTES: mysqld_safe was replaced by an upstart job in Lucid. But Hardy + has support for 3 more years, justifiying a fix. -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
I fixed this for mariadb by adding a patch to the .deb packaging that puts #!/bin/bash in the header of mysqld_safe. Fix will be available from 5.1.52 and 5.2.4. ** Changed in: maria Status: In Progress = Fix Committed -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Changed in: maria Status: New = In Progress ** Changed in: maria Assignee: (unassigned) = Kristian Nielsen (knielsen) ** Changed in: maria Importance: Undecided = Medium -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
Be sure to verify that the script works with bash's non-POSIX mode as well. A not so well known feature of bash is that it enters POSIX mode when called as sh. This causes various subtle differences. Therefore, a #!/bin/sh script with /bin/sh - bash might behave differently from a #!/bin/bash script. -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
Thanks for the patch, can you follow the process outlined by: https://wiki.ubuntu.com/StableReleaseUpdates thanks chuck ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New = Confirmed -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Patch added: fix.diff https://bugs.launchpad.net/bugs/675185/+attachment/1733135/+files/fix.diff ** Description changed: Symptoms are: After mysql server upgrades + restarts the old mysqld_safe keeps running and consumes 100% cpu, strace shows: - 14:18:18.789847 wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) - 14:18:18.789920 wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) - 14:18:18.789992 wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) + wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) + wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) + wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) For more info see the dupes, particularily bug 105457. Does not happen always, for reliable test case see below. This is a bug (race condition) in dash, fixed by http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea . TEST CASE: Script in the commit message (link above). Allows to reproduce this always, even on Karmic still. SRU JUSTIFICATION: Obviously safe patch. PATCH: Attached, run mysqld_safe in bash instead of dash. REGRESSION POTENTIAL: Minimal. 1) Bash is a superset of dash. 2) Before dash became the default sh, bash was used, we just revert that change. NOTES: mysqld_safe will be replaced by an upstart job. But Hardy has support for 3 more years, justifiying a fix. ** Description changed: Symptoms are: After mysql server upgrades + restarts the old mysqld_safe keeps running and consumes 100% cpu, strace shows: - wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) - wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) - wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child processes) + wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... + wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... + wait4(4294967295, 0x7fffb3b3d59c, 0, NULL) = -1 ECHILD (No child ... For more info see the dupes, particularily bug 105457. Does not happen always, for reliable test case see below. This is a bug (race condition) in dash, fixed by http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea . TEST CASE: Script in the commit message (link above). Allows to reproduce this always, even on Karmic still. SRU JUSTIFICATION: Obviously safe patch. PATCH: Attached, run mysqld_safe in bash instead of dash. REGRESSION POTENTIAL: Minimal. 1) Bash is a superset of dash. 2) Before dash became the default sh, bash was used, we just revert that change. NOTES: mysqld_safe will be replaced by an upstart job. But Hardy has support for 3 more years, justifiying a fix. ** Also affects: maria Importance: Undecided Status: New -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Also affects: dash (Ubuntu) Importance: Undecided Status: New -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 675185] Re: [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU
** Tags added: patch -- [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU https://bugs.launchpad.net/bugs/675185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs