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

IS JSON was not interuptable

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • The IS [NOT] JSON operation can be killed with KILL QUERY and now respects the max_statement_time with correct error messages if that occurs.

    Description

      12.3 json functions need to be killable/timeout.

      Functions added in 12.3:

      • IS_JSON

      Like MDEV-28404 they need:

      • je.killed_ptr assignment after json_scan_start where the is a function to json_scan_next used within the Item
      • Remove check_killed() if present - handled by report_json_error.
      • JSON_DO_PAUSE_EXECUTION(thd, 0.0002); in Item_function::val*
      • json library functions to end up in report_json_error(js, &je, 0); immediately after error, and return null.
      • add to func_json_notembedded.test - ensure result file is the timeout error.

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28404 JSON functions don't respect KILL QUERY / max_statement_time limit / recusion depth #2

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-37072 Support for IS JSON predicate

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-39742 11.4 JSON functions not interuptable

          • Major - Major loss of function.
          • Closed

          Activity

            People

              danblack Daniel Black
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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