Calls log doesn't appear to grow beyond 200 records

[devon]

With the "Number of log entries to show:" set to 1000, the 'Diagnostics: Logs' calls log does not appear to grow larger than 200 records. I was watching cdr.db to see how large it would grow, and noticed that it was not getting much bigger than about 80kb.

[Michael]

As with the other logs in AskoziaPBX, there is an upper bound to the call log's size (200 entries). If each log was allowed to grow infinitely, the system would eventually exhaust itself of memory as everything is run from a memory disk.

[devon]

I apologize for not being clear, it makes perfect sense that the logs not be allowed to grow indefinitly. The calls log title says "Last 1000 Call Records" even though the maximum number of records is really 200?

[Michael]

That's a cosmetic problem then. There are two different ways logs are handled. One is aware of how many entries it can have (calls) and the others only have size limits (system, pbx). Some logic could be added to ensure that the titles make sense in those different situations.

[devon]

It appears the limit is imposed in cdr_sqlite.c and compiled into cdr_sqlite.so:

BEGIN DELETE FROM cdr   WHERE id <= (SELECT max(id) FROM cdr) - 200; END;

[Michael]

Yes, those modifications are why it is in our tree.

[devon]

Ok, I now understand your comment. I did not know of the modified cdr_sqlite.c in the svn tree until after your post (i got the text in my previous post from looking at cdr_sqlite.so in a  hex editor). I've downloaded the source and changed the limit from 200 to 1000, and recompiled cdr_sqlite.so. Works a treat, thanks.