[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]

#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:  General       |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 === 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.

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