Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Fix
-
6.3.1
-
None
-
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL=" https://www.centos.org/ " BUG_REPORT_URL=" https://bugs.centos.org/ " CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7"
Description
Three nodes of Columnstore - When a Particular gigantic SELECT query is being run on either of the replica nodes of the cluster, the mariadb service goes into a restart loop. Checking the logs, it shows the below :
Nov 16 06:57:54 pixid-csx2 systemd: mariadb.service: main process exited, code=killed, status=11/SEGV
Nov 16 06:57:54 pixid-csx2 systemd: Unit mariadb.service entered failed state.
Nov 16 06:57:54 pixid-csx2 systemd: mariadb.service failed.
Nov 16 06:57:59 pixid-csx2 systemd: mariadb.service holdoff time over, scheduling restart.
Nov 16 06:57:59 pixid-csx2 systemd: Cannot add dependency job for unit systemd-tmpfiles-clean.timer, ignoring: Unit is masked.
Nov 16 06:57:59 pixid-csx2 systemd: Stopping pt-kill service...
Nov 16 06:57:59 pixid-csx2 systemd: Stopped pt-kill service.
Nov 16 06:57:59 pixid-csx2 systemd: Stopped MariaDB 10.6.7-3 database server.
Nov 16 06:57:59 pixid-csx2 systemd: Starting MariaDB 10.6.7-3 database server...
Cluster health is only restored after a restart, and the query is no longer executing.
Attachments
Issue Links
- causes
-
MCOL-5321 MCS plugin crashes MDB runtime for IN with a long(>4000) list of literals
- Closed