Skip site navigation (1) Skip section navigation (2)

Some odd postgres errors.

From: Adam Bultman <adamb(at)iconideas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Some odd postgres errors.
Date: 2003-01-29 19:30:14
Message-ID: 1043868644.2050.16.camel@perry (view raw or flat)
Thread:
Lists: pgsql-novice
Greetings, everyone.  

I've got a Postgres system version 7.1-1 on RH 6.2 here, and I'm getting
a whole host of errors.

There is an import program that runs daily from a group of CSV files
uploaded to a server.  Since monday, it's been having problems, and I
can't find anything in the import files. Here are some of the errors
below. Some are obvious (invalid float, etC) but the 'bits moved right
off the end of the world' is worrisome, as is Invalid XID in t_cmin..  

I've got myself and three others hunting down reasons, but to no avail
yet. We are debating upgrading postgres, although that worries us to, as
this is a production system.

Help ?

Jan 26 05:04:26 web postgres[26288]: [129-2] ^IRecreate the index.
Jan 26 05:04:26 web postgres[26288]: [130] ERROR:  Invalid XID in t_cmin
(2)
Jan 27 01:45:20 web postgres[26368]: [285-1] FATAL 1:  _bt_restscan: my
bits moved right off the end of the world!

Jan 27 10:17:48 web postgres[7450]: [55] FATAL 1:  This connection has
been terminated by the administrator.
Jan 27 11:05:07 web postgres[11401]: [23] ERROR:  Memory exhausted in
AllocSetAlloc(842608949Jan 27 15:18:18 web postgres[20059]: [65] ERROR: 
Bad float8 input format '3536.34.0000')





-- 

Adam Bultman
adam(dot)bultman(at)iconideas(dot)com
616-836-7213
http://www.iconideas.com


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2003-01-29 19:53:17
Subject: Re: Some odd postgres errors.
Previous:From: eurlixDate: 2003-01-29 19:16:46
Subject: Re: DB corrupted repaired

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group