sqlbill radius problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs

-------------------------------------------------------------------------
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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux