[MDEV-448] Memory loss warnings in mysqldump when more than one schema is dumped Created: 2012-08-12  Updated: 2012-09-02  Resolved: 2012-09-02

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.25
Fix Version/s: 5.5.27

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

-DCMAKE_BUILD_TYPE=Debug



 Description   

When mysqldump is executed for only one database, it runs smoothly. If it's executed for more than one database, it throws a warning on each additional schema.

I suppose these warnings are just as harmless as the previous ones, but it would be nice to fix/suppress them anyway.

~/maria-5.5/client/mysqldump -uroot --protocol=tcp --port=3306 --databases mysql test > d1
Warning: 26624 bytes lost, allocated at mysys/my_malloc.c:89, mysys/string.c:84, client/mysqldump.c:5508, client/mysqldump.c:3678, client/mysqldump.c:4414, client/mysqldump.c:4219, client/mysqldump.c:5633, ??:0
Memory lost: 26624 bytes in 1 chunks

If it's executed with --all-databases option, it throws some more warnings (even although there are only these two databases, 'mysql' and 'test':

~/maria-5.5/client/mysqldump -uroot --protocol=tcp --port=3306 --databases --all-databases > d1
Warning: 26624 bytes lost, allocated at mysys/my_malloc.c:89, mysys/string.c:84, client/mysqldump.c:5508, client/mysqldump.c:3678, client/mysqldump.c:4414, client/mysqldump.c:4180, client/mysqldump.c:5615, ??:0
Warning: 8152 bytes lost, allocated at mysys/my_alloc.c:217, sql-common/client.c:1596, sql-common/client.c:3981, client/mysqldump.c:1110, client/mysqldump.c:4168, client/mysqldump.c:5615, ??:0, ??:0
Warning:   96 bytes lost, allocated at sql-common/client.c:1573, sql-common/client.c:3981, client/mysqldump.c:1110, client/mysqldump.c:4168, client/mysqldump.c:5615, ??:0, ??:0
Warning:  160 bytes lost, allocated at sql-common/client.c:3970, client/mysqldump.c:1110, client/mysqldump.c:4168, client/mysqldump.c:5615, ??:0, ??:0
Warning: 8152 bytes lost, allocated at mysys/my_alloc.c:217, sql-common/client.c:1450, sql-common/client.c:3914, sql-common/client.c:3948, libmysql/libmysql.c:715, client/mysqldump.c:1109, client/mysqldump.c:4168, client/mysqldump.c:5615
Memory lost: 43184 bytes in 5 chunks
 
mysql -uroot --protocol=tcp --port=3306 -e "show databases"
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+


Generated at Thu Feb 08 06:28:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.