Hi,
I cannot duplicate your error on Win7_64 or OpenSuse_64.
On Win7_64, I ran this test:
NB. sqlite test
require '~addons\data\sqlite\sqlite.ijs'
DBN=:'z:\test.sqlite'
footst=: 3 : 0
ferase <DBN
db=:'psqlite'conew~DBN
exec__db'create table data (name string, shortname string, stage integer, enc
blob);'
f=:'D:\jtest.bin'
s=: 1!:1 <f
('name';'name';100;s) apply__db 'insert into data values (?,?,?,?);'
destroy__db''
)
foord=: 3 : 0
db=:'psqlite'conew~DBN
res=:strquery__db 'select enc from data;'
destroy__db''
)
---
I got this result running on j604_32 and J701_32:
footst''
1
foord''
1
foord''
1
foord''
1
res
+----------------------------------------------------------------------------...
|enc
+----------------------------------------------------------------------------...
|4wAAAAAAAAAgAAAAAAAAAOkYAAAAAAAAAQAAAAAAAADpGAAAAAAAAHDHAAAAAAAAyMcAAAAAAAAg...
+----------------------------------------------------------------------------...
Where the file jtest.bin was downloaded from your url.
I made minor modifications to the script and ran it on j701_32 on OpenSuse_64.
It worked there also.
All the best,
David Mitchell
On 2/11/2012 22:58, S Suon wrote:
>
>
> Please note that I pasted the URL incorrectly; there's a space at the end
> that for some reason was pasted as part of the URL.
>
> Here's the correct URL:
> http://pastebin.com/raw.php?i=tMBbfcRQ
>
>
>
> ________________________________
> From: S Suon<[email protected]>
> To: "[email protected]"<[email protected]>
> Sent: Saturday, February 11, 2012 10:52 PM
> Subject: [Jprogramming] Occasional but consistent seg faults using sqlite;
> the simplest case I can reproduce
>
> Hi, all:
>
> SUMMARY:
>
> Blob of only 131k length seems to cause seg fault using sqlite.
>
> DETAILS:
>
> I have been tormented by occasional seg faults that happen when I use
> sqlite. The good thing is that whatever case causes a crash, I can
> produce it all the time.
>
> Here's what I use to create a crash:
> I create the following table:
> CREATE TABLE data (name string, shortname string, stage integer, enc
> blob);
>
> Then I insert one row into it with this code (copied from example when I
> downloaded data/sqlite):
> require 'data/sqlite'
> db=: 'psqlite'conew~ './whatever.sqlite'
>
> fin=. 1!:21<
> '/tmp/longstring'
> s=. 1!:1< fin
> 1!:22 fin
> ('name';'name';100;s) apply__db 'insert into data values (?,?,?,?);'
>
>
> The
> content of /tmp/longstring is 131038 bytes long. Its entire text
> content can be found here: http://pastebin.com/raw.php?i=tMBbfcRQ . It's
> nothing special; just readable
> text characters.
>
>
> Later, when I attempt to read that one row from sqlite, I get a segfault:
> strquery__db 'select enc from data;'
>
> I've played around a while to determine the actual reason. I'm certain it's
> not just the length, because I've had success with strings of many
> megabytes.
>
> Specs:
> I am running 64-bit Ubuntu 11.10 Oneirc - also fails on Ubuntu Maverick
>
> j 701 - also fails on j602
> the default sqlite 3 library that came with Oneirc - also fails with sqlite
> 3.7.10
>
>
> Can anyone help? I haven't seen this sort of problem while looking through
> the jsoftware archives.
>
> --- Sarino Suon
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
