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

Assertion `l_offset >= 0 && table->s->rec_buff_length - l_offset > 0' failed in Field::ptr_in_record

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL)
    • 10.5, 10.6, 10.11, 11.4
    • None
    • None

    Description

       
      CREATE TABLE t1 ( d int, id int NOT NULL auto_increment, s geometry, b int, a int, p1 point NOT NULL DEFAULT st_geometryfromtext('Point(1 1)'), PRIMARY KEY (a,d,id));
       
      SET  SQL_MODE= 'SIMULTANEOUS_ASSIGNMENT' ;
      INSERT IGNORE INTO t1 ( a, b ) VALUES ( 1,2 );
      --error 1416
      UPDATE IGNORE t1 SET id = a, s = 1 WHERE p1 IS NOT NULL;
      ALTER TABLE t1 FORCE;
       

      mariadbd: /10.5/src/sql/field.h:1178: const uchar* Field::ptr_in_record(const uchar*) const: Assertion `l_offset >= 0 && table->s->rec_buff_length - l_offset > 0' failed.
      241113 16:17:02 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.5.28-MariaDB-debug-log source revision: cad881ab104ac54f5e4c4ddffc3470346f98c38f
       
      /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f9d0b24afd6]
      sql/field.h:1179(Field::ptr_in_record(unsigned char const*) const)[0x562605d9be0d]
      sql/field.cc:10932(Column_definition::Column_definition(THD*, Field*, Field*))[0x562606237d40]
      sql/field.h:5683(Create_field::Create_field(THD*, Field*, Field*))[0x56260594af14]
      sql/sql_table.cc:8801(mysql_prepare_alter_table(THD*, TABLE*, HA_CREATE_INFO*, Alter_info*, Alter_table_ctx*))[0x562605cabe5a]
      sql/sql_table.cc:10832(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Recreate_info*, Alter_info*, unsigned int, st_order*, bool, bool))[0x562605cbbf97]
      sql/sql_alter.cc:601(Sql_cmd_alter_table::execute(THD*))[0x562605e6df3f]
      sql/sql_parse.cc:6179(mysql_execute_command(THD*))[0x5626059ff17f]
      sql/sql_parse.cc:8237(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562605a0cb93]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5626059e1506]
      sql/sql_parse.cc:1375(do_command(THD*))[0x5626059ddde0]
      sql/sql_connect.cc:1407(do_handle_one_connection(CONNECT*, bool))[0x562605e50c9c]
      sql/sql_connect.cc:1321(handle_one_connection)[0x562605e507f6]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x562606b0e9b4]
      nptl/pthread_create.c:478(start_thread)[0x7f9d0b7fb609]
       
      Query (0x62b0000852a8): ALTER TABLE t1 FORCE
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              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.