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

Assertion `next_free_value % real_increment == offset' fails upon CREATE SEQUENCE in galera cluster

    XMLWordPrintable

    Details

      Description

      t.test

      --source include/galera_cluster.inc
      --source include/have_wsrep_enabled.inc
       
      --connection node_1
      create sequence s increment 0;
       
      --connection node_2
      select 1;
       
      # Cleanup
      drop sequence s;
      --source include/galera_end.inc
      

      t.cnf file

      !include include/default_mysqld.cnf
       
      [mysqld]
      log-bin=mysqld-bin
      binlog-format=row
      innodb-autoinc-lock-mode=2
      default-storage-engine=innodb
      innodb
      log-slave-updates
      wsrep-on=1
      wsrep-provider=@ENV.WSREP_PROVIDER
      wsrep_node_address=127.0.0.1
       
      [mysqld.1]
      #galera_port=@OPT.port
      #ist_port=@OPT.port
      #sst_port=@OPT.port
       
      server-id=1
       
      wsrep_provider_options='base_port=@mysqld.1.#galera_port;gcache.size=10M'
      wsrep_cluster_address=gcomm://
      wsrep_sst_receive_address='127.0.0.1:@mysqld.1.#sst_port'
      wsrep_node_incoming_address=127.0.0.1:@mysqld.1.port
       
      [mysqld.2]
      #galera_port=@OPT.port
      #ist_port=@OPT.port
      #sst_port=@OPT.port
       
      server-id=2
       
      wsrep_provider_options='base_port=@mysqld.2.#galera_port;gcache.size=10M'
      wsrep_cluster_address='gcomm://127.0.0.1:@mysqld.1.#galera_port'
      wsrep_sst_receive_address='127.0.0.1:@mysqld.2.#sst_port'
      wsrep_node_incoming_address=127.0.0.1:@mysqld.2.port
       
      [ENV]
      NODE_MYPORT_1= @mysqld.1.port
      NODE_MYSOCK_1= @mysqld.1.socket
       
      NODE_MYPORT_2= @mysqld.2.port
      NODE_MYSOCK_2= @mysqld.2.socket
       
      NODE_GALERAPORT_1= @mysqld.1.#galera_port
      NODE_GALERAPORT_2= @mysqld.2.#galera_port
       
      NODE_SSTPORT_1= @mysqld.1.#sst_port
      NODE_SSTPORT_2= @mysqld.2.#sst_port
      

      Note: remember that you might need to set WSREP_PROVIDER if it's not installed system-wide.

      10.3 c98e6d4b3d

      mysqld: /data/src/10.3/sql/sql_sequence.cc:567: void sequence_definition::adjust_values(longlong): Assertion `next_free_value % real_increment == offset' failed.
      180528 18:01:40 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f1347807266 in __assert_fail_base (fmt=0x7f134793ff18 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f134ab29918 "next_free_value % real_increment == offset", file=file@entry=0x7f134ab29778 "/data/src/10.3/sql/sql_sequence.cc", line=line@entry=567, function=function@entry=0x7f134ab29c00 <sequence_definition::adjust_values(long long)::__PRETTY_FUNCTION__> "void sequence_definition::adjust_values(longlong)") at assert.c:92
      #7  0x00007f1347807312 in __GI___assert_fail (assertion=0x7f134ab29918 "next_free_value % real_increment == offset", file=0x7f134ab29778 "/data/src/10.3/sql/sql_sequence.cc", line=567, function=0x7f134ab29c00 <sequence_definition::adjust_values(long long)::__PRETTY_FUNCTION__> "void sequence_definition::adjust_values(longlong)") at assert.c:101
      #8  0x00007f134a16077c in sequence_definition::adjust_values (this=0x7f132800f9b0, next_value=1) at /data/src/10.3/sql/sql_sequence.cc:567
      #9  0x00007f134a15ef9c in sequence_definition::check_and_adjust (this=0x7f132800f9b0, set_reserved_until=true) at /data/src/10.3/sql/sql_sequence.cc:112
      #10 0x00007f134a18bd94 in MYSQLparse (thd=0x7f1328000b00) at /data/src/10.3/sql/sql_yacc.yy:2714
      #11 0x00007f1349f7096e in parse_sql (thd=0x7f1328000b00, parser_state=0x7f134054cde0, creation_ctx=0x0, do_pfs_digest=true) at /data/src/10.3/sql/sql_parse.cc:10031
      #12 0x00007f1349f6baa9 in mysql_parse (thd=0x7f1328000b00, rawbuf=0x7f132802541b "create sequence s increment 0", length=29, parser_state=0x7f134054cde0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7973
      #13 0x00007f134a381e2c in Query_log_event::do_apply_event (this=0x7f1328025270, rgi=0x7f1328021b80, query_arg=0x7f132802541b "create sequence s increment 0", q_len_arg=29) at /data/src/10.3/sql/log_event.cc:5646
      #14 0x00007f134a380d93 in Query_log_event::do_apply_event (this=0x7f1328025270, rgi=0x7f1328021b80) at /data/src/10.3/sql/log_event.cc:5320
      #15 0x00007f1349e7ed31 in Log_event::apply_event (this=0x7f1328025270, rgi=0x7f1328021b80) at /data/src/10.3/sql/log_event.h:1481
      #16 0x00007f134a17b2f4 in wsrep_apply_events (thd=0x7f1328000b00, events_buf=0x7f1341e9e618, buf_len=0) at /data/src/10.3/sql/wsrep_applier.cc:165
      #17 0x00007f134a17b8de in wsrep_apply_cb (ctx=0x7f1328000b00, buf=0x7f1341e9e618, buf_len=348, flags=5, meta=0x7f134054de60) at /data/src/10.3/sql/wsrep_applier.cc:268
      #18 0x00007f1342c8f6d3 in galera::TrxHandle::apply (this=this@entry=0x7f1328027a70, recv_ctx=recv_ctx@entry=0x7f1328000b00, apply_cb=apply_cb@entry=0x7f134a17b5bb <wsrep_apply_cb(void*, void const*, size_t, uint32_t, wsrep_trx_meta_t const*)>, meta=...) at galera/src/trx_handle.cpp:315
      #19 0x00007f1342cc6b93 in apply_trx_ws (recv_ctx=recv_ctx@entry=0x7f1328000b00, apply_cb=0x7f134a17b5bb <wsrep_apply_cb(void*, void const*, size_t, uint32_t, wsrep_trx_meta_t const*)>, commit_cb=0x7f134a17bbff <wsrep_commit_cb(void*, uint32_t, wsrep_trx_meta_t const*, wsrep_bool_t*, bool)>, trx=..., meta=...) at galera/src/replicator_smm.cpp:39
      #20 0x00007f1342cc8a96 in galera::ReplicatorSMM::apply_trx (this=this@entry=0x7f134d832ad0, recv_ctx=recv_ctx@entry=0x7f1328000b00, trx=trx@entry=0x7f1328027a70) at galera/src/replicator_smm.cpp:433
      #21 0x00007f1342cca6a0 in galera::ReplicatorSMM::process_trx (this=0x7f134d832ad0, recv_ctx=0x7f1328000b00, trx=0x7f1328027a70) at galera/src/replicator_smm.cpp:1224
      #22 0x00007f1342caa493 in galera::GcsActionSource::dispatch (this=this@entry=0x7f134d833120, recv_ctx=recv_ctx@entry=0x7f1328000b00, act=..., exit_loop=@0x7f134054eaa0: false) at galera/src/gcs_action_source.cpp:116
      #23 0x00007f1342cab85b in galera::GcsActionSource::process (this=0x7f134d833120, recv_ctx=0x7f1328000b00, exit_loop=@0x7f134054eaa0: false) at galera/src/gcs_action_source.cpp:181
      #24 0x00007f1342ccb8ed in galera::ReplicatorSMM::async_recv (this=0x7f134d832ad0, recv_ctx=0x7f1328000b00) at galera/src/replicator_smm.cpp:355
      #25 0x00007f1342cdc813 in galera_recv (gh=<optimized out>, recv_ctx=<optimized out>) at galera/src/wsrep_provider.cpp:239
      #26 0x00007f134a17d29c in wsrep_replication_process (thd=0x7f1328000b00) at /data/src/10.3/sql/wsrep_thd.cc:362
      #27 0x00007f134a16ee45 in start_wsrep_THD (arg=0x7f134a17d1e9 <wsrep_replication_process(THD*)>) at /data/src/10.3/sql/wsrep_mysqld.cc:1979
      #28 0x00007f134946e064 in start_thread (arg=0x7f134054f700) at pthread_create.c:309
      #29 0x00007f13478c162d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      No crash on a non-debug build.

        Attachments

          Activity

            People

            Assignee:
            monty Michael Widenius
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: