[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