| Lists: | Postg토토 사이트 순위SQL : Postg토토 사이트 순위SQL 메일 링리스트 : 2004-05-18 이후의 PGSQL-BUGS 13:52 |
|---|
| From: | Adam Kempa <janus(at)vtrip(dot)pl> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | postgres crashes |
| Date: | 2004-05-18 13:52:28 |
| Message-ID: | c8d4fd$rq0c8d4fd$rq0$1@atlantis.news.tpi.pl@atlantis.news.tpi.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 사이트 순위SQL : Postg토토 사이트 순위SQL 메일 링리스트 : 2004-05-18 이후의 PGSQL-BUGS 13:52 |
Hello
I've been installed Postgres 7.4.2 on FreeBSD system and when load
average grow up i've error in postgres like this:
ERROR: permission denied for function varchar
ERROR: permission denied for function varchar
and then postgres crashes.
LOG: server process (PID 9787) was terminated by signal 11
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
LOG: all server processes terminated; reinitializing
FATAL: the database system is starting up
This error occurs on Postgres version 7.4.x .
This error doesn't occur on Postgres version 7.3.x but are much more slower (even 300% slower) then version 7.4.x. and that's why 7.4.x is necessary.
Postgres configuration:
connection 50
shared_buffers 1000
In FreeBSD kernel i've increased SEMMNS and SEMMNI parameters
Can anyone help me, and tell me where is the source of problem: postgres or FreeBSD or both?
Thanks in advance.
Adam Kempa
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adam Kempa <janus(at)vtrip(dot)pl> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: postgres crashes |
| Date: | 2004-05-20 18:10:59 |
| Message-ID: | 3269.1085076659@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Adam Kempa <janus(at)vtrip(dot)pl> writes:
> I've been installed Postgres 7.4.2 on FreeBSD system and when load
> average grow up i've error in postgres like this:
> ERROR: permission denied for function varchar
> ERROR: permission denied for function varchar
> and then postgres crashes.
> LOG: server process (PID 9787) was terminated by signal 11
I think you've got hardware problems. Specifically, this sounds like it
could be bad RAM in an address range that doesn't get used until the
system gets sufficiently loaded. memtest86 is a widely-recommended test
program for finding bad RAM ...
regards, tom lane