mORMot Open Source

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

TestSQL3 on XE3

Hi folks,

I'm setting up a new machine Windows 7, Delphi XE3 and mORMot nightly build 2014-09-23_221033_ada8020315 just for the sake of check I ran TestSQL3 ( TestSQL3Register first )

 2.8. External database:
  - TQuery: 2,003 assertions passed  8.82ms
  - External records: 2 assertions passed  612us
  - Auto adapt SQL: 448 assertions passed  25.88ms
  - Crypted database: 253,275 assertions passed  137.00ms
!  - External via REST: 21,893 / 168,346 FAILED  1.26s
!  - External via virtual table: 21,893 / 168,346 FAILED  2.33s
!  - External via REST with change tracking: 22,814 / 178,446 FAILED  2.38s
  - JET database: 7,007 assertions passed  697.57ms
  Total failed: 66,600 / 777,873  - External database FAILED  6.88s

There are three failed tests, the log has the following:

20140924 15592341 EXC   EInterfaceFactoryException ("Invalid TInterfacedObjectFake.FakeCall() for ICalculator.Add: TInterfaceStub returned error: expected exception") at 0064AE5F  stack trace 00526B38 0074BC03 0040AF64 007537C1 75C833CA 77509ED2 77509EA5 
20140924 15592341 EXC   ESynException ("expected exception") at 006501F4  stack trace 00526B38 0074BC03 0040AF64 007537C1 75C833CA 77509ED2 77509EA5 
20140924 15592423 fail  TTestExternalDatabase(003CAA40) External database: External via REST "" stack trace API 00536DAE 0053C04B 00525AAD 0072DE64 0072B81B 00526B38 0074BC03 007537C1 75C833CA 77509ED2 77509EA5 
20140924 15592423 fail  TTestExternalDatabase(003CAA40) External database: External via REST "" stack trace API 00536DAE 0053C04B 00525AAD 0072E1C2 0072B81B 00526B38 0074BC03 007537C1 75C833CA 77509ED2 77509EA5 
...

I can see the same behavior on Delphi XE.

Has anyone else seen this ?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

Are you using latest 3.8.6 sqlite obj?

I do not have any problem on my side.

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

I downloaded both (mormot and sqlite) files at the same time I suppose they are the latest, can't see version number on file properties how can I check that?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

The version number is written at the end of the tests.

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

Well I must be blind, here you are :

Synopse framework used: 1.18.275
SQlite3 engine used: 3.8.6
Generated with: Delphi XE compiler

Same with XE3

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

UPDATE: Downloaded latest version:

 2.8. External database:
  - TQuery: 2,003 assertions passed  6.38ms
  - External records: 2 assertions passed  512us
  - Auto adapt SQL: 448 assertions passed  19.22ms
  - Crypted database: 253,275 assertions passed  155.50ms
!  - External via REST: 21,893 / 168,346 FAILED  1.31s
!  - External via virtual table: 21,893 / 168,346 FAILED  2.38s
!  - External via REST with change tracking: 22,808 / 178,446 FAILED  2.47s
  - JET database: 7,007 assertions passed  920.15ms
  Total failed: 66,594 / 777,873  - External database FAILED  7.27s

Synopse framework used: 1.18.281
SQlite3 engine used: 3.8.6
Generated with: Delphi XE3 compiler

Time elapsed for all tests: 72.12s
Tests performed at 25/09/2014 09:28:31 a.m.

Total assertions failed for all test suits:  66,594 / 17,532,744
! Some tests FAILED: please correct the code.

So I got the same behavior with latest sources on the TestSQL3 just FYI.

Is it just me?  Now I tested with 3 different PC's (two with XE3 and 1 with XE)

Last edited by moctes (2014-09-25 14:35:21)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

I was not able to reproduce it here.

What are the failing tests?
Please enable detailed map info to have the line numbers in the log.

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

From the log with detailed map info

