#1 2025-01-29 10:03:11

damiand
Member
From: Greece
Registered: 2018-09-21
Posts: 100

mormot2tests sqlite fails

I encountered the following run time error when trying to run mormot2tests:

Project mormot2tests.exe raised exception class ESqlite3Exception with message 
'Error SQLITE_ERROR (1) [insert into PeopleArray (FirstName,LastName,YearOfBirth,YearOfDeath,Rec) 
values (:('Salvador1'):,:('Dali'):,:(1904):,:(1989):,:():)] using 3.46.1 - unrecognized token: ":"'.

branch: lts-2.3 - The static folder has been updated with the latest mormot2static.7z contents.
IDE: Delphi 12.2 Professional
Target: Windows 64 bits
OS: Microsoft Windows 10

Last edited by damiand (2025-01-29 10:04:32)

Offline

#2 2025-01-29 10:11:29

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

Re: mormot2tests sqlite fails

I just tried on Delphi 12.2 + Windows 10.
Not able to reproduce here with the trunk.
https://gist.github.com/synopse/f51ae65 … 97c105bd08

Are you sure you did not change the mormot2tests content?
Try with the trunk instead.

Offline

#3 2025-01-29 10:15:39

damiand
Member
From: Greece
Registered: 2018-09-21
Posts: 100

Re: mormot2tests sqlite fails

I didn't change the mormot2tests content, for sure. The error appears also on Windows 32 bit build target. I'll try with the trunk.

Update: I'm now running the tests again, using the trunk (master) branch. The sqlite tests passed successfully, the test is going on...

Last edited by damiand (2025-01-29 10:24:26)

Offline

#4 2025-01-29 10:24:32

damiand
Member
From: Greece
Registered: 2018-09-21
Posts: 100

Re: mormot2tests sqlite fails

With the trunk, all tests completed successfully.

Offline

#5 2025-01-29 12:52:03

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

Re: mormot2tests sqlite fails

So this is only about the current LTS branch. I guess the LTS release archive from github is fine.
I will look into it.

The idea was to include the LTS branch to our continuous integration farm, but we did not have enough time for this yet.
https://blog.synopse.info/?post/2023/07 … the-mORMot

Offline

#6 2025-01-29 14:53:01

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

Re: mormot2tests sqlite fails

Simon has added the LTS branch to LUTI.

And... weird fact... everything pass as expected:
https://luti.tranquil.it/listfolder/e54 … 45a54f124b

Offline

#7 2025-01-29 19:23:56

damiand
Member
From: Greece
Registered: 2018-09-21
Posts: 100

Re: mormot2tests sqlite fails

I've just run git switch lts-2.3, build and run the tests. The sqlite tests failed with the same error as before.

I switched again to master, run git pull (to get some commits ahead), run the tests, all passed successfully. Weird fact indeed...

Last edited by damiand (2025-01-29 19:24:15)

Offline

#8 2025-01-29 21:44:19

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

Re: mormot2tests sqlite fails

I just made the same.

No error.

   mORMot2 Regression Tests
  --------------------------
...
Ubuntu 24.04.1 LTS - Linux 6.8.0-52-generic [utf8 15.2GB 6080010]
    18 x Intel(R) Core(TM) Ultra 5 125H [2MB] (x64)
    on LENOVO 83D2 IdeaPad Pro 5 14IMH9
Using mORMot lts-2.3.8866 29 Jan 2025 and OpenSSL 3.0.13 30 Jan 2024
    TSqlite3LibraryStatic 3.46.1 with internal MM
Generated with: Free Pascal 3.2.3 64 bit Linux compiler

Time elapsed for all tests: 45.18s
Performed 2025-01-29 22:42:24 by ab on lenovo14

Total assertions failed for all test suits:  0 / 128,054,984
! All tests passed successfully.

Offline

#9 2025-01-30 07:28:40

damiand
Member
From: Greece
Registered: 2018-09-21
Posts: 100

Re: mormot2tests sqlite fails

On Linux the tests of lts-2.3 run successfully. Here is the output of my recent attempt:

openSUSE Leap 15.6 - Linux 6.4.0-150600.23.33-default [utf8 7.6GB 6040013]
    4 x Intel(R) Core(TM) i5-4460 CPU @ 3.20GHz [6MB] (x64)
    on Gigabyte Technology Co., Ltd. H81M-S2PV To be filled by O.E.M.
Using mORMot lts-2.3.8866 30 Jan 2025 and OpenSSL 3.1.4 24 Oct 2023
    TSqlite3LibraryStatic 3.46.1 with internal MM
Generated with: Free Pascal 3.2.3 64 bit Linux compiler

Time elapsed for all tests: 45.24s
Performed 2025-01-30 09:20:36 by damian on ifestos

Total assertions failed for all test suits:  0 / 128,055,450
! All tests passed successfully.

I encounter the problem only on windows (actually a Win10 VM I run on Linux) with Delphi 12.2.

Offline

#10 2025-01-30 08:12:11

damiand
Member
From: Greece
Registered: 2018-09-21
Posts: 100

Re: mormot2tests sqlite fails

What make things more weird, is that in an old notebook with 32bit Win10 and Delphi XE, the lts-2.3 run successfully, though not in IDE which stops unexpectedly, but from the command line:

Windows 10 22H2 (10.0.19045.5247) [cp1253 3.4GB 4A651601]
    4 x Intel(R) Core(TM) i5 CPU M 450 @ 2.40GHz [3MB] (x86)
    on Dell Inc. Latitude E5510 0001
Using mORMot lts-2.3.8866 30 Jan 2025
    TSqlite3LibraryStatic 3.46.1 with internal MM
Generated with: Delphi XE 32 bit Win compiler

Time elapsed for all tests: 6m13
Performed 2025-01-30 10:05:33 by damian on LEPORELLO

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

Offline

Board footer

Powered by FluxBB