[MDEV-24061] Galera stack smashing detected during SP commit - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Incomplete
Affects Version/s: 10.4.14
Fix Version/s: N/A
Component/s: Galera
Labels:
- need_feedback

Description

2020-10-09  4:19:06 6973 [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED

201009  4:19:06 [ERROR] mysqld got signal 6 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 10.4.14-MariaDB-log

key_buffer_size=33554432

read_buffer_size=2097152

max_used_connections=273

max_threads=10011

thread_count=208

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 102792608 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f05ec0009a8

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x7f1c86330e40 thread_stack 0x49000

*** stack smashing detected ***: /usr/local/mysql/bin/mysqld terminated

======= Backtrace: =========

/lib64/libc.so.6(__fortify_fail+0x37)[0x7f1e605ff597]

/lib64/libc.so.6(+0x118552)[0x7f1e605ff552]

/usr/local/mysql/bin/mysqld(+0xf418c2)[0x55769d40e8c2]

/usr/local/mysql/bin/mysqld(my_print_stacktrace+0x1c2)[0x55769d3f6d92]

/usr/local/mysql/bin/mysqld(handle_fatal_signal+0x30f)[0x55769ce0772f]

/lib64/libpthread.so.0(+0xf600)[0x7f1e6178f600]

/lib64/libc.so.6(gsignal+0x37)[0x7f1e6051d3a7]

/lib64/libc.so.6(abort+0x148)[0x7f1e6051ea98]

/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1bb82e)[0x7f1dae93a82e]

/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1acee7)[0x7f1dae92bee7]

/usr/local/mysql/lib/galera-4/libgalera_smm.so(+0x1c9108)[0x7f1dae948108]

/usr/local/mysql/bin/mysqld(_ZN5wsrep18wsrep_provider_v2618commit_order_leaveERKNS_9ws_handleERKNS_7ws_metaERKNS_14mutable_bufferE+0x91)[0x55769d4b1a51]

/usr/local/mysql/bin/mysqld(_ZN5wsrep11transaction14ordered_commitEv+0x77)[0x55769d4a77f7]

/usr/local/mysql/bin/mysqld(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0xd8)[0x55769cef6818]

/usr/local/mysql/bin/mysqld(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbb+0xd0)[0x55769cef6e00]

/usr/local/mysql/bin/mysqld(+0xa29fad)[0x55769cef6fad]

/usr/local/mysql/bin/mysqld(+0xa2a2ce)[0x55769cef72ce]

/usr/local/mysql/bin/mysqld(+0xa2a5a9)[0x55769cef75a9]

/usr/local/mysql/bin/mysqld(_Z17ha_rollback_transP3THDb+0xfb)[0x55769ce0a71b]

/usr/local/mysql/bin/mysqld(_Z15ha_commit_transP3THDb+0x9b4)[0x55769ce15ed4]

/usr/local/mysql/bin/mysqld(_Z17trans_commit_stmtP3THD+0x3f)[0x55769ccf475f]

/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xfb2)[0x55769cbface2]

/usr/local/mysql/bin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x55769cb5f8e5]

/usr/local/mysql/bin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x119)[0x55769cb67c79]

/usr/local/mysql/bin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x64c)[0x55769cb6871c]

/usr/local/mysql/bin/mysqld(_ZN7sp_head7executeEP3THDb+0x9c7)[0x55769cb636f7]

/usr/local/mysql/bin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x779)[0x55769cb64bf9]

/usr/local/mysql/bin/mysqld(+0x724f4a)[0x55769cbf1f4a]

/usr/local/mysql/bin/mysqld(+0x726876)[0x55769cbf3876]

/usr/local/mysql/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x90)[0x55769cbf40b0]

/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2860)[0x55769cbfc590]

/usr/local/mysql/bin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x55769cb5f8e5]

/usr/local/mysql/bin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x119)[0x55769cb67c79]

/usr/local/mysql/bin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x64c)[0x55769cb6871c]

/usr/local/mysql/bin/mysqld(_ZN7sp_head7executeEP3THDb+0x9c7)[0x55769cb636f7]

/usr/local/mysql/bin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x779)[0x55769cb64bf9]

/usr/local/mysql/bin/mysqld(+0x724f4a)[0x55769cbf1f4a]

/usr/local/mysql/bin/mysqld(+0x726876)[0x55769cbf3876]

/usr/local/mysql/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x90)[0x55769cbf40b0]

/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2860)[0x55769cbfc590]

/usr/local/mysql/bin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x55769cb5f8e5]

/usr/local/mysql/bin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x119)[0x55769cb67c79]

/usr/local/mysql/bin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x64c)[0x55769cb6871c]

/usr/local/mysql/bin/mysqld(_ZN7sp_head7executeEP3THDb+0x9c7)[0x55769cb636f7]

/usr/local/mysql/bin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x779)[0x55769cb64bf9]

/usr/local/mysql/bin/mysqld(+0x724f4a)[0x55769cbf1f4a]

/usr/local/mysql/bin/mysqld(+0x726876)[0x55769cbf3876]

/usr/local/mysql/bin/mysqld(_ZN12Sql_cmd_call7executeEP3THD+0x90)[0x55769cbf40b0]

/usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2860)[0x55769cbfc590]

/usr/local/mysql/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x545)[0x55769cc15975]

/usr/local/mysql/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x92)[0x55769cc15a82]

/usr/local/mysql/bin/mysqld(+0x7493c7)[0x55769cc163c7]

/usr/local/mysql/bin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x27)[0x55769cc16457]

/usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x17f1)[0x55769cc050e1]

/usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x109)[0x55769cc06e89]

/usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1fa)[0x55769cce5f9a]

/usr/local/mysql/bin/mysqld(handle_one_connection+0x3d)[0x55769cce607d]

/usr/local/mysql/bin/mysqld(+0xe53bdd)[0x55769d320bdd]

/lib64/libpthread.so.0(+0x7e75)[0x7f1e61787e75]

Attachments

Issue Links

relates to

MDEV-32561 WSREP FSM failure: no such a transition REPLICATING -> COMMITTED

Closed

Activity

Jan Lindström (Inactive) added a comment - 2020-10-30 05:50

GDB output from crash:

#8  0x000055769ce0772f in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/sql/signal_handler.cc:207

        curr_time = 1602184746

        tm = {tm_sec = 6, tm_min = 19, tm_hour = 4, tm_mday = 9, tm_mon = 9, tm_year = 120, tm_wday = 5, tm_yday = 282, tm_isdst = 0, tm_gmtoff = 32400, tm_zone = 0x55769ec0a060 "KST"}

        print_invalid_query_pointer = false

#9  <signal handler called>

No symbol table info available.

#10 0x00007f1e6051d3a7 in raise () from /lib64/libc.so.6

No symbol table info available.

#11 0x00007f1e6051ea98 in abort () from /lib64/libc.so.6

No symbol table info available.

#12 0x00007f1dae93a82e in galera::FSM<galera::TrxHandle::State, galera::TrxHandle::Transition, galera::EmptyGuard, galera::EmptyAction>::shift_to (this=this@entry=0x7f082c110458, state=state@entry=galera::TrxHandle::S_COMMITTED, line=line@entry=1424) at galera/src/fsm.hpp:85

        __FUNCTION__ = "shift_to"

        i = {<std::__detail::_Node_iterator_base<std::pair<galera::TrxHandle::Transition const, galera::FSM<galera::TrxHandle::State, galera::TrxHandle::Transition>::TransAttr>, true>> = {_M_cur = 0x0}, <No data fields>}

        gi = <optimized out>

        ai = <optimized out>

        se = <optimized out>

#13 0x00007f1dae92bee7 in set_state (line=1424, state=galera::TrxHandle::S_COMMITTED, this=0x7f082c110450) at galera/src/trx_handle.hpp:222

No locals.

#14 set_state (line=1424, state=galera::TrxHandle::S_COMMITTED, this=0x7f082c110450) at galera/src/trx_handle.hpp:594

No locals.

#15 galera::ReplicatorSMM::commit_order_leave (this=this@entry=0x55769ecf2da0, ts=Python Exception <class 'gdb.error'> cannot resolve overloaded method `_M_before_begin': no arguments supplied:

@0x7f082c110450: {<galera::TrxHandle> = {_vptr.TrxHandle = 0x7f1daea027f0 <vtable for galera::TrxHandleSlave+16>, static TRXHANDLE_FLAGS_MASK = 33791, static EXPLICIT_ROLLBACK_FLAGS = 10, static FLAGS_MATCH_API_FLAGS = true, static num_states_ = 12, state_ = {delete_ = false, trans_map_ = 0x7f1daea09ee0 <galera::TrxHandleSlave::trans_map_>, state_ = {first = galera::TrxHandle::S_REPLICATING, second = 0}, state_hist_ = std::vector of length 0, capacity 0}, source_id_ = {data = "z\242\262]\t\030\021�W\257\tR#P\270", alignment = 16938346102022906490}, conn_id_ = 6973, trx_id_ = 3346858112, timestamp_ = 853817613795143, version_ = 5, write_set_flags_ = 65, local_ = true, master_ = false}, static trans_map_ = {impl_ = std::unordered_map with 4 elements}, local_seqno_ = 10791398, global_seqno_ = 387232383, last_seen_seqno_ = 387232378, depends_seqno_ = 387232375, ends_nbo_ = -1, mem_pool_ = @0x55769ecf3510, write_set_ = {header_ = {static MAGIC_BYTE = 71 'G', static V3_CHECKSUM_SIZE = 8, static V3_ANNOT_FLAG = 1 '\001', static V3_UNORD_FLAG = 2 '\002', static V3_MAGIC_OFF = 0, static V3_HEADER_VERS_OFF = 1, static V3_HEADER_SIZE_OFF = 2, static V3_SETS_OFF = 3, static V3_FLAGS_OFF = 4, static V3_PA_RANGE_OFF = 6, static V3_LAST_SEEN_OFF = 8, static V3_SEQNO_OFF = 8, static V3_TIMESTAMP_OFF = 16, static V3_SOURCE_ID_OFF = 24, static V3_CONN_ID_OFF = 40, static V3_TRX_ID_OFF = 48, static V3_CRC_OFF = 56, static V3_SIZE = 64, static V3 = {header_ver_ = 1, header_size_ = 2, sets_ = 3, flags_ = 4, pa_range_ = 6, last_seen_ = 8, seqno_ = 8, timestamp_ = 16, source_id_ = 24, conn_id_ = 40, trx_id_ = 48, crc_ = 56}, static MAX_HEADER_SIZE = 64, local_ = '\000' <repeats 63 times>, ptr_ = 0x7f1d6ca61bb8 <Address 0x7f1d6ca61bb8 out of bounds>, ver_ = galera::WriteSetNG::VER5, size_ = 64 '@', chksm_ = {<No data fields>}}, size_ = 3120, keys_ = {<gu::RecordSetIn<galera::KeySet::KeyPart>> = {<gu::RecordSetInBase> = {<gu::RecordSet> = {static MAX_VERSION = gu::RecordSet::VER2, static VER2_ALIGNMENT = 8, size_ = 88, count_ = 8, version_ = 2 '\002', check_type_ = 3 '\003', alignment_ = 8 '\b'}, head_ = 0x7f1d6ca61bf8 <Address 0x7f1d6ca61bf8 out of bounds>, next_ = 88, begin_ = 24}, <No data fields>}, version_ = galera::KeySet::FLAT8}, data_ = {<gu::RecordSetIn<galera::DataSet::RecordIn>> = {<gu::RecordSetInBase> = {<gu::RecordSet> = {static MAX_VERSION = gu::RecordSet::VER2, static VER2_ALIGNMENT = 8, size_ = 2965, count_ = 1, version_ = 2 '\002', check_type_ = 3 '\003', alignment_ = 8 '\b'}, head_ = 0x7f1d6ca61c50 <Address 0x7f1d6ca61c50 out of bounds>, next_ = 24, begin_ = 24}, <No data fields>}, version_ = galera::DataSet::VER1}, unrd_ = {<gu::RecordSetIn<galera::DataSet::RecordIn>> = {<gu::RecordSetInBase> = {<gu::RecordSet> = {static MAX_VERSION = gu::RecordSet::VER2, static VER2_ALIGNMENT = 8, size_ = 0, count_ = 0, version_ = 0 '\000', check_type_ = 0 '\000', alignment_ = 0 '\000'}, head_ = 0x0, next_ = 0, begin_ = 0}, <No data fields>}, version_ = galera::DataSet::EMPTY}, annt_ = 0x0, check_thr_id_ = 0, check_thr_ = false, check_ = true, static SIZE_THRESHOLD = 4194304}, buf_ = 0x7f082c110450, action_ = {first = 0x7f1d6ca61bb8, second = 3120}, certified_ = false, committed_ = false, exit_loop_ = false, cert_bypass_ = false, queued_ = false}, error=error@entry=0x7f1c863241b0) at galera/src/replicator_smm.cpp:1424

        retval = WSREP_OK

