[BlueOnyx:21652] Upgrading MariaDB 5.5 -> 10.2

[Aaron Greenspan]

Hi,

I’d like to upgrade to MariaDB 10.x. MariaDB 5.5 silently crashes about once per day, maybe because it’s out of memory—I’m not sure. Here’s what that looks like (spontaneous restart at line 3):

180107 23:30:12 [ERROR] mysqld: Table './x/y' is marked as crashed and should be repaired
180107 23:30:12 [Warning] Checking table:   './x/y'
180108 03:01:36 mysqld_safe Number of processes running now: 0
180108 03:01:36 mysqld_safe mysqld restarted
180108 03:01:37 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.LDvY87' --pid-file='/var/lib/mysql/x.y.com-recover.pid'
180108 03:32:28 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
180108  3:32:28 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
180108  3:32:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180108  3:32:28 InnoDB: Compressed tables use zlib 1.2.7
180108  3:32:28 InnoDB: Using Linux native AIO
180108  3:32:28 InnoDB: Initializing buffer pool, size = 20.0G
180108  3:32:28 InnoDB: Completed initialization of buffer pool
180108  3:32:28 InnoDB: highest supported file format is Barracuda.
180108  3:32:30  InnoDB: Waiting for the background threads to start
180108  3:32:31 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 200824050134
180108  3:32:31 [Note] Plugin 'FEEDBACK' is disabled.
180108  3:32:31 [Note] Server socket created on IP: '0.0.0.0'.
180108  3:32:31 [Note] Event Scheduler: Loaded 0 events
180108  3:32:31 [Note] WSREP: Read nil XID from storage engines, skipping position init
180108  3:32:31 [Note] WSREP: wsrep_load(): loading provider library 'none'
180108  3:32:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.40-MariaDB-wsrep'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server, wsrep_25.11.r4026

Regardless, I’m running into a dependency issue:

base-mysql-capstone-2.4.0-0BX29.el7.noarch

appears to depend on

mariadb-galera-server-5.5.40-4.el7.x86_64

I don’t use MariaDB Galera Server (which I guess is for clustering), but I can’t remove it without affecting BlueOnyx, and MariaDB 10.2 doesn’t want to install while it’s there:

—

Transaction check error:
  file /usr/bin/mysql_plugin from install of MariaDB-client-10.2.12-1.el7.centos.x86_64 conflicts with file from package mariadb-galera-server-1:5.5.40-4.el7.x86_64
  file /usr/share/man/man1/msql2mysql.1.gz from install of MariaDB-client-10.2.12-1.el7.centos.x86_64 conflicts with file from package mariadb-galera-server-1:5.5.40-4.el7.x86_64
  file /usr/share/man/man1/mysql_plugin.1.gz from install of MariaDB-client-10.2.12-1.el7.centos.x86_64 conflicts with file from package mariadb-galera-server-1:5.5.40-4.el7.x86_64
  file /usr/share/man/man1/mysqlbinlog.1.gz from install of MariaDB-client-10.2.12-1.el7.centos.x86_64 conflicts with file from package mariadb-galera-server-1:5.5.40-4.el7.x86_64
  file /usr/share/man/man1/mysqlcheck.1.gz from install of MariaDB-client-10.2.12-1.el7.centos.x86_64 conflicts with file from package mariadb-galera-server-1:5.5.40-4.el7.x86_64
  file /usr/share/man/man1/mysqlimport.1.gz from install of MariaDB-client-10.2.12-1.el7.centos.x86_64 conflicts with file from package mariadb-galera-server-1:5.5.40-4.el7.x86_64

—

MariaDB says (https://mariadb.com/kb/en/library/yum/):

"If the server already has the MariaDB-Galera-server package installed, you might need to remove it prior to installing MariaDB-server (with 'sudo yum remove MariaDB-Galera-server'). No databases are removed when the MariaDB-Galera-server rpm package is removed, but as with any upgrade, it is best to have backups."

Is this dependency really necessary?

Thanks,

Aaron

 <http://www.thinkcomputer.com/>	
Aaron Greenspan
President & CEO
Think Computer Corporation

telephone +1 415 670 9350
fax +1 415 373 3959
e-mail aarong at thinkcomputer.com
web http://www.thinkcomputer.com