Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
  • Help Room /
avatar image
0
Question by kdahlen · Jun 29, 2021 at 12:14 PM · sqlite

Problem opening libsqlite3.0.dylib in Unity on MacOS

Background:

We have an application for office pause gymnastics. A user defined number of times a day, our app notifies the user to do a couple of exercises to prevent occupational injuries.

There is three parts of the application:
-The Player where the exercises are shown with instructions
-A launcher that keeps track of time and notifies the user that its time to do exercises
-A DBUpgrade app that updates the database if a new version is installed.

The player was written in Unity with the mono runtime. It communicated with the database to read settings and language specific texts.

The launcher was written in ObjectiveC for Mac and .NET for Windows

The DBUpgrade app was written in mono.

All worked fine on all Macs (and on Windows) so far.

In February 2021 we made following changes:
Started signing the application with Apple, and ran into problems signing the DBUpgrade application, so we switched to .NET 6 Preview 1 for it.
.NET 6 Preview 1 had built in support for sqlite and was easily signed.

The app was signed and sent to customers having MacOS.

From then on, several bug reports came in, claiming the app wasn't working. Not all, but some of the MacOS users just got a white screen, nothing happened when the app started.

Problem:
The Player.log has theese lines in them:

Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib.so Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib.bundle Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib.so Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib.bundle Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib.so Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib.bundle Fallback handler could not load library /Applications/Pausit.app/Contents/Applications/Pausit.app/Contents/Frameworks/MonoEmbedRuntime/osx/libsqlite3.0.dylib DllNotFoundException: libsqlite3.0.dylib at (wrapper managed-to-native)
Mono.Data.Sqlite.UnsafeNativeMethods.sqlite3_open_v2(byte[],intptr&,int,intptr) at Mono.Data.Sqlite.SQLite3.Open (System.String strFilename, Mono.Data.Sqlite.SQLiteOpenFlagsEnum flags, System.Int32 maxPoolSize, System.Boolean usePool) [0x00046] in :0 at Mono.Data.Sqlite.SqliteConnection.Open () [0x0021a] in :0 at Database.DisposableDbConnection..ctor () [0x00027] in :0 at Services.DatabaseService.GetSettings () [0x00006] in :0 at Services.SettingsService.GetSettings () [0x00009] in :0 at Services.SettingsService.Initialize () [0x00000] in :0 at Bootstrapper.Awake () [0x00000] in :0
(Filename: Line: 0)
DllNotFoundException: libsqlite3.0.dylib at (wrapper managed-to-native) Mono.Data.Sqlite.UnsafeNativeMethods.sqlite3_open_v2(byte[],intptr&,int,intptr) at Mono.Data.Sqlite.SQLite3.Open (System.String strFilename, Mono.Data.Sqlite.SQLiteOpenFlagsEnum flags, System.Int32 maxPoolSize, System.Boolean usePool) [0x00046] in :0 at Mono.Data.Sqlite.SqliteConnection.Open () [0x0021a] in :0 at Database.DisposableDbConnection..ctor () [0x00027] in :0 at Services.DatabaseService.GetSettings () [0x00006] in :0 at Services.SettingsService.GetSettings () [0x00009] in :0 at SceneSelector.LoadStartScene (System.Boolean shouldLoadPlayer) [0x00003] in :0 at SceneSelector.Start () [0x0003c] in :0
(Filename: Line: 0)

We have tried to manually add the libsqlite3.0.dylib as a Plugin, with no success.
We found this bug (https://issuetracker.unity3d.com/issues/macos-native-plugins-not-detected-or-misplaced-in-builds) but after upgrading to latest 2019-version (2019.4.28f1) it still didn't work.


This happens to SOME of the MacOs users, not all. So its hard to reproduce. The test macs we have at our disposal does not get this problem.

Any help or ideas would be appreciated!

Comment
Add comment
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

0 Replies

· Add your reply
  • Sort: 

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

160 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

assign objects to strings from SQLite table 0 Answers

Moving a file from the project folder to the data directory at runtime 1 Answer

iOS can't connect to SQLite DB 1 Answer

SQLite exception on Android 0 Answers

Sqlite memory leak causing game to crash 0 Answers


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges