[wp-trac] [WordPress Trac] #41321: WP won't handle MySQL max_queries_per_hour limit on page load

[WordPress Trac]

#41321: WP won't handle MySQL max_queries_per_hour limit on page load
--------------------------+-----------------------------
 Reporter:  ledgr         |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.8
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 When mysql max_queries_per_hour is reached queries fail at the beginning
 of page load and WordPress fails with wrong(?) error output.


 {{{
 Warning: mysqli_set_charset(): Error executing query in /storage/ssd3/843
 /1561843/public_html/wp-includes/wp-db.php on line 824

 Warning: Cannot modify header information - headers already sent by
 (output
 started at /storage/ssd3/843/1561843/public_html/wp-includes/wp-
 db.php:824) in
 /storage/ssd3/843/1561843/public_html/wp-includes/pluggable.php on line
 1210
 }}}


 And this is example of error if limit is reached in the middle of page
 load:


 {{{
 WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded
 the 'max_queries_per_hour' resource (current value: 100)]
 SELECT option_value FROM wp_options WHERE option_name =
 '_site_transient_update_plugins' LIMIT 1

 WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded
 the 'max_queries_per_hour' resource (current value: 100)]
 SELECT option_value FROM wp_options WHERE option_name =
 '_site_transient_update_themes' LIMIT 1

 WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded
 the 'max_queries_per_hour' resource (current value: 100)]
 SELECT option_value FROM wp_options WHERE option_name =
 '_site_transient_update_core' LIMIT 1

 WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded
 the 'max_queries_per_hour' resource (current value: 100)]
 SELECT comment_approved, COUNT( * ) AS total FROM wp_comments GROUP BY
 comment_approved
 }}}

 To replicate do:


 {{{
 update mysql.user set max_questions=100, max_updates=100 where
 user='id1561843_wp_ac6601cd835';
 flush privileges;
 }}}

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