Skip to content

Unknown system variable 'innodb_version' since MariaDB 10.10 #18204

@gs71

Description

@gs71

Describe the bug

Starting from version 10.10 MariaDB removed the system variable 'innodb_version' (https://jira.mariadb.org/browse/MDEV-28554), so clicking on the 'Operations' link produces an error in the SQL errors log (if enabled):

ERROR 1193: Unknown system variable 'innodb_version' : SELECT @@innodb_version

To Reproduce

Steps to reproduce the behavior:

  1. Enable the SQL errors log in MariaDB ("sql_error_log_filename" variable)
    
  2. Click on 'Operations'
    
  3. See error in log file
    

Expected behavior

No error

Server configuration

  • Operating system: Linux
    
  • Web server: Apache
    
  • Database version: MariaDB **10.10.3**
    
  • PHP version: 8.1.10
    
  • phpMyAdmin version: 5.2
    

Client configuration

  • Browser: any
  • Operating system: any

Additional context

Bug can be fixed by modifying line 286 in file libraries/classes/Engines/Innodb.php

from:
return $GLOBALS['dbi']->fetchValue('SELECT @@innodb_version;') ?: '';

to:
return ($GLOBALS['dbi']->isMariaDB() && $GLOBALS['dbi']->getVersion() >= 101000) ? '' : ($GLOBALS['dbi']->fetchValue('SELECT @@innodb_version;') ? : '');

Metadata

Metadata

Assignees

Labels

BugA problem or regression with an existing featureaffects/5.2This issue or pull-request affects 5.2.x releases (and maybe further versions)affects/6.0This issue or pull-request affects 6.0.x releases (and maybe further versions)confirmed/5.2This issue is confirmed to be reproduced on 5.2 at the time this label was setconfirmed/6.0This issue is confirmed to be reproduced on 6.0 at the time this label was sethas-prAn issue that has a pull request pending that may fix this issue. The pull request may be incompletepatch

Type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions