[MDEV-21741] [Warning] InnoDB: Failed to set memory to MADV_DONTDUMP: Function not implemented Created: 2020-02-15  Updated: 2020-04-05  Resolved: 2020-04-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.4.10
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Abel Torre Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: innodb
Environment:

RMerl/asuswrt through Entware


Issue Links:
Relates
relates to MDEV-10814 Feature request: Optionally exclude ... Closed

 Description   

A month ago the Mariadb server and client worked perfectly with phpMyAdmin, but since I reinstalled the entire system I have appeared in the SSH console:

/opt/bin/mysql_install_db --user=admin --basedir=/opt --datadir=/opt/var/mysql/ --lc-messages-dir=/opt/share/mariadb

Installing MariaDB/MySQL system tables in '/opt/var/mysql/' ...
2020-02-15 18:55:02 0 [Warning] InnoDB: Failed to set memory to MADV_DONTDUMP: F unction not implemented ptr 0x7f73bff000 size 134217728
2020-02-15 18:55:02 0 [Warning] InnoDB: Failed to set memory to MADV_DONTDUMP: F unction not implemented ptr 0x7f71bff000 size 33554432
2020-02-15 18:55:02 0 [Warning] InnoDB: Failed to set memory to MADV_DONTDUMP: Function not implemented ptr 0x7f8014a000 size 2097152
2020-02-15 18:55:02 0 [Warning] InnoDB: Failed to set memory to MADV_DODUMP: Function not implemented ptr 0x7f8014a000 size 2097152
2020-02-15 18:55:03 0 [Warning] InnoDB: Failed to set memory to MADV_DODUMP: Function not implemented ptr 0x7f71bff000 size 33554432
2020-02-15 18:55:03 0 [Warning] InnoDB: Failed to set memory to MADV_DODUMP: Function not implemented ptr 0x7f73bff000 size 134217728
OK

Impossible to start the server with the command:

/opt/etc/init.d/S70mysqld start

Is it possible to deactivate the MADV_DODUMP function ?. The "-core-file" and "-innodb-buffer-pool-in-core-file" commands do not exist in this system Linux.

I have a previous backup and this does not happen.



 Comments   
Comment by Abel Torre [ 2020-02-20 ]

I've tried these settings and it doesn't change anything:

[mysqld]
innodb_buffer_pool_size=8G
core-file
core-nodump=NONE

[mysqld]
innodb_buffer_pool_size=8G
core-file
core-nodump=INNODB_BUFFER_POOL

The kernel of the Asus-Merlin firmware is 4.1.51. The installation of MariaDB through Entware worked after (opkg list | grep mariadb | awk '

{print $ 1}

' | xargs opkg install)

Comment by Abel Torre [ 2020-02-22 ]

The problem appears when updating from 10.2.26 to 10.4.10

Comment by Marko Mäkelä [ 2020-03-09 ]

I do not think that the warning message should prevent the server from starting up or shutting down.

I see 3 messages for both types of calls, corresponding to the 3 data structures being allocated via those interfaces. Which kernel version are you using? A Linux kernel bug fix related to the calls and huge pages was mentioned in MDEV-10814.

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