Full Temp Space Bug with CLOB Fields in Direct Mode

Full Temp Space Bug with CLOB Fields in Direct Mode

Postby mas » Wed 20 Apr 2011 07:35

I have already reported several issues with CLOB fields in Direct Mode, and I have run into another.

We have some tables with CLOB columns. During our performance testing, we inserted a large number of rows into these tables. Eventually, our application started erroring out with the message from Oracle:

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP


With some analysis, we found that the temporary space was being filled and never released, until we shutdown our application.

This problem occurs only in Direct Mode. We tested with the Oracle Client and we didn't run into this problem.

In the change history (http://www.devart.com/History.aspx?prod=dotconnect/oracle), I found this entry for 6.00.69 16-Dec-10:
Fixed bug with freeing temporary tablespace when creating multiple LOBs


Could it be that this bug was fixed for the Oracle Client but not for Direct Mode? When will this bug be fixed?

We tested with Devart dotConnect for Oracle v6.10.135.0.
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Postby Shalex » Wed 20 Apr 2011 11:28

mas wrote:Could it be that this bug was fixed for the Oracle Client but not for Direct Mode? When will this bug be fixed?

This is correct. We will post here when the problem is fixed for the Direct mode.
Shalex
Devart Team
 
Posts: 7606
Joined: Thu 14 Aug 2008 12:44

Postby mas » Mon 02 May 2011 15:58

Hi, is there a workaround that we can employ while we're waiting for the fix? We are currently running performance tests and we often run into this issue.
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Postby Shalex » Wed 04 May 2011 07:03

As a workaround, please increase the size of your tablespace or set it to unlimited.
Shalex
Devart Team
 
Posts: 7606
Joined: Thu 14 Aug 2008 12:44

Postby mas » Tue 07 Jun 2011 11:55

According to the release notes for dotConnect for Oracle 6.30.165:

The bug with retrieving LOB values in Direct mode is fixed


Is this issue fixed?
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Postby mas » Tue 07 Jun 2011 15:09

I have tested with dotConnect for Oracle 6.30.165, and the problem still occurs. A fix for this is quite urgent for us...
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Postby Shalex » Fri 10 Jun 2011 13:11

The bug with retrieving LOB values in Direct mode is fixed

This fix corresponds to the different issue. We are investigating the problem that is described in this thread. We will notify you about the results as soon as possible.
Shalex
Devart Team
 
Posts: 7606
Joined: Thu 14 Aug 2008 12:44

Re: Full Temp Space Bug with CLOB Fields in Direct Mode

Postby mas » Mon 08 Oct 2012 11:59

Hi, it has been a long time since I have reported this issue, and this issue still persists with the newest version (7.2.96).

Our current workaround is to set "Connection Lifetime=60" in the connection string. This ensures that all connections will be closed often, which forces the temp spaced to be cleaned up.

Is there a plan to fix this? If the plan is not to fix this bug, then it would be nice to know so we can search for other solutions.
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Re: Full Temp Space Bug with CLOB Fields in Direct Mode

Postby Pinturiccio » Mon 15 Oct 2012 09:06

We are planning to fix this issue. We will notify you about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1951
Joined: Wed 02 Nov 2011 09:44

Re: Full Temp Space Bug with CLOB Fields in Direct Mode

Postby StanislavK » Sat 29 Dec 2012 16:18

We have fixed the issue with freeing temporary tablespace when creating multiple LOBs in the Direct connection mode. The fix is available in the latest 7.4.146 version of dotConnect for Oracle.

The new build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with an active subscription only).
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle