FWD » Core Development » Database

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

04/06/2026

11:00 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Artur Școlnic wrote:
> [...]
> I don't think 4gl hydrates all the fields on find.
That's what it looks like from y... Ovidiu Maxiniuc

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

> Yes, I cannot replicate the issue with a test case and I am not sure how we end up in RAQ from a for each/preselect... Alexandru Lungu

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

Alexandru Lungu wrote:
> > DO PRESELECT each Book fields (book-id isbn) no-lock:
>
> What index is used in this s... Artur Școlnic

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

> DO PRESELECT each Book fields (book-id isbn) no-lock:
What index is used in this statement?
> message Book.bo... Alexandru Lungu

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

Alexandru Lungu wrote:
> This should have saved a snapshot / reference record that had both f1 and f2 hydrated.
Doe... Artur Școlnic

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

... Artur Școlnic

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

I am not sure this is right:
* @buffer.loadRecord(placeholder);!@ is not looking right. @placeholder@ is (usually)... Alexandru Lungu

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

Artur Școlnic wrote:
> 4GL allows fields only for preselected and presorted fetches, you cannot delete a record whil... Artur Școlnic

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

> Alex, please take a look at 11301c.
Will do now. Alexandru Lungu

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

I know, but I have linked Eduard's task to be aware of @NO-LOCK/SHARE-LOCK/EXCLUSIVE-LOCK@ behavior when using @FIELD... Teodor Gorghe

03:27 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Teodor, I forgot to mention something, this issue is visible only during load testing with 100 concurrent clients. Th... Artur Școlnic

03:22 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Constantin Asofiei wrote:
> Alex, please take a look at 11301c.
+ Alexandru Artur Școlnic

10:32 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

Teodor, keep in mind that excluded/included fields belong to a single component. So, if you join multiple component... Constantin Asofiei

10:29 AM Bug #7999: FWD does not honor FIELDS/EXCEPT at dynamic queries

While working on #11298, I have discovered that optimized @CQ@ components does not have the @included@ and @excluded@... Teodor Gorghe

05:32 AM Feature #11291: Improve h2 locking system

IMO, #11356 makes this task obsolete. We cannot change the locking system in PageStore (internal architecture limitat... Artur Școlnic

05:30 AM Feature #11291: Improve h2 locking system

Artur Școlnic wrote:
> Constantin Asofiei wrote:
> > Well, don't we get unique index violations and maybe other pro... Constantin Asofiei

05:28 AM Feature #11291: Improve h2 locking system

Constantin Asofiei wrote:
> Well, don't we get unique index violations and maybe other problems otherwise? As we di... Artur Școlnic

05:26 AM Feature #11291: Improve h2 locking system

Artur Școlnic wrote:
> MVStore is great because of the superior lock acquiring algorithm, but if we synchronize all ... Constantin Asofiei

05:24 AM Feature #11291: Improve h2 locking system

MVStore is great because of the superior lock acquiring algorithm, but if we synchronize all the access to meta in FW... Artur Școlnic

04:13 AM Feature #11291: Improve h2 locking system

The 11291a branch is obsolete after 11282a was merged. About the MERGE statements - in H2 these lock the table for e... Constantin Asofiei

03:20 AM Bug #11356: Synchronize the access to the meta database in FWD

In a highly concurrent environment, PageStore's storage engine in H2 becomes a point of contention because of the ine... Artur Școlnic

03:16 AM Bug #11356 (New): Synchronize the access to the meta database in FWD

Artur Școlnic

04/03/2026

10:13 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Artur Școlnic wrote:
> Constantin, to answer your question.
> > is it guaranteed that the placeholder record still ... Constantin Asofiei

09:56 AM Bug #11347: IGNORE_FIELDS_ERROR is thrown in RAQ, extend rereadfields support

Alex, please take a look at 11301c. Constantin Asofiei

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

I've seen in the OG task #11301 the following line:
> Record placeholder = referenceRecord != null ? referenceReco... Alexandru Lungu

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

Artur Școlnic

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

Constantin, to answer your question.
> is it guaranteed that the placeholder record still exists in the table - in o... Artur Școlnic

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

During stress testing of a customer application, IGNORE_FIELDS_ERROR was unexpectedly thrown... Artur Școlnic

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

Artur Școlnic

04/01/2026

09:32 AM Bug #10962 (WIP): Optimized multi-table compound components are not invalidated

I fixed most of this in 10962a:
* Register optimized components to ChangeBroker
* Fixed CQ generated by AQ invali... Alexandru Lungu

03/31/2026

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

I’m looking to wrap up the last remaining item for the cluster synchronization: the metadata tables.
We previously... Eduard Soltan

