pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStrange behaviour: create database hangs (v 8.4.4)
7+ messages / 4 participants
[nested] [flat]
* Strange behaviour: create database hangs (v 8.4.4)
@ 2010-05-31 10:50 Dale Gallagher <dale.gallagher@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Dale Gallagher @ 2010-05-31 10:50 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Strange behaviour: create database hangs (v 8.4.4)
@ 2010-05-31 11:10 Dale Gallagher <dale.gallagher@gmail.com>
parent: Dale Gallagher <dale.gallagher@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Dale Gallagher @ 2010-05-31 11:10 UTC (permalink / raw)
To: pgsql-admin
On 31 May 2010 12:50, Dale Gallagher <dale.gallagher@gmail.com> 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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Strange behaviour: create database hangs (v 8.4.4)
@ 2010-05-31 11:31 Dale Gallagher <dale.gallagher@gmail.com>
parent: Dale Gallagher <dale.gallagher@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Dale Gallagher @ 2010-05-31 11:31 UTC (permalink / raw)
To: pgsql-admin
On 31 May 2010 13:10, Dale Gallagher <dale.gallagher@gmail.com> 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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Strange behaviour: create database hangs (v 8.4.4)
@ 2010-05-31 16:29 Naomi Walker <nwalke@mhs.mphasis.com>
parent: Dale Gallagher <dale.gallagher@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Naomi Walker @ 2010-05-31 16:29 UTC (permalink / raw)
To: Dale Gallagher <dale.gallagher@gmail.com>; pgsql-admin
Maybe "test" is a reserved word.
Try test1.
________________________________________
From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] on 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=/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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Strange behaviour: create database hangs (v 8.4.4)
@ 2010-05-31 16:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Dale Gallagher <dale.gallagher@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Tom Lane @ 2010-05-31 16:59 UTC (permalink / raw)
To: Dale Gallagher <dale.gallagher@gmail.com>; +Cc: pgsql-admin
Dale Gallagher <dale.gallagher@gmail.com> writes:
> On 31 May 2010 13:10, Dale Gallagher <dale.gallagher@gmail.com> 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 <pid>" to try to get an idea of which system calls
are eating all the time.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Strange behaviour: create database hangs (v 8.4.4)
@ 2010-06-01 00:50 Jeremy Tunnell <jeremy.tunnell@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Jeremy Tunnell @ 2010-06-01 00:50 UTC (permalink / raw)
To: pgsql-admin
unregister
On Mon, May 31, 2010 at 9:59 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Dale Gallagher <dale.gallagher@gmail.com> writes:
>> On 31 May 2010 13:10, Dale Gallagher <dale.gallagher@gmail.com> 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 <pid>" 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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Strange behaviour: create database hangs (v 8.4.4)
@ 2010-06-01 11:17 Dale Gallagher <dale.gallagher@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 7+ messages in thread
From: Dale Gallagher @ 2010-06-01 11:17 UTC (permalink / raw)
To: pgsql-admin
On 31 May 2010 18:59, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.
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/slackware-13-sluggish-system-possibly-filesyste...
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2010-06-01 11:17 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-31 10:50 Strange behaviour: create database hangs (v 8.4.4) Dale Gallagher <dale.gallagher@gmail.com>
2010-05-31 11:10 ` Dale Gallagher <dale.gallagher@gmail.com>
2010-05-31 11:31 ` Dale Gallagher <dale.gallagher@gmail.com>
2010-05-31 16:59 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-06-01 00:50 ` Jeremy Tunnell <jeremy.tunnell@gmail.com>
2010-06-01 11:17 ` Dale Gallagher <dale.gallagher@gmail.com>
2010-05-31 16:29 ` Naomi Walker <nwalke@mhs.mphasis.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox