[wp-trac] [WordPress Trac] #58559: Database error bug in wordpress current version

[WordPress Trac]

#58559: Database error bug in wordpress current version
--------------------------+------------------------------
 Reporter:  zoddshop63    |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by juzar):

 Hi @zoddshop63,

 Could you share a bit more about your environment?
 - MySQL/MariaDB version?
 - Approximate number of posts in your `wp_posts` table?
 - PHP version and `max_execution_time` setting?

 I tried reproducing this on the latest version of WordPress but was unable
 to.

 Regarding `SQL_CALC_FOUND_ROWS`: this function can become very slow on
 large sites with many posts. It has to count all matching rows before
 applying the `LIMIT`, which on a big table can take long enough for PHP to
 time out mid-query. This is a known limitation and there are existing
 discussions in core around making it more efficient.

 ---
 "For anyone landing here with the same issue: the "no quit sent" symptom
 typically points to PHP terminating the script before WordPress could
 close the MySQL connection — not a core bug. Also worth trying: swap
 `DB_HOST` in `wp-config.php` between `localhost` and `127.0.0.1` — if the
 errors stop, the issue is with your connection method."

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