#1 2014-06-03 14:14:31

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

The I/O operation has been aborted because of either a thread exit or

Hello friends,

I saw this error on the log:

20140528 14471410 EXC   EHttpApiServer ("HttpSendHttpResponse failed: The I/O operation has been aborted because of either a thread exit or an application request (995)") at 006D5CEE  stack trace 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 

What does it mean?

Offline

#2 2014-06-03 19:56:29

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

In which context?

Offline

#3 2014-06-04 11:59:54

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

Re: The I/O operation has been aborted because of either a thread exit or

I don't know exactly. Here is the whole log file:

TSQLLog 1.18 2014-05-28T11:40:04

20140528 11400425 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 0066826A  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140528 14423019 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 0066826A  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140528 14471410 EXC   EHttpApiServer ("HttpSendHttpResponse failed: The I/O operation has been aborted because of either a thread exit or an application request (995)") at 006D5CEE  stack trace 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140528 15151820 EXC   ESQLite3Exception ("TSQLRequest.Reset called with no previous Request") at 00667D2C  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140529 10395406 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 0066826A  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140529 10395416 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 0066826A  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140529 11063231 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 0066826A  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140529 11063238 EXC   ESQLite3Exception ("TSQLRequest.Reset called with no previous Request") at 00667D2C  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140529 11063245 EXC   ESQLite3Exception ("TSQLRequest.Reset called with no previous Request") at 00667D2C  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 
20140529 16024706 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 0066826A  stack trace 006ABA60 006AB05F 006ADE80 00406CB2 0040B2E0 006D8E05 006D1C63 006D6DB0 004D27D0 0040B1EA 75D3339A 773E9EF2 773E9EC5 

Last edited by colbert (2014-06-04 12:00:28)

Offline

#4 2014-06-04 12:45:56

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

Did you use the latest .obj files?

Please enable the "detailed map file" in the project option to have the line numbers in the stack trace.

Offline

#5 2014-06-04 14:55:44

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

Re: The I/O operation has been aborted because of either a thread exit or

The ProjectOptions > Delphi Compiler > Linking > Map File option is already set to Detailed
Is there any other option that should be turned on?

Offline

#6 2014-06-04 17:05:19

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

The .map file should be in .exe folder.

Offline

#7 2014-06-04 17:33:35

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

Re: The I/O operation has been aborted because of either a thread exit or

Yes, the is in the .exe folder after a compilation

Offline

#8 2014-06-04 22:54:31

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

Weird.
The log should therefore contain the line numbers.

Did you use latest sqlite3*.obj files as stated by http://synopse.info/fossil/wiki?name=Get+the+source ?

It is impossible to reproduce your issue here, with so little information on your side.
We even do not know which SQL statement is wrong.

Offline

#9 2014-06-05 16:14:11

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

Re: The I/O operation has been aborted because of either a thread exit or

Yes, it's the latest sqlite3*.obj available. This error with the server in production with clients using.

Does the map file should be in the server folder, even using it in a "production state"?

On the case of the SQL statement, Do you think that this ticket http://synopse.info/fossil/tktview?name=ea07928ae9 could help?

Offline

#10 2014-06-05 17:21:55

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

Yes the .map file should be in the. Exe folder...

Offline

#11 2014-06-16 11:36:52

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

Re: The I/O operation has been aborted because of either a thread exit or

I put the .map file in the Exe folder. The error looks like this now:

