BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000

From: neil(at)postgrescompare(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000
Date: 2016-09-02 03:15:51
Message-ID: 20160902031551.15674.67337@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14307
Logged by: Neil Anderson
Email address: neil(at)postgrescompare(dot)com
PostgreSQL version: 9.6beta4
Operating system: Windows 10 Enterprise N (64 bit)
Description:

Hi,

My project queries most of the system catalogs and hit an issue with 9.6rc1
on Windows 10.

Steps to reproduce:
1. Start psql
2. SELECT * from pg_timezone_abbrevs;

Expected:
Data from pg_timezone_abbrevs to be returned

Actual:
ERROR: F0000: time zone abbreviation "novst" is not used in time zone
"Asia/Novosibirsk"

Setting verbose points to line 1750 of datetime.c
https://github.com/postgres/postgres/blob/REL9_6_RC1/src/backend/utils/adt/datetime.c#L1750

Regards,
Neil

Here is the full exception data:
$exception
{Npgsql.PostgresException: F0000: time zone abbreviation "novst" is not used
in time zone "Asia/Novosibirsk"
at Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode
dataRowLoadingMode, Boolean isPrependedMessage)
at Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode
dataRowLoadingMode)
at Npgsql.NpgsqlDataReader.NextResultInternal()
at Npgsql.NpgsqlDataReader.NextResult()
at Npgsql.NpgsqlCommand.Execute(CommandBehavior behavior)
at Npgsql.NpgsqlCommand.ExecuteDbDataReaderInternal(CommandBehavior
behavior)
at ObjectModel.DatabaseModelBuilder.Read(IDbConnection connection,
Action`1 objectCreated, String query, Type typeToCreate) in
C:\Users\eneiand\dev\postgresqlcompare\dotnetcore\src\models\DatabaseModelBuilder.cs:line
102
at ObjectModel.DatabaseModelBuilder.Build(IDbConnection dbConnection) in
C:\Users\eneiand\dev\postgresqlcompare\dotnetcore\src\models\DatabaseModelBuilder.cs:line
86
at IntegrationTests.TestFramework.Utilities.GetDatabases(DatabaseSchema
schemaX, DatabaseSchema schemaY) in
C:\Users\eneiand\dev\postgresqlcompare\dotnetcore\test\integration\testframework\Utilities.cs:line
66
at IntegrationTests.TestFramework.Utilities.GetComparison(DatabaseSchema
schemaX, DatabaseSchema schemaY, String comparisonName) in
C:\Users\eneiand\dev\postgresqlcompare\dotnetcore\test\integration\testframework\Utilities.cs:line
40
at IntegrationTests.Comparison.ColumnComparison.BasicIdenticalTest() in
C:\Users\eneiand\dev\postgresqlcompare\dotnetcore\test\integration\comparison\ColumnComparison.cs:line
14}
BaseMessage: "time zone abbreviation \"novst\" is not used in time zone
\"Asia/Novosibirsk\""
Code: "F0000"
ColumnName: null
ConstraintName: null
Data: Count = 8
DataTypeName: null
Detail: null
File: "datetime.c"
HResult: -2146233088
HelpLink: null
Hint: null
InnerException: null
InternalPosition: 0
InternalQuery: null
Line: "1750"
Message: "F0000: time zone abbreviation \"novst\" is not used in time
zone \"Asia/Novosibirsk\""
MessageText: "time zone abbreviation \"novst\" is not used in time zone
\"Asia/Novosibirsk\""
Position: 0
Routine: "DetermineTimeZoneAbbrevOffsetInternal"
SchemaName: null
Severity: "ERROR"
Source: "Npgsql"
SqlState: "F0000"
StackTrace: " at
Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode dataRowLoadingMode,
Boolean isPrependedMessage)\r\n at
Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode
dataRowLoadingMode)\r\n at
Npgsql.NpgsqlDataReader.NextResultInternal()\r\n at
Npgsql.NpgsqlDataReader.NextResult()\r\n at
Npgsql.NpgsqlCommand.Execute(CommandBehavior behavior)\r\n at
Npgsql.NpgsqlCommand.ExecuteDbDataReaderInternal(CommandBehavior
behavior)\r\n at ObjectModel.DatabaseModelBuilder.Read(IDbConnection
connection, Action`1 objectCreated, String query, Type typeToCreate) in
C:\\Users\\eneiand\\dev\\postgresqlcompare\\dotnetcore\\src\\models\\DatabaseModelBuilder.cs:line
102\r\n at ObjectModel.DatabaseModelBuilder.Build(IDbConnection
dbConnection) in
C:\\Users\\eneiand\\dev\\postgresqlcompare\\dotnetcore\\src\\models\\DatabaseModelBuilder.cs:line
86\r\n at
IntegrationTests.TestFramework.Utilities.GetDatabases(DatabaseSchema
schemaX, DatabaseSchema schemaY) in C:\\Users\\eneiand\\dev\\
postgresqlcompare\\dotnetcore\\test\\integration\\testframework\\Utilities.cs:line
66\r\n at
IntegrationTests.TestFramework.Utilities.GetComparison(DatabaseSchema
schemaX, DatabaseSchema schemaY, String comparisonName) in
C:\\Users\\eneiand\\dev\\postgresqlcompare\\dotnetcore\\test\\integration\\testframework\\Utilities.cs:line
40\r\n at
IntegrationTests.Comparison.ColumnComparison.BasicIdenticalTest() in
C:\\Users\\eneiand\\dev\\postgresqlcompare\\dotnetcore\\test\\integration\\comparison\\ColumnComparison.cs:line
14"
Statement: {SELECT abbrev, utc_offset, is_dst FROM pg_timezone_abbrevs
}
TableName: null
Where: null

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Anderson 2016-09-02 03:46:39 Re: BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000
Previous Message Spencer Thomason 2016-09-01 18:34:51 Re: BUG #14295: Hot standby crash during tsvector rebuild