[MDEV-26754] main.sp test fails for embedded server Created: 2021-10-04  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Embedded Server, Tests
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Dmitry Shulga
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-20699 mysqldump of routines causes MariaDB ... Closed
Relates
relates to MDEV-26723 Cached stored procedures are counted ... Open

 Description   

The test main.sp that was enhanced by wlad in MDEV-20699 would fail on 10.3 and 10.4 with embedded. This might be a sign of a memory leak

./mtr --embedded main.sp

like this:

--- /mariadb/10.3/mysql-test/main/sp.result	2021-09-29 15:08:31.711087544 +0300
 
+++ /mariadb/10.3/mysql-test/main/sp.reject	2021-10-04 11:08:53.851498265 +0300
 
@@ -8913,6 +8913,6 @@
 
 0
 
 SELECT VARIABLE_VALUE-@global_mem_used FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME='MEMORY_USED';
 
 VARIABLE_VALUE-@global_mem_used
 
-0
 
+1888
 
 DROP PROCEDURE sp1;
 
 # End of 10.3 tests

On merge to 10.5, I had already disabled this part of the test. Possibly this part of the test will have to be rewritten as MDEV-26723.

 Comments   
Comment by Marko Mäkelä [ 2021-10-04 ]

I pushed a work-around for this (disabled that part of the test).

Comment by Vladislav Vaintroub [ 2022-07-07 ]

Reassigning, as the cause is MDEV-26723 , needs to be fixed together with it.

Generated at Thu Feb 08 09:47:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.