Re: [PyWrapper-devel] GENERATING_CONTENT_FAILED with parallel queries

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

Hi Markus,

I am using cherrypy for testing. could you please tell me how to use production
mode? would it be solved if I use apache? thanks again.

Cheers,
Shunde.


Quoting Markus Döring <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
>
>
> -------------------------------------------------------------------------
> 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
>