Launchpad itself

Mantic PPA builder tzdata symlink access problem

Asked by WiltonDB Software

I am building 2 identical (same orig source and build scripts) builds of PostgreSQL on Mantic and on Lunar. Lunar is built successfully, but on Mantic one of the PostgreSQL tests is failing: "sysviews" test is failing with a message "time zone "Pacific/Enderbury" not recognized".

I've dig it inside the Postgres, this test is trying to read "pg_timezone_abbrevs" system view that loads all timezones from system tzdata files. It currently looks to me that Postgres server running under the builder user for some reason cannot successfully read "/usr/share/zoneinfo/Pacific/Enderbury" symlink. It can read non-symlink files in the same directory successfully (otherwise this test will fail on loading the first timezone). I cannot reproduce the problem on Mantic locally - all tests from this exact package are passing for me.

Lunar successful build: https://launchpad.net/~wiltondb/+archive/ubuntu/wiltondb/+build/26759688
Mantic failed build: https://launchpad.net/~wiltondb/+archive/ubuntu/wiltondb/+build/26759686

Question information

Language:
English Edit question
Status:
Solved
For:
Launchpad itself Edit question
Assignee:
No assignee Edit question
Solved by:
William Grant
Solved:
Last query:
Last reply:
Revision history for this message
Best William Grant (wgrant) said : 		#1

mantic's tzdata doesn't have Pacific/Enderbury; it was renamed to Pacific/Kanton in Debian's tzdata 2022g-2. A symlink from the old name is still available in the tzdata-legacy package, which is probably why it works for you locally. postgresql-15 in Debian now Build-Depends on tzdata-legacy.

Revision history for this message
WiltonDB Software (wiltondb) said : 		#2

Thanks William Grant, that solved my question.

Revision history for this message
WiltonDB Software (wiltondb) said : 		#3

Thanks for details! This explains the problem, yes I had tzdata-legacy inadvertently installed in local Mantic.

Revision history for this message
Sergey Ponomarev (stokito) said : 		#5

I had a problem when connected from IntelliJ Idea and Goland to a local Postgresql:
"This time zone name appears in the configuration phot"

From psql I tried to get list of timezones:

select * from pg_timezone_abbrevs;
ERROR: time zone "Pacific/Enderbury" not recognized
DETAIL: This time zone name appears in the configuration file for time zone abbreviation "phot".

I copied the Kanton tz into Enderbury with:
sudo cp /usr/share/zoneinfo/Pacific/Kanton /usr/share/zoneinfo/Pacific/Enderbury

Then it worked. Thank you William for the solution