--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

!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

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