The account balance is not being deducted from any of the accounts

amitiyer · February 13, 2019, 9:09am

Hello,

I have setup Yeti on a new server and the calls are running fine without any issue but when i checked the balance of the customers it is not being deducted. any suggestions ?

dmitry.s · February 13, 2019, 9:14am

pgqd is not running or cdr_billing is not running.

amitiyer · February 13, 2019, 9:16am

how do i check that ? I am sorry i am new to postgres. i have worked with mysql but not postgresql

dmitry.s · February 13, 2019, 9:16am

ps aux | grep pgq
ps aux | grep cdr_billing

amitiyer · February 13, 2019, 9:18am

Below is what i see, should i open any ports on the firewall ?

dmitry.s · February 13, 2019, 9:19am

I was right - pgqd is not running. See https://yeti-switch.org/docs/en/installation/cdr-database.html#pgqd-ticker

amitiyer · February 13, 2019, 9:38am

is this correct ? I also enabled pgqd at startup and rebooted.

dmitry.s · February 13, 2019, 9:48am

yes.

amitiyer · February 13, 2019, 9:50am

Ok, but still the balance is as it is.

dmitry.s · February 13, 2019, 10:31am

show tail /var/log/yeti-cdr-billing.log

amitiyer · February 13, 2019, 10:45am

dmitry.s · February 13, 2019, 10:58am

Billing queue contains 1069038 events, you should wait until they will be processed.

amitiyer · February 13, 2019, 11:02am

I just checked the log again and still there are 1069038 events, Should i wait or something is stuck ?

amitiyer · February 13, 2019, 11:48am

Now i get blank. The Balance is still not decreasing, I have set reverse billing as false in Destination rates.

amitiyer · February 13, 2019, 3:17pm

@dmitry.s , any suggestions ?

dmitry.s · February 13, 2019, 3:21pm

It depends on process cdr_billing. If cdr_billing is running - wait.

amitiyer · February 13, 2019, 3:23pm

I checked the logs, it is blank now, but the balance is still not decreasing.

does this has something to do with the balance ?

amitiyer · February 13, 2019, 3:33pm

I am really confused as i have shifted a client on yeti and since yesterday i dont have a track of their usage.

dmitry.s · February 13, 2019, 7:11pm

Looks like you have no enough RAM and cdr_billing process crashed(killed by OOM killer) when tried to load batch with 1M events. In normal situation pgqd create batches with 10-100 events.
There are few solutions:

drop this huge batch. Then your previous calls will be not billed. You can create report and calculate balance by CDRs.
process events manualy

amitiyer · February 13, 2019, 7:13pm

Here is the config of the server. What can i do to bill the previous once, if that does not work, how can i drop the batch and then have the cdr billing done automatically ?