#16 0x00007f1dae948108 in galera_commit_order_leave (gh=<optimized out>, ws_handle=<optimized out>, meta=<optimized out>, error=0x7f1c863241b0) at galera/src/wsrep_provider.cpp:800

        trx = @0x7f05bc0338e0: {<galera::TrxHandle> = {_vptr.TrxHandle = 0x7f1daea026f0 <vtable for galera::TrxHandleMaster+16>, static TRXHANDLE_FLAGS_MASK = 33791, static EXPLICIT_ROLLBACK_FLAGS = 10, static FLAGS_MATCH_API_FLAGS = true, static num_states_ = 12, state_ = {delete_ = false, trans_map_ = 0x7f1daea09f20 <galera::TrxHandleMaster::trans_map_>, state_ = {first = galera::TrxHandle::S_MUST_REPLAY, second = 781}, state_hist_ = std::vector of length 3, capacity 4 = {{first = galera::TrxHandle::S_EXECUTING, second = 0}, {first = galera::TrxHandle::S_REPLICATING, second = 661}, {first = galera::TrxHandle::S_MUST_ABORT, second = 859}}}, source_id_ = {data = "z\242\262]\t\030\021�W\257\tR#P\270", alignment = 16938346102022906490}, conn_id_ = 6973, trx_id_ = 3346858112, timestamp_ = 1602184746126299309, version_ = 5, write_set_flags_ = 1, local_ = true, master_ = true}, static Defaults = {working_dir_ = ".", version_ = -1, key_format_ = galera::KeySet::FLAT16A, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 0}, mutex_ = {value_ = {__data = {__lock = 1, __count = 0, __owner = 30523, __nusers = 1, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000;w\000\000\001", '\000' <repeats 26 times>, __align = 1}}, mem_pool_ = @0x55769ecf3738, static trans_map_ = {impl_ = std::unordered_map with 22 elementsPython Exception <class 'gdb.error'> cannot resolve overloaded method `_M_before_begin': no arguments supplied:

}, params_ = {working_dir_ = "/datavolume/mariadb/maria_data/", version_ = 5, key_format_ = galera::KeySet::FLAT8, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 2147483647}, ts_ = {px = 0x7f082c110450, pn = {pi_ = 0x7efb478b85b0}}, wso_buf_size_ = 7960, gcs_handle_ = -1, wso_ = false, last_ts_seqno_ = 387232383, deferred_abort_ = false}

        lock = {trx_ = @0x7f05bc0338e0, locked_ = true}

        repl = 0x55769ecf2da0

        txp = 0x7f05bc0338e0

        __FUNCTION__ = "galera_commit_order_leave"

        retval = <optimized out>

#17 0x000055769d4b1a51 in wsrep::wsrep_provider_v26::commit_order_leave (this=<optimized out>, ws_handle=<optimized out>, ws_meta=<optimized out>, err=<optimized out>) at /home/buildbot/buildbot/build/wsrep-lib/src/wsrep_provider_v26.cpp:851

        cwsh = {ws_handle_ = @0x7f05ec0069d0, native_ = {trx_id = 3346858112, opaque = 0x7f05bc0338e0}}

        cwsm = {trx_meta_ = {gtid = {uuid = {data = "\331:#\255\253\306\021\352\276q\206p)\364\374", <incomplete sequence \364>, alignment = 16866480520125692633}, seqno = 387232383}, stid = {node = {data = "z\242\262]\t\030\021�W\257\tR#P\270", alignment = 16938346102022906490}, trx = 3346858112, conn = 18446744073709551615}, depends_on = -1}}

        err_buf = {ptr = 0x0, len = 0}

        ret = <optimized out>

#18 0x000055769d4a77f7 in wsrep::transaction::ordered_commit (this=this@entry=0x7f05ec006970) at /home/buildbot/buildbot/build/wsrep-lib/src/transaction.cpp:532

        lock = {mutex_ = @0x7f05ec0068d0, locked_ = true}

        ret = <optimized out>

#19 0x000055769cef6818 in ordered_commit (this=0x7f05ec006908) at /home/buildbot/buildbot/build/wsrep-lib/include/wsrep/client_state.hpp:479

No locals.

#20 wsrep_ordered_commit (all=<optimized out>, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/wsrep_trans_observer.h:300

No locals.

#21 MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=this@entry=0x55769dd1b120 <mysql_bin_log>, entry=entry@entry=0x7f1c86324310) at /home/buildbot/buildbot/build/sql/log.cc:7751

        is_leader = 1

#22 0x000055769cef6e00 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x55769dd1b120 <mysql_bin_log>, thd=thd@entry=0x7f05ec0009a8, cache_mngr=cache_mngr@entry=0x7f05ec18ff48, end_ev=end_ev@entry=0x7f1c86324460, all=<optimized out>, using_stmt_cache=using_stmt_cache@entry=false, using_trx_cache=using_trx_cache@entry=true) at /home/buildbot/buildbot/build/sql/log.cc:7418

        entry = {next = 0x0, thd = 0x7f05ec0009a8, cache_mngr = 0x7f05ec18ff48, using_stmt_cache = false, using_trx_cache = true, end_event = 0x7f1c86324460, incident_event = 0x0, error = 0, commit_errno = 0, error_cache = 0xffffffffffffffff, all = false, need_unlog = false, check_purge = 35, queued_by_other = false, binlog_id = 17653253098204197310}

        ha_info = <optimized out>

#23 0x000055769cef6fad in binlog_flush_cache (thd=thd@entry=0x7f05ec0009a8, cache_mngr=cache_mngr@entry=0x7f05ec18ff48, end_ev=end_ev@entry=0x7f1c86324460, all=all@entry=false, using_stmt=using_stmt@entry=false, using_trx=using_trx@entry=true) at /home/buildbot/buildbot/build/sql/log.cc:1788

        error = 0

#24 0x000055769cef72ce in binlog_rollback_flush_trx_cache (thd=thd@entry=0x7f05ec0009a8, all=all@entry=false, cache_mngr=cache_mngr@entry=0x7f05ec18ff48) at /home/buildbot/buildbot/build/sql/log.cc:1874

        end_evt = {<Log_event> = {_vptr.Log_event = 0x55769dbf5370 <vtable for Query_log_event+16>, log_pos = 0, temp_buf = 0x0, event_owns_temp_buf = false, when = 1602184746, when_sec_part = 126177, exec_time = 0, data_written = 0, server_id = 135, flags = 12, cache_type = 3, slave_exec_mode = 0, writer = 0x0, thd = 0x7f05ec0009a8, checksum_alg = BINLOG_CHECKSUM_ALG_UNDEF}, user = {str = 0x0, length = 0}, host = {str = 0x0, length = 0}, data_buf = 0x0, query = 0x55769d6341ed "ROLLBACK", catalog = 0x55769d510608 "std", db = 0x7f05ec0dcf78 "wjtblep", q_len = 8, db_len = 7, error_code = 0, thread_id = 6973, slave_proxy_id = 6973, catalog_len = 3, status_vars_len = 0, flags2_inited = true, sql_mode_inited = true, charset_inited = true, flags2 = 0, sql_mode = 1411383300, auto_increment_increment = 5, auto_increment_offset = 4, charset = "!\000!\000S", time_zone_len = 6, time_zone_str = 0x55769d64b1c1 "SYSTEM", lc_time_names_number = 0, charset_database_number = 0, table_map_for_update = 0, master_data_written = 0}

#25 0x000055769cef75a9 in binlog_rollback (hton=<optimized out>, thd=0x7f05ec0009a8, all=<optimized out>) at /home/buildbot/buildbot/build/sql/log.cc:2139

        error = 0

        cache_mngr = 0x7f05ec18ff48

#26 0x000055769ce0a71b in ha_rollback_trans (thd=thd@entry=0x7f05ec0009a8, all=all@entry=false) at /home/buildbot/buildbot/build/sql/handler.cc:1909

        err = <optimized out>

        ht = <optimized out>

        ha_info_next = <optimized out>

        error = <optimized out>

        trans = 0x7f05ec003da8

        ha_info = 0x7f05ec002e00

        is_real_trans = <optimized out>

#27 0x000055769ce15ed4 in ha_commit_trans (thd=thd@entry=0x7f05ec0009a8, all=all@entry=false) at /home/buildbot/buildbot/build/sql/handler.cc:1681

        cookie = <optimized out>

        need_prepare_ordered = <optimized out>

        need_commit_ordered = <optimized out>

        xid = <optimized out>

        error = 1

        trans = <optimized out>

        is_real_trans = true

        ha_info = <optimized out>

        rw_ha_count = 2

        rw_trans = <optimized out>

#28 0x000055769ccf475f in trans_commit_stmt (thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/transaction.cc:436

        res = 0

#29 0x000055769cbface2 in mysql_execute_command (thd=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6156

        res = 0

        lex = <optimized out>

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = <optimized out>, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        orig_binlog_format = BINLOG_FORMAT_ROW

        up_result = <optimized out>

        rpl_filter = <optimized out>

        ots = {ctx = 0x7f05ec004320, traceable = false}

        orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW

        select_lex = <optimized out>

        first_table = <optimized out>

        all_tables = 0x7efb47b5c150

        unit = <optimized out>

        have_table_map_for_update = <optimized out>

#30 0x000055769cb5f8e5 in sp_instr_stmt::exec_core (this=0x7efb47b616e0, thd=<optimized out>, nextp=0x7f1c863274a0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3687

        res = 0

#31 0x000055769cb67c79 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7efb47b61728, thd=thd@entry=0x7f05ec0009a8, nextp=nextp@entry=0x7f1c863274a0, open_tables=open_tables@entry=false, instr=instr@entry=0x7efb47b616e0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3419

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        res = <optimized out>

        parent_modified_non_trans_table = false

        ots = {ctx = 0x7f05ec004320, traceable = false}

#32 0x000055769cb6871c in sp_instr_stmt::execute (this=0x7efb47b616e0, thd=0x7f05ec0009a8, nextp=0x7f1c863274a0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3593

        log_slow = <optimized out>

        res = 0

        save_enable_slow_log = false

        query_backup = {string = {str = 0x7ef91d7d5280 "CALL SP_DUES_SET_SAVE_DSCT_ORD( NAME_CONST('in_inqrYm',_utf8'202010' COLLATE 'utf8_bin'),\r\n", ' ' <repeats 34 times>, "NAME_CONST('in_empNo',_utf8'BATCH' COLLATE 'utf8_bin'),\r\n", ' ' <repeats 18 times>..., length = 366}, cs = 0x55769dcd6240 <my_charset_utf8_general_ci>}

        backup_state = {auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, auto_inc_intervals_forced = {head = 0x0, tail = 0x3e8, current = 0x0, elements = 0}, savepoints = 0x7ef91d7e873f, option_bits = 0, first_successful_insert_id_in_prev_stmt = 0, first_successful_insert_id_in_cur_stmt = 8603404019444424814, insert_id_for_cur_row = 6998637137531333727, limit_found_rows = 139608409412176, tmp_tables_size = 6279520, client_capabilities = 139608408661504, cuted_fields = 93967926405520, sent_row_count = 0, examined_row_count = 73, affected_rows = 12, bytes_sent_old = 462, tmp_tables_used = 3, tmp_tables_disk_used = 0, query_plan_fsort_passes = 0, query_plan_flags = 802, in_sub_stmt = 0, enable_slow_log = false, last_insert_id_used = false, count_cuted_fields = CHECK_FIELD_IGNORE}

#33 0x000055769cb636f7 in sp_head::execute (this=this@entry=0x7f05ec515920, thd=thd@entry=0x7f05ec0009a8, merge_da_on_success=merge_da_on_success@entry=true) at /home/buildbot/buildbot/build/sql/sp_head.cc:1364

        parent_digest = 0x0

        saved_cur_db_name_buf = "\260v2\206\034\177\000\000\322\361\266\234vU\000\000\300v2\206\034\177\000\000 w2\206\034\177\000\000\220v2\206\034\177\000\000]\275?vU\000\000\300v2\206\034\177\000\000N\205?vU\000\000\000\000\000\000\000\000\000\000\240j}\035\371~\000\000\340v2\206\034\177\000\000\025\031\266\234vU\000\000 w2\206\034\177\000\000\204*2\235vU\000\000\060w2\206\034\177\000\000\222\025\273\234vU\000\000\000w2\206\034\177\000\000@YQ\354\005\177\000\000@YQ\354\005\177\000\000\000\\Q\354\005\177\000\000 YQ\354\005\177\000\000 YQ\354\005\177\000\000\340w2\206\034\177\000\000\250\t\000\354\005\177\000\000\000\\Q\354\005\177\000\000\000"

        saved_cur_db_name = {str = 0x7f1c86327660 "\260v2\206\034\177", length = 202}

        ctx = 0x7ef91d7d5598

        execute_mem_root = {free = 0x7ef91d7e79b8, used = 0x7ef91d5c1738, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 16304, block_num = 6, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d50e3be "per_instruction_memroot"}

        old_query_id = 3346857146

        old_rec_tables = 0x0

        old_change_list = {change_list = {<base_ilist> = {first = 0x7f05ec000a60, last = {_vptr.ilink = 0x55769dafeb50 <vtable for ilink+16>, prev = 0x7f05ec000a58, next = 0x0}}, <No data fields>}}

        ip = 51

        saved_creation_ctx = 0x7ef91d9b22c0

        cur_db_changed = false

        err_status = false

        execute_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f1c86327550, state = Query_arena::STMT_INITIALIZED_FOR_SP}

        backup_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x7ef91da6a918, mem_root = 0x7f1c8632a690, state = Query_arena::STMT_INITIALIZED_FOR_SP}

        old_lex = 0x7f05ec878b00

        status_backup_mask = 192

        user_var_events_alloc_saved = 0x7f1c8632a690

        i = 0x7efb47b616e0

        old_derived_tables = 0x0

        old_server_status = 64

        save_abort_on_warning = false

        old_arena = 0x7f05ec87ad28

        old_packet = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}

        save_reprepare_observer = 0x0

        save_sql_mode = 0

        da = 0x7f05ec0061d0

        sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d510f48 "Warning_info"}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f1c863275f8}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 10, m_warn_id = 3346858112, m_error_condition = 0x0, m_allow_unlimited_warnings = false, initialized = true, m_read_only = false, m_next_in_da = 0x7f1c8632a6e0, m_prev_in_da = 0x7f05ec0064d8, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55769dcea630 <end_of_list>, last = 0x7f1c86327640, elements = 0}, <No data fields>}}