20140925 13064013 EXC   EInterfaceFactoryException ("Invalid TInterfacedObjectFake.FakeCall() for ICalculator.Add: TInterfaceStub returned error: expected exception") at 001B1787 mORMot.RaiseError (36492)  stack trace 002ACCF7 mORMotSelfTests.SQLite3ConsoleTests (198) 0000662C System.@StartExe 
20140925 13064013 EXC   ESynException ("expected exception") at 001B6850 mORMot.TInterfaceStub.Invoke (37902)  stack trace 002ACCF7 mORMotSelfTests.SQLite3ConsoleTests (198) 0000662C System.@StartExe 
20140925 13064111 fail  TTestExternalDatabase(0084A950) External database: External via REST "" stack trace API 002905BD SynSelfTests.TTestExternalDatabase.Test (8503) 0028DD2B SynSelfTests.TTestExternalDatabase.ExternalViaREST (8085) 002ACCF7 mORMotSelfTests.SQLite3ConsoleTests (198) 
20140925 13064111 fail  TTestExternalDatabase(0084A950) External database: External via REST "" stack trace API 0029091B SynSelfTests.TTestExternalDatabase.Test (8525) 0028DD2B SynSelfTests.TTestExternalDatabase.ExternalViaREST (8085) 002ACCF7 mORMotSelfTests.SQLite3ConsoleTests (198) 
20140925 13064111 fail  TTestExternalDatabase(0084A950) External database: External via REST "" stack trace API 002905BD SynSelfTests.TTestExternalDatabase.Test (8503) 0028DD2B SynSelfTests.TTestExternalDatabase.ExternalViaREST (8085) 002ACCF7 mORMotSelfTests.SQLite3ConsoleTests (198) 

Call stack on first fail when running from IDE with debugging:

SynCommons.TSynLog.DebuggerNotify((...),'Test failed %')
SynCommons.TSynTestCase.TestFailed('')
SynSelfTests.TTestExternalDatabase.Test(True,False)
SynSelfTests.TTestExternalDatabase.ExternalViaREST
SynCommons.TSynTests.Run
mORMotSelfTests.SQLite3ConsoleTests
TestSQL3.TestSQL3
:760b1174 kernel32.BaseThreadInitThunk + 0x12
:7753b3f5 ntdll.RtlInitializeExceptionChain + 0x63
:7753b3c8 ntdll.RtlInitializeExceptionChain + 0x36

Does it help ?

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

UPDATE: Nightly build from today,  same tests failed:

Synopse framework used: 1.18.290
SQlite3 engine used: 3.8.6
Generated with: Delphi XE3 compiler

I don't have a single problem with my mORMot production code, I'm just reporting TestSQL3 Behavior :-)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

Are you on win1252 code page?

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

Yes I am

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

I was not able to reproduce the issue.
I do not have XE3 at hand, the closest installed versions are XE2 and XE4... which both compile and run just fine!

Synopse framework used: 1.18.303
Running on wSeven_64 with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi XE4 compiler

Time elapsed for all tests: 45.92s
Tests performed at 01/10/2014 12:04:44

Total assertions failed for all test suits:  0 / 17,381,869
! All tests passed successfully.

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

I understand because I been there ;-), unfortunately I only have 2007,  XE and XE3 and the tests previously ran fine,  right now I don't have the time but maybe in a few weeks I can download a Delphi XE7 trial version and see what will happen there

Thanks for taking a look at this

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab,

DXE2-32(w7-64)

   Synopse mORMot Framework Automated tests
  ------------------------------------------

1. Synopse libraries

 1.1. Low level common:
  - System copy record: 22 assertions passed  89us
  - TRawUTF8List: 70,005 assertions passed  34.70ms
  - TDynArray: 1,027,703 assertions passed  117.32ms
  - TDynArrayHashed: 1,200,629 assertions passed  78.43ms
  - TObjectListHashed: 999,874 assertions passed  286.99ms
  - TObjectDynArrayWrapper: 167,501 assertions passed  14.11ms
  - Fast string compare: 7 assertions passed  126us
  - IdemPropName: 30 assertions passed  91us
  - Url encoding: 130 assertions passed  920us
  - GUID: 9,007 assertions passed  3.26ms
  - IsMatch: 599 assertions passed  161us
  - Soundex: 35 assertions passed  114us
  - Numerical conversions: 1,116,461 assertions passed  220.57ms
  - crc32c: 30,030 assertions passed  65.20ms
      pas 23.75ms 251.1 MB/s fast 2.81ms 2.0 GB/s sse42 1.22ms 778.5 MB/s
  - Curr 64: 20,053 assertions passed  896us
  - CamelCase: 11 assertions passed  102us
  - Bits: 4,774 assertions passed  139us
  - Ini files: 7,004 assertions passed  17.77ms
  - UTF8: 81,128 assertions passed  936.68ms
  - Iso 8601 date and time: 36,015 assertions passed  4.52ms
  - Url decoding: 1,100 assertions passed  268us
  - Mime types: 23 assertions passed  123us
!  - TSynTable: 197 / 875 FAILED  4.88ms
  - TSynCache: 404 assertions passed  206us
  - TSynFilter: 1,005 assertions passed  2.20ms
  - TSynValidate: 677 assertions passed  564us
  - TSynLogFile: 42 assertions passed  304us
  Total failed: 197 / 4,775,144  - Low level common FAILED  1.79s
      
...

Synopse framework used: 1.18.305
Running on wSeven_64 with code page 1250
SQlite3 engine used: 3.8.6
Generated with: Delphi XE2 compiler

Time elapsed for all tests: 43.57s
Tests performed at 2014-10-01 15:49:25

Total assertions failed for all test suits:  197 / 17,382,332
! Some tests FAILED: please correct the code.

Done - Press ENTER to Exit

DXE7-32(W7-64)

   Synopse mORMot Framework Automated tests
  ------------------------------------------


1. Synopse libraries

 1.1. Low level common:
  - System copy record: 22 assertions passed  148us
  - TRawUTF8List: 70,005 assertions passed  41.05ms
  - TDynArray: 1,027,703 assertions passed  122.85ms
  - TDynArrayHashed: 1,200,629 assertions passed  79.82ms
  - TObjectListHashed: 999,897 assertions passed  282.26ms
  - TObjectDynArrayWrapper: 167,501 assertions passed  14.30ms
  - Fast string compare: 7 assertions passed  221us
  - IdemPropName: 30 assertions passed  114us
  - Url encoding: 130 assertions passed  935us
  - GUID: 9,007 assertions passed  3.62ms
  - IsMatch: 599 assertions passed  231us
  - Soundex: 35 assertions passed  79us
  - Numerical conversions: 1,117,024 assertions passed  220.94ms
  - crc32c: 30,030 assertions passed  64.47ms
      pas 23.57ms 253.0 MB/s fast 2.91ms 2.0 GB/s sse42 1.26ms 624.3 MB/s
  - Curr 64: 20,053 assertions passed  952us
  - CamelCase: 11 assertions passed  297us
  - Bits: 4,774 assertions passed  467us
  - Ini files: 7,004 assertions passed  19.49ms
  - UTF8: 81,128 assertions passed  931.80ms
  - Iso 8601 date and time: 36,015 assertions passed  3.79ms
  - Url decoding: 1,100 assertions passed  560us
  - Mime types: 23 assertions passed  499us
!  - TSynTable: 193 / 875 FAILED  5.73ms
  - TSynCache: 404 assertions passed  586us
  - TSynFilter: 1,005 assertions passed  2.21ms
  - TSynValidate: 677 assertions passed  579us
  - TSynLogFile: 42 assertions passed  449us
  Total failed: 193 / 4,775,730  - Low level common FAILED  1.80s

...

Synopse framework used: 1.18.305
Running on wSeven_64 with code page 1250
SQlite3 engine used: 3.8.6
Generated with: Delphi XE7 compiler

Time elapsed for all tests: 66.57s
Tests performed at 2014-10-01 15:55:50

Total assertions failed for all test suits:  193 / 17,410,844
! Some tests FAILED: please correct the code.

Done - Press ENTER to Exit

D2007(W8.1-64)

   Synopse mORMot Framework Automated tests
  ------------------------------------------


1. Synopse libraries

 1.1. Low level common:
  - System copy record: 22 assertions passed  561us
  - TRawUTF8List: 70,005 assertions passed  159.33ms
  - TDynArray: 1,027,702 assertions passed  199.20ms
  - TDynArrayHashed: 1,200,629 assertions passed  156.89ms
  - TObjectListHashed: 999,874 assertions passed  506.64ms
  - TObjectDynArrayWrapper: 167,501 assertions passed  33.63ms
  - Fast string compare: 7 assertions passed  231us
  - IdemPropName: 30 assertions passed  494us
  - Url encoding: 130 assertions passed  1.15ms
  - GUID: 9,005 assertions passed  1.85ms
  - IsMatch: 599 assertions passed  472us
  - Soundex: 35 assertions passed  356us
  - Numerical conversions: 1,115,554 assertions passed  410.27ms
  - crc32c: 20,020 assertions passed  74.53ms
      pas 25.41ms 234.7 MB/s fast 4.37ms 1.3 GB/s
  - Curr 64: 20,053 assertions passed  1.73ms
  - CamelCase: 11 assertions passed  208us
  - Bits: 4,774 assertions passed  743us
  - Ini files: 7,004 assertions passed  37.01ms
  - UTF8: 81,128 assertions passed  955.47ms
  - Iso 8601 date and time: 36,015 assertions passed  6.24ms
  - Url decoding: 1,100 assertions passed  510us
  - Mime types: 23 assertions passed  265us
