[Spce-user] MySQL errors

[Raúl Alexis Betancor Santana]

Hi all, since we upgrades a test system from 3.2 to mr3.3 and
yesterday to mr3.4.1 this is getting worst:

Aug  7 14:18:56 sipapp01 proxy[16074]: ERROR: db_mysql
[km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost
connection to MySQL server during query
Aug  7 14:18:56 sipapp01 proxy[16074]: ERROR: <core> [db_query.c:337]:
db_do_update(): error while submitting query
Aug  7 14:18:56 sipapp01 proxy[16074]: ERROR: usrloc [ucontact.c:815]:
db_update_ucontact_addr(): updating database failed
Aug  7 14:18:56 sipapp01 proxy[16074]: ERROR: usrloc
[ucontact.c:1502]: update_ucontact(): failed to update database
Aug  7 14:18:56 sipapp01 proxy[16074]: ERROR: registrar [save.c:775]:
update_contacts(): failed to update contact
Aug  7 14:18:56 sipapp01 proxy[16077]: ERROR: db_mysql
[km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost
connection to MySQL server during query
Aug  7 14:18:56 sipapp01 proxy[16077]: ERROR: <core> [db_query.c:337]:
db_do_update(): error while submitting query
Aug  7 14:18:56 sipapp01 proxy[16077]: ERROR: usrloc [ucontact.c:815]:
db_update_ucontact_addr(): updating database failed
Aug  7 14:18:56 sipapp01 proxy[16077]: ERROR: usrloc
[ucontact.c:1502]: update_ucontact(): failed to update database
Aug  7 14:18:56 sipapp01 proxy[16077]: ERROR: registrar [save.c:775]:
update_contacts(): failed to update contact
Aug  7 14:18:57 sipapp01 proxy[16083]: ERROR: db_mysql
[km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost
connection to MySQL server during query
Aug  7 14:18:57 sipapp01 proxy[16083]: ERROR: <core> [db_query.c:337]:
db_do_update(): error while submitting query
Aug  7 14:18:57 sipapp01 proxy[16083]: ERROR: usrloc [ucontact.c:815]:
db_update_ucontact_addr(): updating database failed
Aug  7 14:18:57 sipapp01 proxy[16083]: ERROR: usrloc
[ucontact.c:1502]: update_ucontact(): failed to update database
Aug  7 14:18:57 sipapp01 proxy[16083]: ERROR: registrar [save.c:775]:
update_contacts(): failed to update contact


Also notice a lot of 'slow queries' on the logs of mysql.

Test system it's a  dual Intel(R) Xeon(R) CPU E5420  @ 2.50GHz, with 4
cores each CPU and 16Gb of RAM.

There is also errors about ACC inserts:

Aug  7 14:21:10 sipapp01 proxy[16085]: ERROR: db_mysql
[km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost
connection to MySQL server duri
ng query
Aug  7 14:21:10 sipapp01 proxy[16085]: ERROR: <core> [db_query.c:235]:
db_do_insert_cmd(): error while submitting query
Aug  7 14:21:10 sipapp01 proxy[16085]: ERROR: acc [acc.c:509]:
acc_db_request(): failed to insert into database


Any hint about what could be wrong ?

Best regards