[wp-trac] [WordPress Trac] #41302: WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out (was: Wordpress not stopping queries which have reached limit and preventing users to load wordpress until query timesout)

[WordPress Trac]

#41302: WordPress not stopping queries which have reached limit and preventing
users to load WordPress until query times out
--------------------------+------------------------------
 Reporter:  juslintek     |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.8
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:  performance
--------------------------+------------------------------
Description changed by SergeyBiryukov:

Old description:

> [[Image(Pasted image at 2017_07_13 10_14 AM.png)]]
>
> 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.

New description:

 [[Image(Pasted image at 2017_07_13 10_14 AM.png)]]

 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.

--

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