Qiqqa sync issues under Parallels

[aterhorst]

I run Qiqqa on a Mac using Parallels.

I ran into sync issues (cannot open database). The intranet library path was //mac/home/... By mapping a network drive the problem went away. It appears SQLlite requires a drive letter rather than a network path.

[GerHobbelt]

👍 Thanks for reporting! Hadn't tested with network paths like that yet myself; not a fix yet (and will take some time to get this fixed, I expect) as this smells like at least sideways related to #257 -- the short story there and here being that SQLite itself has problems with networked storage (officially it's not supported by them).

FYI:

Yours is a different problem than #257 at a technical level (that one is the dreaded SQLite error -14) but it's related for me at least as these both are dependent on one of the Qiqqa subprojects, where I'm looking into migration of (with an eye for #215 - Linux support in the future) the [database+processing] Qiqqa backend. For right now I'm a bit stuck as SQLite.NET won't support network paths like yours AFAICT.

For now, you'll need a drive letter at least, so paths must look like Z:\directory\.... -- I'm glad you reported this as I missed it and thus serves as a strong reminder now to make sure I test the new codebase against network-mapped drives as more folks will suffer from this issue in the future when the new Sync mechanism finally sees the light - as Qiqqa Sync (#257 et al) includes mirroring the Qiqqa libraries, each of which is an SQLite database!

[aterhorst]

Great. I also found with Parallels if I set graphics to "Scaled - Graphics scaled to full-size, best for legacy applications", Qiqqa stops freezing. It does close down without warning every now and then, but overall it's more stable.

---

From: Ger Hobbelt @.> Sent: 23 September 2021 02:37 To: jimmejardine/qiqqa-open-source @.> Cc: Terhorst, Andrew (Data61, Sandy Bay) @.>; Author @.> Subject: Re: [jimmejardine/qiqqa-open-source] Qiqqa sync issues under Parallels (#354)

👍 Thanks for reporting! Hadn't tested with network paths like that yet myself; not a fix yet (and will take some time to get this fixed, I expect) as this smells like at least sideways related to #257https://github.com/jimmejardine/qiqqa-open-source/issues/257 -- the short story there and here being that SQLite itself has problems with networked storage (officially it's not supported by them).

FYI:

Yours is a different problem than #257https://github.com/jimmejardine/qiqqa-open-source/issues/257 at a technical level (that one is the dreaded SQLite error -14) but it's related for me at least as these both are dependent on one of the Qiqqa subprojects, where I'm looking into migration of (with an eye for #215https://github.com/jimmejardine/qiqqa-open-source/issues/215 - Linux support in the future) the [database+processing] Qiqqa backend. For right now I'm a bit stuck as SQLite.NET won't support network paths like yours AFAICT.

For now, you'll need a drive letter at least, so paths must look like Z:\directory.... -- I'm glad you reported this as I missed it and thus serves as a strong reminder now to make sure I test the new codebase against network-mapped drives as more folks will suffer from this issue in the future when the new Sync mechanism finally sees the light - as Qiqqa Sync (#257https://github.com/jimmejardine/qiqqa-open-source/issues/257 et al) includes mirroring the Qiqqa libraries, each of which is an SQLite database!

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/jimmejardine/qiqqa-open-source/issues/354#issuecomment-925096816, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABYGZCYPR4ENVZ4QNB6JSZ3UDIA6PANCNFSM5DKEVKDA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.