I am having an issue with Analysis Server. I believe it based on the pgsql database. the pg_log has these errors:
2015-04-30 19:35:59 GMT::@:: ERROR: could not open file "base/16384/12554": No such file or directory
2015-04-30 19:36:19 GMT::@:: ERROR: could not open file "base/12788/12554": No such file or directory
2015-04-30 19:36:39 GMT::@:: ERROR: could not open file "base/1/12554": No such file or directory
I have confirmed that they are in the /base directory structure. I thought I would try the suggestion here to rebuild the database:
but it also complains about the missing 12554 file.
Looking for some suggestions.
So, I guess finding out what table 12554 is first by running this on prelert db.
select * from pg_class where oid=12554
would be helpful. But I'm afraid that you may just end up doing the restore/recreate the whole db, anyways. Hopefully finding out the table in effect could help you find a pattern to the root cause. I'd check with postgresql.org and see if anyone there can help. or maybe this is a db corruption issue - Corruption - PostgreSQL wiki