Error after upgrading to MariaDB 10.11.12

[gregarios]

Here is what I get for output:

`>> MySQLTuner 2.6.2
* Jean-Marie Renouard jmrenouard@gmail.com
* Major Hayden major@mhtx.net

Bug reports, feature requests, and downloads at http://mysqltuner.pl/
Run with '--help' for additional options and output filtering

ℹ Skipped version check for MySQLTuner script
✘ Failed to execute: SHOW REPLICAS\G
✘ FAIL Execute SQL / return code: 256
✔ Operating on 64-bit architecture

-------- Storage Engine Statistics -----------------------------------------------------------------
ℹ Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
ℹ Data in InnoDB tables: 334.1M (Tables: 822)
ℹ Data in Aria tables: 32.0K (Tables: 1)
✔ Total fragmented tables: 0

✔ Currently running supported MySQL version 10.11.12-MariaDB

-------- Log file Recommendations ------------------------------------------------------------------
✘ Log file doesn't exist

-------- Analysis Performance Metrics --------------------------------------------------------------
ℹ innodb_stats_on_metadata: OFF
✔ No stat updates during querying INFORMATION_SCHEMA.

-------- Views Metrics -----------------------------------------------------------------------------

-------- Triggers Metrics --------------------------------------------------------------------------

-------- Routines Metrics --------------------------------------------------------------------------

-------- Security Recommendations ------------------------------------------------------------------
ℹ MariaDB Server - 10.11.12-MariaDB
ℹ Skipped due to unsupported feature for MySQL 8.0+

-------- CVE Security Recommendations --------------------------------------------------------------
ℹ Skipped due to --cvefile option undefined

-------- Performance Metrics -----------------------------------------------------------------------
ℹ Up for: 6h 26m 24s (799K q [34.477 qps], 6K conn, TX: 10G, RX: 485M)
ℹ Reads / Writes: 91% / 9%
ℹ Binary logging is disabled
ℹ Physical Memory : 7.5G
ℹ Max MySQL memory : 924.8M
ℹ Other process memory: 0B
ℹ Total buffers: 557.0M global + 9.9M per thread (37 max threads)
ℹ Performance_schema Max memory usage: 0B
ℹ Galera GCache Max memory usage: 0B
✔ Maximum reached memory usage: 656.4M (8.53% of installed RAM)
✔ Maximum possible memory usage: 924.8M (12.01% of installed RAM)
✔ Overall possible memory usage with other process is compatible with memory available
✔ Slow queries: 0% (0/799K)
✔ Highest usage of available connections: 27% (10/37)
✔ Aborted connections: 0.00% (0/6233)
ℹ Skipped name resolution test due to skip_networking=ON in system variables.
✔ Query cache is disabled by default due to mutex contention on multiprocessor machines.
✔ Sorts requiring temporary tables: 0% (0 temp sorts / 103K sorts)
✘ Joins performed without indexes: 771
✔ Temporary tables created on disk: 22% (19K on disk / 84K total)
✔ Thread cache hit rate: 99% (10 created / 6K connections)
✔ Table cache hit rate: 99% (995K hits / 999K requests)
✔ table_definition_cache (1400) is greater than number of tables (1114)
✔ Open file limit used: 0% (60/32K)
✔ Table locks acquired immediately: 100% (1K immediate / 1K locks)

-------- Performance schema ------------------------------------------------------------------------
✘ Performance_schema should be activated.
ℹ Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
ℹ ThreadPool stat is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
ℹ General MyIsam metrics:
ℹ +-- Total MyISAM Tables : 0
ℹ +-- Total MyISAM indexes : 0B
ℹ +-- KB Size :1.0M
ℹ +-- KB Used Size :194.0K
ℹ +-- KB used :18.9%
ℹ +-- Read KB hit rate: 0% (0 cached / 0 reads)
ℹ +-- Write KB hit rate: 0% (0 cached / 0 writes)
ℹ No MyISAM table(s) detected ....

-------- InnoDB Metrics ----------------------------------------------------------------------------
ℹ InnoDB is enabled.
✔ InnoDB File per table is activated
✔ InnoDB Buffer Pool size ( 384.0M ) under limit for 64 bits architecture: (17179869184.0G )
✔ InnoDB buffer pool / data size: 384.0M / 334.1M
✔ Ratio InnoDB log file size / InnoDB Buffer pool size: 96.0M * 1/384.0M should be equal to 25%
Illegal division by zero at /home/pcs_mysqltuner.pl line 6568 (#1)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.

Uncaught exception from user code:
Illegal division by zero at /home/pcs_mysqltuner.pl line 6568.
main::mysql_innodb() called at /home/pcs_mysqltuner.pl line 7435`

[jadeops]

same error after upgrading to mariadb 11.4.6

Illegal division by zero at mysqltuner.pl line 6569 (#1)
    (F) You tried to divide a number by 0.  Either something was wrong in
    your logic, or you need to put a conditional in to guard against
    meaningless input.
    
Uncaught exception from user code:
	Illegal division by zero at mysqltuner.pl line 6569.
	main::mysql_innodb() called at mysqltuner.pl line 7436

[jadeops]

https://mariadb.com/kb/en/innodb-system-variables/#innodb_buffer_pool_chunk_size

seems like it shows up as 0 since new release

SHOW VARIABLES LIKE 'innodb_buffer_pool_chunk_size';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| innodb_buffer_pool_chunk_size | 0     |
+-------------------------------+-------+
1 row in set (0.001 sec)

[tunjic]

Confirmed here as well on MySQLTuner 1.8.3 - with Mariadb 10.11.12

Illegal division by zero at /usr/bin/mysqltuner line 5913 (#1)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.

Uncaught exception from user code:
Illegal division by zero at /usr/bin/mysqltuner line 5913.
main::mysql_innodb() called at /usr/bin/mysqltuner line 6577

[juceda]

Me too with latest master from github:

Illegal division by zero at mysqltuner.pl line 6568 (#1)
(F) You tried to divide a number by 0. Either something was wrong in
your logic, or you need to put a conditional in to guard against
meaningless input.

Uncaught exception from user code:
Illegal division by zero at mysqltuner.pl line 6568.
main::mysql_innodb() called at mysqltuner.pl line 7435

---

My MariaDB Version:
mariadb Ver 15.1 Distrib 10.11.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

[jacksonpietro]

Uncaught exception from user code:
Illegal division by zero at mysqltuner.pl line 6568.
main::mysql_innodb() called at mysqltuner.pl line 7435

[JaxxOlly]

This is due to Mariadb using autoscaling (Setting values to 0) I have modified this to check for 0, and if 0 will skip the calculations for the settings.

# InnoDB Used Buffer Pool Size vs CHUNK size
   if ( !defined($myvar{'innodb_buffer_pool_chunk_size'}) || 
     $myvar{'innodb_buffer_pool_chunk_size'} == 0 || 
     !defined($myvar{'innodb_buffer_pool_size'}) || 
     $myvar{'innodb_buffer_pool_size'} == 0 || 
     !defined($myvar{'innodb_buffer_pool_instances'}) || 
     $myvar{'innodb_buffer_pool_instances'} == 0 ) {

    badprint "Cannot calculate InnoDB Buffer Pool Chunk breakdown due to missing or zero values:";
    
    infoprint " - innodb_buffer_pool_size: " . 
        (defined $myvar{'innodb_buffer_pool_size'} ? $myvar{'innodb_buffer_pool_size'} : "undefined");
    infoprint " - innodb_buffer_pool_chunk_size: " . 
        (defined $myvar{'innodb_buffer_pool_chunk_size'} ? $myvar{'innodb_buffer_pool_chunk_size'} : "undefined");
    infoprint " - innodb_buffer_pool_instances: " . 
        (defined $myvar{'innodb_buffer_pool_instances'} ? $myvar{'innodb_buffer_pool_instances'} : "undefined");

} else {
    my $num_chunks = int($myvar{'innodb_buffer_pool_size'} / $myvar{'innodb_buffer_pool_chunk_size'});
    infoprint "Number of InnoDB Buffer Pool Chunk: $num_chunks for " 
        . $myvar{'innodb_buffer_pool_instances'} . " Buffer Pool Instance(s)";

    my $expected_size = int($myvar{'innodb_buffer_pool_chunk_size'}) * 
                        int($myvar{'innodb_buffer_pool_instances'});

    if (int($myvar{'innodb_buffer_pool_size'}) % $expected_size == 0) {
        goodprint "Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances";
    } else {
        badprint "Innodb_buffer_pool_size not aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances";

        push(@adjvars, 
            "innodb_buffer_pool_size must always be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances"
        );
    }
}

[Berttas]

This is due to Mariadb using autoscaling (Setting values to 0) I have modified this to check for 0, and if 0 will skip the calculations for the settings.

# InnoDB Used Buffer Pool Size vs CHUNK size
   if ( !defined($myvar{'innodb_buffer_pool_chunk_size'}) || 
     $myvar{'innodb_buffer_pool_chunk_size'} == 0 || 
     !defined($myvar{'innodb_buffer_pool_size'}) || 
     $myvar{'innodb_buffer_pool_size'} == 0 || 
     !defined($myvar{'innodb_buffer_pool_instances'}) || 
     $myvar{'innodb_buffer_pool_instances'} == 0 ) {

    badprint "Cannot calculate InnoDB Buffer Pool Chunk breakdown due to missing or zero values:";
    
    infoprint " - innodb_buffer_pool_size: " . 
        (defined $myvar{'innodb_buffer_pool_size'} ? $myvar{'innodb_buffer_pool_size'} : "undefined");
    infoprint " - innodb_buffer_pool_chunk_size: " . 
        (defined $myvar{'innodb_buffer_pool_chunk_size'} ? $myvar{'innodb_buffer_pool_chunk_size'} : "undefined");
    infoprint " - innodb_buffer_pool_instances: " . 
        (defined $myvar{'innodb_buffer_pool_instances'} ? $myvar{'innodb_buffer_pool_instances'} : "undefined");

} else {
    my $num_chunks = int($myvar{'innodb_buffer_pool_size'} / $myvar{'innodb_buffer_pool_chunk_size'});
    infoprint "Number of InnoDB Buffer Pool Chunk: $num_chunks for " 
        . $myvar{'innodb_buffer_pool_instances'} . " Buffer Pool Instance(s)";

    my $expected_size = int($myvar{'innodb_buffer_pool_chunk_size'}) * 
                        int($myvar{'innodb_buffer_pool_instances'});

    if (int($myvar{'innodb_buffer_pool_size'}) % $expected_size == 0) {
        goodprint "Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances";
    } else {
        badprint "Innodb_buffer_pool_size not aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances";

        push(@adjvars, 
            "innodb_buffer_pool_size must always be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances"
        );
    }
}

[Berttas]

Yes that works for me with the code you gave :)