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

Assertion `0' failed in json_find_path or Assertion `cur_step->type & JSON_PATH_ARRAY'

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 11.8, 12.3
    • 10.11, 11.4, 11.8, 12.3
    • JSON
    • None

    Description

      SELECT JSON_EXISTS('[[[[[Y[[[[n[[[[[[[[[[[n[[[Vn]]]]]]]]]]]]]],]]:]]]](', '$[0 to rrrrrRR-1]');
      SELECT JSON_EXISTS('[[[[[Y[[[[[[[[[[[[[[[[[[Vn]]]]]]]]]]]]]],]]:]]]](', '$[0 to rrrrRR-1]');
      

      mariadbd: /10.11/src/strings/json_lib.c:1482: json_find_path: Assertion `0' failed.
      260407 16:56:07 [ERROR] /10.11/bld/sql/mariadbd got signal 6 ;
       
      Server version: 10.11.17-MariaDB-debug-log source revision: 7888ca6b7cc3b35c4bdb35965111863a5a4b9cd6
       
      posix/raise.c:27(__GI_raise)[0x7e2c32e4527e]
      stdlib/abort.c:81(__GI_abort)[0x7e2c32e288ff]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7e2c32e2881b]
      /lib/x86_64-linux-gnu/libc.so.6(+0x3b517)[0x7e2c32e3b517]
      strings/json_lib.c:1444(json_find_path)[0x5bf7986cd7ff]
      sql/item_jsonfunc.cc:695(Item_func_json_exists::val_bool())[0x5bf797acadd0]
      sql/item_cmpfunc.h:248(Item_bool_func::val_int())[0x5bf7976cb518]
      sql/sql_type.cc:7732(Type_handler::Item_send_long(Item*, Protocol*, st_value*) const)[0x5bf797b22fa5]
      sql/sql_type.h:5794(Type_handler_long::Item_send(Item*, Protocol*, st_value*) const)[0x5bf797b315ec]
      sql/item.h:1267(Item::send(Protocol*, st_value*))[0x5bf797689df8]
      sql/protocol.cc:1333(Protocol::send_result_set_row(List<Item>*))[0x5bf7976dd3f1]
      sql/sql_class.cc:3213(select_send::send_data(List<Item>&))[0x5bf7977a76fb]
      sql/sql_class.h:6065(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x5bf797906655]
      sql/sql_select.cc:4888(JOIN::exec_inner())[0x5bf7978b1d4e]
      sql/sql_select.cc:4808(JOIN::exec())[0x5bf7978b1620]
      sql/sql_select.cc:5287(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5bf7978b2f01]
      sql/sql_select.cc:601(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x5bf7978a0e34]
      sql/sql_parse.cc:6463(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5bf797840a98]
      sql/sql_parse.cc:4042(mysql_execute_command(THD*, bool))[0x5bf7978376e4]
      sql/sql_parse.cc:8223(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5bf797845cab]
      sql/sql_parse.cc:1926(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5bf797830cfa]
      sql/sql_parse.cc:1434(do_command(THD*, bool))[0x5bf79782f604]
      sql/sql_connect.cc:1475(do_handle_one_connection(CONNECT*, bool))[0x5bf797a341e9]
      sql/sql_connect.cc:1389(handle_one_connection)[0x5bf797a33f5e]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5bf797f9a902]
      nptl/pthread_create.c:447(start_thread)[0x7e2c32e9caa4]
      x86_64/clone3.S:80(clone3)[0x7e2c32f29c6c]
       
      Query (0x762bf0015830): SELECT JSON_EXISTS('[[[[[Y[[[[n[[[[[[[[[[[n[[[Vn]]]]]]]]]]]]]],]]:]]]](', '$[0 to rrrrrRR-1]')
      

      mariadbd: /10.11/src/strings/json_lib.c:1452: json_find_path: Assertion `cur_step->type & JSON_PATH_ARRAY' failed.
      260407 16:59:17 [ERROR] /10.11/bld/sql/mariadbd got signal 6 ;
       
      Server version: 10.11.17-MariaDB-debug-log source revision: 7888ca6b7cc3b35c4bdb35965111863a5a4b9cd6
       
      nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7d2b88e9eb2c]
      posix/raise.c:27(__GI_raise)[0x7d2b88e4527e]
      stdlib/abort.c:81(__GI_abort)[0x7d2b88e288ff]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7d2b88e2881b]
      /lib/x86_64-linux-gnu/libc.so.6(+0x3b517)[0x7d2b88e3b517]
      strings/json_lib.c:1453(json_find_path)[0x64f9349ab5f3]
      sql/item_jsonfunc.cc:695(Item_func_json_exists::val_bool())[0x64f933da8dd0]
      sql/item_cmpfunc.h:248(Item_bool_func::val_int())[0x64f9339a9518]
      sql/sql_type.cc:7732(Type_handler::Item_send_long(Item*, Protocol*, st_value*) const)[0x64f933e00fa5]
      sql/sql_type.h:5794(Type_handler_long::Item_send(Item*, Protocol*, st_value*) const)[0x64f933e0f5ec]
      sql/item.h:1267(Item::send(Protocol*, st_value*))[0x64f933967df8]
      sql/protocol.cc:1333(Protocol::send_result_set_row(List<Item>*))[0x64f9339bb3f1]
      sql/sql_class.cc:3213(select_send::send_data(List<Item>&))[0x64f933a856fb]
      sql/sql_class.h:6065(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x64f933be4655]
      sql/sql_select.cc:4888(JOIN::exec_inner())[0x64f933b8fd4e]
      sql/sql_select.cc:4808(JOIN::exec())[0x64f933b8f620]
      sql/sql_select.cc:5287(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x64f933b90f01]
      sql/sql_select.cc:601(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x64f933b7ee34]
      sql/sql_parse.cc:6463(execute_sqlcom_select(THD*, TABLE_LIST*))[0x64f933b1ea98]
      sql/sql_parse.cc:4042(mysql_execute_command(THD*, bool))[0x64f933b156e4]
      sql/sql_parse.cc:8223(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x64f933b23cab]
      sql/sql_parse.cc:1926(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x64f933b0ecfa]
      sql/sql_parse.cc:1434(do_command(THD*, bool))[0x64f933b0d604]
      sql/sql_connect.cc:1475(do_handle_one_connection(CONNECT*, bool))[0x64f933d121e9]
      sql/sql_connect.cc:1389(handle_one_connection)[0x64f933d11f5e]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x64f934278902]
      nptl/pthread_create.c:447(start_thread)[0x7d2b88e9caa4]
      x86_64/clone3.S:80(clone3)[0x7d2b88f29c6c]
       
      Query (0x752b44015830): SELECT JSON_EXISTS('[[[[[Y[[[[[[[[[[[[[[[[[[Vn]]]]]]]]]]]]]],]]:]]]](', '$[0 to rrrrRR-1]')
      
      

      Attachments

        Issue Links

          Activity

            People

              rucha174 Rucha Deodhar
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.