Ubuntu
linux package

MySQL Socket Sharing in OpenVZ

Bug #268974 reported by Ubuntu Server User
4
Affects Status Importance Assigned to Milestone
Linux
Unknown
Unknown
linux (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

Using "mount --bind" available at http://sudhaker.com/2008/04/isolated-mysql-installation-openvz-cluster/, but I couldn't get it to work. Also the "ln /var/lib/vz/private/101/var/run/mysqld/mysqld.sock ..." mentioned in the article http://wiki.openvz.org/Shared_webhosting" does not work for me

Additionally, "mysql -u root -p -S /vz/root/123/var/run/mysqld/mysqld.sock" fails with:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/vz/root/1234/var/run/mysqld/mysqld.sock' (111)

Hardware node (Ubuntu Server) : Linux hn2 2.6.24-19-openvz #1 SMP Wed Aug 20 22:07:43 UTC 2008 x86_64 GNU/Linux
Virtual mysql server node (debian): mysqld Ver 5.0.32-Debian_7etch6 for pc-linux-gnu on x86_64 (Debian etch distribution)
Virtual mysql client node (debian): mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2

Revision history for this message
jyio (inportb) wrote :

Indeed... this is a pretty obvious problem; it was working fine before I switched from Debian :X
I guess using TCP networking would be a non-optimal workaround.

Revision history for this message
Ubuntu Server User (sss-ltd) wrote :

> I guess using TCP networking would be a non-optimal workaround.
Yes, non-optimal. CPU usage - http://pix.academ.org/img/2008/10/01/c9ac14fecd7353f978b75ace4de26f21

Revision history for this message
jyio (inportb) wrote :

Ouch.

It looks like a kernel bug. Apparently, it's also present in the 2.6.26 development version, but not in 2.6.18 (in the stable Debian Etch repos).

Revision history for this message
jyio (inportb) wrote :

Sorry, I forgot to attach a link: http://bugzilla.openvz.org/show_bug.cgi?id=985

It looks like there's a patch, but I've never compiled a kernel before :X

Revision history for this message
Ubuntu Server User (sss-ltd) wrote :

This patch working fine.
http://pix.academ.org/img/2008/12/05/d9365389638a7eb51e82487fd6dc653f

> It looks like there's a patch, but I've never compiled a kernel before :X
https://help.ubuntu.com/community/Kernel/Compile

Revision history for this message
kernel-janitor (kernel-janitor) wrote :

Hi Ubuntu,

This bug was reported a while ago and there hasn't been any activity in it recently. We were wondering if this is still an issue? Can you try with the latest development release of Ubuntu? ISO CD images are available from http://cdimage.ubuntu.com/releases/ .

If it remains an issue, could you run the following command from a Terminal (Applications->Accessories->Terminal). It will automatically gather and attach updated debug information to this report.

apport-collect -p linux 268974

Also, if you could test the latest upstream kernel available that would be great. It will allow additional upstream developers to examine the issue. Refer to https://wiki.ubuntu.com/KernelMainlineBuilds . Once you've tested the upstream kernel, please remove the 'needs-upstream-testing' tag. This can be done by clicking on the yellow pencil icon next to the tag located at the bottom of the bug description and deleting the 'needs-upstream-testing' text. Please let us know your results.

Thanks in advance.

[This is an automated message. Apologies if it has reached you inappropriately; please just reply to this message indicating so.]

tags: added: needs-kernel-logs
tags: added: needs-upstream-testing
tags: added: kj-triage
Changed in linux (Ubuntu):
status: New → Incomplete
Revision history for this message
Jeremy Foshee (jeremyfoshee) wrote :

This bug report was marked as Incomplete and has not had any updated comments for quite some time. As a result this bug is being closed. Please reopen if this is still an issue in the current Ubuntu release http://www.ubuntu.com/getubuntu/download . Also, please be sure to provide any requested information that may have been missing. To reopen the bug, click on the current status under the Status column and change the status back to "New". Thanks.

[This is an automated message. Apologies if it has reached you inappropriately; please just reply to this message indicating so.]

tags: added: kj-expired
Changed in linux (Ubuntu):
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.