Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21741

[Warning] InnoDB: Failed to set memory to MADV_DONTDUMP: Function not implemented

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.4.10
    • N/A
    • Storage Engine - InnoDB
    • RMerl/asuswrt through Entware

    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.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-10814 Feature request: Optionally exclude large buffers from core dumps

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            ATAGA Abel Torre created issue -
            ATAGA Abel Torre made changes -
            Field Original Value New Value
            Labels innodb
            alice Alice Sherepa made changes -
            ATAGA Abel Torre added a comment -

            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)

            ATAGA Abel Torre added a comment - 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)
            ATAGA Abel Torre added a comment -

            The problem appears when updating from 10.2.26 to 10.4.10

            ATAGA Abel Torre added a comment - The problem appears when updating from 10.2.26 to 10.4.10
            elenst Elena Stepanova made changes -
            Epic/Theme server
            elenst Elena Stepanova made changes -
            Priority Blocker [ 1 ] Critical [ 2 ]
            marko Marko Mäkelä added a comment -

            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.

            marko Marko Mäkelä added a comment - 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 .
            elenst Elena Stepanova made changes -
            Fix Version/s N/A [ 14700 ]
            Resolution Incomplete [ 4 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 104002 ] MariaDB v4 [ 157335 ]

            People

              Unassigned Unassigned
              ATAGA Abel Torre
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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