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