[sqlite] BUG: Documentation of API have incorrect anchors...

[Rob Wehrli]

From: http://www.sqlite.org/c3ref/funclist.html

All of these functions have the same anchor:

http://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupfinish

sqlite3_backup_finish
sqlite3_backup_init
sqlite3_backup_pagecount
sqlite3_backup_remaining
sqlite3_backup_step

...and since the "backup_finish.html" seems to have suitable anchors for 
each of these functions, it would be useful to modify funclist.html to 
match.



Take Care.

Rob!



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

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Frantz FISCHER]

Hi Scott,


Indeed, just saw the release notes. Will give it a try!


Thanks,

Frantz.


On 01/09/2016 17:29, Scott Robison wrote:

In looking at the changelog for 2.7.12, I see multiple SQLite related
Python fixes that addressed coredump bugs.

On Sep 1, 2016 9:22 AM, "Scott Robison"  wrote:


It appears 2.7.12 is available. Perhaps it is worth trying.

On Sep 1, 2016 9:19 AM, "Frantz FISCHER"  wrote:


Hello,


2.7.10 python own release.

Got another crash mentioning the _pylite3.pyd module as you suspected
before.


Thanks,

Frantz.


On 01/09/2016 17:00, Scott Robison wrote:


Specifically, what version / distribution of Python 2 is in use? Python's
own release, ActiveState, other?

On Sep 1, 2016 8:27 AM, "Frantz FISCHER"  wrote:

Hello Richard,


Thank you for your answer!

Could you please tell me which details you would require?

I managed to get a windows mini dump, would that be of any help?

This is the default sqlite3.dll bundled with python 2.7. Do you require
the python module? the dll itself?


Regards,

Frantz.


On 01/09/2016 14:33, Richard Hipp wrote:

On 9/1/16, Frantz FISCHER  wrote:

Using our client Python app for synchronization with a server it

crashes
frequently generating c005 error and also mentioning sqlite3.dll.

Usually when an application crashes and SQLite is mentioned in the

stack trace, that indicates that some other module corrupted the heap
and SQLite was the first unlucky module to stumble over the
corruption.

That said, if you can provide more details, we will look into the
matter.


___

sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___

sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


--

*Frantz Fischer*
Premium Support Team
+33 (0)1 40 33 79 87
+33 (0)1 40 33 71 41 (Fax)
www.nuxeo.com - Content Management Platform 

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


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


--

*Frantz Fischer*
Premium Support Team
+33 (0)1 40 33 79 87
+33 (0)1 40 33 71 41 (Fax)
www.nuxeo.com - Content Management Platform 

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

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Scott Robison]

In looking at the changelog for 2.7.12, I see multiple SQLite related
Python fixes that addressed coredump bugs.

On Sep 1, 2016 9:22 AM, "Scott Robison"  wrote:

> It appears 2.7.12 is available. Perhaps it is worth trying.
>
> On Sep 1, 2016 9:19 AM, "Frantz FISCHER"  wrote:
>
>> Hello,
>>
>>
>> 2.7.10 python own release.
>>
>> Got another crash mentioning the _pylite3.pyd module as you suspected
>> before.
>>
>>
>> Thanks,
>>
>> Frantz.
>>
>>
>> On 01/09/2016 17:00, Scott Robison wrote:
>>
>>> Specifically, what version / distribution of Python 2 is in use? Python's
>>> own release, ActiveState, other?
>>>
>>> On Sep 1, 2016 8:27 AM, "Frantz FISCHER"  wrote:
>>>
>>> Hello Richard,


 Thank you for your answer!

 Could you please tell me which details you would require?

 I managed to get a windows mini dump, would that be of any help?

 This is the default sqlite3.dll bundled with python 2.7. Do you require
 the python module? the dll itself?


 Regards,

 Frantz.


 On 01/09/2016 14:33, Richard Hipp wrote:

 On 9/1/16, Frantz FISCHER  wrote:
>
> Using our client Python app for synchronization with a server it
>> crashes
>> frequently generating c005 error and also mentioning sqlite3.dll.
>>
>> Usually when an application crashes and SQLite is mentioned in the
> stack trace, that indicates that some other module corrupted the heap
> and SQLite was the first unlucky module to stumble over the
> corruption.
>
> That said, if you can provide more details, we will look into the
> matter.
>
>
> ___
 sqlite-users mailing list
 sqlite-users@mailinglists.sqlite.org
 http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

 ___
>>> sqlite-users mailing list
>>> sqlite-users@mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>
>> --
>>
>> *Frantz Fischer*
>> Premium Support Team
>> +33 (0)1 40 33 79 87
>> +33 (0)1 40 33 71 41 (Fax)
>> www.nuxeo.com - Content Management Platform 
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Scott Robison]

It appears 2.7.12 is available. Perhaps it is worth trying.

On Sep 1, 2016 9:19 AM, "Frantz FISCHER"  wrote:

> Hello,
>
>
> 2.7.10 python own release.
>
> Got another crash mentioning the _pylite3.pyd module as you suspected
> before.
>
>
> Thanks,
>
> Frantz.
>
>
> On 01/09/2016 17:00, Scott Robison wrote:
>
>> Specifically, what version / distribution of Python 2 is in use? Python's
>> own release, ActiveState, other?
>>
>> On Sep 1, 2016 8:27 AM, "Frantz FISCHER"  wrote:
>>
>> Hello Richard,
>>>
>>>
>>> Thank you for your answer!
>>>
>>> Could you please tell me which details you would require?
>>>
>>> I managed to get a windows mini dump, would that be of any help?
>>>
>>> This is the default sqlite3.dll bundled with python 2.7. Do you require
>>> the python module? the dll itself?
>>>
>>>
>>> Regards,
>>>
>>> Frantz.
>>>
>>>
>>> On 01/09/2016 14:33, Richard Hipp wrote:
>>>
>>> On 9/1/16, Frantz FISCHER  wrote:

 Using our client Python app for synchronization with a server it crashes
> frequently generating c005 error and also mentioning sqlite3.dll.
>
> Usually when an application crashes and SQLite is mentioned in the
 stack trace, that indicates that some other module corrupted the heap
 and SQLite was the first unlucky module to stumble over the
 corruption.

 That said, if you can provide more details, we will look into the
 matter.


 ___
>>> sqlite-users mailing list
>>> sqlite-users@mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>> ___
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
> --
>
> *Frantz Fischer*
> Premium Support Team
> +33 (0)1 40 33 79 87
> +33 (0)1 40 33 71 41 (Fax)
> www.nuxeo.com - Content Management Platform 
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Frantz FISCHER]

Hello,


2.7.10 python own release.

Got another crash mentioning the _pylite3.pyd module as you suspected 
before.



Thanks,

Frantz.


On 01/09/2016 17:00, Scott Robison wrote:

Specifically, what version / distribution of Python 2 is in use? Python's
own release, ActiveState, other?

On Sep 1, 2016 8:27 AM, "Frantz FISCHER"  wrote:


Hello Richard,


Thank you for your answer!

Could you please tell me which details you would require?

I managed to get a windows mini dump, would that be of any help?

This is the default sqlite3.dll bundled with python 2.7. Do you require
the python module? the dll itself?


Regards,

Frantz.


On 01/09/2016 14:33, Richard Hipp wrote:


On 9/1/16, Frantz FISCHER  wrote:


Using our client Python app for synchronization with a server it crashes
frequently generating c005 error and also mentioning sqlite3.dll.


Usually when an application crashes and SQLite is mentioned in the
stack trace, that indicates that some other module corrupted the heap
and SQLite was the first unlucky module to stumble over the
corruption.

That said, if you can provide more details, we will look into the matter.



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


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


--

*Frantz Fischer*
Premium Support Team
+33 (0)1 40 33 79 87
+33 (0)1 40 33 71 41 (Fax)
www.nuxeo.com - Content Management Platform 

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

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Scott Robison]

