[PyWrapper-devel] GENERATING_CONTENT_FAILED with parallel queries

[Shunde Z. <shu...@ad...>]

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.