mORMot Open Source

EgorovAlex

Member

Registered: 2015-02-18

Posts: 43

TestSQL3 project failed some tests, why?

Just install your latest version of mORMot, after starting TestSQL3 I'm have this log:
What I should to do to fix this problems?

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

1. Synopse libraries

1.1. Low level common:
  - System copy record: 22 assertions passed  115us
  - TDynArray: 519,427 assertions passed  119.86ms
  - TDynArrayHashed: 1,200,629 assertions passed  108.36ms
  - Fast string compare: 7 assertions passed  254us
!  - IdemPropName: 1 / 10 FAILED  647us
  - Url encoding: 105 assertions passed  1.02ms
  - IsMatch: 599 assertions passed  210us
  - Soundex: 35 assertions passed  124us
  - Numerical conversions: 783,638 assertions passed  125.50ms
  - Curr64: 20,039 assertions passed  974us
  - CamelCase: 5 assertions passed  181us
  - Bits: 4,614 assertions passed  204us
  - Ini files: 7,004 assertions passed  22.19ms
  - Unicode - Utf8: 60,081 assertions passed  847.21ms
  - Iso8601 date and time: 24,000 assertions passed  3.46ms
  - Url decoding: 1,100 assertions passed  284us
  - TSynTable: 873 assertions passed  3.28ms
  - TSynCache: 404 assertions passed  519us
  - TSynFilter: 1,005 assertions passed  2.10ms
  - TSynValidate: 677 assertions passed  742us
  - TSynLogFile: 42 assertions passed  505us
  Total failed: 1 / 2,624,316  - Low level common FAILED  1.24s

1.2. Low level types:
  - RTTI: 34 assertions passed  512us
  - Url encoding: 200 assertions passed  688us
  - Encode decode JSON: 250,232 assertions passed  82.67ms
  Total failed: 0 / 250,466  - Low level types PASSED  84.85ms

1.3. Big table:
  - TSynBigTable: 19,254 assertions passed  48.72ms
  - TSynBigTableString: 16,209 assertions passed  26.55ms
  - TSynBigTableMetaData: 384,060 assertions passed  974.13ms
  - TSynBigTableRecord: 452,185 assertions passed  2.21s
  Total failed: 0 / 871,708  - Big table PASSED  3.26s

1.4. Cryptographic routines:
  - Adler32: 1 assertion passed  303us
  - MD5: 1 assertion passed  306us
  - SHA1: 5 assertions passed  278us
  - SHA256: 5 assertions passed  224us
  - AES256: 6,372 assertions passed  54.04ms
  - Base64: 11,994 assertions passed  78.47ms
  Total failed: 0 / 18,378  - Cryptographic routines PASSED  135.15ms

1.5. Compression:
  - In memory compression: 12 assertions passed  173.20ms
  - Gzip format: 19 assertions passed  325.80ms
  - Zip format: 36 assertions passed  597.01ms
  - SynLZO: 3,006 assertions passed  63.20ms
  - SynLZ: 13,016 assertions passed  176.10ms
  Total failed: 0 / 16,089  - Compression PASSED  1.33s

1.6. Synopse PDF:
!  - TPdfDocument: 1 / 4 FAILED  2.39ms
  - TPdfDocumentGDI: 6 assertions passed  5.05ms
  Total failed: 1 / 10  - Synopse PDF FAILED  7.98ms

2. mORMot

2.1. Basic classes:
  - TSQLRecord: 47 assertions passed  235us
  - TSQLRecordSigned: 200 assertions passed  3.10ms
  - TSQLModel: 3 assertions passed  231us
  Total failed: 0 / 250  - Basic classes PASSED  4.21ms

2.2. File based:
  - Database direct access: 10,138 assertions passed  155.69ms
  - Virtual table direct access: 12 assertions passed  3.51ms
  - TSQLTableJSON: 19,030 assertions passed  33.30ms
  - TSQLRestClientDB: 599,030 assertions passed  5.64s
  Total failed: 0 / 628,210  - File based PASSED  5.83s

2.3. File based WAL:
  - Database direct access: 10,138 assertions passed  134.34ms
  - Virtual table direct access: 12 assertions passed  1.24ms
  - TSQLTableJSON: 19,030 assertions passed  28.67ms
  - TSQLRestClientDB: 599,030 assertions passed  5.57s
  Total failed: 0 / 628,210  - File based WAL PASSED  5.73s

2.4. Memory based:
  - Database direct access: 10,136 assertions passed  114.64ms
  - Virtual table direct access: 12 assertions passed  1.00ms
  - TSQLTableJSON: 19,030 assertions passed  25.71ms
  - TSQLRestClientDB: 667,323 assertions passed  6.02s
  Total failed: 0 / 696,501  - Memory based PASSED  6.16s

2.5. Client server access:
  - TSQLite3HttpServer: 2 assertions passed  14.07ms
     using THttpServer
!  - TSQLite3HttpClient: 1 / 1 FAILED  128.00s
!  - Http client keep alive: 50 / 84 FAILED  1251.99s
     first in 1187.99s,
