Bug ID 1024437: Urldb index building fails to open index temp file

Last Modified: Nov 29, 2021

Bug Tracker

Affected Product:  See more info
BIG-IP SSLO, SWG(all modules)

Known Affected Versions:
13.1.0, 13.1.0.1, 13.1.0.2, 13.1.0.3, 13.1.0.4, 13.1.0.5, 13.1.0.6, 13.1.0.7, 13.1.0.8, 13.1.1, 13.1.1.2, 13.1.1.3, 13.1.1.4, 13.1.1.5, 13.1.3, 13.1.3.1, 13.1.3.2, 13.1.3.3, 13.1.3.4, 13.1.3.5, 13.1.3.6, 13.1.4, 13.1.4.1, 14.1.0, 14.1.0.1, 14.1.0.2, 14.1.0.3, 14.1.0.5, 14.1.0.6, 14.1.2, 14.1.2.1, 14.1.2.2, 14.1.2.3, 14.1.2.4, 14.1.2.5, 14.1.2.6, 14.1.2.7, 14.1.2.8, 14.1.3, 14.1.3.1, 14.1.4, 14.1.4.1, 14.1.4.2, 14.1.4.3, 14.1.4.4, 15.1.0, 15.1.0.1, 15.1.0.2, 15.1.0.3, 15.1.0.4, 15.1.0.5, 15.1.1, 15.1.2, 15.1.2.1, 15.1.3, 15.1.3.1, 15.1.4, 15.1.4.1

Opened: Jun 10, 2021
Severity: 3-Major

Symptoms

The following error message shows up in /var/log/urldbmgr-trace.log: THREAD: 2CDD4700; ERROR; WsFileOpen: Could not open file /var/urldb/staging/current/host.6417.byte.dat.003 THREAD: 2CDD4700; ERROR; WsIndexBuilderOpenFile: Failed to open index file /var/urldb/staging/current/host.6417.byte.dat.003. THREAD: 2CDD4700; ERROR; WsHostIndexV7OpenFile: Failed to open Host index file /var/urldb/staging/current/host.6417.byte.dat.003. THREAD: 2CDD4700; ERROR; WsHostIndexV7BuildProcessTempFiles: Failed to open host index temp file As a result of this error, some requested URL category lookups return "Uncategorized".

Impact

Some websites are categorized as "Uncategorized"

Conditions

The error can happen during index building after a new primary URLDB is downloaded.

Workaround

1) Stop urldbmgrd: bigstart stop urldb urldbmgrd 2) Delete databases: rm -rf /var/urldb/master/ rm -rf /var/urldb/rtu/ 3) Start urldbmgrd: bigstart start urldb urldbmgrd 4) Force database download: - tmsh command: "modify sys url-db download-schedule urldb download-now true", or - Admin GUI: Access >> Secure Web Gateway >> Database Settings >> Database Download >> Download Now Databases will re-download and index.

Fix Information

None

Behavior Change