Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    SFX_REQUEST table error running monthly kbdb update

    • 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
    //doorbell.io feedback widged