Re: [PyWrapper-devel] GENERATING_CONTENT_FAILED with parallel queries

[<m.d...@bg...>]

shunde,
are you running pywrapper behind apache via fastcgi or standalone via  
cherrypy? if cherrypy, are you using the produciton mode?
--
Markus



On 13.06.2007, at 02:10, Shunde Zhang wrote:

> Hi all,
>
> I've written a program using multi-threads to send queries at the  
> same time. I
> was working before. Yesterday I put in more records to my database 
> (~300000).
> Today I ran my program, I found that it works if I send one only  
> query at one
> time. If I sent 2 queries at the same time, it gives me an error.
>
> <!-- CONTENT START -->
> <error xmlns="http://rs.tdwg.org/tapir/1.0" time="2007-06-07  
> 11:13:10.23"
> level="ERROR">Response preparation and data retrieval error</error>
> <!-- CONTENT END -->
> <diagnostics>
> <diagnostic time="2007-06-07T11:13:02.44" level="INFO">Reading
> request</diagnostic>
> <diagnostic time="2007-06-07T11:13:02.49" level="INFO">Read model
> http://rs.tdwg.org/tapir/cs/abcd/2.06/model/abcd206.xml</diagnostic>
> <diagnostic time="2007-06-07T11:13:02.51" level="INFO">Request fully
> parsed</diagnostic>
> <diagnostic time="2007-06-07T11:13:02.51" level="INFO">Get distinct
> records...</diagnostic>
> <diagnostic time="2007-06-07T11:13:02.52" level="INFO">Executing  
> SQL: "SELECT
> DISTINCT TaxonName.Genus, TaxonName.Species FROM TaxonName AS  
> TaxonName
>   ORDER BY TaxonName.Genus, TaxonName.Species LIMIT 21 OFFSET 0"</ 
> diagnostic>
> <diagnostic time="2007-06-07T11:13:03.47" level="INFO">Parsed  
> response structure
> contains 991 leaf concepts with type out of 1663 nodes in total</diag
> nostic>
> <diagnostic time="2007-06-07T11:13:04.14" level="INFO">Request fully
> parsed</diagnostic>
> <diagnostic time="2007-06-07T11:13:04.15" level="INFO">Init model  
> ACBD 2.06 with
> datasource preferences</diagnostic>
> <diagnostic time="2007-06-07T11:13:04.55" level="INFO">Model init  
> finished. The
> model contains 1324 mapped concepts for datasource 'avh' out of 1324 m
> odel nodes mapped.</diagnostic>
> <diagnostic time="2007-06-07T11:13:04.55" level="INFO">Update model  
> structure
> with datasource preferences</diagnostic>
> <diagnostic time="2007-06-07T11:13:10.17" level="INFO">DB query
> finished</diagnostic>
> <diagnostic time="2007-06-07T11:13:10.17"
> level="ERROR">GENERATING_CONTENT_FAILED</diagnostic>
> <diagnostic time="2007-06-07T11:13:10.23" level="ERROR">Response  
> preparation and
> data retrieval error</diagnostic>
> <diagnostic time="2007-06-07T11:13:10.24"
> level="ERROR">GENERATING_CONTENT_FAILED</diagnostic>
>
> Strangely, i sent one inventory and one search, but the errors I  
> got are the
> same, which is like doing an inventory query as above. Could you  
> please give me
> some idea of how to solve it? thanks a lot.
>
> Cheers,
> Shunde.
>
>
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> PyWrapper-devel mailing list
> PyW...@li...
> https://lists.sourceforge.net/lists/listinfo/pywrapper-devel