[ic] checkout selection fails

[Caleb Phillips]

On Sat, 2002-12-21 at 15:41, James P. Kinney III wrote:
> Interchange 4.8.6. Postgresql 7.2.1 
> 
> 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: 
> 
> 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

I had this exact problem when the shipping calculation was fscked. For
example, if you use FedEx Web Lookup and blocked all outgoing
ports(particularly 80 if I remember correctly) then you would see these
symptoms as IC chews on itself.

I would go over your whole shipping calculation with a fine tooth comb.
Especially shipping.asc.

> Will ^M in the products database cause problems? A product manager did
> some cut-n-paste on a windows box so the ^M got plonked in all over.

Keep windoze people away from your databases ;P. This shouldn't break
things, but it is good practice to get rid of the ^M's.

Good Luck.

> 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. 
> 
> As long as no user is logged in and a visitor is just looking through
> the system, it works fine. 
> 
> 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?   ?????

-- 
-------------------------------------------
| Caleb Phillips                          |
| The Studio Resource                     |
| IT Specialist                           |
|                                         |
| Handcrafted for you in Ximian Evolution |
-------------------------------------------