[SqueakDBX] OpenDBX: Another command is already in progress

[Mariano Martinez Peck]

On Wed, May 11, 2011 at 3:54 PM, John Toohey <jt at parspro.com> wrote:

> Well the VM crashes, but I can't be sure if its because of the resume or
> something else.
>
>
wow.... we will need more data in order to help there.
Which Pharo/Squeak image, which VM ? which OS ? which OpenDBX version ?
which database ?  which version of SqueakDBX/ConfigurationOf ?

do you have the dump or console output of the crash ?

thanks

Mariano


>
> On Tue, May 10, 2011 at 15:04, Mariano Martinez Peck <
> marianopeck at gmail.com> wrote:
>
>>
>>
>> On Tue, May 10, 2011 at 9:03 PM, John Toohey <jt at parspro.com> wrote:
>>
>>> The main one is the GlorpDatabaseReadError, and as its resumable, and a
>>> read error, I just want to retry it, until it succeeds. This is a production
>>> system, and having the debugger fire constantly, eventually messes up the
>>> entire image.
>>>
>>>
>> Ok....but if you resume... does it work finally ?   I mean, if you do what
>> you said, you fix your problem ?
>>
>> thanks
>>
>>
>>>
>>> On Tue, May 10, 2011 at 14:23, Mariano Martinez Peck <
>>> marianopeck at gmail.com> wrote:
>>>
>>>>
>>>>
>>>> On Tue, May 10, 2011 at 5:03 PM, John Toohey <jt at parspro.com> wrote:
>>>>
>>>>> But as these exceptions
>>>>
>>>>
>>>> which ones? I guess you are talking about GlorpDatabaseReadError
>>>>
>>>>
>>>>> are marked as Resumable, shouldn't it be enough for me to do :-
>>>>
>>>>
>>>> I am not sure if I understood correctly. Can you explain a little more
>>>> please?
>>>>
>>>>
>>>>>  [
>>>>>  ^aQuery executeWithParameters: #() in: self.
>>>>> ]
>>>>> on: GlorpDatabaseReadError
>>>>>  do: [:ex | Transcript show: ex messageText;cr.  ex resume].
>>>>>
>>>>
>>>>
>>>>
>>>> thanks
>>>>
>>>> Mariano
>>>>
>>>>
>>>>
>>>>>
>>>>> On Tue, May 10, 2011 at 10:39, Mariano Martinez Peck <
>>>>> marianopeck at gmail.com> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, May 10, 2011 at 4:31 PM, John Toohey <jt at parspro.com> wrote:
>>>>>>
>>>>>>> I get this error a lot when my system is under load. According to the
>>>>>>> pgsql docs, I should do this, "PQgetResult must be called repeatedly
>>>>>>> until it returns a null pointer,
>>>>>>>
>>>>>>
>>>>>> *indicating* that the *command* *is* done."
>>>>>>>
>>>>>>>
>>>>>> This is weird...it should not happen while using SqueakDBX.
>>>>>> If you see DBXConnection >> execute:
>>>>>>
>>>>>> just at the beginning we do:
>>>>>>
>>>>>>     | aResult |
>>>>>>     self isOpen ifFalse:
>>>>>>         [ OpenDBXDriverError signal: 'You cannot execute a query if
>>>>>> the connection is not open' ].
>>>>>>     self releasePreviousResult.
>>>>>>
>>>>>>
>>>>>> that method #releasePreviousResult  that exactly that. If you didn't
>>>>>> finish iterating all returns in your last query, we do it for you in the
>>>>>> next query. Of course, we also do that while closing the connection.
>>>>>> So...I cannot image how you can get that :(
>>>>>> Probably something with the pool and Glorp ?
>>>>>>
>>>>>>
>>>>>>>  How do I handle this type of error in GlorpDBX? I'm using Pharo 1.2
>>>>>>> and the Glorp/DBX build that was available when that was released.
>>>>>>>
>>>>>>> --
>>>>>>> ~JT
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> SqueakDBX mailing list
>>>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Mariano
>>>>>> http://marianopeck.wordpress.com
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> SqueakDBX mailing list
>>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> ~JT
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> SqueakDBX mailing list
>>>>> SqueakDBX at lists.squeakfoundation.org
>>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Mariano
>>>> http://marianopeck.wordpress.com
>>>>
>>>>
>>>> _______________________________________________
>>>> SqueakDBX mailing list
>>>> SqueakDBX at lists.squeakfoundation.org
>>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>>
>>>>
>>>
>>>
>>> --
>>> ~JT
>>>
>>>
>>>
>>> _______________________________________________
>>> SqueakDBX mailing list
>>> SqueakDBX at lists.squeakfoundation.org
>>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>>
>>>
>>
>>
>> --
>> Mariano
>> http://marianopeck.wordpress.com
>>
>>
>> _______________________________________________
>> SqueakDBX mailing list
>> SqueakDBX at lists.squeakfoundation.org
>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>
>>
>
>
> --
> ~JT
>
>
>
> _______________________________________________
> SqueakDBX mailing list
> SqueakDBX at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>
>


-- 
Mariano
http://marianopeck.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110511/9afabe3e/attachment.htm