[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 - 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
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, 11.2.1
Component/s: Server
Labels:

Description

SET sql_mode= 'oracle';

WHILE f(8)<1 DO SELECT 1;

SHUTDOWN;

Leads to:

10.7.0 57f14eab20ae2733eb341f3d293515a10a40bc48 (Optimized)
2021-07-20 18:09:19 0 [Note] /test/MD090721-mariadb-10.7.0-linux-x86_64-opt/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280

10.7.0 57f14eab20ae2733eb341f3d293515a10a40bc48 (Debug)
2021-07-20 18:09:18 0 [Note] /test/MD090721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280
Warning: 280 bytes lost at 0x150bc0022480, allocated by T@0 at 0x55de58a978ba, mysys/array.c:71, mysys/hash.c:98, sql/sp.cc:2324, sql/sp.cc:2639, sql/item_create.cc:2601, sql/item_create.cc:2450, sql/sql_yacc.yy:10748
Memory lost: 280 bytes in 1 chunks
Warning: 280 bytes lost at 0x150bc0022480, allocated by T@0 at sql/sql_parse.cc:10378, mysys/array.c:71, mysys/hash.c:98, sql/sp.cc:2324, sql/sp.cc:2639, sql/item_create.cc:2601, sql/item_create.cc:2450, sql/sql_yacc.yy:10748
Memory lost: 280 bytes in 1 chunks

Present in 10.5 to 10.11, in debug and optimized. Not present in 10.2 to 10.4.

Attachments

Issue Links

relates to

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

Closed

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2021-07-20 11:20

Roel Van de Paar made changes - 2021-08-10 10:56

Field	Original Value	New Value
Link		This issue relates to MDEV-26335 [ MDEV-26335 ]

Sergei Golubchik made changes - 2021-12-06 21:35

Workflow

MariaDB v3 [ 123592 ]

MariaDB v4 [ 143013 ]

Roel Van de Paar made changes - 2022-01-29 02:32

Fix Version/s

10.7 [ 24805 ]

Roel Van de Paar made changes - 2022-08-29 05:51

Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]

Roel Van de Paar made changes - 2022-08-29 05:51

Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]

Roel Van de Paar made changes - 2022-08-29 05:51

Fix Version/s

10.11 [ 27614 ]

Roel Van de Paar made changes - 2022-08-29 05:51

Description

{noformat}
SET sql_mode= 'oracle';
WHILE f(8)<1 DO SELECT 1;
SHUTDOWN;
{noformat}
Leads to:
{noformat:title=10.7.0 57f14eab20ae2733eb341f3d293515a10a40bc48 (Optimized)}
2021-07-20 18:09:19 0 [Note] /test/MD090721-mariadb-10.7.0-linux-x86_64-opt/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280
{noformat}
{noformat:title=10.7.0 57f14eab20ae2733eb341f3d293515a10a40bc48 (Debug)}
2021-07-20 18:09:18 0 [Note] /test/MD090721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280
Warning: 280 bytes lost at 0x150bc0022480, allocated by T@0 at 0x55de58a978ba, mysys/array.c:71, mysys/hash.c:98, sql/sp.cc:2324, sql/sp.cc:2639, sql/item_create.cc:2601, sql/item_create.cc:2450, sql/sql_yacc.yy:10748
Memory lost: 280 bytes in 1 chunks
Warning: 280 bytes lost at 0x150bc0022480, allocated by T@0 at sql/sql_parse.cc:10378, mysys/array.c:71, mysys/hash.c:98, sql/sp.cc:2324, sql/sp.cc:2639, sql/item_create.cc:2601, sql/item_create.cc:2450, sql/sql_yacc.yy:10748
Memory lost: 280 bytes in 1 chunks
{noformat}

Present in 10.5 to 10.7, in debug and optimized. Not present in 10.2 to 10.4.

{noformat}
SET sql_mode= 'oracle';
WHILE f(8)<1 DO SELECT 1;
SHUTDOWN;
{noformat}
Leads to:
{noformat:title=10.7.0 57f14eab20ae2733eb341f3d293515a10a40bc48 (Optimized)}
2021-07-20 18:09:19 0 [Note] /test/MD090721-mariadb-10.7.0-linux-x86_64-opt/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280
{noformat}
{noformat:title=10.7.0 57f14eab20ae2733eb341f3d293515a10a40bc48 (Debug)}
2021-07-20 18:09:18 0 [Note] /test/MD090721-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280
Warning: 280 bytes lost at 0x150bc0022480, allocated by T@0 at 0x55de58a978ba, mysys/array.c:71, mysys/hash.c:98, sql/sp.cc:2324, sql/sp.cc:2639, sql/item_create.cc:2601, sql/item_create.cc:2450, sql/sql_yacc.yy:10748
Memory lost: 280 bytes in 1 chunks
Warning: 280 bytes lost at 0x150bc0022480, allocated by T@0 at sql/sql_parse.cc:10378, mysys/array.c:71, mysys/hash.c:98, sql/sp.cc:2324, sql/sp.cc:2639, sql/item_create.cc:2601, sql/item_create.cc:2450, sql/sql_yacc.yy:10748
Memory lost: 280 bytes in 1 chunks
{noformat}

Present in 10.5 to 10.11, in debug and optimized. Not present in 10.2 to 10.4.

Roel Van de Paar made changes - 2022-08-29 05:51

Labels

Memory_leak not-10.2 not-10.3 not-10.4 regression

Memory_leak not-10.3 not-10.4 regression

Roel Van de Paar made changes - 2022-08-29 05:51

Labels

Memory_leak not-10.3 not-10.4 regression

Memory_leak memory_not_freed not-10.3 not-10.4 regression

Roel Van de Paar made changes - 2022-08-29 05:53

Assignee

Oleksandr Byelkin [ sanja ]

Alexander Barkov [ bar ]

Roel Van de Paar added a comment - 2023-01-09 05:24

Additional testcase

SET SESSION sql_mode=ORACLE;

BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RETURN f0();

SHUTDOWN;

10.11.2 70be59913c90e93fe5136d6f6df03c4254aa515d (Debug)
2023-01-09 16:22:29 0 [Note] /test/MD070123-mariadb-10.11.2-linux-x86_64-dbg/bin/mysqld: Shutdown complete
Warning: Memory not freed: 280

Roel Van de Paar added a comment - 2023-01-09 05:24 Additional testcase SET SESSION sql_mode=ORACLE; BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RETURN f0(); SHUTDOWN; 10.11.2 70be59913c90e93fe5136d6f6df03c4254aa515d (Debug) 2023-01-09 16:22:29 0 [Note] /test/MD070123-mariadb-10.11.2-linux-x86_64-dbg/bin/mysqld: Shutdown complete Warning: Memory not freed: 280

Roel Van de Paar made changes - 2023-01-09 05:24

Status

Open [ 1 ]

Confirmed [ 10101 ]

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

Fix Version/s

10.7 [ 24805 ]

Roel Van de Paar made changes - 2023-03-04 01:03

Link

This issue relates to MDEV-26335 [ MDEV-26335 ]

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

Fix Version/s

10.8 [ 26121 ]

Alexander Barkov added a comment - 2023-07-18 02:14 - edited

Repeatable in MTR in 10.5 as of c9eff1a144ba44846373660a30d342d3f0dc91a5:

SET sql_mode= 'oracle';

--error ER_PARSE_ERROR

--query WHILE f(8)<1 DO SELECT 1;

--error ER_SP_BADRETURN

BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RETURN f0();

Warning: Memory not freed: 560

Warning:  280 bytes lost at 0x7fb4d021d9c0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497

Warning:  280 bytes lost at 0x7fb4d000ab90, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497

Warning:  280 bytes lost at 0x7fb4d021d9c0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497

Warning:  280 bytes lost at 0x7fb4d000ab90, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497

Alexander Barkov added a comment - 2023-07-18 02:14 - edited Repeatable in MTR in 10.5 as of c9eff1a144ba44846373660a30d342d3f0dc91a5: SET sql_mode= 'oracle' ; --error ER_PARSE_ERROR --query WHILE f(8)<1 DO SELECT 1; --error ER_SP_BADRETURN BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RETURN f0(); Warning: Memory not freed: 560 Warning: 280 bytes lost at 0x7fb4d021d9c0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497 Warning: 280 bytes lost at 0x7fb4d000ab90, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497 Warning: 280 bytes lost at 0x7fb4d021d9c0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497 Warning: 280 bytes lost at 0x7fb4d000ab90, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10744, sql/sql_parse.cc:10497

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

Link

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

Alexander Barkov added a comment - 2023-07-18 02:29 - edited

With a later 10.5 which includes the fix for ~~MDEV-30680~~ (e.g as of 68403eeda320ad0831563ce09a9c4af1549fe65e) the first chunk does not leak memory any more:

SET sql_mode= 'oracle';

--error ER_PARSE_ERROR

--query WHILE f(8)<1 DO SELECT 1;

But the second chunk still does:

SET sql_mode= 'oracle';

--error ER_SP_BADRETURN

BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RETURN f0();

Warning: Memory not freed: 280

Warning:  280 bytes lost at 0x7f24b000aba0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10767, sql/sql_parse.cc:10455

Warning:  280 bytes lost at 0x7f24b000aba0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10767, sql/sql_parse.cc:10455

Alexander Barkov added a comment - 2023-07-18 02:29 - edited With a later 10.5 which includes the fix for MDEV-30680 (e.g as of 68403eeda320ad0831563ce09a9c4af1549fe65e) the first chunk does not leak memory any more: SET sql_mode= 'oracle' ; --error ER_PARSE_ERROR --query WHILE f(8)<1 DO SELECT 1; But the second chunk still does: SET sql_mode= 'oracle' ; --error ER_SP_BADRETURN BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION RETURN f0(); Warning: Memory not freed: 280 Warning: 280 bytes lost at 0x7f24b000aba0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10767, sql/sql_parse.cc:10455 Warning: 280 bytes lost at 0x7f24b000aba0, allocated by T@0 at mysys/array.c:72, mysys/hash.c:99, sql/sp.cc:2331, sql/sp.cc:2646, sql/item_create.cc:2631, sql/item_create.cc:2477, sql/sql_yacc.yy:10767, sql/sql_parse.cc:10455

Alexander Barkov added a comment - 2023-07-18 04:31

All these MTR tests also leak memory:

SET sql_mode= 'oracle';

--error ER_SP_LILABEL_MISMATCH

BEGIN CONTINUE WHEN f0();

SET sql_mode= 'oracle';

--error ER_SP_LILABEL_MISMATCH

BEGIN CONTINUE label WHEN f0();

SET sql_mode= 'oracle';

--error ER_SP_LILABEL_MISMATCH

BEGIN EXIT WHEN f0();

SET sql_mode= 'oracle';

--error ER_SP_LILABEL_MISMATCH

BEGIN EXIT label WHEN f0();

Alexander Barkov added a comment - 2023-07-18 04:31 All these MTR tests also leak memory: SET sql_mode= 'oracle' ; --error ER_SP_LILABEL_MISMATCH BEGIN CONTINUE WHEN f0(); SET sql_mode= 'oracle' ; --error ER_SP_LILABEL_MISMATCH BEGIN CONTINUE label WHEN f0(); SET sql_mode= 'oracle' ; --error ER_SP_LILABEL_MISMATCH BEGIN EXIT WHEN f0(); SET sql_mode= 'oracle' ; --error ER_SP_LILABEL_MISMATCH BEGIN EXIT label WHEN f0();

Alexander Barkov made changes - 2023-07-18 09:35

issue.field.resolutiondate

2023-07-18 09:35:23.0

2023-07-18 09:35:23.293

Alexander Barkov made changes - 2023-07-18 09:35

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		11.2.1 [ 29034 ]
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 ]
Resolution		Fixed [ 1 ]
Status	Confirmed [ 10101 ]	Closed [ 6 ]

People

Assignee:: Alexander Barkov

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2021-07-20 11:20

Updated:: 2023-07-18 13:44

Resolved:: 2023-07-18 09:35

Git Integration

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