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
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 |