mod_callcenter becomes unresponsive if idle for a long time (> than a day) - Githubissues

signalwire / freeswitch

FreeSWITCH is a Software Defined Telecom Stack enabling the digital transformation from proprietary telecom switches to a versatile software implementation that runs on any commodity hardware. From a Raspberry PI to a multi-core server, FreeSWITCH can unlock the telecommunications potential of any device.

https://freeswitch.com/#getting-started

Other

3.54k stars 1.41k forks source link

mod_callcenter becomes unresponsive if idle for a long time (> than a day) #889

Open royalpinto opened 4 years ago

royalpinto commented 4 years ago

Description

When the mod_callcenter is idle for a long time (> than a day), it becomes unresponsive.
Even the callcenter_config agent list command fails.
After analyzing the code, it appears to me that it gets stuck at cc_execute_sql_callback function.
Probably FS considers that the connection is active but in reality, it is closed on the PostgresSQL side.
Hence it simply waits for the query to finish but never finishes.

To Reproduce

Ensure mod_callcenter is loaded and you can run callcenter_config agent list.
Keep it at this stage for more than 24 hours. Nothing should be done during this idle period. (Not sure if this is enough though). In my case, it was idle for 2+ days. (Weekend)
Now, try to hit the callcenter_config agent list. => Your command gets stuck forever. This is just an example, but even the call sent to this module gets stuck forever.

Expected behavior => The command should succeed. If the connection is broken, it should re-initiate a new connection.

Package version or git hash

Version v1.8.5
Database Used: Postgres 9.6

NOTE

Probably the issue is there on other modules too which uses the database connection.

italorossi commented 4 years ago

1.8.5 is a little bit old, could you try to reproduce it with the newer 1.10 version?