Really odd corruption problem: cannot open pg_aggregate: No such file or directory
От | Adam Haberlach |
---|---|
Тема | Really odd corruption problem: cannot open pg_aggregate: No such file or directory |
Дата | |
Msg-id | 20030724101706.A5939@newsnipple.com обсуждение исходный текст |
Ответы |
Re: Really odd corruption problem: cannot open pg_aggregate:
Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory Re: Really odd corruption problem: cannot open pg_aggregate: No such file or directory |
Список | pgsql-hackers |
So, one of the many machines that I support seems to have developed an incredibly odd and specific corruption that I've never seen before. Whenever a query requiring an aggregate is attempted, it spits out: cannot open pg_aggregate: No such file or directory and fails. If I do: select * from pg_class where relname='pg_aggregate'; I see that the relation exists. If I check the relfilenode in the data directory, that exists, and seems to be an object file containing what should be the basic aggregate functions. version: PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) The system ran for a few weeks before anything odd happened, and then suddenly this. Does anyone have any ideas? Now that I look at the above string, I realize that the system /is/ an Athlon processor. Does anyone know if there could be an issue between the i686 and athlon optimizations? -- Adam Haberlach | "When your product is stolen by thieves, you adam@mediariffic.com | have a police problem. When it is stolen by http://mediariffic.com | millions of honest customers, you have a | marketing problem." - GeorgeGilder
В списке pgsql-hackers по дате отправления: