[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Hi Chris, Clint The fix has solved the issue. Thank you for your help! Leonardo -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu Lucid) Assignee: Chris J Arges (christopherarges) = (unassigned) ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: Fix Committed = Fix Released ** Changed in: mysql-5.1 (Ubuntu) Status: Confirmed = Fix Released -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Hi Chris, Clint The fix has solved the issue. Thank you for your help! Leonardo -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu Lucid) Assignee: Chris J Arges (christopherarges) = (unassigned) ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: Fix Committed = Fix Released ** Changed in: mysql-5.1 (Ubuntu) Status: Confirmed = Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Hi Guys, The test script has been running since last friday and no issues so far. I believe this issue is fixed. Thank you again. Leonardo -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Hi Guys, The test script has been running since last friday and no issues so far. I believe this issue is fixed. Thank you again. Leonardo -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Unsubscribing ubuntu-sponsors as there's nothing to sponsor here, please resubscribe if something needs to be uploaded. -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
With the security update to mysql 5.1.61 that is in lucid-proposed, this should resolved. Linking to upstream bug and marking Fix Committed. Should be Fix Released once 5.1.61 lands in lucid-security/lucid- updates. ** Bug watch added: MySQL Bug System #34236 http://bugs.mysql.com/bug.php?id=34236 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=34236 Importance: Unknown Status: Unknown ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: In Progress = Fix Released ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: Fix Released = Fix Committed -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Unsubscribing ubuntu-sponsors as there's nothing to sponsor here, please resubscribe if something needs to be uploaded. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
With the security update to mysql 5.1.61 that is in lucid-proposed, this should resolved. Linking to upstream bug and marking Fix Committed. Should be Fix Released once 5.1.61 lands in lucid-security/lucid- updates. ** Bug watch added: MySQL Bug System #34236 http://bugs.mysql.com/bug.php?id=34236 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=34236 Importance: Unknown Status: Unknown ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: In Progress = Fix Released ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: Fix Released = Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Hi Chris, I left a test case running since yesterday and so far it looks promising no segfaults at all. I'll get back to you by the end of the day. Tks Leo -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Hi Chris, I left a test case running since yesterday and so far it looks promising no segfaults at all. I'll get back to you by the end of the day. Tks Leo -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
A newer version of MySQL is in lucid-proposed: https://launchpad.net/ubuntu/+source/mysql-dfsg-5.1 Please update and verify this resolves the issue. ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: Confirmed = In Progress -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
A newer version of MySQL is in lucid-proposed: https://launchpad.net/ubuntu/+source/mysql-dfsg-5.1 Please update and verify this resolves the issue. ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: Confirmed = In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu Lucid) Assignee: (unassigned) = Chris J Arges (christopherarges) -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Description changed:
+ [Impact]
+ After running thousands of mysql queries on lucid, the mysql daemon
terminates with status 1. This can impact anybody doing a large number of
transactions on a system.
+
+ [Development Fix]
+ Backporting mysql from maverick (5.1.49) to lucid solves the issue. An effort
was made to backport specific patches from maverick to lucid, but the issue was
unable to be resolved.
+
+ [Stable Fix]
+ In order to fix this bug, a backport is requested from maverick to lucid.
+
+ [Test Case]
+ 1. Install Lucid + updates + LAMP stack
+ 2. Configure MySQL + SSL
+ 3. Create SSL certificates and configure the mysql client and server to use
the certificates:
http://dev.mysql.com/doc/refman/5.1/en/secure-create-certs.html
+
+ Add ssl options to /etc/mysql/my.cnf on the Server:
+ In the section [mysql] add:
+ ssl-ca=/etc/mysql/ca-cert.pem
+ ssl-cert=/etc/mysql/server-cert.pem
+ ssl-key=/etc/mysql/server-key.pem
+
+ On the client:
+ In the section [client] add:
+ ssl-ca=/etc/mysql/ca-cert.pem
+ ssl-cert=/etc/mysql/client-cert.pem
+ ssl-key=/etc/mysql/client-key.pem
+
+ 4. Test the SSL connection using mysql command line:
+ # mysql --ssl -p
+
+ show variables like “%ssl%” (value should be “YES” for “have_openssl”)
+
+ \s (output should include “SSL: Cipher in use is”)
+
+ 5. Force the mysql user account for the database driven website to use SSL:
+ update user set ssl_type=’X509’ where user=’USERNAME’; flush privileges;
+
+ 6. Bang the server using ab with a client script like the one below
+
+ ab
+
+ lborda@bordalnx:~/dev$ cat bb.php
+ ?php
+ error_reporting(E_ALL);
+ ini_set(display_errors, 1);
+ $obj = mysqli_init();
+ mysqli_options($obj, MYSQLI_OPT_CONNECT_TIMEOUT, 5);
+ mysqli_ssl_set( $obj,
+ '/etc/mysql/client-key.pem',
+ '/etc/mysql/client-cert.pem',
+ '/etc/mysql/ca-cert.pem',
+ NULL,
+ NULL);
+
+ $link = mysqli_real_connect($obj, '10.153.107.215', 'root', 'ubuntu',
'drupal1');
+ if (!$link)
+ {
+ die('br /br /Connect Error (' . mysqli_connect_errno() . ')
'.mysqli_connect_error());
+ }
+
+ echo 'Success... ' . mysqli_get_host_info($obj) . \n;
+
+ $obj-close();
+ ?
+
+ [Regression Potential]
+ There is potential since this is a backport.
+
+ --
+
On a server dedicated as a MySQL database server, MySQL keeps randomly
terminating with status 1 (from /var/log/daemon.log) and then immediately
starting again.
MySQL-Server version 5.1.49 seems to include the fix as per this bug entry:
http://bugs.mysql.com/bug.php?id=34236
Here are some timestamps from daemon.log from when Mysql terminated:
Jul 4 12:53:28 lightning init: mysql main process (9796) terminated with
status 1
Jul 4 22:28:31 lightning init: mysql main process (8123) terminated with
status 1
Jul 5 04:03:13 lightning init: mysql main process (20731) terminated with
status 1
MySQL Error logs describe the following stack trace. probably due to the use
of yaSSL when configuring mysql to use ssl.
http://bugs.mysql.com/bug.php?id=34236
*** PS: The server uses SSL connections through MySQL ***
110721 11:17:02 - mysqld got signal 11 ;
key_buffer_size=524288000
read_buffer_size=131072
max_used_connections=13
max_threads=151
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 842111 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0x7f1d3406c780
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f1d3be68e58 thread_stack 0x3
/usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f1d64bb51a9]
/usr/sbin/mysqld(handle_segfault+0x404) [0x7f1d648c2884]
/lib/libpthread.so.0(+0xf8f0) [0x7f1d641338f0]
/usr/sbin/mysqld(yaSSL::SSL_SESSION::GetBornOn() const+0) [0x7f1d64bf1170]
/usr/sbin/mysqld(yaSSL::Sessions::Flush()+0x35) [0x7f1d64bf28e5]
/usr/sbin/mysqld(yaSSL::sendFinished(yaSSL::SSL, yaSSL::ConnectionEnd,
yaSSL::BufferOutput)+0x5f0) [0x7f1d64bff1d0]
/usr/sbin/mysqld(yaSSL_accept+0x114) [0x7f1d64be5194]
/usr/sbin/mysqld(+0x636f60) [0x7f1d64b99f60]
/usr/sbin/mysqld(+0x369ad6) [0x7f1d648ccad6]
/usr/sbin/mysqld(handle_one_connection+0x135) [0x7f1d648cd545]
/lib/libpthread.so.0(+0x69ca) [0x7f1d6412a9ca]
/lib/libc.so.6(clone+0x6d) [0x7f1d62c6070d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at (nil) is an invalid pointer
thd-thread_id=42360
thd-killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
110721 11:17:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB:
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu) Status: Invalid = Confirmed -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu Lucid) Assignee: (unassigned) = Chris J Arges (christopherarges) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Description changed:
+ [Impact]
+ After running thousands of mysql queries on lucid, the mysql daemon
terminates with status 1. This can impact anybody doing a large number of
transactions on a system.
+
+ [Development Fix]
+ Backporting mysql from maverick (5.1.49) to lucid solves the issue. An effort
was made to backport specific patches from maverick to lucid, but the issue was
unable to be resolved.
+
+ [Stable Fix]
+ In order to fix this bug, a backport is requested from maverick to lucid.
+
+ [Test Case]
+ 1. Install Lucid + updates + LAMP stack
+ 2. Configure MySQL + SSL
+ 3. Create SSL certificates and configure the mysql client and server to use
the certificates:
http://dev.mysql.com/doc/refman/5.1/en/secure-create-certs.html
+
+ Add ssl options to /etc/mysql/my.cnf on the Server:
+ In the section [mysql] add:
+ ssl-ca=/etc/mysql/ca-cert.pem
+ ssl-cert=/etc/mysql/server-cert.pem
+ ssl-key=/etc/mysql/server-key.pem
+
+ On the client:
+ In the section [client] add:
+ ssl-ca=/etc/mysql/ca-cert.pem
+ ssl-cert=/etc/mysql/client-cert.pem
+ ssl-key=/etc/mysql/client-key.pem
+
+ 4. Test the SSL connection using mysql command line:
+ # mysql --ssl -p
+
+ show variables like “%ssl%” (value should be “YES” for “have_openssl”)
+
+ \s (output should include “SSL: Cipher in use is”)
+
+ 5. Force the mysql user account for the database driven website to use SSL:
+ update user set ssl_type=’X509’ where user=’USERNAME’; flush privileges;
+
+ 6. Bang the server using ab with a client script like the one below
+
+ ab
+
+ lborda@bordalnx:~/dev$ cat bb.php
+ ?php
+ error_reporting(E_ALL);
+ ini_set(display_errors, 1);
+ $obj = mysqli_init();
+ mysqli_options($obj, MYSQLI_OPT_CONNECT_TIMEOUT, 5);
+ mysqli_ssl_set( $obj,
+ '/etc/mysql/client-key.pem',
+ '/etc/mysql/client-cert.pem',
+ '/etc/mysql/ca-cert.pem',
+ NULL,
+ NULL);
+
+ $link = mysqli_real_connect($obj, '10.153.107.215', 'root', 'ubuntu',
'drupal1');
+ if (!$link)
+ {
+ die('br /br /Connect Error (' . mysqli_connect_errno() . ')
'.mysqli_connect_error());
+ }
+
+ echo 'Success... ' . mysqli_get_host_info($obj) . \n;
+
+ $obj-close();
+ ?
+
+ [Regression Potential]
+ There is potential since this is a backport.
+
+ --
+
On a server dedicated as a MySQL database server, MySQL keeps randomly
terminating with status 1 (from /var/log/daemon.log) and then immediately
starting again.
MySQL-Server version 5.1.49 seems to include the fix as per this bug entry:
http://bugs.mysql.com/bug.php?id=34236
Here are some timestamps from daemon.log from when Mysql terminated:
Jul 4 12:53:28 lightning init: mysql main process (9796) terminated with
status 1
Jul 4 22:28:31 lightning init: mysql main process (8123) terminated with
status 1
Jul 5 04:03:13 lightning init: mysql main process (20731) terminated with
status 1
MySQL Error logs describe the following stack trace. probably due to the use
of yaSSL when configuring mysql to use ssl.
http://bugs.mysql.com/bug.php?id=34236
*** PS: The server uses SSL connections through MySQL ***
110721 11:17:02 - mysqld got signal 11 ;
key_buffer_size=524288000
read_buffer_size=131072
max_used_connections=13
max_threads=151
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 842111 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0x7f1d3406c780
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f1d3be68e58 thread_stack 0x3
/usr/sbin/mysqld(my_print_stacktrace+0x29) [0x7f1d64bb51a9]
/usr/sbin/mysqld(handle_segfault+0x404) [0x7f1d648c2884]
/lib/libpthread.so.0(+0xf8f0) [0x7f1d641338f0]
/usr/sbin/mysqld(yaSSL::SSL_SESSION::GetBornOn() const+0) [0x7f1d64bf1170]
/usr/sbin/mysqld(yaSSL::Sessions::Flush()+0x35) [0x7f1d64bf28e5]
/usr/sbin/mysqld(yaSSL::sendFinished(yaSSL::SSL, yaSSL::ConnectionEnd,
yaSSL::BufferOutput)+0x5f0) [0x7f1d64bff1d0]
/usr/sbin/mysqld(yaSSL_accept+0x114) [0x7f1d64be5194]
/usr/sbin/mysqld(+0x636f60) [0x7f1d64b99f60]
/usr/sbin/mysqld(+0x369ad6) [0x7f1d648ccad6]
/usr/sbin/mysqld(handle_one_connection+0x135) [0x7f1d648cd545]
/lib/libpthread.so.0(+0x69ca) [0x7f1d6412a9ca]
/lib/libc.so.6(clone+0x6d) [0x7f1d62c6070d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd-query at (nil) is an invalid pointer
thd-thread_id=42360
thd-killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
110721 11:17:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB:
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu) Status: Invalid = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Update, Updating Ubuntu Lucid to Maverick fixes the issue. So the problem is between Lucid and Maverick versions. Going through the introduced patches will help fix the issue. The version the fixes the problem is the following: mysql-server: Installed: 5.1.49-1ubuntu8.1 Candidate: 5.1.49-1ubuntu8.1 Version table: *** 5.1.49-1ubuntu8.1 0 500 http://ca.archive.ubuntu.com/ubuntu/ maverick-updates/main amd64 Packages 500 http://security.ubuntu.com/ubuntu/ maverick-security/main amd64 Packages 100 /var/lib/dpkg/status 5.1.49-1ubuntu8 0 500 http://ca.archive.ubuntu.com/ubuntu/ maverick/main amd64 Packages Leonardo -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
Update, Updating Ubuntu Lucid to Maverick fixes the issue. So the problem is between Lucid and Maverick versions. Going through the introduced patches will help fix the issue. The version the fixes the problem is the following: mysql-server: Installed: 5.1.49-1ubuntu8.1 Candidate: 5.1.49-1ubuntu8.1 Version table: *** 5.1.49-1ubuntu8.1 0 500 http://ca.archive.ubuntu.com/ubuntu/ maverick-updates/main amd64 Packages 500 http://security.ubuntu.com/ubuntu/ maverick-security/main amd64 Packages 100 /var/lib/dpkg/status 5.1.49-1ubuntu8 0 500 http://ca.archive.ubuntu.com/ubuntu/ maverick/main amd64 Packages Leonardo -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Also affects: mysql-5.1 (Ubuntu Lucid) 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu) Status: New = Confirmed ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: New = Confirmed ** Changed in: mysql-5.1 (Ubuntu Lucid) Importance: Undecided = High ** Changed in: mysql-5.1 (Ubuntu) Status: Confirmed = Invalid ** Changed in: mysql-5.1 (Ubuntu Lucid) Milestone: None = lucid-updates -- 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/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+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 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Also affects: mysql-5.1 (Ubuntu Lucid) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 828036] Re: MySQL daemon keeps dying and restarting when using ssl connections
** Changed in: mysql-5.1 (Ubuntu) Status: New = Confirmed ** Changed in: mysql-5.1 (Ubuntu Lucid) Status: New = Confirmed ** Changed in: mysql-5.1 (Ubuntu Lucid) Importance: Undecided = High ** Changed in: mysql-5.1 (Ubuntu) Status: Confirmed = Invalid ** Changed in: mysql-5.1 (Ubuntu Lucid) Milestone: None = lucid-updates -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/828036 Title: MySQL daemon keeps dying and restarting when using ssl connections To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/828036/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
