Failed statement: CREATE INDEX IX_LISA_TEMP_TABLE1__ ON LISA_TEMP_TABLE1

Products

• Service Virtualization

Issue/Introduction

Recently had a Linux patch applied to our DevTest machine.

Since patch was applied Registry has this error:

2019-11-27 20:27:19,343Z (15:27) [main] ERROR System.err                     - [DevTest AGENT:][ERROR][21171][1][main][Nov 27, 2019 3:27:19 PM] !!!!!!!! Database user permission check failed !!!!!!!!

2019-11-27 20:27:19,403Z (15:27) [main] ERROR System.err                     - [DevTest AGENT:][ERROR][21171][1][main][Nov 27, 2019 3:27:19 PM] Please ensure the user has privileges to create/alter/drop table, view, procedure and index and manipulate data.

2019-11-27 20:27:19,403Z (15:27) [main] ERROR System.err                     - [DevTest AGENT:][ERROR][21171][1][main][Nov 27, 2019 3:27:19 PM] Failed statement: CREATE INDEX IX_LISA_TEMP_TABLE1__ ON LISA_TEMP_TABLE1__ (COL2)  Error: INDEX command denied to user 'svc_evuinonprod'@'ABCl0003.aca.afsiep.net' for table 'lisa_temp_table1__'

 

Environment

All supported DevTest releases.

Cause

Recent Linux patch had been applied and the server rebooted without bringing down all DevTest components. 

Not absolutely sure this is the cause, but the database was running with no issues before the patch was applied.

Resolution

Needed to create a new Registry database.

Basically, the IX_LISA_TEMP_TABLE1__ is used to check whether the user has DB permissions to create the Lisa tables or not.

/**
* Checks whether it is possible and safe to change inner database structure. If migration is
* going to take place, it places safeguard before this process is started and makes
* sure user does have appropriate permissions.
*/