Highlighted

SQLLite implementation freezes device

Explorer ,
Mar 14, 2017

Copy link to clipboard

Copied

Hello,

Adobe Air apps freeze on Amazon _Underground_. It happens quite randomly and everybody is affected at a certain point. I narrowed down the cause of all this to be likely the outdated SQLLite implementation we have in the AIR SDK. When the app freezes, most often the complete device is locked requiring a rebooting!

Please fix!

Thanks,

Henning

TOPICS
Performance issues

Views

229

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

SQLLite implementation freezes device

Explorer ,
Mar 14, 2017

Copy link to clipboard

Copied

Hello,

Adobe Air apps freeze on Amazon _Underground_. It happens quite randomly and everybody is affected at a certain point. I narrowed down the cause of all this to be likely the outdated SQLLite implementation we have in the AIR SDK. When the app freezes, most often the complete device is locked requiring a rebooting!

Please fix!

Thanks,

Henning

TOPICS
Performance issues

Views

230

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 14, 2017 0
Adobe Employee ,
Mar 14, 2017

Copy link to clipboard

Copied

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)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 14, 2017 0
Adobe Employee ,
Mar 14, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 14, 2017 0
Explorer ,
Mar 17, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 17, 2017 0
Devarai LATEST
Explorer ,
Mar 17, 2017

Copy link to clipboard

Copied

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:

   flash.net.registerClassAlias("TableCellSt", TableCellState);
   registerClassAlias("PuzzleSt", PuzzleState);
   flash.net.registerClassAlias("AnArray", Array);

Thanks,

Henning

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 17, 2017 0