全量迁移或同步期间DRS任务报错,日志提示信息:service DATAMOVE failed, cause by: apply event=[type=table_rename_or_copy, index=null, schema_name=%s, object_name=%s] occur error, msg=rename table %s. %s error: Table '%s ' already exists。
Local temp table object_id values are negative. On the other hand global temporary tables have positive object_id values So to summarize, the correct way of creating a DROP IF EXISTS script should be as follows for temp tables. if object_id('tempdb..#TestTable','U') is not null drop ...
Msg 2714, Level 16, State 5, Line 1 There is already an object named 'PK_#tmp' in the database. Msg 1750, Level 16, State 1, Line 1 Could not create constraint or index. See previous errors. The problem arises from the fact that while the temp table name is unique, the constra...
Msg 2714, Level 16, State 5, Line 1 There is already an object named 'PK_#tmp' in the database. Msg 1750, Level 16, State 1, Line 1 Could not create constraint or index. See previous errors. The problem arises from the fact that while the temp table name is unique, the constra...
Msg 2714, Level 16, State 5, Line 1 There is already an object named 'PK_#tmp' in the database. Msg 1750, Level 16, State 1, Line 1 Could not create constraint or index. See previous errors. The problem arises from the fact that while the temp table name is unique, the constra...
Msg 2714, Level 16, State 5, Line 1 There is already an object named 'PK_#tmp' in the database. Msg 1750, Level 16, State 1, Line 1 Could not create constraint or index. See previous errors. The problem arises from the fact that while the temp table name is unique, the constra...
/* Check if table already exists */ if ((create_info->options & HA_LEX_CREATE_TMP_TABLE) && find_temporary_table(thd, db, table_name)) { // 如果找到重名的表,那么执行这里的错误处理代码(非原注释) } ...1.2.3.4.5.6.7.8. 在上面这段代码中我们又看到了一个关键函数find_temporary_table(...
全量迁移或同步期间DRS任务报错,日志提示信息:service DATAMOVE failed, cause by: apply event=[type=table_rename_or_copy, index=null, schema_name=%s, object_name=%s] occur error, msg=temp table: %s.%s not exist 可能原因 无主键表结构迁移异常。
157AE4BCFD41976D' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; -- new object type path: SCHEMA_EXPORT/SYSTEM_GRANT GRANT UNLIMITED TABLESPACE TO "LHR"; -- new object type path: SCHEMA_EXPORT/ROLE_GRANT GRANT "DBA" TO "LHR"; -- new object type path: SCHEMA_EXPORT/DEFAULT_...
I have just ran the repro steps, in case you won't bother to do it :) Using the same repro steps, and this is the result for 5.7.29. 1. innodb_buffer_pool_size = 256G 2. Create and fill about 50G temp table with configuration | innodb_io_capacity | 100 | | innodb_io_capacit...