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

JSON_TABLE: Assertion `thd->is_error()' failed in convert_error_to_warning

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: 10.6.0
    • Component/s: JSON
    • Labels:
      None

      Description

      Hopefully it is related to MDEV-25142 and will be fixed by the same patch.

      CREATE VIEW v AS SELECT * FROM JSON_TABLE('[]', '$' COLUMNS (f INT EXISTS PATH '$')) a;
      SELECT * FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS;
      

      bb-10.6-mdev17399-psergey2 8b533cc1d5

      mysqld: /data/src/bb-10.6-mdev17399-psergey2/sql/sql_error.cc:994: void convert_error_to_warning(THD*): Assertion `thd->is_error()' failed.
      210315 17:31:39 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f1afcb43f36 in __GI___assert_fail (assertion=0x5563cfca619e "thd->is_error()", file=0x5563cfca5b38 "/data/src/bb-10.6-mdev17399-psergey2/sql/sql_error.cc", line=994, function=0x5563cfca61b0 "void convert_error_to_warning(THD*)") at assert.c:101
      #8  0x00005563ceeab37d in convert_error_to_warning (thd=0x7f1aa4000db8) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_error.cc:994
      #9  0x00005563cfc2b0d1 in Show::get_geometry_column_record (thd=0x7f1aa4000db8, tables=0x7f1aa4027f70, table=0x7f1aa401f1b0, res=true, db_name=0x7f1aa4019650, table_name=0x7f1aa4019680) at /data/src/bb-10.6-mdev17399-psergey2/plugin/type_geom/plugin.cc:168
      #10 0x00005563cefba175 in fill_schema_table_by_open (thd=0x7f1aa4000db8, mem_root=0x7f1afc071e80, is_show_fields_or_keys=false, table=0x7f1aa401f1b0, schema_table=0x5563d17687e8, orig_db_name=0x7f1aa4019650, orig_table_name=0x7f1aa4019680, open_tables_state_backup=0x7f1afc071ec0, can_deadlock=false) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_show.cc:4652
      #11 0x00005563cefbbb7a in get_all_tables (thd=0x7f1aa4000db8, tables=0x7f1aa4014470, cond=0x0) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_show.cc:5260
      #12 0x00005563cefcce7b in get_schema_tables_result (join=0x7f1aa4015b20, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_show.cc:8731
      #13 0x00005563cef59d5f in JOIN::exec_inner (this=0x7f1aa4015b20) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:4445
      #14 0x00005563cef59161 in JOIN::exec (this=0x7f1aa4015b20) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:4268
      #15 0x00005563cef5a9ad in mysql_select (thd=0x7f1aa4000db8, tables=0x7f1aa4014470, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f1aa4015af8, unit=0x7f1aa4004f90, select_lex=0x7f1aa4013e20) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:4744
      #16 0x00005563cef4a2db in handle_select (thd=0x7f1aa4000db8, lex=0x7f1aa4004ec8, result=0x7f1aa4015af8, setup_tables_done_option=0) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_select.cc:417
      #17 0x00005563cef0cdd7 in execute_sqlcom_select (thd=0x7f1aa4000db8, all_tables=0x7f1aa4014470) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:6230
      #18 0x00005563cef04037 in mysql_execute_command (thd=0x7f1aa4000db8) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:3926
      #19 0x00005563cef11c24 in mysql_parse (thd=0x7f1aa4000db8, rawbuf=0x7f1aa4013d60 "SELECT * FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS", length=49, parser_state=0x7f1afc073510) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:8001
      #20 0x00005563ceefe042 in dispatch_command (command=COM_QUERY, thd=0x7f1aa4000db8, packet=0x7f1aa400b379 "SELECT * FROM INFORMATION_SCHEMA.GEOMETRY_COLUMNS", packet_length=49, blocking=true) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:1886
      #21 0x00005563ceefc9e9 in do_command (thd=0x7f1aa4000db8, blocking=true) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_parse.cc:1397
      #22 0x00005563cf0aaf98 in do_handle_one_connection (connect=0x5563d1d5aea8, put_in_cache=true) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_connect.cc:1410
      #23 0x00005563cf0aacf4 in handle_one_connection (arg=0x5563d1cf6138) at /data/src/bb-10.6-mdev17399-psergey2/sql/sql_connect.cc:1312
      #24 0x00005563cf60d987 in pfs_spawn_thread (arg=0x5563d1c3f678) at /data/src/bb-10.6-mdev17399-psergey2/storage/perfschema/pfs.cc:2201
      #25 0x00007f1afd05b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #26 0x00007f1afcc2f293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: