• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
Locked
0

SQLLite implementation freezes device

Explorer ,
Mar 14, 2017 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

327

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
community guidelines
Adobe Employee ,
Mar 14, 2017 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)

Votes

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
community guidelines
Adobe Employee ,
Mar 14, 2017 Mar 14, 2017

Copy link to clipboard

Copied

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

Votes

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
community guidelines
Explorer ,
Mar 17, 2017 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

Votes

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
community guidelines
Explorer ,
Mar 17, 2017 Mar 17, 2017

Copy link to clipboard

Copied

LATEST

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

Votes

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
community guidelines