pg_restore的缓存查找失败？ [英] Cache lookup failure for pg_restore?
问题描述
在我恢复Postgres数据库（使用pg_restore）后，当我尝试运行简单的UPDATE查询时，我收到以下错误消息：
错误：功能70529缓存查找失败
更多详细信息：
1.我备份数据库：
pg_dump -Fc --username = webclient [dbname]> database.backup
2.我恢复数据库：
dropdb -U postgres [dbname]
createdb -U postgres [dbname]
createlang -U postgres plpgsql [dbname]
pg_restore -v -U postgres -Fc -d [dbname] database.backup
3.我连接到数据库并运行查询：
$ psql cspan webclient
欢迎使用psql 7.4， PostgreSQL交互式终端。
类型：\copyright for distribution terms
\ h获取有关SQL命令的帮助
\ ？有关内部斜杠命令的帮助
\ g或以分号结束执行查询
\ q退出
cspan =>更新联系人set gender =''M'';
错误：函数70529的缓存查找失败
cspan =>更新联系人设置性别=''M'';
服务器意外关闭连接
这可能意味着服务器异常终止
之前或之后处理请求。
与服务器的连接丢失。尝试重置：失败。
！>
任何想法可能会发生在这里？这一切都在一个
RedHat linux框中运行。原始数据库（在备份/恢复之前）工作
罚款。该数据库有一些GIST（全搜索，tsearch2）索引，但
否则非常普通。
提前感谢任何见解，
Razvan。
After I restore a Postgres database (using pg_restore), I get the
following error message when I try to run a simple UPDATE query:
ERROR: cache lookup failed for function 70529
More details:
1. I backup the database:
pg_dump -Fc --username=webclient [dbname] > database.backup
2. I restore the database:
dropdb -U postgres [dbname]
createdb -U postgres [dbname]
createlang -U postgres plpgsql [dbname]
pg_restore -v -U postgres -Fc -d [dbname] database.backup
3. I connect to the database and run a query:
$ psql cspan webclient
Welcome to psql 7.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
cspan=> update contact set gender = ''M'';
ERROR: cache lookup failed for function 70529
If I re-run the update, I get:
cspan=> update contact set gender = ''M'';
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
Any ideas what might be happening here? This is all running on a
RedHat linux box. The original database (before backup/restore) works
fine. The database has a few GIST (full-search, tsearch2) indices, but
otherwise is pretty ordinary.
Thanks in advance for any insight,
Razvan.
推荐答案
psql cspan webclient
欢迎使用psql 7.4， PostgreSQL交互式终端。
类型：\copyright for distribution terms
\ h获取有关SQL命令的帮助
\ ？有关内部斜杠命令的帮助
\ g或以分号结束执行查询
\ q退出
cspan =>更新联系人set gender =''M'';
错误：函数70529的缓存查找失败
cspan =>更新联系人设置性别=''M'';
服务器意外关闭连接
这可能意味着服务器异常终止
之前或之后处理请求。
与服务器的连接丢失。尝试重置：失败。
！>
任何想法可能会发生在这里？这一切都在一个
RedHat linux框中运行。原始数据库（在备份/恢复之前）工作
罚款。该数据库有一些GIST（全搜索，tsearch2）索引，但
否则非常普通。
提前感谢任何见解，
Razvan。
psql cspan webclient
Welcome to psql 7.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
cspan=> update contact set gender = ''M'';
ERROR: cache lookup failed for function 70529
If I re-run the update, I get:
cspan=> update contact set gender = ''M'';
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
Any ideas what might be happening here? This is all running on a
RedHat linux box. The original database (before backup/restore) works
fine. The database has a few GIST (full-search, tsearch2) indices, but
otherwise is pretty ordinary.
Thanks in advance for any insight,
Razvan.
su ** ****@yahoo.com （Razvan Surdulescu）写道：
su******@yahoo.com (Razvan Surdulescu) writes:
cspan =>更新联系人设置性别=''M'';
错误：功能70529的缓存查找失败
如果我重新运行更新，我得到：
cspan =>更新联系人设置性别='''M'';
服务器意外关闭连接
Hm，我们能看到联系人的完整架构吗？ table？
数据库有一些GIST（全搜索，tsearch2）索引，但
非常普通。
cspan=> update contact set gender = ''M'';
ERROR: cache lookup failed for function 70529 If I re-run the update, I get: cspan=> update contact set gender = ''M'';
server closed the connection unexpectedly
Hm, could we see the full schema for the "contact" table?
The database has a few GIST (full-search, tsearch2) indices, but
otherwise is pretty ordinary.
任何与联系人有关的问题？
有用的是来自核心的调试器堆栈跟踪
转储...
此外，您可能值得花时间更新到7.4.2，看看这个
是否已经修复了。
< br $> b $ b问候，tom lane
--------------------------- （播出结束）---------------------------
提示4：不要杀人-9''邮政局长
Any of those on "contact"?
What would be useful to look at is a debugger stack trace from the core
dump...
Also it might be worth your time to update to 7.4.2, just to see if this
is an already-fixed bug.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
su **** **@yahoo.com （Razvan Surdulescu）写道：
su******@yahoo.com (Razvan Surdulescu) writes:
cspan =>更新联系人设置性别=''M'';
错误：功能70529的缓存查找失败
如果我重新运行更新，我得到：
cspan =>更新联系人设置性别='''M'';
服务器意外关闭连接
Hm，我们能看到联系人的完整架构吗？ table？
数据库有一些GIST（全搜索，tsearch2）索引，但
非常普通。
cspan=> update contact set gender = ''M'';
ERROR: cache lookup failed for function 70529 If I re-run the update, I get: cspan=> update contact set gender = ''M'';
server closed the connection unexpectedly
Hm, could we see the full schema for the "contact" table?
The database has a few GIST (full-search, tsearch2) indices, but
otherwise is pretty ordinary.
任何与联系人有关的问题？
有用的是来自核心的调试器堆栈跟踪
转储...
此外，您可能值得花时间更新到7.4.2，看看这个
是否已经修复了。
< br $> b $ b问候，tom lane
--------------------------- （播出结束）---------------------------
提示4：不要杀人-9''邮政局长
Any of those on "contact"?
What would be useful to look at is a debugger stack trace from the core
dump...
Also it might be worth your time to update to 7.4.2, just to see if this
is an already-fixed bug.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don''t ''kill -9'' the postmaster
这篇关于pg_restore的缓存查找失败？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
