<div dir="ltr">Thanks guys, will try these steps.</div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Oct 8, 2017 at 3:23 AM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Sun, 8 Oct 2017 02:36:03 +0000, you wrote:<br>
<br>
>On 8 October 2017 12:42:06 am "DryHeat122 ." <<a href="mailto:dryheat122@gmail.com">dryheat122@gmail.com</a>> wrote:<br>
><br>
>> 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(<a href="http://239.255.255.250:68" rel="noreferrer" target="_blank">239.<wbr>255.255.250:68</a>): 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',<wbr>9,102269,5125967392),(2041,'<wbr>2017-10-04T22:00:00Z',9,<wbr>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',<wbr>9,102269,5125967392),(2041,'<wbr>2017-10-04T22:00:00Z',9,<wbr>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>
<br>
</div></div>There are various things that can cause mysql problems. There may be<br>
some clues in the mysql log files (normally in /var/log or<br>
/var/log/mysql). I would also check the mythconverg database for any<br>
errors or crashed tables using the optimize_db script. And before<br>
doing that, also make sure that you have enough free space on the<br>
drive. You need room for a copy of the largest table's files. The<br>
largest table is recordedseek, so take a look at<br>
/var/lib/mysql/mythconverg/<wbr>recordedseek.* and see if you have at least<br>
as much free space as those files take.<br>
______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/<wbr>mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/<wbr>Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div><br></div>