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

do not auto resume for "Error 1366" error #921

Closed
csuzhangxc opened this issue Aug 24, 2020 · 4 comments · Fixed by #977
Closed

do not auto resume for "Error 1366" error #921

csuzhangxc opened this issue Aug 24, 2020 · 4 comments · Fixed by #977
Labels
help wanted This issue wanted some help from contributor severity/major type/bug This issue is a bug report

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.

  2. What did you expect to see?

  3. What did you see instead?

    Incorrect datetime value: '466261494-02-09 03:09:21' for column 'c2' at row 1"

    [2020/08/24 15:33:20.353 +08:00] [INFO] [task_checker.go:350] ["dispatch auto resume task"] [component="task checker"] [task=task_single]

  4. Versions of the cluster

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

      v2.0.0-rc
      
@csuzhangxc csuzhangxc added type/bug This issue is a bug report help wanted This issue wanted some help from contributor labels Aug 24, 2020
@lance6716
Copy link
Collaborator

How could generate "Incorrect datetime value: '466261494-02-09 03:09:21' for column 'c2' at row 1" 🤔

@csuzhangxc
Copy link
Member Author

😂 this value was generated by a MariaDB with a different time binary format with MySQL.

more error messages will exist for Error 1366, maybe you can use.

@lance6716
Copy link
Collaborator

can't imitate using newer MariaDB and mysql56_temporal_format = OFF. MariaDB 10.0 is hard to find a macOS/docker version 😢 can't manual test that PR

@csuzhangxc
Copy link
Member Author

MariaDB 10.0 is hard to find a macOS/docker version 😢 can't manual test that PR

I installed a Windows version last time... that's OK even lacking manual test.

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

Successfully merging a pull request may close this issue.

3 participants