Problem after upgrading to PostgreSQL 12

[Sky]

We have been using MogileFS with a PostgreSQL backend successfully for some time now. However, after upgrading to PostgreSQL 12 (from 10), we are experiencing the following error any time we try to add a new file:

Error registering tempfile: DBD::Pg::db last_insert_id failed: No suitable column found for last_insert_id of table "tempfile" at /usr/local/share/perl/5.20.2/MogileFS/Store.pm line 1099.

We are running the latest DBD::Pg (DBD-Pg-3.10.0) which is supposed to be PostgreSQL 12 compatible - at least according to the documentation.

Any ideas what might be going on here?

[Dave Lambley]

Hi Sky,

I'm not a postgres expert, but the driver source code suggests that
that the problem may be with the tempfile table not having exactly one
sequence associated with it.

https://metacpan.org/source/TURNSTEP/DBD-Pg-3.9.1/Pg.pm#L401

The error seems to come either from line 401 or 408, where it seems to
be looking at the catalog to find an appropriate sequence. Perhaps
check that the table is set up with a SERIAL as expected? I don't
remember how tempfile is used, but you may be able to delete and
recreate it if there are no writes happening.

Hope that helps,
Dave

[Sky]

Sorry for not getting back to you sooner. The deletion of the tempfile seemed to resolve the issue.

Thank you!

Sky