#1 2016-03-11 09:08:53

DigDiver
Member
Registered: 2013-04-29
Posts: 137

Restart real-time synchronization

I have a problem with the restart of real-time synchronization.

Master Server

 MasterServer :=  TSQLHttpServer.Create('81',[AccountServer],'+',useBidirSocket);
 MasterServer.WebSocketsEnable(AccountServer,'password');

 AccountServer.RecordVersionSynchronizeMasterStart();

Slave Server

MasterClient := TSQLHttpClientWebsockets.Create(MasterServerAddress,'81', AccountModel );
MasterClient.WebSocketsUpgrade('password');
MasterClient.SetUser('UserName','Password');

Result := AccountSlaveServer.RecordVersionSynchronizeSlaveStart(TUser ,MasterClient, NotifySync);

Then Master Server stopped and started again.

In the Slave Server I have the code that checks availability of the Master Server:

 if not  MasterClient.ServerTimeStampSynchronize then
  begin
   // Stop Synchronization
   AccountSlaveServer.RecordVersionSynchronizeSlaveStop(TUser);
   MasterClient.SessionClose;
   FOnErrorMessage('WebSockets', 'MasterClient', 'Session Closed');
  end
 else
  if MasterClient.SessionUser = nil then
   begin
    // Login to the Master Server
    Status       := MasterClient.WebSocketsUpgrade('bdfyjdbx66_gtnhjdbx70');
    MasterClient.SetUser('UserName','Password');

    // Start Synchronization

    try
     Result := AccountSlaveServer.RecordVersionSynchronizeSlaveStart(TUser ,MasterClient, NotifySync);
     if Not Result then
      begin
       FOnErrorMessage('Bounce', 'RecordVersionSynchronizeSlaveStart', 'Not Stated');
      end;
    except
     On e: Exception do
      begin
        FOnErrorMessage('Bounce', 'RecordVersionSynchronizeSlaveStart', E.Message);
      end;
    end;
   end;
   

   And in RecordVersionSynchronizeSlaveStart method in the line:

    if service.Subscribe(tableName,current,callback) then begin

   

Debugger jumps to:

  
  // WELCOME ABOARD: you just landed in TInterfacedObjectFake.FakeCall() !
  // if your debugger reached here, you are executing a "fake" interface
  // forged to call a remote SOA server or mock/stub an interface

How to properly restart synchronization?

Offline

#2 2016-03-11 13:56:04

DigDiver
Member
Registered: 2013-04-29
Posts: 137

Re: Restart real-time synchronization

There is a problem with the synchronization start.

Steps to reproduce the problem:

1. Starting MasterServer
2. MasterServer.RecordVersionSynchronizeMasterStart();

3. Starting SlaveServer
4. SlaveServer.RecordVersionSynchronizeSlaveStart(TUser, MasterClient, NotifySync);

In this case RecordVersionSynchronizeSlaveStart returns false (retry failure)

If I start MasterServer, then make changes to TSQLRecordPeopleVersioned, and after that start SlaveServer, synchronization will start working.

1. Starting MasterServer
2. MasterServer.RecordVersionSynchronizeMasterStart();

3. Make any changes in the TSQLRecordPeopleVersioned

4. Starting SlaveServer
5. SlaveServer.RecordVersionSynchronizeSlaveStart(TUser, MasterClient, NotifySync);

Below is the log for the scenario 1:

MasterServer

20160311 13074854  +    mORMotSQLite3.TSQLRestServerDB(07316160).URI(POST Accounts/ServiceRecordVersion._contract_?session_signature=017E1BAE00017E2E93B827B4 inlen=2)
20160311 13074854 auth  	mORMot.TSQLRestRoutingREST(072D0800) SuperPuperAdmin/25041838 
20160311 13074854 call  	mORMotSQLite3.TSQLRestServerDB(07316160) IServiceRecordVersion._contract_[]
20160311 13074854 srvr  	mORMotSQLite3.TSQLRestServerDB(07316160) SuperPuperAdmin  POST Accounts/ServiceRecordVersion._contract_ SOA-Interface -> 200 with outlen=31 in 342 us
20160311 13074854 ret   	mORMotSQLite3.TSQLRestServerDB(07316160) {"result":["5DDC975F57031DB5"]}

