[AC-3089] Running a large number of queries on a database causes crash

Copy this code into a newly created project {noformat} var num_rows = 100; var dbname = 'user_db5.db'; var db = Titanium.Database.open(dbname); db.execute('DROP TABLE IF EXISTS playlist'); db.execute('CREATE TABLE IF NOT EXISTS playlist (category_id INTEGER KEY PRIMARY KEY)'); for(var i = 0; i < num_rows; ++i) { db.execute('INSERT INTO playlist(category_id) VALUES(?)', i); } db.close(); var win1 = Ti.UI.createWindow({backgroundColor:'blue'}); win1.addEventListener('focus', function(){ var db = Titanium.Database.open(dbname); for(var j = 0; j < num_rows * 100; ++j) { var r = j % 100; var rows = db.execute('SELECT * FROM playlist WHERE category_id=?', r); var id = rows.fieldByName('category_id'); Ti.API.info('id = ' + id); rows.close(); } db.close(); }); var win2 = Ti.UI.createWindow({backgroundColor:'red'}); var tab_group = Ti.UI.createTabGroup(); tab_group.addTab( Ti.UI.createTab({window:win1}) ); tab_group.addTab( Ti.UI.createTab({window:win2}) ); tab_group.open(); {noformat} Run in IOS simulator Switch between tabs until crash occurs. In Studio the application will just exit, running under XCode gives a EXC_BAD_ACCESS with the following callstack {noformat} #0 0x002d7bab in _Z4toJSPN2TI10TiExcStateEPK13OpaqueTiValue [inlined] at /Users/stiv/src/appcelerator/tijscore/TiCore/API:75 #1 0x002d7bab in TiObjectSetProperty at /Users/stiv/src/appcelerator/tijscore/TiCore/API/TiObjectRef.cpp:295 #2 0x00056291 in -[KrollObject noteObject:forTiString:context:] at /Users/martinslater/code/EasyLang/mobile/EasyLang Mobile/build/iphone/Classes/KrollObject.m:1302 #3 0x0005155b in KrollGetProperty () #4 0x002da7ff in TI::TiCallbackObject::getOwnPropertySlot(TI::TiExcState*, TI::Identifier const&, TI::PropertySlot&) () #5 0x002b8b2a in _ZN2TI6TiCell22fastGetOwnPropertySlotEPNS_10TiExcStateERKNS_10IdentifierERNS_12PropertySlotE [inlined] () #6 0x002b8b2a in TI::TiValue::get(TI::TiExcState*, TI::Identifier const&, TI::PropertySlot&) const () #7 0x002b6126 in cti_op_get_by_id_generic () #8 0x0c3f9746 in () #9 0x00273415 in TI::Interpreter::execute(TI::FunctionExecutable*, TI::TiExcState*, TI::TiFunction*, TI::TiObject*, TI::ArgList const&, TI::ScopeChainNode*, TI::TiValue*) at /Users/stiv/src/appcelerator/tijscore/TiCore/jit/JITCode.h:84 #10 0x002c4bed in TI::TiFunction::call(TI::TiExcState*, TI::TiValue, TI::ArgList const&) () #11 0x0023c30b in TI::call(TI::TiExcState*, TI::TiValue, TI::CallType, TI::CallData const&, TI::TiValue, TI::ArgList const&) () #12 0x002d7816 in TiObjectCallAsFunction () #13 0x00056d53 in -[KrollObject triggerEvent:withObject:thisObject:] () #14 0x000492a1 in -[KrollEvent invoke:] () #15 0x0004800d in -[KrollContext invoke:] () #16 0x00046bee in -[KrollContext main] () #17 0x0067acf4 in -[NSThread main] () {noformat} See [Q&A](http://developer.appcelerator.com/question/123951/crash-updating-window-from-focus-event-while-querying-database--ios-43--sdk-172)