Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 11.0.2
    • N/A
    • Mariadb: docker mariadb:11.0.2
      Running in Nomad v.1.6.1 with no memory limit
      On host: ArchLinux latest 6.1.51-1-lts #1 SMP PREEMPT_DYNAMIC Sat, 02 Sep 2023 14:51:30 +0000 x86_64 GNU/Linux

    Description

      Thanks for making mariadb, it is great!

      FYI Mysql received a segfault. Nomad started auto-restarting it, and then it couldn't come up. I do not know for how long it was.

      I will update to 11.0.3, so you can ignore. Thanks!

      Attachments

        1. dmesg.txt
          1 kB
          Kamil Cukrowski
        2. stderr.txt
          148 kB
          Kamil Cukrowski
        3. stdout.txt
          2 kB
          Kamil Cukrowski

        Issue Links

          Activity

            Hi! Thank you for the report. The reports of corruption could match MDEV-31767. Can you check if an upgrade to MariaDB Server 11.0.3 would fix this?

            marko Marko Mäkelä added a comment - Hi! Thank you for the report. The reports of corruption could match MDEV-31767 . Can you check if an upgrade to MariaDB Server 11.0.3 would fix this?

            The crashes in stderr.txt probably occur somewhere inside InnoDB, during an INSERT operation. Unfortunately, the built-in stack trace report does not correctly resolve InnoDB symbols for some reason.

            Can you please try to follow the instructions https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ to produce a full stack trace of the crash? danblack should be able to assist you with setting up and using a debug image. We successfully used that to analyze MDEV-32049.

            Even though an upgrade to 11.0.3 may make the error go away, I would like to find and fix that crash, because InnoDB is not supposed to crash anymore, no matter what, in the spirit of MDEV-13542.

            marko Marko Mäkelä added a comment - The crashes in stderr.txt probably occur somewhere inside InnoDB, during an INSERT operation. Unfortunately, the built-in stack trace report does not correctly resolve InnoDB symbols for some reason. Can you please try to follow the instructions https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ to produce a full stack trace of the crash? danblack should be able to assist you with setting up and using a debug image. We successfully used that to analyze MDEV-32049 . Even though an upgrade to 11.0.3 may make the error go away, I would like to find and fix that crash, because InnoDB is not supposed to crash anymore, no matter what, in the spirit of MDEV-13542 .
            danblack Daniel Black added a comment - - edited

            First, can you build your own image from:

            Dockerfile

            FROM mariadb:11.0.2
             
            RUN sed -i -e 's/main/main main\/debug/' /etc/apt/sources.list.d/mariadb.list && \
                apt-get update \
                    && apt-get install -y linux-tools-common gdbserver gdb curl mariadb-server-core-dbgsym=11.0.2 ; \
                    rm -rf /var/lib/apt/lists/*
            

            buildah bud --tag m11.0.2debug .
            

            Other dockerfile builders obviously acceptable.

            podman run --user mysql -v volumename:/var/lib/mysql  m11.0.2debug   gdb -ex r -ex 'thread apply all bt -frame-arguments all full' --args  mariadbd
            

            Just translate the podman/docker cmd into how nomad runs things.

            danblack Daniel Black added a comment - - edited First, can you build your own image from: Dockerfile FROM mariadb:11.0.2   RUN sed -i -e 's/main/main main\/debug/' /etc/apt/sources.list.d/mariadb.list && \ apt-get update \ && apt-get install -y linux-tools-common gdbserver gdb curl mariadb-server-core-dbgsym=11.0.2 ; \ rm -rf /var/lib/apt/lists/* buildah bud --tag m11.0.2debug . Other dockerfile builders obviously acceptable. podman run --user mysql -v volumename:/var/lib/mysql m11.0.2debug gdb -ex r -ex 'thread apply all bt -frame-arguments all full' --args mariadbd Just translate the podman/docker cmd into how nomad runs things.

            As I updated to 11.0.3 and I do not have a way to reproduce, I believe this can be closed to cleanup. Thanks!

            KamilCukrowski Kamil Cukrowski added a comment - As I updated to 11.0.3 and I do not have a way to reproduce, I believe this can be closed to cleanup. Thanks!

            People

              marko Marko Mäkelä
              KamilCukrowski Kamil Cukrowski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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