Skip to content

FATAL Error 1205: Lock wait timeout exceeded; try restarting transaction #773

@digdeep126

Description

@digdeep126

Copy: 18942799/18942799 100.0%; Applied: 5207; Backlog: 0/1000; Time: 3h8m10s(total), 3h0m55s(copy); streamer: mysql-bin.001096:428591771; State: migrating; ETA: due
2019-08-03 14:56:43 ERROR Error 1205: Lock wait timeout exceeded; try restarting transaction
2019-08-03 14:56:43 INFO Looking for magic cut-over table
2019-08-03 14:56:43 ERROR Error 1205: Lock wait timeout exceeded; try restarting transaction
2019-08-03 14:56:43 INFO Dropping magic cut-over table
2019-08-03 14:56:43 INFO Dropping table cxxb._btjc01_del
2019-08-03 14:56:43 INFO Table dropped
2019-08-03 14:56:44 INFO Grabbing voluntary lock: gh-ost.45487136.lock
2019-08-03 14:56:44 INFO Setting LOCK timeout as 6 seconds
2019-08-03 14:56:44 INFO Looking for magic cut-over table
2019-08-03 14:56:44 INFO Creating magic cut-over table cxxb._btjc01_del
2019-08-03 14:56:45 INFO Magic cut-over table created
2019-08-03 14:56:45 INFO Locking cxxb.btjc01, cxxb._btjc01_del
Copy: 18942799/18942799 100.0%; Applied: 5207; Backlog: 0/1000; Time: 3h8m15s(total), 3h0m55s(copy); streamer: mysql-bin.001096:428614158; State: migrating; ETA: due
Copy: 18942799/18942799 100.0%; Applied: 5207; Backlog: 0/1000; Time: 3h8m20s(total), 3h0m55s(copy); streamer: mysql-bin.001096:428644772; State: migrating; ETA: due
2019-08-03 14:56:51 ERROR Error 1205: Lock wait timeout exceeded; try restarting transaction
2019-08-03 14:56:51 INFO Looking for magic cut-over table
2019-08-03 14:56:51 ERROR Error 1205: Lock wait timeout exceeded; try restarting transaction
2019-08-03 14:56:51 INFO Dropping magic cut-over table
2019-08-03 14:56:51 INFO Dropping table cxxb._btjc01_del
2019-08-03 14:56:51 INFO Table dropped
2019-08-03 14:56:51 INFO Removing socket file: /tmp/gh-ost.cxxb.btjc01.sock
2019-08-03 14:56:51 INFO Tearing down inspector
2019-08-03 14:56:51 FATAL Error 1205: Lock wait timeout exceeded; try restarting transaction
2019-08-03 14:56:51 INFO Tearing down applier
2019-08-03 14:56:51 INFO Tearing down streamer
2019-08-03 14:56:51 INFO Tearing down throttler
2019-08-03 14:56:51 FATAL Error 1205: Lock wait timeout exceeded; try restarting transaction
[root@mysql01 home]#
[root@mysql01 home]#

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions