<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<div style="color: black;">
<p style="margin: 0 0 1em 0; color: black; font-family: sans-serif;">On 8 October 2017 12:42:06 am "DryHeat122 ." <dryheat122@gmail.com> wrote:</p>
<p style="margin: 0 0 1em 0; color: black; font-family: sans-serif;">> I have been suffering increasingly frequent backend crashes lately. When<br>
> this happens, restarting the backend does not fix the problem. It takes a<br>
> reboot to straighten things out, so I'm guessing the problem isn't the<br>
> backend per se. mythbackend.log indicates some mysql problems. Segment<br>
> below is from where I think the problem starts. Any suggestions how to<br>
> troubleshoot/fix?<br>
><br>
> Oct 4 15:00:05 steve-EP45-UD3P mythbackend: mythbackend[806]: N Update<br>
> autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free<br>
> Space: 3.0 GB w/freq: 15 min<br>
> Oct 4 15:05:43 steve-EP45-UD3P mythbackend: mythbackend[806]: N Expire<br>
> autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free<br>
> Space: 3.0 GB w/freq: 15 min<br>
> Oct 4 15:20:43 steve-EP45-UD3P mythbackend: mythbackend[806]: N Expire<br>
> autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free<br>
> Space: 3.0 GB w/freq: 15 min<br>
> Oct 4 15:35:43 steve-EP45-UD3P mythbackend: mythbackend[806]: N Expire<br>
> autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free<br>
> Space: 3.0 GB w/freq: 15 min<br>
> Oct 4 15:50:43 steve-EP45-UD3P mythbackend: mythbackend[806]: N Expire<br>
> autoexpire.cpp:264 (CalcParams) AutoExpire: CalcParams(): Max required Free<br>
> Space: 3.0 GB w/freq: 15 min<br>
> Oct 4 15:59:00 steve-EP45-UD3P mythbackend: mythbackend[806]: I Scheduler<br>
> scheduler.cpp:2267 (HandleReschedule) Reschedule requested for PLACE<br>
> PrepareToRecord<br>
> Oct 4 16:00:44 steve-EP45-UD3P mythbackend: mythbackend[806]: E TaskQueue<br>
> mmulticastsocketdevice.cpp:60 (MMulticastSocketDevice)<br>
> MMulticastSocketDevice(239.255.255.250:68): setsockopt - IP_ADD_MEMBERSHIP<br>
> #012#011#011#011eno: No such device (19)<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdbcon.cpp:864 (prepare) Error preparing query: INSERT INTO recordedseek<br>
> (chanid, starttime, type, mark, offset) VALUES<br>
> (2041,'2017-10-04T22:00:00Z',9,102269,5125967392),(2041,'2017-10-04T22:00:00Z',9,102397,5132956856)<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdbcon.cpp:866 (prepare) Driver error was [2/2013]:#012QMYSQL3: Unable<br>
> to prepare statement#012Database error was:#012Lost connection to MySQL<br>
> server during query<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdb.cpp:183 (DBError) DB Error (delta position map insert):#012Query<br>
> was:#012INSERT INTO recordedseek (chanid, starttime, type, mark, offset)<br>
> VALUES<br>
> (2041,'2017-10-04T22:00:00Z',9,102269,5125967392),(2041,'2017-10-04T22:00:00Z',9,102397,5132956856)#012Driver<br>
> error was [2/2006]:#012QMYSQL: Unable to execute query#012Database error<br>
> was:#012MySQL server has gone away<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdbcon.cpp:229 (OpenDatabase) [DBManager119] Unable to connect to<br>
> database!<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdbcon.cpp:230 (OpenDatabase) Driver error was [1/2003]:#012QMYSQL:<br>
> Unable to connect#012Database error was:#012Can't connect to MySQL server<br>
> on '192.168.1.200' (101)<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: I TVRecEvent<br>
> mythdbcon.cpp:842 (prepare) MySQL server disconnected<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: I TVRecEvent<br>
> mythdbcon.cpp:638 (exec) MySQL server disconnected<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdb.cpp:183 (DBError) DB Error (delta position map insert):#012Query<br>
> was:#012#012No error type from QSqlError? Strange...<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdbcon.cpp:229 (OpenDatabase) [DBManager119] Unable to connect to<br>
> database!<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: E TVRecEvent<br>
> mythdbcon.cpp:230 (OpenDatabase) Driver error was [1/2003]:#012QMYSQL:<br>
> Unable to connect#012Database error was:#012Can't connect to MySQL server<br>
> on '192.168.1.200' (101)<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: I TVRecEvent<br>
> mythdbcon.cpp:842 (prepare) MySQL server disconnected<br>
> Oct 4 16:14:40 steve-EP45-UD3P mythbackend: mythbackend[806]: I TVRecEvent<br>
> mythdbcon.cpp:638 (exec) MySQL server disconnected<br>
><br>
><br>
><br>
Next time if happens check the state of mysql before rebooting. How best to do so will depend on your OS but a quick first check is to see if you can actually login to your mysql instance as the user in your config.xml file.
<br>
</p>
</div>
</body>
</html>