On Wednesday, August 17, 2016 at 12:03:28 AM UTC+2, Tilman Glotzner wrote: The deadlock I could overcome by removing NO_ZERO_DATE and NO_ZERO_IN_DATE in the sql_mode variable -- probably this will not be really sustainable as NO_ZERO_DATE and NO_ZERO_IN_DATE are depreciated and will become part of the strict mode in future release of mysql. For now it seems to work however:
1) To see the current setting of the sql_mode variable: SELECT @@GLOBAL.sql_mode; In my case, this is: 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_DATE, NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' 2) then I set the variable new, but without NO_ZERO_DATE and NO_ZERO_IN_DATE SET GLOBAL sql_mode= 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; Regards Tilman -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
