Reproduction Instructions
Following this, specifically, the Manual Installation instructions with up to date MediaWiki:
- Use PHP 7.3 and up to date MediaWiki (see version below)
- Choose MySQL as Database type in the Connect to database step
- Enter in applicable Database information
- See error in the final "Install" phase:
Creating main page with default content... failed Could not insert main page: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT GET_LOCK('<HASH>', 30) AS lockstatus Function: MediaWiki\Storage\PageEditStash::getAndWaitForStashValue Error: 1105 Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING (<MYSQL_ADDRESS>:<PORT>)
Some things that I've tried
I have also looked through Percona documentation and discussion boards but was not able to find a viable solution. Due to system restrictions, I am unable to set the pxc_strict_mode=PERMISSIVE as some forums seem to suggest.