[MDEV-13059] XtraDB hangs on Windows due to failing to release block->lock X-latch in innodb_read_only mode Created: 2017-06-12  Updated: 2017-06-14  Resolved: 2017-06-12

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - XtraDB
Affects Version/s: 10.0, 10.1
Fix Version/s: 10.1.25, 10.0.32

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: hang, xtradb
Environment:

Windows (x86, amd64)


Issue Links:
Relates
relates to MDEV-13039 innodb_fast_shutdown=0 may fail to pu... Closed
relates to MDEV-13057 innodb_read_only=1 should avoid creat... Closed

 Description   

The recently added test innodb.row_format_redundant hangs on XtraDB on Windows. InnoDB and other platforms than Windows seem to be fine.

Here is the problematic section:

SET GLOBAL innodb_fast_shutdown=0;
--let $restart_parameters = --innodb-read-only
--source include/restart_mysqld.inc
 
SELECT COUNT(*) FROM t1;

The query is blocked while trying to acquire an S-latch on a block->lock on a clustered index page. The X-latch was acquired by buf_page_init_for_read(), and normally it should be released by buf_page_io_complete(). Added debug output in that function confirms that the function was being invoked for some pages, but not this one.


Generated at Thu Feb 08 08:02:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.