Skip to content
This repository has been archived by the owner on Nov 24, 2023. It is now read-only.

the stage of load unit is still running after encountered "Error 1067: Invalid default value for 'ct'" #743

Closed
csuzhangxc opened this issue Jun 16, 2020 · 1 comment · Fixed by #744
Labels
severity/moderate type/bug This issue is a bug report
Milestone

Comments

@csuzhangxc
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.

    1. set NO_ZERO_DATE sql_mode for the downstream TiDB.
    2. create a table with DEFAULT '0000-00-00 00:00:00'
      CREATE TABLE `tbl` (
        `c1` int(11) NOT NULL,
        `ct` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
        PRIMARY KEY (`c1`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    3. load full data of this table into TiDB
  2. What did you expect to see?

    the task paused after encountered Error 1067: Invalid default value for 'ct'

  3. What did you see instead?

    the task still keeping the Running stage.

    "subTaskStatus": [
        {
             "name": "task_single",
             "stage": "Running",
             "unit": "Load",
             "result": null,
             "unresolvedDDLLockID": "",
             "load": {
                    "finishedBytes": "0",
                    "totalBytes": "145",
                    "progress": "0.00 %",
                    "metaBinlog": "(mysql-bin.000001, 957)"
              }
        }
    ],
    
  4. Versions of the cluster

    • DM version (run dmctl -V or dm-worker -V or dm-master -V):

      v1.0.5
      
@csuzhangxc csuzhangxc added the type/bug This issue is a bug report label Jun 16, 2020
@csuzhangxc csuzhangxc added this to the v1.0.6 milestone Jun 16, 2020
@csuzhangxc
Copy link
Member Author

it because no cancel() called in Process so l.wg.Wait() is still waiting for l.PrintStatus.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
severity/moderate type/bug This issue is a bug report
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants