From 92c4204ee2bedfdf279e7d2051ed1a9293a61802 Mon Sep 17 00:00:00 2001 From: Waqas Hussain Date: Mon, 27 Dec 2010 06:10:35 +0500 Subject: mod_storage_sql: Call commit() after all SQL statements, including SELECT, to get SQLite to drop its locks. --- plugins/mod_storage_sql.lua | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'plugins/mod_storage_sql.lua') diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index e5d5e86c..12c8eebe 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -55,9 +55,9 @@ do -- process options to get a db connection if count == 0 then local stmt = assert(connection:prepare("CREATE TABLE `Prosody` (`host` TEXT, `user` TEXT, `store` TEXT, `key` TEXT, `subkey` TEXT, `type` TEXT, `value` TEXT);")); assert(stmt:execute()); - assert(connection:commit()); module:log("debug", "Initialized new SQLite3 database"); end + assert(connection:commit()); --print("===", json.stringify()) end end @@ -132,7 +132,7 @@ function keyval_store:get(username) end end end - return haveany and result or nil; + return commit(haveany and result or nil); end function keyval_store:set(username, data) user,store = username,self.store; @@ -182,7 +182,7 @@ function map_store:get(username, key) end end end - return haveany and result or nil; + return commit(haveany and result or nil); end function map_store:set(username, key, data) user,store = username,self.store; -- cgit v1.2.3