SCM

[#1011190] Parameter "extra_float_digits" out of range

View Trackers | Bugs | Download .csv | Monitor

Date:
2012-04-26 08:56
Priority:
3
State:
Open
Submitted by:
Oliver Stöneberg (firewave)
Assigned to:
Nobody (None)
Npgsql Version:
2.0.11
Category:
None
Group:
None
Resolution:
None
Summary:
Parameter "extra_float_digits" out of range

Detailed description
After updating to 2.0.1.93 I am getting this error on the first connect:

Additional information: FEHLER: 22023: 3 ist außerhalb des gültigen Bereichs für Parameter »extra_float_digits« (-15 ... 2)

> Npgsql.dll!Npgsql.NpgsqlState.ProcessBackendResponses_Ver_3(Npgsql.NpgsqlConnector context) Line 853 C#
Npgsql.dll!Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() Line 1136 + 0xc bytes C#
Npgsql.dll!Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() Line 1191 + 0x8 bytes C#
Npgsql.dll!Npgsql.ForwardsOnlyDataReader.NextResult() Line 1377 + 0xe bytes C#
Npgsql.dll!Npgsql.ForwardsOnlyDataReader.ForwardsOnlyDataReader(System.Collections.Generic.IEnumerable<Npgsql.IServerResponseObject> dataEnumeration, System.Data.CommandBehavior behavior, Npgsql.NpgsqlCommand command, Npgsql.NpgsqlConnector.NotificationThreadBlock threadBlock, bool synchOnReadError) Line 1040 + 0xb bytes C#
Npgsql.dll!Npgsql.NpgsqlCommand.GetReader(System.Data.CommandBehavior cb) Line 611 + 0x70 bytes C#
Npgsql.dll!Npgsql.NpgsqlCommand.ExecuteBlind() Line 499 + 0xd bytes C#
Npgsql.dll!Npgsql.NpgsqlConnector.Open() Line 836 + 0xa bytes C#
Npgsql.dll!Npgsql.NpgsqlConnectorPool.GetPooledConnector(Npgsql.NpgsqlConnection Connection) Line 436 + 0xa bytes C#
Npgsql.dll!Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(Npgsql.NpgsqlConnection Connection) Line 252 + 0xb bytes C#
Npgsql.dll!Npgsql.NpgsqlConnectorPool.RequestPooledConnector(Npgsql.NpgsqlConnection Connection) Line 202 + 0xb bytes C#
Npgsql.dll!Npgsql.NpgsqlConnectorPool.RequestConnector(Npgsql.NpgsqlConnection Connection) Line 181 + 0xb bytes C#
Npgsql.dll!Npgsql.NpgsqlConnection.Open() Line 543 + 0x16 bytes C#

Followup

Message
Date: 2012-10-30 17:22
Sender: Francisco Figueiredo jr.

Ok. Then you don't have to worry. As I said earlier, this error is caused because Npgsql makes a test trying to set the number of float digits. But only newer servers support 3 and if that fails it fallbacks to 2.
Date: 2012-10-30 17:09
Sender: Oliver Stöneberg

It just appeared in the logs.
Date: 2012-10-30 17:06
Sender: Francisco Figueiredo jr.


Did this error prevent you from connecting to the database or was just an error which appears in logs?

I'm asking that because this error wasn't supposed to give users any trouble. It was just a capability test and shouldn't cause any side effect.
Date: 2012-10-30 17:01
Sender: cyber bird

upgrade to at least 8.5 postgresql, because
SET extra_float_digits=3; is supported from then on.

Also this could be resolved, since it's not a bug in the code itself.
Date: 2012-04-26 08:58
Sender: Oliver Stöneberg

Sorry, I forgot to mention a few things. My previous version
was 2.0.11.92, I am using .NET 3.5 and PostgreSQL 8.4.5.

Attached Files:

Changes:

Field Old Value Date By
summaryParameter "extra_float_digits" out of range2012-04-26 08:58firewave
Powered By FusionForge