Fw: Bug in postgresql 8.1

Started by prem tolaniabout 14 years ago4 messagesbugs
Jump to latest
#1prem tolani
premtolani@yahoo.com

Below error occurs only when i restart postgre 8.1 service when applicaion is running. Otherwise it works fine, but while application is running and i restart postgre 8.1 service. Application crashes. Please refer to below email.

Regards,
Prem

--- On Sun, 18/3/12, prem tolani <premtolani@yahoo.com> wrote:
Show quoted text

From: prem tolani <premtolani@yahoo.com>
Subject: Bug in postgresql 8.1
To: pgsql-bugs@postgresql.org
Date: Sunday, 18 March, 2012, 10:41 AM
Please refer to below mail and help,
i need urgent help.

Thanks in advance.

Regards,
Prem

I get below error message> >

PG "FATAL:� could not reattach to shared memory

(key=5432001, addr=02100000): Invalid

argument.

This messages occurs in windows 7 eventviewer log.
Application log / postgresql log do not show anything.

It is

custom application made in java. When application is

running and i restart postgresql service, the application
crashes. What could be probable reason and solution to this
?

If you need more info do let me know.

Regards,
Prem

--- On Sun, 18/3/12, Adrian Klaver <adrian.klaver@gmail.com>
wrote:

From: Adrian Klaver <adrian.klaver@gmail.com>
Subject: Re: [GENERAL] One more query
To: "prem tolani" <premtolani@yahoo.com>
Cc: pgsql-general@postgresql.org
Date: Sunday, 18 March, 2012, 2:09 AM
On 03/17/2012 12:04 AM, prem tolani
wrote:

Hi Tom,

I am using one postgresql 8.1, when my

application

in

java is running and i restart the postgresql 8.1

service, my

application crashes. Can you please tell me what

could

the

probable fix for this ? I am using windows 7(32

bit).

This

does not happen on windows xp. can u please tell

me

what

could be the probable reason for that ?

This is going to need a lot more information to

get an

answer:)

Are any error messages shown?

What is the application ?
   Is it custom or a known application?

What do the logs say?
   Postgres
   Application
   Windows

regards,
Prem

-- Adrian Klaver
adrian.klaver@gmail.com

#2Jaime Casanova
jcasanov@systemguards.com.ec
In reply to: prem tolani (#1)
Re: Fw: Bug in postgresql 8.1

On Sun, Mar 18, 2012 at 12:13 AM, prem tolani <premtolani@yahoo.com> wrote:

Below error occurs only when i restart postgre 8.1 service when applicaion is running. Otherwise it works fine, but while
application is running and i restart postgre 8.1 service. Application crashes. Please refer to below email.

postgres 8.1 is not currently supported (since November 2010,
http://www.postgresql.org/support/versioning), so is likely that if
something was done in postgres to support win7 it hasn't reach 8.1

the best "fix" you can get is to migrate to a newer supported version
as soon as possible.

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

#3Dave Page
dpage@pgadmin.org
In reply to: Jaime Casanova (#2)
Re: Bug in postgresql 8.1

On Sunday, March 18, 2012, Jaime Casanova <jaime@2ndquadrant.com> wrote:

On Sun, Mar 18, 2012 at 12:13 AM, prem tolani <premtolani@yahoo.com>

wrote:

Below error occurs only when i restart postgre 8.1 service when

applicaion is running. Otherwise it works fine, but while

application is running and i restart postgre 8.1 service. Application

crashes. Please refer to below email.

postgres 8.1 is not currently supported (since November 2010,
http://www.postgresql.org/support/versioning), so is likely that if
something was done in postgres to support win7 it hasn't reach 8.1

It hasn't been supported on Windows for *much* longer.

the best "fix" you can get is to migrate to a newer supported version
as soon as possible.

+1. Windows 7 will never be a supported platform for 8.1, even if it was
still supported in general.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

#4Jaime Casanova
jcasanov@systemguards.com.ec
In reply to: Dave Page (#3)
Re: Bug in postgresql 8.1

On Sun, Mar 18, 2012 at 8:11 AM, Dave Page <dpage@pgadmin.org> wrote:

On Sunday, March 18, 2012, Jaime Casanova <jaime@2ndquadrant.com> wrote:

On Sun, Mar 18, 2012 at 12:13 AM, prem tolani <premtolani@yahoo.com>
wrote:

Below error occurs only when i restart postgre 8.1 service when
applicaion is running. Otherwise it works fine, but while
application is running and i restart postgre 8.1 service. Application
crashes. Please refer to below email.

postgres 8.1 is not currently supported (since November 2010,
http://www.postgresql.org/support/versioning), so is likely that if
something was done in postgres to support win7 it hasn't reach 8.1

It hasn't been supported on Windows for *much* longer.

true. i forgot that, support for 8.1 on windows was dropped on 2008
with release of 8.1.11, and it was because of very serious problems.
so, not being able to start the database is the less serious of your
problems.

http://www.postgresql.org/about/news/865

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación