Details
-
Bug
-
Status: Stalled (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5
-
None
Description
rocksdb.write_sync fails regularly on amd64-windows-packages
rocksdb.write_sync 'write_prepared' w30 [ fail ]
|
Test ended at 2024-04-09 05:07:46
|
|
|
CURRENT_TEST: rocksdb.write_sync
|
mysqltest: In included file "./include/wait_for_status_var.inc":
|
included from D:\Buildbot\amd64-windows-packages\build\storage\rocksdb\mysql-test\rocksdb\t\write_sync.test at line 33:
|
At line 88: Explicit --die command executed
|
e.g.
https://buildbot.mariadb.org/#/builders/239/builds/19608
Attachments
Issue Links
- is part of
-
MDEV-33073 always green buildbot
-
- Stalled
-
Activity
All failures are on windows. There is one on amd64-debian-12-rocksdb but it has failed in a different way.
It is a funny host, too, where it fails. The host seems to have problems with IO. mandatory builder amd64-windows used to be on that host, until one day suddenly it became very slow, so amd64-windows had to move to another machine.
wlad, thanks for the note.. host-specific issues could add another level of complexity...
Pushed this so the priority of this MDEV can be lowered:
commit f90fcefdb2eada4e8c507eefc5d5e620b34c94d2
|
Author: Sergei Petrunia <sergey@mariadb.com>
|
Date: Mon May 6 13:31:31 2024 +0300
|
|
|
MDEV-33866: rocksdb.write_sync fails on windows ... : Disable it
|
Always fails on the same line:
select variable_value into @a from information_schema.global_status where variable_name='rocksdb_wal_synced';SET GLOBAL rocksdb_flush_log_at_trx_commit=2;insert aaa(id, i) values(5,1);let $status_var=rocksdb_wal_synced;let $status_var_value=`select @a+1`;source include/wait_for_status_var.inc;Here, we
and we miss this. The test failures eventually show much larger values:
https://buildbot.mariadb.org/cr/?branch=&revision=&platform=&dt=&bbnum=&typ=&info=&test_name=rocksdb.write_sync&test_variant=&info_text=&failure_text=&limit=50#
**** ERROR: failed while waiting for '' 'rocksdb_wal_synced' = '9' ****Rocksdb_wal_synced 85**** ERROR: failed while waiting for '' 'rocksdb_wal_synced' = '10' ****Rocksdb_wal_synced 93**** ERROR: failed while waiting for '' 'rocksdb_wal_synced' = '9' ****Rocksdb_wal_synced 92**** ERROR: failed while waiting for '' 'rocksdb_wal_synced' = '9' ****Rocksdb_wal_synced 100I am not sure who does the extra syncs...
rocksdb_flush_log_at_trx_commit=2 means "sync every second". This does NOT mean an idle server will still perform a sync every second, does it?