20160311 13074854  +    mORMotSQLite3.TSQLRestServerDB(07316160).URI(GET Accounts?session_signature=017E1BAE00017E2E0BB76508 inlen=121)
20160311 13074854 auth  	mORMot.TSQLRestRoutingREST(072D0C20) SuperPuperAdmin/25041838 
20160311 13074854 DB    	mORMotSQLite3.TSQLRestServerDB(07316160) prepared 35us accounts.db3 SELECT ID,Deleted FROM TableDeleted WHERE ID>? and ID<? order by ID limit 10000
20160311 13074854 SQL   	mORMotSQLite3.TSQLRestServerDB(07316160) 366us returned 0 row as 56 bytes SELECT ID,Deleted FROM TableDeleted WHERE ID>:(576460752303423557): and ID<:(864691128455135232): order by ID limit 10000
20160311 13074854 res   	SynSQLite3.TSQLDatabase(04263628) {"fieldCount":2,"values":["ID","Deleted"],"rowCount":0} 
20160311 13074854 srvr  	mORMotSQLite3.TSQLRestServerDB(07316160) SuperPuperAdmin  GET Accounts/ ORM-Get -> 200 with outlen=56 in 1027 us
20160311 13074854  -    00.001.562
20160311 13074854  +    mORMotSQLite3.TSQLRestServerDB(07316160).URI(GET Accounts?session_signature=017E1BAE00017E2E0BB76508 inlen=307)
20160311 13074854 auth  	mORMot.TSQLRestRoutingREST(072D1040) SuperPuperAdmin/25041838 
20160311 13074854 SQL   	SynSQLite3.TSQLDatabase(04263628) from cache accounts.db3 SELECT ID,Created,Modified,OrderID,TotalCheck,TotalInDay,TotalInMonth,StartMonth,StartDay,FreePoints,PaidPoints,SmtpUserName,FirstName,LastName,Email,RefNo,Blocked,FreeUser,APIKey,Subscription,AllowedIPS,TotalZeroReported,EmptyTestReported,Version FROM User WHERE Version>:(69): order by Version limit 10000
20160311 13074854 res   	SynSQLite3.TSQLDatabase(04263628) {"fieldCount":24,"values":["ID","Created","Modified","OrderID","TotalCheck","TotalInDay","TotalInMonth","StartMonth","StartDay","FreePoints","PaidPoints","SmtpUserName","FirstName","LastName","Email","RefNo","Blocked","FreeUser","APIKey","Subscription","AllowedIPS","TotalZeroReported","EmptyTestReported","Version"],"rowCount":0} 
20160311 13074854 srvr  	mORMotSQLite3.TSQLRestServerDB(07316160) SuperPuperAdmin  GET Accounts/ ORM-Get -> 200 with outlen=331 in 1260 us
20160311 13074854  -    00.001.817
20160311 13074854  +    mORMotSQLite3.TSQLRestServerDB(07316160).URI(GET Accounts?session_signature=017E1BAE00017E2E0BB76508 inlen=121)
20160311 13074854 auth  	mORMot.TSQLRestRoutingREST(072D0C20) SuperPuperAdmin/25041838 
20160311 13074854 SQL   	SynSQLite3.TSQLDatabase(04263628) from cache accounts.db3 SELECT ID,Deleted FROM TableDeleted WHERE ID>:(576460752303423557): and ID<:(864691128455135232): order by ID limit 10000
20160311 13074854 res   	SynSQLite3.TSQLDatabase(04263628) {"fieldCount":2,"values":["ID","Deleted"],"rowCount":0} 
20160311 13074854 srvr  	mORMotSQLite3.TSQLRestServerDB(07316160) SuperPuperAdmin  GET Accounts/ ORM-Get -> 200 with outlen=56 in 2639 us
20160311 13074854  -    00.003.075
20160311 13074854  +    mORMotSQLite3.TSQLRestServerDB(07316160).URI(POST Accounts/ServiceRecordVersion.Subscribe?session_signature=017E1BAE00017E2E93B5E950 inlen=13)
20160311 13074854 auth  	mORMot.TSQLRestRoutingREST(072D0C20) SuperPuperAdmin/25041838 
20160311 13074854 call  	mORMotSQLite3.TSQLRestServerDB(07316160) ServiceRecordVersion.Subscribe["User",69,1]
20160311 13074854 trace 	mORMotSQLite3.TSQLRestServerDB(07316160) TInterfacedObjectFakeServer(04251800:1).Destroy IServiceRecordVersion
20160311 13074854 srvr  	mORMotSQLite3.TSQLRestServerDB(07316160) SuperPuperAdmin  POST Accounts/ServiceRecordVersion.Subscribe SOA-Interface -> 200 with outlen=18 in 619 us
20160311 13074854 ret   	mORMotSQLite3.TSQLRestServerDB(07316160) {"result":[false]}

