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.