TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

ComingNine · 2015-07-27 03:02:31

TestSQL3 was compiled from latest mORMot with CrossKylix but failed on RHEL5.5 x64. The output and the log with line numbers have been provided. Could you help to comment what could be the cause and how to work around ? Many thanks !

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


1. Synopse libraries

 1.1. Low level common: 
  - System copy record: 83 assertions passed  17.00s
  - TRawUTF8List: 130,009 assertions passed  255102.00s
  - TDynArray: 1,082,725 assertions passed  142117.00s
  - TDynArrayHashed: 1,200,629 assertions passed  77837.00s
  - TObjectListHashed: 999,910 assertions passed  275084.00s
  - TObjectDynArrayWrapper: 167,501 assertions passed  17344.00s
  - TObjArray: 2,016 assertions passed  1126.00s
  - Fast string compare: 24 assertions passed  9.00s
  - IdemPropName: 189 assertions passed  20.00s
  - Url encoding: 150 assertions passed  711.00s
  - GUID: 9,005 assertions passed  1210.00s
  - IsMatch: 599 assertions passed  161.00s
  - Soundex: 35 assertions passed  19.00s
  - Numerical conversions: 1,116,350 assertions passed  398819.00s
  - crc32c: 30,030 assertions passed  52334.00s
      pas 19364.00s 323 B/s fast 3022.00s 2070 B/s sse42 1444.00s 4332 B/s
  - Curr 64: 20,053 assertions passed  978.00s
  - CamelCase: 11 assertions passed  6.00s
  - Bits: 4,774 assertions passed  28.00s
  - Ini files: 7,004 assertions passed  20485.00s
  - UTF8: 81,122 assertions passed  831377.00s
  - Iso 8601 date and time: 36,017 assertions passed  3663.00s
  - Time zones: 398 assertions passed  146.00s
  - Url decoding: 1,100 assertions passed  172.00s
  - Mime types: 23 assertions passed  15.00s
!!! Low level common - TSynTable "Access violation at address 08085620, accessing address 00000000" failed !!!
Press [Enter] to continue, or Ctrl+C to abort 
!  - TSynTable: 1 / 50 FAILED  1688134.00s
  - TSynCache: 404 assertions passed  106.00s
  - TSynFilter: 1,005 assertions passed  1768.00s
  - TSynValidate: 677 assertions passed  686.00s
  - TSynLogFile: 36 assertions passed  470.00s
  Total failed: 1 / 4,891,929  - Low level common FAILED  3770499.00s

 1.2. Low level types: 
  - RTTI: 61 assertions passed  2515.00s
  - Url encoding: 200 assertions passed  434.00s
  - Encode decode JSON: 282,109 assertions passed  342193.00s
  - Variants: 46 assertions passed  27.00s
  - Mustache renderer: 144 assertions passed  309995.00s
  - TDocVariant: 71,771 assertions passed  192936.00s
  - BSON: 245,050 assertions passed  58528.00s
  - TSynTableStatement: 205 assertions passed  147.00s
  Total failed: 0 / 599,586  - Low level types PASSED  906992.00s

 1.3. Cryptographic routines: 
  - Adler32: 1 assertion passed  9.00s
  - MD5: 1 assertion passed  6.00s
  - SHA1: 10 assertions passed  6482.00s
  - SHA256: 8 assertions passed  9096.00s
  - AES256: 12,178 assertions passed  571025.00s
  - RC4: 1 assertion passed  8.00s
  - Base64: 11,994 assertions passed  315242.00s
  - CompressShaAes: 1,683 assertions passed  3004.00s
  Total failed: 0 / 25,876  - Cryptographic routines PASSED  904972.00s

 1.4. Compression: 
  - In memory compression: 12 assertions passed  241714.00s
  - GZIP format: 19 assertions passed  502109.00s
  - SynLZO: 3,006 assertions passed  56586.00s
  - SynLZ: 32,221 assertions passed  567578.00s
  Total failed: 0 / 35,258  - Compression PASSED  1368043.00s


2. mORMot

 2.1. File based: 
  - Database direct access: 20,246 assertions passed  294497.00s
  - Virtual table direct access: 12 assertions passed  2196.00s
  - TSQLTableJSON: 144,070 assertions passed  142336.00s
