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

Tabi Tabe Tabi tabi.tabe at gmail.com
Wed Mar 4 12:05:41 EST 2015


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

*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


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

More information about the Spce-user mailing list