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 )