Improve installation procedure and reduce SQL limitations (MCOL-3686)

[MCOL-3718] Use MariaDB system instead of mysql-Columnstore Created: 2020-01-10  Updated: 2020-02-28  Resolved: 2020-02-18

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

Type: Sub-Task Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MCOL-3793 LDI with columnstore_use_import_for_b... Closed
Sprint: 2020-1, 2020-2, 2020-4, 2020-5, 2020-6, 2020-7

 Description   

When ColumnStore is running and MariaDB's systemd stop is used mysql-Columnstore will restart it. We should use MariaDB's systemd for start/stop instead.

 Comments   
Comment by David Hall (Inactive) [ 2020-02-11 ]

Ben asked a question in the PR. I don't understand what he's asking

Comment by Andrew Hutchings (Inactive) [ 2020-02-12 ]

Race condition could have caused "mcsadmin restart" to hang. This is now fixed in the PR

Comment by Daniel Lee (Inactive) [ 2020-02-14 ]

Caused the issue in MCOL-3793

Comment by Daniel Lee (Inactive) [ 2020-02-18 ]

Build verified: 1.4.3-1 BB nightly

engine commit:
1a65d34

1.4.2-1
[root@localhost columnstore_tmp_files]# cat actionMysqlCalpont.log
Starting MySQL. SUCCESS!

1.4.3-1

[root@localhost columnstore_tmp_files]# cat actionMysqlCalpont.log
● mariadb.service - MariaDB 10.4.12-6 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: inactive (dead)
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/

Feb 18 16:55:36 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:36 0 [Note] Event Scheduler: Purging the queue. 0 events
Feb 18 16:55:36 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:36 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 18 16:55:36 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:36 server_audit: STOPPED
Feb 18 16:55:36 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:36 0 [Note] InnoDB: Starting shutdown...
Feb 18 16:55:36 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:36 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Feb 18 16:55:36 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:36 0 [Note] InnoDB: Buffer pool(s) dump completed at 200218 16:55:36
Feb 18 16:55:38 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:38 0 [Note] InnoDB: Shutdown completed; log sequence number 77050; transaction id 50
Feb 18 16:55:38 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Feb 18 16:55:38 localhost.localdomain mysqld[14913]: 2020-02-18 16:55:38 0 [Note] /usr/sbin/mysqld: Shutdown complete
Feb 18 16:55:38 localhost.localdomain systemd[1]: Stopped MariaDB 10.4.12-6 database server.

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