WordPress.org

Make WordPress Core

Opened 4 months ago

Last modified 4 months ago

#41302 new defect (bug)

WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out

Reported by: juslintek Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 4.8
Component: Database Keywords:
Focuses: performance Cc:

Description (last modified by SergeyBiryukov)

No image "Pasted image at 2017_07_13 10_14 AM.png" attached to Ticket #41302

I have problem with WordPress mysql max_questions=600, max_updates=600 limit

User 'id1561843_wp_ac6601cd835d82e22d89d11a3ea228a0' has exceeded the 'max_queries_per_hour' resource (current value: 500)

After

wp-db.php:830

comes timeout.

I suspect that that after limit is reached

public function set_charset( $dbh, $charset = null, $collate = null ) {

throws and error.

After that WordPress gets stuck on loading something. And you cannot make any other queries on other browser windows.

Proper script should just kill the query after error that limit has been exceeded.

Change History (4)

#1 @SergeyBiryukov
4 months ago

  • Component changed from General to Database

#2 @SergeyBiryukov
4 months ago

  • Description modified (diff)
  • Summary changed from Wordpress not stopping queries which have reached limit and preventing users to load wordpress until query timesout to WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out

This ticket was mentioned in Slack in #core by sergey. View the logs.


4 months ago

#4 @ocean90
4 months ago

#41321 was marked as a duplicate.

Note: See TracTickets for help on using tickets.