Hi
I am using sqlbill with gnugk 2.2.6/ postgres 8.1.10.
system is working ok, however following erros are coming on the radius log few times every hour or so.
Fri Jul 25 05:32:30 2008 : Error: rlm_sql (sql): failed after re-connect
Fri Jul 25 05:32:30 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - ERROR: deadlock detected DETAIL: Process 22770 waits for ShareLock on transaction 3951232; blocked by process 22769. Process 22769 waits for ShareLock on transaction 3951234; blocked by process 22770. CONTEXT: SQL statement "UPDATE voipaccount SET balance = balance - $1 WHERE id = $2 " PL/pgSQL function "voipcall_update_cost" line 29 at SQL statement
Fri Jul 25 05:32:30 2008 : Error: rlm_sql (sql): failed after re-connect
Fri Jul 25 05:32:30 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.
Fri Jul 25 05:32:32 2008 : Error: rlm_sql (sql): failed after re-connect
Fri Jul 25 05:32:32 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting START record - ERROR: duplicate key violates unique constraint "voipcall_acctupdatestop_idx"
Fri Jul 25 05:32:32 2008 : Error: rlm_sql (sql): failed after re-connect
Fri Jul 25 05:32:32 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.
Is it a bug in sqlbill ? appreciate your inputs
thanks in advance
Manjula Hettiarachchi
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________________
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/
