Hi, I get the following error after upgrading from Postgres 10.10 -> Postgres 11.4
After upgrade completes when running "vacuumdb -p 5432 -U postgres -a -Z --analyze-in-stages" I get the following error: * vacuumdb: processing database "#DBNAME#": Generating minimal optimizer statistics (1 target) vacuumdb: vacuuming of database "#DBNAME#" failed: ERROR: could not access status of transaction 6095 DETAIL: Could not open file "pg_xact/0000": No such file or directory.* After logging into the database using psql and running "VACUUM FULL #table#" for each table I can see it's an issue with pg_statistic *Running VACUUM FULL on table pg_statistic psql.exe : ERROR: could not access status of transaction 6095 At line:23 char:9 + psql.exe -d $db -c "vacuum full $table" + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (ERROR: could n...ransaction 6095:String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError* * DETAIL: Could not open file "pg_xact/0000": No such file or directory.* Any ideas as to how this could have happened or how I can fix this issue? I had the issue once on another server and running VACUUM FULL on entire database fixed the error. Note: I ran "VACUUM FREEZE ANALYZE" before the upgrade on every database and there were no errors. Ben Snaidero *Geotab* Senior Database Specialist Direct +1 (289) 230-7749 Toll-free +1 (877) 436-8221 Visit www.geotab.com Twitter <https://twitter.com/geotab> | Facebook <https://www.facebook.com/Geotab> | YouTube <https://www.youtube.com/user/MyGeotab> | LinkedIn <https://www.linkedin.com/company/geotab/>
