Good afternoon,
After the upgrade to v1.8 the pgqd ticker throws errors.
As a result the billing events are not processed.
The pgqd service is running, and I can see that the event tables are being filled in the database it is connecting to (using same credentials as provided in /etc/pgqd.ini):
Is there any more detailed logging I can check to see where it’s going wrong?
Could you show postgresql.log? Looks like issue caused by postgresql upgrade. See https://github.com/markokr/skytools/blob/master/doc/faq.txt#L50
The postgresql update was indeed the case, the txid in the postgresql log was too low;
ERROR: Invalid PgQ state: old xmin=13293244, old xmax=13293244, cur txid=8787047
After fixing this the events also moved to pending events. 
Thanks!
After restarting the cdr billing service (as it had crashed) it instantly processed all events. Now all pending events have been cleared, however, the balances of the clients remained intact.
Have these events been lost regarding the billing process?
The log of the CDR service shows:
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.355131 ] [ INFO]: Worker for cdr_billing started
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.385169 ] [ INFO]: Empty batch
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.385212 ] [ INFO]: Finishing batch 338291
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.391970 ] [ INFO]: Empty batch
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.392011 ] [ INFO]: Finishing batch 338292
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.398462 ] [ INFO]: Empty batch
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.398500 ] [ INFO]: Finishing batch 338293
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.404626 ] [ INFO]: Empty batch
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.404660 ] [ INFO]: Finishing batch 338294
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.410783 ] [ INFO]: Empty batch
Jul 26 19:16:45 voipswitch YETI-cdr-billing[60981]: [19:16:45.410812 ] [ INFO]: Finishing batch 338295
Jul 26 19:17:08 voipswitch YETI-cdr-billing[60981]: [19:17:08.981432 ] [ INFO]: Empty batch
Jul 26 19:17:08 voipswitch YETI-cdr-billing[60981]: [19:17:08.981885 ] [ INFO]: Finishing batch 338296
Jul 26 19:18:09 voipswitch YETI-cdr-billing[60981]: [19:18:09.149860 ] [ INFO]: Empty batch
Jul 26 19:18:09 voipswitch YETI-cdr-billing[60981]: [19:18:09.149923 ] [ INFO]: Finishing batch 338297