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:[email protected]
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/
