[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 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 made changes - 2023-07-18 02:26

Link

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

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.