Strange behaviour: create database hangs (v 8.4.4)

Hello

When running the command 'create database test' as user postgres from
within psql, the command hangs indefinitely.

I've installed 8.4.4 from source on a Slackware 13.0 box with kernel
2.6.29, GCC 4.3.3 and OpenSSL 0.9.8n with self-signed certificates.

Built with ./configure --prefix=/opt/postgresql-8.4.4 --with-openssl

Running under daemontools as follows:

setuidgid postgres postgres -i -p 8910 -l -d /srv/data/postgresql 2>&1

psql run as postgres user as follows:

psql -p 8910

There is no indication in the logfiles of errors.

Any possible reasons why this may occur? What can I do to investigate
this further?

Thanks
Dale

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Strange behaviour: create database hangs (v 8.4.4)

On 31 May 2010 12:50, Dale Gallagher wrote:
> When running the command 'create database test' as user postgres from
> within psql, the command hangs indefinitely.

I am now using strace on postgres startup and watching the filesystem
during the creation of the database. So far, it seems that files in
PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
7 minutes and 92 files have been created. The command has not
completed within psql....

Could this be a filesystem corruption issue? The host is using ext4.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Strange behaviour: create database hangs (v 8.4.4)

On 31 May 2010 13:10, Dale Gallagher wrote:
> I am now using strace on postgres startup and watching the filesystem
> during the creation of the database. So far, it seems that files in
> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
> 7 minutes and 92 files have been created. The command has not
> completed within psql....
>
> Could this be a filesystem corruption issue? The host is using ext4.

The command finally completed. It took a VERY long time. Something is
wrong, but I have no clue what.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Strange behaviour: create database hangs (v 8.4.4)

Maybe "test" is a reserved word.=20

Try test1.
________________________________________
From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] o=
n behalf of Dale Gallagher [dale.gallagher@gmail.com]
Sent: Monday, May 31, 2010 3:50 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Strange behaviour: create database hangs (v 8.4.4)

Hello

When running the command 'create database test' as user postgres from
within psql, the command hangs indefinitely.

I've installed 8.4.4 from source on a Slackware 13.0 box with kernel
2.6.29, GCC 4.3.3 and OpenSSL 0.9.8n with self-signed certificates.

Built with ./configure --prefix=3D/opt/postgresql-8.4.4 --with-openssl

Running under daemontools as follows:

setuidgid postgres postgres -i -p 8910 -l -d /srv/data/postgresql 2>&1

psql run as postgres user as follows:

psql -p 8910

There is no indication in the logfiles of errors.

Any possible reasons why this may occur? What can I do to investigate
this further?

Thanks
Dale

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Strange behaviour: create database hangs (v 8.4.4)

Dale Gallagher writes:
> On 31 May 2010 13:10, Dale Gallagher wrote:
>> I am now using strace on postgres startup and watching the filesystem
>> during the creation of the database. So far, it seems that files in
>> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
>> 7 minutes and 92 files have been created. The command has not
>> completed within psql....
>>
>> Could this be a filesystem corruption issue? The host is using ext4.

> The command finally completed. It took a VERY long time. Something is
> wrong, but I have no clue what.

Seems like you must have a kernel/filesystem issue, but I don't know
what either. CREATE DATABASE just copies the contents of template1
using some absolutely straightforward code (look into src/port/copydir.c)
so it's entirely filesystem-limited.

You could try tracing the backend that's doing the command with
"strace -r -p " to try to get an idea of which system calls
are eating all the time.

regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Strange behaviour: create database hangs (v 8.4.4)

unregister

On Mon, May 31, 2010 at 9:59 AM, Tom Lane wrote:
> Dale Gallagher writes:
>> On 31 May 2010 13:10, Dale Gallagher wrote:
>>> I am now using strace on postgres startup and watching the filesystem
>>> during the creation of the database. So far, it seems that files in
>>> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
>>> 7 minutes and 92 files have been created. The command has not
>>> completed within psql....
>>>
>>> Could this be a filesystem corruption issue? The host is using ext4.
>
>> The command finally completed. It took a VERY long time. Something is
>> wrong, but I have no clue what.
>
> Seems like you must have a kernel/filesystem issue, but I don't know
> what either. =A0CREATE DATABASE just copies the contents of template1
> using some absolutely straightforward code (look into src/port/copydir.c)
> so it's entirely filesystem-limited.
>
> You could try tracing the backend that's doing the command with
> "strace -r -p " to try to get an idea of which system calls
> are eating all the time.
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Strange behaviour: create database hangs (v 8.4.4)

On 31 May 2010 18:59, Tom Lane wrote:
> Seems like you must have a kernel/filesystem issue, but I don't know
> what either. =A0CREATE DATABASE just copies the contents of template1
> using some absolutely straightforward code (look into src/port/copydir.c)
> so it's entirely filesystem-limited.

Thanks Tom. I've confirmed that it's not related to PostgreSQL, as
installing this version on another system has zero issues. I've posted
the issue to a Slackware specific forum:

http://www.linuxquestions.org/questions/slackware-14/slackwa re-13-sluggish-=
system-possibly-filesystem-811442/

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin