search

artlife3 / dazed-confused-vagrant-vm

MIT License
3 stars 0 forks source link

Timezone is not set in Mysql error #28

Closed artlife3 closed 7 years ago

artlife3 commented 7 years ago 
[mysqld]
default-time-zone = 'Asia/Tokyo'
slow_query_log = 1
log_output = FILE
slow_query_log_file = /var/log/mysqld/slow_query.log
long_query_time = 1
log_queries_not_using_indexes = 1
query_cache_size = 32M
artlife3 commented 7 years ago

With slow query log setting

artlife3 commented 7 years ago

Unsolved

Variable 'time_zone' can't be set to the value of 'NULL'
Variable 'sql_mode' can't be set to the value of 'NULL'
Variable 'foreign_key_checks' can't be set to the value of 'NULL'
Variable 'unique_checks' can't be set to the value of 'NULL'
Variable 'character_set_client' can't be set to the value of 'NULL'
Variable 'collation_connection' can't be set to the value of 'NULL'
Variable 'sql_notes' can't be set to the value of 'NULL'
artlife3 commented 7 years ago

This was not a bug. MySQL import It is an error that occurred because the tested data was too large. I should restore it because these should be ansible.