The UPDATE was something like:
UPDATE bucket SET qty_available = qty_available + 1 WHERE bucket_uid = 0940850938059380590
Thanks for all your help guys!
On Mon, Jul 29, 2019 at 9:04 PM Jean Baro <jfbaro@xxxxxxxxx> wrote:
All the failures come from the Bucket Table (see image below).I don't have access to the DB, neither the code, but last time I was presented to the UPDATE it was changing (incrementing or decrementing) qty_available, but tomorrow morning I can be sure, once the developers and DBAs are back to the office. I know it's quite a simple UPDATE.Table is called Bucket:{autovacuum_vacuum_scale_factor=0.01}On Mon, Jul 29, 2019 at 3:12 PM Michael Lewis <mlewis@xxxxxxxxxxx> wrote:Can you share the schema of the table(s) involved and an example or two of the updates being executed?