Re: [GENERAL] InitDB: Bad system call

2010-08-16 Thread Torsten Zühlsdorff
Hello, ... The simplest explanation I can think of is that it's *only* shmctl that is malfunctioning, not the other SysV shared memory calls. Which is even weirder, and definitely seems to move the problem into the category of kernel bug rather than configuration mistake. Hmmm ... Google turn

Re: [GENERAL] InitDB: Bad system call

2010-08-15 Thread Tom Lane
I wrote: > ... The simplest explanation > I can think of is that it's *only* shmctl that is malfunctioning, not > the other SysV shared memory calls. Which is even weirder, and > definitely seems to move the problem into the category of kernel bug > rather than configuration mistake. Hmmm ... Goo

Re: [GENERAL] InitDB: Bad system call

2010-08-15 Thread Torsten Zühlsdorff
Hello, Well, this seems to be clear proof for what everyone suspected all along: your kernel is rejecting SysV-shared-memory calls. I'm too tired to go check that that shmctl() is the first such syscall during the boot sequence, but it looks about right. So we're now back to the question of *w

Re: [GENERAL] InitDB: Bad system call

2010-08-15 Thread Tom Lane
=?ISO-8859-1?Q?Torsten_Z=FChlsdorff?= writes: > The problems are known and i already have taken care of it. As written > at the beginning i already have two jails at the server with running > postgresql-instances. > Normally you have to tweak up the IPC-Params and use different user-ids > for e

Re: [GENERAL] InitDB: Bad system call

