Thanks for your involvement and time in this problem.
To begin, here is the current status : for the moment we did not had any more errors or strange behaviour like we had a few hours after upgrading.
The system used here is a recnetly upgraded Debian Wheezy from Squeeze :
# cat /etc/debian_version
7.0
What is sure is that I tested again to upgrade a node (PXDBC 5.5.28 -> 5.5.29) on another cluster with Wheezy on it and had the same errors so this could be probably due to Debian Wheezy ? I do not have any Debian Squeeze with PXDB installed on it to test.
Here is the SHOW CREATE TABLE plugin output :
mysql> SHOW CREATE TABLE plugin;
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| plugin | CREATE TABLE `plugin` (
`name` varchar(64) NOT NULL DEFAULT '',
`dl` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins' |
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
For bash :
# which bash
/bin/bash
# ls -al /bin/bash
-rwxr-xr-x 1 root root 975488 Dec 30 02:39 /bin/bash
# dpkg -l bash
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-=======================================-========================-========================-====================================================================================
ii bash 4.2+dfsg-0.1 amd64 GNU Bourne Again SHell
For info, I have 2 nodes which are still using PXDBC 5.5.28 so I did not upgraded yet to 5.5.29 as this is a test cluster for the moment, so if you need me to do some tests that can be useful to you, don't hesitate, I will try to help.
Hi Ignacio,
Thanks for your involvement and time in this problem.
To begin, here is the current status : for the moment we did not had any more errors or strange behaviour like we had a few hours after upgrading.
The system used here is a recnetly upgraded Debian Wheezy from Squeeze :
# cat /etc/debian_version
7.0
What is sure is that I tested again to upgrade a node (PXDBC 5.5.28 -> 5.5.29) on another cluster with Wheezy on it and had the same errors so this could be probably due to Debian Wheezy ? I do not have any Debian Squeeze with PXDB installed on it to test.
Here is the SHOW CREATE TABLE plugin output :
mysql> SHOW CREATE TABLE plugin; --+---- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------+ --+---- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------+ --+---- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------+
+------
| Table | Create Table |
+------
| plugin | CREATE TABLE `plugin` (
`name` varchar(64) NOT NULL DEFAULT '',
`dl` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins' |
+------
1 row in set (0.00 sec)
For bash :
# which bash
/bin/bash
# ls -al /bin/bash
-rwxr-xr-x 1 root root 975488 Dec 30 02:39 /bin/bash
# dpkg -l bash Unknown/ Install/ Remove/ Purge/Hold Not/Inst/ Conf-files/ Unpacked/ halF-conf/ Half-inst/ trig-aWait/ Trig-pend /Reinst- required (Status,Err: uppercase=bad) ======= ======= ======= ======= ======= =-===== ======= ======= =====-= ======= ======= ======= ==-==== ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ===
Desired=
| Status=
|/ Err?=(none)
||/ Name Version Architecture Description
+++-===
ii bash 4.2+dfsg-0.1 amd64 GNU Bourne Again SHell
For info, I have 2 nodes which are still using PXDBC 5.5.28 so I did not upgraded yet to 5.5.29 as this is a test cluster for the moment, so if you need me to do some tests that can be useful to you, don't hesitate, I will try to help.
Thanks.
Regards,
Laurent