IBM Security QRadar

 View Only

  • 1.  QRadar App Locked

    Posted Tue July 09, 2019 01:18 PM
    One of our QRadar apps is currently "locked". When attempting to upgrade or delete/re-install the app, I get the error "The application is currently locked by another request." I confirmed the app is locked by using the following command: 
    psql -U qradar -c "select id,name,status,lock from installed_application"

    The 'lock' field has a timestamp of when the app was locked. The 'status' is "running". 

    I am able to get to the docker container for that app by using the following command:

    Docker exec -it  {containerID} /bin/bash

    I wanted to know the command to unlock/reset the lock on that app?

    Thank you,
    Manpreet

    ------------------------------
    Manpreet Bains
    ------------------------------


  • 2.  RE: QRadar App Locked
    Best Answer

    Posted Wed July 10, 2019 02:20 AM
    ​Hi,

    Login to QRadar Console and verify locked applications

    psql -U qradar -c "select id,name,status,task_status,lock,errors from installed_application;"

    You will need to unlock all of the apps which have dates and times in their lock column based on the output

    psql -U qradar -c "update installed_application set lock=null where id=<application id>;"

    Once you have gone through and ran the psql to unlock the apps swapping the app id each time re run the first command to make sure the lock status has been removed from the db

    Regards,

    ------------------------------
    Vedran Goricki
    ------------------------------

    Original Message