Re: DB2 server not responding after short time using Slide 2.1 be ta

[James Mason <ma...@apache.org>]

Warwick Burrows wrote:
> Hi James,
> 
> I haven't picked up the latest fixes from the head yet so if the fix you and
> Oliver made was in there and after the beta release then I don't have it
> yet.

The changes were part of the beta, so... :(

> 
> I'm not an expert on DB2 (on Windows) so I seem to have logging enabled but
> I'm not sure where to check for the log of all sql statements. I have opened
> the journal but it doesn't seem to have a lot of information. Where would I
> find the statement log?  Also the logging I have enabled for my database is
> the default, called "circular logging", which may be less detailed than the
> other option they give me. Should I enable the other logging method?
> Circular logging has automatic rollover but the other method doesn't.

Unfortunately, I think you more know about DB2 than I do. I was never 
even able to find a working client download! DB2 should be able to offer 
you some sort of statement log; it will likely be a debug feature since 
it shouldn't normally be needed. Maybe your driver has a parameter you 
can pass? I'd recommend searching the web or finding a DB2 admin that 
you can ask. If you've got support IBM should be able to tell you 
straight up.

I think there are also tool available to monitor a jdbc connection and 
watch what's going on. Maybe you can find one of those that will monitor 
what's going on?

-James

> 
> Thanks,
> Warwick
> 
> 
> -----Original Message-----
> From: James Mason [mailto:masonjm@apache.org] 
> Sent: Wednesday, August 25, 2004 9:47 PM
> To: Slide Users Mailing List
> Subject: Re: DB2 server not responding after short time using Slide 2.1 beta
> 
> 
> Warwick,
> This sounds suspiciously like a deadlock condition to me. I ran into 
> something similar with MySQL, and I *thought* that Oliver and I had made 
> changes that would ensure it couldn't happen, but maybe not.
> 
> If possible can you get a log of all the sql statements executed by 
> Slide against the database? If your log includes a connection id look to 
> see if the connection id suddenly changes. That should help you pinpoint 
> the sql statement that's causing the problem .
> 
>  From looking at enumerateLocks() I don't see any way that statement 
> could cause a deadlock. This makes me think the problem is probably 
> somewhere else and it's just surfacing when that statement runs.
> 
> -James
> 
> Warwick Burrows wrote:
> 
>>Hi,
>> 
>>I've run into a serious problem with the slide 2.1B1 server where the 
>>DB2 server hangs executing a select statement in the enumerateLocks() 
>>method of the StandardRDBMSAdapter in the server. Once the DB server 
>>is hung it won't even respond to simple select statements from the DB2 
>>cli.  Though it will respond to "list tables" commands. When I run a 
>>select from the DB2 cli (eg. select * from URI) and it hangs I can hit 
>>ctrl-C at the DB2 cli prompt and it will cancel the request and return 
>>-- but no data comes back with it. Of course the slide server will 
>>wait indefinitely for the sql request to come back. Has anybody else 
>>had this problem with Slide 2.1B1 and DB2?  A new DB2 RDBMS adapter 
>>was introduced in 2.1B1 as well as a new DB2 schema. I didn't see this 
>>problem with 2.1M1 but its happening frequently with 2.1B1. In fact 
>>its such a problem my project no longer works and we're grounded until 
>>we can find a fix.
>> 
>>Thanks,
>>Warwick
>> 
>> 
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org