Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. SFX_REQUEST table error running monthly kbdb update

    SFX_REQUEST table error running monthly kbdb update

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: SFX
    • Product Version: 3

    Description:
    When running a kbdb portion of the monthly update, I get the following error:
    ....
    mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `SFX_REQUEST` at row: 77456

    Revision::DeployKBDB::deploy: Failed deployment for sfxlcl3

    ERROR when trying: 'sh /exlibris/sfx_ver/sfx_version_3/tmp/rev-up-downloads/sfx-kbdb-update-...run --'. Exiting.
    ---

    Resolution:
    What happened was most likely a result of an excessively large SFX_REQUEST table – it occurred during the creation of a backup of the instance's database. Below are the instructions on how to resolve the problem - note that the example below is for the sfxlcl3 instance, but you can use them for any instance where the problem occured.

    1) log into mysql for sfxlcl3 :

    mysql -sfxlcl3 -psfxlcl3 sfxlcl3

    2) type:

    DELETE from SFX_REQUEST where LENGTH(SERIALIZED) > X;

    where X is the value shown for max_allowed_packet when you run: mysqldump –help

    3) remove the lock file for sfxlcl3 that was created during the backup (example for 20050901 kbupdate):

    rm -rf /exlibris/sfx_ver/sfx_version_3/tmp/.revision-lock-sfxlcl3-kbdb-20050901

    4) restart the update using the standard ./rev-up command

    We also suggest using server_admin_util to clean the SFX_REQUEST table (option 5 “Statistics” -> option 6 – Clear SFX_REQUEST )

    Additional Information

    SFX_REQUEST,table,kbdb,update,error


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • SFX menu should be collapsible by default, out-of-the box
      • SFX search embedded into library website
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 3
      2. contype:kba
      3. Prod:SFX
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved