| Bug #24781 | Mysqld dies after several hours, must kill process to restart it | ||
|---|---|---|---|
| Submitted: | 3 Dec 2006 22:21 | Modified: | 16 Feb 2007 9:11 |
| Reporter: | Mike Burgener | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | mysqld Ver 4.1.12 for mandriva-linux | OS: | |
| Assigned to: | CPU Architecture: | Any | |
[3 Dec 2006 22:21]
Mike Burgener
[4 Dec 2006 8:28]
Sveta Smirnova
Thank you for the report. Version you use is old. Please try using current MySQL 4.1.22 accessible from http://dev.mysql.com/downloads/mysql/4.1.html
[4 Dec 2006 8:38]
Mike Burgener
Do you know if there exist already packages fot mandriva 2006? Greets Mike Burgener
[4 Dec 2006 8:59]
Sveta Smirnova
Please, use Linux packages.
[5 Dec 2006 20:41]
Mike Burgener
I did install mysqld-4.1.19 on mandriva linux 2007 from urpmi packages, still get the same problem, can i upgrade that install with packages from mysql.com? Greets and Thanks in Advance
[5 Dec 2006 21:09]
Sveta Smirnova
Yes, you should upgrade from http://dev.mysql.com/downloads/mysql/4.1.html, because we don't support packages provided by anyone else.
[6 Dec 2006 8:35]
Mike Burgener
This is my Version Information from urpmi (smart) my glibc version information is on the bottom, which Package should i take to Upgrade from? And do i lost data when upgrading? Greets Mike Name: MySQL41 Version: 4.1.19-1mdv2007.0@i586 Priority: 0 Group: Databases Installed Size: 5.6MB Reference URLs: http://www.mysql.com Flags: Channels: RPM Database; contrib Summary: MySQL41: a very fast and reliable SQL database engine Description: The MySQL41(TM) software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL41 Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. MySQL41 is a trademark of MySQL41 AB. . The MySQL41 software has Dual Licensing, which means you can use the MySQL41 software free of charge under the GNU General Public License (http://www.gnu.org/licenses/). You can also purchase commercial MySQL41 licenses from MySQL41 AB if you do not wish to be bound by the terms of the GPL. See the chapter "Licensing and Support" in the manual for further info. . The MySQL41 web site (http://www.mysql.com/) provides the latest news and information about the MySQL41 software. Also please see the documentation and the manual for more information. . You can build MySQL41 with some conditional build swithes; . (ie. use with rpm --rebuild): --with debug Compile with debugging code (disabled), forces --with alltests --with test Initiate tests (enabled) --without test Disable test --with alltests Initiate tests for all built servers (disabled) Warning! This could take several hours... --without alltests Disable all tests Name: glibc Version: 6:2.4-4mdk@i586 Priority: 0 Group: System/Libraries Installed Size: 13.3MB Reference URLs: http://www.gnu.org/software/libc/ Flags: Channels: RPM Database; main Summary: The GNU libc libraries Description: The glibc package contains standard libraries which are used by multiple programs on the system. In order to save disk space and memory, as well as to make upgrading easier, common system code is kept in one place and shared between programs. This particular package contains the most important sets of shared libraries: the standard C library and the standard math library. Without these two libraries, a Linux system will not function. The glibc package also contains national language (locale) support.
[6 Dec 2006 9:06]
Sveta Smirnova
Dinamically linked Linux (x86) binaries. Your data won't be lost if you don't remove your data directory by self.
[6 Dec 2006 9:43]
Mike Burgener
Ok, Thank you very much I'll Upgrade this Evening and inform you if it Persists
[9 Jan 2007 15:43]
Sveta Smirnova
Status changed, because feedback from reporter is needed
[10 Jan 2007 10:18]
Mike Burgener
As i saw Mandriva 2007 uses the Original Source Distribution from mysql Version: '4.1.19' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr ibution I still have the same issue after several hours/days it is crashing I opened a Bugreport on mandriva Bugzilla at http://qa.mandriva.com/show_bug.cgi?id=27516 too
[10 Jan 2007 10:44]
Sveta Smirnova
Thank you for the feedback. But please note current 4.1 version is 4.1.22 and we have fixed many bugs since 4.1.19 has been released. So to process this bug here we need results of your test with current 4.1.22
[14 Jan 2007 11:19]
Mike Burgener
I Upgraded Today from Cooker Packages to mysql Ver 14.7 Distrib 4.1.22, for mandriva-linux-gnu (i586) using readline 5.1 Now i wait for a crash / no more crashed the next days to get feedback
[15 Jan 2007 11:04]
Sveta Smirnova
We will wait results of your test.
[16 Feb 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[16 Feb 2007 5:44]
Mike Burgener
I did not have an issue for nearle a month, so i will recommend the mandriva developers to backport the cooker package which i use now Greets and Thank u very much Mike Burgener
[16 Feb 2007 8:00]
Sveta Smirnova
Thank you for the test. I'll close this report as "Can't repeat"
[16 Feb 2007 9:11]
Mike Burgener
Close it as resolved, cause i updates to newest Mysql Packages from Mandriva Cooker and it runs, so it is resolved on current
