FWD » Core Development » Database

11/15/2025

08:28 AM Feature #4369: implement stateless FWD server clustering

I have mainly finished all the changes necessary in @InMemoryLockManager@ regarding the @.wait()/.notify()@ construct... Andrei Plugaru

11/14/2025

05:56 AM Feature #9711: collation configuration cleanup

Alex, when talking _meta tables, the nuances you mentioned is a bit more complex.
There is some 'persistent' infor... Ovidiu Maxiniuc

05:33 AM Feature #9711: collation configuration cleanup

> I think we need a way to allow the H2's default collation and ignore completely the embedded-collation for the _tem... Alexandru Lungu

04:58 AM Feature #9711: collation configuration cleanup

I think we need a way to allow the H2's default collation and ignore completely the @embedded-collation@ for the _tem... Constantin Asofiei

11/13/2025

07:44 AM Bug #10385 (WIP): Incorrect reset of the cursor cache in Reposition

I run a large unit test suite and discovered a NPE in @RepositionCache$Node.getRow@, on @rows.floor(position.intValue... Alexandru Lungu

05:52 AM Feature #4369: implement stateless FWD server clustering

> If the requests are stateless, then they should be able to be distributed across the clustered servers without any ... Alexandru Lungu

11/12/2025

10:56 AM Feature #4369: implement stateless FWD server clustering

> if there are 1k requests at a time and 10 servers, it is completely valid to balance 100 across these 10 servers?
... Greg Shah

10:54 AM Feature #4369: implement stateless FWD server clustering

I don't think we need the @RemoteLockManager@ if we have proper clustering. Greg Shah

09:15 AM Feature #4369: implement stateless FWD server clustering

> Within single-server mode and cluster mode, the server should still handle multiple requests in parallel? I mean, i... Andrei Plugaru

07:59 AM Feature #4369: implement stateless FWD server clustering

Review of 4369a:
h4. Model
* I spot some changes in the synchronization in general and I want to better underst... Alexandru Lungu

11/10/2025

08:41 AM Feature #4369: implement stateless FWD server clustering

Queuing it up! Alexandru Lungu

08:33 AM Feature #4369 (Review): implement stateless FWD server clustering

Eric/Alex: Please do this first review. Greg Shah

07:35 AM Bug #10838: Unique index violation should be cured even at flush time

Make a @tbl@ persistent table with unique index of (f1, f2).... Alexandru Lungu

07:32 AM Bug #10838 (New): Unique index violation should be cured even at flush time

Alexandru Lungu

11/07/2025

08:46 AM Bug #9950 (Review): Upgrade the metadata schema to a newer version

Constantin Asofiei

08:34 AM Feature #9305: Replace begins with interval based conditional

Please do the tests requested in #9305-25 in 4GL and PG with LIKE / < and > / with BETWEEN. We need to take a decisio... Alexandru Lungu

07:42 AM Feature #9305: Replace begins with interval based conditional

The range check follows the field collation or is byte-by-byte?
If it is after collation, there are some cases like ... Teodor Gorghe

07:11 AM Feature #9305: Replace begins with interval based conditional

Teodor Gorghe wrote:
> You told yesterday and in #9305-10 that the default database configuration, with @en_us.UTF... Eduard Soltan

07:01 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

When the changes from this task are regression tested, please also include the following scenario mentioned in #10763... Lorian Sandu

11/06/2025

04:55 PM Bug #9950: Upgrade the metadata schema to a newer version

I added backward compatibility with projects that have not upgraded from OE 11.6. By default 11.6 is the default meta... Ovidiu Maxiniuc

10:45 AM Feature #4369 (WIP): implement stateless FWD server clustering

*Update on the current status.*
Up until now, I have synchronized the *tracker for records in unique indices* and th... Andrei Plugaru

05:36 AM Feature #9305: Replace begins with interval based conditional

Alexandru,
You told yesterday and in #9305-10 that the default database configuration, with @en_us.UTF8@ collation, ... Teodor Gorghe

04:04 AM Bug #10822: Lock is not acquired if the update field value is the same as the current one

If a no-lock is set on a record it cannot be modified, 4GL does not allow any assignment and raises ... Artur Școlnic

03:58 AM Bug #10822 (New): Lock is not acquired if the update field value is the same as the current one

Artur Școlnic

03:56 AM Support #10664: Develop a multi session test suite in harness

I agree, I will open related tasks for every issue found during testing. Artur Școlnic

03:53 AM Support #10664: Develop a multi session test suite in harness

> Alex/Eric can determine if we do this now or if we do this in a separate task.
IMHO, related tasks should be ope... Alexandru Lungu

02:34 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> The tests that are not running properly have this pattern:
> [...]
>
> The test relies on... Greg Shah

02:12 AM Support #10664: Develop a multi session test suite in harness

Razvan pointed out an issue with lock scopes in #10796, @locking@ test suite already includes lock release/downgrade ... Artur Școlnic

11/04/2025

06:50 AM Support #10664: Develop a multi session test suite in harness

+ Ovidiu Alexandru Lungu

06:50 AM Support #10664: Develop a multi session test suite in harness

I computed some topics to look into based on recent work we've done for customers on High/Urgent priority. This list ... Alexandru Lungu

05:05 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> I will change the tests to assign a different value.
After this and ignoring the error num... Artur Școlnic

04:38 AM Support #10664: Develop a multi session test suite in harness

The tests that are not running properly have this pattern:... Artur Școlnic

01:32 AM Support #10664: Develop a multi session test suite in harness

Eric,
For review purposes, the actual test classes are in @flushing_and_validation@ and @locking@ directories in the... Artur Școlnic

01:28 AM Support #10664: Develop a multi session test suite in harness

The tests are not checked in testcases, but I uploaded them to 10664a root directory for preliminary reviews. I figur... Artur Școlnic

11/03/2025

12:26 PM Support #10664: Develop a multi session test suite in harness

Are the tests checked in? Eric/Alex should do a code review on the tests. Greg Shah

11:13 AM Support #10664: Develop a multi session test suite in harness

I finished the locking tests, here is what they include:
* Lock type: no-lock, share-lock, exclusive-lock / no-wait
... Artur Școlnic

05:23 AM Bug #10806: Presort queries can sometimes dynamically find records created after opening the query

Part of #10737, I discovered that BY clause index overlapping resolution is influenced by WHERE clause. This happens ... Alexandru Lungu

05:13 AM Bug #10806 (New): Presort queries can sometimes dynamically find records created after opening th...

Alexandru Lungu

10/31/2025

03:15 PM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
>
> It seems the rules are:
> 1. If a test does database operations committed or not, a tran... Tomasz Domin

07:38 AM Support #10664: Develop a multi session test suite in harness

Greg Shah wrote:
> Sorry, I still need to catch up here. Are you saying that in OE, the ABLUnit test code in #10664... Artur Școlnic

07:30 AM Support #10664: Develop a multi session test suite in harness

Sorry, I still need to catch up here. Are you saying that in OE, the ABLUnit test code in #10664-86 fails to compile... Greg Shah

07:19 AM Support #10664: Develop a multi session test suite in harness

... Artur Școlnic

06:28 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz Domin wrote:
> > Dont we need tests running on level 0 ? Or test when we control when... Tomasz Domin

06:26 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> Dont we need tests running on level 0 ? Or test when we control when level 1 is entered ?
> ... Artur Școlnic

06:21 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz Domin wrote:
> > I meant something different - if starting a test case implicitly sta... Tomasz Domin

06:20 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> I meant something different - if starting a test case implicitly starts transaction we can onl... Artur Școlnic

06:12 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Maybe I am not explaining myself clear, this is what fails:
> [...]
> This doesn't even mak... Tomasz Domin

05:42 AM Support #10664: Develop a multi session test suite in harness

Maybe I am not explaining myself clear, this is what fails:... Artur Școlnic

05:39 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz Domin wrote:
> > Isnt each ABLUnit test case started within an implicit transaction a... Tomasz Domin

05:28 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> Isnt each ABLUnit test case started within an implicit transaction already ?
AFAIK yes, but... Artur Școlnic

05:26 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> Possible solution is moving subtransaction into a sub-procedure. But that would make tests har... Artur Școlnic

05:25 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> In a simple program, constructs like:
> [...]
> are perfectly legal and cause no trouble.
... Tomasz Domin

05:22 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> From my investigation, this is not a true warning and cannot be suppressed with @SESSION:SUPP... Tomasz Domin

03:21 AM Support #10664: Develop a multi session test suite in harness

In a simple program, constructs like:... Artur Școlnic

08:37 PM Support #10664: Develop a multi session test suite in harness

> there were some hard limits with abl unit and nested explicit transactions
Please provide more details. What ar... Greg Shah

10/30/2025

08:49 AM Support #10664: Develop a multi session test suite in harness

I have to mention an issue I was having in case anybody else encounters it.
If an abl unit class has all capital let... Artur Școlnic

08:41 AM Support #10664: Develop a multi session test suite in harness

I solved all the issues with @flushing_and_validation@ tests, there were some hard limits with abl unit and nested ex... Artur Școlnic

04:29 AM Bug #10399: Index selection in dirty database

Eduard Soltan wrote:
> This issue can also be rejected, as it refers to a unit test rejected from customer applicati... Constantin Asofiei

04:28 AM Bug #10399: Index selection in dirty database

This issue can also be rejected, as it refers to a unit test rejected from customer application. Eduard Soltan

10/29/2025

04:55 PM Bug #10470 (Rejected): Wrong order of records fetching when index modification

Constantin Asofiei

04:50 PM Bug #10470: Wrong order of records fetching when index modification

Teodor Gorghe wrote:
> This issue was solved by #10480?
This issue can be rejected or closed. The test I was inve... Eduard Soltan

03:28 PM Bug #10470: Wrong order of records fetching when index modification

Teodor Gorghe wrote:
> This issue was solved by #10480?
Eduard? Constantin Asofiei

04:42 PM Feature #10491: Tool to standardize PG cluster creation

I have a proposed change so that @max_connections@ can be updated from the default of 100. It would involve adding @-... Roger Borrello

05:14 AM Bug #10560: Wrong buffer picking for ReadXml when seralization name of a buffer correspond to the...

Rebased task branch *10560a* to trunk revision *16250*. Teodor Gorghe

05:01 AM Bug #10560: Wrong buffer picking for ReadXml when seralization name of a buffer correspond to the...

Teodor: please rebase 10560a. Constantin Asofiei

10/27/2025

09:39 AM Bug #9633 (WIP): bulk delete for permanent tables

Branch 9633a was rebased with trunk/16246, current revision is 16248. I'm handing this over to Stefanel, I'll walk hi... Andrei Iacob

09:27 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
>
> For now, please upgrade build.gradle to 1.63 in 10526a.
Sure. In rev. 16151. Eduard Soltan

09:20 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Eduard Soltan wrote:
> Constantin Asofiei wrote:
> > Eduard: please merge 10526a_h2 to fwd-h2 trunk.
>
> Done, i... Constantin Asofiei

09:06 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
> Eduard: please merge 10526a_h2 to fwd-h2 trunk.
Done, is there a task for notificatio... Eduard Soltan

08:09 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Eduard: please merge 10526a_h2 to fwd-h2 trunk. Constantin Asofiei

07:57 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
> Alexandru: can we merge 10526a_h2 to fwd-h2-trunk so 10526a can upgrade the fwd-h2 rev?
... Alexandru Lungu

07:44 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Alexandru: can we merge 10526a_h2 to fwd-h2-trunk so 10526a can upgrade the fwd-h2 rev? Constantin Asofiei

07:37 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Constantin Asofiei wrote:
> Eduard, what's the state of 10526a_h2 ? I assume this is mandatory for the original cus... Eduard Soltan

07:35 AM Bug #10526: Progressive results don't get invalidated when buffer-copy is performed

Eduard, what's the state of 10526a_h2 ? I assume this is mandatory for the original customer scenario to be solved? Constantin Asofiei

10/24/2025

02:41 PM Feature #4369: implement stateless FWD server clustering

I have been going through the classes that update the metadata tables. Here are my findings. Both @UserTableStatUpdat... Andrei Plugaru

07:57 AM Bug #10776: FFC.touch standing out in profiling

In a test for #10737, I am running 4 concurrent REST calls 100.000 times. Nearly 20% of the time across all sessions ... Alexandru Lungu

07:53 AM Bug #10776 (Pending): FFC.touch standing out in profiling

Alexandru Lungu

01:06 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.

Yes, there are 2 unit tests that suffers this issue, but I have didn't considered this high priority to be in trunk b... Teodor Gorghe

10/23/2025

07:05 PM Feature #4369: implement stateless FWD server clustering

> Truth is, I'm not convinced a purely just-in-time implementation of the metadata is the right thing here. At least,... Greg Shah

05:41 PM Feature #4369: implement stateless FWD server clustering

Greg Shah wrote:
> > Greg, regarding the idea to move the refactoring of the metadata support to another task(as mot... Eric Faulhaber

06:56 AM Feature #4369: implement stateless FWD server clustering

> Greg, regarding the idea to move the refactoring of the metadata support to another task(as motivated in #4369-48),... Greg Shah

06:39 AM Feature #4369: implement stateless FWD server clustering

Greg, regarding the idea to move the refactoring of the metadata support to another task(as motivated in #4369-48), d... Andrei Plugaru

05:05 AM Feature #4369: implement stateless FWD server clustering

> The conclusion is that from the list above I don't see any cache that would really need synchronization between ser... Greg Shah

04:53 AM Feature #4369: implement stateless FWD server clustering

I have been going through all the caches I have found in FWD in order to understand if they need synchronization:
# ... Andrei Plugaru

12:54 PM Bug #10590 (Test): Indices are not taken from the model temp-table

10590a was merged into trunk and archived. Eduard Soltan

11:33 AM Bug #10590 (Merge Pending): Indices are not taken from the model temp-table

Eduard, please merge after 9906a Constantin Asofiei

11:48 AM Bug #10390: FIND FIRST buffer field change does not propagate into the next FIRST FIRST statements.

Teodor, is this an issue with the #9457 customer app? Constantin Asofiei

09:45 AM Bug #10542 (Test): Write trigger called when multiple buffers reference the same record

10542a, was merged to trunk rev. 16238 and archived. Eduard Soltan

08:00 AM Bug #10542 (Merge Pending): Write trigger called when multiple buffers reference the same record

This can be merged after 10501a Constantin Asofiei

09:36 AM Bug #10480 (Test): Wrong sort criteria in FOR LAST when index has desc component

Eduard Soltan

09:35 AM Bug #10480: Wrong sort criteria in FOR LAST when index has desc component

1480a was merged to trunk rev. 16235 and archived. Eduard Soltan

07:59 AM Bug #10480 (Merge Pending): Wrong sort criteria in FOR LAST when index has desc component

This can be merged after 10417a Constantin Asofiei

08:32 AM Bug #10455 (Test): Persistent table CAN-FIND FIRST issue

Branch *10455a* was merged to trunk rev. *16231* and archived. Teodor Gorghe

07:57 AM Bug #10455 (Merge Pending): Persistent table CAN-FIND FIRST issue

This can be merged after 10336b. Constantin Asofiei

03:11 AM Bug #10772: NUM-RESULTS on a FOR EACH query fails

+ Added watchers Teodor Gorghe

03:06 AM Bug #10772: NUM-RESULTS on a FOR EACH query fails

{{Collapse(book.df)... Teodor Gorghe

03:04 AM Bug #10772 (Internal Test): NUM-RESULTS on a FOR EACH query fails

Teodor Gorghe

10/22/2025

05:47 AM Bug #7793 (Closed): incremental conversion with deleted table from .df

Greg Shah

10/21/2025

02:55 PM Feature #4369: implement stateless FWD server clustering

First of all, thank you Greg and Eric for your input!
Regarding the H2 changes mentioned in #4369-44, at this mome... Andrei Plugaru

10:37 AM Feature #4369: implement stateless FWD server clustering

From #4369-4:
> * dirty share database
> ** This is a quirk of the 4GL implementation where uncommitted index upd... Eric Faulhaber

07:43 AM Feature #4369: implement stateless FWD server clustering

I will also re-iterate the advice I've previously given about how we support metadata. We should NOT be maintaining ... Greg Shah

07:34 AM Feature #4369: implement stateless FWD server clustering

> While writing the last point, I realised that, not only the metadata H2 tables need to be synced, but also 4GL temp... Greg Shah

10/20/2025

10:48 AM Feature #4369: implement stateless FWD server clustering

I started going over the things that need synchronization based on the list from #4369-4 and came up with solutions u... Andrei Plugaru

08:54 AM Support #10664: Develop a multi session test suite in harness

I encountered a problem with the multi session test results with FWD.
I have a main session test that modifies a rec... Artur Școlnic

07:03 AM Support #10664: Develop a multi session test suite in harness

Tomasz,
We need to mention in the wiki that with FWD, @unit_test.xml@ must be created from @unit_test.xml.template@... Artur Școlnic

10/17/2025

05:52 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> I understand that individual tests are run in parallel, but the test sets are sequential, no?... Tomasz Domin

05:48 AM Support #10664: Develop a multi session test suite in harness

Tomasz Domin wrote:
> ps. funny thing - I've just tried setting @parallel = "1"@ and changed all the port in @cross_... Artur Școlnic

05:42 AM Support #10664: Develop a multi session test suite in harness

I understand that individual tests are run in parallel, but the test sets are sequential, no?
I have a lot of scenar... Artur Școlnic

05:37 AM Support #10664: Develop a multi session test suite in harness

Artur Școlnic wrote:
> Tomasz,
> I would like to reuse some test classes in multiple test-sets, this means that the... Tomasz Domin

04:54 AM Support #10664: Develop a multi session test suite in harness

Tomasz,
I would like to reuse some test classes in multiple test-sets, this means that the same socket will be used,... Artur Școlnic

01:21 AM Bug #10590: Indices are not taken from the model temp-table

Eduard, see 10590a/16183 - a copy of the index AST is required when copying from the model. Constantin Asofiei