#1 2014-08-29 18:42:19

Sabbiolina
Member
Registered: 2014-05-20
Posts: 120

[Interface based Services] Exception

Hi AB

My test server hangs on new connections:

20140829 20284825  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284825 call  	TSQLRestServerFullMemory(0359C770) TimeStamp
20140829 20284825 srvr  	TSQLRestServerFullMemory(0359C770) GET TimeStamp -> 200
20140829 20284825  -    00.000.033
20140829 20284827  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284827 call  	TSQLRestServerFullMemory(0359C770) Auth
20140829 20284827 srvr  	TSQLRestServerFullMemory(0359C770) GET auth -> 200
20140829 20284827  -    00.000.033
20140829 20284829  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284829 call  	TSQLRestServerFullMemory(0359C770) Auth
20140829 20284829 auth  	TAuthSession(03639330) New "User" session User/2121733790 created at 88.xxx.226.167/DD000000600009EB running Mozilla/3.0 (compatible; Indy Library)
20140829 20284829 srvr  	TSQLRestServerFullMemory(0359C770) GET auth -> 200
20140829 20284829  -    00.000.197
20140829 20284849  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284849 EXCOS 	EAccessViolation (C0000005) at 00869889  stack trace 0045A7CD 00408A06 75E733CA 778F9ED2 778F9EA5 
20140829 20284849  -    00.000.700
20140829 20284907  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284907 EXCOS 	EAccessViolation (C0000005) at 00869889  stack trace 0045A7CD 00408A06 75E733CA 778F9ED2 778F9EA5 
20140829 20284907  -    00.000.330
20140829 20284926  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284926 EXCOS 	EAccessViolation (C0000005) at 00869889  stack trace 0045A7CD 00408A06 75E733CA 778F9ED2 778F9EA5 
20140829 20284926  -    00.000.565 

I have already compiled the project with MAP detailed options.
This log does not help me.
The only thing I'm sure of is that the call does not come to my function.

I start with this:

  //mormot
  // define the log level
   with TSQLLog.Family do
   begin
    Level := LOG_VERBOSE;
//    EchoToConsole := LOG_VERBOSE; // log all events to the console
   end;
    TSQLLog.Enter;

   // create a Data Model
   aModel := TSQLModel.Create([],ROOT_NAME);

   try
    // initialize a TObjectList-based database engine
    aServer := TSQLRestServerFullMemory.Create(aModel,'test.json',false,true);
    try


      AddToServerWrapperMethod(aServer,
        ['c:\CrossPlatform\templates','c:\CrossPlatform\templates']);


      // register our Irestsrv service on the server side
     aServer.ServiceRegister(TServiceRestSrv,[TypeInfo(IrestSRV)],sicShared);


     // launch the HTTP server
     aHTTPServer := TSQLHttpServer.Create(PORT_NAME,[aServer],'+',useHttpApiRegisteringURI);
     try
       aHTTPServer.AccessControlAllowOrigin := '*'; // for AJAX requests to wor

     except
     end;
    finally


any ideas ?

ps exe runs on win2008 R2 / xe2
client android

Offline

#2 2014-08-29 19:05:20

Sabbiolina
Member
Registered: 2014-05-20
Posts: 120

Re: [Interface based Services] Exception

more log:

20140829 19165930 call  	TSQLRestServerFullMemory(0359C770) Auth
20140829 19165930 auth  	TAuthSession(036395A0) New "User" session User/2121733791 created at 88.xxx.226.167/DD00000060000991 running Mozilla/3.0 (compatible; Indy Library)
20140829 19165930 srvr  	TSQLRestServerFullMemory(0359C770) GET auth -> 200
20140829 19165930  -    00.000.128
20140829 19165952  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 19165952 auth  	TSQLRestRoutingREST(035B9450) User/2121733791
20140829 19165952 call  	TSQLRestServerFullMemory(0359C770) restSVR._contract_
20140829 19165952 srvr  	TSQLRestServerFullMemory(0359C770) POST restSVR._contract_ -> 200
20140829 19165952  -    00.000.030
20140829 19165954  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 19165954 auth  	TSQLRestRoutingREST(035B9450) User/2121733788
20140829 19165954 call  	TSQLRestServerFullMemory(0359C770) Auth
20140829 19165954 auth  	TSQLRestServerFullMemory(0359C770) Deleted session User/2121733788 from 88.xxx.226.167/EE00000060003761
20140829 19165954 srvr  	TSQLRestServerFullMemory(0359C770) GET auth -> 200
20140829 19165954  -    00.000.035
20140829 19170015  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 19170015 auth  	TSQLRestRoutingREST(035B9450) User/2121733791
20140829 19170015 call  	TSQLRestServerFullMemory(0359C770) restSVR.func1Back
20140829 19170015 srvr  	TSQLRestServerFullMemory(0359C770) POST restSVR.func1Back -> 200
20140829 19170015  -    00.000.873
20140829 19170155  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 19170155 auth  	TSQLRestRoutingREST(035B9450) User/2121733791
20140829 19170155 call  	TSQLRestServerFullMemory(0359C770) restSVR.func1
20140829 19170155 srvr  	TSQLRestServerFullMemory(0359C770) POST restSVR.func1-> 200
20140829 19170155  -    00.000.960
20140829 19170256  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 19170256 auth  	TSQLRestRoutingREST(035B9450) User/2121733791
20140829 19170256 call  	TSQLRestServerFullMemory(0359C770) restSVR.func1
20140829 19170256 srvr  	TSQLRestServerFullMemory(0359C770) POST restSVR.func1-> 200
20140829 19170256  -    00.001.012
20140829 19170504  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 19170504 auth  	TSQLRestRoutingREST(035B9450) User/2121733791
20140829 19170504 call  	TSQLRestServerFullMemory(0359C770) restSVR.func2
20140829 19170540 srvr  	TSQLRestServerFullMemory(0359C770) POST restSVR.func2 -> 200
20140829 19170540  -    00.581.775
20140829 20284825  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284825 call  	TSQLRestServerFullMemory(0359C770) TimeStamp
20140829 20284825 srvr  	TSQLRestServerFullMemory(0359C770) GET TimeStamp -> 200
20140829 20284825  -    00.000.033
20140829 20284827  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284827 call  	TSQLRestServerFullMemory(0359C770) Auth
20140829 20284827 srvr  	TSQLRestServerFullMemory(0359C770) GET auth -> 200
20140829 20284827  -    00.000.033
20140829 20284829  +    TSQLRestServerFullMemory(0359C770).00868C04 
20140829 20284829 call  	TSQLRestServerFullMemory(0359C770) Auth
20140829 20284829 auth  	TAuthSession(03639330) New "User" session User/2121733790 created at 88.xxx.226.167/DD000000600009EB running Mozilla/3.0 (compatible; Indy Library)
20140829 20284829 srvr  	TSQLRestServerFullMemory(0359C770) GET auth -> 200
20140829 20284829  -    00.000.197 

I noticed:
20140829 19165930 auth      TAuthSession(036395A0) New "User" session User/2121733791 created at 88.xxx.226.167/DD00000060000991
20140829 20284829 auth      TAuthSession(03639330) New "User" session User/2121733790 created at 88.xxx.226.167/DD000000600009E


2121733791 before 2121733790 ?

I think:
20140829 19165952 call      TSQLRestServerFullMemory(0359C770) restSVR._contract_
20140829 19165952 srvr      TSQLRestServerFullMemory(0359C770) POST restSVR._contract_ -> 200

could be the point of the exception

Offline

#3 2014-08-29 19:53:34

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

Re: [Interface based Services] Exception

You did NOT have the .map generated with the .exe, I'm quite sure.
Otherwise the line numbers would appear at the exception level in the logs.

The session numbers are NOT sequential for security reasons.
So 2121733791 is computed before 2121733790.
But they will always be unique.

Did you use the latest source code?
Your problem sounds close to http://synopse.info/fossil/info/18756fee3ec474e3a22

Offline

#4 2014-08-29 22:18:23

Sabbiolina
Member
Registered: 2014-05-20
Posts: 120

Re: [Interface based Services] Exception

Now I'm trying

But the .map must be included or separate from exe?

Offline

#5 2014-08-29 22:57:07

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

Re: [Interface based Services] Exception

In the exe folder - this is the easiest.

Offline

#6 2014-08-30 07:15:32

Sabbiolina
Member
Registered: 2014-05-20
Posts: 120

Re: [Interface based Services] Exception

The rest server now seems stable.

I forgot to upload the .map .....

Offline

#7 2014-08-30 19:06:22

Sabbiolina
Member
Registered: 2014-05-20
Posts: 120

Re: [Interface based Services] Exception

Works well.

Thanks

Offline

#8 2014-08-30 19:13:32

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

Re: [Interface based Services] Exception

You are welcome!
smile

Offline

Board footer

Powered by FluxBB