Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18486

Database crash on a table with indexed virtual column

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.2.15, 10.3.11, 10.2(EOL), 10.3(EOL), 10.4(EOL)
    • 10.2.23, 10.3.14, 10.4.4
    • Virtual Columns

    Description

      Database crashed with queries executed on tables with stored generated fields.
      DB was highly inconsistent and crashing on random select, insert and truncate statements. Attached logs

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15881 Assertion `is_valid_value_slow()' failed in Datetime::Datetime or corrupt data after ALTER with indexed persistent column

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18695 Corruption (?) with multi-value insert and stored virtual column index

          • Major - Major loss of function.
          • Closed
          is part of

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17221 Production Database restarted

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15881 Assertion `is_valid_value_slow()' failed in Datetime::Datetime or corrupt data after ALTER with indexed persistent column

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17834 Server crashes in row_upd_build_difference_binary on LOAD DATA into table with indexed virtual column

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18270 ASAN heap-use-after-free in Field_long::val_int()

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18366 Crash on SELECT on a table that contains indexed virtual columns

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18414 Server crash or ASAN heap-use-after-free in my_strtod_int / Value_source::Converter_strntod::Converter_strntod

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18449 ASAN heap-use-after-free in my_strnncollsp_simple

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23018 Database corruption involving an index on a virtual column and a charset change

          • Major - Major loss of function.
          • Confirmed

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Confirmed
            		32m 4s 1
            Sergei Golubchik made transition -
            Confirmed In Progress
            		23d 20h 53m 1
            Sergei Golubchik made transition -
            In Progress Stalled
            		5s 1
            Sergei Golubchik made transition -
            Stalled Closed
            		3h 31m 1

            People

              serg Sergei Golubchik
              s.tausiff@animalytix.com Syed Tausiff
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.