Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5309

mariadb service crashing and restarting intermittently - status=11/SEGV (long in-list)

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 6.3.1
    • 22.08.7
    • None
    • None

    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

        1. Columnstore_CSX2.xml
          20 kB
        2. CSX2_PIXID_logs.tar.gz
          242 kB
        3. gigantic_query_list
          3.52 MB
        4. mariadb_errlog
          64 kB

        Issue Links

          Activity

            People

              drrtuy Roman
              michael.amadi Michael Amadi
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.