SlaveServer

20160311 13074853  +    mORMot.TServiceFactoryClient(0414C590).InternalInvoke IServiceRecordVersion._contract_ [] 
20160311 13074853  +    	mORMotHttpClient.TSQLHttpClientWebsockets(0403E830).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13074853 clnt  		mORMotHttpClient.TSQLHttpClientWebsockets(0403E830) POST Accounts/ServiceRecordVersion._contract_?session_signature=017E1BAE00017E2E93B827B4 status=200 state=13
20160311 13074853  -    	00.001.216
20160311 13074853 ret   	mORMot.TServiceFactoryClient(0414C590) {"result":["5DDC975F57031DB5"]}
20160311 13074853  -    00.001.230
20160311 13074853  +    mORMotSQLite3.TSQLRestServerDB(073225C0).RecordVersionSynchronizeSlave TUser
20160311 13074853 SQL   	mORMotSQLite3.TSQLRestServerDB(073225C0) 149us returned 1 row as 22 bytes SELECT max(Version) FROM User LIMIT 1
20160311 13074853 res   	SynSQLite3.TSQLDatabase(0413A8F0) [{"max(Version)":69}] 
20160311 13074853 DB    	mORMotSQLite3.TSQLRestServerDB(073225C0) prepared 29us users_slave.db3 SELECT max(ID) FROM TableDeleted WHERE ID>? and ID<? LIMIT 1
20160311 13074853 SQL   	mORMotSQLite3.TSQLRestServerDB(073225C0) 76us returned 1 row as 19 bytes SELECT max(ID) FROM TableDeleted WHERE ID>:(576460752303423488): and ID<:(864691128455135232): LIMIT 1
20160311 13074853 res   	SynSQLite3.TSQLDatabase(0413A8F0) [{"max(ID)":null}] 
20160311 13074853  +    	mORMotSQLite3.TSQLRestServerDB(073225C0).RecordVersionSynchronizeSlaveToBatch TUser
20160311 13074853  +    		mORMotHttpClient.TSQLHttpClientWebsockets(0403E830).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13074854 clnt  			mORMotHttpClient.TSQLHttpClientWebsockets(0403E830) GET Accounts?session_signature=017E1BAE00017E2E0BB76508 status=200 state=13
20160311 13074854  -    		00.002.499
20160311 13074854  +    		mORMotHttpClient.TSQLHttpClientWebsockets(0403E830).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13074854 clnt  			mORMotHttpClient.TSQLHttpClientWebsockets(0403E830) GET Accounts?session_signature=017E1BAE00017E2E0BB76508 status=200 state=13
20160311 13074854  -    		00.001.795
20160311 13074854  -    	00.004.336
20160311 13074854  -    00.004.629

Below is the log for the scenario 2:

MasterServer

