ERROR: system_time_zone is not modifiable at startup

Help
1

Hello there,

I tried to modify system_time_zone variable via memsqlctl update config. It updated memsql.cnf normally. Got ERROR: Thread -1: main: Global variable @@system_time_zone is not modifiable at startup.

It happens when updated back to default UTC. Only resolution is to delete it from the configs, then MemSQL starts.
system_time_zone = UTC
system_time_zone = Europe/Brussels both fails.

Does anybody have this problem?

2

What do you mean by this?

It happens when updated back to default UTC

3

Sorry that part made no sense. So, the error also appeared when we set system_time_zone to UTC (that’s the default). So, in other words, if system_time_zone parameter was set to any value in the memsql.cnf file, we had “ERROR: Thread -1: main: Global variable @@system_time_zone is not modifiable at startup” error. If we get rid of the setting, MemSQL started normally.

4

You should never try to change system_time_zone directly. You can set time_zone but beware, that is a NOOP; it’s only allowed so as not to break some apps that set it that were built for MySQL.

If you really want to change your time zone, change it at the OS level or change the config variable default_time_zone. This post covers it:

We’re in the process of documenting some of this better.

1 Like