Product Upgrade on Linux Indexer Fails

book

Article ID: 100056308

calendar_today

Updated On:

Description

Error Message

2023-04-23 20:16:11 ERROR: V-378-1301-1: #{3389916992} indexdb.c|F|make_prepared_stmt(SELECT fid,atime,ctime,mtime,gid,uid,cuid,muid,size,access,fromancestor,todescendant,aid,dtime,odsize,nextsibling,nextchild,attr,kind FROM dentry WHERE parentid=:parentid AND name=:name)|1

2023-04-23 20:16:11 ERROR: V-378-1301-1: #{3389916992} indexdb.c|F|indexdb_inode_get_v2|indexdb_inode_get|ERR_FAILED

2023-04-23 20:16:59 INFO: V-378-1306-50: #{3389916992} [dbhandle_cleanup: 1116] Deleting the database /DataInsight/data/indexer/default/45/45/index.db.27 

Cause

This error happens when there is not enough space on the TEMP volume on the indexer node

SQLite uses the following order for temporary file locations:

Temporary Files Used By SQLite

  1. The directory set by PRAGMA temp_store_directory or by the sqlite3_temp_directory global variable
  2. The SQLITE_TMPDIR environment variable
  3. The TMPDIR environment variable
  4. /var/tmp
  5. /usr/tmp
  6. /tmp
  7. The current working directory (".")

Resolution

Set the SQLITE_TMPDIR environment variable on the indexer node to a location that contains enough space to store the temporary files necessary for the upgrade

In most cases, setting the SQLITE_TMPDIR to Data Insight location will be sufficient

Example:

SQLITE_TMPDIR=/DataInsight

Once the SQLITE_TMPDIR environment variable is set, relaunch the upgrade

Issue/Introduction

Performing an upgrade of Data Insight on a Linux indexer fails during database upgrades