RSS Feed/News mariadb-dump: Error 1412: Table definition has changed

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
24,697
Points
823

Reputation:

I have an OS cron job that takes a backup of my XF database every day. This has worked flawlessly from the beginning.

However, today the cron job ran into an error which has made me concerned:
mariadb-dump: Error 1412: Table definition has changed, please retry transaction when dumping table xf_thread_view at row: 0
Click to expand...

This seems to imply that the table definition was changed while the backup was running. I believe this could be caused by either an "ALTER TABLE" or a "TRUNCATE" SQL...

Read more

Continue reading...
 
Status
Not open for further replies.
Top