[MDEV-10068] Invalid datetime format: 1292 Incorrect datetime value: '2011-03-27 02:47:26' - Jira

XML

Word

Printable

After run a seeder for create 75000 users, after several minutes (almost 7000 users inserts on table with any problem,my app get a exception below.

[Illuminate\Database\QueryException]

  SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2008-03-30 02:56:12' for column 'created_at' at row 1 (S

  QL: insert into `users` (`type`, `name`, `email`, `nick`, `password`, `vat`, `address`, `zipcode`, `city`, `state`, `country`, `cr

  eated_at`, `updated_at`) values (customer, Adrian Santos, qpuig@live.com, rzavala12, y$Veqd2mkgRHtl6VKtYBV0yey77tVLo34.6THXqhtGRwg

  /Ea73/FhlK, 02058805Y, Plaça Abril, 85, 96º D, 44824, Vargas de San Pedro, 57431, San Roig, Huesca, ES, 2008-03-30 02:56:12, 2008-

  03-30 02:56:12))

Datetime value it's correct and same for others 7000, 8000 users create with before INSERTS

Try several options such:

MariaDB [(none)]> select @@GLOBAL.sql_mode;

+------------------------+

| @@GLOBAL.sql_mode      |

+------------------------+

| NO_ENGINE_SUBSTITUTION |

+------------------------+

relates to

MDEV-29696 uhelpful error message for timedate in the DST non-existing hour

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.