[MYSQL案例][013] mysqldump报错 Error 1412: Table definition has changed

14:57:58 [root@ddcw21 ~]#mysqldump -h127.0.0.1 -P3314 -p123456 --all-databases --single-transaction --master-data --quick > alldb_t20230811.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. 
mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table `t20230811_0` at row: 0

import pymysql
def runsql(conn,sql):
	cursor = conn.cursor()
	cursor.execute(sql)
	data = cursor.fetchall()
	cursor.close()
	
conn = pymysql.connect(
			host='127.0.0.1',
			port=3314,
			user='root',
			password='123456',
			)


while True:
	for table_n in range(10):
		table_name=f'db1.t20230811_{table_n}'
		ddl = f'create table if not exists {table_name}(id int, name varchar(20));'
		runsql(conn,ddl)
		for i in range(1000):
			runsql(conn,f'insert into {table_name} values({i},"aa")')
			runsql(conn,'commit')
		for i in range(1001,2000):
			runsql(conn,f'insert into {table_name} values({i},"aa")')
			runsql(conn,'commit')
	for table_n in range(10):
		table_name=f'db1.t20230811_{table_n}'
		runsql(conn,f'drop table {table_name}')