MichaelR wrote:

You should check your log first from Service Center > Monitoring, it will help you to find out what is causing timeout for your process. You can ask further if you need more help

Try to do that delete query as well on that machine toward the database machine. lot of possible suspect here but check that one out as well. could be latency or network issue.

I think it might have to do with some sort of lock that OS puts on the table

In the specific flow that often jams up, it's calling a couple of actions that delete, add and delete a row from the entity in rapid succession. By altering a setting to avoid this branch of the code we no longer have the problem.

HOWEVER while it's not a breaking issue for us in the current case, the behavior from outysystems is still concerning. If there was a lock we would hope OS would give a more useful response than just freezing for a minute. I also can't seem to reproduce it in another module so It seems like there may be some edge-case behavior in the underlying OS db that is causing this.

I guess you already raised this to OS given your statement.

I am just curious that your single record entity takes up 90 second to do. Can you share the flow?

Hi,

We have also stumbled upon this issue in one of apps. Do you perhaps have any information or a resolution from OS on why this could be happening?

Regards,

Heinri

It sounds like a lock issue, Couple of thing you can do to check or minimize the issue

1) Is it possible that someone else may have the record opened in a transaction/ Do you do bulk operations on the table that take a while, if so these may be locking multiple records or even the entire table

2) Are you using getforupdate? this puts a lock on the record until the record is later updated and can increase your chance of having issues

3) Are you doing a lot of operations in the action or the actions calling it? A transaction will stay open until the last action exits or is manually closed and that can result in record locks being open. If you are doing the delete at the end of your logic you could try doing a committransaction to see if that helps

I agree with Jeanene, it does sound like a locking issue.

To further enhance your investigation, I would like to suggest triggering the concern and after doing so, try generating a QUERIES PERFORMANCE Report so you can analyze how long and what kind of action is taking up the resource or causing the contention lock.

CRUD operations are tagged here especially if they are not performing well.

Aside from that, try reading the logs under the GENERAL Tab as it shows data such as SLOW SQLS or at least any hint that could lead towards this issue. then the rest of the community can assist from there.

It would be nice to open up a new post or thread to this concern so the rest of the community can help assist in this issue.

Thanks!

-Jose

Hi MichaelR ,

Can you please check connection between application server & database server, It may be due to connection issue between application server & database server.

Regards

Shashikant Shukla