Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Issues

Go to all issues
Select view

Select search mode

 
50 of 195

DELETE of already deleted records range crashes PXC server

Done

Description

While running pquery3, a crash is seen on node 1. The details of the crash is furnished below:
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x55) [0x4db5f6c]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x2db) [0x3b6f6b5]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7fa65e6c9390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7fa65c6dc428]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fa65c6de02a]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x1c1) [0x524763a]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld() [0x516967c]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long)+0x29fa) [0x516c16e]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function)+0x5e6) [0x4eca0b6]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function)+0x64) [0x35137a0]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function)+0x25d) [0x34fd837]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(handler::read_range_first(key_range const*, key_range const*, bool, bool)+0x10d) [0x3509f09]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(ha_innobase::read_range_first(key_range const*, key_range const*, bool, bool)+0x68) [0x4ecb5b4]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(handler::multi_range_read_next(char**)+0x207) [0x3507c71]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(DsMrr_impl::dsmrr_next(char**)+0x49) [0x3508c7d]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(ha_innobase::multi_range_read_next(char**)+0x2a) [0x4eec81a]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(handler::ha_multi_range_read_next(char**)+0x7b) [0x35079bb]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(QUICK_RANGE_SELECT::get_next()+0xa7) [0x375e1df]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(IndexRangeScanIterator::Read()+0x41) [0x37c4eef]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(Sql_cmd_delete::delete_from_single_table(THD*)+0x1676) [0x389d5d4]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(Sql_cmd_delete::execute_inner(THD*)+0x44) [0x389eb82]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x406) [0x39d2c5e]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(mysql_execute_command(THD*, bool)+0x3166) [0x395faf7]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x719) [0x39681b5]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld() [0x396c101]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1878) [0x39592e7]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(do_command(THD*)+0x93c) [0x3956e50]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld(threadpool_process_request(THD*)+0x82) [0x3af9918]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld() [0x3b2d8a5]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld() [0x3b2da99]
/home/mohit.joshi/pxc-8.0_build/Percona-XtraDB-Cluster_8.0.18.9-26.4.3_debug.Linux.x86_64/bin/mysqld() [0x55af319]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7fa65e6bf6ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fa65c7ae41d]Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fa5fccd2028): DELETE FROM tt_2_p WHERE ipkey BETWEEN 6157 AND 7024
Connection ID (thread ID): 33
Status: NOT_KILLED

Environment

None

blocks

Smart Checklist

Details

Assignee

Reporter

Needs Review

Yes

Time tracking

2d 5h logged

Fix versions

Priority

Smart Checklist

Created March 3, 2020 at 12:57 PM
Updated March 6, 2024 at 9:46 PM
Resolved April 29, 2020 at 1:15 PM

Activity

Show:

mohit.joshiApril 28, 2020 at 4:16 PM

Comments from QA: Post-merge, the issue is not seen.

Flag notifications