Opened 16 months ago
Last modified 16 months ago
#58559 new defect (bug)
Database error bug in wordpress current version
Reported by: | zoddshop63 | Owned by: | |
---|---|---|---|
Milestone: | Awaiting Review | Priority: | normal |
Severity: | normal | Version: | |
Component: | Database | Keywords: | |
Focuses: | Cc: |
Description (last modified by )
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)
Note: See
TracTickets for help on using
tickets.
And yes I have disabled all plugins and reinstalled wordpress.