[MCOL-5018] Columnstore doesn't work on CentOS 7 debug RPM build: Internal error: Lost connection to DDLProc Created: 2022-03-15  Updated: 2022-05-11

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.6.4
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File columnstore_failure_logs.tar.gz    

 Description   

MariaDB server buildbot, among other variations, creates and tests debug CentOS 7 RPM packages.
Columnstore doesn't work on this build. An attempt to create a table deterministically fails with

ERROR 1815 (HY000) at line 1: Internal error: Lost connection to DDLProc

To reproduce, install a minimum set of RPM packages from such a build (depending on when you try to reproduce it, the build below may already be gone, just choose the latest available within the same version/builder):

wget http://hasky.askmonty.org/archive/10.5/build-46562/kvm-rpm-centos74-amd64-debug/rpms/MariaDB-columnstore-engine-10.5.16_5.6.4-1.el7.centos.x86_64.rpm
wget http://hasky.askmonty.org/archive/10.5/build-46562/kvm-rpm-centos74-amd64-debug/rpms/MariaDB-common-10.5.16-1.el7.centos.x86_64.rpm
wget http://hasky.askmonty.org/archive/10.5/build-46562/kvm-rpm-centos74-amd64-debug/rpms/MariaDB-server-10.5.16-1.el7.centos.x86_64.rpm
wget http://hasky.askmonty.org/archive/10.5/build-46562/kvm-rpm-centos74-amd64-debug/rpms/MariaDB-client-10.5.16-1.el7.centos.x86_64.rpm
wget http://hasky.askmonty.org/archive/10.5/build-46562/kvm-rpm-centos74-amd64-debug/rpms/MariaDB-shared-10.5.16-1.el7.centos.x86_64.rpm
wget http://hasky.askmonty.org/archive/10.5/build-46562/kvm-rpm-centos74-amd64-debug/rpms/MariaDB-compat-10.5.16-1.el7.centos.x86_64.rpm
wget http://hasky.askmonty.org/builds/mariadb-4.x/latest/kvm-rpm-centos74-amd64-gal/rpms/galera-4-26.4.11-1.el7.centos.x86_64.rpm
sudo yum install *.rpm

Restart mariadb-columnstore (optionally, it fails either way):

sudo systemctl stop mariadb-columnstore
sudo systemctl start mariadb-columnstore

Start mariadb service

sudo systemctl start mariadb

Try to create a table

sudo mysql -e "create database if not exists cs; use cs; create table t (a int) engine=columnstore"
ERROR 1815 (HY000) at line 1: Internal error: Lost connection to DDLProc

Columnstore logs are attached. The occurrence in question is at this timestamp:

[buildbot@centos74-amd64 rpms]$ sudo systemctl stop mariadb-columnstore
[buildbot@centos74-amd64 rpms]$ date
Tue Mar 15 17:26:47 UTC 2022
[buildbot@centos74-amd64 rpms]$ sudo systemctl start mariadb-columnstore
[buildbot@centos74-amd64 rpms]$ sudo systemctl start mariadb
[buildbot@centos74-amd64 rpms]$ sudo mysql -e "create database if not exists cs; use cs; create table t (a int) engine=columnstore"
ERROR 1815 (HY000) at line 1: Internal error: Lost connection to DDLProc

Non-debug builds of the same version/revision on the same platform usually work all right.

The difference in options:

Problematic debug build

cmake .  -DBUILD_CONFIG=mysql_release $NO_DEBUGINFO -DCMAKE_COMMAND_DEP=cmake -DRPM=centos74 -DCMAKE_BUILD_TYPE=Debug -DMYSQL_MAINTAINER_MODE=OFF

Normal release build

cmake .  -DBUILD_CONFIG=mysql_release $NO_DEBUGINFO -DCMAKE_COMMAND_DEP=cmake -DRPM=centos74


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