Activity
From 11/02/2025 to 12/01/2025
12/01/2025
- 11:22 AM Feature #4369: implement stateless FWD server clustering
- I'll have to think about the pattern a bit more before I discuss that.
I do want us to avoid putting the same Geod...
11/28/2025
- 10:10 AM Feature #4369: implement stateless FWD server clustering
- I have been lately focused on implementing refactoring the @LockStatus/TraceLockStatus@ classes in order to be able t...
- 09:29 AM Support #10664: Develop a multi session test suite in harness
- Artur Școlnic wrote:
> Tomasz Domin wrote:
> > I fully agree, I was just wondering if I can help with tooling modif... - 08:35 AM Support #10664: Develop a multi session test suite in harness
- Tomasz Domin wrote:
> I fully agree, I was just wondering if I can help with tooling modification.
Since you brou... - 08:27 AM Support #10664: Develop a multi session test suite in harness
- Artur Școlnic wrote:
> We know there are failures, hence the skewed results, we simply need to work on the issues an... - 08:26 AM Support #10664: Develop a multi session test suite in harness
- We know there are failures, hence the skewed results, we simply need to work on the issues and bring the success rate...
- 08:18 AM Support #10664: Develop a multi session test suite in harness
- Artur Școlnic wrote:
> I finished writing the locking tests, the results are:
> OE: 1610/1610
> FWD: 411/1610
>... - 05:19 AM Support #10664 (Review): Develop a multi session test suite in harness
- I finished writing the locking tests, the results are:
OE: 1610/1610
FWD: 411/1610
There are two main reasons wh... - 03:47 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Committed revision *16298* on task branch *10455b*:
- Set the batch mode validation to false when it is in bulk copy. - 01:49 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Committed revision *16297* on task branch *10455b*:
- Changed reportBatchValidationException to throw the error. - 01:43 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- I am thinking on something else:
* when the assigned buffer is the destination buffer, or something else, a variable... - 01:05 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Constantin Asofiei wrote:
> Also, does the original test scenario still work?
Yes, they still work, I have tested...
11/27/2025
- 12:09 PM Bug #10455: Persistent table CAN-FIND FIRST issue
- For show vs throwError I think there are two cases:
* if validation fails and LVALUE is the buffer (or field?) which... - 10:50 AM Bug #10455 (Review): Persistent table CAN-FIND FIRST issue
- Committed revision *16296* on task branch *10455b*:
- Fixed BUFFER-COPY BATCH ASSIGN when a function call is the fir... - 09:50 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- I have also tried this:...
- 09:38 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Hm... you are right, this works. But, how can we differentiate that we are in an assignment for a target buffer fiel...
- 09:33 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Please try this:...
- 09:29 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Note that @ErrorManager.recordOrThrowError(newErrorCodes, newErrorMessages, false);@ is called in @RecordBuffer.repor...
- 09:26 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Teodor, please check with 12.x this test:...
- 09:01 AM Bug #10455: Persistent table CAN-FIND FIRST issue
- Created task branch *10455b*.
- 09:00 AM Bug #10455 (WIP): Persistent table CAN-FIND FIRST issue
- There is a regression regarding this task.
When the @BUFFER-COPY ASSIGN@ on a buffer on the same table with unique f... - 08:08 AM Bug #6834 (Closed): RAQ navigation on records having NULL values on same index components
- 08:06 AM Bug #6834: RAQ navigation on records having NULL values on same index components
- Cool. Then this can be closed.
- 06:25 AM Bug #6834: RAQ navigation on records having NULL values on same index components
- This has been fixed in a revision before trunk/16000.
The FWD output of the #6834-3 test is:... - 05:20 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- > We can TRUNCATE only if there are separate SQL tables, and we get rid of the MULTIPLEX. Otherwise, we need DELETE ....
- 05:05 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- Alexandru Lungu wrote:
> Mind that this does TRUNCATE AFAIK.
We can TRUNCATE only if there are separate SQL tables,... - 04:51 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- > Otherwise, if it proves too difficult to solve/investigate the destructor conundrums, lets work on enhancing the UP...
- 04:41 AM Feature #9711: collation configuration cleanup
- Stefanel Pezamosca wrote:
> If I understand correctly, the goal here is to to eliminate the need for manual configur... - 03:26 AM Feature #9711: collation configuration cleanup
- If I understand correctly, the goal here is to to eliminate the need for manual configuration and hard-coded settings...
11/26/2025
- 02:48 PM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- Ovidiu, lets solve the @nonEmptyTableFlags@ issue in this task:
* for NO-UNDO tables, this bitmap will work as is - ... - 08:44 AM Bug #10937 (WIP): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- 08:23 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- Or maybe the destructor is deferred till the end of the transaction and we don't see that. Maybe a message after dele...
- 08:22 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- > In the temp-table destroy case, the destructor changes are not rolled back.
So you can create things in the pers... - 08:01 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- Alexandru Lungu wrote:
> > So, does an UNDO revert any created records by such destructors?
>
> Huh, interesting... - 05:07 AM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- > I don't see another way than add a NO-UNDO option for the DELETE statement in H2, so that we can do DELETEs which a...
11/25/2025
- 01:35 PM Bug #10937: fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- This is related also to the #10833-80 scenario, where it was proved that @nonEmptyTableFlags@ is broken in case of ro...
- 01:16 PM Bug #10937 (Test): fwd-h2 'killedMultiplexesCleanup' must not abend if the batch is not empty
- 06:23 AM Bug #10901 (Review): BEGINS trims the rvalue if the lvalue field is first in an index
- Created 10901a from trunk rev 16292. In rev 16293: If in a BEGINS LVALUE is a field part of the index used for sort,...
11/24/2025
- 09:58 AM Feature #6348: implement support for MariaDB
- It should be a different task, please make one in Deployment.
- 09:49 AM Feature #6348: implement support for MariaDB
- Is it fair to continue use of this task for finishing touches on MariaDB? Some things I am considering:
* We have im... - 06:28 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- > Is not about a query from FWD, just a direct SELECT I noticed. Yes, RTRIM=TRUE is in the JDBC URL.
Right. The co... - 06:24 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- Is not about a query from FWD, just a direct SELECT I noticed. Yes, @RTRIM=TRUE@ is in the JDBC URL.
- 04:31 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- PS: I see @dialect.addRtrimmedExpression("?", sb);@. This can be wrapped with @dialect.isAutoRtrim@.
- 04:30 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- Is @RTRIM=TRUE;@ set? H2 also knows to compare the values of strings with rtrim automatically.
- 04:15 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- Alex, as a side note: this query does not return records in H2: @select * from meta_user where userid = rtrim('HOTEL'...
- 03:35 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- I am OK with the changes in #10920-3. This piece of code is a backdoor into the persistence and wasn't handled proper...
- 03:23 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- This is because of the H2's dialect automatic case-insensitive assumption in @P2JH2Dialect@; I've used a JDBC URL li...
11/23/2025
- 05:42 AM Bug #10920: String concatenation doesn't work in WHERE clause for permanent databases
- I used H2 permanent database. No records are found in FWD....
- 05:40 AM Bug #10920 (New): String concatenation doesn't work in WHERE clause for permanent databases
11/21/2025
- 09:48 AM Feature #4369: implement stateless FWD server clustering
- Greg Shah wrote:
> The tables we could expect to be used frequently are not the same tables that are editable. @_fi... - 08:09 AM Feature #4369: implement stateless FWD server clustering
- The tables we could expect to be used frequently are not the same tables that are editable. @_file@, @_field@, @_ind...
- 06:09 AM Feature #4369: implement stateless FWD server clustering
- I am just writing here a discussion that happened in the daily yesterday.
Back when we tested performance for a la...
11/20/2025
- 01:55 PM Feature #4369: implement stateless FWD server clustering
- > In the end, it all comes down to the number of queries executed for the metadata tables for the current and future ...
- 12:52 PM Feature #4369: implement stateless FWD server clustering
- Today I have made some experiments for understanding the time taken for inserting a large number of records in a meta...
11/19/2025
- 02:07 PM Feature #4369: implement stateless FWD server clustering
- > Over the solution presented by you, this has the advantage that the tables don't need to be recreated before each q...
- 01:14 PM Feature #4369: implement stateless FWD server clustering
- Greg Shah wrote:
> For the tables that need to represent state that can change at runtime, I am suggesting that the ... - 11:02 AM Feature #4369: implement stateless FWD server clustering
- > Greg, just to be clear, do you suggest to give up on the H2 metadata tables all together?
No. There is value i... - 06:52 AM Feature #4369: implement stateless FWD server clustering
- Greg Shah wrote:
> I repeat my points of #4369-46 and #4369-54. The existing approach to metadata is overcomplicate...
11/18/2025
- 05:36 PM Feature #4369: implement stateless FWD server clustering
- I repeat my points of #4369-46 and #4369-54. The existing approach to metadata is overcomplicated and causes unneces...
- 04:52 PM Feature #4369: implement stateless FWD server clustering
- Andrei Plugaru wrote:
> [...]
> IMHO, the versioning approach from @UserTableStatUpdater@ and @LockTableUpdater@ is... - 10:32 AM Feature #4369: implement stateless FWD server clustering
- In the last note, I forgot to mentioned the new directory configurations introduced in my latest commits. Right under...
- 07:42 AM Feature #4369: implement stateless FWD server clustering
- I have committed @4369a/16232@. I have completed all the java docs, history entries all the file headers on the new f...
- 11:34 AM Bug #10901: BEGINS trims the rvalue if the lvalue field is first in an index
- Actually things are a little more complicated: what matters is that the field is part of the 4GL index associated wit...
- 09:52 AM Bug #10901: BEGINS trims the rvalue if the lvalue field is first in an index
- This test shows that if a field is part of a leading component, then it will trim the rvalue for @BEGINS@:...
- 09:45 AM Bug #10901 (Closed): BEGINS trims the rvalue if the lvalue field is first in an index
11/17/2025
- 04:30 AM Bug #10890: merge-row-changes does not change the before/after image row-state correctly
- Another issue is that after @merge-row-changes@, in OE there are scenarios in which the *before image is not deleted*...
- 04:27 AM Bug #10890: merge-row-changes does not change the before/after image row-state correctly
- ...
- 04:19 AM Bug #10890 (New): merge-row-changes does not change the before/after image row-state correctly
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...
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... - 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...
- 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...
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...
- 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 ...
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?
... - 10:54 AM Feature #4369: implement stateless FWD server clustering
- I don't think we need the @RemoteLockManager@ if we have proper clustering.
- 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...
- 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...
11/10/2025
- 08:41 AM Feature #4369: implement stateless FWD server clustering
- Queuing it up!
- 08:33 AM Feature #4369 (Review): implement stateless FWD server clustering
- Eric/Alex: Please do this first review.
- 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)....
- 07:32 AM Bug #10838 (New): Unique index violation should be cured even at flush time
11/07/2025
- 08:46 AM Bug #9950 (Review): Upgrade the metadata schema to a newer version
- 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...
- 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 ... - 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... - 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...
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...
- 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... - 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, ... - 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 ...
- 03:58 AM Bug #10822 (New): Lock is not acquired if the update field value is the same as the current one
- 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.
- 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... - 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... - 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 ...
11/04/2025
- 06:50 AM Support #10664: Develop a multi session test suite in harness
- + Ovidiu
- 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 ...
- 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... - 04:38 AM Support #10664: Develop a multi session test suite in harness
- The tests that are not running properly have this pattern:...
- 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... - 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...
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.
- 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
... - 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 ...
- 05:13 AM Bug #10806 (New): Presort queries can sometimes dynamically find records created after opening th...
Also available in: Atom