Exit code -1073741819 - Mailing list pgsql-admin

From Carlos Henrique Reimer
Subject Exit code -1073741819
Date
Msg-id CAJnnue1CnFR24B1Wo49H38J2=ZMPbg1vZ0Xt_zLUHJ-qPxAD8w@mail.gmail.com
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: CS DBA
Date:
Subject: db crash, streaming rep slave will not start
Next
From: Samrat Revagade
Date:
Subject: Re: Restore after using pg_dumpall