Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Backend crash during explain



Grant Finnemore napsal(a):
CrashReporter trace:

Date/Time:      2007-05-31 10:21:39.285 +0200
OS Version:     10.4.9 (Build 8P2137)
Report Version: 4

Command: postmaster
Path:    ./bin/postmaster
Parent:  postmaster [23091]

Version: ??? (???)

PID:    23096
Thread: 0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x00000018

Thread 0 Crashed:
0   postmaster     0x00116ec6 ExecSetSlotDescriptor + 77 (execTuples.c:344)
1 postmaster 0x001182f9 ExecAssignScanTypeFromOuterPlan + 33 (execUtils.c:771)
2   postmaster     0x001240c8 ExecInitSort + 168 (nodeSort.c:211)

It looks that tupDesc contains invalid pointer. I found some strange assignment in ExecAssignScanTypeFromOuterPlan function. See comment bellow. OuterPlanState expects PlaneState structure instead ScanState.

00762 ExecAssignScanTypeFromOuterPlan(ScanState *scanstate)
00763 {
00764     PlanState  *outerPlan;
00765     TupleDesc   tupDesc;
00766
00767     outerPlan = outerPlanState(scanstate);
					^^^^^
					scanstate->ps ??

00768     tupDesc = ExecGetResultType(outerPlan);
00769
00770     ExecAssignScanType(scanstate, tupDesc);
00771 }


	Zdenek



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group