[Glass] How to solve this problem - concurrency on one field/attribute

[Lourens van Nieuwenhuizen]

Hi Marten

What about System>>millisecondsSinceTransactionBoundary?

Regards

Lourens

From: Glass <glass-bounces at lists.gemtalksystems.com> On Behalf Of Marten Feldtmann via Glass
Sent: Tuesday, 23 August 2022 09:31
To: via Glass <glass at lists.gemtalksystems.com>
Subject: [Glass] How to solve this problem - concurrency on one field/attribute

Please note this email originated from external. Please treat with caution.
________________________________
I've face a problem for years now using Gemstone/S and I did several attempts to solve this, but I would like to ask, if there is a hidden trick to get rid of concurrency in this case using Gemstone/s.

Think about a session object holding an attribute with a timestamp - a timestamp, where the last successful commit has been done in this session. Its a rough index about how the session hasn't done anything (regarding the read-only user case).

This session object is shared in a Javascript ui frontend-application (actually the gop to the session) - and now whenever this ui calls an API function on the   server (resulting in a commit), the session object in the server gets updated. But if the UI now opens several windows and would like to do sevral independent stuff with the same session in  a concurrency way - you will notice, that the API calls might fail - due to concurrency of updating the same timestamp from different "logical" threads.

How can this be solved in Gemstone/S ? Retry of the transaction just due to this field might be pretty cost intensive.

How did I try to solve that in the past ?

a) I added an update object in a work queue and and independent topaz process worked on that work queue

In a newer attempt I introduced RabbitMQ in our solutions and use RabbitMQ for holding the information formerly stored in the work queue in Gemstone/S and now the topaz process receives information from RabbitMQ and updates the data in an optimized way. The good thing here is, that  I get session updates in an transaction with or without commit.

Any ideas ?


This electronic message, including any attachments, is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged or confidential. If you are not the intended recipient, please notify us immediately by replying to this message and then delete this message from your system. Any use, dissemination, distribution or reproduction of this message or any attachments by unintended recipients is unauthorised and may be unlawful. We have taken precautions to minimise the risk of transmitting software viruses, but we advise you to perform your own virus checks on any attachment to this message. We do not accept liability for any loss or damage caused by software viruses.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gemtalksystems.com/mailman/archives/glass/attachments/20220823/663f6e6d/attachment-0001.htm>