Hey @Hakan and guys
I'm sorry, I know it is almost an old thread, but, just to be sure you have
tried something I want to suggest.
We have a project where the requirements is to perform over the SQL Server
and Oracle depending of what license the customer has.
I had some issues with pool of Oracle and the final solution was to add a
call to clear the Oracle Pool from the current database connection of the
application.
The OracleDataManaged provider has a static method from the OracleConnection
<https://docs.oracle.com/cd/E85694_01/ODPNT/ConnectionClearPoolCtor1.htm>
class where you pass an instance of a OracleCOnnection and it will be
closed and removed from the pool (Oracle). I am not a expert of Oracle but
it solve the problem when the application get a lot of users running.See on
the link:
https://docs.oracle.com/cd/E85694_01/ODPNT/ConnectionClearPoolCtor1.htm
The implementation should follow something like this:
var oracleConnection = session.Connection as OracleConnection;
if (oracleConnection != null)
OracleConnection.ClearPool(oracleConnection);
if (session.IsOpen)
session.Close();
session.Dispose();
On Mon, Jan 18, 2021 at 7:37 AM Hakan karaoğlu <[email protected]>
wrote:
> Hi Gunnar,
> As you said, I used concurrent limit and second level cache. There is no
> problem at the moment, thanks for your suggestion
>
> 14 Ocak 2021 Perşembe tarihinde saat 00:44:49 UTC+3 itibarıyla Gunnar
> Liljas şunları yazdı:
>
>> Maybe you should try to limit concurrency. Masstransit has ways of doing
>> that.
>>
>> /G
>>
>> On Wed, Jan 13, 2021 at 10:32 PM Hakan karaoğlu <[email protected]>
>> wrote:
>>
>>> let me give you one more information, my example query you can see
>>> below
>>>
>>> [image: 9.PNG]
>>>
>>> 14 Ocak 2021 Perşembe tarihinde saat 00:16:06 UTC+3 itibarıyla Hakan
>>> karaoğlu şunları yazdı:
>>>
>>>> Gunnar, I found the error and fixed it. However, this time, other
>>>> consumers who received the message started to give different errors. For
>>>> example
>>>>
>>>> Received "Pooled connection request timed out" error 1881 times among
>>>> 13 thousand data
>>>>
>>>> [image: 7.PNG]
>>>>
>>>> 1000 times "Object reference not set to an instance of an object." got
>>>> the error
>>>>
>>>> [image: 8.PNG]
>>>> By the way, I set the connection timeout to 120 in the
>>>> configuration. What else can you suggest?
>>>> 13 Ocak 2021 Çarşamba tarihinde saat 02:37:39 UTC+3 itibarıyla Gunnar
>>>> Liljas şunları yazdı:
>>>>
>>>>> Are you 100% sure that you get a new instance of the Consumer (and
>>>>> therefore, the UoW and the session) every time a message is received?
>>>>> That's very important.
>>>>>
>>>>> Weird object reference errors are typical of thread safety issues.
>>>>>
>>>>> /G
>>>>>
>>>>>
>>>>>
>>>> --
>>>
>> You received this message because you are subscribed to the Google Groups
>>> "nhusers" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>>
>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/nhusers/b422eb7c-9561-4a90-bc63-6ccbcd810e39n%40googlegroups.com
>>> <https://groups.google.com/d/msgid/nhusers/b422eb7c-9561-4a90-bc63-6ccbcd810e39n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/nhusers/4eb1b2af-7754-4b8e-b93e-970e53da8755n%40googlegroups.com
> <https://groups.google.com/d/msgid/nhusers/4eb1b2af-7754-4b8e-b93e-970e53da8755n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
______________________________________
Felipe B Oriani
[email protected]
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/nhusers/CANHAVGfwdpx%2BC%2BuQ3Uk2HnG3amX-r3U07K8qx0vK--bE%2B%2B%3DGZQ%40mail.gmail.com.
