[Babase] Partial query results
Catherine Markham
babase@www.eco.princeton.edu
Wed, 28 Sep 2005 17:37:04 -0400
Ok, sounds good. One thing worth mentioning is that I can rerun the
query and it has always worked fine the second time. In other words, it
isn't like I can't ever get the full results - just that occasionally
the first table output is incomplete.
Karl O. Pinc wrote:
>
> On 09/28/2005 01:39:49 PM, Catherine Markham wrote:
> \
> In the checking of old and new MEMBERS
>
>> tables that goes along with all this, I've noticed a funny quirk a
>> couple times. When I run a query in the new system, I have had the
>> table stop "processing" without completing all the rows. This is
>> very rare - I've only noticed it happening maybe 4 or 5 times. When
>> it does happen, it is pretty obvious because usually I'm checking out
>> the death dates (which aren't loaded because of the cutoff) and there
>> is no total of table rows or time executed listed at the bottom of
>> the webpage. Just the same, it seems like a potentially dangerous
>> quirk - if the table was thought to be completed and exported, it
>> would be short a lot of data. I played just a little to see I was
>> doing something funky to cause this - can't figure anything out,
>> though. And the table "load" line does indicate that the page is
>> "done" - in other words, the computer doesn't seem to be momentarily
>> thinking before completely the additional rows.
>>
>> Not sure if I explained that well, or if it really is an issue to
>> worry about. Just thought I'd mention it.
>
>
> We're using a really old version of the phppgadmin, I think the
> thing to do is upgrade and see if it's still happening.
> I can also look at the logs and see if anything jumps out.
> Also, there could be some sort of limit set somewhere that
> we're exceeding that I need to fiddle with.
>
> If we're really concerned then you could read over the
> phppgadmin release notes on their website and see if they
> say they've fixed a bug like this. After that we'd ask around
> on their mailing list. When all else fails I fix whatever's
> broken and send in the fix.
>
> Karl <kop@meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase@www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Catherine Markham
Department of Ecology and Evolutionary Biology
Princeton University
Phone: (609) 258-6898
Fax: (609) 258-2712