#34 0x000055769cb64bf9 in sp_head::execute_procedure (this=0x7f05ec515920, thd=thd@entry=0x7f05ec0009a8, args=0x7f05ec879a88) at /home/buildbot/buildbot/build/sql/sp_head.cc:2370

        params = <optimized out>

        save_spcont = 0x7ef91ddb6498

        nctx = 0x7ef91d7d5598

        octx = <optimized out>

        save_log_general = false

        need_binlog_call = <optimized out>

        err_status = false

        utime_before_sp_exec = 849084505740

        save_enable_slow_log = false

        pkg = 0x0

        save_security_ctx = 0x0

#35 0x000055769cbf1f4a in do_execute_sp (thd=0x7f05ec0009a8, sp=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3005

        bits_to_be_cleared = <optimized out>

        affected_rows = <optimized out>

        select_limit = 18446744073709551615

        res = <optimized out>

        sp = <optimized out>

        thd = 0x7f05ec0009a8

#36 0x000055769cbf3876 in Sql_cmd_call::execute (this=this@entry=0x7f05ec87a690, thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3247

        sp = 0x7f05ec515920

#37 0x000055769cbf40b0 in Sql_cmd_call::execute (this=0x7f05ec87a690, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3201

No locals.

#38 0x000055769cbfc590 in mysql_execute_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6098

        res = 0

        lex = 0x7f05ec878b00

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        orig_binlog_format = <optimized out>

        up_result = 0

        rpl_filter = <optimized out>

        ots = {ctx = 0x7f05ec004320, traceable = false}

        orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW

        select_lex = 0x7f05ec8793b8

        first_table = 0x0

        all_tables = 0x0

        unit = 0x7f05ec878bc0

        have_table_map_for_update = false

#39 0x000055769cb5f8e5 in sp_instr_stmt::exec_core (this=0x7f05ec87ad28, thd=<optimized out>, nextp=0x7f1c8632a5e0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3687

        res = 0

#40 0x000055769cb67c79 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f05ec87ad70, thd=thd@entry=0x7f05ec0009a8, nextp=nextp@entry=0x7f1c8632a5e0, open_tables=open_tables@entry=false, instr=instr@entry=0x7f05ec87ad28) at /home/buildbot/buildbot/build/sql/sp_head.cc:3419

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        res = <optimized out>

        parent_modified_non_trans_table = false

        ots = {ctx = 0x7f05ec004320, traceable = false}

#41 0x000055769cb6871c in sp_instr_stmt::execute (this=0x7f05ec87ad28, thd=0x7f05ec0009a8, nextp=0x7f1c8632a5e0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3593

        log_slow = <optimized out>

        res = 0

        save_enable_slow_log = false

        query_backup = {string = {str = 0x7ef91ddb60c0 "CALL SP_DUES_SET_DSCT_SETUP( NAME_CONST('v_ITAB_vndrCstmrId',_utf8'0027385924' COLLATE 'utf8_bin'),   #��ǰó ����ID\r\n", ' ' <repeats 33 times>, "NAME_CONST('in_analsYm',_utf8'202010' COLLAT"..., length = 549}, cs = 0x55769dcd6240 <my_charset_utf8_general_ci>}

        backup_state = {auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, auto_inc_intervals_forced = {head = 0x0, tail = 0x1ec093c28, current = 0x0, elements = 0}, savepoints = 0x1, option_bits = 139663410989480, first_successful_insert_id_in_prev_stmt = 93967941558080, first_successful_insert_id_in_cur_stmt = 139760487276590, insert_id_for_cur_row = 274877906944, limit_found_rows = 0, tmp_tables_size = 454212504, client_capabilities = 139663411592720, cuted_fields = 139663411592224, sent_row_count = 0, examined_row_count = 122927, affected_rows = 1556, bytes_sent_old = 462, tmp_tables_used = 239, tmp_tables_disk_used = 0, query_plan_fsort_passes = 0, query_plan_flags = 826, in_sub_stmt = 3960028696, enable_slow_log = 5, last_insert_id_used = 127, count_cuted_fields = CHECK_FIELD_IGNORE}

#42 0x000055769cb636f7 in sp_head::execute (this=this@entry=0x7f05ed554090, thd=thd@entry=0x7f05ec0009a8, merge_da_on_success=merge_da_on_success@entry=true) at /home/buildbot/buildbot/build/sql/sp_head.cc:1364

        parent_digest = 0x0

        saved_cur_db_name_buf = "\360\247\062\206\034\177\000\000\322\361\266\234vU\000\000\000\250\062\206\034\177\000\000`\250\062\206\034\177\000\000��2\206\034\177\000\000]\275?vU\000\000\000\250\062\206\034\177\000\000N\205?vU\000\000\000\000\000\000\000\000\000\000\240z\333\035\371~\000\000 \250\062\206\034\177\000\000\025\031\266\234vU\000\000`\250\062\206\034\177\000\000\204*2\235vU\000\000p\250\062\206\034\177\000\000\222\025\273\234vU\000\000@\250\062\206\034\177\000\000\260@U\355\005\177\000\000\260@U\355\005\177\000\000pCU\355\005\177\000\000\220@U\355\005\177\000\000\220@U\355\005\177\000\000 \251\062\206\034\177\000\000\250\t\000\354\005\177\000\000pCU\355\005\177\000\000\000"

        saved_cur_db_name = {str = 0x7f1c8632a7a0 "\360\247\062\206\034\177", length = 202}

        ctx = 0x7ef91ddb6498

        execute_mem_root = {free = 0x7ef91d9b0348, used = 0x7ef91d7d5168, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 24456, block_num = 7, first_block_usage = 6, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d50e3be "per_instruction_memroot"}

        old_query_id = 3346756135

        old_rec_tables = 0x0

        old_change_list = {change_list = {<base_ilist> = {first = 0x7f05ec000a60, last = {_vptr.ilink = 0x55769dafeb50 <vtable for ilink+16>, prev = 0x7f05ec000a58, next = 0x0}}, <No data fields>}}

        ip = 88

        saved_creation_ctx = 0x7ef91d58bcf8

        cur_db_changed = false

        err_status = false

        execute_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f1c8632a690, state = Query_arena::STMT_INITIALIZED_FOR_SP}

        backup_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x7ef91d94a550, mem_root = 0x7f1c8632d7d0, state = Query_arena::STMT_INITIALIZED_FOR_SP}

        old_lex = 0x7f05ed524c80

        status_backup_mask = 192

        user_var_events_alloc_saved = 0x7f1c8632d7d0

        i = 0x7f05ec87ad28

        old_derived_tables = 0x0

        old_server_status = 64

        save_abort_on_warning = false

        old_arena = 0x7f05ec0385e8

        old_packet = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}

        save_reprepare_observer = 0x0

        save_sql_mode = 0

        da = 0x7f05ec0061d0

        sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d510f48 "Warning_info"}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f1c8632a738}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 3346766828, m_error_condition = 0x0, m_allow_unlimited_warnings = false, initialized = true, m_read_only = false, m_next_in_da = 0x7f1c8632d820, m_prev_in_da = 0x7f1c86327630, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55769dcea630 <end_of_list>, last = 0x7f1c8632a780, elements = 0}, <No data fields>}}

#43 0x000055769cb64bf9 in sp_head::execute_procedure (this=0x7f05ed554090, thd=thd@entry=0x7f05ec0009a8, args=0x7f05ed525c08) at /home/buildbot/buildbot/build/sql/sp_head.cc:2370

        params = <optimized out>

        save_spcont = 0x7f05ec015858

        nctx = 0x7ef91ddb6498

        octx = <optimized out>

        save_log_general = false

        need_binlog_call = <optimized out>

        err_status = false

        utime_before_sp_exec = 849084505740

        save_enable_slow_log = false

        pkg = 0x0

        save_security_ctx = 0x0

#44 0x000055769cbf1f4a in do_execute_sp (thd=0x7f05ec0009a8, sp=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3005

        bits_to_be_cleared = <optimized out>

        affected_rows = <optimized out>

        select_limit = 18446744073709551615

        res = <optimized out>

        sp = <optimized out>

        thd = 0x7f05ec0009a8

