open failed in ios 15.2

[jiangzhiguo1992]

After ios upgrade to 15.2.1, encrypted database open failed.

sqflite: ^2.0.2
sqflite_sqlcipher: ^2.1.0

2022-01-24 17:26:59.672175+0800 Runner[2338:552005] Unknown error calling sqlite3_step (26: file is not a database) rs
2022-01-24 17:26:59.672959+0800 Runner[2338:552005] Unknown error calling sqlite3_step (26: file is not a database) eu
2022-01-24 17:26:59.673004+0800 Runner[2338:552005] DB Query: BEGIN EXCLUSIVE
2022-01-24 17:26:59.673042+0800 Runner[2338:552005] Unknown error finalizing or resetting statement (26: file is not a database)
2022-01-24 17:26:59.673064+0800 Runner[2338:552005] DB Query: BEGIN EXCLUSIVE
2022-01-24 17:26:59.673328+0800 Runner[2338:552009] flutter: 17:26:59：error DatabaseException(Error Domain=FMDatabase Code=26 "file is not a database" UserInfo={NSLocalizedDescription=file is not a database}) sql 'BEGIN EXCLUSIVE' args [] during open, closing...
2022-01-24 17:26:59.673465+0800 Runner[2338:552005] Error calling sqlite3_step (1: cannot rollback - no transaction is active) SQLITE_ERROR
2022-01-24 17:26:59.673507+0800 Runner[2338:552005] DB Query: ROLLBACK
2022-01-24 17:26:59.673540+0800 Runner[2338:552005] Unknown error finalizing or resetting statement (1: cannot rollback - no transaction is active)
2022-01-24 17:26:59.673568+0800 Runner[2338:552005] DB Query: ROLLBACK

[jiangzhiguo1992]

Has anyone encountered this problem?

[davidmartos96]

Can you run the following to check if SQLCipher is being loaded properly?

final db = await openDatabase(":memory:");
final rows = await db.rawQuery("PRAGMA cipher_version");
print(rows[0]);

It should say something like "SQLCipher Community version 4.x"
If it does not, could you share your pubspec file?

[davidmartos96]

And another thing I've just noticed. You shouldn't need both sqflite and sqflite_sqlcipher in the pubspec. This library already exposes the same functions and API from sqflite

[jiangzhiguo1992]

PRAGMA return null and my problem is the same as described in this link https://developer.apple.com/forums/thread/697001

[jiangzhiguo1992]

this is my pubspec.yaml

environment:
sdk: ">=2.12.0 <3.0.0"

dependencies:
flutter:
sdk: flutter
flutter_localizations:
sdk: flutter

image_picker: ^0.8.4
local_auth: ^1.1.7
package_info_plus: ^1.0.6
device_info_plus: ^2.1.0
share_plus: ^2.1.4
connectivity_plus: ^2.2.0
path_provider: ^2.0.3
shared_preferences: ^2.0.7
url_launcher: ^6.0.2

flutter_bloc: ^7.2.0
equatable: ^2.0.3
synchronized: ^3.0.0
dio: ^4.0.0
get_it: ^7.2.0
uuid: ^3.0.4
crypto: ^3.0.1
mime_type: ^1.0.0
permission_handler: ^8.1.6
vibration: ^1.7.3
flutter_local_notifications: ^8.2.0
background_fetch: ^1.0.1

logger: ^1.1.0
sentry_flutter: ^6.0.1

intl: ^0.17.0
flutter_cupertino_localizations: ^1.0.1

flutter_secure_storage: ^4.2.1
sqflite: ^2.0.0+4
sqflite_sqlcipher: ^2.0.0

flutter_screenutil: ^5.0.0+2
animations: ^2.0.1
bot_toast: ^4.0.1
flutter_spinkit: ^5.1.0
flutter_markdown: ^0.6.6
flutter_slidable: ^0.6.0

flutter_svg: ^0.22.0
font_awesome_flutter: ^9.1.0
cupertino_icons: ^1.0.3

path: ^1.8.0
file_picker: ^4.0.3

photo_view: ^0.12.0
flutter_image_compress: ^1.0.0
image_cropper: ^1.4.1

flutter_sound: ^8.3.10

qr_code_scanner: ^0.5.2
qr_flutter: ^4.0.0

web3dart: ^2.3.1

nkn_sdk_flutter:
path: ./plugins/nkn-sdk-flutter

dev_dependencies:
flutter_test:
sdk: flutter

flutter:

uses-material-design: true

assets:
- assets/
- assets/contact/
- assets/icons/
- assets/chat/
- assets/wallet/
- assets/splash/

flutter_intl:
enabled: true

[davidmartos96]

There is another thing you can try. There was one time when SQLCipher was not being loaded for me because one native dependency on iOS was linking explicitly with SQLite.
What fixed it for me was the following:
Put -framework SQLCipher in "Other Linker Flags" in your project's settings on XCode.

Unfortunately I don't know what else could be happening. An app I have with this package works correctly on iOS 15.2

[jiangzhiguo1992]

I just checked my "Other Linker Flags" and it always has "-framework SQLCipher" in it.
In fact my app also works on ios15.2. But if I install the app in ios14.x version and upgrade to ios15.2, the database will fail to open.
You can try to install the demo on ios14.x, then upgrade to 15.2 and see if it will appear.

[davidmartos96]

That sounds really odd. I don't see how an iOS upgrade can affect the SQLCipher library in the app binary.
Out of curiosity, how are you handling downgrading and upgrading the device to different iOS versions. Can you do it with the simulator?

[jiangzhiguo1992]

I haven't tried the emulator, but all users in my app who upgraded to ios15.2 had this problem.

[jiangzhiguo1992]

It suddenly occurred to me that the emulator cannot be upgraded.

[jiangzhiguo1992]

I have the same problem after upgrading to iOS 15.2 on my own phone.

[davidmartos96]

Can you try to reproduce it in the example app of this repository? That way we could tell if it's related to this or is some other issue.

[jiangzhiguo1992]

I haven't been able to reproduce the issue yet because I don't have the right equipment around.
But I deleted the code in my app, only the database open operation is left, and the error still exists.
And after I uninstalled and reinstalled the app, there is no such problem.

[davidmartos96]

You should try without any other dependency in the pubspec. I have a feeling that it could be a conflict with some dependency.
If you don't get the error with just sqflite_sqlcipher, then start adding the rest of dependencies until it starts failing

[navjyot11singh]

Not able to access database when updating in android 15.2 and above. Same issue