[MDEV-11454] quick start/stop with innodb_buffer_pool_dump_pct < 100 results in suboptimal dump file - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.10
Fix Version/s: 10.2.5, 10.3.0
Component/s: Storage Engine - InnoDB
Labels:
- contribution
- foundation

Description

With innodb_buffer_pool_dump_pct say 25% (the default since 10.2.2), a server started will restore 25% of the buffer pool size with the expectation that over time the rest of the buffer pool will be populated. Then on shutdown 25% will be saved.

If a server is started and then is shutdown a) without much activity occurring b) is started as a hot spare and shutdown before being used, then 6.25% (25% of 25%) of the buffer pool is saved.

Proposed solution:

Rather than innodb_buffer_pool_dump_pct referring to the percentage of hot data in the buffer pool, it refers to the entire buffer pool size. This means that a completed load followed by a shutdown will write the exact same data.

This will generate bigger dump files for users who don't have a full innodb_buffer_pool however a realistic scenario is a buffer pool should be completely used.

Attachments

Activity

Ascending order - Click to sort in descending order

View 5 older comments

Daniel Black added a comment - 2017-03-01 02:50

http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar-debug/builds/2193/steps/test/logs/mysqld.1.err.3 shows 128 pages dumped. Not sure why only 124 pages where loaded yet.

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/7238/steps/test_3/logs/mysqld.1.err.2 shows only 127 pages dumped so that needs to be fixed too.

Thanks marko. I am still looking at this.

Daniel Black added a comment - 2017-03-01 02:50 http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar-debug/builds/2193/steps/test/logs/mysqld.1.err.3 shows 128 pages dumped. Not sure why only 124 pages where loaded yet. http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/7238/steps/test_3/logs/mysqld.1.err.2 shows only 127 pages dumped so that needs to be fixed too. Thanks marko . I am still looking at this.

Marko Mäkelä added a comment - 2021-09-07 07:11

danblack, are you still looking at this? I noticed that the test is still disabled, while waiting for the results for a ~~MDEV-26547~~ fixup, to address a failure of the test sys_vars.innodb_buffer_pool_dump_abort_loads.

Marko Mäkelä added a comment - 2021-09-07 07:11 danblack , are you still looking at this? I noticed that the test is still disabled, while waiting for the results for a MDEV-26547 fixup , to address a failure of the test sys_vars.innodb_buffer_pool_dump_abort_loads .

Daniel Black added a comment - 2021-09-07 09:28

Obviously haven't for a while. Maybe some of the page/chunk sizing it has magicly made it better. I'll take a look tomorrow.

Daniel Black added a comment - 2021-09-07 09:28 Obviously haven't for a while. Maybe some of the page/chunk sizing it has magicly made it better. I'll take a look tomorrow.

Daniel Black added a comment - 2022-02-09 01:55

10.2 still varying results

innodb_buffer_pool_dump_pct_function - 10.2.43-MariaDB
- SSL connections supported
- binaries built with wsrep patch
Collecting tests...
- sys_vars.innodb_buffer_pool_dump_pct_function wil be run although it's been disabled
due to 'MDEV-11454 follow-up needed (unstable)'
Installing system database...

==============================================================================

TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5225
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ]
Test ended at 2022-02-09 12:44:12

CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
--- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100
+++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:12.631033650 +1100
@@ -34,11 +34,11 @@
# Restart server
SET GLOBAL innodb_buffer_pool_load_now=1;
# Case 1: Limit from innodb_buffer_pool_dump_pct
-SELECT 256 as 'Previous pool pages',
+SELECT 464 as 'Previous pool pages',
ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
-128 as 'Pages saved';
+127 as 'Pages saved';
Previous pool pages Limit Pages saved
-256 128 128
+464 128 127
# Case 2: blog_pages is the minimum.
# load buffer pool with entire table.
select * from t1;

mysqltest: Result content mismatch

- saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/'
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5109
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ]
Test ended at 2022-02-09 12:44:23

CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
--- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100
+++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:23.694048987 +1100
@@ -34,11 +34,11 @@
# Restart server
SET GLOBAL innodb_buffer_pool_load_now=1;
# Case 1: Limit from innodb_buffer_pool_dump_pct
-SELECT 256 as 'Previous pool pages',
+SELECT 460 as 'Previous pool pages',
ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
-128 as 'Pages saved';
+125 as 'Pages saved';
Previous pool pages Limit Pages saved
-256 128 128
+460 128 125
# Case 2: blog_pages is the minimum.
# load buffer pool with entire table.
select * from t1;

mysqltest: Result content mismatch

- saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/'
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5096
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ]
Test ended at 2022-02-09 12:44:34

CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
--- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100
+++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:34.567064059 +1100
@@ -34,11 +34,11 @@
# Restart server
SET GLOBAL innodb_buffer_pool_load_now=1;
# Case 1: Limit from innodb_buffer_pool_dump_pct
-SELECT 256 as 'Previous pool pages',
+SELECT 467 as 'Previous pool pages',
ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
-128 as 'Pages saved';
+127 as 'Pages saved';
Previous pool pages Limit Pages saved
-256 128 128
+467 128 127
# Case 2: blog_pages is the minimum.
# load buffer pool with entire table.
select * from t1;

mysqltest: Result content mismatch

- saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/'
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ]
Test ended at 2022-02-09 12:44:40

CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
--- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100
+++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:40.148071797 +1100
@@ -36,9 +36,9 @@
# Case 1: Limit from innodb_buffer_pool_dump_pct
SELECT 256 as 'Previous pool pages',
ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
-128 as 'Pages saved';
+127 as 'Pages saved';
Previous pool pages Limit Pages saved
-256 128 128
+256 128 127
# Case 2: blog_pages is the minimum.
# load buffer pool with entire table.
select * from t1;

mysqltest: Result content mismatch

- saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/'
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5124
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ]
Test ended at 2022-02-09 12:44:51

CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
--- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100
+++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:51.029086880 +1100
@@ -34,11 +34,11 @@
# Restart server
SET GLOBAL innodb_buffer_pool_load_now=1;
# Case 1: Limit from innodb_buffer_pool_dump_pct
-SELECT 256 as 'Previous pool pages',
+SELECT 465 as 'Previous pool pages',
ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
-128 as 'Pages saved';
+127 as 'Pages saved';
Previous pool pages Limit Pages saved
-256 128 128
+465 128 127
# Case 2: blog_pages is the minimum.
# load buffer pool with entire table.
select * from t1;

mysqltest: Result content mismatch

- saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/'
sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ]
Test ended at 2022-02-09 12:44:56

CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
--- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100
+++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:56.782094854 +1100
@@ -36,9 +36,9 @@
# Case 1: Limit from innodb_buffer_pool_dump_pct
SELECT 256 as 'Previous pool pages',
ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
-128 as 'Pages saved';
+127 as 'Pages saved';
Previous pool pages Limit Pages saved
-256 128 128
+256 128 127
# Case 2: blog_pages is the minimum.
# load buffer pool with entire table.
select * from t1;

mysqltest: Result content mismatch

- saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/'
--------------------------------------------------------------------------
The servers were restarted 1 times
Spent 20.554 of 64 seconds executing testcases

Completed: Failed 6/10 tests, 40.00% were successful.

Failing test(s): sys_vars.innodb_buffer_pool_dump_pct_function

select count from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' is always empty resulting in syntax error. Manual testing doesn't exhibit same results.

10.5.14 always failing (5/5)
CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function
mysqltest: At line 70: query 'SELECT $blob_pages as 'Previous pool pages',
ROUND($PCT / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit',
$loaded_blob_pages as 'Pages saved'' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as 'Pages saved'' at line 3

Daniel Black added a comment - 2022-02-09 01:55 10.2 still varying results innodb_buffer_pool_dump_pct_function - 10.2.43-MariaDB - SSL connections supported - binaries built with wsrep patch Collecting tests... - sys_vars.innodb_buffer_pool_dump_pct_function wil be run although it's been disabled due to 'MDEV-11454 follow-up needed (unstable)' Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5225 sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ] Test ended at 2022-02-09 12:44:12 CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function --- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100 +++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:12.631033650 +1100 @@ -34,11 +34,11 @@ # Restart server SET GLOBAL innodb_buffer_pool_load_now=1; # Case 1: Limit from innodb_buffer_pool_dump_pct -SELECT 256 as 'Previous pool pages', +SELECT 464 as 'Previous pool pages', ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', -128 as 'Pages saved'; +127 as 'Pages saved'; Previous pool pages Limit Pages saved -256 128 128 +464 128 127 # Case 2: blog_pages is the minimum. # load buffer pool with entire table. select * from t1; mysqltest: Result content mismatch - saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5109 sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ] Test ended at 2022-02-09 12:44:23 CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function --- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100 +++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:23.694048987 +1100 @@ -34,11 +34,11 @@ # Restart server SET GLOBAL innodb_buffer_pool_load_now=1; # Case 1: Limit from innodb_buffer_pool_dump_pct -SELECT 256 as 'Previous pool pages', +SELECT 460 as 'Previous pool pages', ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', -128 as 'Pages saved'; +125 as 'Pages saved'; Previous pool pages Limit Pages saved -256 128 128 +460 128 125 # Case 2: blog_pages is the minimum. # load buffer pool with entire table. select * from t1; mysqltest: Result content mismatch - saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5096 sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ] Test ended at 2022-02-09 12:44:34 CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function --- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100 +++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:34.567064059 +1100 @@ -34,11 +34,11 @@ # Restart server SET GLOBAL innodb_buffer_pool_load_now=1; # Case 1: Limit from innodb_buffer_pool_dump_pct -SELECT 256 as 'Previous pool pages', +SELECT 467 as 'Previous pool pages', ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', -128 as 'Pages saved'; +127 as 'Pages saved'; Previous pool pages Limit Pages saved -256 128 128 +467 128 127 # Case 2: blog_pages is the minimum. # load buffer pool with entire table. select * from t1; mysqltest: Result content mismatch - saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ] Test ended at 2022-02-09 12:44:40 CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function --- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100 +++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:40.148071797 +1100 @@ -36,9 +36,9 @@ # Case 1: Limit from innodb_buffer_pool_dump_pct SELECT 256 as 'Previous pool pages', ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', -128 as 'Pages saved'; +127 as 'Pages saved'; Previous pool pages Limit Pages saved -256 128 128 +256 128 127 # Case 2: blog_pages is the minimum. # load buffer pool with entire table. select * from t1; mysqltest: Result content mismatch - saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ pass ] 5124 sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ] Test ended at 2022-02-09 12:44:51 CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function --- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100 +++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:51.029086880 +1100 @@ -34,11 +34,11 @@ # Restart server SET GLOBAL innodb_buffer_pool_load_now=1; # Case 1: Limit from innodb_buffer_pool_dump_pct -SELECT 256 as 'Previous pool pages', +SELECT 465 as 'Previous pool pages', ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', -128 as 'Pages saved'; +127 as 'Pages saved'; Previous pool pages Limit Pages saved -256 128 128 +465 128 127 # Case 2: blog_pages is the minimum. # load buffer pool with entire table. select * from t1; mysqltest: Result content mismatch - saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' sys_vars.innodb_buffer_pool_dump_pct_function 'innodb' [ fail ] Test ended at 2022-02-09 12:44:56 CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function --- /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.result 2020-10-21 11:53:36.123736898 +1100 +++ /home/dan/repos/mariadb-server-10.2_second/mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_pct_function.reject 2022-02-09 12:44:56.782094854 +1100 @@ -36,9 +36,9 @@ # Case 1: Limit from innodb_buffer_pool_dump_pct SELECT 256 as 'Previous pool pages', ROUND(25 / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', -128 as 'Pages saved'; +127 as 'Pages saved'; Previous pool pages Limit Pages saved -256 128 128 +256 128 127 # Case 2: blog_pages is the minimum. # load buffer pool with entire table. select * from t1; mysqltest: Result content mismatch - saving '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' to '/home/dan/repos/build-mariadb-server-10.2_second/mysql-test/var/log/sys_vars.innodb_buffer_pool_dump_pct_function-innodb/' -------------------------------------------------------------------------- The servers were restarted 1 times Spent 20.554 of 64 seconds executing testcases Completed: Failed 6/10 tests, 40.00% were successful. Failing test(s): sys_vars.innodb_buffer_pool_dump_pct_function select count from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' is always empty resulting in syntax error. Manual testing doesn't exhibit same results. 10.5.14 always failing (5/5) CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_function mysqltest: At line 70: query 'SELECT $blob_pages as 'Previous pool pages', ROUND($PCT / 100 * @@innodb_buffer_pool_size / @@innodb_page_size) as 'Limit', $loaded_blob_pages as 'Pages saved'' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as 'Pages saved'' at line 3

Daniel Black added a comment - 2024-07-23 02:02

fixed per https://github.com/MariaDB/server/commit/342b48b7b1cf9c5ed3db04d5b7abff335d6e3090

Daniel Black added a comment - 2024-07-23 02:02 fixed per https://github.com/MariaDB/server/commit/342b48b7b1cf9c5ed3db04d5b7abff335d6e3090

People

Assignee:: Daniel Black

Reporter:: Daniel Black

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2016-12-02 04:04

Updated:: 2024-07-23 02:02

Resolved:: 2024-07-23 02:02

Git Integration

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

MariaDB Server