Seems like another query has locked voipaccount table and keeps other queries from running. The ps command may give you some hints on what query is holding the lock (find the process ID). ----- Original Message ----- From: "manjula hettiarachchi" <manjula_55@xxxxxxxxx> To: "gnugk list" <openh323gk-users@xxxxxxxxxxxxxxxxxxxxx> Sent: Monday, March 10, 2008 11:18 AM Subject: sqlbill radius problem > Hi > > I am using gnugk 2.2.6 with sqlbill. The system > usually works normally, but we see following error on > the radius log, every now and then. > > > > ######################### >>> Mon Mar 10 06:07:12 2008 : Error: rlm_sql (sql): > failed after re-connect > Mon Mar 10 06:07:12 2008 : Error: rlm_sql (sql): > Couldn't insert SQL accounting START record - ERROR: > deadlock detected DETAIL: Process 4930 waits for > ShareLock on transaction 1235265; blocked by process > 4718. Process 4718 waits for ShareLock on transaction > 1235267; blocked by process 4930. CONTEXT: SQL > statement "UPDATE voipaccount SET balance = balance - > $1 WHERE id = $2 " PL/pgSQL function > "voipcall_update_cost" line 29 at SQL statement > Mon Mar 10 06:07:12 2008 : Error: rlm_sql (sql): > failed after re-connect > Mon Mar 10 06:07:12 2008 : Error: rlm_sql (sql): > Couldn't update SQL accounting START record - ERROR: > function throwex() does not exist HINT: No function > matches the given name and argument types. You may > need to add explicit type casts. > > ################### > > > Can anybody give a hint as to what's going on > > Thanks in advance > > Manjula Hettiarachchi ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