#45 0x000055769cbf3876 in Sql_cmd_call::execute (this=this@entry=0x7f05ec037e60, thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3247

        sp = 0x7f05ed554090

#46 0x000055769cbf40b0 in Sql_cmd_call::execute (this=0x7f05ec037e60, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3201

No locals.

#47 0x000055769cbfc590 in mysql_execute_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6098

        res = 0

        lex = 0x7f05ed524c80

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        orig_binlog_format = <optimized out>

        up_result = 0

        rpl_filter = <optimized out>

        ots = {ctx = 0x7f05ec004320, traceable = false}

        orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW

        select_lex = 0x7f05ed525538

        first_table = 0x0

        all_tables = 0x0

        unit = 0x7f05ed524d40

        have_table_map_for_update = false

#48 0x000055769cb5f8e5 in sp_instr_stmt::exec_core (this=0x7f05ec0385e8, thd=<optimized out>, nextp=0x7f1c8632d720) at /home/buildbot/buildbot/build/sql/sp_head.cc:3687

        res = 0

#49 0x000055769cb67c79 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f05ec038630, thd=thd@entry=0x7f05ec0009a8, nextp=nextp@entry=0x7f1c8632d720, open_tables=open_tables@entry=false, instr=instr@entry=0x7f05ec0385e8) at /home/buildbot/buildbot/build/sql/sp_head.cc:3419

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        res = <optimized out>

        parent_modified_non_trans_table = false

        ots = {ctx = 0x7f05ec004320, traceable = false}

#50 0x000055769cb6871c in sp_instr_stmt::execute (this=0x7f05ec0385e8, thd=0x7f05ec0009a8, nextp=0x7f1c8632d720) at /home/buildbot/buildbot/build/sql/sp_head.cc:3593

        log_slow = <optimized out>

        res = 0

        save_enable_slow_log = false

        query_backup = {string = {str = 0x7f05ec00fe60 "/*[com.wjthinkbig.lep.bt.ac.duesCalc.service.dao.DuesReSumDao.procDuesReSumScpeList]*/\n\t\t call SP_BAT_DUES_SET_CRTN_STEP2\n\t\t\t(\n\t\t\t'202010',\n\t\t\t'0027274480',\n\t\t\t'0027386160'\n\t\t\t)", length = 177}, cs = 0x55769dcd5dc0 <my_charset_utf8mb4_general_ci>}

        backup_state = {auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, auto_inc_intervals_forced = {head = 0x0, tail = 0x7f05ec04f1b0, current = 0x0, elements = 0}, savepoints = 0x7f1c8632d4b0, option_bits = 93967926431602, first_successful_insert_id_in_prev_stmt = 139663412133576, first_successful_insert_id_in_cur_stmt = 34359738369, insert_id_for_cur_row = 93967941984448, limit_found_rows = 139663411463482, tmp_tables_size = 2661773169792, client_capabilities = 0, cuted_fields = 1, sent_row_count = 0, examined_row_count = 7108302929361928460, affected_rows = 8704326, bytes_sent_old = 462, tmp_tables_used = 1486952, tmp_tables_disk_used = 20904, query_plan_fsort_passes = 0, query_plan_flags = 1850, in_sub_stmt = 2647482368, enable_slow_log = 118, last_insert_id_used = 85, count_cuted_fields = CHECK_FIELD_IGNORE}

#51 0x000055769cb636f7 in sp_head::execute (this=this@entry=0x7f05ec0e34a0, thd=thd@entry=0x7f05ec0009a8, merge_da_on_success=merge_da_on_success@entry=true) at /home/buildbot/buildbot/build/sql/sp_head.cc:1364

        parent_digest = 0x0

        saved_cur_db_name_buf = "0\331\062\206\034\177\000\000\322\361\266\234vU\000\000@\331\062\206\034\177\000\000\240\331\062\206\034\177\000\000\000\000\000\000\000\000\000\000\240\064\016\354\005\177\000\000\250\t\000\354\005\177\000\000\240\064\016\354\005\177\000\000\000\000\000\000\000\000\000\000\240\331\062\206\034\177\000\000`\331\062\206\034\177\000\000\025\031\266\234vU\000\000\240\331\062\206\034\177\000\000\204*2\235vU\000\000\260\331\062\206\034\177\000\000\222\025\273\234vU\000\000\070\367\r\354\005\177\000\000\300\064\016\354\005\177\000\000\300\064\016\354\005\177\000\000\200\067\016\354\005\177\000\000\240\064\016\354\005\177\000\000\240\064\016\354\005\177\000\000`\332\062\206\034\177\000\000\250\t\000\354\005\177\000\000\200\067\016\354\005\177\000\000"...

        saved_cur_db_name = {str = 0x7f1c8632d8e0 "0\331\062\206\034\177", length = 202}

        ctx = 0x7f05ec015858

        execute_mem_root = {free = 0x7ef91d799478, used = 0x7ef91d589d48, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 32608, block_num = 8, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d50e3be "per_instruction_memroot"}

        old_query_id = 1987669015

        old_rec_tables = 0x0

        old_change_list = {change_list = {<base_ilist> = {first = 0x7f05ec000a60, last = {_vptr.ilink = 0x55769dafeb50 <vtable for ilink+16>, prev = 0x7f05ec000a58, next = 0x0}}, <No data fields>}}

        ip = 49

        saved_creation_ctx = 0x7f05ec0522e0

        cur_db_changed = false

        err_status = false

        execute_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f1c8632d7d0, state = Query_arena::STMT_INITIALIZED_FOR_SP}

        backup_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x7f05ec0521d0, mem_root = 0x7f05ec006188, state = Query_arena::STMT_CONVENTIONAL_EXECUTION}

        old_lex = 0x7f05ec0dd470

        status_backup_mask = 192

        user_var_events_alloc_saved = 0x7f05ec006188

        i = 0x7f05ec0385e8

        old_derived_tables = 0x0

        old_server_status = 0

        save_abort_on_warning = false

        old_arena = 0x7f05ed51f580

        old_packet = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f05ec00bad8 "\003def", str_length = 23}, Alloced_length = 16392, extra_alloc = 0, alloced = true, thread_specific = false}, <No data fields>}

        save_reprepare_observer = 0x7f1c86330240

        save_sql_mode = 2097152

        da = 0x7f05ec0061d0

        sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d510f48 "Warning_info"}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f1c8632d878}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 3346669562, m_error_condition = 0x0, m_allow_unlimited_warnings = false, initialized = true, m_read_only = false, m_next_in_da = 0x7f05ec006410, m_prev_in_da = 0x7f1c8632a770, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55769dcea630 <end_of_list>, last = 0x7f1c8632d8c0, elements = 0}, <No data fields>}}

#52 0x000055769cb64bf9 in sp_head::execute_procedure (this=0x7f05ec0e34a0, thd=thd@entry=0x7f05ec0009a8, args=0x7f05ec0de3f8) at /home/buildbot/buildbot/build/sql/sp_head.cc:2370

        params = <optimized out>

        save_spcont = 0x0

        nctx = 0x7f05ec015858

        octx = <optimized out>

        save_log_general = true

        need_binlog_call = <optimized out>

        err_status = false

        utime_before_sp_exec = 849082209912

        save_enable_slow_log = true

        pkg = 0x0

        save_security_ctx = 0x0

#53 0x000055769cbf1f4a in do_execute_sp (thd=0x7f05ec0009a8, sp=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3005

        bits_to_be_cleared = <optimized out>

        affected_rows = <optimized out>

        select_limit = 18446744073709551615

        res = <optimized out>

        sp = <optimized out>

        thd = 0x7f05ec0009a8

#54 0x000055769cbf3876 in Sql_cmd_call::execute (this=this@entry=0x7f05ec0df1c0, thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3247

        sp = 0x7f05ec0e34a0

#55 0x000055769cbf40b0 in Sql_cmd_call::execute (this=0x7f05ec0df1c0, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3201

No locals.

#56 0x000055769cbfc590 in mysql_execute_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6098

        res = 0

        lex = 0x7f05ec0dd470

        trace_command = <optimized out>

        trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>}

        orig_binlog_format = <optimized out>

        up_result = 0

        rpl_filter = <optimized out>

        ots = {ctx = 0x7f05ec004320, traceable = false}

        orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW

        select_lex = 0x7f05ec0ddd28

        first_table = 0x0

        all_tables = 0x0

        unit = 0x7f05ec0dd530

        have_table_map_for_update = false

#57 0x000055769cc15975 in Prepared_statement::execute (this=this@entry=0x7f05ed51f568, expanded_query=expanded_query@entry=0x7f1c863302c0, open_cursor=open_cursor@entry=false) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:4765

        parent_locker = <optimized out>

        stmt_backup = {<ilink> = {_vptr.ilink = 0x55769db07a70 <vtable for Statement+16>, prev = 0x0, next = 0x0}, <Query_arena> = {_vptr.Query_arena = 0x55769db07aa0 <vtable for Statement+64>, free_list = 0x7f05ecb7bdb8, mem_root = 0x7f1c863300ae, state = -1647911104}, id = 0, column_usage = MARK_COLUMNS_READ, name = {str = 0x55769d451b42 <my_string_metadata_get+130> "\203", <incomplete sequence \370>, length = 48}, lex = 0x7f05ec004650, query_string = {string = {str = 0x7f05ec00fe60 "/*[com.wjthinkbig.lep.bt.ac.duesCalc.service.dao.DuesReSumDao.procDuesReSumScpeList]*/\n\t\t call SP_BAT_DUES_SET_CRTN_STEP2\n\t\t\t(\n\t\t\t'202010',\n\t\t\t'0027274480',\n\t\t\t'0027386160'\n\t\t\t)", length = 177}, cs = 0x55769dcd5dc0 <my_charset_utf8mb4_general_ci>}, base_query = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}, db = {str = 0x55769cc80a52 <String::append(char const*, unsigned long)+258> "D\001c\020\061\300\351q\377\377\377\017\037", length = 0}, query_cache_is_applicable = 0 '\000'}

        old_stmt_arena = 0x7f05ec0009c0

        saved_cur_db_name_buf = "\n\000\000\000\000\000\000\000\030\371\r\354\005\177\000\000\030\371\r\354\005\177\000\000\217\000\000\000\000\000\000\000\300\002\063\206\034\177\000\000\307z\000\354\005\177\000\000\300\001\063\206\034\177\000\000\307\t\301\234vU\000\000\224\000\000\000\000\000\000\000\250\t\000\354\005\177\000\000\210\001\063\206\034\177\000\000\242z\000\354\005\177\000\000\000\371\r\354\005\177\000\000\030\371\r\354\005\177\000\000\260\357\r\354\005\177\000\000\307z\000\354\005\177\000\000\250\t\000\354\005\177\000\000h\365Q\355\005\177\000\000\030\371\r\354\005\177\000\000\300\002\063\206\034\177\000\000\252z\000\354\005\177\000\000\242z\000\354\005\177\000\000 \002\063\206\034\177\000\000XI\301\234vU\000\000\310z\000\354\005\177\000\000"...

        saved_cur_db_name = {str = 0x7f1c86330110 "\n", length = 202}

        cur_db_changed = false

        error = true

        qc_executed = false

        stmt_db_name = {str = 0x7f05ec0defa8 "wjtblep", length = 7}

#58 0x000055769cc15a82 in Prepared_statement::execute_loop (this=0x7f05ed51f568, expanded_query=0x7f1c863302c0, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:4251

        reprepare_observer = {m_invalidated = false}

        error = <optimized out>