!  - TSynTable: 193 / 875 FAILED  11.72ms
  - TSynCache: 404 assertions passed  363us
  - TSynFilter: 1,005 assertions passed  2.86ms
  - TSynValidate: 677 assertions passed  1.81ms
  - TSynLogFile: 42 assertions passed  6.09ms
  Total failed: 193 / 4,764,224  - Low level common FAILED  2.58s

 1.2. Low level types:
  - RTTI: 58 assertions passed  581us
  - Url encoding: 200 assertions passed  990us
  - Encode decode JSON: 262,094 assertions passed  155.85ms
  - Variants: 5 assertions passed  372us
  - Mustache renderer: 142 assertions passed  3.59ms
  - TDocVariant: 71,670 assertions passed  189.61ms
  - BSON: 245,048 assertions passed  3.71ms
  Total failed: 0 / 579,217  - Low level types PASSED  361.34ms

 1.3. Big table:
  - TSynBigTable: 19,220 assertions passed  117.68ms
  - TSynBigTableString: 16,053 assertions passed  24.74ms
  - TSynBigTableMetaData: 384,062 assertions passed  1.20s
  - TSynBigTableRecord: 304,062 assertions passed  1.79s
  Total failed: 0 / 723,397  - Big table PASSED  3.14s

 1.4. Synopse PDF:
!  - TPdfDocument: 1 / 2 FAILED  8.27ms
  - TPdfDocumentGDI: 5 assertions passed  734.50ms
  Total failed: 1 / 7  - Synopse PDF FAILED  744.82ms

 1.5. Cryptographic routines:
  - Adler32: 1 assertion passed  789us
  - MD5: 1 assertion passed  281us
  - SHA1: 5 assertions passed  399us
  - SHA256: 5 assertions passed  385us
  - AES256: 16,815 assertions passed  1.01s
  - RC4: 1 assertion passed  235us
  - Base64: 11,994 assertions passed  112.27ms
  - CompressShaAes: 1,683 assertions passed  4.59ms
  Total failed: 0 / 30,505  - Cryptographic routines PASSED  1.13s

 1.6. Compression:
  - In memory compression: 12 assertions passed  308.54ms
  - GZIP format: 19 assertions passed  584.01ms
  - ZIP format: 36 assertions passed  1.02s
  - SynLZO: 3,006 assertions passed  101.78ms
  - SynLZ: 30,019 assertions passed  768.13ms
  Total failed: 0 / 33,092  - Compression PASSED  2.79s


2. mORMot

 2.1. File based:
!  - Database direct access: 2 / 10,138 FAILED  351.48ms
  - Virtual table direct access: 12 assertions passed  2.52ms
  - TSQLTableJSON: 106,068 assertions passed  118.78ms
  - TSQLRestClientDB: 608,165 assertions passed  4.47s
  Total failed: 2 / 724,383  - File based FAILED  4.95s

 2.2. File based memory map:
!  - Database direct access: 1 / 10,136 FAILED  337.58ms
  - Virtual table direct access: 12 assertions passed  3.22ms
  - TSQLTableJSON: 106,068 assertions passed  119.20ms
  - TSQLRestClientDB: 608,164 assertions passed  4.84s
  Total failed: 1 / 724,380  - File based memory map FAILED  5.31s

 2.3. File based WAL:
!  - Database direct access: 2 / 10,138 FAILED  359.53ms
  - Virtual table direct access: 12 assertions passed  1.97ms
  - TSQLTableJSON: 106,068 assertions passed  116.03ms
  - TSQLRestClientDB: 608,165 assertions passed  4.81s
  Total failed: 2 / 724,383  - File based WAL FAILED  5.29s

 2.4. Memory based:
!  - Database direct access: 1 / 10,136 FAILED  327.44ms
  - Virtual table direct access: 12 assertions passed  1.85ms
  - TSQLTableJSON: 106,068 assertions passed  110.49ms