03/30/2026

01:56 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Updated documentation to include how to adjust the @batchResultsSize@ parameter:
https://proj.goldencode.com/project... Teodor Gorghe

03/27/2026

10:26 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Please tell when to port these changes to custom customer build line. Teodor Gorghe

10:24 AM Bug #9383 (Test): Cache only the current delegate on transaction commit if a ProgressiveResults i...

Branch 9383c was merged into trunk as rev. 16488 and archived. Teodor Gorghe

10:15 AM Bug #9383 (Merge Pending): Cache only the current delegate on transaction commit if a Progressive...

> Yes, I have made the customer application setup just for that.
Nice job! Please proceed with merging 9383a to tr... Alexandru Lungu

10:14 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Yes, I have made the customer application setup just for that. Teodor Gorghe

10:13 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Do you also mean #10275?
Alexandru Lungu

10:11 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I have already tested that and this is why I have moved from @OFFSET@ approach to fetch by pk.
Every change that I h... Teodor Gorghe

10:10 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

> All testing was done and it can be scheduled for merging.
#11154 is the number one priority for testing this. We... Alexandru Lungu

10:08 AM Bug #7841 (Test): Invalid conversion of temp table DMO when using clob/blob fields

Branch 7841a was merged into trunk as rev. 16487 and archived. Stefanel Pezamosca

10:00 AM Bug #7841 (Merge Pending): Invalid conversion of temp table DMO when using clob/blob fields

Please merge this to trunk now. Alexandru Lungu

03:35 AM Bug #7841: Invalid conversion of temp table DMO when using clob/blob fields

I forgot about this, the regression testing has passed for 7841a.
I think we can merge this. Stefanel Pezamosca

09:44 AM Bug #11332: SimpleResults.rows might store Object instead of Object[]

There is a bug in @SimpleResults.rows@ so that the generic is bypassed forcefully somewhere so that a plain Object is... Alexandru Lungu

09:42 AM Bug #11332 (New): SimpleResults.rows might store Object instead of Object[]

Alexandru Lungu

05:58 AM Feature #11291 (Review): Improve h2 locking system

I changed the meta db to use mvstore and fixed the unique constraint violation in @databaseConnected@ by using @merge... Artur Școlnic

04:19 AM Feature #11291: Improve h2 locking system

