PHP/Postgres dieing in random but consistent place.

From: "Zot O'Connor" <zot(at)zotconsulting(dot)com>
To: php-pgsql(at)linuxports(dot)com, postgres sql <pgsql-sql(at)hub(dot)org>, plug list <plug(at)Northwest(dot)com>
Subject: PHP/Postgres dieing in random but consistent place.
Date: 1999-12-02 20:18:42
Message-ID: 3846D422.6B2E6CDB@zotconsulting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am running fischat (www.fishcartsql.org).

The site works great but on order crashes the system.

The call is under SSL under Apache using php

Server: Red Hat Secure/2.0 (Unix) PHP/3.0.8 mod_ssl/2.0.7 SSLeay/0.9.0b

The script will just die in the midst of a table line. If I up the
error_reporting, it dies further down the road.

I tried makeing safe mode bigger (90s, 10M) but the script takes like .3
seconds to run.

It shows the same results under s_client.

After running Vaccum Analyze it moved the place it fails.

Postgres logs show no errors, apache shows no errors, php shows no
errors.

Its like somehting just comes and whomps the order.

Orders are processing just fine in the system.

There are no funky chars in the items that I can see.

The page is not big (3000 chars where it stops).

Any ideas?

--
Zot O'Connor

www.ZotConsulting.com
www.WhiteKnightHackers.com

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Techoueyres 1999-12-02 20:51:51 A search SQL query
Previous Message Mark Dalphin 1999-12-02 19:30:27 How to avoid "Out of memory" using aggregate functions?