Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5, 10.6
-
None
Description
MariaDB [(none)]> select @@innodb_buffer_pool_size, @@innodb_buffer_pool_chunk_size,@@innodb_page_size;
|
+---------------------------+---------------------------------+--------------------+
|
| @@innodb_buffer_pool_size | @@innodb_buffer_pool_chunk_size | @@innodb_page_size |
|
+---------------------------+---------------------------------+--------------------+
|
| 134217728 | 134217728 | 65536 |
|
+---------------------------+---------------------------------+--------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [(none)]> set global INNODB_BUFFER_POOL_SIZE = 20971520 - (1024*1024*1024);
|
Query OK, 0 rows affected, 1 warning (0.000 sec)
|
|
|
MariaDB [(none)]> show warnings;
|
+---------+------+------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------+
|
| Warning | 1292 | Truncated incorrect innodb_buffer_pool_size value: '-1052770304' |
|
+---------+------+------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [(none)]> select @@innodb_buffer_pool_size;
|
+---------------------------+
|
| @@innodb_buffer_pool_size |
|
+---------------------------+
|
| 134217728 |
|
+---------------------------+
|
1 row in set (0.000 sec)
|
|
10.6.21-MariaDB error log - less sane |
Version: '10.6.21-MariaDB' socket: '/tmp/build-mariadb-server-10.6-test.sock' port: 0 Source distribution
|
2025-01-20 23:04:33 3 [Note] InnoDB: Requested to resize buffer pool. (new size: -939524096 bytes)
|
2025-01-20 23:04:33 0 [Note] InnoDB: Resizing buffer pool from 134217728 to 18446744072770027520 (unit=134217728).
|
2025-01-20 23:04:33 0 [Note] InnoDB: Disabling adaptive hash index.
|
2025-01-20 23:04:33 0 [Note] InnoDB: Withdrawing blocks to be shrunken.
|
2025-01-20 23:04:33 0 [Note] InnoDB: Latching whole of buffer pool.
|
2025-01-20 23:04:33 0 [Note] InnoDB: buffer pool resizing with chunks 1 to 137438953465.
|
2025-01-20 23:05:32 0 [ERROR] InnoDB: Cannot allocate 6597069766344 bytes of memory after 60 retries over 60 seconds. OS error: Cannot allocate memory (12). Check if you should increase the swap file or ulimits of your operating system. Note that on most 32-bit computers the process memory space is limited to 2 GB or 4 GB.
|
2025-01-20 23:05:32 0 [ERROR] InnoDB: failed to allocate the chunk array.
|
2025-01-20 23:05:32 0 [Note] InnoDB: Completed to resize buffer pool from 134217728 to 18446744072770027520.
|
2025-01-20 23:05:32 0 [Note] InnoDB: Resizing buffer pool failed, finished resizing at 250120 23:05:32.
|