!  - TSQLRestClientDB: 2 / 676,461 FAILED  5.51s
  - RTree: 140,000 assertions passed  1.45s
  Total failed: 3 / 932,677  - Memory based FAILED  7.41s

 2.5. Basic classes:
  - TSQLRecord: 79 assertions passed  1.40ms
  - TSQLRecordSigned: 200 assertions passed  6.07ms
  - TSQLModel: 3 assertions passed  195us
  - TSQLRestServerFullMemory: 562,311 assertions passed  837.07ms
  Total failed: 0 / 562,593  - Basic classes PASSED  850.35ms

 2.6. Client server access:
  - TSQLHttpServer: 2 assertions passed  6.03ms
     using HTTP API 2.0
!  - TSQLHttpClient: 1 / 3 FAILED  41.96ms
  - HTTP client keep alive: 3,087 assertions passed  346.84ms
     4818 B, first 8.32ms, done 319.59ms i.e. 3128/s, aver. 319us, 14.6 MB/s
  - HTTP client multi connect: 3,087 assertions passed  343.35ms
     4818 B, first 762us, done 323.31ms i.e. 3092/s, aver. 323us, 14.4 MB/s
  - HTTP client encrypted: 3,087 assertions passed  403.44ms
     4818 B, first 955us, done 381.79ms i.e. 2619/s, aver. 381us, 12.2 MB/s
  - Named pipe access: 3,089 assertions passed  697.58ms
     4818 B, first 258.27ms, done 223.96ms i.e. 4465/s, aver. 223us, 20.8 MB/s
  - Local window messages: 3,088 assertions passed  57.82ms
     4818 B, first 138us, done 48.74ms i.e. 20515/s, aver. 48us, 95.9 MB/s
  - Direct in process access: 3,056 assertions passed  53.32ms
     4818 B, first 55us, done 38.24ms i.e. 26147/s, aver. 38us, 122.2 MB/s
  - HTTP several DB servers: 9,604 assertions passed  1.04s
     4818 B, first 635us, done 296.48ms i.e. 3372/s, aver. 296us, 15.7 MB/s
     4818 B, first 611us, done 296.86ms i.e. 3368/s, aver. 296us, 15.7 MB/s
     4818 B, first 623us, done 292.75ms i.e. 3415/s, aver. 292us, 15.9 MB/s
  Total failed: 1 / 28,103  - Client server access FAILED  3.03s

 2.7. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  2.22ms
  - Service initialization: 243 assertions passed  4.52ms
  - Direct call: 572,877 assertions passed  39.48ms
  - Server side: 572,896 assertions passed  40.35ms
  - Client side REST: 572,901 assertions passed  758.12ms
  - Client side REST result as object: 572,895 assertions passed  777.10ms
  - Client side REST locked: 572,898 assertions passed  766.93ms
  - Client side REST synchronized: 572,898 assertions passed  3.10s
  - Client side REST background thread: 572,898 assertions passed  2.47s
  - Client side REST weak authentication: 572,895 assertions passed  723.18ms
  - Client side http basic authentication: 572,895 assertions passed  877.54ms
  - Client side REST custom record layout: 572,895 assertions passed  795.38ms
  - Client side JSONRPC: 572,895 assertions passed  841.45ms
  - Test over HTTP: 9,322 assertions passed  569.40ms
  - Security: 135 assertions passed  2.45ms
  - Mocks and stubs: 30,031 assertions passed  68.99ms
  Total failed: 0 / 6,341,630  - Service oriented architecture PASSED  11.86s

 2.8. External database:
  - TQuery: 2,003 assertions passed  15.28ms
  - External records: 2 assertions passed  389us
  - Auto adapt SQL: 624 assertions passed  51.96ms
  - Crypted database: 253,275 assertions passed  275.41ms
  - External via REST: 168,346 assertions passed  1.99s
  - External via virtual table: 168,346 assertions passed  6.25s
  - External via REST with change tracking: 178,446 assertions passed  4.53s
  - JET database: 7,007 assertions passed  1.13s
  Total failed: 0 / 778,049  - External database PASSED  14.26s

 2.9. Multi thread process:
  - Create thread pool: 1 assertion passed  3.41ms
  - TSQLRestServerDB: 4,822 assertions passed  243.79ms
     1=17244/s  2=11551/s  5=7051/s  10=11197/s  30=8954/s  50=11300/s
  - TSQLRestClientDB: 4,822 assertions passed  306.72ms
     1=15081/s  2=8364/s  5=13439/s  10=8733/s  30=8952/s  50=4024/s
  - TSQLRestClientURINamedPipe: 2,412 assertions passed  1.52s
     1=1100/s  2=860/s  5=826/s
  - TSQLRestClientURIMessage: 3,222 assertions passed  208.30ms
     1=6856/s  2=9053/s  5=9823/s  10=7556/s
  - TSQLHttpClientWinHTTP_HTTPAPI: 4,822 assertions passed  578.86ms
     1=3085/s  2=4453/s  5=4717/s  10=4833/s  30=4836/s  50=4377/s
  - TSQLHttpClientWinSock_WinSock: 4,822 assertions passed  544.54ms
     1=5866/s  2=6364/s  5=7166/s  10=7437/s  30=6692/s  50=3140/s
  - Locked: 4,821 assertions passed  261.43ms
     1=15625/s  2=14931/s  5=13941/s  10=10071/s  30=7316/s  50=5524/s
  - Unlocked: 4,822 assertions passed  239.17ms
     1=14458/s  2=14536/s  5=11180/s  10=6079/s  30=17625/s  50=8629/s
  - Background thread: 4,822 assertions passed  657.61ms
     1=12185/s  2=14398/s  5=12565/s  10=6692/s  30=1915/s  50=1411/s
  - Main thread: 4,822 assertions passed  250.01ms
     1=12043/s  2=10033/s  5=11508/s  10=8379/s  30=16901/s  50=6852/s
  Total failed: 0 / 44,210  - Multi thread process PASSED  4.84s