2010-08-15 Thread Torsten Zühlsdorff
Alban Hertroys schrieb: Core was generated by `postgres'. Program terminated with signal 12, Bad system call. Reading symbols from /lib/libm.so.5...done. Loaded symbols for /lib/libm.so.5 Reading symbols from /lib/libc.so.7...done. Loaded symbols for /lib/libc.so.7 Reading symbols from /libexe

Re: [GENERAL] InitDB: Bad system call

2010-08-15 Thread Alban Hertroys
On 15 Aug 2010, at 7:32, Tom Lane wrote: > =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: >> Core was generated by `postgres'. >> Program terminated with signal 12, Bad system call. >> Reading symbols from /lib/libm.so.5...done. >> Loaded symbols for /lib/libm.so.5 >> Reading symbols from /lib/li

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Glen Barber
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 8/15/10 1:32 AM, Tom Lane wrote: > > Well, this seems to be clear proof for what everyone suspected all > along: your kernel is rejecting SysV-shared-memory calls. I'm too tired > to go check that that shmctl() is the first such syscall during the

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > Core was generated by `postgres'. > Program terminated with signal 12, Bad system call. > Reading symbols from /lib/libm.so.5...done. > Loaded symbols for /lib/libm.so.5 > Reading symbols from /lib/libc.so.7...done. > Loaded symbols for /lib/libc.so

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Torsten Zühlsdorff
Tom Lane schrieb: Hm... /path/to/postgres? Not initdb? Yes; it's postgres that is failing, not initdb. Ok. But regardless what i use, it looks like: #0 0x000800bb166c in ?? () #1 0x005b158f in ?? () ... I believe that is not very helpful, is it? Nope, it's not. Could you

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > Hm... /path/to/postgres? Not initdb? Yes; it's postgres that is failing, not initdb. > But regardless what i use, it looks > like: > #0 0x000800bb166c in ?? () > #1 0x005b158f in ?? () > ... > I believe that is not very helpful, is

Re: [GENERAL] InitDB: Bad system call

2010-08-14 Thread Torsten Zühlsdorff
Tom Lane schrieb: =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: It's the same like before, but this time with core-file! :) I don't know why, but now there is one. You can find it here: http://www.dddbl.de/postgres.core (2,4 MB) That's good, but the core file is pretty much useless to anyon

Re: [GENERAL] InitDB: Bad system call

2010-08-13 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > It's the same like before, but this time with core-file! :) I don't know > why, but now there is one. You can find it here: > http://www.dddbl.de/postgres.core (2,4 MB) That's good, but the core file is pretty much useless to anyone else. Please g

Re: [GENERAL] InitDB: Bad system call

2010-08-13 Thread Torsten Zühlsdorff
Hello Tom, How annoying :-(. I think what you need to do is use truss or strace or local equivalent with the follow-forks flag, so that you can see what the stand-alone backend process does, not just initdb itself. Ok, next round. I just have truss as an option, because strace didn't work at

Re: [GENERAL] InitDB: Bad system call

2010-08-13 Thread Torsten Zühlsdorff
Hi Glen, How annoying :-(. I think what you need to do is use truss or strace or local equivalent with the follow-forks flag, so that you can see what the stand-alone backend process does, not just initdb itself. Ok, next round. I just have truss as an option, because strace didn't work at my

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Glen Barber
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 8/12/10 11:23 AM, Tom Lane wrote: > =?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: >>> How annoying :-(. I think what you need to do is use truss or strace >>> or local equivalent with the follow-forks flag, so that you can see what >>> the stand-

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Alban Hertroys
On 12 Aug 2010, at 16:04, Torsten Zühlsdorff wrote: > Ok, next round. I just have truss as an option, because strace didn't work at > my AMD64. Hope its helpfull: I haven't used it yet, but I've heard good things about DTrace, which is apparently in base these days. Alban Hertroys -- Screwin

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: >> How annoying :-(. I think what you need to do is use truss or strace >> or local equivalent with the follow-forks flag, so that you can see what >> the stand-alone backend process does, not just initdb itself. > Ok, next round. I just have truss

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Torsten Zühlsdorff
Hi Tom, Please notice, that after changing the IPC-Settings of the system, no core-file is dumped anymore. Quiet interessting. How annoying :-(. I think what you need to do is use truss or strace or local equivalent with the follow-forks flag, so that you can see what the stand-alone backend

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Tom Lane
=?ISO-8859-15?Q?Torsten_Z=FChlsdorff?= writes: > Please notice, that after changing the IPC-Settings of the system, no > core-file is dumped anymore. Quiet interessting. How annoying :-(. I think what you need to do is use truss or strace or local equivalent with the follow-forks flag, so that

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Torsten Zühlsdorff
Hello, Excerpts from Torsten ZÌhlsdorff's message of mié ago 11 02:52:34 -0400 2010: Bad system call (core dumped) I think you should try harder to generate the core file. Maybe you have too low an "ulimit -c" setting? The kernel message indicates that core *is* being dumped. Possibly

Re: [GENERAL] InitDB: Bad system call

2010-08-12 Thread Torsten Zühlsdorff
Hello, The first suspicious i can see are a lots of "ERR#32 'Broken pipe'" entries. This is the result of postgres crashing and thus initdb being unable to write any more data to it. I think you should try harder to generate the core file. Maybe you have too low an "ulimit -c" setting? The

Re: [GENERAL] InitDB: Bad system call

2010-08-11 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Torsten Zühlsdorff's message of mié ago 11 02:52:34 -0400 > 2010: Bad system call (core dumped) > I think you should try harder to generate the core file. Maybe you have > too low an "ulimit -c" setting? The kernel message indicates that core *is*

Re: [GENERAL] InitDB: Bad system call

2010-08-11 Thread Alvaro Herrera
Excerpts from Torsten Zühlsdorff's message of mié ago 11 02:52:34 -0400 2010: > Hi Tom, > > >>> Bad system call (core dumped) > > > >> Have you tried running the initdb with strace or truss? That might give > >> you a clue as to exactly what system call is failing. Your jail isn't > >> allowi

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Torsten Zühlsdorff
Hi Tom, Bad system call (core dumped) Have you tried running the initdb with strace or truss? That might give you a clue as to exactly what system call is failing. Your jail isn't allowing something fundamental here, but it's hard to guess what. Or even easier, gdb the core file ... As

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Tom Lane
Greg Smith writes: > Torsten Zühlsdorff wrote: >> Bad system call (core dumped) > Have you tried running the initdb with strace or truss? That might give > you a clue as to exactly what system call is failing. Your jail isn't > allowing something fundamental here, but it's hard to guess what.

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Greg Smith
Torsten Zühlsdorff wrote: selecting default max_connections ... Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) 10 selecting default shared_buffers ... Bad system ca

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Torsten Zühlsdorff
Reko Turja schrieb: i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. Is the machine really running a pre-RELENG 7.0? As far as i now, we used the 7.0 versions some month after their release. So: no. Wh

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Reko Turja
Torsten Zühlsdorff schrieb: i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. Is the machine really running a pre-RELENG 7.0? But when i call the initdb, i get "Bad System Call" messages. Here is the out

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Torsten Zühlsdorff
Torsten Zühlsdorff schrieb: i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. But when i call the initdb, i get "Bad System Call" messages. Here is the output: $ /usr/local/pgsql/bin/initdb -D /usr/local

Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Torsten Zühlsdorff
Hello Thom, See http://www.postgresql.org/docs/9.0/static/kernel-resources.html and the section under NetBSD/OpenBSD. I already know the FreeBSD section. My current values are: kern.ipc.shmall: 131072 kern.ipc.shmmax: 2684225436 kern.ipc.semmap: 4096 kern.ipc.semmnu: 512 kern.ipc.semmns: 102

Re: [GENERAL] InitDB: Bad system call

2010-08-09 Thread Thom Brown
On 9 August 2010 13:56, Amitabh Kant wrote: > On Mon, Aug 9, 2010 at 6:01 PM, Thom Brown wrote: >> >> See http://www.postgresql.org/docs/9.0/static/kernel-resources.html >> and the section under NetBSD/OpenBSD. >> >> -- >> Thom Brown >> Registered Linux user: #516935 >> > > Thom > > Not sure if i

Re: [GENERAL] InitDB: Bad system call

2010-08-09 Thread Amitabh Kant
On Mon, Aug 9, 2010 at 6:01 PM, Thom Brown wrote: > > See http://www.postgresql.org/docs/9.0/static/kernel-resources.html > and the section under NetBSD/OpenBSD. > > -- > Thom Brown > Registered Linux user: #516935 > > Thom Not sure if it's a typo, but shouldn't he be looking under FreeBSD secti

Re: [GENERAL] InitDB: Bad system call

2010-08-09 Thread Thom Brown
On 9 August 2010 12:56, Torsten Zühlsdorff wrote: > Hello, > > i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to > get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. > > But when i call the initdb, i get "Bad System Call" messages. Here is the > output: > > $ /

[GENERAL] InitDB: Bad system call

2010-08-09 Thread Torsten Zühlsdorff
Hello, i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. But when i call the initdb, i get "Bad System Call" messages. Here is the output: $ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -d Runnin