ERROR:assert failed on i < m_idx.size() at rc_attr.h:342, msg: [bad dpn index 0/0]

[haitaoguan]

Have you read the Contributing Guidelines on issues?

• I have 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

###tianmu.log
[2022-11-09 16:24:01.808835] [32289] [INFO] [engine_execute.cpp:455] MSG: Query terminated with exception: SELECT count(0) FROM (SELECT wc.id, wc.external_userid, wc.name, wc.avatar, wc.type, wc.gender, wc.unionid, wc.birthday, wc.corp_name, wc.corp_full_name, wc.position, wc.is_open_chat, wc.first_user_id, wc.first_user_id AS user_tid, wc.first_user_id AS create_by_user, wc.first_add_time AS create_time_user, wfcr.status, (SELECT COUNT(*) FROM we_flower_customer_tag_rel wfcrf WHERE wfcrf.external_userid = wc.external_userid) AS user_id, wc.card_number, wc.grade, wc.id_card, wc.age, wc.source, wc.now_money, wc.brokerage_price, wc.wechat_id, wc.integral, wc.member_id, wc.recent_login_time, wc.recent_login_ip, wc.track_state, wc.phone, wc.clerk_id, su.name AS clerk_name, wc.store_id store_id, sd.dept_name AS dept_name, wc.is_loss, wc.customer_source, wc.remark, wc.description, wc.remark_corp_name, wc.remark_mobiles, wc.remark_pic_mediaid, wc.remark_pic_url, IFNULL(wc.wecom_add, 'N') wecom_add, wc.mdbh, wc.mdmc, wc.gsmc, wc.hylx, wc.koul, wc.xfje, wc.ykh, wc.hytm, wc.ckh, wc.hd, wc.hybh, wc.mm, wc.sxrq, wc.created, wc.bank_deposit, wc.bank_account, wc.postal_code, wc.tax_no, wc.default_discount_rate, wc.education FROM we_customer wc LEFT JOIN we_flower_customer_rel wfcr ON wfcr.external_userid = wc.external_userid LEFT JOIN (SELECT u.user_name, u.name, u.user_id, u.dept_id, u.phonenumber, c.first_user_id FROM sys_user u INNER JOIN we_customer c ON u.user_id = c.first_user_id UNION ALL SELECT ser.user_name, ser.name, ser.user_id, ser.dept_id, ser.phonenumber, mer.first_user_id FROM sys_user ser INNER JOIN we_customer mer ON ser.user_id = mer.clerk_id) su ON wc.first_user_id = su.first_user_id LEFT JOIN sys_dept sd ON sd.dept_id = su.dept_id WHERE wc.del_flag = '0' AND wc.name LIKE concat('%', 'aaa', '%') GROUP BY wc.id) table_count
[2022-11-09 16:24:08.095229] [32289] [WARN] [exception.cpp:42] MSG: Exception: assert failed on i < m_idx.size() at rc_attr.h:342, msg: [bad dpn index 0/0].

STACK TRACE BEGIN
/opt/stonedb57/install/bin/mysqld(Tianmu::common::AssertException::AssertException(char const*, char const*, int, std::string const&)+0x317) [0x1753bd7]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::RCAttr::get_dpn(unsigned long)+0x165) [0x160d945]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::RCAttr::LockPackForUse(unsigned int)+0x29) [0x17cef59]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::VCPackGuardian::LockPackrow(Tianmu::core::MIIterator const&)+0x12e) [0x17ad17e]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::AggregationAlgorithm::AggregatePackrow(Tianmu::core::GroupByWrapper&, Tianmu::core::MIIterator*, long)+0xdd) [0x1757b2d]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::AggregationAlgorithm::MultiDimensionalGroupByScan(Tianmu::core::GroupByWrapper&, long&, long&, Tianmu::core::ResultSender*, bool, bool)+0xfba) [0x175e70a]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::AggregationAlgorithm::Aggregate(bool, long&, long&, Tianmu::core::ResultSender*)+0x456) [0x175ed86]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::TempTable::Materialize(bool, Tianmu::core::ResultSender*, bool)+0x270) [0x1638540]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::TempTable::TempTable(Tianmu::core::JustATable*, int, Tianmu::core::Query*)+0x2bd) [0x163daed]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::TempTable::Create(Tianmu::core::JustATable*, int, Tianmu::core::Query*, bool)+0x1ee) [0x1631ace]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::Query::Preexecute(Tianmu::core::CompiledQuery&, Tianmu::core::ResultSender*, bool)+0x189e) [0x15e782e]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::Engine::Execute(THD*, LEX*, Query_result*, st_select_lex_unit*)+0x4f8) [0x15cc618]
/opt/stonedb57/install/bin/mysqld(Tianmu::core::Engine::HandleSelect(THD*, LEX*, Query_result*&, unsigned long, int&, int&, int&, int)+0x8ca) [0x15cd55a]
/opt/stonedb57/install/bin/mysqld(Tianmu::handler::ha_my_tianmu_query(THD*, LEX*, Query_result*&, unsigned long, int&, int&, int&, int)+0x35) [0x164f415]
/opt/stonedb57/install/bin/mysqld() [0xfab7b8]
/opt/stonedb57/install/bin/mysqld(mysql_execute_command(THD*, bool)+0x45e0) [0xfb2840]
/opt/stonedb57/install/bin/mysqld(mysql_parse(THD*, Parser_state*)+0x425) [0xfb48e5]
/opt/stonedb57/install/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1599) [0xfb5ee9]
/opt/stonedb57/install/bin/mysqld(do_command(THD*)+0x207) [0xfb6c07]
/opt/stonedb57/install/bin/mysqld(handle_connection+0x2b8) [0x106ed48]
/opt/stonedb57/install/bin/mysqld(pfs_spawn_thread+0x164) [0x15449d4]
/lib64/libpthread.so.0(+0x7ea5) [0x2b4b72405ea5]
/lib64/libc.so.6(clone+0x6d) [0x2b4b74fb9b0d]
STACK TRACE END