!!! File based - TSQLRestClientDB "" failed !!!
Press [Enter] to continue, or Ctrl+C to abort 
!!! File based - TSQLRestClientDB "" failed !!!
Press [Enter] to continue, or Ctrl+C to abort 
!!! File based - TSQLRestClientDB "" failed !!!
Press [Enter] to continue, or Ctrl+C to abort 
!!! File based - TSQLRestClientDB "" failed !!!
Press [Enter] to continue, or Ctrl+C to abort 
!!! File based - TSQLRestClientDB "" failed !!!
Press [Enter] to continue, or Ctrl+C to abort ! File based - TSQLRestClientDB
! Exception EControlC raised with messsage:
!  Control-C hit


Using mORMot 1.18.1694 PRTL FTS3
Running on Linux 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010
TSQLite3LibraryDynamic 3.8.10.2 with internal MM
Generated with: Kylix 3 compiler

Time elapsed for all tests: 10242552.00s
Tests performed at 07/27/2015 12:10:44 PM

Total assertions failed for all test suits:  1 / 5,552,649
! Some tests FAILED: please correct the code.

/test/mormot/TestSQL3 0.0.0.0 (2015-07-27 00:44:39)
Host=login01 User=test CPU=12/12 OS=Linux-2.6.18-194.el5#1-SMP-Tue-Mar-16-21:52:39-EDT-2010 Wow64=0 Freq=1000
TSQLLog 1.18.1694 PRTL FTS3 2015-07-27T12:10:36

00000000 00000000 EXCOS EAccessViolation (FBEE0101) at 08085620 SynCommons.MoveX87 (30316) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0804E83C System.@WStrSetLength 08076406 SynCommons.TSynAnsiConvert.AnsiToUnicodeString (13824) 080A9985 SynTests.TSynTestCase.RandomUnicode (666) 0814A76E SynSelfTests.TTestLowLevelCommon._TSynTable (3436) 080AA404 SynTests.TSynTests.Run (969) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12103627 EXCOS EAccessViolation (FBEE0101) at 08085620 SynCommons.MoveX87 (30316) stack trace 0804D7B1 System.@LStrClr 0804D0A5 System.@HandleFinally 080A9998 SynTests.TSynTestCase.RandomUnicode (666) 0814A76E SynSelfTests.TTestLowLevelCommon._TSynTable (3436) 080AA404 SynTests.TSynTests.Run (969) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12103627 fail #50 Access violation at address 08085620, accessing address 00000000 stack trace 080A99E8 SynTests.TSynTestCase.TestFailed (729) 080A9646 SynTests.TSynTestCase.Check (550) 0814B48F SynSelfTests.TTestLowLevelCommon._TSynTable (3500) 080AA404 SynTests.TSynTests.Run (969) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12103628 fail TTestLowLevelCommon(5588B420) Low level common: TSynTable "Access violation at address 08085620, accessing address 00000000" stack trace 080AAFC0 SynTests.TSynTestsLogged.Failed (1135) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 0814B48F SynSelfTests.TTestLowLevelCommon._TSynTable (3500) 080AA404 SynTests.TSynTests.Run (969) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104132 fail #25 stack trace 080A99E8 SynTests.TSynTestCase.TestFailed (729) 080A9646 SynTests.TSynTestCase.Check (550) 0817642C SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10909) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104133 fail TTestFileBased(55819A20) File based: TSQLRestClientDB "" stack trace 080AAFC0 SynTests.TSynTestsLogged.Failed (1135) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 0817642C SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10909) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104245 fail #26 stack trace 080A99E8 SynTests.TSynTestCase.TestFailed (729) 080A9646 SynTests.TSynTestCase.Check (550) 08176485 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10911) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104246 fail TTestFileBased(55819A20) File based: TSQLRestClientDB "" stack trace 080AAFC0 SynTests.TSynTestsLogged.Failed (1135) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 08176485 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10911) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104310 fail #27 stack trace 080A99E8 SynTests.TSynTestCase.TestFailed (729) 080A9646 SynTests.TSynTestCase.Check (550) 081764A2 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10912) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104310 fail TTestFileBased(55819A20) File based: TSQLRestClientDB "" stack trace 080AAFC0 SynTests.TSynTestsLogged.Failed (1135) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 081764A2 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10912) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104332 fail #28 stack trace 080A99E8 SynTests.TSynTestCase.TestFailed (729) 080A9646 SynTests.TSynTestCase.Check (550) 081764BD SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10913) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104332 fail TTestFileBased(55819A20) File based: TSQLRestClientDB "" stack trace 080AAFC0 SynTests.TSynTestsLogged.Failed (1135) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 081764BD SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10913) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104352 fail #29 stack trace 080A99E8 SynTests.TSynTestCase.TestFailed (729) 080A9646 SynTests.TSynTestCase.Check (550) 081764D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10914) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104352 fail TTestFileBased(55819A20) File based: TSQLRestClientDB "" stack trace 080AAFC0 SynTests.TSynTestsLogged.Failed (1135) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 081764D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10914) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0804B499 System.TextIn 0804BB97 System.@ReadChar 0804BD26 System.@ReadLn 080AB060 SynTests.TSynTestsLogged.Failed (1140) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 081764D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10914) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 0804D0A5 System.@HandleFinally 080AB07D SynTests.TSynTestsLogged.Failed (1140) 080A99F8 SynTests.TSynTestCase.TestFailed (731) 080A9646 SynTests.TSynTestCase.Check (550) 081764D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10914) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 0804D0A5 System.@HandleFinally 08177F90 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (11285) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 0804C987 System.TObject.Free 0804D0A5 System.@HandleFinally 08177FD8 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (11296) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 0804D7B1 System.@LStrClr 0804D0A5 System.@HandleFinally 08178089 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (11296) 080AA404 SynTests.TSynTests.Run (969) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 080AA4BF SynTests.TSynTests.Run (978) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 12104416 EXCOS EControlC (FBEE0101) at FFFFE410 stack trace 080AA516 SynTests.TSynTests.Run (982) 081761D4 SynSelfTests.TTestSQLite3Engine._TSQLRestClientDB (10876) 081839B1 mORMotSelfTests.SQLite3ConsoleTests (180) 08183CFC TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start

