[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