Hi Aaron,
did the same on my single WO system using postgres (with only moderate load),
but on your sql query I DO get some result rows. Did no yet have time for
further analysis
Regards, Markus
> Am 14.12.2020 um 22:29 schrieb Aaron Rosenzweig via Webobjects-dev
> :
>
> Has anyone dealt wit
Thanks Paul for the sanity check :-)
> On Dec 14, 2020, at 4:54 PM, Paul Hoadley wrote:
>
> Hi Aaron,
>
> On 15 Dec 2020, at 07:59, Aaron Rosenzweig via Webobjects-dev
> mailto:webobjects-dev@lists.apple.com>>
> wrote:
>
>> Anyone have any thoughts or experience with this?
>
> Just some da
Hi Aaron,
On 15 Dec 2020, at 07:59, Aaron Rosenzweig via Webobjects-dev
wrote:
> Anyone have any thoughts or experience with this?
Just some data points for you. Out of curiosity, I ran that query on several
databases in the wild here (modest traffic—daily sessions in the thousands):
none o
Has anyone dealt with SQL statements that linger and get stuck “idle in
transaction” ?
We started looking carefully at our WO app and Postgres data store. We
discovered that it wasn’t vacuuming because of these hung statements.
Turns out it appears to be deep into WO, when we do fetches somet
