Pages: 1

#1 2013-10-03 13:29:51

thomasg
Member
Registered: 2013-10-03
Posts: 1

TestSQL3 fails Delphi 7 - Windows 7

1.6. Synopse PDF:
! - TPdfDocument: 1/2/FAILED

2.2 File Based:
! - Database direct access: ... FAILED
{the same error occurs later}

I have already run TestSqlRegister but i do not think this is the issue.


Logs
20131003 15555032 fail  TTestSynopsePDF(01FD3778) Synopse PDF: TPdfDocument "" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00531D39 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555055 fail  TTestFileBased(01FBDA98) File based: Database direct access "Expected ExecuteJSON result not retrieved" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00504160 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555055 fail  TTestFileBased(01FBDA98) File based: Database direct access "ExecuteJSON crypted" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00504259 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00507F7E 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00507F9B 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00507FB6 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00507FCD 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00507FE3 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "Retrieve" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00505768 00507FF3 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "Retrieve" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 005057B7 00507FF3 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "Retrieve" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 005057DC 00507FF3 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "Retrieve" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 005057FA 00507FF3 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "Retrieve" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 00505817 00507FF3 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 fail  TTestFileBased(01FBDA98) File based: TSQLRestClientDB "check RETRIEVE/GET" stack trace API 0044E6EA 0044DE3E 00450A7B 0043748F 0043727A 0050800F 00437DA2 0053BA4E 0053BD5D 759B336A 77489F72 77489F45
20131003 15555061 EXC   ESQLite3Exception ("unrecognized token: \"0000004C000F86416DE84493\"") at 00461E1B  stack trace API 0044D270 ..............

Thanks in advance

Offline

#2 2013-10-03 15:05:44

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

Re: TestSQL3 fails Delphi 7 - Windows 7

I just made the tests under Windows 7 and Delphi 7 compiler, with the latest version of the source.

No problem at all:

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


1. Synopse libraries

 1.1. Low level common:
  - System copy record: 22 assertions passed  269us
  - TDynArray: 1,011,445 assertions passed  89.85ms
  - TDynArrayHashed: 1,200,629 assertions passed  64.57ms
  - Fast string compare: 7 assertions passed  85us
  - IdemPropName: 10 assertions passed  77us
  - Url encoding: 105 assertions passed  723us
  - IsMatch: 599 assertions passed  276us
  - Soundex: 35 assertions passed  105us
  - Numerical conversions: 886,312 assertions passed  180.98ms
  - Curr 64: 20,053 assertions passed  1.04ms
  - CamelCase: 11 assertions passed  75us
  - Bits: 4,614 assertions passed  80us
  - Ini files: 7,004 assertions passed  15.51ms
  - Unicode - UT F 8: 69,093 assertions passed  633.49ms
  - Iso 8601 date and time: 24,006 assertions passed  3.02ms
  - Url decoding: 1,100 assertions passed  243us
  - Mime types: 19 assertions passed  134us
  - TSynTable: 41 assertions passed  1.40ms
  - TSynCache: 404 assertions passed  166us
  - TSynFilter: 1,005 assertions passed  1.56ms
  - TSynValidate: 677 assertions passed  500us
  - TSynLogFile: 42 assertions passed  316us
  Total failed: 0 / 3,227,233  - Low level common PASSED  1.00s

 1.2. Low level types:
  - RTTI: 34 assertions passed  345us
  - Url encoding: 200 assertions passed  484us
  - Encode decode JSON: 251,055 assertions passed  68.95ms
  Total failed: 0 / 251,289  - Low level types PASSED  70.32ms

 1.3. Big table:
  - TSynBigTable: 19,166 assertions passed  35.20ms
  - TSynBigTableString: 16,047 assertions passed  14.78ms
  - TSynBigTableMetaData: 384,060 assertions passed  608.66ms
  - TSynBigTableRecord: 452,185 assertions passed  1.52s
  Total failed: 0 / 871,458  - Big table PASSED  2.18s

 1.4. Cryptographic routines:
  - Adler 32: 1 assertion passed  284us
  - MD5: 1 assertion passed  82us
  - SHA1: 5 assertions passed  89us
  - SHA256: 5 assertions passed  75us
  - AES256: 6,372 assertions passed  86.64ms
  - RC4: 1 assertion passed  87us
  - Base 64: 11,994 assertions passed  49.84ms
  Total failed: 0 / 18,379  - Cryptographic routines PASSED  140.44ms

 1.5. Compression:
  - In memory compression: 12 assertions passed  123.67ms
  - gzip format: 19 assertions passed  249.84ms
  - Zip format: 36 assertions passed  434.76ms
  - SynLZO: 3,006 assertions passed  43.92ms
  - SynLZ: 29,018 assertions passed  394.31ms
  Total failed: 0 / 32,091  - Compression PASSED  1.24s

 1.6. Synopse PDF:
  - TPdfDocument: 4 assertions passed  6.03ms
  - TPdfDocumentGDI: 6 assertions passed  20.77ms
  Total failed: 0 / 10  - Synopse PDF PASSED  28.38ms