Synopse framework used: 1.18.305
Running on wEight_64 with code page 1250
SQlite3 engine used: 3.8.6
Generated with: Delphi 2007 compiler

Time elapsed for all tests: 73.69s
Tests performed at 2014-10-01 16:08:21

Total assertions failed for all test suits:  203 / 16,990,850
! Some tests FAILED: please correct the code.

Done - Press ENTER to Exit

Michal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

@miab3
You are not on a Win1252 code page (but 1250), so some tests do fail.
Sadly, this is not yet fixed - we run the tests on Win1252 windows.

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab,

...
Running on wSeven_64 with code page 1250
...
Running on wEight_64 with code page 1250
...

Michal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

@miab3
Yes, this was what I wrote: you are using code page 1250.

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab,

How to force a test for the code page 1252?

Michal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

Change the "Language for non Unicode programs".
See http://adriank.org/changing-windows-7-s … -registry/

This would need a computer restart.

warleyalex

Member

From: Sete Lagoas-MG, Brasil

Registered: 2013-01-20

Posts: 250

Re: TestSQL3 on XE3

Apparently this is still occurs in XE3 and D7.
Datetime download: 2014-09-30 09:59:32
filename: mORMot+and+Open+Source+friends-2a40fe0a0f246db0_30092014-095932.zip
------------------------------------------------------------------------------------

DELPHI X3:

---------
2.8. External database:
  - TQuery: 2,003 assertions passed  38.61ms
  - External records: 2 assertions passed  517us
  - Auto adapt SQL: 624 assertions passed  131.77ms
  - Crypted database: 253,275 assertions passed  717.95ms
!  - External via REST: 21,981 / 168,346 FAILED  5.64s
!  - External via virtual table: 21,981 / 168,346 FAILED  10.43s
!  - External via REST with change tracking: 22,992 / 178,446 FAILED  10.66s
  - JET database: 7,007 assertions passed  3.79s
  Total failed: 66,954 / 778,049  - External database FAILED  31.43s

Synopse framework used: 1.18.299
Running on wXP with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi XE3 compiler

DELPHI 7
--------

2.8. External database:
  - TQuery: 2,003 assertions passed  47.52ms
  - External records: 2 assertions passed  514us
  - Auto adapt SQL: 624 assertions passed  120.66ms
  - Crypted database: 253,275 assertions passed  598.87ms
!  - External via REST: 21,981 / 168,346 FAILED  5.05s
!  - External via virtual table: 21,981 / 168,346 FAILED  9.75s
!  - External via REST with change tracking: 22,992 / 178,446 FAILED  9.19s
  - JET database: 7,007 assertions passed  2.90s
  Total failed: 66,954 / 778,049  - External database FAILED  27.67s

Synopse framework used: 1.18.299
Running on wXP with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi 7 compiler