ab · 2015-07-27 06:16:01

I just checked and run the tests: I did not have any problem with Ubuntu.
Here I tested with a 3.13 kernel revision.

I guess the problem may be about the kernel you use.
It is displayed as 2.6.18, and sounds a bit old to me.
Your system ages from 2010-03-30, as told by https://access.redhat.com/articles/3078
Not a good idea at all on production.

Please try with a newer RHEL version.

ab · 2015-07-27 06:19:42

To be more precise, we use CLOCK_MONOTONIC_COARSE for GetTickCount64 implementation, which requires a 2.6.32 kernel.
See http://man7.org/linux/man-pages/man2/cl … ime.2.html
and http://lwn.net/Articles/347811

It may be the cause of the issue.

ComingNine · 2015-07-27 07:05:29

ab wrote:

I just checked and run the tests: I did not have any problem with Ubuntu.
Here I tested with a 3.13 kernel revision.
I guess the problem may be about the kernel you use.
It is displayed as 2.6.18, and sounds a bit old to me.
Your system ages from 2010-03-30, as told by https://access.redhat.com/articles/3078
Not a good idea at all on production.
Please try with a newer RHEL version.

ab wrote:

To be more precise, we use CLOCK_MONOTONIC_COARSE for GetTickCount64 implementation, which requires a 2.6.32 kernel.
See http://man7.org/linux/man-pages/man2/cl … ime.2.html
and http://lwn.net/Articles/347811
It may be the cause of the issue.

Thanks for your efforts very much ! I have tried on a CentOS 6.x and indeed the exception did not show.

According to the "End-of-support schedule" as shown https://en.wikipedia.org/wiki/CentOS , v5.x is going to be supported till 2017. More importantly, that my application does not run does not mean much to the linux administrators.

Could you help to comment since which version of mORMot did you make the change ? More importantly, is it possible to allow mORMot to run on old kernel again ?

ab · 2015-07-27 11:17:25