The problem is the pattern used in @databaseConnected@, currently id does @select@ -> @insert@/@update@ and assumes (... Artur Școlnic

03/26/2026

11:41 AM Feature #11291: Improve h2 locking system

For testing I am using a script that starts a number of concurrent batch clients that connect to the database.
With ... Artur Școlnic

03/25/2026

11:16 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Ok, thanks!
All testing was done and it can be scheduled for merging. Teodor Gorghe

11:16 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Tests passed successfully, nothing unusual. Stefanel Pezamosca

09:21 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

No problem.
I would have been tested by myself, but I am struggling with the disk space. Teodor Gorghe

09:18 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Teodor Gorghe wrote:
> *Stefanel*, when you have time, please test this branch on your main application (I have aske... Stefanel Pezamosca

09:12 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Committed revision *16429* on task branch *9383c*:
- Fixed regressions from ChUI regression tests.
Now, the ChUI ... Teodor Gorghe

09:36 AM Feature #10491: Tool to standardize PG cluster creation

Ovidiu Maxiniuc wrote:
> Roger Borrello wrote:
> > Ovidiu, I have been seeing the below after the server connects t... Roger Borrello

07:57 AM Feature #10491: Tool to standardize PG cluster creation

Roger Borrello wrote:
> Ovidiu, I have been seeing the below after the server connects to the DB. Do you know where ... Ovidiu Maxiniuc

03/23/2026

11:29 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I have found the issue.
I have didn't looked that much when the query is @PreselectQuery@ from conversion.
The issu... Teodor Gorghe

04:44 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

About the regression from ChUI Regression tests, I have debugged the test, but unfortunate, I was unable to see the i... Teodor Gorghe

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

I have also tested the difference between @LIKE@ and @RANGE CHECK@ on @PSQL@.
When the @libc@ collation provider i... Teodor Gorghe

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

I have also noticed that for Western characters, there is no difference between @BASIC@ and @ICU-UCA@ on @RANGE CHECK... Teodor Gorghe

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

This is another example of @RANGE CHECK@ vs @BEGINS@, using @UTF-8@ collation on 4GL:... Teodor Gorghe

03/20/2026

04:49 PM Bug #9383 (Internal Test): Cache only the current delegate on transaction commit if a Progressive...

Teodor Gorghe wrote:
> Committed revision *16428* on task branch *9383c*:
Good job! Please go ahead with regressi... Ovidiu Maxiniuc

08:07 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

On ChUI regression tests, there is one unexpected test which fails now. I am investigating this once the ChUI regress... Teodor Gorghe

07:02 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Committed revision *16428* on task branch *9383c*:
- Fixed SQLServer issue (set the limit to be 0). Teodor Gorghe

06:52 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I have found where the @LIMIT@ is inserted, and that is because the @maxLimit@ is set. I will set it to 0 since is no... Teodor Gorghe

06:38 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

There is actually a regression from *9383c* on *SQLServer*.
The issue comes from the fact that you can't use @OFFSET... Teodor Gorghe

04:20 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Committed revision *16427* on task branch *9383c*:
- Changes to address #9383-129 observation (no functional differe... Teodor Gorghe

01:40 PM Bug #11288: Check if c3p0 is required for in-memory databases

Artur Școlnic wrote:
> With c3p0, this worked by accident because @connection.close()@ doesn't actually close the co... Ovidiu Maxiniuc

12:03 PM Bug #11288: Check if c3p0 is required for in-memory databases

Ovidiu Maxiniuc wrote:
> I agree.
> The drop of c3p0 pooling support for in-memory databases was just an optimisati... Eric Faulhaber

07:07 AM Bug #11288: Check if c3p0 is required for in-memory databases

Done:
> Port of trunk/16478: Reverted changes done by 11288a in trunk/16471. (refs: #11288) Alexandru Lungu

06:56 AM Bug #11288: Check if c3p0 is required for in-memory databases

Alexandru Lungu wrote:
> Branch 11288c was merged into trunk as rev. 16478 and archived.
Please also patch 10614_ma... Constantin Asofiei

06:55 AM Bug #11288 (WIP): Check if c3p0 is required for in-memory databases

Branch 11288c was merged into trunk as rev. 16478 and archived. Alexandru Lungu

06:53 AM Bug #11288 (Merge Pending): Check if c3p0 is required for in-memory databases

11288c now has the revert of trunk/16471.
I am preparing to merge it to trunk. Alexandru Lungu

06:44 AM Bug #11288: Check if c3p0 is required for in-memory databases

> Alex: can you take care of the rollback?
Now is WIP. Alexandru Lungu

06:03 AM Bug #11288: Check if c3p0 is required for in-memory databases

Alex: can you take care of the rollback? Constantin Asofiei

09:35 PM Bug #11288: Check if c3p0 is required for in-memory databases

I agree.
The drop of c3p0 pooling support for in-memory databases was just an optimisation, as proven by the initial... Ovidiu Maxiniuc

09:32 AM Feature #10491: Tool to standardize PG cluster creation

Updated in revision 16473 when I realized the external tool @create_roles.sql@ was not included. This version creates... Roger Borrello

09:17 AM Feature #9305: Replace begins with interval based conditional

This is one difference between @BEGINS@ and @range check@, on @BASIC@ collation:... Teodor Gorghe

03/19/2026

02:15 PM Bug #11288 (WIP): Check if c3p0 is required for in-memory databases

Alex/Ovidiu: we need to back out 11288a changes from trunk and 10614_main, via a branch 11288c:
* we are now bypassi... Constantin Asofiei

01:41 PM Bug #11288: Check if c3p0 is required for in-memory databases

Please check if we are not re-using a prepared statement after the connection has closed. Also, post a small test, ... Constantin Asofiei

01:39 PM Bug #11288: Check if c3p0 is required for in-memory databases

Constantin Asofiei wrote:
> I don't understand this - are you saying there is some async processing in the backgroun... Artur Școlnic

01:33 PM Bug #11288: Check if c3p0 is required for in-memory databases

Artur Școlnic wrote:
> With direct connections, @close()@ is immediate. So the sequence was effectively:
> 1. setBl... Constantin Asofiei

01:23 PM Bug #11288 (Review): Check if c3p0 is required for in-memory databases

We were using @stmt.setBlob@ in @TypeManager@, which in H2 doesn't immediately send the data to the database. Instead... Artur Școlnic

08:21 AM Bug #11288 (Internal Test): Check if c3p0 is required for in-memory databases

Let me know when you find the issue. Constantin Asofiei

08:19 AM Bug #11288: Check if c3p0 is required for in-memory databases

Constantin,
There is an issue with an unit test from the large gui application suite, I need to see what is is first... Artur Școlnic

07:47 AM Bug #11288 (Merge Pending): Check if c3p0 is required for in-memory databases

Artur, add history entry and merge to trunk and 10614_main now. Constantin Asofiei

03/18/2026

05:01 PM Feature #10491: Tool to standardize PG cluster creation

Ovidiu Maxiniuc wrote:
> [...]
> ...but my guess is that it happens at the time the secondary databases (dirty/meta... Eric Faulhaber

08:56 AM Feature #10491: Tool to standardize PG cluster creation

Ovidiu Maxiniuc wrote:
> Roger,
> I remember seeing that warning. I did not investigate what is the exact cause, bu... Roger Borrello

12:44 PM Bug #11288: Check if c3p0 is required for in-memory databases

Ovidiu, I also added cfg initialization. Artur Școlnic

12:27 PM Bug #11288 (Review): Check if c3p0 is required for in-memory databases

Ovidiu, I don't think there is other initialization missed, the rest was c3p0 specific.
Please review 11288b.
I alr... Artur Școlnic

12:01 PM Bug #11288: Check if c3p0 is required for in-memory databases

Artur: Please update [[regression:Open Regressions in FWD v4]] with the details. Greg Shah

11:59 AM Bug #11288 (WIP): Check if c3p0 is required for in-memory databases

Thank you, Stefanel.
Ovidiu, I'll add this and see if I forgot something else in the 'b' branch. Artur Școlnic

11:39 AM Bug #11288: Check if c3p0 is required for in-memory databases

Artur, trunk/16471 seems to have a regression. The new @ConnectionProvider.getH2Connection@ is missing this piece of ... Stefanel Pezamosca

08:13 AM Bug #11288 (Test): Check if c3p0 is required for in-memory databases

I did port the change. Artur Școlnic

06:01 AM Bug #11288: Check if c3p0 is required for in-memory databases

Since this task was derived from #11282, I assume the patch should be delivered to the custom branch also? Artur Școlnic

06:00 AM Bug #11288: Check if c3p0 is required for in-memory databases

11288a was merged to trunk/16471. Artur Școlnic

05:47 AM Bug #11288 (Merge Pending): Check if c3p0 is required for in-memory databases

Please merge 11288a to trunk after 11068c. Alexandru Lungu

03:56 AM Bug #11288: Check if c3p0 is required for in-memory databases

I think we can merge this one. Artur Școlnic

10:31 AM Bug #10385 (Test): Incorrect reset of the cursor cache in Reposition

Greg Shah

10:28 AM Bug #10385 (Internal Test): Incorrect reset of the cursor cache in Reposition

This task is the same issue as 11021, so it can be closed. Eduard Soltan

06:21 AM Feature #9545: confirm/add table parameter support

Committed on *9545a, rev. 16473*.
- improved shouldRaiseBeforeError method logic, to handle FWD actor and paramete... Eduard Soltan

03/17/2026

06:59 PM Feature #10491: Tool to standardize PG cluster creation

Roger,
I remember seeing that warning. I did not investigate what is the exact cause, but my guess is that it happen... Ovidiu Maxiniuc

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

Ovidiu: Please review.
Roger: This should be in the FWD project under @tools/scripts/@. Greg Shah

10:50 AM Bug #11288: Check if c3p0 is required for in-memory databases

I tested the multi tenant application since it's the most complex in terms of the db infrastructure. I spotted no reg... Artur Școlnic

10:40 AM Feature #9545: confirm/add table parameter support

Committed on *9545a, rev. 16473.*
Fixed different error handling logic. Eduard Soltan

03/16/2026

11:14 AM Bug #11288 (Internal Test): Check if c3p0 is required for in-memory databases

All my observations seems to be addressed. Please start the regression tests. Ovidiu Maxiniuc

06:56 AM Bug #11288: Check if c3p0 is required for in-memory databases

Ovidiu Maxiniuc wrote:
> +Review of 11288a / r16469+
> ** line 256: the defaulting to @TenantManager.DEFAULT_TENANT... Artur Școlnic

09:19 AM Feature #11291: Improve h2 locking system

Setting a certain lock mode for certain h2 databases is a reasonable solution, anything that involves changing the ov... Artur Școlnic

09:00 AM Feature #11291: Improve h2 locking system

> Switch to MVStore, which handles concurrency more robustly and avoids these locking complications.
If this is pr... Alexandru Lungu

08:47 AM Feature #11291: Improve h2 locking system

After extensive analysis and trial and error, modifying the H2 @PageStore@ locking system is proving extremely comple... Artur Școlnic

08:14 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

In @BatchResults.java@:
* there is a missing @*@ at line 36;
* lines 519/520 and 583/584: by moving the concatena... Ovidiu Maxiniuc

02:37 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Addressed the code review #9383-127 in +9383c / r16426+. Teodor Gorghe

05:38 AM Feature #9545: confirm/add table parameter support

Changes in current form passed initial conversion and regression tests on ETF. Eduard Soltan

05:36 AM Feature #9545 (Review): confirm/add table parameter support

Committed on *9545a, rev. 16470*.
- Before table of the REFERECE-ONLY temp-table is passed as parameter to RecordB... Eduard Soltan

03/14/2026

09:39 PM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

+Review of 9383c / r16422..16425+
I focused only to latest changes. Let me know if I should review the full change... Ovidiu Maxiniuc

08:17 PM Bug #11288: Check if c3p0 is required for in-memory databases

+Review of 11288a / r16469+
I think the code is good. Except for restricting the direct connection only to in-memo... Ovidiu Maxiniuc

03/13/2026

09:11 AM Feature #11291: Improve h2 locking system

Important note:
H2 has a general invariant - *the lock must be on the @database@ instance*, this is expected through... Artur Școlnic

08:54 AM Bug #10772: NUM-RESULTS on a FOR EACH query fails

All testing was done and the branch is ready to be merged to trunk. Teodor Gorghe

07:33 AM Bug #11288 (Review): Check if c3p0 is required for in-memory databases

Ovidiu, please review 11288a. Artur Școlnic

07:32 AM Bug #11288 (WIP): Check if c3p0 is required for in-memory databases

11288a contains several changes:
* refactored @JdbcDataSource@ to manage only persistent db connections
* small re... Artur Școlnic

03:24 AM Bug #11288: Check if c3p0 is required for in-memory databases

For single threaded performance comparison of h2 direct connection and pooling, please see #11282-40.
With a more 'r... Artur Școlnic

05:26 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

*Ovidiu*, please take a look into the changes. Please tell if this is alright. Teodor Gorghe

05:22 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Committed revision *1832* on *xfer testcases*:
- Added tests for BatchResults (#9383).
Committed revision *16423*... Teodor Gorghe

02:48 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Status from yesterday:
- I have tested different queries, outer-join, with 2 or more components, query with only one... Teodor Gorghe

03/12/2026

08:04 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Committed revision *16422* in task branch *9383c*:
- When possible, fetch the records in batch by PK.
I will do s... Teodor Gorghe

06:17 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

Awesome!!! Greg Shah

05:59 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I have tested #11154 and now it takes 2 minutes (from 4 minutes). Teodor Gorghe

05:24 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I have great news.
I have tested #9383 with PK fetching in batches, and I see very noticible changes in performance.... Teodor Gorghe

04:42 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I think the easiest solution for this is to fetch the records in batches, by PK (eg. @IN@ syntax from SQL). This will... Teodor Gorghe

07:58 AM Feature #11291 (WIP): Improve h2 locking system

Artur Școlnic

06:37 AM Feature #11291: Improve h2 locking system

In H2 using the PageStore engine, writes acquire locks on database pages or tables. In a highly concurrent environmen... Artur Școlnic

06:34 AM Feature #11291 (Review): Improve h2 locking system

Artur Școlnic

03/11/2026

09:29 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I can confirm that #11154 is caused by fetching smaller batches instead of one with bigger batch size.
Suppose you... Teodor Gorghe

08:31 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

There is no dynamic mode, which I have thought.
The issue from #11154 comes from the fact that the @Session@ cache i... Teodor Gorghe

08:00 AM Bug #9383: Cache only the current delegate on transaction commit if a ProgressiveResults is used

I have managed to get the #11154 up and running, but I see that there is a regression also with 9383c (baseline time ... Teodor Gorghe

08:13 AM Bug #11288: Check if c3p0 is required for in-memory databases

This task is to investigate the performance benefit of c3p0 for in-memory databases.
* _temp doesn't use c3p0 and it... Alexandru Lungu

08:11 AM Bug #11288 (Test): Check if c3p0 is required for in-memory databases

Alexandru Lungu

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

This effort was integrated in #11037 Alexandru Lungu

07:29 AM Feature #11287: Leverege the pg_prewarm function to improve cold server performance

An extension of this task is fine tuning the shared buffer cache size, the default is quite modest at 128Mb, I think ... Artur Școlnic

07:25 AM Feature #11287: Leverege the pg_prewarm function to improve cold server performance

@pg_prewarm@ is a PostgreSQL extension that loads tables or indexes into memory (the shared buffer cache) before they... Artur Școlnic

07:09 AM Feature #11287 (New): Leverege the pg_prewarm function to improve cold server performance

Artur Școlnic

03/10/2026

02:08 PM Feature #9545: confirm/add table parameter support

h3. Buffer / Temp-Table explicit deletion... Eduard Soltan