I recently updated mORMot to test cross platform project, linux and Lazarus/FPC and apparently mORMot is broken after september 30, 2014.

Does anyone has any clue of what have changed in mORMot after 2014-09-30 09:59:32?
mORMot+and+Open+Source+friends-0a1175cf9b0fb82e.zip 2014-10-01 10:11:56
mORMot+and+Open+Source+friends-e327eb2fe6b597c9.zip 2014-10-01 12:03
mORMot+and+Open+Source+friends-225859e862ea3e93.zip 2014-10-01 13:22
---------------------
D7 and DX3, I always get Runtime error 216 at 00404666, running testsql3.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

Synopse framework used: 1.18.311
Running on wSeven_64 with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi XE7 compiler

Time elapsed for all tests: 43.84s
Tests performed at 04/10/2014 00:13:00

Total assertions failed for all test suits:  0 / 17,408,107
! All tests passed successfully.

Synopse framework used: 1.18.311
Running on wSeven_64 with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi 7 compiler

Time elapsed for all tests: 38.76s
Tests performed at 04/10/2014 00:17:46

Total assertions failed for all test suits:  0 / 17,000,628
! All tests passed successfully.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

But there seems to be an issue with deprecated blocking Backup/Restore methods, which are unstable.
I guess this is the cause of your particular problem, even if - by chance - it works on my PC.

I would probably completely disable those in the regression tests, in favor to the safer background backup - see http://blog.synopse.info/post/2014/08/1 … 3-Database

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab,

After 1.16.346

DXE2-32(w7-64) 1 error:

1.1
!  - TSynTable: 101 / 875 FAILED  6.25ms

D2007(W8.1-64) 2 errors:

1.1
!  - TSynTable: 187 / 875 FAILED  12.75ms

1.4
!  - TPdfDocument: 1 / 2 FAILED  7.97ms

Michal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

I just tested with XE4 and 2007. No problem.

Synopse framework used: 1.18.346
Running on wSeven_64 with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi 2007 compiler

Time elapsed for all tests: 33.58s
Tests performed at 16/10/2014 18:33:03

Total assertions failed for all test suits:  0 / 17,163,719
! All tests passed successfully.

What is your system code page?
Here we have code page 1252.

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab,

What is your system code page?

1250, but why just only in those places is the problem?

Michal

Last edited by miab3 (2014-10-16 16:36:53)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

Because there is some WinAnsi random strings, with accents, which fails to convert to/from variants.
The regression tests are too optimistic about variant storage, I'm afraid.

What are the exact source code lines which failed, e.g. for TSynTable ?

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab

Now, after 1.16.351

DXE2-32(w7-64)

2.5. Basic classes:
!  - TSQLRecord: 1 / 80 FAILED  1.27ms

D2007(W8.1-64)

1.1. Low level common:
!  - TSynTable: 187 / 875 FAILED  13.55ms

1.4. Synopse PDF:
!  - TPdfDocument: 1 / 2 FAILED  7.80ms

2.5. Basic classes:
!  - TSQLRecord: 1 / 80 FAILED  1.68ms

cp1250

Michal

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

My current tests status:

2.8. External database:
  - TQuery: 2,003 assertions passed  7.83ms
  - External records: 2 assertions passed  877us
  - Auto adapt SQL: 624 assertions passed  31.56ms
  - Crypted database: 253,275 assertions passed  167.23ms
!  - External via REST: 21,893 / 168,339 FAILED  1.21s
!  - External via virtual table: 21,893 / 168,339 FAILED  1.82s
!  - External via REST with change tracking: 22,904 / 178,439 FAILED  2.55s
  - JET database: 7,007 assertions passed  987.85ms
  Total failed: 66,690 / 778,028  - External database FAILED  6.79s

Synopse framework used: 1.18.346
Running on wSeven_64 with code page 1252
SQlite3 engine used: 3.8.6
Generated with: Delphi XE3 compiler

Time elapsed for all tests: 73.65s
Tests performed at 17/10/2014 05:18:22 p.m.

Total assertions failed for all test suits:  66,690 / 17,544,492
! Some tests FAILED: please correct the code.

Regards

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab

Now, after 1.16.354

DXE2-32(w7-64)

Synopse framework used: 1.18.354
Running on wSeven_64 with code page 1250
SQlite3 engine used: 3.8.6
Generated with: Delphi XE2 compiler