#59 0x000055769cc163c7 in mysql_stmt_execute_common (thd=thd@entry=0x7f05ec0009a8, stmt_id=833, packet=packet@entry=0x7f05ec007aa2 "", packet_end=packet_end@entry=0x7f05ec007ac7 "", cursor_flags=0, bulk_op=bulk_op@entry=false, read_types=read_types@entry=false) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:3260

        expanded_query = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f05ecb7bdb8 "/*[com.wjthinkbig.lep.bt.ac.duesCalc.service.dao.DuesReSumDao.procDuesReSumScpeList]*/\n\t\t call SP_BAT_DUES_SET_CRTN_STEP2\n\t\t\t(\n\t\t\t'202010',\n\t\t\t'0027274480',\n\t\t\t'0027386160'\n\t\t\t)", str_length = 177}, Alloced_length = 264, extra_alloc = 128, alloced = true, thread_specific = false}, <No data fields>}

        stmt = 0x7f05ed51f568

        save_protocol = 0x7f05ec000ee8

        open_cursor = false

#60 0x000055769cc16457 in mysqld_stmt_execute (thd=thd@entry=0x7f05ec0009a8, packet_arg=packet_arg@entry=0x7f05ec007a99 "A\003", packet_length=packet_length@entry=46) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:3158

        packet = 0x7f05ec007aa2 ""

        stmt_id = <optimized out>

        flags = <optimized out>

        packet_end = 0x7f05ec007ac7 ""

#61 0x000055769cc050e1 in dispatch_command (command=command@entry=COM_STMT_EXECUTE, thd=thd@entry=0x7f05ec0009a8, packet=packet@entry=0x7f05ec007a99 "A\003", packet_length=packet_length@entry=46, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1758

        net = 0x7f05ec000c18

        do_end_of_statement = true

        __FUNCTION__ = "dispatch_command"

        error = false

        drop_more_results = false

#62 0x000055769cc06e89 in do_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1353

        return_value = <optimized out>

        packet = 0x7f05ec007a98 "\027A\003"

        packet_length = <optimized out>

        net = 0x7f05ec000c18

        command = COM_STMT_EXECUTE

        __FUNCTION__ = "do_command"

#63 0x000055769cce5f9a in do_handle_one_connection (connect=connect@entry=0x55770618c478) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1412

        create_user = true

        thr_create_utime = <optimized out>

        thd = 0x7f05ec0009a8

#64 0x000055769cce607d in handle_one_connection (arg=arg@entry=0x55770618c478) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1316

        connect = 0x55770618c478

#65 0x000055769d320bdd in pfs_spawn_thread (arg=0x5577062dc058) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1869

        typed_arg = 0x5577062dc058

        user_arg = 0x55770618c478

        pfs = <optimized out>

        user_start_routine = 0x55769cce6040 <handle_one_connection(void*)>

        klass = <optimized out>

#66 0x00007f1e61787e75 in start_thread () from /lib64/libpthread.so.0

No symbol table info available.

#67 0x00007f1e605e58fd in clone () from /lib64/libc.so.6

No symbol table info available.

Jan Lindström (Inactive) added a comment - 2020-10-30 05:50 GDB output from crash: #8 0x000055769ce0772f in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/sql/signal_handler.cc:207 curr_time = 1602184746 tm = {tm_sec = 6, tm_min = 19, tm_hour = 4, tm_mday = 9, tm_mon = 9, tm_year = 120, tm_wday = 5, tm_yday = 282, tm_isdst = 0, tm_gmtoff = 32400, tm_zone = 0x55769ec0a060 "KST"} print_invalid_query_pointer = false #9 <signal handler called> No symbol table info available. #10 0x00007f1e6051d3a7 in raise () from /lib64/libc.so.6 No symbol table info available. #11 0x00007f1e6051ea98 in abort () from /lib64/libc.so.6 No symbol table info available. #12 0x00007f1dae93a82e in galera::FSM<galera::TrxHandle::State, galera::TrxHandle::Transition, galera::EmptyGuard, galera::EmptyAction>::shift_to (this=this@entry=0x7f082c110458, state=state@entry=galera::TrxHandle::S_COMMITTED, line=line@entry=1424) at galera/src/fsm.hpp:85 __FUNCTION__ = "shift_to" i = {<std::__detail::_Node_iterator_base<std::pair<galera::TrxHandle::Transition const, galera::FSM<galera::TrxHandle::State, galera::TrxHandle::Transition>::TransAttr>, true>> = {_M_cur = 0x0}, <No data fields>} gi = <optimized out> ai = <optimized out> se = <optimized out> #13 0x00007f1dae92bee7 in set_state (line=1424, state=galera::TrxHandle::S_COMMITTED, this=0x7f082c110450) at galera/src/trx_handle.hpp:222 No locals. #14 set_state (line=1424, state=galera::TrxHandle::S_COMMITTED, this=0x7f082c110450) at galera/src/trx_handle.hpp:594 No locals. #15 galera::ReplicatorSMM::commit_order_leave (this=this@entry=0x55769ecf2da0, ts=Python Exception <class 'gdb.error'> cannot resolve overloaded method `_M_before_begin': no arguments supplied: @0x7f082c110450: {<galera::TrxHandle> = {_vptr.TrxHandle = 0x7f1daea027f0 <vtable for galera::TrxHandleSlave+16>, static TRXHANDLE_FLAGS_MASK = 33791, static EXPLICIT_ROLLBACK_FLAGS = 10, static FLAGS_MATCH_API_FLAGS = true, static num_states_ = 12, state_ = {delete_ = false, trans_map_ = 0x7f1daea09ee0 <galera::TrxHandleSlave::trans_map_>, state_ = {first = galera::TrxHandle::S_REPLICATING, second = 0}, state_hist_ = std::vector of length 0, capacity 0}, source_id_ = {data = "z\242\262]\t\030\021�W\257\tR#P\270", alignment = 16938346102022906490}, conn_id_ = 6973, trx_id_ = 3346858112, timestamp_ = 853817613795143, version_ = 5, write_set_flags_ = 65, local_ = true, master_ = false}, static trans_map_ = {impl_ = std::unordered_map with 4 elements}, local_seqno_ = 10791398, global_seqno_ = 387232383, last_seen_seqno_ = 387232378, depends_seqno_ = 387232375, ends_nbo_ = -1, mem_pool_ = @0x55769ecf3510, write_set_ = {header_ = {static MAGIC_BYTE = 71 'G', static V3_CHECKSUM_SIZE = 8, static V3_ANNOT_FLAG = 1 '\001', static V3_UNORD_FLAG = 2 '\002', static V3_MAGIC_OFF = 0, static V3_HEADER_VERS_OFF = 1, static V3_HEADER_SIZE_OFF = 2, static V3_SETS_OFF = 3, static V3_FLAGS_OFF = 4, static V3_PA_RANGE_OFF = 6, static V3_LAST_SEEN_OFF = 8, static V3_SEQNO_OFF = 8, static V3_TIMESTAMP_OFF = 16, static V3_SOURCE_ID_OFF = 24, static V3_CONN_ID_OFF = 40, static V3_TRX_ID_OFF = 48, static V3_CRC_OFF = 56, static V3_SIZE = 64, static V3 = {header_ver_ = 1, header_size_ = 2, sets_ = 3, flags_ = 4, pa_range_ = 6, last_seen_ = 8, seqno_ = 8, timestamp_ = 16, source_id_ = 24, conn_id_ = 40, trx_id_ = 48, crc_ = 56}, static MAX_HEADER_SIZE = 64, local_ = '\000' <repeats 63 times>, ptr_ = 0x7f1d6ca61bb8 <Address 0x7f1d6ca61bb8 out of bounds>, ver_ = galera::WriteSetNG::VER5, size_ = 64 '@', chksm_ = {<No data fields>}}, size_ = 3120, keys_ = {<gu::RecordSetIn<galera::KeySet::KeyPart>> = {<gu::RecordSetInBase> = {<gu::RecordSet> = {static MAX_VERSION = gu::RecordSet::VER2, static VER2_ALIGNMENT = 8, size_ = 88, count_ = 8, version_ = 2 '\002', check_type_ = 3 '\003', alignment_ = 8 '\b'}, head_ = 0x7f1d6ca61bf8 <Address 0x7f1d6ca61bf8 out of bounds>, next_ = 88, begin_ = 24}, <No data fields>}, version_ = galera::KeySet::FLAT8}, data_ = {<gu::RecordSetIn<galera::DataSet::RecordIn>> = {<gu::RecordSetInBase> = {<gu::RecordSet> = {static MAX_VERSION = gu::RecordSet::VER2, static VER2_ALIGNMENT = 8, size_ = 2965, count_ = 1, version_ = 2 '\002', check_type_ = 3 '\003', alignment_ = 8 '\b'}, head_ = 0x7f1d6ca61c50 <Address 0x7f1d6ca61c50 out of bounds>, next_ = 24, begin_ = 24}, <No data fields>}, version_ = galera::DataSet::VER1}, unrd_ = {<gu::RecordSetIn<galera::DataSet::RecordIn>> = {<gu::RecordSetInBase> = {<gu::RecordSet> = {static MAX_VERSION = gu::RecordSet::VER2, static VER2_ALIGNMENT = 8, size_ = 0, count_ = 0, version_ = 0 '\000', check_type_ = 0 '\000', alignment_ = 0 '\000'}, head_ = 0x0, next_ = 0, begin_ = 0}, <No data fields>}, version_ = galera::DataSet::EMPTY}, annt_ = 0x0, check_thr_id_ = 0, check_thr_ = false, check_ = true, static SIZE_THRESHOLD = 4194304}, buf_ = 0x7f082c110450, action_ = {first = 0x7f1d6ca61bb8, second = 3120}, certified_ = false, committed_ = false, exit_loop_ = false, cert_bypass_ = false, queued_ = false}, error=error@entry=0x7f1c863241b0) at galera/src/replicator_smm.cpp:1424 retval = WSREP_OK #16 0x00007f1dae948108 in galera_commit_order_leave (gh=<optimized out>, ws_handle=<optimized out>, meta=<optimized out>, error=0x7f1c863241b0) at galera/src/wsrep_provider.cpp:800 trx = @0x7f05bc0338e0: {<galera::TrxHandle> = {_vptr.TrxHandle = 0x7f1daea026f0 <vtable for galera::TrxHandleMaster+16>, static TRXHANDLE_FLAGS_MASK = 33791, static EXPLICIT_ROLLBACK_FLAGS = 10, static FLAGS_MATCH_API_FLAGS = true, static num_states_ = 12, state_ = {delete_ = false, trans_map_ = 0x7f1daea09f20 <galera::TrxHandleMaster::trans_map_>, state_ = {first = galera::TrxHandle::S_MUST_REPLAY, second = 781}, state_hist_ = std::vector of length 3, capacity 4 = {{first = galera::TrxHandle::S_EXECUTING, second = 0}, {first = galera::TrxHandle::S_REPLICATING, second = 661}, {first = galera::TrxHandle::S_MUST_ABORT, second = 859}}}, source_id_ = {data = "z\242\262]\t\030\021�W\257\tR#P\270", alignment = 16938346102022906490}, conn_id_ = 6973, trx_id_ = 3346858112, timestamp_ = 1602184746126299309, version_ = 5, write_set_flags_ = 1, local_ = true, master_ = true}, static Defaults = {working_dir_ = ".", version_ = -1, key_format_ = galera::KeySet::FLAT16A, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 0}, mutex_ = {value_ = {__data = {__lock = 1, __count = 0, __owner = 30523, __nusers = 1, __kind = 0, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000;w\000\000\001", '\000' <repeats 26 times>, __align = 1}}, mem_pool_ = @0x55769ecf3738, static trans_map_ = {impl_ = std::unordered_map with 22 elementsPython Exception <class 'gdb.error'> cannot resolve overloaded method `_M_before_begin': no arguments supplied: }, params_ = {working_dir_ = "/datavolume/mariadb/maria_data/", version_ = 5, key_format_ = galera::KeySet::FLAT8, record_set_ver_ = gu::RecordSet::VER2, max_write_set_size_ = 2147483647}, ts_ = {px = 0x7f082c110450, pn = {pi_ = 0x7efb478b85b0}}, wso_buf_size_ = 7960, gcs_handle_ = -1, wso_ = false, last_ts_seqno_ = 387232383, deferred_abort_ = false} lock = {trx_ = @0x7f05bc0338e0, locked_ = true} repl = 0x55769ecf2da0 txp = 0x7f05bc0338e0 __FUNCTION__ = "galera_commit_order_leave" retval = <optimized out> #17 0x000055769d4b1a51 in wsrep::wsrep_provider_v26::commit_order_leave (this=<optimized out>, ws_handle=<optimized out>, ws_meta=<optimized out>, err=<optimized out>) at /home/buildbot/buildbot/build/wsrep-lib/src/wsrep_provider_v26.cpp:851 cwsh = {ws_handle_ = @0x7f05ec0069d0, native_ = {trx_id = 3346858112, opaque = 0x7f05bc0338e0}} cwsm = {trx_meta_ = {gtid = {uuid = {data = "\331:#\255\253\306\021\352\276q\206p)\364\374", <incomplete sequence \364>, alignment = 16866480520125692633}, seqno = 387232383}, stid = {node = {data = "z\242\262]\t\030\021�W\257\tR#P\270", alignment = 16938346102022906490}, trx = 3346858112, conn = 18446744073709551615}, depends_on = -1}} err_buf = {ptr = 0x0, len = 0} ret = <optimized out> #18 0x000055769d4a77f7 in wsrep::transaction::ordered_commit (this=this@entry=0x7f05ec006970) at /home/buildbot/buildbot/build/wsrep-lib/src/transaction.cpp:532 lock = {mutex_ = @0x7f05ec0068d0, locked_ = true} ret = <optimized out> #19 0x000055769cef6818 in ordered_commit (this=0x7f05ec006908) at /home/buildbot/buildbot/build/wsrep-lib/include/wsrep/client_state.hpp:479 No locals. #20 wsrep_ordered_commit (all=<optimized out>, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/wsrep_trans_observer.h:300 No locals. #21 MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=this@entry=0x55769dd1b120 <mysql_bin_log>, entry=entry@entry=0x7f1c86324310) at /home/buildbot/buildbot/build/sql/log.cc:7751 is_leader = 1 #22 0x000055769cef6e00 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=this@entry=0x55769dd1b120 <mysql_bin_log>, thd=thd@entry=0x7f05ec0009a8, cache_mngr=cache_mngr@entry=0x7f05ec18ff48, end_ev=end_ev@entry=0x7f1c86324460, all=<optimized out>, using_stmt_cache=using_stmt_cache@entry=false, using_trx_cache=using_trx_cache@entry=true) at /home/buildbot/buildbot/build/sql/log.cc:7418 entry = {next = 0x0, thd = 0x7f05ec0009a8, cache_mngr = 0x7f05ec18ff48, using_stmt_cache = false, using_trx_cache = true, end_event = 0x7f1c86324460, incident_event = 0x0, error = 0, commit_errno = 0, error_cache = 0xffffffffffffffff, all = false, need_unlog = false, check_purge = 35, queued_by_other = false, binlog_id = 17653253098204197310} ha_info = <optimized out> #23 0x000055769cef6fad in binlog_flush_cache (thd=thd@entry=0x7f05ec0009a8, cache_mngr=cache_mngr@entry=0x7f05ec18ff48, end_ev=end_ev@entry=0x7f1c86324460, all=all@entry=false, using_stmt=using_stmt@entry=false, using_trx=using_trx@entry=true) at /home/buildbot/buildbot/build/sql/log.cc:1788 error = 0 #24 0x000055769cef72ce in binlog_rollback_flush_trx_cache (thd=thd@entry=0x7f05ec0009a8, all=all@entry=false, cache_mngr=cache_mngr@entry=0x7f05ec18ff48) at /home/buildbot/buildbot/build/sql/log.cc:1874 end_evt = {<Log_event> = {_vptr.Log_event = 0x55769dbf5370 <vtable for Query_log_event+16>, log_pos = 0, temp_buf = 0x0, event_owns_temp_buf = false, when = 1602184746, when_sec_part = 126177, exec_time = 0, data_written = 0, server_id = 135, flags = 12, cache_type = 3, slave_exec_mode = 0, writer = 0x0, thd = 0x7f05ec0009a8, checksum_alg = BINLOG_CHECKSUM_ALG_UNDEF}, user = {str = 0x0, length = 0}, host = {str = 0x0, length = 0}, data_buf = 0x0, query = 0x55769d6341ed "ROLLBACK", catalog = 0x55769d510608 "std", db = 0x7f05ec0dcf78 "wjtblep", q_len = 8, db_len = 7, error_code = 0, thread_id = 6973, slave_proxy_id = 6973, catalog_len = 3, status_vars_len = 0, flags2_inited = true, sql_mode_inited = true, charset_inited = true, flags2 = 0, sql_mode = 1411383300, auto_increment_increment = 5, auto_increment_offset = 4, charset = "!\000!\000S", time_zone_len = 6, time_zone_str = 0x55769d64b1c1 "SYSTEM", lc_time_names_number = 0, charset_database_number = 0, table_map_for_update = 0, master_data_written = 0} #25 0x000055769cef75a9 in binlog_rollback (hton=<optimized out>, thd=0x7f05ec0009a8, all=<optimized out>) at /home/buildbot/buildbot/build/sql/log.cc:2139 error = 0 cache_mngr = 0x7f05ec18ff48 #26 0x000055769ce0a71b in ha_rollback_trans (thd=thd@entry=0x7f05ec0009a8, all=all@entry=false) at /home/buildbot/buildbot/build/sql/handler.cc:1909 err = <optimized out> ht = <optimized out> ha_info_next = <optimized out> error = <optimized out> trans = 0x7f05ec003da8 ha_info = 0x7f05ec002e00 is_real_trans = <optimized out> #27 0x000055769ce15ed4 in ha_commit_trans (thd=thd@entry=0x7f05ec0009a8, all=all@entry=false) at /home/buildbot/buildbot/build/sql/handler.cc:1681 cookie = <optimized out> need_prepare_ordered = <optimized out> need_commit_ordered = <optimized out> xid = <optimized out> error = 1 trans = <optimized out> is_real_trans = true ha_info = <optimized out> rw_ha_count = 2 rw_trans = <optimized out> #28 0x000055769ccf475f in trans_commit_stmt (thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/transaction.cc:436 res = 0 #29 0x000055769cbface2 in mysql_execute_command (thd=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6156 res = 0 lex = <optimized out> trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = <optimized out>, context = {writer = <optimized out>}, closed = false}, <No data fields>} orig_binlog_format = BINLOG_FORMAT_ROW up_result = <optimized out> rpl_filter = <optimized out> ots = {ctx = 0x7f05ec004320, traceable = false} orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW select_lex = <optimized out> first_table = <optimized out> all_tables = 0x7efb47b5c150 unit = <optimized out> have_table_map_for_update = <optimized out> #30 0x000055769cb5f8e5 in sp_instr_stmt::exec_core (this=0x7efb47b616e0, thd=<optimized out>, nextp=0x7f1c863274a0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3687 res = 0 #31 0x000055769cb67c79 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7efb47b61728, thd=thd@entry=0x7f05ec0009a8, nextp=nextp@entry=0x7f1c863274a0, open_tables=open_tables@entry=false, instr=instr@entry=0x7efb47b616e0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3419 trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>} res = <optimized out> parent_modified_non_trans_table = false ots = {ctx = 0x7f05ec004320, traceable = false} #32 0x000055769cb6871c in sp_instr_stmt::execute (this=0x7efb47b616e0, thd=0x7f05ec0009a8, nextp=0x7f1c863274a0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3593 log_slow = <optimized out> res = 0 save_enable_slow_log = false query_backup = {string = {str = 0x7ef91d7d5280 "CALL SP_DUES_SET_SAVE_DSCT_ORD( NAME_CONST('in_inqrYm',_utf8'202010' COLLATE 'utf8_bin'),\r\n", ' ' <repeats 34 times>, "NAME_CONST('in_empNo',_utf8'BATCH' COLLATE 'utf8_bin'),\r\n", ' ' <repeats 18 times>..., length = 366}, cs = 0x55769dcd6240 <my_charset_utf8_general_ci>} backup_state = {auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, auto_inc_intervals_forced = {head = 0x0, tail = 0x3e8, current = 0x0, elements = 0}, savepoints = 0x7ef91d7e873f, option_bits = 0, first_successful_insert_id_in_prev_stmt = 0, first_successful_insert_id_in_cur_stmt = 8603404019444424814, insert_id_for_cur_row = 6998637137531333727, limit_found_rows = 139608409412176, tmp_tables_size = 6279520, client_capabilities = 139608408661504, cuted_fields = 93967926405520, sent_row_count = 0, examined_row_count = 73, affected_rows = 12, bytes_sent_old = 462, tmp_tables_used = 3, tmp_tables_disk_used = 0, query_plan_fsort_passes = 0, query_plan_flags = 802, in_sub_stmt = 0, enable_slow_log = false, last_insert_id_used = false, count_cuted_fields = CHECK_FIELD_IGNORE} #33 0x000055769cb636f7 in sp_head::execute (this=this@entry=0x7f05ec515920, thd=thd@entry=0x7f05ec0009a8, merge_da_on_success=merge_da_on_success@entry=true) at /home/buildbot/buildbot/build/sql/sp_head.cc:1364 parent_digest = 0x0 saved_cur_db_name_buf = "\260v2\206\034\177\000\000\322\361\266\234vU\000\000\300v2\206\034\177\000\000 w2\206\034\177\000\000\220v2\206\034\177\000\000]\275?vU\000\000\300v2\206\034\177\000\000N\205?vU\000\000\000\000\000\000\000\000\000\000\240j}\035\371~\000\000\340v2\206\034\177\000\000\025\031\266\234vU\000\000 w2\206\034\177\000\000\204*2\235vU\000\000\060w2\206\034\177\000\000\222\025\273\234vU\000\000\000w2\206\034\177\000\000@YQ\354\005\177\000\000@YQ\354\005\177\000\000\000\\Q\354\005\177\000\000 YQ\354\005\177\000\000 YQ\354\005\177\000\000\340w2\206\034\177\000\000\250\t\000\354\005\177\000\000\000\\Q\354\005\177\000\000\000" saved_cur_db_name = {str = 0x7f1c86327660 "\260v2\206\034\177", length = 202} ctx = 0x7ef91d7d5598 execute_mem_root = {free = 0x7ef91d7e79b8, used = 0x7ef91d5c1738, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 16304, block_num = 6, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d50e3be "per_instruction_memroot"} old_query_id = 3346857146 old_rec_tables = 0x0 old_change_list = {change_list = {<base_ilist> = {first = 0x7f05ec000a60, last = {_vptr.ilink = 0x55769dafeb50 <vtable for ilink+16>, prev = 0x7f05ec000a58, next = 0x0}}, <No data fields>}} ip = 51 saved_creation_ctx = 0x7ef91d9b22c0 cur_db_changed = false err_status = false execute_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f1c86327550, state = Query_arena::STMT_INITIALIZED_FOR_SP} backup_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x7ef91da6a918, mem_root = 0x7f1c8632a690, state = Query_arena::STMT_INITIALIZED_FOR_SP} old_lex = 0x7f05ec878b00 status_backup_mask = 192 user_var_events_alloc_saved = 0x7f1c8632a690 i = 0x7efb47b616e0 old_derived_tables = 0x0 old_server_status = 64 save_abort_on_warning = false old_arena = 0x7f05ec87ad28 old_packet = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>} save_reprepare_observer = 0x0 save_sql_mode = 0 da = 0x7f05ec0061d0 sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d510f48 "Warning_info"}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f1c863275f8}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 10, m_warn_id = 3346858112, m_error_condition = 0x0, m_allow_unlimited_warnings = false, initialized = true, m_read_only = false, m_next_in_da = 0x7f1c8632a6e0, m_prev_in_da = 0x7f05ec0064d8, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55769dcea630 <end_of_list>, last = 0x7f1c86327640, elements = 0}, <No data fields>}} #34 0x000055769cb64bf9 in sp_head::execute_procedure (this=0x7f05ec515920, thd=thd@entry=0x7f05ec0009a8, args=0x7f05ec879a88) at /home/buildbot/buildbot/build/sql/sp_head.cc:2370 params = <optimized out> save_spcont = 0x7ef91ddb6498 nctx = 0x7ef91d7d5598 octx = <optimized out> save_log_general = false need_binlog_call = <optimized out> err_status = false utime_before_sp_exec = 849084505740 save_enable_slow_log = false pkg = 0x0 save_security_ctx = 0x0 #35 0x000055769cbf1f4a in do_execute_sp (thd=0x7f05ec0009a8, sp=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3005 bits_to_be_cleared = <optimized out> affected_rows = <optimized out> select_limit = 18446744073709551615 res = <optimized out> sp = <optimized out> thd = 0x7f05ec0009a8 #36 0x000055769cbf3876 in Sql_cmd_call::execute (this=this@entry=0x7f05ec87a690, thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3247 sp = 0x7f05ec515920 #37 0x000055769cbf40b0 in Sql_cmd_call::execute (this=0x7f05ec87a690, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3201 No locals. #38 0x000055769cbfc590 in mysql_execute_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6098 res = 0 lex = 0x7f05ec878b00 trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>} orig_binlog_format = <optimized out> up_result = 0 rpl_filter = <optimized out> ots = {ctx = 0x7f05ec004320, traceable = false} orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW select_lex = 0x7f05ec8793b8 first_table = 0x0 all_tables = 0x0 unit = 0x7f05ec878bc0 have_table_map_for_update = false #39 0x000055769cb5f8e5 in sp_instr_stmt::exec_core (this=0x7f05ec87ad28, thd=<optimized out>, nextp=0x7f1c8632a5e0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3687 res = 0 #40 0x000055769cb67c79 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f05ec87ad70, thd=thd@entry=0x7f05ec0009a8, nextp=nextp@entry=0x7f1c8632a5e0, open_tables=open_tables@entry=false, instr=instr@entry=0x7f05ec87ad28) at /home/buildbot/buildbot/build/sql/sp_head.cc:3419 trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>} res = <optimized out> parent_modified_non_trans_table = false ots = {ctx = 0x7f05ec004320, traceable = false} #41 0x000055769cb6871c in sp_instr_stmt::execute (this=0x7f05ec87ad28, thd=0x7f05ec0009a8, nextp=0x7f1c8632a5e0) at /home/buildbot/buildbot/build/sql/sp_head.cc:3593 log_slow = <optimized out> res = 0 save_enable_slow_log = false query_backup = {string = {str = 0x7ef91ddb60c0 "CALL SP_DUES_SET_DSCT_SETUP( NAME_CONST('v_ITAB_vndrCstmrId',_utf8'0027385924' COLLATE 'utf8_bin'), #��ǰó ��ID\r\n", ' ' <repeats 33 times>, "NAME_CONST('in_analsYm',_utf8'202010' COLLAT"..., length = 549}, cs = 0x55769dcd6240 <my_charset_utf8_general_ci>} backup_state = {auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, auto_inc_intervals_forced = {head = 0x0, tail = 0x1ec093c28, current = 0x0, elements = 0}, savepoints = 0x1, option_bits = 139663410989480, first_successful_insert_id_in_prev_stmt = 93967941558080, first_successful_insert_id_in_cur_stmt = 139760487276590, insert_id_for_cur_row = 274877906944, limit_found_rows = 0, tmp_tables_size = 454212504, client_capabilities = 139663411592720, cuted_fields = 139663411592224, sent_row_count = 0, examined_row_count = 122927, affected_rows = 1556, bytes_sent_old = 462, tmp_tables_used = 239, tmp_tables_disk_used = 0, query_plan_fsort_passes = 0, query_plan_flags = 826, in_sub_stmt = 3960028696, enable_slow_log = 5, last_insert_id_used = 127, count_cuted_fields = CHECK_FIELD_IGNORE} #42 0x000055769cb636f7 in sp_head::execute (this=this@entry=0x7f05ed554090, thd=thd@entry=0x7f05ec0009a8, merge_da_on_success=merge_da_on_success@entry=true) at /home/buildbot/buildbot/build/sql/sp_head.cc:1364 parent_digest = 0x0 saved_cur_db_name_buf = "\360\247\062\206\034\177\000\000\322\361\266\234vU\000\000\000\250\062\206\034\177\000\000`\250\062\206\034\177\000\000��2\206\034\177\000\000]\275?vU\000\000\000\250\062\206\034\177\000\000N\205?vU\000\000\000\000\000\000\000\000\000\000\240z\333\035\371~\000\000 \250\062\206\034\177\000\000\025\031\266\234vU\000\000`\250\062\206\034\177\000\000\204*2\235vU\000\000p\250\062\206\034\177\000\000\222\025\273\234vU\000\000@\250\062\206\034\177\000\000\260@U\355\005\177\000\000\260@U\355\005\177\000\000pCU\355\005\177\000\000\220@U\355\005\177\000\000\220@U\355\005\177\000\000 \251\062\206\034\177\000\000\250\t\000\354\005\177\000\000pCU\355\005\177\000\000\000" saved_cur_db_name = {str = 0x7f1c8632a7a0 "\360\247\062\206\034\177", length = 202} ctx = 0x7ef91ddb6498 execute_mem_root = {free = 0x7ef91d9b0348, used = 0x7ef91d7d5168, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 24456, block_num = 7, first_block_usage = 6, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d50e3be "per_instruction_memroot"} old_query_id = 3346756135 old_rec_tables = 0x0 old_change_list = {change_list = {<base_ilist> = {first = 0x7f05ec000a60, last = {_vptr.ilink = 0x55769dafeb50 <vtable for ilink+16>, prev = 0x7f05ec000a58, next = 0x0}}, <No data fields>}} ip = 88 saved_creation_ctx = 0x7ef91d58bcf8 cur_db_changed = false err_status = false execute_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f1c8632a690, state = Query_arena::STMT_INITIALIZED_FOR_SP} backup_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x7ef91d94a550, mem_root = 0x7f1c8632d7d0, state = Query_arena::STMT_INITIALIZED_FOR_SP} old_lex = 0x7f05ed524c80 status_backup_mask = 192 user_var_events_alloc_saved = 0x7f1c8632d7d0 i = 0x7f05ec87ad28 old_derived_tables = 0x0 old_server_status = 64 save_abort_on_warning = false old_arena = 0x7f05ec0385e8 old_packet = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>} save_reprepare_observer = 0x0 save_sql_mode = 0 da = 0x7f05ec0061d0 sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d510f48 "Warning_info"}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f1c8632a738}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 3346766828, m_error_condition = 0x0, m_allow_unlimited_warnings = false, initialized = true, m_read_only = false, m_next_in_da = 0x7f1c8632d820, m_prev_in_da = 0x7f1c86327630, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55769dcea630 <end_of_list>, last = 0x7f1c8632a780, elements = 0}, <No data fields>}} #43 0x000055769cb64bf9 in sp_head::execute_procedure (this=0x7f05ed554090, thd=thd@entry=0x7f05ec0009a8, args=0x7f05ed525c08) at /home/buildbot/buildbot/build/sql/sp_head.cc:2370 params = <optimized out> save_spcont = 0x7f05ec015858 nctx = 0x7ef91ddb6498 octx = <optimized out> save_log_general = false need_binlog_call = <optimized out> err_status = false utime_before_sp_exec = 849084505740 save_enable_slow_log = false pkg = 0x0 save_security_ctx = 0x0 #44 0x000055769cbf1f4a in do_execute_sp (thd=0x7f05ec0009a8, sp=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3005 bits_to_be_cleared = <optimized out> affected_rows = <optimized out> select_limit = 18446744073709551615 res = <optimized out> sp = <optimized out> thd = 0x7f05ec0009a8 #45 0x000055769cbf3876 in Sql_cmd_call::execute (this=this@entry=0x7f05ec037e60, thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3247 sp = 0x7f05ed554090 #46 0x000055769cbf40b0 in Sql_cmd_call::execute (this=0x7f05ec037e60, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3201 No locals. #47 0x000055769cbfc590 in mysql_execute_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6098 res = 0 lex = 0x7f05ed524c80 trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>} orig_binlog_format = <optimized out> up_result = 0 rpl_filter = <optimized out> ots = {ctx = 0x7f05ec004320, traceable = false} orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW select_lex = 0x7f05ed525538 first_table = 0x0 all_tables = 0x0 unit = 0x7f05ed524d40 have_table_map_for_update = false #48 0x000055769cb5f8e5 in sp_instr_stmt::exec_core (this=0x7f05ec0385e8, thd=<optimized out>, nextp=0x7f1c8632d720) at /home/buildbot/buildbot/build/sql/sp_head.cc:3687 res = 0 #49 0x000055769cb67c79 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f05ec038630, thd=thd@entry=0x7f05ec0009a8, nextp=nextp@entry=0x7f1c8632d720, open_tables=open_tables@entry=false, instr=instr@entry=0x7f05ec0385e8) at /home/buildbot/buildbot/build/sql/sp_head.cc:3419 trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>} res = <optimized out> parent_modified_non_trans_table = false ots = {ctx = 0x7f05ec004320, traceable = false} #50 0x000055769cb6871c in sp_instr_stmt::execute (this=0x7f05ec0385e8, thd=0x7f05ec0009a8, nextp=0x7f1c8632d720) at /home/buildbot/buildbot/build/sql/sp_head.cc:3593 log_slow = <optimized out> res = 0 save_enable_slow_log = false query_backup = {string = {str = 0x7f05ec00fe60 "/*[com.wjthinkbig.lep.bt.ac.duesCalc.service.dao.DuesReSumDao.procDuesReSumScpeList]*/\n\t\t call SP_BAT_DUES_SET_CRTN_STEP2\n\t\t\t(\n\t\t\t'202010',\n\t\t\t'0027274480',\n\t\t\t'0027386160'\n\t\t\t)", length = 177}, cs = 0x55769dcd5dc0 <my_charset_utf8mb4_general_ci>} backup_state = {auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, auto_inc_intervals_forced = {head = 0x0, tail = 0x7f05ec04f1b0, current = 0x0, elements = 0}, savepoints = 0x7f1c8632d4b0, option_bits = 93967926431602, first_successful_insert_id_in_prev_stmt = 139663412133576, first_successful_insert_id_in_cur_stmt = 34359738369, insert_id_for_cur_row = 93967941984448, limit_found_rows = 139663411463482, tmp_tables_size = 2661773169792, client_capabilities = 0, cuted_fields = 1, sent_row_count = 0, examined_row_count = 7108302929361928460, affected_rows = 8704326, bytes_sent_old = 462, tmp_tables_used = 1486952, tmp_tables_disk_used = 20904, query_plan_fsort_passes = 0, query_plan_flags = 1850, in_sub_stmt = 2647482368, enable_slow_log = 118, last_insert_id_used = 85, count_cuted_fields = CHECK_FIELD_IGNORE} #51 0x000055769cb636f7 in sp_head::execute (this=this@entry=0x7f05ec0e34a0, thd=thd@entry=0x7f05ec0009a8, merge_da_on_success=merge_da_on_success@entry=true) at /home/buildbot/buildbot/build/sql/sp_head.cc:1364 parent_digest = 0x0 saved_cur_db_name_buf = "0\331\062\206\034\177\000\000\322\361\266\234vU\000\000@\331\062\206\034\177\000\000\240\331\062\206\034\177\000\000\000\000\000\000\000\000\000\000\240\064\016\354\005\177\000\000\250\t\000\354\005\177\000\000\240\064\016\354\005\177\000\000\000\000\000\000\000\000\000\000\240\331\062\206\034\177\000\000`\331\062\206\034\177\000\000\025\031\266\234vU\000\000\240\331\062\206\034\177\000\000\204*2\235vU\000\000\260\331\062\206\034\177\000\000\222\025\273\234vU\000\000\070\367\r\354\005\177\000\000\300\064\016\354\005\177\000\000\300\064\016\354\005\177\000\000\200\067\016\354\005\177\000\000\240\064\016\354\005\177\000\000\240\064\016\354\005\177\000\000`\332\062\206\034\177\000\000\250\t\000\354\005\177\000\000\200\067\016\354\005\177\000\000"... saved_cur_db_name = {str = 0x7f1c8632d8e0 "0\331\062\206\034\177", length = 202} ctx = 0x7f05ec015858 execute_mem_root = {free = 0x7ef91d799478, used = 0x7ef91d589d48, pre_alloc = 0x0, min_malloc = 32, block_size = 8152, total_alloc = 32608, block_num = 8, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d50e3be "per_instruction_memroot"} old_query_id = 1987669015 old_rec_tables = 0x0 old_change_list = {change_list = {<base_ilist> = {first = 0x7f05ec000a60, last = {_vptr.ilink = 0x55769dafeb50 <vtable for ilink+16>, prev = 0x7f05ec000a58, next = 0x0}}, <No data fields>}} ip = 49 saved_creation_ctx = 0x7f05ec0522e0 cur_db_changed = false err_status = false execute_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f1c8632d7d0, state = Query_arena::STMT_INITIALIZED_FOR_SP} backup_arena = {_vptr.Query_arena = 0x55769db07a30 <vtable for Query_arena+16>, free_list = 0x7f05ec0521d0, mem_root = 0x7f05ec006188, state = Query_arena::STMT_CONVENTIONAL_EXECUTION} old_lex = 0x7f05ec0dd470 status_backup_mask = 192 user_var_events_alloc_saved = 0x7f05ec006188 i = 0x7f05ec0385e8 old_derived_tables = 0x0 old_server_status = 0 save_abort_on_warning = false old_arena = 0x7f05ed51f580 old_packet = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f05ec00bad8 "\003def", str_length = 23}, Alloced_length = 16392, extra_alloc = 0, alloced = true, thread_specific = false}, <No data fields>} save_reprepare_observer = 0x7f1c86330240 save_sql_mode = 2097152 da = 0x7f05ec0061d0 sp_wi = {m_warn_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 2009, total_alloc = 0, block_num = 4, first_block_usage = 0, error_handler = 0x55769ccc1a10 <sql_alloc_error_handler()>, name = 0x55769d510f48 "Warning_info"}, m_warn_list = {<I_P_List_counter> = {m_counter = 0}, <I_P_List_fast_push_back<Sql_condition>> = {m_last = 0x7f1c8632d878}, m_first = 0x0}, m_warn_count = {0, 0, 0}, m_current_statement_warn_count = 0, m_current_row_for_warning = 1, m_warn_id = 3346669562, m_error_condition = 0x0, m_allow_unlimited_warnings = false, initialized = true, m_read_only = false, m_next_in_da = 0x7f05ec006410, m_prev_in_da = 0x7f1c8632a770, m_marked_sql_conditions = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55769dcea630 <end_of_list>, last = 0x7f1c8632d8c0, elements = 0}, <No data fields>}} #52 0x000055769cb64bf9 in sp_head::execute_procedure (this=0x7f05ec0e34a0, thd=thd@entry=0x7f05ec0009a8, args=0x7f05ec0de3f8) at /home/buildbot/buildbot/build/sql/sp_head.cc:2370 params = <optimized out> save_spcont = 0x0 nctx = 0x7f05ec015858 octx = <optimized out> save_log_general = true need_binlog_call = <optimized out> err_status = false utime_before_sp_exec = 849082209912 save_enable_slow_log = true pkg = 0x0 save_security_ctx = 0x0 #53 0x000055769cbf1f4a in do_execute_sp (thd=0x7f05ec0009a8, sp=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3005 bits_to_be_cleared = <optimized out> affected_rows = <optimized out> select_limit = 18446744073709551615 res = <optimized out> sp = <optimized out> thd = 0x7f05ec0009a8 #54 0x000055769cbf3876 in Sql_cmd_call::execute (this=this@entry=0x7f05ec0df1c0, thd=thd@entry=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3247 sp = 0x7f05ec0e34a0 #55 0x000055769cbf40b0 in Sql_cmd_call::execute (this=0x7f05ec0df1c0, thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:3201 No locals. #56 0x000055769cbfc590 in mysql_execute_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:6098 res = 0 lex = 0x7f05ec0dd470 trace_command = <optimized out> trace_command_steps = {<Json_writer_struct> = {my_writer = 0x0, context = {writer = <optimized out>}, closed = false}, <No data fields>} orig_binlog_format = <optimized out> up_result = 0 rpl_filter = <optimized out> ots = {ctx = 0x7f05ec004320, traceable = false} orig_current_stmt_binlog_format = BINLOG_FORMAT_ROW select_lex = 0x7f05ec0ddd28 first_table = 0x0 all_tables = 0x0 unit = 0x7f05ec0dd530 have_table_map_for_update = false #57 0x000055769cc15975 in Prepared_statement::execute (this=this@entry=0x7f05ed51f568, expanded_query=expanded_query@entry=0x7f1c863302c0, open_cursor=open_cursor@entry=false) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:4765 parent_locker = <optimized out> stmt_backup = {<ilink> = {_vptr.ilink = 0x55769db07a70 <vtable for Statement+16>, prev = 0x0, next = 0x0}, <Query_arena> = {_vptr.Query_arena = 0x55769db07aa0 <vtable for Statement+64>, free_list = 0x7f05ecb7bdb8, mem_root = 0x7f1c863300ae, state = -1647911104}, id = 0, column_usage = MARK_COLUMNS_READ, name = {str = 0x55769d451b42 <my_string_metadata_get+130> "\203", <incomplete sequence \370>, length = 48}, lex = 0x7f05ec004650, query_string = {string = {str = 0x7f05ec00fe60 "/*[com.wjthinkbig.lep.bt.ac.duesCalc.service.dao.DuesReSumDao.procDuesReSumScpeList]*/\n\t\t call SP_BAT_DUES_SET_CRTN_STEP2\n\t\t\t(\n\t\t\t'202010',\n\t\t\t'0027274480',\n\t\t\t'0027386160'\n\t\t\t)", length = 177}, cs = 0x55769dcd5dc0 <my_charset_utf8mb4_general_ci>}, base_query = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x0, str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}, db = {str = 0x55769cc80a52 <String::append(char const*, unsigned long)+258> "D\001c\020\061\300\351q\377\377\377\017\037", length = 0}, query_cache_is_applicable = 0 '\000'} old_stmt_arena = 0x7f05ec0009c0 saved_cur_db_name_buf = "\n\000\000\000\000\000\000\000\030\371\r\354\005\177\000\000\030\371\r\354\005\177\000\000\217\000\000\000\000\000\000\000\300\002\063\206\034\177\000\000\307z\000\354\005\177\000\000\300\001\063\206\034\177\000\000\307\t\301\234vU\000\000\224\000\000\000\000\000\000\000\250\t\000\354\005\177\000\000\210\001\063\206\034\177\000\000\242z\000\354\005\177\000\000\000\371\r\354\005\177\000\000\030\371\r\354\005\177\000\000\260\357\r\354\005\177\000\000\307z\000\354\005\177\000\000\250\t\000\354\005\177\000\000h\365Q\355\005\177\000\000\030\371\r\354\005\177\000\000\300\002\063\206\034\177\000\000\252z\000\354\005\177\000\000\242z\000\354\005\177\000\000 \002\063\206\034\177\000\000XI\301\234vU\000\000\310z\000\354\005\177\000\000"... saved_cur_db_name = {str = 0x7f1c86330110 "\n", length = 202} cur_db_changed = false error = true qc_executed = false stmt_db_name = {str = 0x7f05ec0defa8 "wjtblep", length = 7} #58 0x000055769cc15a82 in Prepared_statement::execute_loop (this=0x7f05ed51f568, expanded_query=0x7f1c863302c0, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:4251 reprepare_observer = {m_invalidated = false} error = <optimized out> #59 0x000055769cc163c7 in mysql_stmt_execute_common (thd=thd@entry=0x7f05ec0009a8, stmt_id=833, packet=packet@entry=0x7f05ec007aa2 "", packet_end=packet_end@entry=0x7f05ec007ac7 "", cursor_flags=0, bulk_op=bulk_op@entry=false, read_types=read_types@entry=false) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:3260 expanded_query = {<Charset> = {m_charset = 0x55769dc6df40 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f05ecb7bdb8 "/*[com.wjthinkbig.lep.bt.ac.duesCalc.service.dao.DuesReSumDao.procDuesReSumScpeList]*/\n\t\t call SP_BAT_DUES_SET_CRTN_STEP2\n\t\t\t(\n\t\t\t'202010',\n\t\t\t'0027274480',\n\t\t\t'0027386160'\n\t\t\t)", str_length = 177}, Alloced_length = 264, extra_alloc = 128, alloced = true, thread_specific = false}, <No data fields>} stmt = 0x7f05ed51f568 save_protocol = 0x7f05ec000ee8 open_cursor = false #60 0x000055769cc16457 in mysqld_stmt_execute (thd=thd@entry=0x7f05ec0009a8, packet_arg=packet_arg@entry=0x7f05ec007a99 "A\003", packet_length=packet_length@entry=46) at /home/buildbot/buildbot/build/sql/sql_prepare.cc:3158 packet = 0x7f05ec007aa2 "" stmt_id = <optimized out> flags = <optimized out> packet_end = 0x7f05ec007ac7 "" #61 0x000055769cc050e1 in dispatch_command (command=command@entry=COM_STMT_EXECUTE, thd=thd@entry=0x7f05ec0009a8, packet=packet@entry=0x7f05ec007a99 "A\003", packet_length=packet_length@entry=46, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1758 net = 0x7f05ec000c18 do_end_of_statement = true __FUNCTION__ = "dispatch_command" error = false drop_more_results = false #62 0x000055769cc06e89 in do_command (thd=0x7f05ec0009a8) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1353 return_value = <optimized out> packet = 0x7f05ec007a98 "\027A\003" packet_length = <optimized out> net = 0x7f05ec000c18 command = COM_STMT_EXECUTE __FUNCTION__ = "do_command" #63 0x000055769cce5f9a in do_handle_one_connection (connect=connect@entry=0x55770618c478) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1412 create_user = true thr_create_utime = <optimized out> thd = 0x7f05ec0009a8 #64 0x000055769cce607d in handle_one_connection (arg=arg@entry=0x55770618c478) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1316 connect = 0x55770618c478 #65 0x000055769d320bdd in pfs_spawn_thread (arg=0x5577062dc058) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1869 typed_arg = 0x5577062dc058 user_arg = 0x55770618c478 pfs = <optimized out> user_start_routine = 0x55769cce6040 <handle_one_connection(void*)> klass = <optimized out> #66 0x00007f1e61787e75 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #67 0x00007f1e605e58fd in clone () from /lib64/libc.so.6 No symbol table info available.

People

Assignee:: Seppo Jaakola

Reporter:: Jan Lindström (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2020-10-30 05:49

Updated:: 2024-07-07 21:47

Resolved:: 2020-12-21 10:31

Git Integration

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

MariaDB Server