Postgres 6.5.1 Error

From: Robert Hiltibidal <rob(at)y2k(dot)state(dot)il(dot)us>
To: pgsql-interfaces(at)postgreSQL(dot)org
Cc: James_Jorgensen(at)cms(dot)state(dot)il(dot)us, Don_Kupferschmid(at)cms(dot)state(dot)il(dot)us
Subject: Postgres 6.5.1 Error
Date: 1999-12-03 14:57:22
Message-ID: 3.0.6.32.19991203085722.00969850@y2k.state.il.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Morning,

Our Crossover project seems to have presented another test production error.

Last I wrote was how does one get data from one database to another from
within Postgres.

This time I have data that is actually causing postgres to go into a
cascade failure that actually takes down the server.

What we did was take data from an Access97 application. We exported the
tables to a postgres database. We have done this for another Access97
application and have had no probles with it.

During testing and development of a web application everything worked ok.

When we went into beta test we had one agency that when ever they accessed
their data it would cause postgres to go into a cascade failure and take
the server down. IF I can catch it in time I can kill the process.

Tech Specs:

Hardware- PII 300 with 128 mg ram
6 gig ide hard drive
2 gig ide hard drive

Software- Apache 1.3.6 Web server
PostgreSQL 6.5.1
Linux 2.2.6
FPK Pascal 0.99.12

FPK pascal uses the libpq library created by the PostgreSQL distribution. I
can also achieve the same results with perl.

Unfortunately, since this is a state agency, I cannot release the full
records. I can say there appears to be control characters in the data.
Specifically 5, 8, and 9. These appear to be unicode characters.

I need to do one of the following:

a> filter the data
b> determine if this was a malicious act or an accident
c> prevent the server from crashing
d> find out if this only affects one agency or if there are others we
haven't encountered yet.

Thanks,

-Rob

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-12-03 15:35:39 Re: [INTERFACES] Postgres 6.5.1 Error
Previous Message Oscar Serrano 1999-12-03 14:44:01 RE: [INTERFACES] Spanish format on date and numbers