Execution of query hangs up/freezes
-----------------------------------
Key: DNET-440
URL: http://tracker.firebirdsql.org/browse/DNET-440
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.5.0
Environment: FB 2.5 RC1, FlameRobin OK
Reporter: Jiri Cincura
Assignee: Jiri Cincura
//From mailing list.
The query is:
update ecc$rejestr set wartosc0=@wartosc, typklucza=@typklucza where
klucz=@klucz and induzytkownik=@induzytkownik
The params are:
@klucz = PersonLocator_mainGridControl
@induzytkownik = 1
@typklucza = 0
@wartosc =
db://(2813f4c2-87c7-4c3d-8175-d0e03c88d516)//PersonLocator_mainGridControl.x
ml
A DDL of ECC$REJESTR:
CREATE TABLE ECC$REJESTR
(
KLUCZ STRING50_FIELD DEFAULT '' NOT NULL,
INDUZYTKOWNIK BIGINT_FIELD NOT NULL,
TYPKLUCZA SHORT_FIELD DEFAULT 0,
WARTOSC0 STRING250_FIELD,
WARTOSC1 INTEGER_FIELD,
WARTOSC2 FLOAT_FIELD,
WARTOSC3 MONEY_FIELD,
WARTOSC4 TIMESTAMP_FIELD,
CONSTRAINT PK_ECC$REJESTR PRIMARY KEY (KLUCZ,INDUZYTKOWNIK)
);
ALTER TABLE ECC$REJESTR ADD
FOREIGN KEY (INDUZYTKOWNIK) REFERENCES ECC$UZYTKOWNICY (ID);
===
A program simply hangs up/freezes and I have to break debugging. Then I get
this call stack:
[Managed to Native Transition]
System.dll!System.Net.Sockets.Socket.Receive(byte[] buffer =
{byte[4096]}, int offset = 0, int size, System.Net.Sockets.SocketFlags
socketFlags = None, out System.Net.Sockets.SocketError errorCode = Success) +
0xc4 bytes
System.dll!System.Net.Sockets.Socket.Receive(byte[] buffer, int
offset, int size, System.Net.Sockets.SocketFlags socketFlags) + 0x20 bytes
System.dll!System.Net.Sockets.NetworkStream.Read(byte[] buffer,
int offset, int size) + 0x84 bytes
mscorlib.dll!System.IO.BufferedStream.Read(byte[] array =
{byte[8]}, int offset = 0, int count = 4) + 0xc4 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.XdrStream.Read(byte[]
buffer, int offset, int count) + 0x2e bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.XdrStream.ReadNextOperation()
+ 0x17 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.XdrStream.ReadOperation()
+ 0x16 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.ReadOperation()
+ 0x19 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse()
+ 0x11 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
+ 0x11 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
+ 0xc bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Execute()
+ 0x11d bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(System.Data.CommandBehavior
behavior, bool returnsSet) + 0xc7 bytes
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
+ 0x40 bytes
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
