Ticket #724 (closed defect: worksforme)

Opened 12 years ago

Last modified 12 years ago

[WG] Fastcgi timeout errors on browse.

Reported by: lawrence Owned by: lawrence
Priority: blocker Milestone: BETA
Component: community Version:
Keywords: Cc:

Description

A real  browse case results in 500 internal server errors and timeouts on glue.

It runs ok in my sandbox using the unthreaded wsgi server.

The log file has:

bnl /db/ndg_B_metadata declare default element namespace 'http://ndg.nerc.ac.uk/moles';declare variable $targetCollection as xs:string {'/db/ndg_B_metadata'};for $Obj in collection($targetCollection)/dgMetadata/dgMetadataRecord[dgMetadataID/schemeIdentifier='NDG-B0' and dgMetadataID/repositoryIdentifier='badc.nerc.ac.uk' and dgMetadataID/localIdentifier='dataent_chablis']  return <objectType>{if (exists($Obj/dgDataEntity)) then 4 else (if (exists($Obj/dgObservationStation)) then 3 else (if (exists($Obj/dgDataProductionTool)) then 2 else (if (exists($Obj/dgActivity)) then 1 else (0))))}</objectType>
objectType=4
Render says gettable is : 0
Unhandled exception in thread started by <bound method ThreadPool._worker of <flup.server.threadpool.ThreadPool object at 0xb71071cc>>
Traceback (most recent call last):
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/threadpool.py", line 103, in _worker
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 642, in run
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 678, in process_input
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 777, in _do_params
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 761, in _start_request
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 570, in run
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 577, in _flush
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 336, in close  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 693, in writeRecord
  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 530, in write  File "/usr/local/badc/python/lib/python2.4/site-packages/flup-0.5-py2.4.egg/flup/server/fcgi_base.py", line 507, in _sendall
socket.error: (32, 'Broken pipe')

Change History

comment:1 Changed 12 years ago by lawrence

  • Status changed from new to closed
  • Resolution set to worksforme

This turned out to be the stupidly long xqueries, which led to apache timeouts. Xqueries have since been rationalised, but it's still a problem; however, it's probably better to solve it in the xqueries than here ...

Note: See TracTickets for help on using tickets.