Bug 26433 - [iOS] Trying to update rows in SQLite database crashes with SIGSEGV
Summary: [iOS] Trying to update rows in SQLite database crashes with SIGSEGV
Status: RESOLVED NORESPONSE
Alias: None
Product: iOS
Classification: Xamarin
Component: General ()
Version: XI 8.6.0
Hardware: PC Mac OS
: Normal normal
Target Milestone: Untriaged
Assignee: Bugzilla
URL:
Depends on:
Blocks:
 
Reported: 2015-01-26 16:43 UTC by Dominic N [MSFT]
Modified: 2016-05-26 21:23 UTC (History)
5 users (show)

Tags:
Is this bug a regression?: ---
Last known good build:

Notice (2018-05-24): bugzilla.xamarin.com is now in read-only mode.

Please join us on Visual Studio Developer Community and in the Xamarin and Mono organizations on GitHub to continue tracking issues. Bugzilla will remain available for reference in read-only mode. We will continue to work on open Bugzilla bugs, copy them to the new locations as needed for follow-up, and add the new items under Related Links.

Our sincere thanks to everyone who has contributed on this bug tracker over the years. Thanks also for your understanding as we make these adjustments and improvements for the future.


Please create a new report on Developer Community or GitHub with your current version information, steps to reproduce, and relevant error messages or log files if you are hitting an issue that looks similar to this resolved bug and you do not yet see a matching new report.

Related Links:
Status:
RESOLVED NORESPONSE

Description Dominic N [MSFT] 2015-01-26 16:43:24 UTC
## Overview

A customer has a Xamarin.iOS iPad app that connects to a SQLite database. There are a large number of rows that need to be inserted (86063). The app works until around 184, but then crashes with no output in the application output. In the log file from /Users/X/Library/Logs/iOS Simulator/7.1/system.log however there is the following error: https://gist.github.com/heiligerdankgesang/525a21e7187d7c87698d

The project will be attached in a private comment, but it gets data from a server available only to the customer. 


## Additional information

I have linked the customer to the following bug report, but it was not helpful as the customer indicates the app doesn't use multiple threads for SQLite: https://bugzilla.xamarin.com/show_bug.cgi?id=21492

The main thread is used for the UI (progressbar) and an async call (background thread) is used for the SQLite. Additionally, he is using Mono.Data.SQLite.SQLiteConnection and there is no property to set for SQLiteOpenFlags.FullMutex.


## Customer Version Information

Xamarin IOS:
Xamarin Studio
Version 5.5.3 (build 6)
Installation UUID: 53463fc6-500d-43ad-b83f-a3c839fcbb40
Runtime:
Mono 3.10.0 ((detached/e204655)
GTK+ 2.24.23 (Raleigh theme)

Package version: 310000023

Apple Developer Tools
Xcode 5.1 (5084)
Build 5B130a

Xamarin.Mac
Version:

Xamarin.Android
Version: 4.18.1 (Business Edition)
Android SDK: /Users/MbProg/Library/Developer/Xamarin/android-sdk-mac_x86
Supported Android versions:
2.1 (API level 7)
2.2 (API level 8)
2.3 (API level 10)
3.1 (API level 12)
4.0 (API level 14)
4.0.3 (API level 15)
Java SDK: /usr
java version "1.6.0_65"
Java(TM) SE Runtime Environment (build 1.6.0_65-b14-462-11M4609)
Java HotSpot(TM) 64-Bit Server VM (build 20.65-b04-462, mixed mode)

Xamarin.iOS
Version: 8.4.0.16 (Business Edition)
Hash: 80e9ff7
Branch:
Build date: 2014-10-22 15:09:12-0400
Comment 2 Sebastien Pouliot 2015-01-26 20:58:48 UTC
The attached source code does not build. Either we can duplicate this ourselves or we need more than partial log, minimally a symbolicated crash report to see which threads are involved.

> an async call (background thread) is used for the SQLite

That does not mean that every call with go to the _same_ thread.
Comment 3 MBProg 2015-02-10 02:13:22 UTC
The project is mine. Why aren't you able to build it?
Comment 4 Sebastien Pouliot 2015-02-16 16:12:35 UTC
Several assemblies are missing and the provided solution does not build.

Assembly 'Newtonsoft.Json' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'SatelliteMenu' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'AlertCenter.IOS' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'GunmetalTheme.iOS' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'Blounty.SlideDownMenu' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'GunmetalTheme.Controls.iOS.AlertView' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'GunmetalTheme.Controls.iOS.ProgressBar' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'GunmetalTheme.Controls.iOS.Switch' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'SQLite' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.
Assembly 'MBProgressHUD' not found. Make sure that the assembly exists in disk. If the reference is required to build the project you may get compilation errors.


If you use components then they should automatically download/install (but there still a risk that the versions won't match).
Comment 5 Sebastien Pouliot 2016-05-26 21:23:22 UTC
We have not received the requested information. If you are still experiencing this issue please provide all the requested information and re-open the bug report. Thanks!