WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for

  • Hi I am having a problem with my website we keep getting this error file that is approx 1gig each day
    The following is just a sample of the log file
    Phperrorlogs.txt
    sorry if I have put this in the wrong place, I am having trouble working out how to find a forum to post in.

    [13-Mar-2019 08:05:53 UTC] WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for query DELETE FROM as_wp_options WHERE option_name IN (‘wpsessionexpiresd86707fb1df932def631873b23ad4b4d’,’_wp_session_07fb1df932def631873b23ad4b4d’,’wpsessionexpires89450916babeafb4ea1d57676bbfb842′,’_wp_session_0916babeafb4ea1d57676bbfb842′,’wpsessionexpiresb2e8ae3198dd88ce172553541c9e7325′,’_wp_session_ae3198dd88ce172553541c9e7325′,’wpsessionexpires5de8bba9ccea1d6f20e04f982f2f4821′,’_wp_session_bba9ccea1d6f20e04f982f2f4821′,’wpsessionexpires2b6126924033b0521ab5c556f45396c8′,’_wp_session_26924033b0521ab5c556f45396c8′,’wpsessionexpiresc28724d4ea4edf38522e2ccef67d3f5c’,’_wp_session_24d4ea4edf38522e2ccef67d3f5c’,’wpsessionexpiresa6ac66bdc4cb1665ee9fcd015d24eb77′,’_wp_sessio

    Are you able to let me know why it is being created and how to stop it as its keeps filling up our website and we have to delete it each day.
    Thanks
    Rowena

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @rowm11,

    Can you run the following query on your database?

    SHOW VARIABLES LIKE 'max_allowed_packet';

    If you can, try setting this value to 1024000. You can do this by editing my.cnf and searching for max_allowed_packet=.

    Dave

    Thread Starter rowm11

    (@rowm11)

    Hi Dave
    Thanks for getting back to me i ran the query and the response I got was
    max_allowed_packet 33554432
    Is the value too high?
    Thanks
    Rowena

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for’ is closed to new replies.