2. mORMot

 2.1. File based:
  - Database direct access: 10,138 assertions passed  201.32ms
  - Virtual table direct access: 12 assertions passed  1.71ms
  - TSQLTableJSON: 104,066 assertions passed  60.18ms
  - TSQLRestClientDB: 604,037 assertions passed  2.26s
  Total failed: 0 / 718,253  - File based PASSED  2.52s

 2.2. File based WAL:
  - Database direct access: 10,138 assertions passed  197.10ms
  - Virtual table direct access: 12 assertions passed  1.51ms
  - TSQLTableJSON: 104,066 assertions passed  60.74ms
  - TSQLRestClientDB: 604,037 assertions passed  2.24s
  Total failed: 0 / 718,253  - File based WAL PASSED  2.50s

 2.3. Memory based:
  - Database direct access: 10,136 assertions passed  177.33ms
  - Virtual table direct access: 12 assertions passed  1.56ms
  - TSQLTableJSON: 104,066 assertions passed  57.03ms
  - TSQLRestClientDB: 672,333 assertions passed  2.79s
  Total failed: 0 / 786,547  - Memory based PASSED  3.03s

 2.4. Basic classes:
  - TSQLRecord: 52 assertions passed  268us
  - TSQLRecordSigned: 200 assertions passed  2.95ms
  - TSQLModel: 3 assertions passed  74us
  Total failed: 0 / 255  - Basic classes PASSED  4.37ms

 2.5. Client server access:
  - TSQLHttpServer: 2 assertions passed  9.38ms
     using THttpApiServer
  - TSQLHttpClient: 3 assertions passed  21.68ms
  - Http client keep alive: 3,085 assertions passed  200.11ms
     4818 B, first 4.91ms, done 183.34ms i.e. 5454/s, aver. 183us, 25.5 MB/s
  - Http client multi connect: 3,085 assertions passed  193.53ms
     4818 B, first 392us, done 182.33ms i.e. 5484/s, aver. 182us, 25.6 MB/s
  - Named pipe access: 3,087 assertions passed  516.90ms
     4818 B, first 256.23ms, done 54.74ms i.e. 18267/s, aver. 54us, 85.4 MB/s
  - Local window messages: 3,086 assertions passed  27.85ms
     4818 B, first 101us, done 20.47ms i.e. 48844/s, aver. 20us, 228.3 MB/s
  - Direct in process access: 3,054 assertions passed  18.07ms
     4818 B, first 20us, done 13.23ms i.e. 75562/s, aver. 13us, 353.3 MB/s
  Total failed: 0 / 15,402  - Client server access PASSED  992.24ms

 2.6. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  334us
  - Service initialization: 133 assertions passed  1.53ms
  - Direct call: 608,487 assertions passed  25.16ms
  - Server side: 608,506 assertions passed  25.22ms
  - Client side REST: 608,511 assertions passed  499.32ms
  - Client side JSONRPC: 608,505 assertions passed  521.05ms
  - Client side synchronized REST: 608,505 assertions passed  1.00s
  - Client side weak authentication REST: 608,505 assertions passed  489.47ms
  - Security: 135 assertions passed  1.45ms
  - Custom record layout: 608,505 assertions passed  511.63ms
  - Mocks and stubs: 30,031 assertions passed  32.95ms
  Total failed: 0 / 4,289,879  - Service oriented architecture PASSED  3.11s

 2.7. External database:
  - External records: 2 assertions passed  519us
  - Auto adapt SQL: 260 assertions passed  10.79ms
  - Crypted database: 253,275 assertions passed  173.91ms
  - External via REST: 250,472 assertions passed  897.32ms
  - External via virtual table: 250,472 assertions passed  1.41s
  - External in background thread: 250,472 assertions passed  822.60ms
  Total failed: 0 / 1,004,953  - External database PASSED  3.32s

 2.8. Multi thread process:
  - Create thread pool: 1 assertion passed  1.52ms
  - TSQLRestServerDB: 4,821 assertions passed  173.51ms
     1=42548/s  2=20128/s  5=8015/s  10=8039/s  30=20197/s  50=20233/s
  - TSQLRestClientDB: 4,822 assertions passed  154.02ms
     1=39968/s  2=20153/s  5=40629/s  10=13406/s  30=13415/s  50=8056/s
  - TSQLRestClientURINamedPipe: 2,412 assertions passed  1.62s
     1=1379/s  2=1081/s  5=524/s
  - TSQLRestClientURIMessage: 3,222 assertions passed  143.34ms
     1=19974/s  2=16723/s  5=9873/s  10=7370/s
  - TSQLHttpClientWinHTTP_HTTPAPI: 4,820 assertions passed  348.64ms
     1=5036/s  2=6685/s  5=8031/s  10=8032/s  30=8032/s  50=7583/s
  - TSQLHttpClientWinSock_WinSock: 4,822 assertions passed  274.33ms
     1=10153/s  2=8014/s  5=13397/s  10=7853/s  30=12153/s  50=6588/s
  Total failed: 0 / 24,920  - Multi thread process PASSED  2.72s


Synopse framework used: 1.18
SQlite3 engine used: 3.8.0.2
Generated with: Delphi 7 compiler

Time elapsed for all tests: 22.93s
Tests performed at 10/3/2013 5:05:10 PM

Total assertions failed for all test suits:  0 / 11,958,922
! All tests passed successfully.

Done - Press ENTER to Exit

Offline

#3 2013-10-03 15:11:26

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

Re: TestSQL3 fails Delphi 7 - Windows 7

Ensure you got the latest version of every unit.
Please enable the detailed Map File (Project/Options/Linker/Map file/Detailed) to have the source code line numbers of the problem.

Offline

Pages: 1

Board footer

Powered by FluxBB