zhongliangkang

check if the ghost table got some data lost? ref to bugs : #887 #1038 #1039

Meet the same problem :( Nice fix! A question for the fix: If the `insert` is not the max/min ID, or it's a `update` ,data may lost too?

> @wukongHH > > > session 3: rename table a to _a_del,_a_gho to a; > > when does this statement run? In `gh-ost`, this statement only runs _after_ `_gho` table...

> I'm meanwhile curious: who would be reading from `_a_gho`? This table is unknown to anyone outside `gh-ost` itself or the engineer that runs the migration. -- DB manage program...

> Thank you, I will look into it. > > I'm meanwhile curious: who would be reading from `_a_gho`? This table is unknown to anyone outside `gh-ost` itself or the...

> I can confirm I get the same behavior as yours, but something's strange here: > > At first I thought this might be related to the fact your table...

> from https://dev.mysql.com/doc/refman/5.7/en/rename-table.html: > > > Renaming operations are performed left to right > > > Metadata locks on tables are acquired in name order, which in some cases can...

Thanks for your solutions 👍 -- I had discussed the short term solution with @shatianjiang , maybe there is still exists risk of lost data when there got a table...

> Yes. Even if no query on the _gho table, data may lost, add a query make it easy to reproduce. We fix it by add 'zz' prefix temporary.. #987...