[MDEV-24847] Server crashes in Field_long::cmp()[field.cc:4438] when index merge is used Created: 2021-02-11 Updated: 2021-10-28 Resolved: 2021-07-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer |
| Affects Version/s: | 10.5.8 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Valerii Kravchuk | Assignee: | Sergei Petrunia |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | index_merge | ||
| Environment: |
Windows |
||
| Description |
|
Server crashes on Windows with the following stack trace:
while executing a complex SELECT query with many tables and index_merge used in the plan. The crash happens here it seems:
and Windows mindump reports this:
not sure why. |
| Comments |
| Comment by Sergei Petrunia [ 2021-07-01 ] | |||
|
After loading the minidump, I see this:
unfortunately there is not much else. The rowids are in the InnoDB table, they are 8-byte integer fields. This
seems to hint we're sorting 42M data which is ~5M rows.. | |||
| Comment by Sergei Petrunia [ 2021-07-01 ] | |||
|
It doesn't look like it's realistic to infer something from this info. | |||
| Comment by Sergei Petrunia [ 2021-07-02 ] | |||
|
Tried reproducing, no success. Another item we need to know: does the problem happen every time the query is ran or only sometimes? |