FWD » Core Development » Database

12/30/2025

10:04 AM Bug #10455: Persistent table CAN-FIND FIRST issue

Please see the unit test in #9457-163, 10455b does not solve it. Constantin Asofiei

12/22/2025

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

I think there are some problems there. @eval exec $prog [...] &@ is contradictory because:
* @exec@ replaces the cur... Roger Borrello

05:15 AM Bug #11037 (WIP): Record not being evicted from FFCache

Review of 11037a:
* Why do you need to actually check if @nodeToRemove@ is inside the list? Can't you run @nodeToR... Alexandru Lungu

04:37 AM Bug #10776: FFC.touch standing out in profiling

> Alex, I feel like there could be a issue regarding the single FastFindCacheEntry instance for the negative results(... Alexandru Lungu

04:25 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Eduard Soltan wrote:
>
> I have made a set of tests for the case when 2 buffers to the same table are used.
>
>... Eduard Soltan

04:20 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

Another application unit tests passed. Testing still in WIP. Alexandru Lungu

12/20/2025

08:25 AM Support #11066: How does FWD handle "by-reference"

From Onno:
Hi guys,
In OpenEdge it's possible to specify temp-table parameters as "by-reference".
See: https://... Greg Shah

12/19/2025

04:14 PM Support #11066 (WIP): How does FWD handle "by-reference"

Onno de Haan

11:04 AM Bug #11027: Unflushed record causes infinite loop

A few thoughts I want to note before going into vacation :))
A first problem I am encountering is that there is no p... Andrei Plugaru

07:07 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

ChUI regression testing passed. Testing still in WIP. Alexandru Lungu

02:50 AM Bug #10776: FFC.touch standing out in profiling

