Hello Jain Sorry forgot to indicate: it is running the ubuntu packaged version 13.3 on ubuntu 20.04. It is not in the cloud, but is a VM in a government datacentre. I am not sure of the underlying hyperviser. I could find out. Regards Bob On Mon, 24 May 2021 at 12:35, Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote: > > I think there have been similar issues reported earlier as well. But it would be too early to generalize. > > > Where is the db server running? Cloud? > > Also what is the version ? > > > On Mon, May 24, 2021, 5:00 PM Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote: >> >> I am seeing a strange issue on a database using jdbc. Regularly, 4 or >> 5 times a day, I see something like a "stutter", where a bundle of >> maybe 30 transactions suddenly finish at the same time. It looks like >> (it is quite hard to catch this exactly) that the lead transaction >> which has been blocking the rest has been blocked in COMMIT. In each >> case it blocks for almost exactly 30s, just over, and once it goes >> through, releases locks, and the others clear behind it. >> >> My question: what are the range of possibilities that might cause a >> COMMIT to block? I haven't seen this before. Is there anything >> suspicious about the regular 30s? Occasionally we see 60s, which >> seems likely to be two sets of 30. >> >> Regards >> Bob >> >>
