[wp-trac] [WordPress Trac] #56841: WordPress pagination broken after updating to 6.0

[WordPress Trac]

#56841: WordPress pagination broken after updating to 6.0
-------------------------------------------------+-------------------------
 Reporter:  wpfed                                |       Owner:  (none)
     Type:  defect (bug)                         |      Status:  reopened
 Priority:  normal                               |   Milestone:
Component:  Posts, Post Types                    |     Version:  6.0
 Severity:  normal                               |  Resolution:
 Keywords:  has-screenshots needs-testing-info   |     Focuses:
  reporter-feedback                              |
-------------------------------------------------+-------------------------

Comment (by tadamarketing):

 @wpfed

 nginx: 1.25.1
 PHP: 7.4.33
 WP: 6.22
 MariaDB: 10.4.30-MariaDB-log
 Galera (wsrep provider version): 26.4.14(r06a0c285)
 ProxySQL: 2.5.2-217-g7f727b3

 Communication is going from WP (PHP) through ProxySQL to one of three
 MariaDB servers.

 Can you try to run SQL query on your DB and share the result?
 SHOW GLOBAL STATUS LIKE 'wsrep_provider_version';

 Do you now if your hosting provider gives you direct connection to DB or
 is proxied through Load Balancer such as HAProxy, ProxySQL?

 We diagnosed that the problem lies in that commit:
 https://github.com/WordPress/WordPress/commit/6f5f1875749a4425b3133ecddcc9366b432d06aa
 The change is maybe better for readability but quite annoying for database
 load balancer which cannot match configured rules to incoming queries
 properly.
 We also cannot trim white characters from queries.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/56841#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform