[op5-users] Error on writing on database

[Andreas Ericsson]

Pierguido Lambri wrote:
> Hi.
> I setup merlind but in the logs i found this:
> 
> [1246291556] 7: Successfully read 1 event (264 bytes; 200 bytes body) from socket 5
> 
> [1246291556] 7: Sending to all 0 nocs and peers
> [1246291556] 6: dbi_conn_query_null(): Failed to run [UPDATE merlin.program_status SET is_running = 1, last_alive = 1246291556, program_start = 1246057040, pid = 25188, daemon_mode = 1, last_command_check = 1246291556, last_log_rotation = 1246226400, notifications_enabled = 1, active_service_checks_enabled = 1, passive_service_checks_enabled = 1, active_host_checks_enabled = 1, passive_host_checks_enabled = 1, event_handlers_enabled = 1, flap_detection_enabled = 1, failure_prediction_enabled = 1, process_performance_data = 0, obsess_over_hosts = 0, obsess_over_services = 0, modified_host_attributes = 0, modified_service_attributes = 0, global_host_event_handler = '', global_service_event_handler = ''WHERE instance_id = 0]: 2006: MySQL server has gone away
> [1246291556] 7: sel_val: 6; ipc_listen_sock: 3; ipc_sock: 5; net_sock: 6
> [1246291560] 7: select() returned 1 (errno = 0: Success)
> 
> If i go to check manually the db is empty.
> I've tried to increase a bit the value max_allowed_packet=2097152
> but didn't help.
> Mysql is up and running without problems,

Have you configured the database parameters correctly?
Does the database have a timeout parameter set? Can you increase it?

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

Considering the successes of the wars on alcohol, poverty, drugs and
terror, I think we should give some serious thought to declaring war
on peace.