All Saved Connections lost when opening a second window

[johnmadrak]

Describe the bug

I recently installed Antares and created all of my saved connections manually via the UI.

While using the client, I attempted to open a second window. When the second window opened, all of my saved connections were gone in that window.

After closing both windows and opening a new window, my saved connections were also gone.

I then reproduced the issue with a single saved connection.

To Reproduce
Steps to reproduce the behavior:

1. Install Antares SQL.
2. Save a connection.
3. Right click the app in the task bar and click "New Window."
4. See there are no saved connections in the new window.
5. Close all windows and open a new window.
6. See there are still no saved connections in the new window.

Expected behavior

I can open multiple windows without losing my saved connections.

Screenshots

Not applicable.

Application (please complete the following information):

• App Client: PostgreSQL, MySQL, SQLite (Possibly the rest too)
• App Version: Version 0.7.30
• Installation Source: Pop Shop (which installed the Flatpak)

Environment (please complete the following information):

• OS name: Pop OS
• OS version: 22.04 LTS
• DB name: Not Applicable
• DB version: Not Applicable

Additional context

N/A

[Fabio286]

Hi John,
i found that if after installation at first Antares run if you open multiple windows you lose your connections.
However if you close Antares and reopen then you create connections the problem never happens again.
Is the same for you?

[johnmadrak]

Hello @Fabio286,

Unfortunately not. I did a fresh install to confirm.

Steps to reproduce the behavior:
1 - Install Antares
2 - Open Antares
3 - Close Antares
4 - Open Antares
5 - Create a connection and save it
6 - Close Antares
7 - Open Antares (Connection is there)
8 - Open a second window (Connection is not there)
9 - Close both windows
10 - Open Antares (Connection is not there)

[Fabio286]

Do you have any way to test if the same thing happens with the AppImage version?

The problem lies in the secrets store in that when a new window is opened, an encrypted key is required to decrypt connection data. If the secrets store cannot be accessed Antares will not open multiple windows. In your case, however, something is not quite right.
I tried from a clean installation of PopOS 22.04 but the only problem I found was the one I asked you to check 😔.
Would you be able to tell me if you made any custom configurations in your PopOS compared to the clean install? For example using a different desktop environment.

[johnmadrak]

@Fabio286

I was able to confirm that the AppImage version does not have the problem that I'm experiencing.

I'm not aware of any custom configurations that would be causing this issue, my setup is pretty standard.

Strangely, after testing the AppImage version I'm unable to reproduce the issue with the Flatpak version even though I had been able to reproduce it several times consistently in the past.

Could it be something strange about flatpak sandboxing and first-time user setup?

[Fabio286]

Could it be something strange about flatpak sandboxing and first-time user setup?

Yes, probably the issue is related to Antares in flatpak sandbox that lacks of permissions to create the encrypt key, but after creation it can read.