[Spce-user] MySQL error - too many connections and 500 Internal error

[Tabi Tabe Tabi]

Hi,

I am not sure if anyone has experienced this. I suspect that the "500
Internal Error" I reported in another posting might have to do with this
error.


*Mar  4 19:00:10 sbc-1 proxy[4389]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Too many connections*
*Mar  4 19:00:10 sbc-1 proxy[4389]: ERROR: <core> [db_query.c:235]:
db_do_insert_cmd(): error while submitting query*
*Mar  4 19:00:10 sbc-1 proxy[4389]: ERROR: acc [acc.c:509]:
acc_db_request(): failed to insert into database*

On checking the total MySQL connection I found 2049 connections


*mysql> SHOW STATUS WHERE `variable_name` = 'Threads_connected';*
*+-------------------+-------+*
*| Variable_name     | Value |*
*+-------------------+-------+*
*| Threads_connected | 2049  |*
*+-------------------+-------+*
*1 row in set (0.00 sec)*



Could this be the cause of the error?

What is the recommended setting for max connection for SIPwise?

I am running SPCE 3.7.1. However, the error is the same for 3.6.2 and 3.4.2

Regards,

-- 
...Tabi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20150304/ae8c5092/attachment.html>