Invalid time zone (+08). Falling back to displacement [CORE6520]

[firebird-automations]

Submitted by: Basil A. Sidorov (basid)

CentOS Linux release 7.9.2009 (Core)
LI-V4.0.0.2390 Firebird 4.0 Release Candidate 1
--
ls -lhF /opt/firebird/tzdata/
total 244K
-r--r--r--. 1 root root 41K Mar 22 09:32 metaZones.res
-r--r--r--. 1 root root 20K Mar 22 09:32 timezoneTypes.res
-r--r--r--. 1 root root 23K Mar 22 09:32 windowsZones.res
-r--r--r--. 1 root root 153K Mar 22 09:32 zoneinfo64.res
--
timedatectl status
Local time: Mon 2021-03-22 17:04:57 +08
Universal time: Mon 2021-03-22 09:04:57 UTC
RTC time: Mon 2021-03-22 09:04:57
Time zone: Asia/Irkutsk (+08, +0800)
NTP enabled: n/a
NTP synchronized: no
RTC in local TZ: no
DST active: n/a

firebird.log:
--
vm-centos-7.local Mon Mar 22 17:05:23 2021
/opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird

vm-centos-7.local Mon Mar 22 17:05:23 2021
Invalid time zone (+08). Falling back to displacement.
--

Commits: 73a26f6

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

CentOS 7 is fully updated (yum update and reboot before install FB).
Currently installed:
libicu.x86_64 50.2-4.el7_7 @base

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: @asfernandes

Does firebird.conf have any custom DefaultTimeZone config?

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

Firebird only installed without any configuration, but ...

System info: tzdata.noarch 2021a-1.el7 @updates

Firebird info:
DATABASE_VERSION 2018e
RDB$TIME_ZONE_ID 65260
RDB$TIME_ZONE_NAME Asia/Irkutsk
RDB$START_TIMESTAMP 2014-10-25 17:00:00.0000 GMT
RDB$END_TIMESTAMP 9999-12-31 23:59:59.9999 GMT
RDB$ZONE_OFFSET 480
RDB$DST_OFFSET 0
RDB$EFFECTIVE_OFFSET 480

[firebird-automations]

Commented by: @asfernandes

Tzdata version from RC1 should be 2021a.

Why your is 2018e?

Did you queries with select rdb$time_zone_util.database_version() from rdb$database ?

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

Yes, "Firebird info" - is result of select from firebird system table.
No, I don't know why "system info" (yum -C list tzdata) is different from "Firebird info".

[firebird-automations]

Commented by: @asfernandes

Do you have ICU_TIMEZONE_FILES_DIR environment variable set?

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

Yes:
strings /proc/`pgrep firebird`/environ
LANG=en_US.UTF-8
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
HOME=/opt/firebird
LOGNAME=firebird
USER=firebird
SHELL=/sbin/nologin
ICU_TIMEZONE_FILES_DIR=/opt/firebird/tzdata

[firebird-automations]

Commented by: @asfernandes

Please show exactly file sizes in bytes of files present in /opt/firebird/tzdata/

Also, what is the result if you remove that env. var. (and reboot)?

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

ls -l /opt/firebird/tzdata/
total 244
-r--r--r--. 1 root root 41824 Mar 22 09:32 metaZones.res
-r--r--r--. 1 root root 20112 Mar 22 09:32 timezoneTypes.res
-r--r--r--. 1 root root 22592 Mar 22 09:32 windowsZones.res
-r--r--r--. 1 root root 155808 Mar 22 09:32 zoneinfo64.res

ICU_TIMEZONE_FILES_DIR is automatically set by firebird, not in unit:
--
sudo systemctl cat firebird
#⁠ /usr/lib/systemd/system/firebird.service
[Unit]
Description=Firebird Database Server
After=syslog.target network.target

[Service]
User=firebird
Group=firebird
Type=forking
ExecStart=/opt/firebird/bin/fbguard -daemon -forever
StandardError=syslog

[Install]
WantedBy=multi-user.target
--
and not set for fbguard:
sudo strings /proc/`pgrep fbguard`/environ
LANG=en_US.UTF-8
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
HOME=/opt/firebird
LOGNAME=firebird
USER=firebird
SHELL=/sbin/nologin

[firebird-automations]

Commented by: @asfernandes

Does the problem happens both with localhost protocol and embedded?

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

Local protocol - not applicable: process firebird started already and message already written.

Embedded - yes, but only on very first open of any database.
-- tzchk.sql
set list;
set echo off;
shell top -u firebird -bn1; -- show process list
shell cat /dev/null > firebird.log; -- log truncate
shell date; -- just timestamp
shell printenv|grep ICU; -- check ICU_TIMEZONE_FILES_DIR envvar
shell tail firebird.log; -- should be no output

connect 'employee' user sysdba; commit;
shell tail firebird.log; -- should be "Invalid time zone (+08). Falling back to displacement."

select rdb$time_zone_util.database_version() from rdb$database;
select * from RDB$TIME_ZONES where RDB$TIME_ZONE_NAME = 'Asia/Irkutsk';
select * from rdb$time_zone_util.transitions('Asia/Irkutsk', timestamp '2020-01-01', timestamp '2021-01-01');
commit;
exit;

-- output on my system (some empty line insterted and removed for better formatting)
-- sudo su -s /bin/sh - firebird -c "bin/isql -q -z -b -i tzchk.sql"
ISQL Version: LI-V4.0.0.2390 Firebird 4.0 Release Candidate 1

top - 17:30:13 up 36 min, 1 user, load average: 0.05, 0.03, 0.05
Tasks: 102 total, 1 running, 101 sleeping, 0 stopped, 0 zombie
%Cpu(s): 7.1 us, 7.1 sy, 0.0 ni, 85.7 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 2047036 total, 1771284 free, 147332 used, 128420 buff/cache
KiB Swap: 2559996 total, 2559996 free, 0 used. 1755684 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1289 firebird 20 0 161972 2036 1452 R 16.7 0.1 0:00.19 top
1274 firebird 20 0 133892 2316 1876 S 0.0 0.1 0:00.19 isql

Thu Mar 25 17:30:13 +08 2021

ICU_TIMEZONE_FILES_DIR=/opt/firebird/tzdata

Server version:
LI-V4.0.0.2390 Firebird 4.0 Release Candidate 1

vm-centos-7.local Thu Mar 25 17:30:13 2021
Invalid time zone (+08). Falling back to displacement.

DATABASE_VERSION 2018e

RDB$TIME_ZONE_ID 65260
RDB$TIME_ZONE_NAME Asia/Irkutsk

RDB$START_TIMESTAMP 2014-10-25 17:00:00.0000 GMT
RDB$END_TIMESTAMP 9999-12-31 23:59:59.9999 GMT
RDB$ZONE_OFFSET 480
RDB$DST_OFFSET 0
RDB$EFFECTIVE_OFFSET 480

[firebird-automations]

Commented by: Basil A. Sidorov (basid)

If change time zone on Europe/Moscow - message "Invalid timezone ..." are disappear, but Firebird tzdb version not changed (2018e).

[firebird-automations]

Commented by: @asfernandes

How did you install libncurses.6 in CentOS 7?

I'm trying to test with docker, but was not able to install it.

With docker and CentOS 8 I had no problem.

[firebird-automations]

Commented by: @asfernandes

Looks like ICU 50 is too old and cannot open tzdata present in firebird.

You should probably update it if possible.