Exit code -1073741819

From: Carlos Henrique Reimer <carlos(dot)reimer(at)opendb(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Exit code -1073741819
Date: 2013-07-31 01:11:38
Message-ID: CAJnnue1CnFR24B1Wo49H38J2=ZMPbg1vZ0Xt_zLUHJ-qPxAD8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have a Windows box running Windows Server 2003 Enterprise Edition Service
Pack 2 with PostgreSQL 8.2.23 and getting a server crash while trying to
select a table:

select * from "TOTALL.tt_est" where assina=' kdkd' ;

Dumping the table with pg_dump or creating indexes in this table produce
the same error.

2013-07-30 21:35:47 LOG: server process (PID 2004) exited with exit code
-1073741819

2013-07-30 21:35:47 LOG: terminating any other active server processes

2013-07-30 21:35:47 WARNING: terminating connection because of crash of
another server process

2013-07-30 21:35:47 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.

2013-07-30 21:35:47 HINT: In a moment you should be able to reconnect to
the database and repeat your command.

2013-07-30 21:35:47 WARNING: terminating connection because of crash of
another server process

2013-07-30 21:35:47 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.

2013-07-30 21:35:47 HINT: In a moment you should be able to reconnect to
the database and repeat your command.

2013-07-30 21:35:47 LOG: all server processes terminated; reinitializing

2013-07-30 21:35:47 LOG: database system was interrupted at 2013-07-30
21:31:34

2013-07-30 21:35:47 LOG: checkpoint record is at 48/635B7158

2013-07-30 21:35:47 LOG: redo record is at 48/635B7158; undo record is at
0/0; shutdown TRUE

2013-07-30 21:35:47 LOG: next transaction ID: 0/14207015; next OID:
13153513

2013-07-30 21:35:47 LOG: next MultiXactId: 1714; next MultiXactOffset: 3455

2013-07-30 21:35:47 LOG: database system was not properly shut down;
automatic recovery in progress

2013-07-30 21:35:47 LOG: record with zero length at 48/635B71A8

2013-07-30 21:35:47 LOG: redo is not required

2013-07-30 21:35:47 LOG: database system is ready

CREATE TABLE "TOTALL".tt_est
(
codfil character(3) NOT NULL,
sequen character(10) NOT NULL,
filmat character(3) NOT NULL,
codmat character(5) NOT NULL,
codcor numeric(5) NOT NULL,
codtam numeric(5) NOT NULL,
qtdest numeric(12,4) NOT NULL,
coduid numeric,
assina character varying(256),
CONSTRAINT pk_est PRIMARY KEY (codfil, sequen),
CONSTRAINT fk_est_dfil FOREIGN KEY (codfil)
REFERENCES "TOTALL".td_fil (codfil) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_est_gra FOREIGN KEY (filmat, codmat, codcor, codtam)
REFERENCES "TOTALL".tt_gra (filmat, codmat, codcor, codtam) MATCH
SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;

Is there anything we could try to fix this?

Thank you in advance!

--
Reimer

Browse pgsql-admin by date

  From Date Subject
Next Message Samrat Revagade 2013-07-31 07:00:38 Re: Restore after using pg_dumpall
Previous Message CS DBA 2013-07-30 23:19:48 db crash, streaming rep slave will not start