Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug: The instance is frequently restarted #1174

Closed
3 tasks done
haitaoguan opened this issue Dec 30, 2022 · 0 comments · Fixed by #1178
Closed
3 tasks done

bug: The instance is frequently restarted #1174

haitaoguan opened this issue Dec 30, 2022 · 0 comments · Fixed by #1178
Assignees
Labels
A-bug Something isn't working

Comments

@haitaoguan
Copy link
Collaborator

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

2022-12-30T05:44:04.278997Z mysqld_safe mysqld restarted
2022-12-30T05:44:07.318860Z mysqld_safe Number of processes running now: 0
2022-12-30T05:44:07.330660Z mysqld_safe mysqld restarted
2022-12-30T05:44:10.237983Z mysqld_safe Number of processes running now: 0
2022-12-30T05:44:10.250383Z mysqld_safe mysqld restarted

###tianmu.log

[2022-12-30 13:41:10.718119] [22162] [WARN] [exception.cpp:42] MSG: Exception: assert failed on i < m_idx.size() at tianmu_attr.h:382, msg: [bad dpn index 111/1].

STACK TRACE BEGIN
        /stonedb57/install//bin/mysqld(Tianmu::common::AssertException::AssertException(char const*, char const*, int, std::string const&)+0x1b7) [0x2f87007]
        /stonedb57/install//bin/mysqld(Tianmu::core::TianmuAttr::get_dpn(unsigned long)+0xe2) [0x2d3f18a]
        /stonedb57/install//bin/mysqld(Tianmu::core::TianmuAttr::LockPackForUse(unsigned int)+0x50) [0x2d361e4]
        /stonedb57/install//bin/mysqld(_ZSt13__invoke_implIvRMN6Tianmu4core10TianmuAttrEFvjERPS2_IRiEET_St21__invoke_memfun_derefOT0_OT1_DpOT2_+0x7e) [0x2d84c39]
        /stonedb57/install//bin/mysqld(std::__invoke_result<void (Tianmu::core::TianmuAttr::*&)(unsigned int)<Tianmu::core::TianmuAttr*&, int&> >::type std::__invoke<void (Tianmu::core::TianmuAttr::*&)(unsigned int), Tianmu::core::TianmuAttr*&, int&>(void (Tianmu::core::TianmuAttr::*&)(unsigned int), Tianmu::core::TianmuAttr*&, int&)+0x57) [0x2d83725]
        /stonedb57/install//bin/mysqld(void std::_Bind<void (Tianmu::core::TianmuAttr::*(Tianmu::core::TianmuAttr*, int))(unsigned int)>::__call<void, , 0ul, 1ul>(std::tuple<>&&, std::_Index_tuple<0ul, 1ul>)+0x75) [0x2d82087]
        /stonedb57/install//bin/mysqld(void std::_Bind<void (Tianmu::core::TianmuAttr::*(Tianmu::core::TianmuAttr*, int))(unsigned int)>::operator()<, void>()+0x2a) [0x2d7f8b2]
        /stonedb57/install//bin/mysqld(std::_Function_handler<void (), std::_Bind<void (Tianmu::core::TianmuAttr::*(Tianmu::core::TianmuAttr*, int))(unsigned int)> >::_M_invoke(std::_Any_data const&)+0x20) [0x2d7c336]
        /stonedb57/install//bin/mysqld(std::function<void ()>::operator()() const+0x32) [0x2c5d0a6]
        /stonedb57/install//bin/mysqld(Tianmu::core::FunctionExecutor::FunctionExecutor(std::function<void ()>, std::function<void ()>)+0x71) [0x2c94e29]
        /stonedb57/install//bin/mysqld(Tianmu::core::DataPackLock::DataPackLock(Tianmu::core::TianmuAttr*, int const&)+0xcf) [0x2d788a1]
        /stonedb57/install//bin/mysqld(std::_MakeUniq<Tianmu::core::DataPackLock>::__single_object std::make_unique<Tianmu::core::DataPackLock, Tianmu::core::TianmuAttr*&, int>(Tianmu::core::TianmuAttr*&, int&&)+0x51) [0x2d7b4ac]
        /stonedb57/install//bin/mysqld(Tianmu::core::TianmuTable::Iterator::LockPacks()+0xe8) [0x2d6f6ee]
        /stonedb57/install//bin/mysqld(Tianmu::core::TianmuTable::Iterator::FetchValues()+0x2b) [0x2d6f509]
        /stonedb57/install//bin/mysqld(Tianmu::core::TianmuTable::Iterator::GetData(int)+0x1b) [0x2da1775]
        /stonedb57/install//bin/mysqld(Tianmu::handler::ha_tianmu::fill_row(unsigned char*)+0x13e) [0x2d98b62]
        /stonedb57/install//bin/mysqld(Tianmu::handler::ha_tianmu::rnd_pos(unsigned char*, unsigned char*)+0x389) [0x2d97db5]
        /stonedb57/install//bin/mysqld(handler::ha_rnd_pos(unsigned char*, unsigned char*)+0x125) [0x1d6c15b]
        /stonedb57/install//bin/mysqld(handler::rnd_pos_by_record(unsigned char*)+0xac) [0x1d7ac08]
        /stonedb57/install//bin/mysqld(Rows_log_event::do_index_scan_and_update(Relay_log_info const*)+0x378) [0x26444fa]
        /stonedb57/install//bin/mysqld(Rows_log_event::do_apply_event(Relay_log_info const*)+0x10ef) [0x26469a5]
        /stonedb57/install//bin/mysqld(Log_event::apply_event(Relay_log_info*)+0x1b3) [0x262e67d]
        /stonedb57/install//bin/mysqld(apply_event_and_update_pos(Log_event**, THD*, Relay_log_info*)+0x422) [0x26a2dc9]
        /stonedb57/install//bin/mysqld() [0x26a4463]
        /stonedb57/install//bin/mysqld(handle_slave_sql+0xf84) [0x26aadf4]
        /stonedb57/install//bin/mysqld(pfs_spawn_thread+0x170) [0x2bc8c61]
        /lib64/libpthread.so.0(+0x81a3) [0x7f52bca0e1a3]
        /lib64/libc.so.6(clone+0x6d) [0x7f52b9e9dfad]
STACK TRACE END

[2022-12-30 13:41:10.718507] [22162] [ERROR] [ha_tianmu.cpp:1193] MSG: An exception is caught: assert failed on i < m_idx.size() at tianmu_attr.h:382, msg: [bad dpn index 111/1]
[2022-12-30 13:41:10.718734] [22162] [ERROR] [MYSQL:0] MSG: Slave SQL for channel '': Could not execute Delete_rows event on table zz.sbtest1; assert failed on i < m_idx.size() at tianmu_attr.h:382, msg: [bad dpn index 111/1], Error_code: 6; Can't find record in 'sbtest1', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log mybinlog.000012, end_log_pos 300383577, Error_code: 6
[2022-12-30 13:41:10.718821] [22162] [WARN] [MYSQL:0] MSG: Slave: assert failed on i < m_idx.size() at tianmu_attr.h:382, msg: [bad dpn index 111/1] Error_code: 6
[2022-12-30 13:41:10.718863] [22162] [WARN] [MYSQL:0] MSG: Slave: Can't find record in 'sbtest1' Error_code: 1032
[2022-12-30 13:41:10.722166] [22162] [ERROR] [MYSQL:0] MSG: Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mybinlog.000012' position 300383162.
[2022-12-30 13:41:10.722271] [22162] [ERROR] [engine.cpp:763] MSG: Roll back query '(null)'
[2022-12-30 13:41:10.722311] [22162] [INFO] [transaction.cpp:90] MSG: rollback transaction 63ae79f300002711.
[2022-12-30 13:41:10.722372] [22162] [INFO] [tianmu_table.cpp:393] MSG: roll back table zz../zz/sbtest1.tianmu
[2022-12-30 13:41:10.722518] [22162] [ERROR] [engine.cpp:763] MSG: Roll back query '(null)'

Expected behavior

No response

How To Reproduce

No response

Environment

./mysqld Ver 5.7.36-StoneDB-debug for Linux on x86_64 (build-)
build information as follow:
Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
Branch name: stonedb-5.7-dev
Last commit ID: 26b011f
Last commit time: Date: Thu Dec 29 10:16:32 2022 +0800
Build time: Date: Fri Dec 30 11:30:38 CST 2022

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!
@haitaoguan haitaoguan added the A-bug Something isn't working label Dec 30, 2022
@konghaiya konghaiya self-assigned this Dec 30, 2022
@konghaiya konghaiya added this to the stonedb_5.7_v1.0.3 milestone Dec 30, 2022
konghaiya added a commit to konghaiya/stonedb that referenced this issue Dec 30, 2022
…toneatom#1174)

There is a problem with the judgment condition. You cannot ignore the case where the primary key value is 0
@mergify mergify bot closed this as completed in #1178 Jan 3, 2023
mergify bot pushed a commit that referenced this issue Jan 3, 2023
…1174)

There is a problem with the judgment condition. You cannot ignore the case where the primary key value is 0
konghaiya added a commit to konghaiya/stonedb that referenced this issue Mar 7, 2023
…toneatom#1174)

There is a problem with the judgment condition. You cannot ignore the case where the primary key value is 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-bug Something isn't working
Projects
Development

Successfully merging a pull request may close this issue.

2 participants