Time elapsed for all tests: 36.42s
Tests performed at 2014-10-18 10:52:05

Total assertions failed for all test suits:  0 / 17,542,191
! All tests passed successfully.
(Add: on  W8.1-64 ->  !  - TPdfDocument: 1 / 2 FAILED  5.51ms)

D2007(W8.1-64)

1.1. Low level common:
!  - TSynTable: 188 / 875 FAILED  11.99ms

1.4. Synopse PDF:
!  - TPdfDocument: 1 / 2 FAILED  7.80ms

cp1250

Michal

Last edited by miab3 (2014-10-18 10:39:44)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

All due to cp 1250...

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab

R_1.16.355

DXE2-32(w7-64)

Synopse framework used: 1.18.355
Running on wSeven_64 with code page 1250
SQlite3 engine used: 3.8.6
Generated with: Delphi XE2 compiler

Time elapsed for all tests: 36.71s
Tests performed at 2014-10-19 13:19:51

Total assertions failed for all test suits:  0 / 17,540,355
! All tests passed successfully.

================================

D2007(W8.1-64)

1.4. Synopse PDF:
!  - TPdfDocument: 1 / 2 FAILED  10.67ms

Synopse framework used: 1.18.355
Running on wEight_64 with code page 1250
SQlite3 engine used: 3.8.6
Generated with: Delphi 2007 compiler

Time elapsed for all tests: 70.51s
Tests performed at 2014-10-19 13:12:26

Total assertions failed for all test suits:  1 / 17,156,035
! Some tests FAILED: please correct the code.

Michal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

What is the failing test for D2007?

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab

Mistake occurs on Windows.8.1-64(in both versions).
On Windows 7-64 both versions pass without error.

Michal

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,658

Website

Re: TestSQL3 on XE3

What is the failing source code line?

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: TestSQL3 on XE3

@ab

The same on Windows 10-64 (with cp1252), for both DXE2-32 and D2007.

On D2007:

SynCommons.TSynLog.DebuggerNotify(???,???)
SynCommons.TSynTestCase.TestFailed('')
SynSelfTests.TTestSynopsePDF._TPdfDocument
SynCommons.TSynTests.Run
mORMotSelfTests.SQLite3ConsoleTests
TestSQL3.TestSQL3
:7571919f KERNEL32.BaseThreadInitThunk + 0xe
:771d0bbb ntdll.RtlInitializeExceptionChain + 0x84
:771d0b91 ntdll.RtlInitializeExceptionChain + 0x5a

SynSelfTest.pas line 6900:
       //MS.SaveToFile(ChangeFileExt(paramstr(0),'.pdf'));
      Check(Hash32(MS.Memory,MS.Position)=Hash[embed]);
      if not embed then begin      // <===
        if CharSet<>ANSI_CHARSET then

Michal

moctes

Member

From: Mexico

Registered: 2013-05-11

Posts: 129

Re: TestSQL3 on XE3

Hi Arnaud,

I found sometime to dig deeper on the failed tests, the TestSQL3 program is failing at first at p line 8576 (SynSefTests.pas) :

n := 0;
        while RInt.FillOne do begin
          if RInt.fID<100 then // some real entries for backup testing
            aExternalClient.Add(RInt,true,true);
          RExt.Data := RInt.Data;
          RExt.FirstName := RInt.FirstName;
          RExt.LastName := RInt.LastName;
          RExt.YearOfBirth := RInt.YearOfBirth;
          RExt.YearOfDeath := RInt.YearOfDeath;
          {$ifndef NOVARIANTS}
          RExt.Value := ValuesToVariantDynArray(['text',RInt.YearOfDeath]);
          {$endif}
          RExt.fLastChange := 0;
          RExt.CreatedAt := 0;
          if RInt.fID>100 then begin
            if aExternalClient.BatchCount=0 then
              aExternalClient.BatchStart(TSQLRecordPeopleExt);
            aExternalClient.BatchAdd(RExt,true);
          end else begin
            aID := aExternalClient.Add(RExt,true);
            Check(aID<>0);
            Check(RExt.LastChange>=Start);  //  <--------- HERE!

Values

aID = 1
  RExt.LastChange = 135197975833
  Start = 135197975833

aID = 2
  RExt.LastChange = 135197955540
  Start = 135197975833

The test fails when aID > 1 don't know if this behaviour rings a bell for you.

What do you think?