Found this issue while testing PXC-8.0 with pstress. But this assertion fails even on PS-8.0.
mysqld: /home/venki/work/ps/80/sql/dd/impl/raw/raw_record.cc:171: bool dd::Raw_record::store(int, ulonglong, bool): Assertion `rc == TYPE_OK' failed.
04:31:50 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.Build ID: f5f4a0418ad99f35a63c387ac0e736b569e3a510
Server Version: 8.0.22-13-debug Source distributionThread pointer: 0x7febc4001040
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 = 7fec940dace8 thread_stack 0x46000
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x55) [0x565182123882]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(handle_fatal_signal+0x2e0) [0x565180eef748]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7feca604d3c0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7feca568a18b]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7feca5669859]
/lib/x86_64-linux-gnu/libc.so.6(+0x25729) [0x7feca5669729]
/lib/x86_64-linux-gnu/libc.so.6(+0x36f36) [0x7feca567af36]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Raw_record::store(int, unsigned long long, bool)+0x8b) [0x565181ff1e11]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Raw_record::store(int, unsigned int, bool)+0x2d) [0x56518205fafd]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Partition_value_impl::store_attributes(dd::Raw_record*)+0x6d) [0x56518208c8db]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Weak_object_impl::store(dd::Open_dictionary_tables_ctx*)+0x3f1) [0x5651820b411d]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Collection<dd::Partition_value*>::store_items(dd::Open_dictionary_tables_ctx*)+0x1a7) [0x565181e25cc1]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Partition_impl::store_children(dd::Open_dictionary_tables_ctx*)+0xda) [0x565182086568]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Weak_object_impl::store(dd::Open_dictionary_tables_ctx*)+0x52f) [0x5651820b425b]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Collection<dd::Partition*>::store_items(dd::Open_dictionary_tables_ctx*)+0x1a7) [0x565181e25885]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Table_impl::store_children(dd::Open_dictionary_tables_ctx*)+0x96) [0x565182098f6e]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Weak_object_impl::store(dd::Open_dictionary_tables_ctx*)+0x52f) [0x5651820b425b]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(bool dd::cache::Storage_adapter::store<dd::Table>(THD*, dd::Table*)+0x248) [0x565181fd965e]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(bool dd::cache::Dictionary_client::store<dd::Table>(dd::Table*)+0x1f1) [0x565181ee082f]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x372d94b) [0x565180d9294b]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x3743644) [0x565180da8644]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_create_table_no_lock(THD*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, unsigned int, bool, bool*, handlerton**)+0x7de) [0x565180da936a]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_create_table(THD*, TABLE_LIST*, HA_CREATE_INFO*, Alter_info*)+0x5f6) [0x565180dacede]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(Sql_cmd_create_table::execute(THD*)+0xd6f) [0x565180c21f93]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_execute_command(THD*, bool)+0x22d6) [0x565180cd3fb8]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x745) [0x565180cd99d1]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1586) [0x565180ccef43]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(do_command(THD*)+0x548) [0x565180ccd3a8]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x3872b2c) [0x565180ed7b2c]
/home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x5321678) [0x565182986678]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7feca6041609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7feca5766103]Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7febc400ab38): CREATE TABLE tt_4_p (ip_col INT, ipkey INT, d1 DOUBLE, PRIMARY KEY(ipkey, ip_col), INDEX tt_4_pi0(ipkey ASC) ) COMPRESSION='zlib' ENGINE=INNODB PARTITION BY LIST (ip_col)( PARTITION p0 VALUES IN (3790,639,349,853,301,2573,3768,1781,1913,268,721,80,3929,2204,1343,1302,3763,1162,1840,1848,1474,1837,2297,3836,3639,2129,3919,2998,2783,913,1473,3474,3450,3366,3693,2637,2171,947,2845,1514,3483,2820,2735,3966,2598,2215,1520,3133,2398,2408,969,2770,477,296,1032,1414,1780,2059,1374,1746,2808,3070,1528,759,2018,2357,1158,3359,355,912,2870,1110,891,1933,1862,694,2377,1895,2692,956,1656,1857,1113,1758,3571,2125,2579,2757,988,1649,3077,3351,2148,2849,1674,456,386,899,880,2893,418,1057,2793,1156,2996,1600,1740,917,212,3979,673,2327,3779,2174,3567,1642,1589,478,561,3439,1774,1573,1733,1182,75,2875,2885,990,2633,551,2352,3691,3232,3471,3285,3954,847,2751,275,1247,1470,2492,3527,1272,3107,2966,1018,2281,2940,1613,2268,2961,1100,3154,2888,1820,1129,3911,1361,3292,798,3587,2233,565,1794,3164,2529,192,40,3582,1619,1694,146,234
Connection ID (thread ID): 19
Status: NOT_KILLED
Found this issue while testing PXC-8.0 with pstress. But this assertion fails even on PS-8.0.
mysqld: /home/venki/work/ps/80/sql/dd/impl/raw/raw_record.cc:171: bool dd::Raw_record::store(int, ulonglong, bool): Assertion `rc == TYPE_OK' failed. 04:31:50 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.Build ID: f5f4a0418ad99f35a63c387ac0e736b569e3a510 Server Version: 8.0.22-13-debug Source distributionThread pointer: 0x7febc4001040 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 = 7fec940dace8 thread_stack 0x46000 /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x55) [0x565182123882] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(handle_fatal_signal+0x2e0) [0x565180eef748] /lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7feca604d3c0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb) [0x7feca568a18b] /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b) [0x7feca5669859] /lib/x86_64-linux-gnu/libc.so.6(+0x25729) [0x7feca5669729] /lib/x86_64-linux-gnu/libc.so.6(+0x36f36) [0x7feca567af36] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Raw_record::store(int, unsigned long long, bool)+0x8b) [0x565181ff1e11] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Raw_record::store(int, unsigned int, bool)+0x2d) [0x56518205fafd] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Partition_value_impl::store_attributes(dd::Raw_record*)+0x6d) [0x56518208c8db] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Weak_object_impl::store(dd::Open_dictionary_tables_ctx*)+0x3f1) [0x5651820b411d] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Collection<dd::Partition_value*>::store_items(dd::Open_dictionary_tables_ctx*)+0x1a7) [0x565181e25cc1] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Partition_impl::store_children(dd::Open_dictionary_tables_ctx*)+0xda) [0x565182086568] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Weak_object_impl::store(dd::Open_dictionary_tables_ctx*)+0x52f) [0x5651820b425b] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Collection<dd::Partition*>::store_items(dd::Open_dictionary_tables_ctx*)+0x1a7) [0x565181e25885] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Table_impl::store_children(dd::Open_dictionary_tables_ctx*)+0x96) [0x565182098f6e] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dd::Weak_object_impl::store(dd::Open_dictionary_tables_ctx*)+0x52f) [0x5651820b425b] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(bool dd::cache::Storage_adapter::store<dd::Table>(THD*, dd::Table*)+0x248) [0x565181fd965e] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(bool dd::cache::Dictionary_client::store<dd::Table>(dd::Table*)+0x1f1) [0x565181ee082f] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x372d94b) [0x565180d9294b] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x3743644) [0x565180da8644] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_create_table_no_lock(THD*, char const*, char const*, HA_CREATE_INFO*, Alter_info*, unsigned int, bool, bool*, handlerton**)+0x7de) [0x565180da936a] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_create_table(THD*, TABLE_LIST*, HA_CREATE_INFO*, Alter_info*)+0x5f6) [0x565180dacede] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(Sql_cmd_create_table::execute(THD*)+0xd6f) [0x565180c21f93] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_execute_command(THD*, bool)+0x22d6) [0x565180cd3fb8] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x745) [0x565180cd99d1] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1586) [0x565180ccef43] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(do_command(THD*)+0x548) [0x565180ccd3a8] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x3872b2c) [0x565180ed7b2c] /home/venki/work/ps/80/bld/runtime_output_directory/mysqld(+0x5321678) [0x565182986678] /lib/x86_64-linux-gnu/libpthread.so.0(+0x9609) [0x7feca6041609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7feca5766103]Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7febc400ab38): CREATE TABLE tt_4_p (ip_col INT, ipkey INT, d1 DOUBLE, PRIMARY KEY(ipkey, ip_col), INDEX tt_4_pi0(ipkey ASC) ) COMPRESSION='zlib' ENGINE=INNODB PARTITION BY LIST (ip_col)( PARTITION p0 VALUES IN (3790,639,349,853,301,2573,3768,1781,1913,268,721,80,3929,2204,1343,1302,3763,1162,1840,1848,1474,1837,2297,3836,3639,2129,3919,2998,2783,913,1473,3474,3450,3366,3693,2637,2171,947,2845,1514,3483,2820,2735,3966,2598,2215,1520,3133,2398,2408,969,2770,477,296,1032,1414,1780,2059,1374,1746,2808,3070,1528,759,2018,2357,1158,3359,355,912,2870,1110,891,1933,1862,694,2377,1895,2692,956,1656,1857,1113,1758,3571,2125,2579,2757,988,1649,3077,3351,2148,2849,1674,456,386,899,880,2893,418,1057,2793,1156,2996,1600,1740,917,212,3979,673,2327,3779,2174,3567,1642,1589,478,561,3439,1774,1573,1733,1182,75,2875,2885,990,2633,551,2352,3691,3232,3471,3285,3954,847,2751,275,1247,1470,2492,3527,1272,3107,2966,1018,2281,2940,1613,2268,2961,1100,3154,2888,1820,1129,3911,1361,3292,798,3587,2233,565,1794,3164,2529,192,40,3582,1619,1694,146,234 Connection ID (thread ID): 19 Status: NOT_KILLED
Steps to reproduce:
./pstress-pxc --database=test --threads=64 --queries-per-thread=2147483647 --logdir=./ --user=root --socket=/home/venki/work/ps/80/bld/mysql-test/var/tmp/mysqld.1.sock --step 1 --metadata-path ./ --tables 200 --records 4000 --log-all-queries --log-failed-queries --no-encryption --no-temp-tables --check 0 --analyze 100