Make WordPress Core

Opened 13 months ago

Last modified 13 months ago

#58559 new defect (bug)

Database error bug in wordpress current version

Reported by: zoddshop63's profile zoddshop63 Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version:
Component: Database Keywords:
Focuses: Cc:

Description (last modified by sabernhardt)

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.

Change History (2)

#1 @zoddshop63
13 months ago

And yes I have disabled all plugins and reinstalled wordpress.

#2 @sabernhardt
13 months ago

  • Component changed from General to Database
  • Description modified (diff)
Note: See TracTickets for help on using tickets.