Re: Received fatal signal 11 using a prosqlite predicate

Dear Bob,

On Sat, 28 Sep 2013 08:54:02 -0500
"Bob Ly" <[email protected]> wrote:

> Thank you for your response, Nicos.
> 
> I was able to duplicate the example sqlite database.
> 
> So the problem appears to be the database itself.
> 
> I thought the problem might be the permission of the database but they  
> are the same.
> $ ls downloads/uniprot.sqlite -l && ls  
> .mozilla/firefox/ooftaizq.default/places.sqlite -l
> -rw-r--r-- 1 robert robert 192375808 Jun 12 10:42 downloads/uniprot.sqlite
> -rw-r--r-- 1 robert robert 20971520 Sep 28 07:33  
> .mozilla/firefox/ooftaizq.default/places.sqlite
> 
> I also thought the error might be the fact that the datable was hidden  
> (ie .uniprot.sqlite) but I was able to duplicate the previous code  
> successfully.
> 
> The system I am running is the following:
> Linux 360data 3.2.0-4-amd64 #1 SMP Debian 3.2.46-1 x86_64 GNU/Linux.
> 
> The database is just the web browser's (in this case, iceweasel)  
> history. 

	I tried with places.sqlite on my set-up (firefox on mint 15, linux).
	it seems the problem arises from the way prosqlite deals with some database values

	In my set up i get the same error as you do when backtracking reaches
	a row containing a column with value:
	'place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&maxResults=10&excludeQueries=1'

	i used sqlitebrowser http://sqlitebrowser.sourceforge.net/ to see the contents  of places.sqlite

        if you try your query with id and visit_count only, you may well be able to get more rows back.
        If you find the offending content of your .sqlite file please let me know.
 
	hopefully I will be able to resolve this soon, if this is indeed the only issue


Regards,

Nicos Angelopoulos.