IncludeUserNameInFilter causes hang while searching

Published 2 years ago

Searching while including username causes the application to hang.

Version 2023.2.2.4 on Kubuntu 22.04

Following config without IncludeUserNameInFilter works.

<?xml version="1.0" encoding="utf-8"?>
<Option>
  <ApplicationKnownCertificatesArray />
  <DefaultTerminalEmulator>konsole</DefaultTerminalEmulator>
  <ResolvePMProURLIntoIPAddress>false</ResolvePMProURLIntoIPAddress>
  <BeforeConnectionEventMessagePromptMode>Default</BeforeConnectionEventMessagePromptMode>
  <CreationDate>2023-09-28T00:00:00-05:00</CreationDate>
  <DefaultCredentialEntryAction>CopyPassword</DefaultCredentialEntryAction>
  <DefaultGroupEntryAction>CopyPassword</DefaultGroupEntryAction>
  <DwlKeyArray />
  <IncludeHostInFilter>true</IncludeHostInFilter>
  <IncludeTypeInFilter>true</IncludeTypeInFilter>
  <IncludeUserNameInFilter>true</IncludeUserNameInFilter>
  <KeePassOnlyFilterOnEnter>Default</KeePassOnlyFilterOnEnter>
  <LoginAttemptDateFilter>Today</LoginAttemptDateFilter>
  <LoginAttemptDateUsed>false</LoginAttemptDateUsed>
  <MinimizeOnClose>true</MinimizeOnClose>
  <NewTwoFactorUpgrade>true</NewTwoFactorUpgrade>
  <OptionsLoaded>false</OptionsLoaded>
  <PasswordGenerator>
    <ID>REDACTED</ID>
  </PasswordGenerator>
  <RDMOUrl>https://cloud.devolutions.net/</RDMOUrl>
  <RDPScreenSizingMode>DynamicResolution</RDPScreenSizingMode>
  <ConsultedFeedbackIDArray />
  <Style>DockingRibbon</Style>
  <Terminal>
    <Font>Sans 12</Font>
    <FontHeight>12</FontHeight>
    <SyntaxHighlightingItemArray />
    <X11Protocol>Default</X11Protocol>
  </Terminal>
  <TerminalCursorType>Default</TerminalCursorType>
  <TerminalCursorBlink>Default</TerminalCursorBlink>
  <TodoFilterOption />
  <TodoRefreshDelay>2</TodoRefreshDelay>
  <Token>REDACTED</Token>
  <UpdateRepositoryUri>https://devolutions.net/products.htm</UpdateRepositoryUri>
  <UseOpenGLRenderingInVNC>false</UseOpenGLRenderingInVNC>
  <UserAccessDateFilter>LastWeek</UserAccessDateFilter>
  <UserAccessDateKind>OriginalTime</UserAccessDateKind>
  <UserAccessEndDate p2:nil="true" xmlns:p2="http://www.w3.org/2001/XMLSchema-instance" />
  <UserAccessStartDate p2:nil="true" xmlns:p2="http://www.w3.org/2001/XMLSchema-instance" />
  <VideoRecorderFrameRate>5</VideoRecorderFrameRate>
  <VideoRecorderMonitor>Primary</VideoRecorderMonitor>
  <WebPrivateSessionMode>Enabled</WebPrivateSessionMode>
</Option>

All Comments (9)

Simon Duguay Létourneau

Published 2 years ago

Hello,

We'll look into the issue and get back to you.

Regards,

Simon Duguay Létourneau

Simon Duguay Létourneau

Published 2 years ago

I was able to reproduce your problem using a SQL Server data source with many connections.

Could you tell me what type of data source you're using and how many connections it contains?

Simon Duguay Létourneau

lfudala

Published 2 years ago

I can almost guarantee I had the only active connection for RDM at the time (2am). The only other DB on the server likely only had one idle connection for the app which is mostly idle at the time.

I was connected over a VPN connection, however. This is how I normally connect. Sounds like something changed and the latency is causing an issue.

Maybe related.

I haven't found a way to manually go offline.
Sometimes I end up in offline mode. Changing entries has a huge delay, which I believe is the timeout looking for the SQL server.
I found the setting to automatically go offline in the data source and this only seems to make entries available for things that previously weren't when offline, like viewing password. I still get prompted for checking network when performing actions.
The "Manage Cache" has no output.
Caching mode is set to File.
Offline engine is default: MCDF v2.0
Right-clicking the tray icon DOES respond after about 30 seconds while the app itself is frozen. Selecting any of the options has no effect on the app.

It hangs when offline, as well. I suspect this is related to it trying to access the DB still and there not being a mode where it just stays offline.

Simon Duguay Létourneau

Published 2 years ago

Hello,

I may have found an issue that is causing some of your problems.

We often check internet connectivity when performing certain actions in RDM, including searching with the search menu, and, in my case, this is the cause of the slowness and hangs I get on SQL Server. It may also be the cause of some of your problems.

I've tried changing the way we check internet connectivity and that's helped a lot, plus it fixes the blocking when IncludeUserNameInFilter is enabled.

Before digging deeper into your problems with offline mode, we'll wait for you to try this fix when the update is available. Maybe it will solve some of your problems.

The update should arrive sometime next week.

Kind regards,

Simon Duguay Létourneau

lfudala

Published 2 years ago

Thanks, I'll update once it drops and I test.

Simon Duguay Létourneau

Published 2 years ago

Hello,

Our new update 2023.2.2.5 is now available and should solve your hang issue when doing a search.

Let me know if this has solved any other problems you may have encountered.

Regards,

Simon Duguay Létourneau

lfudala

Published 2 years ago

Can confirm that the search issue is fixed.

Looks like it still attempts repeatedly to try the database when offline. Is there a way to force/stay offline to prevent consistently trying the database and waiting for that to fail to switch records?

Simon Duguay Létourneau

Published 2 years ago

Hello,

I have tried to perform some actions in offline mode and everything seems to be fine for me. Can you send me a video showing the issue you get?

Simon Duguay Létourneau

lfudala

Published 2 years ago

Hi Simon,

Returned to this today to capture the behaviour and it appears that at some point since this was solved.
Previously it would lag with every character press or tree navigation action while disconnected, waiting for a connection timeout.

Cheers