Specifically, what version / distribution of Python 2 is in use? Python's
own release, ActiveState, other?

On Sep 1, 2016 8:27 AM, "Frantz FISCHER"  wrote:

> Hello Richard,
>
>
> Thank you for your answer!
>
> Could you please tell me which details you would require?
>
> I managed to get a windows mini dump, would that be of any help?
>
> This is the default sqlite3.dll bundled with python 2.7. Do you require
> the python module? the dll itself?
>
>
> Regards,
>
> Frantz.
>
>
> On 01/09/2016 14:33, Richard Hipp wrote:
>
>> On 9/1/16, Frantz FISCHER  wrote:
>>
>>> Using our client Python app for synchronization with a server it crashes
>>> frequently generating c005 error and also mentioning sqlite3.dll.
>>>
>> Usually when an application crashes and SQLite is mentioned in the
>> stack trace, that indicates that some other module corrupted the heap
>> and SQLite was the first unlucky module to stumble over the
>> corruption.
>>
>> That said, if you can provide more details, we will look into the matter.
>>
>>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Frantz FISCHER]

Hello Richard,


Thank you for your answer!

Could you please tell me which details you would require?

I managed to get a windows mini dump, would that be of any help?

This is the default sqlite3.dll bundled with python 2.7. Do you require 
the python module? the dll itself?



Regards,

Frantz.


On 01/09/2016 14:33, Richard Hipp wrote:

On 9/1/16, Frantz FISCHER  wrote:

Using our client Python app for synchronization with a server it crashes
frequently generating c005 error and also mentioning sqlite3.dll.

Usually when an application crashes and SQLite is mentioned in the
stack trace, that indicates that some other module corrupted the heap
and SQLite was the first unlucky module to stumble over the
corruption.

That said, if you can provide more details, we will look into the matter.



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

Re: [sqlite] wow, amazing!

[ronny . dierckx]

Yo! 


I've been  looking for some info  on the web  and came across that  amazing 
picture, just  take a look 

Faithfully, ronny.dierckx


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

Re: [sqlite] client app crashes frequently and points sqlite DLL

[Richard Hipp]

On 9/1/16, Frantz FISCHER  wrote:
> Using our client Python app for synchronization with a server it crashes
> frequently generating c005 error and also mentioning sqlite3.dll.

Usually when an application crashes and SQLite is mentioned in the
stack trace, that indicates that some other module corrupted the heap
and SQLite was the first unlucky module to stumble over the
corruption.

That said, if you can provide more details, we will look into the matter.

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

[sqlite] client app crashes frequently and points sqlite DLL

[Frantz FISCHER]

Hi experts,

Using our client Python app for synchronization with a server it crashes 
frequently generating c005 error and also mentioning sqlite3.dll. 
(see file attached for details on the crash event):
The SQLlite version is the one bundled with Python 2. Upgrading 
(replacing) the dll to the latest version does not improve the situation.

It happens randomly after a different amount of time for each attempt. 
Sometimes it even does not crash and goes through.


This seems to be specific to one customer environment and has been 
tested on several computers and several CPUs from Pentium4 to Core i3 
architectures.
Also I tested with several synchronization server so it is very unlikely 
to be responsible for this.



1) this is happening on Windows 7 - 32 bit.
2) uninstalled several applications.
3) uninstalled 2 antiviruses
4) uninstalled 1 antimalware
5) disabled Windows Search
6) disabled Windows firewall
7) made ram test with memtest86 -> clean
8) made ram test with Windows Memory Diagnostic -> clean
9) uninstall some more applications and drivers (printers, …)

After all that, it is still happening. I would be grateful to get any 
new ideas or a reason why this is happening.

This is happening in one specific environment and not with any other 
customer. I cannot reproduce the behavior  as this is working fine in my 
env. This may be related to the software installed on the customer 
machine but not sure.


Is there a reliable way to track what is causing the app to crash 
involving sqlite?


Regards,
Frantz.


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

Re: [sqlite] database problem with later Android Studio emulator

[Jim Callahan]

Wild guess: Could there possibly be a difference in where the different
implementations
of Android look for SQLite files? If you are using a default directory and
the default directory
is different on different machines; then Android might not be looking in
the correct directory to find your files; resulting in a "file not found"
error.  Also consider file permission issues.

You might find these StackOverflow discussions useful:

December 15, 2010
http://stackoverflow.com/questions/4452538/location-of-sqlite-database-on-the-device

March 10, 2013
http://stackoverflow.com/questions/15326455/what-is-the-default-database-location-of-an-android-app-for-an-unrooted-device

September 9, 2013
http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android



Jim Callahan
Orlando, FL






On Thu, Sep 1, 2016 at 3:13 AM, Charles L. Sykes 
wrote:

> Dear SQLite Experts:
>
>
>
> I recently made the move from Windows 7 to Windows 10, and from Eclipse to
> Android Studio.
>
>
>
> I have a set of Oscar quiz apps with a SQLite database, which ran fine when
> I converted them over, testing under the Nexus Emulator (API 19). When I
> later obtained a Samsung Galaxy S7 and copied the apk over to the physical
> device, I got the "Unfortunately, APP NAME has stopped". I forgot about it
> (since it was running under the Nexus emulator), until I uploaded them to
> Amazon for sale, and they failed on all devices except an older one,
> possibly the Nexus.
>
>
>
> I installed a Galaxy emulator and figured out how to get a detailed debug
> log, and now I am perplexed in getting a "table not found" error.
>
>
>
> I know this doesn't occur with the Nexus emulator because I put in Toast
> statements to display table counts as part of my standard debugging when a
> new version of the database is loaded.
>
>
>
> In testing, I'm only switching between the two emulators. There are no code
> changes.
>
>
>
> (Since the app only does queries, and no updates, the table is initially
> created outside and pushed onto the phone. Basically I use SQL Workbench to
> load the table from text files. I didn't see a reason to have hundreds of
> INSERT statements in the code for a one-time use. The canned database is
> then used in both the Android and iPhone versions [never got the Windows
> version to work].)
>
>
>
> I originally created the apps a couple of years ago (version 3.??). Do I
> need to possibly download a later version of SQLite and recreate the
> database with it?
>
>
>
> Thank you for any insight you can offer,
>
>
>
> cls
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database problem with later Android Studio emulator

[Clemens Ladisch]

Charles L. Sykes wrote:
> I installed a Galaxy emulator and figured out how to get a detailed debug
> log, and now I am perplexed in getting a "table not found" error.

Such an error is typically caused by using the Android framework
incorrectly.


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

[sqlite] database problem with later Android Studio emulator

[Charles L. Sykes]

Dear SQLite Experts:

 

I recently made the move from Windows 7 to Windows 10, and from Eclipse to
Android Studio.

 

I have a set of Oscar quiz apps with a SQLite database, which ran fine when
I converted them over, testing under the Nexus Emulator (API 19). When I
later obtained a Samsung Galaxy S7 and copied the apk over to the physical
device, I got the "Unfortunately, APP NAME has stopped". I forgot about it
(since it was running under the Nexus emulator), until I uploaded them to
Amazon for sale, and they failed on all devices except an older one,
possibly the Nexus.

 

I installed a Galaxy emulator and figured out how to get a detailed debug
log, and now I am perplexed in getting a "table not found" error.

 

I know this doesn't occur with the Nexus emulator because I put in Toast
statements to display table counts as part of my standard debugging when a
new version of the database is loaded.

 

In testing, I'm only switching between the two emulators. There are no code
changes.

 

(Since the app only does queries, and no updates, the table is initially
created outside and pushed onto the phone. Basically I use SQL Workbench to
load the table from text files. I didn't see a reason to have hundreds of
INSERT statements in the code for a one-time use. The canned database is
then used in both the Android and iPhone versions [never got the Windows
version to work].)

 

I originally created the apps a couple of years ago (version 3.??). Do I
need to possibly download a later version of SQLite and recreate the
database with it? 

 

Thank you for any insight you can offer,

 

cls

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