Commented by: @cincuranet

What changed data structures you're talking about?

Commented by: Mark Junker (fubar-coder)

Here's a stack trace when I try to open an already opened database:

System.IndexOutOfRangeException: Der Index war außerhalb des Arraybereichs.
bei FirebirdSql.Data.Common.IscHelper.VaxInteger(Byte[] buffer, Int32 index, Int32 length) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Common\IscHelper.cs:Zeile 312.
bei FirebirdSql.Data.Common.IscHelper.ParseDatabaseInfo(Byte[] buffer) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Common\IscHelper.cs:Zeile 35.
bei FirebirdSql.Data.Client.Native.FesDatabase.GetDatabaseInfo(Byte[] items, Int32 bufferLength) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 392.
bei FirebirdSql.Data.Client.Native.FesDatabase.GetServerVersion() in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 372.
bei FirebirdSql.Data.Client.Native.FesDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:Zeile 291.
bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:Zeile 171.
bei FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:Zeile 202.
bei FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:Zeile 106.
bei FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:Zeile 221.
bei FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:Zeile 542.

Commented by: @cincuranet

Are you using latest provider? Does this happen only on FB3 and FB2.5.x is OK? This doesn't look like FB3 caused to me.

Commented by: Mark Junker (fubar-coder)

Yes, I'm using 4.8.0.0 and this happens with FB3 only. When using the FB2.5 DLLs, I get the following exception:

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): I/O error during "CreateFile (open)" operation for file "D:\DATALINE\DATALINE.OFFICE.MFC\BUILD\DEBUG\DATA\MUSTER.FDB"
Error while trying to open file ---> I/O error during "CreateFile (open)" operation for file "D:\DATALINE\DATALINE.OFFICE.MFC\BUILD\DEBUG\DATA\MUSTER.FDB"
Error while trying to open file
bei FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:Zeile 196.
bei FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:Zeile 202.
bei FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:Zeile 106.
bei FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:Zeile 221.
bei FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:Zeile 542.

It might be an interesting for you, that the other application opens the database using a Firebird server, while my test application tries to open the DB directly (embedded).

Commented by: @dyemanov

I've found possible incompatibility with FB3. The native fbclient v3 always passes isc_dpb_utf8_filename (even if it wasn't specified by user) and all DPB strings are encoded in UTF8. Provider passes everything "as is" (using system encoding), similar to how FB 2.5 fbclient works. This may break monitoring if isc_dpb_process_name contains non-ASCII characters and server's locale is different from the client's one (example: CP1251 on the Windows client, UTF8 on the Linux server). It would be convinient to follow the fbclient logic -- i.e. always pass isc_dpb_utf8_filename (and transliterate all DPB strings accordingy) -- for protocol P13 and above.

Commented by: @cincuranet

OK. Will do. Thanks Dmitry.

Closing in favor of separate issues.

AFAIS, the issue I described earlier still exists. It makes monitoring usage impossible for many clients using .NET provider. Jiri, could you please post an update, when we may expect it to be fixed/improved?

@dyemanov Can you create separate issue for that?

Done, see #1020.

Thanks.