BUG #12858: Server crash on upgrade due to invalid timezoneset syntax
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
````
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The server does work when restarted. I was looking at this more from the
perspective of it being unexpected/undocumented behavior for a minor
version upgrade.
Thank you for the tips on the re-index.
On Thu, Mar 12, 2015 at 4:19 PM, John R Pierce <pierce@hogranch.com> wrote:
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
--
*Tyler Poland* | Data Support Lead | w: (415) 624-8448 | s: tyler.poland
| t: @tylerpoland
[image: Inline image 1]