Plesk 10.4.4 on Ubuntu Hardy: Last weeks MySQL upgrade

[Tozz]

We upgraded MySQL packages on our Plesk machines yesterday, and this seems to have caused problems on a machine with Ubuntu Hardy. When logging in to the Plesk interface we get:

ERROR: Exception
[MySQL][ODBC 3.51 Driver][mysqld-5.0.95-0ubuntu1]Memory allocation error

As Oracle wasn't very clear about the security fixes, both Debian as Ubuntu have shipped a new upstream version of mysql-server. Could it be the installed ODBC driver's are incompatible with this release of mysql-server?

Is this a known issue?

 

[BettaC]

+1 for the same issue, anyone fixed this yet?

 

[Tozz]

I have fixed this issue by downgrading (downgrading the upgraded packages) MySQL and its related packages.

libmysqlclient15-dev
mysql-client
mysql-common
mysql-server

You can download them from any Ubuntu mirror, eg:
http://nl.archive.ubuntu.com/ubuntu/pool/main/m/mysql-dfsg-5.0/

Download them using wget, then install them using dpkg -i *.deb

 

[BettaC]

Thanks for the post. I have completed your steps but still have the same error in my plesk panel

### Logs from install

# dpkg -i *.deb
Selecting previously deselected package libmysqlclient15-dev.
(Reading database ... 205225 files and directories currently installed.)
Unpacking libmysqlclient15-dev (from libmysqlclient15-dev_5.0.51a-3ubuntu5_i386.deb) ...
dpkg - warning: downgrading mysql-client-5.0 from 5.0.95-0ubuntu1 to 5.0.51a-3ubuntu5.
Preparing to replace mysql-client-5.0 5.0.95-0ubuntu1 (using mysql-client-5.0_5.0.51a-3ubuntu5_i386.deb) ...
Unpacking replacement mysql-client-5.0 ...
dpkg - warning: downgrading mysql-common from 5.0.95-0ubuntu1 to 5.0.51a-3ubuntu5.
Preparing to replace mysql-common 5.0.95-0ubuntu1 (using mysql-common_5.0.51a-3ubuntu5_all.deb) ...
Unpacking replacement mysql-common ...
dpkg - warning: downgrading mysql-server-5.0 from 5.0.95-0ubuntu1 to 5.0.51a-3ubuntu5.
Preparing to replace mysql-server-5.0 5.0.95-0ubuntu1 (using mysql-server-5.0_5.0.51a-3ubuntu5_i386.deb) ...
* Stopping MySQL database server mysqld [ OK ]
* Stopping MySQL database server mysqld [ OK ]
Unpacking replacement mysql-server-5.0 ...
dpkg: dependency problems prevent configuration of libmysqlclient15-dev:
libmysqlclient15-dev depends on zlib1g-dev; however:
Package zlib1g-dev is not installed.
dpkg: error processing libmysqlclient15-dev (--install):
dependency problems - leaving unconfigured
Setting up mysql-common (5.0.51a-3ubuntu5) ...
Setting up mysql-client-5.0 (5.0.51a-3ubuntu5) ...
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5) ...
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

Warning: option 'select_limit': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
Errors were encountered while processing:
libmysqlclient15-dev


It looks like a dep problem with zlib1g-dev, so I tried installing it... however..

# apt-get install zlib1g-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
libmysqlclient15off: Depends: mysql-common (>= 5.0.95-0ubuntu1) but 5.0.51a-3ubuntu5 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

Any ideas on howto resolve this would be great.

Thanks

 

[BettaC]

Resolved !!!!

had to install zlib1g-dev first and get libmysqlclient15off as well.. Thanks Tozz your a legend...

 

[BettaC]

Don't for get to prevent these packages for upgrading next time you run apt-get


echo mysql-common hold | sudo dpkg --set-selections
echo mysql-server-5.0 hold | sudo dpkg --set-selections
echo mysql-client-5.0 hold | sudo dpkg --set-selections
echo libmysqlclient15off hold | sudo dpkg --set-selections
echo libmysqlclient15-dev hold | sudo dpkg --set-selections

dpkg --get-selections | grep mysql
libdbd-mysql-perl install
libmysql-ruby1.8 install
libmysqlclient15-dev hold
libmysqlclient15off hold
mysql-client-5.0 hold
mysql-common hold
mysql-server-5.0 hold
php5-mysql install

 

[Bluesplat]

Hi,

I was wondering would someone have a step by step to fix this?

I upgraded as well and I'm experiencing the exact same problem but I'm far from an expert in Linux installing etc so have no idea where to being.

It would be appreciated big time!!

 

[IgorG]

The main reason of this issue is following:
Oracle has released new version of MySQL server for Ubuntu 8.04 but not released appropriate drivers like lib odbc for this version of MySQL. They are released it only for Ubuntu 10.04. Parallels never release packages for other vendors. Therefore you can do not use fresh version of MySQL or migrate to Ubuntu 10.04.

 

[IgorG]

http://kb.parallels.com/113620

 

[Bluesplat]

I'm running ubuntu-8.04 so that fix won't work for me.

How do I go about upgrading the OS or downgrading mysql?

 

[dako1312]

Hi,
I was wondering would someone have a step by step to fix this?

http://www.berlihost.de/mysql5bug.php

 

[Bluesplat]

http://www.berlihost.de/mysql5bug.php

Just tried going through that tutorial and on the first wget it failed with no error code.

Any thoughts?

 

[dako1312]

Maybe you can tell us the error code? ;-)

1.) make sure you are logged in as root
2.) type "cd #" to go to your home-directory before downloading
3.) make sure you have installed "wget" -> "apt-get install wget"

 

[Bluesplat]

That is the error I'm getting. i did the "cd" to go to the home directory checked to see if wget was installed and it was.

Followed the tutorial again and it gave the above error message.

(Thanks in advance for helping as well )

 

[dako1312]

You have an error code "0"...means NO error. Look in your directory, the file should be there! Continue with other files and install them.

I am wondering whats that for a window, why dont you use SSH-Client like Putty?

 

[Bluesplat]

I'm using WinSCP and using terminal through there.

But you where right, the log in the terminal window said the file was downloaded successfully! Continued with the other packages and I was able to fix my issue with your help.

Many many thanks for you help! Greatly appreciated

I'll be sure to drop you a message next time I have an issue as you seem to know what you are talking about