Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
11.8
-
None
-
None
Description
After a upload of 11.8.5 to Debian I noticed the ppc build failed with this result mismatch:
main.analyze_stmt_prefetch_count w4 [ fail ]
|
Test ended at 2025-12-08 13:00:14
|
|
|
CURRENT_TEST: main.analyze_stmt_prefetch_count
|
--- /build/reproducible-path/mariadb-11.8.5/mysql-test/main/analyze_stmt_prefetch_count.result 2025-11-13 08:45:29.000000000 +0000
|
+++ /build/reproducible-path/mariadb-11.8.5/mysql-test/main/analyze_stmt_prefetch_count.reject 2025-12-08 13:00:13.370821625 +0000
|
@@ -37,12 +37,12 @@
|
set @high_ok= @total_read < @pages_accessed*1.50;
|
select @low_ok, @high_ok;
|
@low_ok @high_ok
|
-1 1
|
+1 0
|
select
|
if(@low_ok and @high_ok,0,@pages_accessed) unexpected_accessed,
|
if(@low_ok and @high_ok,0,@total_read) unexpected_read;
|
unexpected_accessed unexpected_read
|
-0 0
|
+1174 1823
|
set @innodb_pages_read1=
|
(select variable_value
|
from information_schema.session_status
|
|
|
Result length mismatch
|
Later in the same run a retry passed, so it was sporadic:
main.analyze_stmt_prefetch_count w4 [ retry-pass ] 3274
|
Reporting this as a data point in case others see this pattern repeat.
Attachments
Issue Links
- relates to
-
MDEV-34190 ANALYZE: r_engine_stats shows unrealistically low pages_read_count
-
- Closed
-