[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:  General       |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 2023-06-16  8:52:53 47 [Warning] Aborted connection 47 to db:
 'wordpressdb' user: 'wpuser' host: 'localhost' (Got an error reading
 communication packets)
 2023-06-16  8:52:53 46 [Warning] Aborted connection 46 to db:
 'wordpressdb' user: 'wpuser' host: 'localhost' (Got an error writing
 communication packets)

 I am constantly seeing read and write errors in database due to wordpress
 in the current version. I have been running wordpress for years.

 Upon checking the logs the read errors last query is
 SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
                                         FROM wp_posts
                                         WHERE 1=1  AND
 (wp_posts.post_author = 2) AND ((wp_posts.post_type = 'post' AND
 (wp_posts.post_status = 'publish')))

                                         ORDER BY wp_posts.post_date DESC
                                         LIMIT 0, 32

 The write error last query is

 SELECT DISTINCT post_author FROM wp_posts WHERE post_type = 'post' AND
 post_status = 'publish' LIMIT 2

 Both queries execute fine manually. The problem is not related to timeouts
 or max allowed packets as both execute manually.

 I noticed they are both increasing the aborted clients value in mysql.
 There is also no quit sent at the end of the mysql connections.

 It seems to be a bug within wordpress. I have literally gone through
 everything else possible to solve this bug.

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