Motion - Support Question 2011x 09x 29x 082713

mysql connections in sleep state

Question

Hi, i have a debian system with 2.6.32-5-amd64 kernel and motion version 3.2.12-3, and have the motion set to log images, mpegs, and timelapse files to mysql version 5.1.58-1. The motion detection is based on 3 netcams, and one v4l webcam. The detection is working fine, but leaves the sql connections open, so after a while the maximum sql connections are exceeded, so no more logging. Only restarting the motion daemon or killing the sql connections via mysql admin are freeing the connections.

sql_log_image on
sql_log_snapshot off
sql_log_mpeg on
sql_log_timelapse on
sql_query insert into motion(camera, filename, frame, file_type, time_stamp, event_time_stamp) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C')
mysql_db motion
mysql_host localhost
mysql_user motion
mysql_password pw



Environment

Motion version: 3.2.12
ffmpeg version: 5:0.6.1+svn20101128-0.2
Libraries: ffmpeg, mysql
Server OS: debian kernel 2.6.32
-- PeterTar - 29 Sep 2011

Answer

Topic revision: r1 - 29 Sep 2011, PeterTar
Copyright © 1999-2017 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Please do not email Kenneth for support questions (read why). Use the Support Requests page or join the Mailing List.
This website only use harmless session cookies. See Cookie Policy for details. By using this website you accept the use of these cookies.