<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18939">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>after hangup,</FONT></DIV>
<DIV><FONT size=2>nibblebill makes unnecessary duplicated SQL requests
:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=1>
<P>2011-02-08 11:06:36.894238 [DEBUG] mod_sofia.c:457 Channel
sofia/internal/9999999999999@domain.com hanging up, cause:
NORMAL_CLEARING<BR>2011-02-08 11:06:37.018489 [DEBUG] mod_nibblebill.c:433
Attempting to bill at $0.03864 per minute to account 9999999999999<BR>2011-02-08
11:06:37.018489 [INFO] mod_nibblebill.c:485 Beginning new billing on
461772290@12.34.56.78<BR>2011-02-08 11:06:37.018489 [DEBUG] mod_nibblebill.c:491
1 seconds passed since last bill time of 2011-02-08 11:06:35<BR>2011-02-08
11:06:37.018489 [DEBUG] mod_nibblebill.c:498 Billing $0.000874 to 9999999999999
(Call: 461772290@12.34.56.78 / 0.000000 so far)<BR>2011-02-08 11:06:37.018489
[DEBUG] mod_nibblebill.c:321 Doing update query<BR><FONT color=#ff0000>[UPDATE
accounts SET cash=cash-0.000874 WHERE id='9999999999999']</FONT><BR>2011-02-08
11:06:37.074740 [DEBUG] mod_nibblebill.c:366 Doing lookup query<BR>[<FONT
color=#ff0000>SELECT cash AS nibble_balance FROM accounts WHERE
id='9999999999999']</FONT><BR>2011-02-08 11:06:37.082844 [DEBUG]
mod_nibblebill.c:376 Retrieved current balance for account 9999999999999
(balance = 9.579666)<BR>2011-02-08 11:06:37.082844 [DEBUG]
switch_core_state_machine.c:46 sofia/internal/9999999999999@domain.com Standard
HANGUP, cause: NORMAL_CLEARING<BR>2011-02-08 11:06:37.082844 [DEBUG]
switch_core_state_machine.c:557 (sofia/internal/9999999999999@domain.com) State
HANGUP going to sleep<BR>2011-02-08 11:06:37.082844 [DEBUG]
switch_core_state_machine.c:351 (sofia/internal/9999999999999@domain.com) State
Change CS_HANGUP -> CS_REPORTING<BR>2011-02-08 11:06:37.082844 [DEBUG]
switch_core_session.c:1116 Send signal sofia/internal/9999999999999@domain.com
[BREAK]<BR>2011-02-08 11:06:37.082844 [DEBUG] switch_core_state_machine.c:320
(sofia/internal/9999999999999@domain.com) Running State Change
CS_REPORTING<BR>2011-02-08 11:06:37.082844 [DEBUG]
switch_core_state_machine.c:617 (sofia/internal/9999999999999@domain.com) State
REPORTING<BR>2011-02-08 11:06:37.082844 [DEBUG] mod_nibblebill.c:433 Attempting
to bill at $0.03864 per minute to account 9999999999999<BR>2011-02-08
11:06:37.082844 [DEBUG] mod_nibblebill.c:491 0 seconds passed since last bill
time of 2011-02-08 11:06:37<BR>2011-02-08 11:06:37.082844 [DEBUG]
mod_nibblebill.c:498 Billing $0.000041 to 9999999999999 (Call:
461772290@12.34.56.78 / 0.000874 so far)<BR>2011-02-08 11:06:37.082844 [DEBUG]
mod_nibblebill.c:321 Doing update query<BR><FONT color=#ff0000>[UPDATE accounts
SET cash=cash-0.000041 WHERE id='9999999999999']</FONT><BR>2011-02-08
11:06:37.133170 [DEBUG] mod_nibblebill.c:366 Doing lookup query<BR><FONT
color=#ff0000>[SELECT cash AS nibble_balance FROM accounts WHERE
id='9999999999999']</FONT><BR>2011-02-08 11:06:37.201557 [DEBUG]
mod_nibblebill.c:376 Retrieved current balance for account 9999999999999
(balance = 9.579625)</P>
<P><FONT size=2>How to avoid duplicate SQL requests with nibblebill ?</FONT></P>
<P><FONT size=2>Thanks</FONT></P></FONT></DIV></BODY></HTML>