[Solved] mysql error reading comm packets

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
linuxguy1454
Newcomer
Posts: 12
Joined: Fri Jun 14, 2019 9:10 pm
Location: Northern California
United States of America

[Solved] mysql error reading comm packets

Post by linuxguy1454 » Fri Aug 23, 2019 4:16 am

Gurus,

{see my system specs in my signature below]

I have been having problems saving a new Channel Group, then yesterday when I went to the Program Guide to schedule a couple of recordings, the guide data was not updated. There was no change after running

Code: Select all

mythfilldatabase -dd-grab-all
This led me to check the mysql error.log, and about twice a minute I was getting
[Note] Got an error reading communication packets
I could try manually recording something, but I would prefer not to take any chances to mess up the database.

Found a post in troubleshooting SQL this error could be caused by the default max_allowed_packet of 1M, with a suggestion to increase it to 256M. I added

Code: Select all

max_allowed_packet=256M
to /etc/mysql/conf.d/mythtv.cnf. After restating everything and even rebooting, I'm still getting these errors. Today I'm getting 4 or 5 per minute with the frontend and backend both shut down. I ran

Code: Select all

netstat -na | grep :3306
and don't see anything connecting to that port. I'm at a loss as far as other possible issues that are mentioned, such as clients not closing the connection properly.

I don't know what else could be causing this error, or if the database is OK or corrupted.

If somebody has information about this from a mythtv perspective, I would really appreciate some ideas.

linuxguy1454
Last edited by linuxguy1454 on Sat Aug 24, 2019 5:28 am, edited 1 time in total.
MythTV v29.1-13-g329c235, fixes/29, Library API : 29.20180316-1
with HDHR3 tuner on Ubuntu 18.04 Bionic Beaver and lightdm.

linuxguy1454
Newcomer
Posts: 12
Joined: Fri Jun 14, 2019 9:10 pm
Location: Northern California
United States of America

Re: mysql error reading comm packets

Post by linuxguy1454 » Fri Aug 23, 2019 4:30 am

mysql details: Ver 14.14 Distrib 5.7.27, for Linux (x86_64)
MythTV v29.1-13-g329c235, fixes/29, Library API : 29.20180316-1
with HDHR3 tuner on Ubuntu 18.04 Bionic Beaver and lightdm.

linuxguy1454
Newcomer
Posts: 12
Joined: Fri Jun 14, 2019 9:10 pm
Location: Northern California
United States of America

Re: mysql error reading comm packets

Post by linuxguy1454 » Fri Aug 23, 2019 5:05 am

I'm also running mythwelcome. I started things back up and when I first went in to check the Program Guide, it had correct and current data from my shedulesdirect. When I scheduled 2 programs from there and checked them in Upcoming Recordings, they were shown as "Not Listed" and the Program Guide is messed up again too.

All this behavior feels like da6tabase problems to me, not that I'm that much of an expert on mythtv.
MythTV v29.1-13-g329c235, fixes/29, Library API : 29.20180316-1
with HDHR3 tuner on Ubuntu 18.04 Bionic Beaver and lightdm.

jksj
Junior
Posts: 61
Joined: Thu Feb 13, 2014 7:53 pm
Great Britain

Re: mysql error reading comm packets

Post by jksj » Fri Aug 23, 2019 8:00 am

Check the database - seehttps://www.mythtv.org/wiki/User_Manual ... aintenance
Mythweb also has database checks as part of its tools.

linuxguy1454
Newcomer
Posts: 12
Joined: Fri Jun 14, 2019 9:10 pm
Location: Northern California
United States of America

Re: mysql error reading comm packets

Post by linuxguy1454 » Sat Aug 24, 2019 5:24 am

jksj, thank you! Running the optimize_mythdb script seems to have done the job. The Program Guide and recordings seem to be working OK now. I set up a cron job to run it periodically.

I'm still seeing those communication packets errors as frequently as before, but at least the frontend is useable now.

I'm not sure how to properly mark this topic as [Solved]. I will see if I can figure that out.
MythTV v29.1-13-g329c235, fixes/29, Library API : 29.20180316-1
with HDHR3 tuner on Ubuntu 18.04 Bionic Beaver and lightdm.

Post Reply