Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.35-galera
-
Fix Version/s: 5.5.36-galera
-
Component/s: None
-
Labels:
-
Environment:Debian squeeze (6.0.8) amd64 virtual machine on kvm
Description
After upgrading to mysql-galera-server-5.5 from 5.5.34 to 5.5.35 and keep galera package version to 23.2.7, mysql fail to start :
In mysql log file :
140214 16:55:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140214 16:55:11 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.AaT0zn' --pid-file='/var/lib/mysql/galera-node-recover.pid' 140214 16:55:13 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 140214 16:55:13 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1' 140214 16:55:13 [Note] WSREP: Read nil XID from storage engines, skipping position init 140214 16:55:13 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' 140214 16:55:13 [ERROR] WSREP: provider interface version mismatch: need '25', found '23' 140214 16:55:13 [ERROR] WSREP: wsrep_load(): interface version mismatch: my version 25, provider version 23 140214 16:55:13 [ERROR] WSREP: wsrep_load(/usr/lib/galera/libgalera_smm.so) failed: Invalid argument (22). Reverting to no provider. 140214 16:55:13 [Note] WSREP: Read nil XID from storage engines, skipping position init 140214 16:55:13 [Note] WSREP: wsrep_load(): loading provider library 'none' 140214 16:55:13 [ERROR] Aborting 140214 16:55:13 [Note] WSREP: Service disconnected. 140214 16:55:14 [Note] WSREP: Some threads may fail to exit. 140214 16:55:14 [Note] /usr/sbin/mysqld: Shutdown complete 140214 16:55:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
wsrep API version is 25 but there is no galera associate in 2.x (25.2.x) but just 3.x (25.3.2)
# apt-cache policy galera
galera:
Installed: 23.2.7
Candidate: 25.3.2
Version table:
25.3.2 0
500 http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian/ squeeze/main amd64 Packages
*** 23.2.7 0
100 /var/lib/dpkg/status
In dependencies, galera is set to >= 23.2. So it should be >= 25.2 but no packages are available in this version.
# aptitude show mariadb-galera-server-5.5
Package: mariadb-galera-server-5.5
New: yes
State: partially configured
Automatically installed: no
Version: 5.5.35+maria-1~squeeze
Priority: extra
Section: optional
Maintainer: MariaDB Developers <maria-developers@lists.launchpad.net>
Uncompressed Size: 82.0 M
Depends: mariadb-client-5.5 (>= 5.5.35+maria-1~squeeze), libdbi-perl, perl (>= 5.6), libaio1, libc6 (>= 2.7), libpam0g (>= 0.99.7.1), libssl0.9.8 (>= 0.9.8m-1), libstdc++6 (>= 4.1.1), zlib1g (>= 1:1.2.0), debconf (>= 0.5) |
debconf-2.0, psmisc, passwd, lsb-base (>= 3.0-10), libmariadbclient18 (>= 5.5.35+maria-1~squeeze), galera (>= 23.2)
PreDepends: mariadb-common, adduser (>= 3.40), debconf
Recommends: libhtml-template-perl
Suggests: tinyca, mailx, mariadb-test
Conflicts: mariadb-galera-server (< 5.5.35+maria-1~squeeze), mariadb-server, mariadb-server-5.1, mariadb-server-5.2, mariadb-server-5.3, mariadb-server-core-5.1, mariadb-server-core-5.2, mariadb-server-core-5.5,
mariadb-tokudb-engine-5.5, mysql-server, mysql-server-4.1, mysql-server-5.0, mysql-server-5.1, mysql-server-5.5, mysql-server-core-5.0, mysql-server-core-5.1, mysql-server-core-5.5
Replaces: libmariadbclient-dev (< 5.5.0), libmariadbclient16 (< 5.3.4), mariadb-galera-server (< 5.5.35+maria-1~squeeze), mariadb-server, mariadb-server-5.1, mariadb-server-5.2, mariadb-server-5.3, mariadb-server-core-5.1,
mariadb-server-core-5.2, mariadb-server-core-5.5, mariadb-tokudb-engine-5.5, mysql-server, mysql-server-4.1, mysql-server-5.0, mysql-server-5.1, mysql-server-5.5, mysql-server-core-5.0, mysql-server-core-5.1,
mysql-server-core-5.5
Provides: mariadb-galera-server, mysql-server, mysql-server-core, mysql-server-core-5.1, mysql-server-core-5.5, virtual-mysql-server
Description: MariaDB database server with Galera cluster binaries
MariaDB is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MariaDB are speed, robustness and
ease of use.
This package includes the server binaries.
Homepage: http://mariadb.org/
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Arturo, I also have an error for upgrading on debian7: https://mariadb.atlassian.net/browse/MDEV-5691 Can you see what you have in your /var/log/syslog output?
Pushed the fix to maria-5.5-galera.
What about the availability of a galera package 25.2.x ?
Because the fix will work with galera package 25.3.2 but there is not package available with version 25.2.x
Maybe open another issue for that ?
I can add 25.2.x galera packages to the MariaDB Galera Cluster 5.5.35 downloads page. Will do after the MariaDB Galera Cluster 10.0.7 Alpha is out.
Thank you Daniel 
Error after update mariadb-galera-server from 5.5.34 to 5.5.35 (on debian 7 wheezy x64)
dpkg: error al procesar mariadb-galera-server-5.5 (--configure):
el subproceso instalado el script post-installation devolvio el codigo de salida de error 1
dpkg: problemas de dependencias impiden la configuracion de mariadb-galera-server:
mariadb-galera-server depende de mariadb-galera-server-5.5 (= 5.5.35+maria-1~wheezy); sin embargo:
El paquete `mariadb-galera-server-5.5' no esta¡ configurado todavia.
dpkg: error al procesar mariadb-galera-server (--configure):
problemas de dependencias - se deja sin configurar
Se encontraron errores al procesar:
mariadb-galera-server-5.5
mariadb-galera-server
E: Sub-process /usr/bin/dpkg returned an error code (1)