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

Assertion `is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed in Field_timestamp::store_TIME_with_warning

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1
    • 10.1.12
    • Replication
    • None
    • 10.1.12

    Description

      Stack trace from 498a264d19f041c36d71e41a32c16ac40a014a3e

      10.1/sql/field.cc:4615: int Field_timestamp::store_TIME_with_warning(THD*, MYSQL_TIME*, const ErrConv*, int, bool): Assertion `is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed.
      150702 17:46:52 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f23dc77f311 in *__GI___assert_fail (assertion=0x7f23dfaf0a30 "is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))", file=<optimized out>, line=4615, function=0x7f23dfaf45e0 "int Field_timestamp::store_TIME_with_warning(THD*, MYSQL_TIME*, const ErrConv*, int, bool)") at assert.c:81
      #7  0x00007f23df304ffc in Field_timestamp::store_TIME_with_warning (this=0x7f23b6276b58, thd=0x7f23b604c070, l_time=0x7f23deacce30, str=0x7f23deacce60, was_cut=0, have_smth_to_conv=true) at 10.1/sql/field.cc:4615
      #8  0x00007f23df3052c6 in Field_timestamp::store_time_dec (this=0x7f23b6276b58, ltime=0x7f23deacd0b0, dec=0) at 10.1/sql/field.cc:4676
      #9  0x00007f23df31f86a in do_field_temporal (copy=0x7f23deacd280) at 10.1/sql/field_conv.cc:424
      #10 0x00007f23df31eee0 in do_copy_null (copy=0x7f23deacd280) at 10.1/sql/field_conv.cc:243
      #11 0x00007f23df43382c in unpack_row (rgi=0x7f23b6023800, table=0x7f23dbd8e470, colcnt=9, row_data=0x7f23b62d5df0 "r\376\001", cols=0x7f23b629d1e8, current_row_end=0x7f23b629d288, master_reclength=0x7f23b629d230, row_end=0x7f23b62d5ec6 "\245\245h4z\025") at 10.1/sql/rpl_record.cc:375
      #12 0x00007f23df432587 in Rows_log_event::unpack_current_row (this=0x7f23b629d170, rgi=0x7f23b6023800) at 10.1/sql/log_event.h:4430
      #13 0x00007f23df42f287 in Rows_log_event::find_row (this=0x7f23b629d170, rgi=0x7f23b6023800) at 10.1/sql/log_event.cc:11889
      #14 0x00007f23df4304ec in Update_rows_log_event::do_exec_row (this=0x7f23b629d170, rgi=0x7f23b6023800) at 10.1/sql/log_event.cc:12386
      #15 0x00007f23df42a8da in Rows_log_event::do_apply_event (this=0x7f23b629d170, rgi=0x7f23b6023800) at 10.1/sql/log_event.cc:9917
      #16 0x00007f23df05030d in Log_event::apply_event (this=0x7f23b629d170, rgi=0x7f23b6023800) at 10.1/sql/log_event.h:1347
      #17 0x00007f23df045cf6 in apply_event_and_update_pos (ev=0x7f23b629d170, thd=0x7f23b604c070, rgi=0x7f23b6023800, rpt=0x0) at 10.1/sql/slave.cc:3269
      #18 0x00007f23df0465a3 in exec_relay_log_event (thd=0x7f23b604c070, rli=0x7f23ca088c20, serial_rgi=0x7f23b6023800) at 10.1/sql/slave.cc:3587
      #19 0x00007f23df04988a in handle_slave_sql (arg=0x7f23ca087000) at 10.1/sql/slave.cc:4687
      #20 0x00007f23de79ab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #21 0x00007f23dc82f95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      To reproduce,

      • bootstrap server 1 and server 2;
      • unpack the attached binlog.tar.gz and put all mysql-bin.* files into the datadir for server 1;
      • start server 1 with --log-bin=mysql-bin --server-id=1;
      • start server 2 with --server-id=2;
      • set up and start standard replication from server 1 to server 2;
      • wait.

      When slave SQL thread reaches mysql-bin.000237 pos 866, the slave crashes as above.

      I have also attached mysql.log from the master in case you want to match the binlog with the general log.

      Attachments

        Activity

          People

            cvicentiu Vicențiu Ciorbaru
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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