Re: any idea regarding this error?
От | Tom Lane |
---|---|
Тема | Re: any idea regarding this error? |
Дата | |
Msg-id | 22014.1059490028@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | any idea regarding this error? ("Mel Jamero" <mel@gmanmi.tv>) |
Ответы |
Re: any idea regarding this error?
|
Список | pgsql-novice |
"Mel Jamero" <mel@gmanmi.tv> writes: > PostgreSQL 7.2; OS Red Hat Linux release 7.3 (Valhalla); 2016 MB Memory; > 15% Disk Space Usage > description: an insert into a table fires a trigger that creates other > tables. same script works in 7.1 & 7.3; > DEBUG: server process (pid 5203) was terminated by signal 11 Well, my short answer would be "use 7.3" ;-) If you don't like that answer, the next question is did you really mean 7.2, or 7.2.4? (Any answer other than "it's 7.2.4" is the wrong one --- there are bad bugs in earlier 7.2.* releases, and you should update immediately.) If it is 7.2.4, and you want to investigate the problem, then look for the core file left by the crashed backend process. It should be in $PGDATA/base/YOURDBNUMBER/core. (If you don't see any core files, you probably need to restart the postmaster under "ulimit -c unlimited" to allow core files to be produced in crashes.) Once you have a core file, do this: gdb /path/to/postgres /path/to/core gdb> bt gdb> quit Send along the gdb output and other details of the problem to the pgsql-bugs list, and we'll take a look ... regards, tom lane
В списке pgsql-novice по дате отправления: