Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Anonymous_User Absent Member.
Absent Member.
252 views

JDBC driver slowdown


I made some changes to our Oracle database and ever since then the JDBC
driver has been acting up. I don't know if it is related or not. I added
a column to include an email address and modified the view that the
driver uses to include the attribute. Since then the driver trace
occasionally spits stuff like this out:


Code:
--------------------
13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
--------------------


There will be thousands of those messages all with the same time stamp
and thousands more for the next second, and the next, etc. That
attribute is not the one I added however and I don't know why this
message is happening. The problem is that this delays the processing of
the event queue and gets things backed up. This may be more of a SQL
question but I thought I'd ask.


--
bobbintb
------------------------------------------------------------------------
bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
View this thread: https://forums.netiq.com/showthread.php?t=51753

Labels (1)
0 Likes
16 Replies
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/15/2014 2:38 PM, bobbintb wrote:

> Code:
> --------------------
> 13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
> --------------------
>


Could you post more of the trace in context please? That will allow us to tell you what it is
actually doing with that.


--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown


descent;248743 Wrote:
> On 9/15/2014 2:38 PM, bobbintb wrote:
>
> > Code:
> > --------------------
> > 13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field

> 'MV_CUTS_GROUPS', value = null
> > --------------------
> >

>
> Could you post more of the trace in context please? That will allow us
> to tell you what it is
> actually doing with that.
>
>
> --
> -----------------------------------------------------------------------
> Will Schneider
> Knowledge Partner http://forums.netiq.com
>
> If you find this post helpful, please click on the star below.


I don't know if I can really. It's just that message over and over
thousands of times. That's the problem really. It's just that
occasionally that message will flood the system and I have to wait for
it to stop before anything else gets processed. I suppose I could try
and get a trace of it before and during but I never know when it will
start.


--
bobbintb
------------------------------------------------------------------------
bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
View this thread: https://forums.netiq.com/showthread.php?t=51753

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/16/2014 11:27 AM, bobbintb wrote:

> I don't know if I can really. It's just that message over and over
> thousands of times. That's the problem really. It's just that
> occasionally that message will flood the system and I have to wait for
> it to stop before anything else gets processed. I suppose I could try
> and get a trace of it before and during but I never know when it will
> start.
>
>




So is it literally:
13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:21 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:22 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:23 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:24 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:25 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:26 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null
13:12:27 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value = null

That doesn't seem right. Can you share the structure of your view?
I'd like to see the few lines around what is generating this line. Without context it is difficult to say.

--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown


descent;248821 Wrote:
> On 9/16/2014 11:27 AM, bobbintb wrote:
>
> > I don't know if I can really. It's just that message over and over
> > thousands of times. That's the problem really. It's just that
> > occasionally that message will flood the system and I have to wait

> for
> > it to stop before anything else gets processed. I suppose I could try
> > and get a trace of it before and during but I never know when it will
> > start.
> >
> >

>
>
>
> So is it literally:
> 13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:21 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:22 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:23 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:24 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:25 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:26 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
> 13:12:27 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
> = null
>
> That doesn't seem right. Can you share the structure of your view?
> I'd like to see the few lines around what is generating this line.
> Without context it is difficult to say.
>
> --
> -----------------------------------------------------------------------
> Will Schneider
> Knowledge Partner http://forums.netiq.com
>
> If you find this post helpful, please click on the star below.


well, it is more like:

13:12:20 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
= null

a few thousand times then:

13:12:21 A2903700 Drvrs: ISU-JDBC PT: RS field 'MV_CUTS_GROUPS', value
= null

a few thousand times etc. which is part of the problem. the file size of
the log is limited so by the time i notice it starts happening, the part
the caused it has already been trimmed from the log. is there a way i
can share the view without letting everyone see it?


--
bobbintb
------------------------------------------------------------------------
bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
View this thread: https://forums.netiq.com/showthread.php?t=51753

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/17/2014 4:27 PM, bobbintb wrote:
> a few thousand times etc. which is part of the problem. the file size of
> the log is limited so by the time i notice it starts happening, the part
> the caused it has already been trimmed from the log. is there a way i
> can share the view without letting everyone see it?
>
>


You can email it to me directly at my first initial lastname [at] cisus [dot] com
If there is something relevant I'll post the explanation only here and not specific code.


--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown


Thanks for the help but I think the issue has been resolved. I went back
to look at the data in the view and something was up. When I added that
attribute earlier I used the wizard to do it. Well the wizard screwed up
something in the join statement and I'm pretty sure that was the cause.
I need to quit using that wizard. I only use it to remove the
possibility of human error but every time I have used it instead of
manually changing the view, it has screwed something up. Thanks again.


--
bobbintb
------------------------------------------------------------------------
bobbintb's Profile: https://forums.netiq.com/member.php?userid=5629
View this thread: https://forums.netiq.com/showthread.php?t=51753

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/18/2014 10:29 AM, bobbintb wrote:
>
> Thanks for the help but I think the issue has been resolved. I went back
> to look at the data in the view and something was up. When I added that
> attribute earlier I used the wizard to do it. Well the wizard screwed up
> something in the join statement and I'm pretty sure that was the cause.
> I need to quit using that wizard. I only use it to remove the
> possibility of human error but every time I have used it instead of
> manually changing the view, it has screwed something up. Thanks again.
>
>

