Library on network drive not working on macOS

[Rachel030219]

Describe the bug
Rune stops working when creating a library on a remote drive attached with Finder -> Go -> Connect to server.

flutter run log:

Launching lib/main.dart on macOS in debug mode...
--- xcodebuild: WARNING: Using the first of multiple matching destinations:
{ platform:macOS, arch:arm64, id:00008103-0001093E3E40801E, name:My Mac }
{ platform:macOS, arch:x86_64, id:00008103-0001093E3E40801E, name:My Mac }
Building macOS application...
✓ Built build/macos/Build/Products/Debug/player.app
2024-10-12 08:41:11.072 player[60311:5633503] WARNING: Secure coding is automatically enabled for restorable state! However, not on all supported macOS versions of this application. Opt-in to secure coding explicitly by implementing NSApplicationDelegate.applicationSupportsSecureRestorableState:.
package:fluent_ui has `uses-material-design: true` set but the primary pubspec contains `uses-material-design: false`. If the application needs material icons, then `uses-material-design`  must be set
to true.
Syncing files to device macOS...                                    66ms

Flutter run key commands.
r Hot reload. 🔥🔥🔥
R Hot restart.
h List all available interactive commands.
d Detach (terminate "flutter run" but leave application running).
c Clear the screen
q Quit (terminate the application on the device).

A Dart VM Service on macOS is available at: http://127.0.0.1:51410/CyQ2A2-XUh4=/
The Flutter DevTools debugger and profiler on macOS is available at: http://127.0.0.1:9100?uri=http://127.0.0.1:51410/CyQ2A2-XUh4=/
resolved bookmark to: file:///Volumes/ExosSMB/Music/FromLaptop/ (false)
flutter: Device is not Windows 10, skip the patch
2024-10-12T00:41:14.914069Z  INFO hub::connection: Received path: /Volumes/ExosSMB/Music/FromLaptop
2024-10-12T00:41:14.914179Z  INFO hub: Media Library Received, initialize other receivers
2024-10-12T00:41:14.914637Z  INFO hub: Initializing database
2024-10-12T00:41:14.918701Z  INFO database::connection: Initializing main database: /Volumes/ExosSMB/Music/FromLaptop/.rune/.0.db
2024-10-12T00:41:15.367784Z  INFO database::connection: Initializing recommendation database: /Volumes/ExosSMB/Music/FromLaptop/.rune/.analysis
2024-10-12T00:41:15.412741Z  INFO tantivy::indexer::segment_updater: save metas
2024-10-12T00:41:15.413377Z ERROR hub: Failed to connect to search DB: An IO error occurred: 'Operation not supported (os error 45)'

To Reproduce
Steps to reproduce the behavior:

1. Attach a network drive
2. Select it as new library location
3. See error

Additional context
flutter doctor -v result:

$ flutter doctor -v

[✓] Flutter (Channel stable, 3.24.3, on macOS 14.5 23F79 darwin-arm64, locale en-US)
    • Flutter version 3.24.3 on channel stable at /opt/homebrew/Caskroom/flutter/3.22.2/flutter
    • Upstream repository https://github.com/flutter/flutter.git
    • Framework revision 2663184aa7 (4 weeks ago), 2024-09-11 16:27:48 -0500
    • Engine revision 36335019a8
    • Dart version 3.5.3
    • DevTools version 2.37.3
    • Pub download mirror https://pub.flutter-io.cn
    • Flutter download mirror https://storage.flutter-io.cn

[!] Android toolchain - develop for Android devices (Android SDK version 34.0.0)
    • Android SDK at /Users/rachel/Library/Android/sdk
    • Platform android-34, build-tools 34.0.0
    • Java binary at: /Applications/Android Studio.app/Contents/jbr/Contents/Home/bin/java
    • Java version OpenJDK Runtime Environment (build 17.0.10+0-17.0.10b1087.21-11609105)
    ! Some Android licenses not accepted. To resolve this, run: flutter doctor --android-licenses

[!] Xcode - develop for iOS and macOS (Xcode 15.4)
    • Xcode at /Applications/Xcode.app/Contents/Developer
    • Build 15F31d
    ✗ Unable to get list of installed Simulator runtimes.
    • CocoaPods version 1.15.2

[✓] Chrome - develop for the web
    • Chrome at /Applications/Google Chrome.app/Contents/MacOS/Google Chrome

[✓] Android Studio (version 2024.1)
    • Android Studio at /Applications/Android Studio.app/Contents
    • Flutter plugin can be installed from:
      🔨 https://plugins.jetbrains.com/plugin/9212-flutter
    • Dart plugin can be installed from:
      🔨 https://plugins.jetbrains.com/plugin/6351-dart
    • Java version OpenJDK Runtime Environment (build 17.0.10+0-17.0.10b1087.21-11609105)

[✓] IntelliJ IDEA Community Edition (version 2023.2)
    • IntelliJ at /Applications/IntelliJ IDEA CE.app
    • Flutter plugin can be installed from:
      🔨 https://plugins.jetbrains.com/plugin/9212-flutter
    • Dart plugin can be installed from:
      🔨 https://plugins.jetbrains.com/plugin/6351-dart

[✓] VS Code (version 1.93.1)
    • VS Code at /Applications/Visual Studio Code.app/Contents
    • Flutter extension version 3.98.0

[✓] Connected device (3 available)
    • macOS (desktop)                 • macos                 • darwin-arm64   • macOS 14.5 23F79 darwin-arm64
    • Mac Designed for iPad (desktop) • mac-designed-for-ipad • darwin         • macOS 14.5 23F79 darwin-arm64
    • Chrome (web)                    • chrome                • web-javascript • Google Chrome 126.0.6478.183

[✓] Network resources
    • All expected network resources are available.

! Doctor found issues in 2 categories.

[Losses]

The same thing also happens on Windows, both sqlx and tantivy need to be tweaked to make this work