20140613 14511433 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 00267782 SynSQLite3.sqlite3_check (4207)  stack trace 002AB0D4 mORMot.TSQLRestServerURIContext.ExecuteORMGet (25504) 002AA6D3 mORMot.TSQLRestServerURIContext.Execute (25335) 002AD4F4 mORMot.TSQLRestServer.URI (26234) 00005CB2 System.@GetMem 0000A2E0 System.@NewAnsiString 002D849D mORMotHttpServer.TSQLHttpServer.Request (570) 002D12FB SynCrtSock.THttpServerGeneric.Request (2003) 002D6448 SynCrtSock.THttpApiServer.Execute (5053) 000D17D0 System.Classes.ThreadProc 0000A1EA System.ThreadWrapper 
20140613 14511504 EXC   ESQLite3Exception ("TSQLRequest.Reset called with no previous Request") at 00267244 SynSQLite3.TSQLRequest.Reset (4127)  stack trace 002AB0D4 mORMot.TSQLRestServerURIContext.ExecuteORMGet (25504) 002AA6D3 mORMot.TSQLRestServerURIContext.Execute (25335) 002AD4F4 mORMot.TSQLRestServer.URI (26234) 00005CB2 System.@GetMem 0000A2E0 System.@NewAnsiString 002D849D mORMotHttpServer.TSQLHttpServer.Request (570) 002D12FB SynCrtSock.THttpServerGeneric.Request (2003) 002D6448 SynCrtSock.THttpApiServer.Execute (5053) 000D17D0 System.Classes.ThreadProc 0000A1EA System.ThreadWrapper 
20140613 14511535 EXC   ESQLite3Exception ("TSQLRequest.Reset called with no previous Request") at 00267244 SynSQLite3.TSQLRequest.Reset (4127)  stack trace 002AB0D4 mORMot.TSQLRestServerURIContext.ExecuteORMGet (25504) 002AA6D3 mORMot.TSQLRestServerURIContext.Execute (25335) 002AD4F4 mORMot.TSQLRestServer.URI (26234) 00005CB2 System.@GetMem 0000A2E0 System.@NewAnsiString 002D849D mORMotHttpServer.TSQLHttpServer.Request (570) 002D12FB SynCrtSock.THttpServerGeneric.Request (2003) 002D6448 SynCrtSock.THttpApiServer.Execute (5053) 000D17D0 System.Classes.ThreadProc 000

Offline

#12 2014-06-16 12:00:42

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

What is the purpose of your program?
What does the server side do?
What does the client side do?
Do the sample programs shipped with mORMot (ORM, services, and so on...) work on your computer?

Without code to reproduce the issue, it is hard to tell.

I guess you did not initialize properly the client or server side, but it is impossible to find out what's wrong for you.
Perhaps you are using interface-based services without authentication, and so on.

You may have to enable logging to find out the exact content of the issue (RESTful request, timing, SQL statement...).
The stack trace is not enough here to get the context.

Offline

#13 2014-06-24 12:14:31

colbert
Member
Registered: 2013-03-02
Posts: 38
Website

Re: The I/O operation has been aborted because of either a thread exit or

I enabled SQL statements on the log. And the error happened again together with this SQL statement:

20140623 14130040 SQL   TDBServer(02701510) SELECT ID,DataAlteracao,IdCliente,Cliente,Nome,Descricao FROM Vendas WHERE ID = 3482 AND ID = ; prepared with 1 param
20140623 14130040 EXC   ESQLite3Exception ("near \"AND\": syntax error") at 00268AA2 SynCrypto.TAESAbstract  stack trace 002ADFC0 mORMot.TSQLRestServer.SessionAccess (26413) 002AD5BF mORMot.TSQLRestServer.URI (26250) 002B03F5 mORMot.TSQLRestStorageInMemory.Create (27544) 00005CB2 System.@GetMem 0000A2E0 System.@NewAnsiString 002DD401 Vcl.Buttons.TSpeedButtonActionLink.IsGlyphLinked 002D625F SynCrtSock.THttpApiServer.Execute (5002) 002DB3AC Vcl.Buttons.{System.Generics.Collections}TList<System.Integer> 000D17D0 System.Classes.ThreadProc 0000A1EA System.ThreadWrapper 

This SQL was not generated by hand, not even after the where clause.

Offline

#14 2014-06-24 14:39:48

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: The I/O operation has been aborted because of either a thread exit or

What is the high-level CRUD/ORM method run?
(with parameters)

Offline

Board footer

Powered by FluxBB