Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
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
Issue Links
- relates to
-
MDEV-22705 Assertion `llabs(next_free_value % real_increment) == offset' failed in sequence_definition::adjust_values, from sequence_definition::check_and_adjust and from SEQUENCE::read_stored_values
- Confirmed