[ic] checkout selection fails

James P. Kinney III interchange-users@icdevgroup.org
Sat Dec 21 18:43:00 2002


--=-pn4a1lSErs/pQu7iFF0f
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Interchange 4.8.6. Postgresql 7.2.1=20

I have had no problems for a while. Today, an email came in that the
customer could not access the checkout page. They weren't kidding!

The process seems to just hang. Eventually the timeouts happen and
apache returns an error to the user:=20

Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request.

apache log says:  Premature end of script headers:
/var/www/cgi-bin/foundation


ps aux shows:
postgres  5705  0.0  0.3  8132 1800 pts/1    S    18:09   0:00
/usr/bin/postmaster
postgres  5707  0.0  0.3  9124 1780 pts/1    S    18:09   0:00 postgres:
stats buffer process
postgres  5709  0.0  0.3  8156 1816 pts/1    S    18:09   0:00 postgres:
stats collector process
root      6012  0.0  0.1  1652  548 pts/1    S    18:18   0:00 tail -f
/var/log/httpd/error_log
interch   6129  0.0  3.9 25292 20484 ?       S    18:21   0:00
interchange
interch   6214  0.0  0.0  1452  388 ?        S    18:26   0:00
foundation
interch   6216  0.0  4.1 26376 21548 ?       S    18:26   0:00
interchange
postgres  6217  0.0  0.6  8844 3348 pts/1    S    18:26   0:00 postgres:
interch foundation [local] idle
root      6238  0.0  0.1  2648  720 pts/0    R    18:30   0:00 ps aux

It's the [local] idle part that seems to be the issue. Continued
interchange access spawns more interchange/foundation pair processes
with nothing getting sent back to the screen.=20

As long as no user is logged in and a visitor is just looking through
the system, it works fine.=20

I had been doing some firewall work adding a VPN to the system. But 80
and 443 are still open. I can access the admin pages which all use https
and some other https pages on the same system.

The /var/log/interchange/foundation/error.log shows:

foundation /cgi-bin/foundation/process.html Attempted database operation
without table, fields, or key.
> Table: ''
> Fields:''
> Key:   ''

So I check out the database foundation for blank tables. I have:
     Name      | Type  |  Owner
---------------+-------+---------
 affiliate     | table | interch
 area          | table | interch
 cat           | table | interch
 country       | table | interch
 gift_certs    | table | interch
 inventory     | table | interch
 merchandising | table | interch
 options       | table | interch
 order_returns | table | interch
 orderline     | table | interch
 pricing       | table | interch
 products      | table | interch
 state         | table | interch
 transactions  | table | interch
 userdb        | table | interch

Which matches my test setup. This is the real, online live system!
Yikes!

Where do I go to look for more info?   ?????

--=20
James P. Kinney III   \Changing the mobile computing world/
President and CEO      \          one Linux user         /
Local Net Solutions,LLC \           at a time.          /
770-493-8244             \.___________________________./

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics) <jkinney@localnetsoluti=
ons.com>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7=20



--=-pn4a1lSErs/pQu7iFF0f
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQA+BPw+YZCtw4KcbKcRAmptAKCqqj1YgqAAL3mhLEuA6zdtSOuFeACeJSFj
1KIBOkS+1s8xPA+SqZ+9KNE=
=sX7x
-----END PGP SIGNATURE-----

--=-pn4a1lSErs/pQu7iFF0f--