[Bug 9989] New: Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

Summary: Oracle OCI client: Hangs on updating LOB data
           Product: Wine
           Version: 0.9.46.
          Platform: PC
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: wine-net
        AssignedTo: [e-mail]
        ReportedBy: [e-mail]

Created an attachment (id=8509)
 --> (http://bugs.winehq.org/attachment.cgi?id=8509)
log file (with WINEDEBUG=+all) containing last lines before freeze

A business application written in Delphi that uses Oracle OCI client, worked
normally in Wine 0.9.33 under Ubuntu 7.04. After upgrade to Wine 0.9.46 (or
even to 0.9.41) it starts working faster but also starts hanging on update LOB
data if these data amount more than ~10 KBytes.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #1 from Yuriy Tkachenko   2007-10-11 07:56:14 ---
In addition: used Oracle client version 8.1.6

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

Dan Kegel  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #2 from Dan Kegel   2007-10-11 08:12:19 ---
Can you do a regression test to see which commit causes the problem?

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

Dan Kegel  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |regression

--- Comment #3 from Dan Kegel   2007-10-11 08:13:46 ---
Also, is there a test or demo app you can point us
to that reproduces the problem?

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #4 from Yuriy Tkachenko   2007-10-11 16:49:11 ---
I'll try do a regression test in a few days and inform you.
Sorry, but neither test nor demo exists for this application.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #5 from Yuriy Tkachenko   2007-10-16 10:11:33 ---
What I've got after some testing:
- Wine 0.9.33 from the Ubuntu 7.04 Feisty repositories - works without
hangings, but slower than with Wine >=0.9.39;
- Wine versions 0.9.35 .. 0.9.38 from
http://wine.budgetdedicated.com/archive/index.html - hangs on start connecting
to oracle database (in debug mode "oracle error ORA-12571: TNS:packet writer
failure" popup message appears) and the application doesn't work (??!);
- Wine versions 0.9.39 .. 0.9.47 from
http://wine.budgetdedicated.com/archive/index.html - works fine except already
mentioned hanging on update LOB data if data size more than ~10 KBytes.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #6 from Yuriy Tkachenko   2007-10-16 10:19:47 ---
The *same* hangings also detected in PL/SQL Developer 
(http://www.allroundautomations.com)

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #7 from Dan Kegel   2007-10-30 14:01:52 ---
Somebody submitted a patch:
http://winehq.org/pipermail/wine-patches/2007-October/045988.html

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #8 from Yuriy Tkachenko   2007-10-30 16:17:28 ---
(In reply to comment #7)
> Somebody submitted a patch:
> http://winehq.org/pipermail/wine-patches/2007-October/045988.html

Somebody - it's me. :) I played with git, but it seems I have not properly
configured it.
Will this patch be committed or resend needed?

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #9 from Timo-Heikki Mäkelä   2008-03-06 16:01:27 ---
I cannot find that patch committed to the GIT. Obviously you need to resend it.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #10 from Yuriy Tkachenko   2008-03-07 13:47:19 ---
This patch has been rejected by Alexandre Julliard. 
He answered: "This is wrong, it will make all sockets non-overlapped."
However, it works fine for me. :)

diff --git a/dlls/ws2_32/socket.c b/dlls/ws2_32/socket.c
index 24a4a76..3697746 100644
--- a/dlls/ws2_32/socket.c
+++ b/dlls/ws2_32/socket.c
@@ -2662,7 +2662,8 @@ INT WINAPI WSASendTo( SOCKET s, LPWSABUF lpBuffers, DWORD
dwBufferCount,
         goto error;
     }

-    if ((lpOverlapped || lpCompletionRoutine) &&
+    /* If no options specified, the socket assumed to be non-overlapped*/
+    if (options && (lpOverlapped || lpCompletionRoutine) &&
         !(options & (FILE_SYNCHRONOUS_IO_ALERT |
FILE_SYNCHRONOUS_IO_NONALERT)))
     {
         IO_STATUS_BLOCK *iosb;

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

Kai Blin  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |patch

--- Comment #11 from Kai Blin   2008-05-25 04:35:54 ---
Adding patch keyword

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #12 from Austin English   2008-11-23 15:38:00 ---
Is this still an issue in current (1.1.9 or newer) wine?

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #13 from Kai Blin   2008-12-18 06:49:52 ---
Probably, at least WSASendTo wasn't changed.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #14 from Austin English   2009-06-30 10:54:27 ---
Probably still present.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #15 from Yuriy Tkachenko   2009-06-30 13:37:52 ---
In version 1.1.24 this issue is still present (compiled in Ubuntu 9.04).
But when I tried Wine 1.0.1 rpm in CentOS 5.3 under VirtualBox, Oracle OCI
client worked fine.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #16 from Dmitry Timoshkov   2009-07-11 03:27:31 ---
(In reply to comment #15)
> In version 1.1.24 this issue is still present (compiled in Ubuntu 9.04).
> But when I tried Wine 1.0.1 rpm in CentOS 5.3 under VirtualBox, Oracle OCI
> client worked fine.

Perhaps you could perform a regression test then?

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #17 from Yuriy Tkachenko   2009-07-12 04:06:53 ---
(In reply to comment #16)
> Perhaps you could perform a regression test then?

Unfortunately I don't have such an opportunity AT THIS TIME.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

--- Comment #18 from Yuriy Tkachenko   2009-09-28 12:12:37 ---
Seems it's fixed in 1.1.30?
After compiling 1.1.30 I can't reproduce this issue.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

Dan Kegel  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |FIXED

--- Comment #19 from Dan Kegel   2009-09-28 12:28:47 ---
Marking fixed, then.

[Bug 9989] Oracle OCI client: Hangs on updating LOB data

http://bugs.winehq.org/show_bug.cgi?id=9989

Alexandre Julliard  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #20 from Alexandre Julliard   2009-10-09 11:13:31 ---
Closing bugs fixed in 1.1.31.