You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by Kee Hinckley <na...@somewhere.com> on 2002/09/16 04:47:06 UTC
Urgent DBIx::Recordset question
On occasion on some of my database driven sites I get a query result
which is both there and not there. Which is to say that
DBIx::Recordset returns the correct number of records, and the static
text associated with each record is returned, but the actual content
of the record is completely empty. So you end up with a page of (for
instance) 8 rows, but no data in them. Very odd.
Could this be caused by not preloading Apache::DBI. And if not, what
*could* cause it. Clearly DBIx::Recordset knows correctly how many
records there are, but where did the data go.
I should add that after a reload or two, the problem almost always goes away.
--
Kee Hinckley - Somewhere.Com, LLC
http://consulting.somewhere.com/
I'm not sure which upsets me more: that people are so unwilling to accept
responsibility for their own actions, or that they are so eager to regulate
everyone else's.
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: Urgent DBIx::Recordset question
Posted by Angus Lees <gu...@inodes.org>.
At Tue, 17 Sep 2002 19:09:49 -0400, Kee Hinckley wrote:
> At 8:10 AM +1000 9/18/02, Angus Lees wrote:
> >you haven't set $DBIx::Recordset::FetchsizeWarn=0, have you?
>
> Yes. Why?
perhaps that doesn't work for your database? (it doesn't for postgresql)
it might appear to work sometimes, if the results come back fast
enough for the client libraries to give an accurate result (or
something).
i'm just making stuff up here. trying to find something that would be
intermittent and affect the fetch loop in some way.
--
- Gus
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: Urgent DBIx::Recordset question
Posted by Kee Hinckley <na...@somewhere.com>.
At 8:10 AM +1000 9/18/02, Angus Lees wrote:
>you haven't set $DBIx::Recordset::FetchsizeWarn=0, have you?
Yes. Why?
--
Kee Hinckley - Somewhere.Com, LLC
http://consulting.somewhere.com/
I'm not sure which upsets me more: that people are so unwilling to accept
responsibility for their own actions, or that they are so eager to regulate
everyone else's.
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org
Re: Urgent DBIx::Recordset question
Posted by Angus Lees <gu...@inodes.org>.
At Sun, 15 Sep 2002 22:47:06 -0400, Kee Hinckley wrote:
> On occasion on some of my database driven sites I get a query result
> which is both there and not there. Which is to say that
> DBIx::Recordset returns the correct number of records, and the static
> text associated with each record is returned, but the actual content
> of the record is completely empty. So you end up with a page of (for
> instance) 8 rows, but no data in them. Very odd.
>
> Could this be caused by not preloading Apache::DBI. And if not, what
> *could* cause it. Clearly DBIx::Recordset knows correctly how many
> records there are, but where did the data go.
>
> I should add that after a reload or two, the problem almost always goes away.
weird. i can't think of a reason why that would happen. we'd probably
need a debug log of at least dbgEval and !Debug=3 to find out whats
happening.
I couldn't see how Apache::DBI would change things, since it simply
redefines DBI->connect and DBI->disconnect. afaik it doesn't affect
things during the fetch loop.
you haven't set $DBIx::Recordset::FetchsizeWarn=0, have you?
--
- Gus
---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org