Slave Hangup on Federated Tables

Bug #1533226 reported by Chodorenko
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
New
Undecided
Unassigned

Bug Description

 i have trouble which slave on percona server
on my master server present Federated table view_sessions (ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='mysql://LOGIN:PASS@localhost/db/catnew_prices')

i create dump by extra backup, transver to different server and create slave
slave start and go to 'mysql-bin.000219' at position 609823535

in this position
UPDATE view_sessions SET atime = '1455077774', sdata = 'forum_key|s:32:\"bce9a16e23efe360d6ad7b4d5a229b38\";XSS_HASH|s:32:\"46da84548e5ee74422b8374d9522433f\";user_mode_admin|b:0;forum_login|s:5:\"22217\";', ip = '178.121.240.181', visits = visits + 1 WHERE id = '7dmhv9qv9mtj37epst1ieooq47'

and mysql hangup

in server 10 gb memory and This can cause problems

Revision history for this message
Chodorenko (chodorenko) wrote :
Revision history for this message
Chodorenko (chodorenko) wrote :

 Server version: 5.6.28-76.1-log Percona Server (GPL), Release 76.1, Revision 5759e76
i try on debian 8 and centos 6 and 7 , and retrive one result

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3357

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.