!  - Http client multi connect: 50 / 84 FAILED  1279.99s
     first in 1215.99s,
  - Named pipe access: 3,085 assertions passed  701.46ms
     first in 85.47ms, done in 213.72ms i.e. 4678/s, aver. 213us, 21.8 MB/s
  - Local window messages: 3,084 assertions passed  61.03ms
     first in 3.69ms, done in 51.68ms i.e. 19346/s, aver. 51us, 90.4 MB/s
  - Direct in process access: 3,052 assertions passed  39.34ms
     first in 500us, done in 38.56ms i.e. 25931/s, aver. 38us, 121.2 MB/s
  Total failed: 101 / 9,392  - Client server access FAILED  2660.82s

2.6. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  491us
  - Service initialization: 127 assertions passed  4.99ms
  - Direct call: 596,163 assertions passed  21.87ms
  - Server side: 596,173 assertions passed  21.55ms
  - Client side REST: 596,175 assertions passed  265.12ms
  - Client side JSONRPC: 596,173 assertions passed  295.46ms
  - Client side synchronized REST: 596,173 assertions passed  2.12s
  - Security: 135 assertions passed  856us
  - Custom record layout: 596,173 assertions passed  276.04ms
  Total failed: 0 / 3,577,348  - Service oriented architecture PASSED  3.01s

2.7. External database:
  - External records: 1 assertion passed  183us
  - Auto adapt SQL: 168 assertions passed  6.75ms
  - Crypted database: 253,272 assertions passed  160.77ms
  - External via REST: 243,436 assertions passed  503.36ms
  - External via virtual table: 243,436 assertions passed  872.39ms
  Total failed: 0 / 740,313  - External database PASSED  1.54s

Synopse framework used: 1.17
SQlite3 engine used: 3.7.14
Generated with: Delphi XE7 compiler

Time elapsed for all tests: 2689.22s
Tests performed at 2/18/2015 10:30:42 AM

Total assertions failed for all test suits:  103 / 10,061,191

! Some tests FAILED: please correct the code.
Done - Press ENTER to Exit

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,662

Website

Re: TestSQL3 project failed some tests, why?

The version you are using (1.17) is clearly deprecated.
Please ensure you retrieve and install the latest 1.18 branch.
See http://synopse.info/files/html/Synopse% … l#TITL_113

EgorovAlex

Member

Registered: 2015-02-18

Posts: 43

Re: TestSQL3 project failed some tests, why?

Thanks, now i have for test version from 21 Feb 2015 and have only one issue with TestSQL3:

1.4. Synopse PDF:
!  - TPdfDocument: 1 / 4 FAILED  6.63ms
  - TPdfDocumentGDI: 8 assertions passed  765.71ms
  Total failed: 1 / 12  - Synopse PDF FAILED  773.19ms

This is normal?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,662

Website

Re: TestSQL3 project failed some tests, why?

Sounds like an issue due to your system code page.
Not a problem.

tdanop

Member

Registered: 2015-01-16

Posts: 27

Re: TestSQL3 project failed some tests, why?

TestSQL3 Failed to test LowLevel Types - Encode decode JSON with Access Violation.  I am using DelphiXE3 - Update2. Mormot Framework NightlyBuild on 14/12/2016 14:00.

Any idea?

Last edited by tdanop (2016-12-14 14:10:21)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,662

Website

Re: TestSQL3 project failed some tests, why?

I'm not able to reproduce the problem here.
Regression tests do pass.

Using mORMot 1.18.3251 FTS3
Running on Windows 7 64bit SP1 (6.1.7601) with code page 1252
TSQLite3LibraryStatic 3.15.2 with internal MM
Generated with: Delphi XE6 compiler

Time elapsed for all tests: 50.63s
Tests performed at 14/12/2016 16:58:45

Total assertions failed for all test suits:  0 / 27,199,273

But I do not have XE3 installed here...

What is your system code page?

tdanop

Member

Registered: 2015-01-16

Posts: 27

Re: TestSQL3 project failed some tests, why?

Well I think this could be the reason it fails, my DOS command prompt (cmd) gives active code page 737 which is not UTF-8.
I was try with chcp command in the registry to change cmd command to 65001 and 1253 active page,  but when I run the tests using these settings  I get the exactly the same fail result.
I also try with XE5 and XE10.1 Berlin starter edition with the same fail reason.  The rest of tests was successful.

May I had to switch my active page somehow to 65001 or 1253 inside to TestSQL3.pas, but I don't know how.

Last edited by tdanop (2016-12-15 09:06:10)

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,571

Website

Re: TestSQL3 project failed some tests, why?

You should change code page on Windows level (Windows Locale), not in cmd.  As described here http://knowledgebase.progress.com/articles/Article/4677

Last edited by mpv (2016-12-15 09:17:35)

tdanop

Member

Registered: 2015-01-16

Posts: 27

Re: TestSQL3 project failed some tests, why?

I think this is not the reason it fails, when I debugged seems actually it hangs on HttpGet('https://api.github.com/users/zendframework/repos'); with class EwinHTTP error 12002 Operation Timed Out then coms the access violation and the whole test fails.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,662

Website

Re: TestSQL3 project failed some tests, why?

I suspect you have a proxy to connect to internet...