SQLLite implementation freezes device

Hi Rakshit,

I forgot something.... the only more seldom operation on the SQLLite database we conduct is that we have a game state table into which/from which we serialize a class (automatically).

The table is created through

"CREATE TABLE IF NOT EXISTS gamestate (" + 

                "    puzzleId INTEGER PRIMARY KEY, " + 

                "    data Object "+                  

                ")";

And we use:

Thanks,

Henning

Hello Rakshit,

unfortunately the bug cannot be reproduced (on my side) with a systematic POC as it occures rather "randomly" (in different situations, different times, different screens), which speaks for a "thread working parallel in the background like SQLLite).

We just published a new app version without any fancy (no Stage3D/starling this time, no native extensions etc.)

The only fancy it uses is a SQLLite database (that is this time not even encrypted).

Amazon.com: Crosswords Light: Appstore for Android

After a week already the first customers complain about a "freezing" app that requires a rebooting of the device. The same issues occur since a year on our other (more sophisticated) crossword app. The affected may have an updated device of the newest Kindle Fire generation. It is not a memory issue. Please have a look.

Thanks,

Henning

Also, you can email me the link @ rsareen@adobe.com

Hi,

Thank you for reaching out to us. Can you please provide a POC which reproduces the bug. We will be able to narrow down the issue using that. Please post the POC in a dropbox and paste the link here.

Regards

Rakshit (ADOBE AIR Team)