Well at least that means I was onto the correct scent 🙂

--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC driver slowdown

On 9/18/2014 1:01 PM, Will Schneider wrote:
> On 9/18/2014 10:29 AM, bobbintb wrote:
>>
>> Thanks for the help but I think the issue has been resolved. I went back
>> to look at the data in the view and something was up. When I added that
>> attribute earlier I used the wizard to do it. Well the wizard screwed up
>> something in the join statement and I'm pretty sure that was the cause.
>> I need to quit using that wizard. I only use it to remove the
>> possibility of human error but every time I have used it instead of
>> manually changing the view, it has screwed something up. Thanks again.
>>
>>

> Well at least that means I was onto the correct scent 🙂


As opposed to a wild goose smell chase? 🙂

It is interesting how often odd things 'build up' in connected systems.



0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/18/2014 12:02 PM, Geoffrey Carman wrote:
> As opposed to a wild goose smell chase? 🙂


You have a stench of New Jersey in your Canadian Red Beard (are you a pirate?).
I think you've been swimming in too many channels Jeff Carmen.


--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC driver slowdown

On 9/18/2014 2:08 PM, Will Schneider wrote:
> On 9/18/2014 12:02 PM, Geoffrey Carman wrote:
>> As opposed to a wild goose smell chase? 🙂

>
> You have a stench of New Jersey in your Canadian Red Beard (are you a
> pirate?).
> I think you've been swimming in too many channels Jeff Carmen.


You wound me sir! I have a soul, ginger though I may be! Do not cross
me, as I am (per Cartman) a 3G! (Ginger, Jewish, living in Jersey). You
never know where this could end up! Wake up with a herring head in your
bed!

Ocean did not smell this morning at all. (Did a swim around the statue
of liberty. That was fun!).

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/18/2014 1:15 PM, Geoffrey Carman wrote:

> Ocean did not smell this morning at all. (Did a swim around the statue of liberty. That was fun!).
>

You are an Angie from the 51st State!!!
You stay away from our dear lady you crazy Cankee!!!!


--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC driver slowdown

On 9/18/2014 2:18 PM, Will Schneider wrote:
> On 9/18/2014 1:15 PM, Geoffrey Carman wrote:
>
>> Ocean did not smell this morning at all. (Did a swim around the
>> statue of liberty. That was fun!).
>>

> You are an Angie from the 51st State!!!


When (not if) it ever comes to that, it will be the 51st through 63rd
states anyway! 🙂

> You stay away from our dear lady you crazy Cankee!!!!


Ya, security is oddly lax. They let through knives and water bottles
onto the Ferry. I mean, who knows what I might do! Hijack the statue
and fly her around the area? I dunno.

Still had to go through security. The organizers were very funny. They
required us to get back into clothes after the swim, since the Parks
Commission does NOT like the image of a bunch of people walking around
the Statue island in bathing suits.

Was cool. Counter clockwise around, so every breath to the left was a
great view of the Statue. (As we rounded the island from its south, the
sun was rising behind her, great image, no camera, alas).

I have swum with these guys in the East River (Brooklyn to Manhattan)
and in the Harlem River (1500m circle route up by the Triboro bridge).
They are fun! Saturday they have a 7 Mile swim from the GW Bridge north
to Yonkers. Supposed to be with the current which should make it
easier, but 7 miles is too long.

They also do a Manhattan Island Marathon Swim (MIMS) that is 28.5 miles
all the way around Manhattan Island. That is a bit kookie to me, even.
So we have established what kind of 'woman' I am, just negotiating
distance. 🙂



0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: JDBC driver slowdown

On 9/18/2014 1:28 PM, Geoffrey Carman wrote:
> Counter clockwise around, so every breath to the left was a great view of the Statue. (As we rounded the island from its
> south, the sun was rising behind her, great image, no camera, alas).


How have you not strapped a GoPro to yourself for these adventures?

--
-----------------------------------------------------------------------
Will Schneider
Knowledge Partner http://forums.netiq.com

If you find this post helpful, please click on the star below.
0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC driver slowdown

On 9/18/2014 2:52 PM, Will Schneider wrote:
> On 9/18/2014 1:28 PM, Geoffrey Carman wrote:
>> Counter clockwise around, so every breath to the left was a great view
>> of the Statue. (As we rounded the island from its
>> south, the sun was rising behind her, great image, no camera, alas).

>
> How have you not strapped a GoPro to yourself for these adventures?


Drag baby drag! Lots of people were actually wearing them.

The beard by the way is hydronamically positive! Polar bears prove it!
I am a ginger polar bear! (The belly is just good for warmth)

Don't have a GoPro, won a sort of version but gave it to Aaron at
Brainshare. figured he can find sillier uses than I ever would. (That
guy is crazy! He seems so nice, but does the craziest stuff!)



0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.