Hi everyone,
after upgrading from Bacula 7.5.7 to 9.0.1 in my test environment, I
encountered the same issue after running the "update_mysql_tables"
script. Beside removing NO_ZERO_IN_DATE and NO_ZERO_DATE I also had to
remove STRICT_TRANS_TABLES from the SQL mode.
The MySQL version I use is 5.7.13
mysql> show variables like "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 5.7.13 |
| protocol_version | 10 |
| slave_type_conversions | |
| tls_version | TLSv1,TLSv1.1 |
| version | 5.7.13-log |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | sparc |
| version_compile_os | solaris11 |
+-------------------------+------------------------------+
with these settings:
[mysqld]
basedir=/opt/mysql
datadir=/data/mysql
bind_address=Ip.Address.Of.Zone
collation_server=utf8_general_ci
character_set_server=utf8
slow_query_log=1
slow_query_log_file=/logs/mysql/slow_queries
log_error=/logs/mysql/error
explicit_defaults_for_timestamp=TRUE
skip-external-locking
skip-innodb_doublewrite
Regards,
Daniel
Am 17.07.17 um 00:15 schrieb Phil Stracchino:
On 07/16/17 15:11, Kern Sibbald wrote:
Hello Phil,
According to the documentation in both MySQL and MariaDB, I can use
"0000-00-00 00:00:00".
Yes - prior to MySQL 5.7, or if you change MySQL 5.7's default SQL_MODE.
The default SQL_MODE in 5.7 includes NO_ZERO_DATE,NO_ZERO_IN_DATE.
Remove those, and it'll work just fine in MySQL 5.7.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|