20160311 13171223  +    MainServer.TAPI1Server(040EC6F0).URI(GET api/v1/CreateTest?apikey=xxxxx&Limit=22&offset=5&Groups=2049 inlen=0)
20160311 13171223 call  	MainServer.TAPI1Server(040EC6F0) CreateTest apikey=xxxxx&Limit=22&offset=5&Groups=2049
20160311 13171223 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 71us accounts.db3 SELECT ID,Blocked FROM User WHERE APiKey=?
20160311 13171223 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 571us returned 1 row as 25 bytes SELECT ID,Blocked FROM User WHERE APiKey=:('xxxxx'):
20160311 13171224 res   	SynSQLite3.TSQLDatabase(04143628) [{"ID":579,"Blocked":0}] 
20160311 13171224 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 217us returned 1 row as 530 bytes SELECT ID,Created,Modified,OrderID,TotalCheck,TotalInDay,TotalInMonth,StartMonth,StartDay,FreePoints,PaidPoints,SmtpUserName,FirstName,LastName,Email,RefNo,Blocked,FreeUser,APIKey,Subscription,AllowedIPS,TotalZeroReported,EmptyTestReported FROM User WHERE ID in (579)
20160311 13171224 res   	SynSQLite3.TSQLDatabase(04143628) [{"ID":579,"Created":135293311538,"Modified":135301219462,"OrderID":"xxx","TotalCheck":618,"TotalInDay":46,"TotalInMonth":55,"StartMonth":"2016-02-15T16:46:05","StartDay":"2016-03-11T06:52:27","FreePoints":0,"PaidPoints":0,"SmtpUserName":"xxx","FirstName":"xxx","LastName":"xxx","Email":"xxx@xxx.com","RefNo":"47119952","Blocked":0,"FreeUser":0,"APIKey":"xxx","Subscription":3,"AllowedIPS":50,"TotalZeroReported":1,"Empty... (truncated) length=530
20160311 13171224 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 174us returned 1 row as 22 bytes SELECT max(Version) FROM User LIMIT 1
20160311 13171224 res   	SynSQLite3.TSQLDatabase(04143628) [{"max(Version)":69}] 
20160311 13171224 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 50us accounts.db3 SELECT max(ID) FROM TableDeleted WHERE ID>? and ID<? LIMIT 1
20160311 13171224 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 517us returned 1 row as 19 bytes SELECT max(ID) FROM TableDeleted WHERE ID>:(864691128455135232): and ID<:(1152921504606846976): LIMIT 1
20160311 13171224 res   	SynSQLite3.TSQLDatabase(04143628) [{"max(ID)":null}] 
20160311 13171224 cache 	SynSQLite3.TSQLDatabase(04143628) accounts.db3 cache flushed
20160311 13171224 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 59us accounts.db3 UPDATE User SET Modified=?,TotalCheck=?,TotalInDay=?,TotalInMonth=?,StartMonth=?,StartDay=?,FreePoints=?,PaidPoints=?,Version=? WHERE RowID=?;
20160311 13171227 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 44.17ms  UPDATE User SET Modified=:(135301223500):,TotalCheck=:(619):,TotalInDay=:(47):,TotalInMonth=:(56):,StartMonth=:('2016-02-15T16:46:05'):,StartDay=:('2016-03-11T06:52:27'):,FreePoints=:(0):,PaidPoints=:(0):,Version=:(70): WHERE RowID=:(579):;
20160311 13171227 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 376us returned 4 rows as 2386 bytes SELECT 
20160311 13171227 cache 	SynSQLite3.TSQLDatabase(04143628) accounts.db3 cache flushed
20160311 13171721 trace mORMotSQLite3.TSQLRestServerDB(07306160) BeginCurrentThread(TWebSocketServerResp) ThreadID=00002A28 ThreadCount=33
20160311 13171721  +    mORMotSQLite3.TSQLRestServerDB(07306160).URI(GET Accounts/TimeStamp inlen=0)
20160311 13171721 call  	mORMotSQLite3.TSQLRestServerDB(07306160) TimeStamp 
20160311 13171721 srvr  	mORMotSQLite3.TSQLRestServerDB(07306160)   GET Accounts/TimeStamp SOA-Method -> 200 with outlen=12 in 250 us
20160311 13171721 ret   	mORMotSQLite3.TSQLRestServerDB(07306160) 135301223505
20160311 13171721  -    00.001.024
20160311 13171721  +    mORMotSQLite3.TSQLRestServerDB(07306160).URI(GET Accounts/Auth?UserName=SuperPuperAdmin inlen=0)
20160311 13171721 call  	mORMotSQLite3.TSQLRestServerDB(07306160) Auth UserName=SuperPuperAdmin
20160311 13171721 srvr  	mORMotSQLite3.TSQLRestServerDB(07306160)   GET Accounts/Auth SOA-Method -> 200 with outlen=77 in 265 us
20160311 13171721 ret   	mORMotSQLite3.TSQLRestServerDB(07306160) {"result":"0009ea1df10edeb0e3b634afe2f34b53463bc2e3155a4c3df79654d475a38755"}
20160311 13171721  -    00.001.214
20160311 13171721  +    mORMotSQLite3.TSQLRestServerDB(07306160).URI(GET Accounts/Auth?UserName=SuperPuperAdmin&Password=e31a3c47f2bb426b5a0d2dd17d992ded960aeeef5bd0864e8cc069a29d797608&ClientNonce=0009ea1df10edeb0e3b634afe2f34b53463bc2e3155a4c3df79654d475a38755 inlen=0)
20160311 13171722 call  	mORMotSQLite3.TSQLRestServerDB(07306160) Auth UserName=SuperPuperAdmin&Password=e31a3c47f2bb426b5a0d2dd17d992ded960aeeef5bd0864e8cc069a29d797608&ClientNonce=0009ea1df10edeb0e3b634afe2f34b53463bc2e3155a4c3df79654d475a38755
20160311 13171722 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 70us accounts.db3 SELECT ID,LogonName,DisplayName,PasswordHashHexa,GroupRights FROM AuthUser WHERE LogonName=?
20160311 13171722 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 689us returned 1 row as 165 bytes SELECT ID,LogonName,DisplayName,PasswordHashHexa,GroupRights FROM AuthUser WHERE LogonName=:('SuperPuperAdmin'):
20160311 13171722 res   	SynSQLite3.TSQLDatabase(04143628) [{"ID":1,"LogonName":"SuperPuperAdmin","DisplayName":"Admin","PasswordHashHexa":"2f79797e7e41e761eed0d588e58bdc7bf8577e3576347246234a0f3b35c8e62a","GroupRights":1}] 
20160311 13171722 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 55us accounts.db3 SELECT ID,Ident,SessionTimeout,AccessRights FROM AuthGroup WHERE RowID=?;
20160311 13171722 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 744us returned 1 row as 99 bytes SELECT ID,Ident,SessionTimeout,AccessRights FROM AuthGroup WHERE RowID=:(1):;
20160311 13171722 res   	SynSQLite3.TSQLDatabase(04143628) [{"ID":1,"Ident":"Admin","SessionTimeout":10,"AccessRights":"47,1-256,0,1-256,0,1-256,0,1-256,0"}] 
20160311 13171722 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 66us accounts.db3 SELECT Data FROM AuthUser WHERE RowID=?
20160311 13171722 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 464us returned 0 bytes SELECT Data FROM AuthUser WHERE RowID=:(1):
20160311 13171722 auth  	mORMot.TAuthSession(040F5480) New "Admin" session SuperPuperAdmin/25596674 created at /1 running 
20160311 13171722 srvr  	mORMotSQLite3.TSQLRestServerDB(07306160)   GET Accounts/Auth SOA-Method -> 200 with outlen=219 in 6185 us
20160311 13171722 ret   	mORMotSQLite3.TSQLRestServerDB(07306160) {"result":"25596674+cd89e2471509ffe1828420fc6e31b634709f4a45b220b08a4fdaf9b0a0ce2941","logonid":1,"logonname":"SuperPuperAdmin","logondisplay":"Admin","logongroup":1,"server":"xxx- server","version":"1.0.0.0"}
20160311 13171722  -    00.007.607
20160311 13171722  +    mORMotSQLite3.TSQLRestServerDB(07306160).URI(POST Accounts/ServiceRecordVersion._contract_?session_signature=01869302000186DBC723D6B3 inlen=2)
20160311 13171722 auth  	mORMot.TSQLRestRoutingREST(072C0800) SuperPuperAdmin/25596674 
20160311 13171722 call  	mORMotSQLite3.TSQLRestServerDB(07306160) IServiceRecordVersion._contract_[]
20160311 13171722 srvr  	mORMotSQLite3.TSQLRestServerDB(07306160) SuperPuperAdmin  POST Accounts/ServiceRecordVersion._contract_ SOA-Interface -> 200 with outlen=31 in 537 us
20160311 13171722 ret   	mORMotSQLite3.TSQLRestServerDB(07306160) {"result":["5DDC975F57031DB5"]}
20160311 13171722  -    00.001.540
20160311 13171722  +    mORMotSQLite3.TSQLRestServerDB(07306160).URI(GET Accounts?session_signature=01869302000186DB21ED5E68 inlen=307)
20160311 13171722 auth  	mORMot.TSQLRestRoutingREST(072C0C20) SuperPuperAdmin/25596674 
20160311 13171722 DB    	mORMotSQLite3.TSQLRestServerDB(07306160) prepared 115us accounts.db3 SELECT ID,Created,Modified,OrderID,TotalCheck,TotalInDay,TotalInMonth,StartMonth,StartDay,FreePoints,PaidPoints,SmtpUserName,FirstName,LastName,Email,RefNo,Blocked,FreeUser,APIKey,Subscription,AllowedIPS,TotalZeroReported,EmptyTestReported,Version FROM User WHERE Version>? order by Version limit 10000
20160311 13171722 SQL   	mORMotSQLite3.TSQLRestServerDB(07306160) 815us returned 1 row as 543 bytes SELECT ID,Created,Modified,OrderID,TotalCheck,TotalInDay,TotalInMonth,StartMonth,StartDay,FreePoints,PaidPoints,SmtpUserName,FirstName,LastName,Email,RefNo,Blocked,FreeUser,APIKey,Subscription,AllowedIPS,TotalZeroReported,EmptyTestReported,Version FROM User WHERE Version>:(69): order by Version limit 10000
20160311 13171722 res   	SynSQLite3.TSQLDatabase(04143628) [{"ID":579,"Created":135293311538,"Modified":135301223500,"OrderID":"xxxxx","TotalCheck":619,"TotalInDay":47,"TotalInMonth":56,"StartMonth":"2016-02-15T16:46:05","StartDay":"2016-03-11T06:52:27","FreePoints":0,"PaidPoints":0,"SmtpUserName":"xxx","FirstName":"xxx","LastName":"xxx","Email":"xxx@xxx.com","RefNo":"47119952","Blocked":0,"FreeUser":0,"APIKey":"xxx","Subscription":3,"AllowedIPS":50,"TotalZeroReported":1,"Empty... (truncated) length=543
20160311 13171722 srvr  	mORMotSQLite3.TSQLRestServerDB(07306160) SuperPuperAdmin  GET Accounts/ ORM-Get -> 200 with outlen=543 in 3036 us

SlaveServer

20160311 13171722  +    mORMot.TServiceFactoryClient(0414C590).InternalInvoke IServiceRecordVersion._contract_ [] 
20160311 13171722  +    	mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13171722 clnt  		mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30) POST Accounts/ServiceRecordVersion._contract_?session_signature=01869302000186DBC723D6B3 status=200 state=20
20160311 13171722  -    	00.001.842
20160311 13171722 ret   	mORMot.TServiceFactoryClient(0414C590) {"result":["5DDC975F57031DB5"]}
20160311 13171722  -    00.001.858
20160311 13171722  +    mORMotSQLite3.TSQLRestServerDB(073725C0).RecordVersionSynchronizeSlave TUser
20160311 13171722 SQL   	mORMotSQLite3.TSQLRestServerDB(073725C0) 224us returned 1 row as 22 bytes SELECT max(Version) FROM User LIMIT 1
20160311 13171722 res   	SynSQLite3.TSQLDatabase(0413A8F0) [{"max(Version)":69}] 
20160311 13171722 DB    	mORMotSQLite3.TSQLRestServerDB(073725C0) prepared 48us users_slave.db3 SELECT max(ID) FROM TableDeleted WHERE ID>? and ID<? LIMIT 1
20160311 13171722 SQL   	mORMotSQLite3.TSQLRestServerDB(073725C0) 117us returned 1 row as 19 bytes SELECT max(ID) FROM TableDeleted WHERE ID>:(576460752303423488): and ID<:(864691128455135232): LIMIT 1
20160311 13171722 res   	SynSQLite3.TSQLDatabase(0413A8F0) [{"max(ID)":null}] 
20160311 13171722  +    	mORMotSQLite3.TSQLRestServerDB(073725C0).RecordVersionSynchronizeSlaveToBatch TUser
20160311 13171722  +    		mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13171722 clnt  			mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30) GET Accounts?session_signature=01869302000186DB21ED5E68 status=200 state=20
20160311 13171722  -    		00.004.111
20160311 13171722  +    		mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13171723 clnt  			mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30) GET Accounts?session_signature=01869302000186DB21ED5E68 status=200 state=20
20160311 13171723  -    		00.002.357
20160311 13171723 DB    		mORMotSQLite3.TSQLRestServerDB(073725C0) prepared 34us users_slave.db3 SELECT ID FROM User WHERE RowID=? LIMIT 1
20160311 13171723 SQL   		mORMotSQLite3.TSQLRestServerDB(073725C0) 134us returned 1 row as 13 bytes SELECT ID FROM User WHERE RowID=:(579): LIMIT 1
20160311 13171723 res   		SynSQLite3.TSQLDatabase(0413A8F0) [{"ID":579}] 
20160311 13171723  -    	00.007.160
20160311 13171723  +    	mORMotSQLite3.TSQLRestServerDB(073725C0).EngineBatchSend  inlen=599
20160311 13171723 cache 		SynSQLite3.TSQLDatabase(0413A8F0) users_slave.db3 cache flushed
20160311 13171723 DB    		mORMotSQLite3.TSQLRestServerDB(073725C0) prepared 80us users_slave.db3 UPDATE User SET Created=?,Modified=?,OrderID=?,TotalCheck=?,TotalInDay=?,TotalInMonth=?,StartMonth=?,StartDay=?,FreePoints=?,PaidPoints=?,SmtpUserName=?,FirstName=?,LastName=?,Email=?,RefNo=?,Blocked=?,FreeUser=?,APIKey=?,Subscription=?,AllowedIPS=?,TotalZeroReported=?,EmptyTestReported=?,Version=? WHERE RowID=?;
20160311 13171725 SQL   		mORMotSQLite3.TSQLRestServerDB(073725C0) 38.63ms  UPDATE User SET Created=:(135293311538):,Modified=:(135301223500):,OrderID=:('xxxxx'):,TotalCheck=:(619):,TotalInDay=:(47):,TotalInMonth=:(56):,StartMonth=:('2016-02-15T16:46:05'):,StartDay=:('2016-03-11T06:52:27'):,FreePoints=:(0):,PaidPoints=:(0):,SmtpUserName=:('xxx'):,FirstName=:('xxx'):,LastName=:('xxx'):,Email=:('xxx@xxx.com'):,RefNo=:('47119952'):,Blocked=:(0):,FreeUser=:(0):,APIKey=:('xxx'):,Subscription=:(3):,AllowedIPS=:(50):,TotalZeroReported=:(1):,EmptyTestReported=:(1):,Version=:(70): WHERE RowID=:(579):;
20160311 13171725 trace 		mORMotSQLite3.TSQLRestServerDB(073725C0) EngineBatchSend json=599 B add=0 update=1 delete=0 @User
20160311 13171725  -    	00.038.824
20160311 13171725 debug 	mORMotSQLite3.TSQLRestServerDB(073725C0) TSQLRestServerDB.RecordVersionSynchronize Added=0 Updated=1 Deleted=0 on {"TSQLHttpClientWebsockets(0403EE30)":{"Socket":{"THttpClientWebSockets(0403C300)":{"WebSockets":{"TWebSocketProcessClient(0737CC70)":{"Protocol":{"TWebSocketProtocolBinary(0414C400)":{"Compressed":true,"Encrypted":true,"FramesInBytesSocket":1308,"FramesOutBytesSocket":1180,"FramesInCompression":-9,"FramesOutCompression":-21,"Name":"synopsebinary","URI":"Accounts","LastError":"","FramesInCount":6,"FramesOutCount":6,"FramesInBytes":1197,"FramesOutBytes":972}},"InvalidPingSendCount":0}},"Sock":1220,"Server":"127.0.0.1","Port":"81","TimeOut":60000,"BytesIn":1484,"BytesOut":1547}},"KeepAliveMS":20000,"Compression":["hcSynLZ"],"Server":"127.0.0.1","Port":"81","LastErrorCode":200,"LastErrorMessage":"","MaximumAuthentificationRetry":0,"RetryOnceOnTimeout":false,"SessionID":25596674,"SessionServer":"inboxmonitor - server","SessionVersion":"1.0.0.0","ServerTimeStamp":135301223505}}
20160311 13171725  +    	mORMotSQLite3.TSQLRestServerDB(073725C0).RecordVersionSynchronizeSlaveToBatch TUser
20160311 13171725  +    		mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13171725 clnt  			mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30) GET Accounts?session_signature=01869302000186DB21ED5E68 status=200 state=20
20160311 13171725  -    		00.003.458
20160311 13171725  +    		mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30).0092152C mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (464) 
20160311 13171725 clnt  			mORMotHttpClient.TSQLHttpClientWebsockets(0403EE30) GET Accounts?session_signature=01869302000186DB21ED5E68 status=200 state=20
20160311 13171725  -    		00.002.208
20160311 13171725  -    	00.005.721
20160311 13171725  -    00.053.994

Offline

Board footer

Powered by FluxBB