[wp-trac] [WordPress Trac] #57943: Massive SQL statement shown in Dashboard WordPress Events and News. WordPress database error Got a packet bigger than 'max_allowed_packet'

WordPress Trac noreply at wordpress.org
Fri Mar 17 22:20:25 UTC 2023


#57943: Massive SQL statement shown in Dashboard WordPress Events and News.
WordPress database error Got a packet bigger than 'max_allowed_packet'
-------------------------------------------------+-------------------------
 Reporter:  ipajen                               |       Owner:  (none)
     Type:  defect (bug)                         |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
                                                 |  Review
Component:  Administration                       |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  has-testing-info needs-testing       |     Focuses:
  reporter-feedback                              |
-------------------------------------------------+-------------------------

Old description:

> === Bug Report
> Massive SQL statement shown in Dashboard WordPress Events and News.
> WordPress database error Got a packet bigger than 'max_allowed_packet'
>
> === Environment
> - OS: Windows 10
> - Server: Apache (WINNT)
> - PHP: 8.2.0
> - WordPress: 6.2-RC2
> - Browser: Edge
> - Theme: Twenty Ten 3.7
> - MU-PluginsNone activated
> - Plugins:
>   * WordPress Beta Tester 3.3.1
>   * WP SMS 6.1.1
>
> === Steps to Reproduce
> Not sure but maybe:
> 1. Debugging enabled.
>
> {{{
> define( 'WP_DEBUG', true);
> define( 'WP_DEBUG_LOG', true );
> define( 'WP_DEBUG_DISPLAY', true );
> }}}
>
> 2. Set max_allowed_packet to very low value.
> 3. GO to http://localhost/test/wp-admin/index.php
> x.  Bug occurs.
>
> === Expected Results
> 1.   WordPress Events and News should be shown.
> 2.   If failed a user friendly message shown in GUI
> 3.   Not to log 18 MB of errors.
>
> === Actual Results
> 1.   Massive SQL statement was shown
> 2.   User friendly error message was not shown in GUI
> 2.   Logging was made of 18MB
>
> Some few lines from the logfile.
>
> {{{
> 17-Mar-2023 18:13:23 UTC] WordPress database error Got a packet bigger
> than 'max_allowed_packet' bytes for query INSERT INTO `wp_options`
> (`option_name`, `option_value`, `autoload`) VALUES
> ('_transient_feed_d117b5738fbd35bd8c0391cda1f2b5d9',
> 'a:4:{s:5:\"child\";a:1:{s:0:\"\";a:1:{s:3:\"rss\";a:1:{i:0;a:6:{s:4:\"data\";s:3:\"\n\n\n\";s:7:\"attribs\";a:1:{s:0:\"\";a:1:{s:7:\"version\";s:3:\"2.0\";}}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:1:{s:7:\"channel\";a:1:{i:0;a:6:{s:4:\"data\";s:61:\"\n
> \n      \n      \n
> \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:5:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:16:\"WordPress
> Planet\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:28:\"http://planet.wordpress.org/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:8:\"language\";a:1:{i:0;a:5:{s:4:\"data\";s:2:\"en\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:47:\"WordPress
> Planet -
> http://planet.wordpress.org/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"item\";a:50:{i:0;a:6:{s:4:\"data\";s:13:\"\n
> \n      \n      \n      \n      \n
> \n\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:5:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:39:\"WordCamp
> Central: WordCamp Buffalo
> 2023\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"guid\";a:1:{i:0;a:5:{s:4:\"data\";s:39:\"https://central.wordcamp.org/?p=3163106\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:64:\"https://central.wordcamp.org/news/2023/03
> /wordcamp-
> buffalo-2023/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:1802:\"<a
> href=\"https://profiles.wordpress.org/empireoflight/\"><img
> /></a>WordCamp Buffalo 2023 logo. Design by Ben Dunkle.\n\n\n\n<p>Buffalo
> again will host the region’s WordCamp for bloggers and web designers and
> developers of all skill levels. Novices are very welcome. WordCamp
> Buffalo will be held Saturday, May 6, 2023.</p>\n\n\n\n<p>Registration
> opens at 8:00am. Sessions begin at 9 a.m. and continue through 5 p.m.
> This year’s WordCamp will be held at Ken-Ton Elmwood Commons, 3200
> Elmwood Ave Suite 110, Kenmore, NY 14217. Tickets are required in
> advance.</p>\n\n\n\n<p>The $25 ticket cost covers WordCamp Buffalo swag,
> morning coffee, lunch, and the evenings’s after-party food. Participants
> are strongly encouraged to bring their laptops or tablets. Ticket
> purchase and program details are available at <a
> href=\"https://buffalo.wordcamp.org/2023\">buffalo.wordcamp.org/2023</a>.
> The capacity for this event is about 120 people, so getting tickets early
> is advised.</p>\n\n\n\n<p>WordCamps are held worldwide, locally run and
> purposely at a low cost for accessibility to all. WordCamp Buffalo is
> dedicated to WordPress, blogging and web facility. WordCamps are
> sponsored by WordPress, the open-source, free, not-for-profit platform
> for individuals, groups and businesses to build their own blogs and
> websites. WordPress.org began in 2003. Its administrators call it the
> “largest self-hosted blogging tool in the world, used on millions of
> sites and seen by tens of millions of people every
> day.”</p>\n\n\n\n<p>Similar to previous years, Buffalo’s 2023 WordCamp
> will divide its workshops along two tracks, with sessions for every
> ability and level of use.</p>\n\n\n\n<p>Speakers will include WordPress
> users from Buffalo, Rochester, and beyond, with experience ranging from
> user/blogger to advanced developer.</p>\";s:7:\
> }}}
>
> If you need the full log, let me know but as I don't know what's included
> I don't want share in the public ticket.

New description:

 === Bug Report
 Massive SQL statement shown in Dashboard WordPress Events and News.
 WordPress database error Got a packet bigger than 'max_allowed_packet'

 === Environment
 - OS: Windows 10
 - Server: Apache (WINNT)
 - PHP: 8.2.0
 - WordPress: 6.2-RC2
 - Browser: Edge
 - Theme: Twenty Ten 3.7
 - MU-Plugins: None activated
 - Plugins:
   * WordPress Beta Tester 3.3.1
   * WP SMS 6.1.1

 === Steps to Reproduce
 Not sure but maybe:
 1. Debugging enabled.

 {{{
 define( 'WP_DEBUG', true);
 define( 'WP_DEBUG_LOG', true );
 define( 'WP_DEBUG_DISPLAY', true );
 }}}

 2. Set max_allowed_packet to very low value.
 3. GO to http://localhost/test/wp-admin/index.php
 x. 🐞 Bug occurs.

 === Expected Results
 1. ✅ WordPress Events and News should be shown.
 2. ✅ If failed a user friendly message shown in GUI
 3. ✅ Not to log 18 MB of errors.

 === Actual Results
 1. ❌ Massive SQL statement was shown
 2. ❌ User friendly error message was not shown in GUI
 2. ❌ Logging was made of 18MB

 Some few lines from the logfile.

 {{{
 17-Mar-2023 18:13:23 UTC] WordPress database error Got a packet bigger
 than 'max_allowed_packet' bytes for query

 INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`)
 VALUES
 (
 '_transient_feed_d117b5738fbd35bd8c0391cda1f2b5d9',
 'a:4:{s:5:\"child\";a:1:{s:0:\"\";a:1:{s:3:\"rss\";a:1:{i:0;a:6:s:4:\"data\";s:3:\"\n\n\n\";s:7:\"attribs\";a:1:{s:0:\"\";a:1:s:7:\"version\";s:3:\"2.0\";}}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:1:{s:7:\"channel\";a:1:{i:0;a:6:{s:4:\"data\";s:61:\"\n
 \n      \n
 \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\";s:7:\"attribs\";a:0:}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:1:{s:0:\"\";a:5:{s:5:\"title\";a:1:{i:0;a:5{s:4:\"data\";s:16:\"WordPress
 Planet\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:28:\"http://planet.wordpress.org/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:8:\"language\";a:1:{i:0;a:5:{s:4:\"data\";s:2:\"en\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:47:\"WordPress
 Planet -
 http://planet.wordpress.org/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"item\";a:50:{i:0;a:6:{s:4:\"data\";s:13:\"\n
 \n      \n      \n      \n      \n
 \n\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";s:5:\"child\";a:2:{s:0:\"\";a:5:{s:5:\"title\";a:1:{i:0;a:5:{s:4:\"data\";s:39:\"WordCamp
 Central: WordCamp Buffalo
 2023\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"guid\";a:1:{i:0;a:5:{s:4:\"data\";s:39:\"https://central.wordcamp.org/?p=3163106\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:4:\"link\";a:1:{i:0;a:5:{s:4:\"data\";s:64:\"https://central.wordcamp.org/news/2023/03
 /wordcamp-
 buffalo-2023/\";s:7:\"attribs\";a:0:{}s:8:\"xml_base\";s:0:\"\";s:17:\"xml_base_explicit\";b:0;s:8:\"xml_lang\";s:0:\"\";}}s:11:\"description\";a:1:{i:0;a:5:{s:4:\"data\";s:1802:\"<a
 href=\"https://profiles.wordpress.org/empireoflight/\"><img /></a>WordCamp
 Buffalo 2023 logo. Design by Ben Dunkle.\n\n\n\n<p>Buffalo again will host
 the region’s WordCamp for bloggers and web designers and developers of all
 skill levels. Novices are very welcome. WordCamp Buffalo will be held
 Saturday, May 6, 2023.</p>\n\n\n\n<p>Registration opens at 8:00am.
 Sessions begin at 9 a.m. and continue through 5 p.m. This year’s WordCamp
 will be held at Ken-Ton Elmwood Commons, 3200 Elmwood Ave Suite 110,
 Kenmore, NY 14217. Tickets are required in advance.</p>\n\n\n\n<p>The $25
 ticket cost covers WordCamp Buffalo swag, morning coffee, lunch, and the
 evenings’s after-party food. Participants are strongly encouraged to bring
 their laptops or tablets. Ticket purchase and program details are
 available at <a
 href=\"https://buffalo.wordcamp.org/2023\">buffalo.wordcamp.org/2023</a>.
 The capacity for this event is about 120 people, so getting tickets early
 is advised.</p>\n\n\n\n<p>WordCamps are held worldwide, locally run and
 purposely at a low cost for accessibility to all. WordCamp Buffalo is
 dedicated to WordPress, blogging and web facility. WordCamps are sponsored
 by WordPress, the open-source, free, not-for-profit platform for
 individuals, groups and businesses to build their own blogs and websites.
 WordPress.org began in 2003. Its administrators call it the “largest self-
 hosted blogging tool in the world, used on millions of sites and seen by
 tens of millions of people every day.”</p>\n\n\n\n<p>Similar to previous
 years, Buffalo’s 2023 WordCamp will divide its workshops along two tracks,
 with sessions for every ability and level of use.</p>\n\n\n\n<p>Speakers
 will include WordPress users from Buffalo, Rochester, and beyond, with
 experience ranging from user/blogger to advanced developer.</p>\";s:7:\
 }}}

 If you need the full log, let me know but as I don't know what's included
 I don't want share in the public ticket.

--

Comment (by costdev):

 Woops! Apparently I accidentally removed icons from the ticket
 description. Re-adding them and adding a couple of line breaks to the log.

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


More information about the wp-trac mailing list