I tried to enable mORMot to run on very old Linux kernels.

See http://synopse.info/fossil/info/897fb31348

ComingNine · 2015-07-27 15:10:17

Thanks for your efforts very much ! Now TestSQL3 proceeds much further. However, there is a segment fault at "2.10. Multi thread process". Could you help to comment about the problem ? The output and the log with line numbers have been provided...

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


1. Synopse libraries

 1.1. Low level common: 
  - System copy record: 83 assertions passed  29.00s
  - TRawUTF8List: 130,009 assertions passed  107445.00s
  - TDynArray: 1,082,725 assertions passed  132543.00s
  - TDynArrayHashed: 1,200,629 assertions passed  70605.00s
  - TObjectListHashed: 999,886 assertions passed  257372.00s
  - TObjectDynArrayWrapper: 167,501 assertions passed  16932.00s
  - TObjArray: 2,016 assertions passed  1116.00s
  - Fast string compare: 24 assertions passed  9.00s
  - IdemPropName: 189 assertions passed  25.00s
  - Url encoding: 150 assertions passed  697.00s
  - GUID: 9,005 assertions passed  1194.00s
  - IsMatch: 599 assertions passed  105.00s
  - Soundex: 35 assertions passed  9.00s
  - Numerical conversions: 1,115,424 assertions passed  386694.00s
  - crc32c: 30,030 assertions passed  51004.00s
      pas 19060.00s 328 B/s fast 2880.00s 2172 B/s sse42 1380.00s 4533 B/s
  - Curr 64: 20,053 assertions passed  956.00s
  - CamelCase: 11 assertions passed  15.00s
  - Bits: 4,774 assertions passed  28.00s
  - Ini files: 7,004 assertions passed  60730.00s
  - UTF8: 81,122 assertions passed  775938.00s
  - Iso 8601 date and time: 36,017 assertions passed  3473.00s
  - Time zones: 398 assertions passed  136.00s
  - Url decoding: 1,100 assertions passed  174.00s
  - Mime types: 23 assertions passed  19.00s
!!! Low level common - TSynTable "Access violation at address 080856E4, accessing address 00000000" failed !!!
Press [Enter] to continue, or Ctrl+C to abort 
!  - TSynTable: 1 / 50 FAILED  712945.00s
  - TSynCache: 404 assertions passed  89.00s
  - TSynFilter: 1,005 assertions passed  3409.00s
  - TSynValidate: 677 assertions passed  1246.00s
  - TSynLogFile: 36 assertions passed  487.00s
  Total failed: 1 / 4,890,979  - Low level common FAILED  2585679.00s

 1.2. Low level types: 
  - RTTI: 61 assertions passed  44.00s
  - Url encoding: 200 assertions passed  752.00s
  - Encode decode JSON: 284,555 assertions passed  109447.00s
  - Variants: 46 assertions passed  12.00s
  - Mustache renderer: 144 assertions passed  81720.00s
  - TDocVariant: 71,771 assertions passed  186739.00s
  - BSON: 245,050 assertions passed  36222.00s
  - TSynTableStatement: 205 assertions passed  74.00s
  Total failed: 0 / 602,032  - Low level types PASSED  415125.00s

 1.3. Cryptographic routines: 
  - Adler32: 1 assertion passed  9.00s
  - MD5: 1 assertion passed  7.00s
  - SHA1: 10 assertions passed  6497.00s
  - SHA256: 8 assertions passed  9332.00s
  - AES256: 12,178 assertions passed  550793.00s
  - RC4: 1 assertion passed  9.00s
  - Base64: 11,994 assertions passed  113557.00s
  - CompressShaAes: 1,683 assertions passed  2824.00s
  Total failed: 0 / 25,876  - Cryptographic routines PASSED  683087.00s

 1.4. Compression: 
  - In memory compression: 12 assertions passed  231993.00s
  - GZIP format: 19 assertions passed  474122.00s
  - SynLZO: 3,006 assertions passed  53257.00s
  - SynLZ: 32,221 assertions passed  511550.00s
  Total failed: 0 / 35,258  - Compression PASSED  1270958.00s


2. mORMot

 2.1. File based: 
  - Database direct access: 20,246 assertions passed  275284.00s
  - Virtual table direct access: 12 assertions passed  1027.00s
  - TSQLTableJSON: 144,070 assertions passed  108955.00s
  - TSQLRestClientDB: 310,071 assertions passed  1497442.00s
  - TRecordVersion: 20,060 assertions passed  139405.00s
  Total failed: 0 / 494,459  - File based PASSED  2022171.00s

 2.2. File based memory map: 
  - Database direct access: 20,246 assertions passed  268353.00s
  - Virtual table direct access: 12 assertions passed  2941146.00s
  - TSQLTableJSON: 144,070 assertions passed  104388.00s
  - TSQLRestClientDB: 310,071 assertions passed  1262594.00s
  - TRecordVersion: 20,060 assertions passed  136532.00s
  Total failed: 0 / 494,459  - File based memory map PASSED  4713077.00s

 2.3. File based WAL: 
  - Database direct access: 20,246 assertions passed  229259.00s
  - Virtual table direct access: 12 assertions passed  957.00s
  - TSQLTableJSON: 144,070 assertions passed  92167.00s
  - TSQLRestClientDB: 310,071 assertions passed  1596096.00s
  - TRecordVersion: 20,060 assertions passed  1665422.00s
  Total failed: 0 / 494,459  - File based WAL PASSED  3583953.00s

 2.4. Memory based: 
  - Database direct access: 20,246 assertions passed  237607.00s
  - Virtual table direct access: 12 assertions passed  924.00s
  - TSQLTableJSON: 144,070 assertions passed  95665.00s
  - TSQLRestClientDB: 402,407 assertions passed  1837980.00s
  - TRecordVersion: 20,060 assertions passed  142092.00s
  - RTree: 140,000 assertions passed  2437929.00s
  Total failed: 0 / 726,795  - Memory based PASSED  4752251.00s

 2.5. Basic classes: 
  - TSQLRecord: 77 assertions passed  214.00s
  - TSQLRecordSigned: 200 assertions passed  4066.00s
  - TSQLModel: 16 assertions passed  21.00s
  - TSQLRestServerFullMemory: 562,308 assertions passed  900038.00s
  Total failed: 0 / 562,601  - Basic classes PASSED  904398.00s

 2.6. Client server access: 
  - TSQLHttpServer: 2 assertions passed  22523.00s
     using Synopse CrossPlatform Socket Layer.514
  - TSQLHttpClient: 3 assertions passed  60905.00s
     using TSQLHttpClientWinSock
  - HTTP client keep alive: 3,087 assertions passed  206976.00s
     4818 B, first 74984.00s, done 118559.00s i.e. 0/s, aver. 118.55s, 41 B/s
  - HTTP client multi connect: 3,087 assertions passed  199975.00s
     4818 B, first 243.00s, done 182961.00s i.e. 0/s, aver. 182.96s, 26 B/s
  - HTTP client encrypted: 3,087 assertions passed  149923.00s
     4818 B, first 256.00s, done 137116.00s i.e. 0/s, aver. 137.11s, 35 B/s
  - Direct in process access: 3,056 assertions passed  102685.00s
     4818 B, first 52.00s, done 27199.00s i.e. 0/s, aver. 27.19s, 180 B/s
  - HTTP several DB servers: 9,604 assertions passed  753108.00s
     4818 B, first 345.00s, done 133607.00s i.e. 0/s, aver. 133.60s, 36 B/s
     4818 B, first 616.00s, done 139394.00s i.e. 0/s, aver. 139.39s, 35 B/s
     4818 B, first 790.00s, done 155638.00s i.e. 0/s, aver. 155.63s, 31 B/s
  Total failed: 0 / 21,926  - Client server access PASSED  1496240.00s

 2.7. Service oriented architecture: 
  - Weak interfaces: 56 assertions passed  37.00s
  - Service initialization: 255 assertions passed  72874.00s
  - Direct call: 579,186 assertions passed  33877.00s
  - Server side: 579,206 assertions passed  23806.00s
  - Client side REST: 772,274 assertions passed  793079.00s
  - Client side REST as JSON object: 772,268 assertions passed  1948470.00s
  - Client side REST sessions stats: 772,268 assertions passed  1221145.00s
  - Client side REST locked: 772,272 assertions passed  1955988.00s
  - Client side REST main thread: 772,272 assertions passed  3633614.00s
  - Client side REST background thread: 772,272 assertions passed  1980965.00s
  - Client side REST weak authentication: 772,268 assertions passed  1080264.00s
  - Client side REST basic authentication: 772,268 assertions passed  1147049.00s
  - Client side REST custom record layout: 772,268 assertions passed  1119175.00s
  - Client side REST service log to DB: 772,268 assertions passed  2282099.00s
  - Client side JSONRPC: 772,268 assertions passed  1888977.00s
  - Test over HTTP: 9,661 assertions passed  499727.00s
  - Security: 135 assertions passed  156607.00s
  - Mocks and stubs: 30,029 assertions passed  42813.00s
  Total failed: 0 / 9,693,494  - Service oriented architecture PASSED  19880852.00s

 2.8. Bidirectional remote connection: 
  - Websockets JSON protocol: 60 assertions passed  35.00s
  - Websockets binary protocol: 240 assertions passed  182.00s
  - Run http server: 2 assertions passed  339.00s
  - SOA callback on server side: 4,452 assertions passed  963.00s
  - SOA callback via JSON websockets: 4,455 assertions passed  97303.00s
  - SOA callback via binary websockets: 4,455 assertions passed  106139.00s
  - TRecordVersion: 20,068 assertions passed  5477462.00s
  Total failed: 0 / 33,732  - Bidirectional remote connection PASSED  5682527.00s

 2.9. External database: 
  - TQuery: 2,003 assertions passed  34810.00s
  - SynDBRemote: 25,079 assertions passed  5307366.00s
  - DB properties persistence: 7 assertions passed  835.00s
  - External records: 2 assertions passed  168.00s
  - Auto adapt SQL: 708 assertions passed  107295.00s
  - Crypted database: 176,192 assertions passed  173950.00s
  - External via REST: 170,354 assertions passed  20052879.00s
  - External via virtual table: 170,354 assertions passed  22895000.00s
  - External via REST with change tracking: 180,454 assertions passed  21897830.00s
  Total failed: 0 / 725,153  - External database PASSED  27520576.04s

 2.10. Multi thread process: 
  - Create thread pool: 1 assertion passed  2364.00s
