Thread: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax
BUG #12858: Server crash on upgrade due to invalid timezoneset syntax
From
tpoland@engineyard.com
Date:
The following bug has been logged on the website:
Bug reference: 12858
Logged by: Tyler Poland
Email address: tpoland@engineyard.com
PostgreSQL version: 9.1.15
Operating system: Gentoo Linux
Description:
Immediately after upgrading from 9.1.9 to 9.1.15 the server (still running
9.1.9) crashes with the error:
2015-03-12 18:39:55.585 UTC,,,13721,,5500d157.3599,9,,2015-03-11 23:35:51
UTC,,0,FATAL,22023,"invalid number for time zone offset in time zone file
""Default"", line 57",,,,,,,,,""
Reviewing the Default timezoneset file reveals that it has changed from:
````
### Before
ART -10800 # Argentina Time
# (America/Argentina/Buenos_Aires)
# (America/Argentina/Cordoba)
# (America/Argentina/Tucuman)
# (America/Argentina/La_Rioja)
# (America/Argentina/San_Juan)
# (America/Argentina/Jujuy)
# (America/Argentina/Catamarca)
# (America/Argentina/Mendoza)
# (America/Argentina/Rio_Gallegos)
# (America/Argentina/Ushuaia)
ARST -7200 D # Argentina Summer Time
````
To
````
ART America/Argentina/Buenos_Aires # Argentina Time
# (America/Argentina/Buenos_Aires)
# (America/Argentina/Cordoba)
# (America/Argentina/Tucuman)
# (America/Argentina/La_Rioja)
# (America/Argentina/San_Juan)
# (America/Argentina/Jujuy)
# (America/Argentina/Catamarca)
# (America/Argentina/Mendoza)
# (America/Argentina/Rio_Gallegos)
# (America/Argentina/Ushuaia)
ARST America/Argentina/Buenos_Aires # Argentina Summer Time
````
On 3/12/2015 1:08 PM, tpoland@engineyard.com wrote: > Immediately after upgrading from 9.1.9 to 9.1.15 the server (still running > 9.1.9) crashes with the error: > > 2015-03-12 18:39:55.585 UTC,,,13721,,5500d157.3599,9,,2015-03-11 23:35:51 > UTC,,0,FATAL,22023,"invalid number for time zone offset in time zone file > ""Default"", line 57",,,,,,,,,"" > > Reviewing the Default timezoneset file reveals that it has changed does the server work when you restart it? replacing files of a running service is always a sketchy thing. you should also read the release notes for 9.1.15, .14, and .11 as there are issues which may need addressing via REINDEX and such, if you use certain index types. http://www.postgresql.org/docs/current/static/release-9-1-11.html http://www.postgresql.org/docs/current/static/release-9-1-14.html http://www.postgresql.org/docs/current/static/release-9-1-15.html -- john r pierce 37N 122W somewhere on the middle of the left coast