0

I am trying to write function for updating database table columns (here column name will differ various point of time.) So while doing so, i am getting "operation error, Database locked". Could anyone suggest reason behind this. For more clarification i am providing code as below:

def UpdateDB_ForFields(DB_name, DB_tableName, dev_name, devindex, colList, colValList): 
    try:
        conn = None
        cloudDBlockList[devindex].acquire()
        pool_sema.acquire()
        conn = sqlite3.connect("XYZ.db",timeout=20)
        for i in range(len(colList)):
            cursor = conn.execute("""UPDATE XYZ_settings SET {0} = ? WHERE {1} = ?;""".format(colList[i],"devName"),(colValList[i],dev_name))           
        conn.commit()
        conn.close()
        pool_sema.release()
        cloudDBlockList[devindex].release()
    except Exception as ex:
        template = "An exception of type {0} occurred. Arguments:\n{1!r}"
        message = template.format(type(ex).__name__, ex.args)
        print(message)
        logging.error(message)
        if conn == None:
            print("Error")
        else:
            conn.close()
            pool_sema.release()
            cloudDBlockList[devindex].release()

I am getting error while updating db as database locked. Please suggest the solution.

0 Answers0