Golden Code Redmine

03/19/2026

01:39 PM Database 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:23 PM Database 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:19 AM Database 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

03/18/2026

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

Ovidiu, I also added cfg initialization. Artur Școlnic

12:27 PM Database 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

11:59 AM Database 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

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

I did port the change. Artur Școlnic

06:01 AM Database 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 Database Bug #11288: Check if c3p0 is required for in-memory databases

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

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

I think we can merge this one. Artur Școlnic

03/17/2026

10:50 AM Database 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

03/16/2026

09:19 AM Database 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

08:47 AM Database 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

06:56 AM Database 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

03/13/2026

09:11 AM Database 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

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

Ovidiu, please review 11288a. Artur Școlnic

07:32 AM Database 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 Database 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

03/12/2026

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

Artur Școlnic

06:37 AM Database 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 Database Feature #11291 (Review): Improve h2 locking system

Artur Școlnic

03/11/2026

07:29 AM Database 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 Database 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 Database Feature #11287 (New): Leverege the pg_prewarm function to improve cold server performance

Artur Școlnic

04:51 AM Base Language Bug #9060: Cache oftenly used values that are immutable

I extracted the more impactful and safe bdt caching code and tested the performance impact on a customer application.... Artur Școlnic

03/10/2026

11:59 AM Base Language Bug #10313: server-sidef file-system must 'mount' user's working dir and look in this path by def...

10313b is in trunk/16464. Artur Școlnic

08:35 AM Base Language Bug #10313: server-sidef file-system must 'mount' user's working dir and look in this path by def...

Constantin, are we ok to merge this one? Artur Școlnic

03/09/2026

08:45 AM Database Bug #11161 (Review): fail gracefully when the database connection can not be established

I committed the initial version of the fix. With the new approach, if the database connection pool is exhausted, C3P0... Artur Școlnic

05:45 AM Base Language Bug #10313 (Internal Test): server-sidef file-system must 'mount' user's working dir and look in ...

I tested the pasoe project on linux and windows, everything passed. Artur Școlnic

03/06/2026

04:15 AM Base Language Bug #10313: server-sidef file-system must 'mount' user's working dir and look in this path by def...

Unless there are no more concerns, I will start testing. Artur Școlnic

03:51 AM Base Language Bug #10313: server-sidef file-system must 'mount' user's working dir and look in this path by def...

I checked the OE documentation for PASOE and did some experiments, the conclusion is:
* PROPATH: used to find ABL co... Artur Școlnic

03/05/2026

06:36 AM Base Language Bug #10313 (Review): server-sidef file-system must 'mount' user's working dir and look in this pa...

Constantin, I committed the fix to 10313b, please review. Artur Școlnic

06:15 AM Base Language Bug #10313 (WIP): server-sidef file-system must 'mount' user's working dir and look in this path ...

Input streams for files opened using a relative path fails with server-side resources
This is the test case:
<pre... Artur Școlnic

03/04/2026

09:57 AM Database Bug #11231: FastFindCache clear operations may leak memory

11231a was merged to trunk/16455. Artur Școlnic

03:42 AM Database Bug #11231: FastFindCache clear operations may leak memory

I also tested harness, webui navigation and reports, everything looks ok, can we merge? Artur Școlnic

03/03/2026

08:39 AM Base Language Feature #6407: name_map.xml improvements

It looks like a regression, a library procedure is taking an output parameter @size@ and is supposed to return a non ... Artur Școlnic

08:36 AM Base Language Feature #6407: name_map.xml improvements

Danut,
Is @Indeterminate extent dimension 0 is out of range 1 to 28000@ raised? Artur Școlnic

03/02/2026

08:58 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Do we need to port the changes to @custom_build_line@? Artur Școlnic

05:47 AM Database Bug #11231: FastFindCache clear operations may leak memory

Alexandru, I addressed the issues, please review 11231a/16436. Artur Școlnic

02/27/2026

02:49 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ovidiu Maxiniuc wrote:
> Well, that's a philosophical question :).
> When a tenant is deleted, beside the effect on... Artur Școlnic

02/26/2026

01:46 PM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ovidiu, I meant on tenant delete, do we need to disconnect the private database? Artur Școlnic

05:29 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

@ConnectionManager.disconnect@ expects the logical db name, which can/should be the same for all the tenant databases... Artur Școlnic

04:55 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ovidiu Maxiniuc wrote:
> +Review of 11235a / r16440+
>
> Nicely done! I think the code will work as expected.
... Artur Școlnic

02/25/2026

10:05 AM Database Bug #11161: fail gracefully when the database connection can not be established

Greg Shah wrote:
> The @CONNECT@ must be in a *separate* @.p@. Call the @<connect_program>.p@ from *within* the 4GL... Artur Școlnic

09:04 AM Database Bug #11161: fail gracefully when the database connection can not be established

Maybe my tests are wrong, I can't seem to register the STOP
connect.p... Artur Școlnic

08:40 AM Database Bug #11161: fail gracefully when the database connection can not be established

When it comes to database shutdown during an open session:
1. program executed on the server - is terminated, error ... Artur Școlnic

08:05 AM Database Bug #11161: fail gracefully when the database connection can not be established

Artur Școlnic wrote:
> In OE, failure happens early.
> At the beginning of an unbound session:
> * A database conn... Artur Școlnic

06:37 AM Database Bug #11161: fail gracefully when the database connection can not be established

I was talking strictly about insufficient database connections, if the connection is interrupted during a session, I ... Artur Școlnic

04:24 AM Database Bug #11161: fail gracefully when the database connection can not be established

*With the current infrastructure, handling database connection starvation remains challenging*
Key Challenges:
... Artur Școlnic

02/24/2026

12:17 PM Database Bug #11235 (Review): Deprovisioning tenants does not clear data sources

I added cleanup for the dirty database sources and extended the source clearing to include the tenant update scenario... Artur Școlnic

09:35 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Understood, thank you.
I got another question, using the tenant api, we can update a tenant, including the urls. On ... Artur Școlnic

08:57 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ovidiu, please comment on #11235-19. Artur Școlnic

08:10 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

I would expect so. I am using just one tenant, so there are 2 dirty db, the default tenant and the explicit one. Artur Școlnic

08:06 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ok, it makes sense, so we do need to clear only the data source for the dirty databases.
On tenant delete, this is n... Artur Școlnic

07:46 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Also, what about the _temp database, where the temp tables reside? Shouldn't it also be tenant specific and cleared o... Artur Școlnic

06:21 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ovidiu,
I have a few questions:
1. Not all h2 databases are marked as @temp@, is this expected?
2. The dirty data... Artur Școlnic

02:33 AM Database Bug #11235 (WIP): Deprovisioning tenants does not clear data sources

Artur Școlnic

02/23/2026

08:18 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Ovidiu,
Constantin raised the question of data source resources retention, mainly the helper threads, just to be on... Artur Școlnic

04:06 AM Database Bug #11235 (Review): Deprovisioning tenants does not clear data sources

It looks like I was wrong, the values are not overwritten, just a different context local instance of the connection ... Artur Școlnic

03:32 AM Database Bug #11235 (WIP): Deprovisioning tenants does not clear data sources

Ovidiu,
I encountered an issues while working with @tenantsByDatabase@, adding a tenant with the same logical datab... Artur Școlnic

02:18 AM Database Bug #11235: Deprovisioning tenants does not clear data sources

Not sure if it is relevant in these cases, but in certain broker modes, the contexts can be reused across appserver s... Artur Școlnic