[2022-11-09 16:24:08.095487] [32289] [INFO] [engine_execute.cpp:455] MSG: Query terminated with exception: SELECT count(0) FROM (SELECT wc.id, wc.external_userid, wc.name, wc.avatar, wc.type, wc.gender, wc.unionid, wc.birthday, wc.corp_name, wc.corp_full_name, wc.position, wc.is_open_chat, wc.first_user_id, wc.first_user_id AS user_tid, wc.first_user_id AS create_by_user, wc.first_add_time AS create_time_user, wfcr.status, (SELECT COUNT(*) FROM we_flower_customer_tag_rel wfcrf WHERE wfcrf.external_userid = wc.external_userid) AS user_id, wc.card_number, wc.grade, wc.id_card, wc.age, wc.source, wc.now_money, wc.brokerage_price, wc.wechat_id, wc.integral, wc.member_id, wc.recent_login_time, wc.recent_login_ip, wc.track_state, wc.phone, wc.clerk_id, su.name AS clerk_name, wc.store_id store_id, sd.dept_name AS dept_name, wc.is_loss, wc.customer_source, wc.remark, wc.description, wc.remark_corp_name, wc.remark_mobiles, wc.remark_pic_mediaid, wc.remark_pic_url, IFNULL(wc.wecom_add, 'N') wecom_add, wc.mdbh, wc.mdmc, wc.gsmc, wc.hylx, wc.koul, wc.xfje, wc.ykh, wc.hytm, wc.ckh, wc.hd, wc.hybh, wc.mm, wc.sxrq, wc.created, wc.bank_deposit, wc.bank_account, wc.postal_code, wc.tax_no, wc.default_discount_rate, wc.education FROM we_customer wc LEFT JOIN we_flower_customer_rel wfcr ON wfcr.external_userid = wc.external_userid LEFT JOIN (SELECT u.user_name, u.name, u.user_id, u.dept_id, u.phonenumber, c.first_user_id FROM sys_user u INNER JOIN we_customer c ON u.user_id = c.first_user_id UNION ALL SELECT ser.user_name, ser.name, ser.user_id, ser.dept_id, ser.phonenumber, mer.first_user_id FROM sys_user ser INNER JOIN we_customer mer ON ser.user_id = mer.clerk_id) su ON wc.first_user_id = su.first_user_id LEFT JOIN sys_dept sd ON sd.dept_id = su.dept_id WHERE wc.del_flag = '0' AND wc.name LIKE concat('%', 'aaa', '%') GROUP BY wc.id) table_count

Expected behavior

No response

How To Reproduce

No response

Environment

No response

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

• Yes, I will!

[konghaiya]

@adofsauron PTAL

[adofsauron]

Need to provide the sql and table structure to be executed

[RingsC]

SELECT COUNT(0)
FROM (
	SELECT wc.id, wc.external_userid, wc.name, wc.avatar, wc.type
		, wc.gender, wc.unionid, wc.birthday, wc.corp_name, wc.corp_full_name
		, wc.position, wc.is_open_chat, wc.first_user_id, wc.first_user_id AS user_tid, wc.first_user_id AS create_by_user
		, wc.first_add_time AS create_time_user, wfcr.status
		, (
			SELECT COUNT(*)
			FROM we_flower_customer_tag_rel wfcrf
			WHERE wfcrf.external_userid = wc.external_userid
		) AS user_id, wc.card_number, wc.grade, wc.id_card, wc.age
		, wc.source, wc.now_money, wc.brokerage_price, wc.wechat_id, wc.integral
		, wc.member_id, wc.recent_login_time, wc.recent_login_ip, wc.track_state, wc.phone
		, wc.clerk_id, su.name AS clerk_name, wc.store_id AS store_id, sd.dept_name AS dept_name, wc.is_loss
		, wc.customer_source, wc.remark, wc.description, wc.remark_corp_name, wc.remark_mobiles
		, wc.remark_pic_mediaid, wc.remark_pic_url, IFNULL(wc.wecom_add, 'N') AS wecom_add
		, wc.mdbh, wc.mdmc, wc.gsmc, wc.hylx, wc.koul
		, wc.xfje, wc.ykh, wc.hytm, wc.ckh, wc.hd
		, wc.hybh, wc.mm, wc.sxrq, wc.created, wc.bank_deposit
		, wc.bank_account, wc.postal_code, wc.tax_no, wc.default_discount_rate, wc.education
	FROM we_customer wc
		LEFT JOIN we_flower_customer_rel wfcr ON wfcr.external_userid = wc.external_userid
		LEFT JOIN (
			SELECT u.user_name, u.name, u.user_id, u.dept_id, u.phonenumber
				, c.first_user_id
			FROM sys_user u
				INNER JOIN we_customer c ON u.user_id = c.first_user_id
			UNION ALL
			SELECT ser.user_name, ser.name, ser.user_id, ser.dept_id, ser.phonenumber
				, mer.first_user_id
			FROM sys_user ser
				INNER JOIN we_customer mer ON ser.user_id = mer.clerk_id
		) su
		ON wc.first_user_id = su.first_user_id
		LEFT JOIN sys_dept sd ON sd.dept_id = su.dept_id
	WHERE wc.del_flag = '0'
		AND wc.name LIKE concat('%', 'aaa', '%')
	GROUP BY wc.id
) table_count

[RingsC]

@haitaoguan , Would you give out the definitions of these tables. Thanks.