This is a cryptographically signed message in MIME format.
--------------ms080209000601080805040909
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi,
We've been working with the excellent Second Quadrant to resolve some
data corruption issues caused by a database crash. I'm trying to get an
explanation of a recurring issue that we're seeing with the database.
Basically, some queries that are run against the DB take the following form;
CREATE TEMP TABLE 'x' ON COMMIT DROP AS SELECT...
>From this, we often get an ERROR and the transaction doesn't complete.
The error message is invariably;
ERROR: cache lookup failed for relation 5168456
Using ois2name has left me more confused, as the provided OID doesn't
seem to existing anywhere in the database. I've read some discussion
from Tom Lane that I didn't really follow on the [HACKERS] list and one
of our consultants mentioned that this might be related to a bug fix
between 8.4.0 and 8.4.1.
Can anyone break this down into SysAdmin (NOT DBA!) language for me? If
it involves reading manuals or whitepapers, that's fine. If it involves
reading source code, I'm game to give it a try. If it involves years of
study in database theory, I think it needs to be a little simpler than
that!!
Many thanks
--
Dave Barton
Senior Systems Administrator - Comodo
--------------ms080209000601080805040909
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIISTDCC
BIowggNyoAMCAQICECf06hH0eobEbp27bqkXBwcwDQYJKoZIhvcNAQEFBQAw bzELMAkGA1UE
BhMCU0UxFDASBgNVBAoTC0FkZFRydXN0IEFCMSYwJAYDVQQLEx1BZGRUcnVz dCBFeHRlcm5h
bCBUVFAgTmV0d29yazEiMCAGA1UEAxMZQWRkVHJ1c3QgRXh0ZXJuYWwgQ0Eg Um9vdDAeFw0w
NTA2MDcwODA5MTBaFw0yMDA1MzAxMDQ4MzhaMIGuMQswCQYDVQQGEwJVUzEL MAkGA1UECBMC
VVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNF UlRSVVNUIE5l
dHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQG A1UEAxMtVVRO
LVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMIIB IjANBgkqhkiG
9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsjmFpPJ9q0E7YkY3rs3BYHW8OWX5ShpH ornMSMxqmNVN
NRm5pELlzkniii8efNIxB8dOtINknS4p1aJkxIW9hVE1eaROaJB7HHqkkqgX 8pgV8pPMyaQy
lbsMTzC9mKALi+VuG6JG+ni8om+rWV6lL8/K2m2qL+usobNqqrcuZzWLeeEe aYji5kbNoKXq
vgvOdjp6Dpvq/NonWz1zHyLmSGHGTPNpsaguG7bUMSAsvIKKjqQOpdeJQ/wW Wq8dcdcRWdq6
hw2v+vPhwvCkxWeM1tZUOt4KpLoDd7NlyP0e03RiqhjKaJMeoYV+9Udly/hN Vyh00jT/MLbu
9mIwFIws6wIDAQABo4HhMIHeMB8GA1UdIwQYMBaAFK29mHo0tCb3+sQmVO8D veAky1QaMB0G
A1UdDgQWBBSJgmd9xJ0mcABLtFBIfN49rgRufTAOBgNVHQ8BAf8EBAMCAQYw DwYDVR0TAQH/
BAUwAwEB/zB7BgNVHR8EdDByMDigNqA0hjJodHRwOi8vY3JsLmNvbW9kb2Nh LmNvbS9BZGRU
cnVzdEV4dGVybmFsQ0FSb290LmNybDA2oDSgMoYwaHR0cDovL2NybC5jb21v ZG8ubmV0L0Fk
ZFRydXN0RXh0ZXJuYWxDQVJvb3QuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQAZ 2IkRbyispgCi
54fBm5AD236hEv0e8+LwAamUVEJrmgnEoG3XkJIEA2Z5Q3H8+G+v23ZF4jca Pd3kWQR4rBz0
g0bzes9bhHIt5UbBuhgRKfPLSXmHPLptBZ2kbWhPrXIUNqi5sf2/z3/wpGqU NVCPz4FtVbHd
WTBK322gnGQfSXzvNrv042n0+DmPWq1LhTq3Du3Tzw1EovsEv+QvcI4l+1pU BrPQxLxtjftz
Mizpm4QkLdZ/kXpoAlAfDj9N6cz1u2fo3BwuO/xOzf4CjuOoEwqlJkRl6RDy TVKnrtw+ymsy
XEFs/vVdoOr/0fqbhlhtPZZH5f4ulQTCAMyOofK7MIIG2zCCBcOgAwIBAgIP bPF3ENeHXN9v
aWo7fTzhMA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJVUzELMAkGA1UE CBMCVVQxFzAV
BgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNU IE5ldHdvcmsx
ITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMt VVROLVVTRVJG
aXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTA4MTIw MjAwMDAwMFoX
DTExMTIwMjIzNTk1OVowggFWMQswCQYDVQQGEwJHQjEPMA0GA1UEERMGTTUg M0VRMRswGQYD
VQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEzARBgNVBAcTCk1hbmNoZXN0ZXIx EDAOBgNVBAkT
B1NhbGZvcmQxJjAkBgNVBAkTHU9mZmljZSBWaWxsYWdlLCBFeGNoYW5nZSBR dWF5MR8wHQYD
VQQJExYzcmQgRmxvb3IsIEJ1aWxkaW5nIDI2MRYwFAYDVQQKEw1Db21vZG8g Q0EgTHRkMTMw
MQYDVQQLEypJc3N1ZWQgdGhyb3VnaCBDb21vZG8gQ0EgTHRkIEUtUEtJIE1h bmFnZXIxHzAd
BgNVBAsTFkNvcnBvcmF0ZSBTZWN1cmUgRW1haWwxFDASBgNVBAMTC0RhdmUg QmFydG9uMSUw
IwYJKoZIhvcNAQkBFhZkYXZlLmJhcnRvbkBjb21vZG8uY29tMIIBIjANBgkq hkiG9w0BAQEF
AAOCAQ8AMIIBCgKCAQEA1MEkTtxVis2JBrlOxJC9dWO8JkGsApSM9ZZ2cZQ6 io1lcAXcvnXY
6Curl+bP7dVwDXm4+YiO171nZV+cin58akAB0bx0eT0vmZ3mfHCBsIayqXaR yGLmk++f8KaP
ZVkPK9MjCukVRyf4hP0quuKJzC1+3/SJCQBfRa1ot8J/cwBBCwipsklSc6Wa uTCfwSiVhLO1
uY48akZr5zwwqA99CdTSClIh0GB3xGSLe59SLlTLkTT86yIK9TaWQAbQ5eZY H7esIykBWglm
z/6cu0cvBzEgGK8p+L9OGmsnqMys3NGoPm4Zjgp2XdTZLWM4dKAJQpWoSyj+ 5fF6xrqBFU8G
UwIDAQABo4ICSTCCAkUwHwYDVR0jBBgwFoAUiYJnfcSdJnAAS7RQSHzePa4E bn0wHQYDVR0O
BBYEFPQB5lmu5wxhaprlDQ2HOsvHtP5NMA4GA1UdDwEB/wQEAwIFoDAMBgNV HRMBAf8EAjAA
MCkGA1UdJQQiMCAGCCsGAQUFBwMEBggrBgEFBQcDAgYKKwYBBAGCNxQCAjAR BglghkgBhvhC
AQEEBAMCBaAwRgYDVR0gBD8wPTA7BgwrBgEEAbIxAQIBAwUwKzApBggrBgEF BQcCARYdaHR0
cHM6Ly9zZWN1cmUuY29tb2RvLm5ldC9DUFMwgaUGA1UdHwSBnTCBmjBMoEqg SIZGaHR0cDov
L2NybC5jb21vZG9jYS5jb20vVVROLVVTRVJGaXJzdC1DbGllbnRBdXRoZW50 aWNhdGlvbmFu
ZEVtYWlsLmNybDBKoEigRoZEaHR0cDovL2NybC5jb21vZG8ubmV0L1VUTi1V U0VSRmlyc3Qt
Q2xpZW50QXV0aGVudGljYXRpb25hbmRFbWFpbC5jcmwwbAYIKwYBBQUHAQEE YDBeMDYGCCsG
AQUFBzAChipodHRwOi8vY3J0LmNvbW9kb2NhLmNvbS9VVE5BQUFDbGllbnRD QS5jcnQwJAYI
KwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmNvbW9kb2NhLmNvbTBJBgNVHREEQjBA gRZkYXZlLmJh
cnRvbkBjb21vZG8uY29toCYGCisGAQQBgjcUAgOgGAwWZGF2ZS5iYXJ0b25A Y29tb2RvLmNv
bTANBgkqhkiG9w0BAQUFAAOCAQEAArmhbyrs3Xv7l032f86ZblEbucfzfh7D qzbUFA+jF8nU
1r1iS+IbbTv1h3Ss/iv0yHe728UXVtfnqvntCStR9nmrBOGYeJMJ1/+eEoDW cuinXFAlsAro
xr2HjpE/f2D28t+w4Coi+yuWXfu5XjpRpcAlo7WHBpYOvdSKXz+9J5EciwnY g1Q/xxhFsIQ8
faqJVy9IBDUKqcSm4l5FPbujenb7m9W7/wmEMnQ+7pdr0HhVDGfvdGFi+CRt f4LNhrC06yGu
nM8o3XMNDccg3SUOAHEFZmBlfpxTNFlyhiIl3DNOJLCNK1VmADYEvhc9Y3bj v5kQi3u4LDci
GqM2qj7jKzCCBtswggXDoAMCAQICD2zxdxDXh1zfb2lqO3084TANBgkqhkiG 9w0BAQUFADCB
rjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExh a2UgQ2l0eTEe
MBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRw Oi8vd3d3LnVz
ZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1 dGhlbnRpY2F0
aW9uIGFuZCBFbWFpbDAeFw0wODEyMDIwMDAwMDBaFw0xMTEyMDIyMzU5NTla MIIBVjELMAkG
A1UEBhMCR0IxDzANBgNVBBETBk01IDNFUTEbMBkGA1UECBMSR3JlYXRlciBN YW5jaGVzdGVy
MRMwEQYDVQQHEwpNYW5jaGVzdGVyMRAwDgYDVQQJEwdTYWxmb3JkMSYwJAYD VQQJEx1PZmZp
Y2UgVmlsbGFnZSwgRXhjaGFuZ2UgUXVheTEfMB0GA1UECRMWM3JkIEZsb29y LCBCdWlsZGlu
ZyAyNjEWMBQGA1UEChMNQ29tb2RvIENBIEx0ZDEzMDEGA1UECxMqSXNzdWVk IHRocm91Z2gg
Q29tb2RvIENBIEx0ZCBFLVBLSSBNYW5hZ2VyMR8wHQYDVQQLExZDb3Jwb3Jh dGUgU2VjdXJl
IEVtYWlsMRQwEgYDVQQDEwtEYXZlIEJhcnRvbjElMCMGCSqGSIb3DQEJARYW ZGF2ZS5iYXJ0
b25AY29tb2RvLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEB ANTBJE7cVYrN
iQa5TsSQvXVjvCZBrAKUjPWWdnGUOoqNZXAF3L512Ogrq5fmz+3VcA15uPmI jte9Z2VfnIp+
fGpAAdG8dHk9L5md5nxwgbCGsql2kchi5pPvn/Cmj2VZDyvTIwrpFUcn+IT9 Krriicwtft/0
iQkAX0WtaLfCf3MAQQsIqbJJUnOlmrkwn8EolYSztbmOPGpGa+c8MKgPfQnU 0gpSIdBgd8Rk
i3ufUi5Uy5E0/OsiCvU2lkAG0OXmWB+3rCMpAVoJZs/+nLtHLwcxIBivKfi/ ThprJ6jMrNzR
qD5uGY4Kdl3U2S1jOHSgCUKVqEso/uXxesa6gRVPBlMCAwEAAaOCAkkwggJF MB8GA1UdIwQY
MBaAFImCZ33EnSZwAEu0UEh83j2uBG59MB0GA1UdDgQWBBT0AeZZrucMYWqa 5Q0NhzrLx7T+
TTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADApBgNVHSUEIjAgBggr BgEFBQcDBAYI
KwYBBQUHAwIGCisGAQQBgjcUAgIwEQYJYIZIAYb4QgEBBAQDAgWgMEYGA1Ud IAQ/MD0wOwYM
KwYBBAGyMQECAQMFMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNv bW9kby5uZXQv
Q1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2Eu Y29tL1VUTi1V
U0VSRmlyc3QtQ2xpZW50QXV0aGVudGljYXRpb25hbmRFbWFpbC5jcmwwSqBI oEaGRGh0dHA6
Ly9jcmwuY29tb2RvLm5ldC9VVE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRp Y2F0aW9uYW5k
RW1haWwuY3JsMGwGCCsGAQUFBwEBBGAwXjA2BggrBgEFBQcwAoYqaHR0cDov L2NydC5jb21v
ZG9jYS5jb20vVVROQUFBQ2xpZW50Q0EuY3J0MCQGCCsGAQUFBzABhhhodHRw Oi8vb2NzcC5j
b21vZG9jYS5jb20wSQYDVR0RBEIwQIEWZGF2ZS5iYXJ0b25AY29tb2RvLmNv baAmBgorBgEE
AYI3FAIDoBgMFmRhdmUuYmFydG9uQGNvbW9kby5jb20wDQYJKoZIhvcNAQEF BQADggEBAAK5
oW8q7N17+5dN9n/OmW5RG7nH834ew6s21BQPoxfJ1Na9YkviG2079Yd0rP4r 9Mh3u9vFF1bX
56r57QkrUfZ5qwThmHiTCdf/nhKA1nLop1xQJbAK6Ma9h46RP39g9vLfsOAq Ivsrll37uV46
UaXAJaO1hwaWDr3Uil8/vSeRHIsJ2INUP8cYRbCEPH2qiVcvSAQ1CqnEpuJe RT27o3p2+5vV
u/8JhDJ0Pu6Xa9B4VQxn73RhYvgkbX+CzYawtOshrpzPKN1zDQ3HIN0lDgBx BWZgZX6cUzRZ
coYiJdwzTiSwjStVZgA2BL4XPWN247+ZEIt7uCw3IhqjNqo+4ysxggRaMIIE VgIBATCBwjCB
rjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExh a2UgQ2l0eTEe
MBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRw Oi8vd3d3LnVz
ZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1 dGhlbnRpY2F0
aW9uIGFuZCBFbWFpbAIPbPF3ENeHXN9vaWo7fTzhMAkGBSsOAwIaBQCgggJs MBgGCSqGSIb3
DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5MTEyMzEwMjkw MFowIwYJKoZI
hvcNAQkEMRYEFKuZjY4VUgCkUor4dqMct1A5zJIqMF8GCSqGSIb3DQEJDzFS MFAwCwYJYIZI
AWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0D AgIBQDAHBgUr
DgMCBzANBggqhkiG9w0DAgIBKDCB0wYJKwYBBAGCNxAEMYHFMIHCMIGuMQsw CQYDVQQGEwJV
UzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYD VQQKExVUaGUg
VVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRy dXN0LmNvbTE2
MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24g YW5kIEVtYWls
Ag9s8XcQ14dc329pajt9POEwgdUGCyqGSIb3DQEJEAILMYHFoIHCMIGuMQsw CQYDVQQGEwJV
UzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYD VQQKExVUaGUg
VVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRy dXN0LmNvbTE2
MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24g YW5kIEVtYWls
Ag9s8XcQ14dc329pajt9POEwDQYJKoZIhvcNAQEBBQAEggEAQKsjRnOdvYAO Opr58TYYt6Ba
bvmxDtKBfnnCpJeM0ENZeRhGyNEVBoEB3EFSO4wSzBzH5PbCt6eTjpE38bCx GypTfzzSWQNA
/CbJPeHuaQvcHP8PmiCv1KOi3acllL1NDxpzfZ5lN8eGgaRCGt1Qa2eWslwE ohJUZhol3nIF
v1zE5RTHq3fHA3uNFfeLXrORBXF3APmD8sRxgvhIy9v2XOKwm1GfH1gy3jXW 5PuXJhAH6Sop
HFoXiP0KwIaKkljOMpJPYKEUZS4dNuKqRzB9sHJ4nE4CexCmrhGjbf2WALfm vr/1jr7NYMBe
sim2uLPNWJbGSHM0Uzmo760wNLHU6AAAAAAAAA==
--------------ms080209000601080805040909--
