[MDEV-30680] Warning: Memory not freed: 280 on mangled query, LeakSanitizer: detected memory leaks - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.8.8, 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2
Component/s: Stored routines
Labels:

Description

Present in 10.5+ only, both in debug and optimized.

IF(NOT (scalar (@0s)>scalar (@0s))) { die (.);�ku u va�oj SQL sINTaksi{ die (. na liniji0;;

SHUTDOWN;

Leads to (ref error log after shutdown):

11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Debug)
2023-02-18 14:22:07 0 [Note] /test/MD180223-mariadb-11.0.1-linux-x86_64-dbg/bin/mariadbd: Shutdown complete
Warning: Memory not freed: 280

In all affected versions.

No UBSAN/ASAN issues observed.

I tried to make this work under MTR for some time, but failed. AFAICS ftm, this issue can only be reproduced in a client, not in MTR, not even when using the CLI via MTR i.e. --start-and-exit.

As such, you will need to start mariadbd and then mariadb manually/directly to reproduce.

Attachments

Issue Links

relates to

MDEV-26186 280 Bytes lost in mysys/array.c, mysys/hash.c, sql/sp.cc, sql/sp.cc, sql/item_create.cc, sql/item_create.cc, sql/sql_yacc.yy:10748 when using oracle sql_mode

Closed

MDEV-31578 DECLARE CURSOR: "Memory not freed: 280 bytes lost" on syntax error

Closed

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2023-02-18 03:20

Roel Van de Paar made changes - 2023-02-18 03:21

Field	Original Value	New Value
Description	Present in 10.5+ only, both in debug and optimized. {code:sql} IF(NOT (scalar (@0s)>scalar (@0s))) { die (.);�ku u va�oj SQL sINTaksi{ die (. na liniji0;; SHUTDOWN; {code} Leads to: {noformat} Warning: Memory not freed: 280 {noformat} In all affected versions. No UBSAN/ASAN issues observed. I tried to make this work under MTR for some time, but failed. AFAICS ftm, this issue can only be reproduced in a client, not in MTR, not even when using the CLI via MTR i.e. {{--start-and-exit}}. As such, you will need to start mariadbd and then mariadb manually/directly to reproduce.	Present in 10.5+ only, both in debug and optimized. {code:sql} IF(NOT (scalar (@0s)>scalar (@0s))) { die (.);�ku u va�oj SQL sINTaksi{ die (. na liniji0;; SHUTDOWN; {code} Leads to (ref error log after shutdown): {noformat} Warning: Memory not freed: 280 {noformat} In all affected versions. No UBSAN/ASAN issues observed. I tried to make this work under MTR for some time, but failed. AFAICS ftm, this issue can only be reproduced in a client, not in MTR, not even when using the CLI via MTR i.e. {{--start-and-exit}}. As such, you will need to start mariadbd and then mariadb manually/directly to reproduce.

Roel Van de Paar made changes - 2023-02-18 03:22

Description

Present in 10.5+ only, both in debug and optimized.
{code:sql}
IF(NOT (scalar (@0s)>scalar (@0s))) { die (.);�ku u va�oj SQL sINTaksi{ die (. na liniji0;;
SHUTDOWN;
{code}
Leads to (ref error log after shutdown):
{noformat}
Warning: Memory not freed: 280
{noformat}
In all affected versions.

No UBSAN/ASAN issues observed.

I tried to make this work under MTR for some time, but failed. AFAICS ftm, this issue can only be reproduced in a client, not in MTR, not even when using the CLI via MTR i.e. {{--start-and-exit}}.

As such, you will need to start mariadbd and then mariadb manually/directly to reproduce.

Present in 10.5+ only, both in debug and optimized.
{code:sql}
IF(NOT (scalar (@0s)>scalar (@0s))) { die (.);�ku u va�oj SQL sINTaksi{ die (. na liniji0;;
SHUTDOWN;
{code}
Leads to (ref error log after shutdown):
{noformat:title=11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Debug)}
2023-02-18 14:22:07 0 [Note] /test/MD180223-mariadb-11.0.1-linux-x86_64-dbg/bin/mariadbd: Shutdown complete
Warning: Memory not freed: 280
{noformat}
In all affected versions.

No UBSAN/ASAN issues observed.

I tried to make this work under MTR for some time, but failed. AFAICS ftm, this issue can only be reproduced in a client, not in MTR, not even when using the CLI via MTR i.e. {{--start-and-exit}}.

As such, you will need to start mariadbd and then mariadb manually/directly to reproduce.

Ramesh Sivaraman made changes - 2023-02-20 06:28

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julien Fritsch made changes - 2023-03-03 17:31

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 14:51

Fix Version/s

10.8 [ 26121 ]

Roel Van de Paar made changes - 2023-05-13 04:10

Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.1 [ 28549 ]
Affects Version/s		11.1 [ 28549 ]
Labels	regression-10.5	Memory_leak regression-10.5

Roel Van de Paar made changes - 2023-05-13 04:11

Summary

Warning: Memory not freed: 280 on mangled query

Warning: Memory not freed: 280 on mangled query, LeakSanitizer: detected memory leaks

Roel Van de Paar made changes - 2023-05-13 04:12

Labels

Memory_leak regression-10.5

LSAN Memory_leak regression-10.5

Alexander Barkov made changes - 2023-05-15 10:09

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Alexander Barkov made changes - 2023-05-15 10:10

Assignee	Alexander Barkov [ bar ]	Dmitry Shulga [ JIRAUSER47315 ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Dmitry Shulga made changes - 2023-06-20 05:56

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Dmitry Shulga made changes - 2023-06-20 07:47

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Dmitry Shulga made changes - 2023-06-20 07:47

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Alexander Barkov made changes - 2023-06-21 13:42

Assignee

Dmitry Shulga [ JIRAUSER47315 ]

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2023-06-21 13:42

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Alexander Barkov made changes - 2023-06-29 10:13

Link

This issue relates to ~~MDEV-31578~~ [ ~~MDEV-31578~~ ]

Alexander Barkov made changes - 2023-06-29 10:48

Component/s		Stored routines [ 13905 ]
Fix Version/s		10.5.22 [ 29011 ]
Fix Version/s		10.6.15 [ 29013 ]
Fix Version/s		10.9.8 [ 29015 ]
Fix Version/s		10.10.6 [ 29017 ]
Fix Version/s		10.11.5 [ 29019 ]
Fix Version/s		11.0.3 [ 28920 ]
Fix Version/s		11.1.2 [ 28921 ]
Fix Version/s		10.8.8 [ 28518 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.0 [ 28320 ]
Fix Version/s	11.1 [ 28549 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Alexander Barkov made changes - 2023-07-18 02:26

Link

This issue relates to ~~MDEV-26186~~ [ ~~MDEV-26186~~ ]

People

Assignee:: Alexander Barkov

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-02-18 03:20

Updated:: 2023-07-18 02:26

Resolved:: 2023-06-29 10:48

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration