[Firebird-net-provider] log filled with INET error 10054

[Rick Roen]

Firebird server v 2.1.17910

FirebirdClient.dll v 2.1.0.0

Vista Pro



My firebird.log file is filled with hundreds entries like:

RICK2008 (Server) Sat Dec 27 13:21:07 2008

INET/inet_error: read errno = 10054



My connection string is:

initial catalog=???;user id=Sysdba;password=masterkey;role
name=Full_Access;data source=localhost;pooling=True;max pool size=100;min
pool size=10;packet size=8192;dialect=3



I see that this error is from a dropped connection, however since I am using
my local Firebird server in a test environment (data source=localhost), I
don't know how this can be.



I looked at a clients firebird log that has thousands of the same entries.



This appears to have started when I upgraded to Firebird server v 2.1.17910



When I clear the log and run a simple quick program that logs into the
database, there are maybe 7 new entries like above. If I do selects, etc,
more entries are added, although all selects/updates/inserts run with no
problem. There are no other entries in the log.



When I execute selects/updates/inserts from DBWorkbench, a utility program,
there are no entries into the log.



Any idea why this is happening?



Regards,



Rick

[Pham Huu Le Quoc Phuc]

I get lastest source code FB.net 2.5 and build, it can't create database in
Embedded Server.

[Pham Huu Le Quoc Phuc]

I get lastest source code FB.net 2.5 and build, it can't create database in
Embedded Server.



_____

From: Rick Roen [mailto:***@LakeValleySeed.com]
Sent: Sunday, December 28, 2008 02:39
To: firebird-net-***@lists.sourceforge.net
Subject: [Firebird-net-provider] log filled with INET error 10054



Firebird server v 2.1.17910

FirebirdClient.dll v 2.1.0.0

Vista Pro



My firebird.log file is filled with hundreds entries like:

RICK2008 (Server) Sat Dec 27 13:21:07 2008

INET/inet_error: read errno = 10054



My connection string is:

initial catalog=???;user id=Sysdba;password=masterkey;role
name=Full_Access;data source=localhost;pooling=True;max pool size=100;min
pool size=10;packet size=8192;dialect=3



I see that this error is from a dropped connection, however since I am using
my local Firebird server in a test environment (data source=localhost), I
don't know how this can be.



I looked at a clients firebird log that has thousands of the same entries.



This appears to have started when I upgraded to Firebird server v 2.1.17910



When I clear the log and run a simple quick program that logs into the
database, there are maybe 7 new entries like above. If I do selects, etc,
more entries are added, although all selects/updates/inserts run with no
problem. There are no other entries in the log.



When I execute selects/updates/inserts from DBWorkbench, a utility program,
there are no entries into the log.



Any idea why this is happening?



Regards,



Rick

[Jiri Cincura]

HI, I'll look at it. Maybe some protocol problems.

[Pham Huu Le Quoc Phuc]

I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create
database in Embbedded mode. But it can't. Please help me.
Thanks

[Dean Harding]

Post by Pham Huu Le Quoc Phuc
I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create
database in Embbedded mode. But it can't. Please help me.

You haven't described the problem. HOW do you try to create a database using
the FbBatchScript (please provide the code you're using). HOW does it fail?
Does it produce an error message (if so, what does the error say)? Does it
simply do nothing and no database is created? Something else?

Lastly, with the embedded server, you need to use
FbConnection.CreateDatabase to actually create the database file, and then
you can use FbBatchScript to populate it with tables/sproc/etc.

Dean.

[Pham Huu Le Quoc Phuc]

I think, FbBatchScript not support CREATE DATABASE in Embedded Server?

-----Original Message-----
From: Dean Harding [mailto:***@dload.com.au]
Sent: Monday, January 05, 2009 13:33
To: 'For users and developers of the Firebird .NET providers'
Subject: Re: [Firebird-net-provider] FbBatchScript can't CREATE DATABASEin
Embedded server

Post by Pham Huu Le Quoc Phuc
I get lastest Fb.Net 2.5 and build it. I try to use FbBatchScript to create
database in Embbedded mode. But it can't. Please help me.

You haven't described the problem. HOW do you try to create a database using
the FbBatchScript (please provide the code you're using). HOW does it fail?
Does it produce an error message (if so, what does the error say)? Does it
simply do nothing and no database is created? Something else?

Lastly, with the embedded server, you need to use
FbConnection.CreateDatabase to actually create the database file, and then
you can use FbBatchScript to populate it with tables/sproc/etc.

Dean.



----------------------------------------------------------------------------
--

[Dean Harding]

Post by Pham Huu Le Quoc Phuc
I think, FbBatchScript not support CREATE DATABASE in Embedded Server?

Right. As I said, the embedded server works on database files directly, so
you need to create the database with FbConnection.CreateDatabase. You can
still use FbBatchScript to populate the database with tables and so on.

Dean.

[Jiri Cincura]

Post by Dean Harding

Post by Pham Huu Le Quoc Phuc
I think, FbBatchScript not support CREATE DATABASE in Embedded Server?

Right. As I said, the embedded server works on database files directly, so
you need to create the database with FbConnection.CreateDatabase. You can
still use FbBatchScript to populate the database with tables and so on.

FbBatchExecution is in fact internally calling
FbConnection.CreateDatabase, but there's no way to tell thru standard
command:
// CREATE {DATABASE | SCHEMA} 'filespec'
// [USER 'username' [PASSWORD 'password']]
// [PAGE_SIZE [=] int]
// [LENGTH [=] int [PAGE[S]]]
// [DEFAULT CHARACTER SET charset]
// [<secondary_file>];
that it should use embedded server, so it will use isc_create_database
from fbembed.dll.

What comes to my mind - but not tested, just guess that it may work -
is to provide dummy connection string with ServerType=1. Then maybe
the create database isql command will not rewrite the ServerType so it
will be done using embedded server.

[Jiri Cincura]

Post by Dean Harding
You haven't described the problem. HOW do you try to create a database using
the FbBatchScript (please provide the code you're using). HOW does it fail?
Does it produce an error message (if so, what does the error say)? Does it
simply do nothing and no database is created? Something else?

Dean is right. Without any further info is this just ... useless. No
description, no fix.

[Rick Roen]

Did you have a chance to look at this yet?

Rick

-----Original Message-----
From: Jiri Cincura [mailto:***@cincura.net]
Sent: Saturday, January 03, 2009 4:16 PM
To: ***@lakevalleyseed.com; For users and developers of the Firebird .NET
providers
Subject: Re: [Firebird-net-provider] log filled with INET error 10054

HI, I'll look at it. Maybe some protocol problems.

[Jiri Cincura]

Post by Rick Roen
Did you have a chance to look at this yet?

Not yet. I'm working now on new FB2.1 protocol. I'll check the problem
during next week, together with protocol work.

[Jiri Cincura]

Post by Rick Roen
Did you have a chance to look at this yet?

Hi I looked into this with my latest build, and the problem is gone. I
don't know what changed (I had these errors in log too, but I thought
that's because of killing apps during debug), but it's not there
anymore. :) Maybe I've fixed by accident (LOL "fixed by accident")
something together with work on FB2.1 protocol. :)

Anyway, to be sure, can you grab latest weekly build and try?

[Jiri Cincura]

OK I'm not so lucky. :) The problem is in connection pooling that was
turned off on my connection string. I'll look at the problem.

[nieurig]

Post by Jiri Cincura
OK I'm not so lucky. :) The problem is in connection pooling that was
turned off on my connection string. I'll look at the problem.

Well,
I got this error too, only when pooling is set to true.
Depends on the firebird server-type I get

INET/inet_error: read errno = 10054
or
XNET error (xnet:2044) connection lost: another side is dead

Searching on web I found this
http://tracker.firebirdsql.org/browse/CORE-1196

I thought it is a firebird problem ?
Best wishes.
Niels

[Jiri Cincura]

Post by nieurig
I thought it is a firebird problem ?

No it's a problem in FirebirdClient. I've fixed it. Tomorrow I'll commit fix.

[Mercea Paul]

Post by Jiri Cincura
OK I'm not so lucky. :) The problem is in connection pooling that was
turned off on my connection string. I'll look at the problem.

[PM]
This error is related to http://tracker.firebirdsql.org/browse/DNET-156 to
or is something new?

Regards,
Paul

[Jiri Cincura]

Post by Mercea Paul
This error is related to http://tracker.firebirdsql.org/browse/DNET-156 to
or is something new?

It's something different. :)

[Jiri Cincura]

Should be fixed now. You can check weekly build.

[Pham Huu Le Quoc Phuc]

I use FB 2.1.2 Embedded server, FB.Net Provider 2.5 Beta 2, our program
thown following bug:



Csla.DataPortalException: DataPortal.Update failed (System.FormatException:
Input string was not in a correct format.

at System.Number.StringToNumber(String str, NumberStyles options,
NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberStyles style,
NumberFormatInfo info)

at System.String.System.IConvertible.ToInt32(IFormatProvider provider)

at System.Convert.ChangeType(Object value, Type conversionType,
IFormatProvider provider)

at System.Data.XSDSchema.HandleElementColumn(XmlSchemaElement elem,
DataTable table, Boolean isBase)

at System.Data.XSDSchema.HandleParticle(XmlSchemaParticle pt, DataTable
table, ArrayList tableChildren, Boolean isBase)

at System.Data.XSDSchema.HandleComplexType(XmlSchemaComplexType ct,
DataTable table, ArrayList tableChildren, Boolean isNillable)

at System.Data.XSDSchema.InstantiateTable(XmlSchemaElement node,
XmlSchemaComplexType typeNode, Boolean isRef)

at System.Data.XSDSchema.HandleTable(XmlSchemaElement node)

at System.Data.XSDSchema.HandleDataSet(XmlSchemaElement node, Boolean
isNewDataSet)

at System.Data.XSDSchema.LoadSchema(XmlSchemaSet schemaSet, DataSet ds)

at System.Data.DataSet.ReadXSDSchema(XmlReader reader, Boolean
denyResolving)

at System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving)

at System.Data.DataSet.ReadXml(Stream stream)

at FirebirdSql.Data.Schema.FbSchemaFactory.GetSchema(FbConnection
connection, String collectionName, String[] restrictions)

at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.GetSchema(String
collectionName, String[] restrictions)

at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String
collectionName, String[] restrictions)

at FirebirdSql.Data.FirebirdClient.FbConnection.GetSchema(String
collectionName)

at
FirebirdSql.Data.FirebirdClient.FbCommandBuilder.DeriveParameters(FbCommand
command)

at Tony.Data.Database.Database.DeriveParameters(DbCommand DbCommand)

at Tony.Core.Business.Report.CMDReport.AddParameters(DbCommand DbCommand)

at Tony.Core.Business.Report.CMDReport.LoadData()

at Tony.Core.Business.Report.CMDReport.DataPortal_Execute())



Please help me, thanks.

[Jiri Cincura]

And what's the test-case?