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

Assertion `str_length + (uint32) (4) <= Alloced_length' failed in Binary_string::q_append

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • 11.7
    • GIS
    • None

    Description

       SELECT ST_VALIDATE(ST_GEOMCOLLFROMTEXT(' GEOMETRYCOLLECTION( POLYGON( ( 5 2, 4 3, 9 8, 2 9, 1 6, 3 1, 3 1, 5 2 ) ), LINESTRING( 8 5, 0 3, 4 9, 1 8, 0 8, 5 2 ), POINT( 7 7 ), LINESTRING( 0 1, 1 6, 7 2, 3 4 ), LINESTRING( 5 2, 9 9, 4 4, 7 5, 4 6 ) ) '));
      

      Version: '11.7.0-MariaDB-debug-log' 
      mariadbd: /11.7/src/sql/sql_string.h:391: void Binary_string::q_append(uint32): Assertion `str_length + (uint32) (4) <= Alloced_length' failed.
      241002 17:55:35 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.7.0-MariaDB-debug-log source revision: 7391f7143b462b29ecdaee049c5ebdfd1aefa6d7
       
      /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7feed3944fd6]
      sql/sql_string.h:392(Binary_string::q_append(unsigned int))[0x56378ed26e70]
      sql/spatial.cc:4609(Gis_geometry_collection::make_clockwise(String*) const)[0x56378f0ad524]
      sql/item_geofunc.cc:2155(Item_func_validate::val_str(String*))[0x56378ed1906c]
      sql/sql_type.cc:7637(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const)[0x56378e8d89e0]
      sql/sql_type.h:5724(Type_handler_string_result::Item_send(Item*, Protocol*, st_value*) const)[0x56378e63b010]
      sql/item.h:1251(Item::send(Protocol*, st_value*))[0x56378ddc838c]
      sql/protocol.cc:1353(Protocol::send_result_set_row(List<Item>*))[0x56378de8dcdb]
      sql/sql_class.cc:3276(select_send::send_data(List<Item>&))[0x56378e04663c]
      sql/sql_class.h:6222(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x56378e3946ad]
      sql/sql_select.cc:4895(JOIN::exec_inner())[0x56378e2b871c]
      sql/sql_select.cc:4809(JOIN::exec())[0x56378e2b7248]
      sql/sql_select.cc:5342(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*))[0x56378e2bba71]
      sql/sql_select.cc:625(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x56378e28a0ac]
      sql/sql_parse.cc:6157(execute_sqlcom_select(THD*, TABLE_LIST*))[0x56378e1a7d5a]
      sql/sql_parse.cc:3955(mysql_execute_command(THD*, bool))[0x56378e197a01]
      sql/sql_parse.cc:7879(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x56378e1b31a4]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x56378e18992d]
      sql/sql_parse.cc:1405(do_command(THD*, bool))[0x56378e186642]
      sql/sql_connect.cc:1448(do_handle_one_connection(CONNECT*, bool))[0x56378e68b262]
      sql/sql_connect.cc:1352(handle_one_connection)[0x56378e68abbf]
      perfschema/pfs.cc:2200(pfs_spawn_thread)[0x56378f42d316]
      nptl/pthread_create.c:478(start_thread)[0x7feed3e5f609]
       
      Query (0x6290000e6460): SELECT ST_VALIDATE(ST_GEOMCOLLFROMTEXT(' GEOMETRYCOLLECTION( POLYGON( ( 5 2, 4 3, 9 8, 2 9, 1 6, 3 1, 3 1, 5 2 ) ), LINESTRING( 8 5, 0 3, 4 9, 1 8, 0 8, 5 2 ), POINT( 7 7 ), LINESTRING( 0 1, 1 6, 7 2, 3 4 ), LINESTRING( 5 2, 9 9, 4 4, 7 5, 4 6 ) ) '))
      

      SELECT  ST_VALIDATE(ST_INTERSECTION( MULTILINESTRINGFROMTEXT('  MULTILINESTRING( ( 2 3, 7 6, 3 5, 7 8 ), ( 3 3, 2 1, 1 5, 2 5, 4 8 ), ( 4 6, 4 2, 3 5, 0 4, 2 5 ), ( 9 5, 8 0, 0 9, 4 4 ), ( 7 7, 8 7, 9 8, 7 8, 7 7 ) ) '), EXTERIORRING(  POLYGONFROMTEXT('  POLYGON( ( 2 2, 2 8, 8 8, 8 2, 2 2 ), ( 4 4, 4 6, 6 6, 6 4, 4 4 ) ) ') ) ));
      

      Attachments

        Issue Links

          Activity

            People

              Gosselin Dave Gosselin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.