Posts edit.php not paginating

[tgelles]

I'm running multisite and the /wp-admin/edit.php pagination feature for my posts is very buggy across my network.

I must refresh the page to see the full number of posts and pages of said posts. Or, the page count of posts shows random numbers (see below)

If pagination does load and when on /wp-admin/edit.php?paged=2, if attempt to click on the 'next page' arrow, it'll either go to page 3. But more often just takes me back to/wp-admin/edit.php?paged=1

I have the following plugins activated on my network.

Admin Menu Editor Pro
Admin Menu Tree Page View
Black Studio TinyMCE Widget
Comet Cache Pro
Email Post Changes
KSAS Global Function (code: ​https://github.com/ksascomm/plugin_global_functions)
KSAS Global Widgets (code: ​https://github.com/ksascomm/plugin_ksas_global_widgets)
miniOrange SSO using SAML 2.0
mobble
Plugin Activation Status
Post Thumbnail Editor
Quick Page/Post Redirect Plugin
Snapshot Pro
SSH SFTP Updater Support
User Switching
WordPress MU Domain Mapping
WP Security Audit Log

I've tried deactivating mostly all individually but the problem still happens.

I'm running WP 4.8.1 on PHP 5.6.26/RHEL release 6.9 (Santiago).

I have a feeling this is a server issue as it affects the core wp-admin/edit.php. Also it does not happen on my local (MAMP); and I have been deactivating plugins, checking themes, and removing any expires headers from the htaccess file to no avail.

However, I do not know enough about what WordPress is trying to do when paginating posts in edit.php that the server is not allowing it/causing the bug to appear every now and then.

Has anyone encountered this before? To repeat, this only happens for POSTS post type both in the admin (and then again on the index.php page), not pages or other custom post types.

(also, I opened, and then closed, a similar ticket a few days ago. I closed it because I wasnt sure if this was a bug or something the support forum could assist it. As it clearly affects a core component of wp-admin, and I just updated to 4.8.1, I think it's a bug)

[tgelles]

Sorry, forgot to mention two important technical specifications:

Running Apache 2.2.15 & mysql 5.5.5 (on a mariadb host)

[tgelles]

Bug is also now occurring for /wp-admin/network/users.php and most custom post types, like:

https://github.com/ksascomm/plugin_people_directory/blob/master/ksas-people-directory.php

[tgelles]

When inspecting element, here's the html for when the pagination works/appears and does not work/appear:

Working

<div class="tablenav-pages"><span class="displaying-num">489 items</span>
<span class="pagination-links"><span class="tablenav-pages-navspan" aria-hidden="true">«</span>
<span class="tablenav-pages-navspan" aria-hidden="true">‹</span>
<span class="paging-input"><label for="current-page-selector" class="screen-reader-text">Current Page</label><input class="current-page" id="current-page-selector" type="text" name="paged" value="1" size="2" aria-describedby="table-paging"><span class="tablenav-paging-text"> of <span class="total-pages">10</span></span></span>
<a class="next-page" href="https://krieger.jhu.edu/wp-admin/edit.php?paged=2"><span class="screen-reader-text">Next page</span><span aria-hidden="true">›</span></a>
<a class="last-page" href="https://krieger.jhu.edu/wp-admin/edit.php?paged=10"><span class="screen-reader-text">Last page</span><span aria-hidden="true">»</span></a></span></div>

Not Working

<div class="tablenav-pages one-page"><span class="displaying-num">3 items</span>
<span class="pagination-links"><span class="tablenav-pages-navspan" aria-hidden="true">«</span>
<span class="tablenav-pages-navspan" aria-hidden="true">‹</span>
<span class="paging-input"><label for="current-page-selector" class="screen-reader-text">Current Page</label><input class="current-page" id="current-page-selector" type="text" name="paged" value="1" size="1" aria-describedby="table-paging"><span class="tablenav-paging-text"> of <span class="total-pages">1</span></span></span>
<span class="tablenav-pages-navspan" aria-hidden="true">›</span>
<span class="tablenav-pages-navspan" aria-hidden="true">»</span></span></div>

[tgelles]

Issue resolved. Problem was the MaxScale database proxy on the MariaDB. Switching database host names solved problem.

[SergeyBiryukov]

Thanks for the follow-up!