[mythtv-users] MySQL related BE deadlocks - collective wisdom needed

Brian J. Murrell brian at interlinx.bc.ca
Wed Aug 24 12:43:27 UTC 2011


On 11-08-24 07:46 AM, Warpme wrote:
> Daniel, Mike,
> 
> Sorry for long silence - I was on holidays :-)

My long silence was to be sure I was seeing success without trying to
"jnix" it.  I have been considering over the last couple of days to send
an update.

I have been running pretty solid for a week and a half on 20110811.915da4f

I didn't do any other upgrades of system software at the time so I can
quite confidently say that the fixes in the Myth code are what has
returned stability.

> -in those 5 days period I had reported 1 DB successful reconnect.

How are you accounting for that?  i.e. what are you looking for in the
log so that I can see how many I am experiencing.

> Currently only DB related issues I have with 20110812-g50606cd are
> reflected in following log entries (avg. 1 per day):

I've gotten the following DB errors in the last day or so:

2011-08-23 15:37:22.862807 E [1588/22518] RecThread mythdb.cpp:192
(DBError) - DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=1045, :DATA=720, :MARK=13215, :STARTTIME=2011-08-23T15:30:00,
:TYPE=30
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1045-2011-08-23 15:30:00-30-13215' for key 'PRIMARY'

2011-08-23 15:37:22.868539 E [1588/22518] RecThread mythdb.cpp:192
(DBError) - DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=1045, :DATA=480, :MARK=13215, :STARTTIME=2011-08-23T15:30:00,
:TYPE=31
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1045-2011-08-23 15:30:00-31-13215' for key 'PRIMARY'

> I want to say recent Daniel's mysql related commits are GREAT for making
> myth production/server grade software.

Absolutely!

> Daniel, really BIG thank You for impressive rightness in problem
> diagnosis and v.quick & 100% effective solution.

Yes, really, really BIG thanks from here too.  My wife was actually
watching a Myth recorded show yesterday, with no assistance from me.

Many many thanks!

b.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
Url : http://www.mythtv.org/pipermail/mythtv-users/attachments/20110824/f166a7c3/attachment.bin 


More information about the mythtv-users mailing list