Full Temp Space Bug with CLOB Fields in Direct Mode

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
mas
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Full Temp Space Bug with CLOB Fields in Direct Mode

Post by 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 ... ect/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.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by 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.

mas
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Post by 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.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 04 May 2011 07:03

As a workaround, please increase the size of your tablespace or set it to unlimited.

mas
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Post by 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

Post by 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...

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by 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.

mas
Posts: 25
Joined: Mon 15 Nov 2010 12:09

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

Post by 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.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by 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.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

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

Post by 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).

Post Reply