Re: [sqlite] Issue with SQLite3 for WinRT ARM

[Richard Hipp]

On Fri, Sep 28, 2012 at 9:15 AM, Richard Hipp  wrote:

>
>
> On Fri, Sep 28, 2012 at 9:06 AM, Clemens Ladisch wrote:
>
>> Christian Le Gall wrote:
>> > I have included an example project
>>
>> ... and the mailing list server has stripped it.
>> Please put it somewhere on the web.
>>
>
> The SQLite developers got the project files last night, through a
> back-channel.  We are working the problem now.
>
> Our best theory so far is that this is a compiler bug.  But we haven't
> proven that yet.  As I said, we are still working the problem...
>

We have no confirmed that the problem was in the ARM optimizer on the
latest version of MSVC.  We have checked in a change to SQLite to work
around the problem here:

http://www.sqlite.org/src/info/9fab9edd0d


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with SQLite3 for WinRT ARM

[Black, Michael (IS)]

I took a wee bit of a look at your project -- don't have Win 8 so can't debug 
it.
And you didn't include the sqlite assembly anyways.

But...if I read your comments correctly it appears that the primary difference 
between what works and what doesn't is the size of the SQL string.

So...this sounds a lot like stack corruption to me.  Perhaps stack size?

#1 -- Put in a breakpoint on your stack size and see if it gets hit  -- see 
this -- 
http://stackoverflow.com/questions/11667440/monitoring-call-stack-size-in-visual-studio
#2 -- strdup(sql.c_str()) and free it inside your exec function.  Just to 
ensure it's not some other funky thing going on.
#3 -- Show the length of the SQL it when it runs.
#4 -- reduce the create SQL string until it works..which I'm guessing it 
eventually will.

Let us know the results.



Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Christian Le Gall [firemanchr...@gmail.com]
Sent: Friday, September 28, 2012 6:14 PM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Issue with SQLite3 for WinRT ARM

Sorry about that.

Here is the project:
http://dl.dropbox.com/u/4076650/Direct3DApp_ProblemExample.zip

> This typically indicates a bug in your program, such as threading
> issues, objects used after being freed, or just general memory
> corruption.

Typically I would agree with you but in the case above I have replicated
the issue in a stripped down example project so there should be no rogue
memory allocation or threading happening. It even happens if you comment
out all unnecessary calls so all you're left with is an empty Metro
application and it still happens on ARM. I've sent this to Microsoft
developer support who tell me it is most likely a problem with SQLite.

Regards,

Christian.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with SQLite3 for WinRT ARM

[Christian Le Gall]

Sorry about that.

Here is the project:
http://dl.dropbox.com/u/4076650/Direct3DApp_ProblemExample.zip

> This typically indicates a bug in your program, such as threading
> issues, objects used after being freed, or just general memory
> corruption.

Typically I would agree with you but in the case above I have replicated
the issue in a stripped down example project so there should be no rogue
memory allocation or threading happening. It even happens if you comment
out all unnecessary calls so all you're left with is an empty Metro
application and it still happens on ARM. I've sent this to Microsoft
developer support who tell me it is most likely a problem with SQLite.

Regards,

Christian.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with SQLite3 for WinRT ARM

[Richard Hipp]

On Fri, Sep 28, 2012 at 9:06 AM, Clemens Ladisch  wrote:

> Christian Le Gall wrote:
> > I have included an example project
>
> ... and the mailing list server has stripped it.
> Please put it somewhere on the web.
>

The SQLite developers got the project files last night, through a
back-channel.  We are working the problem now.

Our best theory so far is that this is a compiler bug.  But we haven't
proven that yet.  As I said, we are still working the problem...


>
> > The error I am getting is generally "critical error detected c000374"
> which
> > my research tells me is a corrupted heap.
>
> This typically indicates a bug in your program, such as threading
> issues, objects used after being freed, or just general memory
> corruption.
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Issue with SQLite3 for WinRT ARM

[Clemens Ladisch]

Christian Le Gall wrote:
> I have included an example project

... and the mailing list server has stripped it.
Please put it somewhere on the web.

> The error I am getting is generally "critical error detected c000374" which
> my research tells me is a corrupted heap.

This typically indicates a bug in your program, such as threading
issues, objects used after being freed, or just general memory
corruption.


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Issue with SQLite3 for WinRT ARM

[Christian Le Gall]

Hey,

We need to use SQLite3 for a game we are building on the WinRT platform,
the same codebase has worked for a long time but doesn't work when
compiling for the WinRT ARM platform. I have tried using the SQLite for
Windows Runtime Visual Studio extension (visx) as well as the latest source
amalgamation directly but experience the same issue with both.

I have included an example project that demonstrates the issue when
compiling for ARM (it works targeting x86). If you compile as is you should
experience the error I've been getting. In the Direct3DApp2.cpp there are
some strings with SQL statements in the SetWindow method. There are some
lines commented, if you uncomment them and comment the block below it will
work. A simple change in order of execution and it works. Surely there is
more going on behind the scenes here than I am aware of.

The error I am getting is generally "critical error detected c000374" which
my research tells me is a corrupted heap.

Has anyone else experienced issues on WinRT ARM platform? Is there anything
I can do or a newer version I can get?

Any help appreciated.

Note: The project is for Visual Studio 2012 and to replicate the issue you
need to be building to an ARM device.

Regards,

Christian.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users