[MCOL-199] It is not possible to have mariadb RPM and columnstore RPM installed on same system Created: 2016-06-24  Updated: 2019-04-04  Resolved: 2019-04-04

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-1477 Support other install locations for n... Closed

 Description   

reported to google group:

  1. rpm -ihv mariadb-columnstore-1.0-1-x86_64-centos6-server.rpm
    Preparing... ########################################### [100%]

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.1.14-1.el6.x86_64) is installed.

The current MariaDB server package is provided by a different
vendor (Monty Program AB) than MariaDB AB. Some files may be installed
to different locations, including log files and the service
startup script in /usr/local/mariadb/columnstore/mysql/init.d/.

A manual upgrade is required.

  • Ensure that you have a complete, working backup of your data and my.cnf
    files
  • Shut down the MySQL server cleanly
  • Remove the existing MySQL packages. Usually this command will
    list the packages you should remove:
    rpm qa | grep -i '^mysql'

You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.

  • Install the new MariaDB packages supplied by MariaDB AB
  • Ensure that the MariaDB server is started
  • Run the 'mysql_upgrade' program

This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(mariadb-columnstore-server-1.0-1.el6.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping mariadb-columnstore-server-1.0-1.el6

 Comments   
Comment by Justin Swanhart (Inactive) [ 2016-06-24 ]

OS is 64 bit CentOS 6 (that is what el6 means) existing RPM installed is MariaDB-server-10.1.14-1.

Basically the columnstore RPM is built from the server source, and it thinks it is the same package as the regular server. Columnstore RPM doesn't know it lives in a different prefix. the pre-install scripts need modification.

Comment by Justin Swanhart (Inactive) [ 2016-06-24 ]

further problem:
columnstore will try to listen on same port as regular mariadb (3306) so both can not be installed at same time.

Comment by David Thompson (Inactive) [ 2016-10-11 ]

This is documented as a limitation and pre-requisite. More desirable for developer setup scenarios rather than production use cases so not a blocker for beta.

Comment by Andrew Hutchings (Inactive) [ 2019-04-04 ]

With the next major release ColumnStore will use a regular MariaDB server so this becomes irrelevant.

Generated at Thu Feb 08 02:19:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.