pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql-9.0 Windows service stops after database transaction
6+ messages / 3 participants
[nested] [flat]
* postgresql-9.0 Windows service stops after database transaction
@ 2010-09-24 04:39 adrian.kitchingman@dse.vic.gov.au
0 siblings, 1 reply; 6+ messages in thread
From: adrian.kitchingman@dse.vic.gov.au @ 2010-09-24 04:39 UTC (permalink / raw)
To: pgsql-performance
Hi all
I've have a strange problem with my Windows postgresql-9.0 service
stopping after any transaction which manipulates tables in any database
(Deleting records, Inserting records, bulk importing via \copy, etc). This
problem occurs regardless whether I'm accessing the database server via
pgAdmin III on a client machine or the server itself as well as through
the command prompt. The end result it that I have to constantly restart
the postgresql service after any transactions. Sometime there is a slight
delay allowing a couple of transactions but the service is always
eventually stopped.
The problem appears to have started when I changed permissions on my
machine to allow the user 'postgres' access to the C drive following the
instructions in the last post of this thread:
http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
The specs of postres environment are:
Windows XP SP3
PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
PostGIS 2.0SVN
Hope someone can shed some light on this issue.
Cheers
Adrian
Notice:
This email and any attachments may contain information that is personal,
confidential, legally privileged and/or copyright.No part of it should be reproduced,
adapted or communicated without the prior written consent of the copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete
it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information
contained in this email.
Please consider the environment before printing this email.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql-9.0 Windows service stops after database transaction
@ 2010-09-24 07:05 Thom Brown <thom@linux.com>
parent: adrian.kitchingman@dse.vic.gov.au
0 siblings, 2 replies; 6+ messages in thread
From: Thom Brown @ 2010-09-24 07:05 UTC (permalink / raw)
To: adrian.kitchingman@dse.vic.gov.au; +Cc: pgsql-performance
On 24 September 2010 05:39, <adrian.kitchingman@dse.vic.gov.au> wrote:
> Hi all
>
> I've have a strange problem with my Windows postgresql-9.0 service stopping
> after any transaction which manipulates tables in any database (Deleting
> records, Inserting records, bulk importing via \copy, etc). This problem
> occurs regardless whether I'm accessing the database server via pgAdmin III
> on a client machine or the server itself as well as through the command
> prompt. The end result it that I have to constantly restart the postgresql
> service after any transactions. Sometime there is a slight delay allowing a
> couple of transactions but the service is always eventually stopped.
>
> The problem appears to have started when I changed permissions on my machine
> to allow the user 'postgres' access to the C drive following the
> instructions in the last post of this thread:
> http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
>
> The specs of postres environment are:
>
> Windows XP SP3
> PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
> pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
> PostGIS 2.0SVN
>
> Hope someone can shed some light on this issue.
What appears in the logs?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql-9.0 Windows service stops after database transaction
@ 2010-09-26 23:18 adrian.kitchingman@dse.vic.gov.au
parent: Thom Brown <thom@linux.com>
1 sibling, 0 replies; 6+ messages in thread
From: adrian.kitchingman@dse.vic.gov.au @ 2010-09-26 23:18 UTC (permalink / raw)
To: Thom Brown <thom@linux.com>; +Cc: pgsql-performance
Hi Thom
Thanks for the reply and the log seems to have shed some light. Looks like
I have my old postgres 8.3 service still running concurrently which is
interfering with the new 9.0 service. This is the message that comes up a
lot in the log.
2010-09-24 15:39:34 EST LOG: unexpected EOF on client connection
2010-09-24 15:39:37 EST LOG: unexpected EOF on client connection
2010-09-24 15:39:37 EST LOG: unexpected EOF on client connection
2010-09-24 15:40:07 EST LOG: server process (PID 3724) was terminated by
exception 0xC0000005
2010-09-24 15:40:07 EST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2010-09-24 15:40:07 EST LOG: terminating any other active server
processes
2010-09-24 15:40:07 EST WARNING: terminating connection because of crash
of another server process
2010-09-24 15:40:07 EST 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.
2010-09-24 15:40:07 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
It's a bit strange though because I did do an uninstall of the postgres
8.3 before installing the 9.0. The 8.3 service is still present in Windows
Services but I've disabled with with no effect on the problem. I notice it
still is also listed as a separate server in pgAdmin but when it's
activated it refers to the 9.0 databases. I'm guessing that I have to do a
deeper uninstall of the 8.3 service. Do you have any pointers on how to go
about this?
Cheers
Adrian
From: Thom Brown <thom@linux.com>
To: adrian.kitchingman@dse.vic.gov.au
Cc: pgsql-performance@postgresql.org
Date: 24/09/2010 05:05 PM
Subject: Re: [PERFORM] postgresql-9.0 Windows service stops after
database transaction
On 24 September 2010 05:39, <adrian.kitchingman@dse.vic.gov.au> wrote:
> Hi all
>
> I've have a strange problem with my Windows postgresql-9.0 service
stopping
> after any transaction which manipulates tables in any database (Deleting
> records, Inserting records, bulk importing via \copy, etc). This problem
> occurs regardless whether I'm accessing the database server via pgAdmin
III
> on a client machine or the server itself as well as through the command
> prompt. The end result it that I have to constantly restart the
postgresql
> service after any transactions. Sometime there is a slight delay
allowing a
> couple of transactions but the service is always eventually stopped.
>
> The problem appears to have started when I changed permissions on my
machine
> to allow the user 'postgres' access to the C drive following the
> instructions in the last post of this thread:
> http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
>
> The specs of postres environment are:
>
> Windows XP SP3
> PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
> pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
> PostGIS 2.0SVN
>
> Hope someone can shed some light on this issue.
What appears in the logs?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Notice:
This email and any attachments may contain information that is personal,
confidential, legally privileged and/or copyright.No part of it should be reproduced,
adapted or communicated without the prior written consent of the copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete
it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information
contained in this email.
Please consider the environment before printing this email.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql-9.0 Windows service stops after database transaction
@ 2010-09-27 00:06 adrian.kitchingman@dse.vic.gov.au
parent: Thom Brown <thom@linux.com>
1 sibling, 1 reply; 6+ messages in thread
From: adrian.kitchingman@dse.vic.gov.au @ 2010-09-27 00:06 UTC (permalink / raw)
To: Thom Brown <thom@linux.com>; +Cc: pgsql-performance
Hi again Thom
Just a quick update regarding my previous reply to you. I managed to do a
deeper uninstall of Postgresql 8.3 with these following steps.
* Remove the Registry entries.
(HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.3) and
(HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\postgresql-8.3)
* Remove the postgresql-8.3 service. (sc delete postgresql-8.3)
This didn't fix the problem although the 8.3 service is now no longer
present in Windows Services nor in pgAdmin. Below is the complete log
output when the original error occurs and the 9.0 service is shut down.
All I did was delete the content of a table and this is what happens.
2010-09-27 09:52:48 EST LOG: unexpected EOF on client connection
2010-09-27 09:53:05 EST LOG: unexpected EOF on client connection
2010-09-27 09:53:19 EST LOG: server process (PID 2564) was terminated by
exception 0xC0000005
2010-09-27 09:53:19 EST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2010-09-27 09:53:19 EST LOG: terminating any other active server
processes
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash
of another server process
2010-09-27 09:53:19 EST 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.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash
of another server process
2010-09-27 09:53:19 EST 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.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2010-09-27 09:53:19 EST WARNING: terminating connection because of crash
of another server process
2010-09-27 09:53:19 EST 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.
2010-09-27 09:53:19 EST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2010-09-27 09:53:19 EST LOG: all server processes terminated;
reinitializing
2010-09-27 09:53:29 EST FATAL: pre-existing shared memory block is still
in use
2010-09-27 09:53:29 EST HINT: Check if there are any old server processes
still running, and terminate them.
Thanks again.
Cheers
Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Adrian Kitchingman, Aquatic Spatial Scientist | Arthur Rylah Institute,
Dept of Sustainability and Environment
123 Brown St, Heidelberg, Victoria, Australia, 3084 | ph: + (03) 9450 8716
| fax: + (03) 9450 8799
~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <°)))><
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: Thom Brown <thom@linux.com>
To: adrian.kitchingman@dse.vic.gov.au
Cc: pgsql-performance@postgresql.org
Date: 24/09/2010 05:05 PM
Subject: Re: [PERFORM] postgresql-9.0 Windows service stops after
database transaction
On 24 September 2010 05:39, <adrian.kitchingman@dse.vic.gov.au> wrote:
> Hi all
>
> I've have a strange problem with my Windows postgresql-9.0 service
stopping
> after any transaction which manipulates tables in any database (Deleting
> records, Inserting records, bulk importing via \copy, etc). This problem
> occurs regardless whether I'm accessing the database server via pgAdmin
III
> on a client machine or the server itself as well as through the command
> prompt. The end result it that I have to constantly restart the
postgresql
> service after any transactions. Sometime there is a slight delay
allowing a
> couple of transactions but the service is always eventually stopped.
>
> The problem appears to have started when I changed permissions on my
machine
> to allow the user 'postgres' access to the C drive following the
> instructions in the last post of this thread:
> http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
>
> The specs of postres environment are:
>
> Windows XP SP3
> PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
> pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
> PostGIS 2.0SVN
>
> Hope someone can shed some light on this issue.
What appears in the logs?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Notice:
This email and any attachments may contain information that is personal,
confidential, legally privileged and/or copyright.No part of it should be reproduced,
adapted or communicated without the prior written consent of the copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete
it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information
contained in this email.
Please consider the environment before printing this email.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql-9.0 Windows service stops after database transaction
@ 2010-09-28 09:11 Craig Ringer <craig@postnewspapers.com.au>
parent: adrian.kitchingman@dse.vic.gov.au
0 siblings, 1 reply; 6+ messages in thread
From: Craig Ringer @ 2010-09-28 09:11 UTC (permalink / raw)
To: adrian.kitchingman@dse.vic.gov.au; +Cc: Thom Brown <thom@linux.com>; pgsql-performance
On 27/09/10 08:06, adrian.kitchingman@dse.vic.gov.au wrote:
>
> /2010-09-27 09:53:19 EST LOG: server process (PID 2564) was terminated
> by exception 0xC0000005/
> /2010-09-27 09:53:19 EST HINT: See C include file "ntstatus.h" for a
> description of the hexadecimal value./
That's an access violation - in UNIX land, a segmentation fault, signal
11. A plain 'ol crash of a backend.
It'd be really nice to have some information about how it crashed. It'd
be ideal if you could make a .sql file that, when run on a newly created
database, creates a table and manipulates it in a way that causes the
backend to crash. Please do not add PostGIS to the test database. If you
cannot make it crash without PostGIS in the mix, that tells us something.
If you can make it crash without PostGIS, please post the .sql file that
creates the table(s) and runs the command that crashes the server.
If you have to add PostGIS to make it crash, it might be best to talk to
the PostGIS folks about the problem.
In either case, to make things even better you could collect some crash
information that may help diagnose where in PostgreSQL the crash occurs.
See:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
By the way: You don't have the old 8.3 data directory on the system PATH
do you? You can check the value of the system path in the System control
panel, though exactly where varies from Windows version to Windows version.
--
Craig Ringer
Tech-related writing: http://soapyfrogs.blogspot.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql-9.0 Windows service stops after database transaction
@ 2010-09-30 06:00 adrian.kitchingman@dse.vic.gov.au
parent: Craig Ringer <craig@postnewspapers.com.au>
0 siblings, 0 replies; 6+ messages in thread
From: adrian.kitchingman@dse.vic.gov.au @ 2010-09-30 06:00 UTC (permalink / raw)
To: Craig Ringer <craig@postnewspapers.com.au>; pgsql-performance
Hi all
Looks like Craig is right in suspecting that the PostGIS installation was
causing the problem. I did a full reinstall of Postgres and ran it without
PostGIS with no problems. For those interested, the bug has been noted on
the PostGIS bugs list but yet to have a fix.
http://trac.osgeo.org/postgis/ticket/518
Thanks for the help.
Cheers
Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Adrian Kitchingman, Aquatic Spatial Scientist | Arthur Rylah Institute,
Dept of Sustainability and Environment
123 Brown St, Heidelberg, Victoria, Australia, 3084 | ph: + (03) 9450 8716
| fax: + (03) 9450 8799
~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <°)))><
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Notice:
This email and any attachments may contain information that is personal,
confidential, legally privileged and/or copyright.No part of it should be reproduced,
adapted or communicated without the prior written consent of the copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete
it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information
contained in this email.
Please consider the environment before printing this email.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-09-30 06:00 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-24 04:39 postgresql-9.0 Windows service stops after database transaction adrian.kitchingman@dse.vic.gov.au
2010-09-24 07:05 ` Thom Brown <thom@linux.com>
2010-09-26 23:18 ` adrian.kitchingman@dse.vic.gov.au
2010-09-27 00:06 ` adrian.kitchingman@dse.vic.gov.au
2010-09-28 09:11 ` Craig Ringer <craig@postnewspapers.com.au>
2010-09-30 06:00 ` adrian.kitchingman@dse.vic.gov.au
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