FWD » Core Development » Database

05/06/2026

10:53 AM Feature #6720: lazy hydration

Greg Shah wrote:
> Why would we ever hydrate or store state for a @CAN-FIND@? It should not affect any buffers (tha... Teodor Gorghe

10:47 AM Feature #6720: lazy hydration

Why would we ever hydrate or store state for a @CAN-FIND@? It should not affect any buffers (that are explicitly ref... Greg Shah

10:42 AM Feature #6720: lazy hydration

*Alexandru*, what do you think we should do in this scenario:... Teodor Gorghe

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

There is something that Constantin mentioned in the last stand up.
Initially, I load the data to Redis by parsing ... Eduard Soltan

05/04/2026

11:20 AM Feature #4369: implement stateless FWD server clustering

Eduard Soltan wrote:
> *Question* why does @values@ in @Attribute@ class is an Vector? Shouldn't it be just a simple... Constantin Asofiei

11:17 AM Feature #4369: implement stateless FWD server clustering

Greg Shah wrote:
> Yes, we need to implement the directory solution now.
>
> I'm OK in principle with a redis bas... Eduard Soltan

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

Yes, we need to implement the directory solution now.
I'm OK in principle with a redis based backend. I assume tha... Greg Shah

02:38 AM Feature #4369: implement stateless FWD server clustering

About the need to synchronize directory changes, I think we need to implement a centralized directory back-end now (p... Eduard Soltan

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

I little bit about my work on implementation of stateless clustering:
- During some experiments I determined that ... Eduard Soltan

09:17 AM Bug #10962: Optimized multi-table compound components are not invalidated

Made an update on 10962a/rev. 16542:
* Stabilized 10962a. The biggest issue was the lack of support of indexed-rep... Alexandru Lungu

06:18 AM Bug #11015 (Closed): allow cleanup the DMO types, caches, etc for dynamic temp-tables

Constantin Asofiei

06:17 AM Bug #11015: allow cleanup the DMO types, caches, etc for dynamic temp-tables

Branch 11015b was merged to trunk rev 16546 and archived. Constantin Asofiei

06:11 AM Bug #11015 (Merge Pending): allow cleanup the DMO types, caches, etc for dynamic temp-tables

I've been testing this and is OK. I'm merging 11015b now. Constantin Asofiei

04/30/2026

10:04 AM Bug #10962: Optimized multi-table compound components are not invalidated

Made an update on 10962a/rev. 16541:
* Fixed the blurred line between @storeReferenceRow@ and @overrideReferenceRo... Alexandru Lungu

08:12 AM Feature #6720: lazy hydration

Testcase where the @Session.associate@ error appears (@item@ table has at least one record):... Teodor Gorghe

04/29/2026

09:03 AM Bug #10962: Optimized multi-table compound components are not invalidated

Made an update on 10962a/rev. 16540:
* Removed dynamicPreproc and dynamicArgs from AdaptiveComponent. In fact, the... Alexandru Lungu

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

As mentioned on the call this morning, I think that in a clustered environment we need a centralized directory. My i... Greg Shah

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

Some other notes:
* we need to check all nodes use the same JDBC configurations (URL, passwords, etc), for landlord ... Constantin Asofiei

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

A little update on running a stateless cluster on a customer application.
This stack trace shows a heavy lock con... Eduard Soltan

04/27/2026

05:03 AM Bug #11413 (WIP): Investigate CQ optimization for preselect component with dynamic component

Refer to #11397-7:
* construct a for each block with a CQ that has a preselect component and dynamic component (RA... Alexandru Lungu

05:00 AM Bug #11413 (WIP): Investigate CQ optimization for preselect component with dynamic component

Alexandru Lungu

04/22/2026

03:22 AM Feature #4369: implement stateless FWD server clustering

[Deleted] Eduard Soltan

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

Eduard Soltan wrote:
> Is it about @server-side-resources@ node? I didn't see it set in any project.
Please post th... Constantin Asofiei

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

Is it about @server-side-resources@ node? I didn't see it set in any project. Eduard Soltan

02:46 AM Feature #4369: implement stateless FWD server clustering

Eduard, please post your directory.xml. Constantin Asofiei

04/21/2026

01:44 PM Feature #4369: implement stateless FWD server clustering

I started 2 serves with the script from #11392.
I get the following error:... Eduard Soltan

04/20/2026

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

Eric, these settings are more under @persistence@, per-database, and not per server. Constantin Asofiei

01:54 PM Feature #4369: implement stateless FWD server clustering

Committed on 4369a, disabled runtime support VSTs.
Added new class @MetaConfig@, to keep VSTs enable/disable flags... Eduard Soltan

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

I'm OK with a STOP condition. Greg Shah

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

If the legacy code tries to use one of the _meta tables, I think it is more logical to raise a STOP condition instead. Ovidiu Maxiniuc

03:42 AM Feature #4369: implement stateless FWD server clustering

If we disable the usage of @MetadataTables@ from the directory configuration, and if we still encounter an usage of t... Eduard Soltan

04/17/2026

10:12 AM Bug #11379: implement "live" metadata tables in persistent database

Just for reference:
!{width:50%}fwd-clustering-02.jpg!
* each FWD node
** publishes _meta to FWD Broker
** reques... Ovidiu Maxiniuc

08:32 AM Bug #11379: implement "live" metadata tables in persistent database

> This is not a problem specific to the H2 pagestore engine; we've not seen sufficient improvement with the MVStore e... Alexandru Lungu

04/16/2026

07:27 PM Bug #11015: allow cleanup the DMO types, caches, etc for dynamic temp-tables

I have no objections.
Constantin, I know I told you this week about some possible issues I seen while looking the f... Ovidiu Maxiniuc

10:54 AM Bug #11379: implement "live" metadata tables in persistent database

> will we have a server hierarchy (tree, star)?
> all nodes equals and a 1-to-1 communication between all servers?
... Greg Shah

07:35 AM Bug #11379: implement "live" metadata tables in persistent database

Eric Faulhaber wrote:
>
> Using a persistent database for this purpose may also make the stateless clustering solu... Eduard Soltan

06:06 AM Bug #11379: implement "live" metadata tables in persistent database

Here is a graphical representation of how I see the architecture at this moment:
!{width:50%}fwd-clustering-01.jpg!
... Ovidiu Maxiniuc

05:43 AM Bug #11347 (Review): IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

11347a addressed the concerns above. Alex, please review. Artur Școlnic

01:42 AM Bug #10937 (Test): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty

Branch 10937a was merged into trunk as rev. 16518 and archived. Teodor Gorghe

01:29 AM Bug #10937 (Merge Pending): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not ...

Please merge now. Constantin Asofiei

01:04 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty

They passed and the performance for the remaining apps is the same. Teodor Gorghe

04/15/2026

06:58 PM Bug #11379: implement "live" metadata tables in persistent database

Currently we support the following VSTs (alphabetically ordered):
|_. VST Legacy Name |_. Java Class |_. Write Str... Ovidiu Maxiniuc

05:01 PM Bug #11379: implement "live" metadata tables in persistent database

This option was discussed in a standup meeting today as an alternative to using the H2 database in memory for "live" ... Eric Faulhaber

04:35 PM Bug #11379 (New): implement "live" metadata tables in persistent database

Eric Faulhaber

01:05 PM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty

Teodor, what testing is left here? If ETF, ChUI and unit tests for other apps passed, then is OK to merge. Constantin Asofiei

08:02 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

> If the customer explicitly excluded the index fields, yes, the fix would not work and the error will be thrown same... Alexandru Lungu

04/14/2026

04:38 PM Feature #4369: implement stateless FWD server clustering

Eduard, we actively have been making changes to the implementation of the updatable metadata tables to overcome locki... Eric Faulhaber

08:41 AM Bug #11015: allow cleanup the DMO types, caches, etc for dynamic temp-tables

In 11015b/16519 I've addressed these:
Review report:
> * *[CRITICAL]* _functional_ @ProxyFactory.CacheKey@.@hashC... Constantin Asofiei

07:43 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Alexandru Lungu wrote:
> Review of trunk/16514:
>
> * there is a potential NPE in @collectIndexedFields@. If @Per... Artur Școlnic

07:31 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

11301c was merged to trunk in rev 16514 to solve an immediate issue.
See #11301-165 for a set of concerns that rem... Greg Shah

04/08/2026

01:49 PM Bug #11161: fail gracefully when the database connection can not be established

Instead of @PersistenceException@, shouldn't we be using a @StopConditionException@ (e.g. a legacy-compatible conditi... Greg Shah

06:28 AM Bug #11347 (WIP): IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

I had a talk with Alex. The getters are invoked only for the indexed fields, so we just have to make sure to always h... Artur Școlnic

04:32 AM Bug #11347 (Review): IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Artur Școlnic

04:32 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Yes, only the included fields are available, the indexes do not affect this mechanism.
Artur Școlnic wrote:
> I t... Artur Școlnic

04:30 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Artur, so if you exclude fields which are part of the index used in this query, then in 4GL they are still not availa... Constantin Asofiei

04/07/2026

06:32 PM Bug #11161: fail gracefully when the database connection can not be established

I came back to 11161a. Without actually running the new code, I am not sure I fully understand the changes, so this i... Ovidiu Maxiniuc

07:12 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Alexandru,
I committed the solution to 11301c, please review. Artur Școlnic

07:01 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

I tried reloading the buffer when the AQ is invalidated, it solved the issue. Artur Școlnic

06:02 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

When invalidating an @AdaptiveQuery@, can't we force load the snapshot, if is incomplete?
> Considering that inRAQ... Constantin Asofiei

05:33 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

I manage to come up with a recreate in a single session:
Book should have at least 2 records.... Artur Școlnic