Runtime error 231 at 0805B929
Segmentation fault

/test/mormot/TestSQL3 0.0.0.0 (2015-07-27 22:19:47)
Host=login01 User=tes CPU=12/12 OS=Linux-2.6.18-194.el5#1-SMP-Tue-Mar-16-21:52:39-EDT-2010 Wow64=0 Freq=1000
TSQLLog 1.18.1699 PRTL FTS3 2015-07-27T23:43:29

20150727 23432951 EXCOS EAccessViolation (FBEE0101) at 080856E4 SynCommons.MoveX87 (30326) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0804E83C System.@WStrSetLength 080764CA SynCommons.TSynAnsiConvert.AnsiToUnicodeString (13834) 080A9A49 SynTests.TSynTestCase.RandomUnicode (666) 0814A872 SynSelfTests.TTestLowLevelCommon._TSynTable (3436) 080AA4C8 SynTests.TSynTests.Run (969) 08183AAD mORMotSelfTests.SQLite3ConsoleTests (180) 08183DF8 TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 23432952 EXCOS EAccessViolation (FBEE0101) at 080856E4 SynCommons.MoveX87 (30326) stack trace 0804D7B1 System.@LStrClr 0804D0A5 System.@HandleFinally 080A9A5C SynTests.TSynTestCase.RandomUnicode (666) 0814A872 SynSelfTests.TTestLowLevelCommon._TSynTable (3436) 080AA4C8 SynTests.TSynTests.Run (969) 08183AAD mORMotSelfTests.SQLite3ConsoleTests (180) 08183DF8 TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 23432953 fail #50 Access violation at address 080856E4, accessing address 00000000 stack trace 080A9AAC SynTests.TSynTestCase.TestFailed (729) 080A970A SynTests.TSynTestCase.Check (550) 0814B593 SynSelfTests.TTestLowLevelCommon._TSynTable (3500) 080AA4C8 SynTests.TSynTests.Run (969) 08183AAD mORMotSelfTests.SQLite3ConsoleTests (180) 08183DF8 TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 23432953 fail TTestLowLevelCommon(5588B420) Low level common: TSynTable "Access violation at address 080856E4, accessing address 00000000" stack trace 080AB084 SynTests.TSynTestsLogged.Failed (1135) 080A9ABC SynTests.TSynTestCase.TestFailed (731) 080A970A SynTests.TSynTestCase.Check (550) 0814B593 SynSelfTests.TTestLowLevelCommon._TSynTable (3500) 080AA4C8 SynTests.TSynTests.Run (969) 08183AAD mORMotSelfTests.SQLite3ConsoleTests (180) 08183DF8 TestSQL3 (187) 0805413E SysInit.@main 08054194 SysInit.@start
20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 00A4AEA9 stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 080A2D56 SynCommons.FixedWaitFor (32280) 0804E3E7 System.@LStrSetLength 08182480 SynSelfTests.TTestMultiThreadProcessThread.Execute (13434) 08072ADE Classes.ThreadProc 0804D71A System.ThreadWrapper
20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 00A4AEA9 stack trace 0804D0A5 System.@HandleFinally 081826F7 SynSelfTests.TTestMultiThreadProcessThread.Execute (13481) 08072ADE Classes.ThreadProc 0804D71A System.ThreadWrapper
20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 00A4AEA9 stack trace 0804D0A5 System.@HandleFinally 08182726 SynSelfTests.TTestMultiThreadProcessThread.Execute (13483) 08072ADE Classes.ThreadProc 0804D71A System.ThreadWrapper
20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 00A4AEA9 stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 080A2D56 SynCommons.FixedWaitFor (32280) 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 080A2D56 SynCommons.FixedWaitFor (32280) 0804E3E7 System.@LStrSetLength 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter
20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452655 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter
20150727 23452658 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 0805B929 SysUtils.RaiseSignalException 0805B95E SysUtils.SignalConverter 20150727 23452658 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452658 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452658 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452658 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace 20150727 23452658 EXCOS EAccessViolation (FBEE0101) at 080A55C5 SynLog.IsBadReadPtr (2009) stack trace

ComingNine · 2015-07-28 03:30:32

Further comparison was made and shown below:

(1) As shown in the above post, the " 2.10. Multi thread process:" test suite fails complaining "Segmentation fault" on RHEL 5.5 with kernel version 2.6.18-194.el5.
(2) The " 2.10. Multi thread process:" test suite hangs on CentOS 5.11 with kernel version 2.6.18-400.1.1.el5.
(3) The " 2.10. Multi thread process:" test suite passes on CentOS 6.5 with kernel version 2.6.32.12-x86_64-linode15 (Linode VM).
(4) The " 2.10. Multi thread process:" test suite passes on CentOS 5.6 or CentOS 6.5 with kernel version 4.1.0-x86_64-linode59 (Linode VM).

Therefore, the issue seems to be related to the kernel again...
Could you help to comment whether it is possible for the " 2.10. Multi thread process:" test suite to succeed on legacy kernels of 2.6.18 ?
Thank you for your efforts very much !

Last edited by ComingNine (2015-07-28 05:08:21)

ComingNine · 2015-07-29 12:22:55

Dear ab,

sorry for the trouble but could you help to comment whether it is possible for the " 2.10. Multi thread process:" test suite to succeed on legacy kernels of 2.6.18 ?
I mean, could you help to confirm whether the failure of the " 2.10. Multi thread process:" test suite is crucial ?

mORMot Open Source

#1 2015-07-27 03:02:31

TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#2 2015-07-27 06:16:01

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#3 2015-07-27 06:19:42

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#4 2015-07-27 07:05:29

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#5 2015-07-27 11:17:25

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#6 2015-07-27 15:10:17

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#7 2015-07-28 03:30:32

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

#8 2015-07-29 12:22:55

Re: TestSQL3 tests (TSQLRestClientDB etc) failed on RHEL 5.5.

Board footer