Alex, I feel like there could be a issue regarding the single @FastFindCacheEntry@ instance for the negative results(... Andrei Plugaru

12/18/2025

11:35 AM Bug #6767: Possible name clashes in DMO classes

Hynek/Constantin/Eric: What testing is needed here?
Should this be in Internal Test status? Greg Shah

09:37 AM Bug #10776 (Review): FFC.touch standing out in profiling

I prototyped a fix for this: cache the actual @Cache.Entry@ in the FFC so that @touch@ will be able to bypass the map... Alexandru Lungu

08:58 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

The latest code changes are OK, from my PoV. Optionally, you may review the last H entry for typos. Ovidiu Maxiniuc

08:29 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

* 11034a/16322 contains a typo fix
* 11034a/16323 is a bit more invasive as it fixed the @marked@ structure which wa... Alexandru Lungu

07:54 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

Assessed review in #11034-4 in 11034a/16321.
Moving ahead with testing. Alexandru Lungu

08:45 AM Bug #11037 (Review): Record not being evicted from FFCache

I have created @11037a@ and committed @11037a/16325@ with the invalidation changes from #11037-1 and the ones from #1... Andrei Plugaru

07:07 AM Bug #11037 (WIP): Record not being evicted from FFCache

After a discussion yesterday with Alex, we decided to tackle the problem of invalid records in @ReverseLookup.lruCach... Andrei Plugaru

08:42 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

The changes are in 7999a, rev. 16331.
I have made a set of tests for the case when 2 buffers to the same table are... Eduard Soltan

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

I think that can be changed to @lockType.isExclusive()@ Lorian Sandu

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

+ added Artur and Lorian as watchers

I guess my question is why we check if the lock is different then @LockType.... Eduard Soltan

05:15 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Lorian/Artur: please advice on this topic. Alexandru Lungu

04:28 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

I think the way by which we handle the LOCK type change and all fields retrieval is not right.
We retrieve all fie... Eduard Soltan

12/17/2025

12:38 PM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

I have rebased the 7999a, to latest trunk. rev. 16321.
Added changes to handle the case when the query AST is retr... Eduard Soltan

04:16 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Eduard, this task will be required by #10934. I am raising priority. Please rebase 7999a and recap what is left to be... Alexandru Lungu

09:13 AM Bug #10776: FFC.touch standing out in profiling

I started profiling another application (#10981). There is a consistent performance downgrade comparing trunk with 71... Alexandru Lungu

08:42 AM Bug #11037: Record not being evicted from FFCache

While testing the above solution on the unit tests from the large customer application, I found another case when the... Andrei Plugaru

07:52 AM Bug #10937 (WIP): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty

Alexandru Lungu wrote:
> Anything left to review?
Not at this time.
I'm leaving this open for the discussion abo... Constantin Asofiei

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

Anything left to review? Alexandru Lungu

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

Review for 11015a:
* Changes in BufferManager are dependent upon the unique pk across temp-tables; which I think... Alexandru Lungu

12/16/2025

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

10937a_h2 was merged to fwd-h2 trunk rev 64 and archived as merged.
10937b was created from trunk rev 16321 - 1632... Constantin Asofiei

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

@Session.cleanUndoLog@ usage of @undoLog != null@ is database-wide no-undo for all temp-tables, @Table.isNoUndo()@ is... Constantin Asofiei

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

Constantin,
although I am not against it, I do not think the new code in @cleanTable()@ will be executed. As Alex m... Ovidiu Maxiniuc

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

Alexandru Lungu wrote:
> Constantin Asofiei wrote:
> > *Alexandru* - there is another change I want to add to 10937... Constantin Asofiei

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

Constantin Asofiei wrote:
> *Alexandru* - there is another change I want to add to 10937a_h2. In @UndoLog.cleanTabl... Alexandru Lungu

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

*Alexandru* - there is another change I want to add to 10937a_h2. In @UndoLog.cleanTable@, I think we can be no-op i... Constantin Asofiei

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

Ovidiu, at this time I don't think I'll add 10937a to 9457c - 9457c already has a change which always uses this:
<pr... Constantin Asofiei

05:56 AM Bug #11015 (Review): allow cleanup the DMO types, caches, etc for dynamic temp-tables

Alexandru, please review 11015a - this contains a mix of fixes for persistence. I'll use 11015b for the DMO unload. Constantin Asofiei

02:49 AM Bug #11037: Record not being evicted from FFCache

While investigating #10247, I found a scenario where an entry is not being evicted from FFcache at the invalidation s... Andrei Plugaru

02:41 AM Bug #11037 (Review): Record not being evicted from FFCache

Andrei Plugaru

12/15/2025

11:11 AM Bug #11034 (Internal Test): Reduce the number of Object[] created in ChangeSet

I think the changes in @ChangeSet.java@ will work.
I can only recommend some non-mandatory optimisations:
* lines... Ovidiu Maxiniuc

08:54 AM Bug #11034 (Review): Reduce the number of Object[] created in ChangeSet

Alexandru Lungu

08:53 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

Committed 11034a/16320 fixing this issue. Please review. Alexandru Lungu

08:31 AM Bug #11034: Reduce the number of Object[] created in ChangeSet

This task is about the big number of @Object[]@ instances created in @ChangeSet@. The initial capacity defined is 16 ... Alexandru Lungu

08:14 AM Bug #11034 (Test): Reduce the number of Object[] created in ChangeSet

Alexandru Lungu

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

I am OK with the changes in fwd-h2/10937a. They are clean: on @killMultiplex@, replace any undo-entry regarding that ... Alexandru Lungu

12/12/2025

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

Alex - please review fwd-h2 changes. Constantin Asofiei

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

I reverted changes which enhanced DELETE H2 statement with NOUNDO option, the management being performed from @FWDDir... Ovidiu Maxiniuc

07:12 AM Bug #11027: Unflushed record causes infinite loop

> This leads me to think that the solution is to flush the record from test6_8971. Maybe when b_test6_8971 is defined... Alexandru Lungu

06:26 AM Bug #11027: Unflushed record causes infinite loop

While investigating the unit tests for #10247, I got over an infinite loop that can be reproduced with this testcase:... Andrei Plugaru

04:53 AM Bug #11027 (Test): Unflushed record causes infinite loop

Andrei Plugaru

12/11/2025

05:28 PM Bug #10937 (Review): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty

I did multiple tests and the @noundo@ is actually needed when in the @doCloseMultiplexScope()@. I committed the final... Ovidiu Maxiniuc

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

I found another mechansim to handle the pass of the KILL signal to the java process that should also allow execution ... Andrei Plugaru

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

BTW: there are ~4376 temp DMOs and 958 persistent DMOs in the application profiled. So 3070 is not that much IMHO Alexandru Lungu

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

> DmoMetadataManager.byId - this needs to be switched to a map and maintained properly. Alexandru: if you have some o... Alexandru Lungu

12/10/2025

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

This has nothing to do with Docker. It needs to always be done (bare metal, Docker, VM... whatever). If there is a ... Greg Shah

03:48 PM Feature #4369: implement stateless FWD server clustering

Greg Shah wrote:
> Please work with Roger to evaluate and organize testing the @exec@ change.
I must admit I read... Roger Borrello

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

Please work with Roger to evalute and organize testing the @exec@ change. Greg Shah

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

> As the change I proposed(adding @exec@ in the command from @server.sh@) isn't a FWD change per-se, should I documen... Greg Shah

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

Greg Shah wrote:
> I agree. Moreover, graceful shutdown is a core requirement in any installation environment, not ... Andrei Plugaru

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

> IMHO, clients using the clustering feature, will likely use it in a docker env, where they will stop and start cont... Greg Shah

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

The functionality described below is in rev. @16311@ and @16312@.
I have implemented the FWD version(and a hash of... Andrei Plugaru

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

I think these is good news.
Constantin Asofiei wrote:
> * @DmoMetadataManager.byId@ - this needs to be switched t... Ovidiu Maxiniuc

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

I've managed to get classes evicted, but not completely - some still remain, like proxies. But I found other misc le... Constantin Asofiei

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

> limit the number of cached DmoMeta instances, and when they are evicted, unload also from the AsmClassLoader
Thi... Alexandru Lungu

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

A customer uses heavily XMLs to communicate with the FWD server, which in turn creates dynamic temp-tables, and in mo... Constantin Asofiei

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

Constantin Asofiei

04:56 AM Bug #10956: Wrong primary index selection on FOR EACH table

10956a rev 16300 fixes a NPE. Constantin Asofiei

04:20 AM Bug #11008: Performance issue at parsing the query string when it's buffer is part of a large dat...

Let's take the following example:... Eduard Soltan

04:12 AM Bug #11008 (New): Performance issue at parsing the query string when it's buffer is part of a lar...

Eduard Soltan

12/08/2025

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

Constantin,
I did additional tests and, all I could find was an NPE (which I have fixed and will be available in ... Ovidiu Maxiniuc

06:57 AM Bug #10937 (WIP): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty

Ovidiu, I don't think the H2 changes are OK.
The NO-UNDO at the DELETE statement when dropping the multiplex in a ... Constantin Asofiei

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

Comparing the FWD version number and even a checksum of the jar would be a reasonable thing at server startup in clus... Greg Shah

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

I have rebased the @4369a@ branch to @trunk/16298@ and made a few commits for moving the distributed specific logic t... Andrei Plugaru