subject:"Re\: \[sqlite\] Problems"

Re: [sqlite] Problems loading extensions on Windows 10

2019-03-05 Thread Kyle

As indicated by "Random Coder", the problem was that I was missing the
required dependencies.

Thank you.

On Tue, Mar 5, 2019 at 8:03 PM Thomas Kurz  wrote:

> Are both of the same architecture, either 32bit or 64bit?
>
> - Original Message -
> From: Kyle 
> To: sqlite-users@mailinglists.sqlite.org <
> sqlite-users@mailinglists.sqlite.org>
> Sent: Tuesday, March 5, 2019, 23:30:35
> Subject: [sqlite] Problems loading extensions on Windows 10
>
> I am having problems loading sqlite3 extensions on Windows 10.
>
> I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and
> copied them to C:\Windows\System32.
>
> When I run
> SELECT load_extension('mod_spatialite')
> sqlite returns "Error: the specified module could not be found"
>
> I have also tried
> SELECT load_extension('C:\Windows\System32\mod_spatialite.dll')
> which returns the same error.
>
> These commands work perfectly fine in Ubuntu and the extension loads with
> no problems. What do I need to do differently on Windows?
> ___
> 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
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems loading extensions on Windows 10

2019-03-05 Thread Thomas Kurz

Are both of the same architecture, either 32bit or 64bit?

- Original Message - 
From: Kyle 
To: sqlite-users@mailinglists.sqlite.org 
Sent: Tuesday, March 5, 2019, 23:30:35
Subject: [sqlite] Problems loading extensions on Windows 10

I am having problems loading sqlite3 extensions on Windows 10.

I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and
copied them to C:\Windows\System32.

When I run
SELECT load_extension('mod_spatialite')
sqlite returns "Error: the specified module could not be found"

I have also tried
SELECT load_extension('C:\Windows\System32\mod_spatialite.dll')
which returns the same error.

These commands work perfectly fine in Ubuntu and the extension loads with
no problems. What do I need to do differently on Windows?
___
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] Problems loading extensions on Windows 10

2019-03-05 Thread Random Coder

On Tue, Mar 5, 2019 at 2:30 PM Kyle  wrote:
> I have downloaded both sqlite3 and mod_spatialite.dll (the extension) and
> copied them to C:\Windows\System32.
>
> When I run
> SELECT load_extension('mod_spatialite')
> sqlite returns "Error: the specified module could not be found"

Helpfully, on Windows, the error message for unable to find a DLL, and
unable to find a dependency of that DLL are the same error.

The version of mod_spatialite.dll I'm familiar with has several
dependencies.  You'll need to make sure all of the dependent DLL files
are also copied to somewhere in your path.  You might try using
Dependency Walker ( http://www.dependencywalker.com/ ) to see which
DLLs a component is missing.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems with compiling SQLite for MUSL.

2018-09-03 Thread John Found

On Sun, 02 Sep 2018 22:25:16 -0600
"Keith Medcalf"  wrote:

> Interesting ... Sounds like the optimizer in the compiler is broken ... 
> unless someone has ideas about how to debug this.  Can you compile with no 
> optimization and SQLITE_DEBUG defined and see what happens?  Though, to me it 
> sounds like the compiler and/or the optimizer is just broken (or perhaps the 
> replacement standard library is broken and does not return properly aligned 
> memory allocations) ... 

Well, the problem is solved. The crashes was caused because gcc compiled sqlite 
with requirement for stack alignment on 16 bytes,
regardles of that it was compiled to 32bit code. On the other hand, my code 
aligns the stack on 4 bytes as an usual 32bit program.

The option -mpreferred-stack-boundary=2 fixed the issue.

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

Re: [sqlite] Problems with compiling SQLite for MUSL.

2018-09-02 Thread Keith Medcalf


On Sunday, 2 September, 2018 20:32, John Found  wrote:

>On Sun, 02 Sep 2018 14:18:50 -0600 "Keith Medcalf"  wrote:

>> This is a compiler issue and has nothing to do with SQLite3.
>>Anything you compiled using that compiler would exhibit the same
>>problems ...

>Well, I was almost sure, but as long as here I can find people
>understanding gcc and I am compiling sqlite after all,
>considered a good place to ask. ;)

>> However, that the compiler does not automatically use the correct
>>alignment for the cpu architecture in use is puzzling, since this is
>>something that one would normally expect to be correct by default.
>>You did not say what Operating System or CPU you are using ... this
>>is probably important information.  As is likely the version of GCC
>>(use gcc -v or musl-gcc -v to get the compiler's compile
>>configuration).

>The OS is 64bit Linux (Manjaro/Arch), the CPU is AMD A4-1200
>(supports almost all extensions), gcc version is 8.2.0;

>BTW, compiling with -O1 sometimes produces working result (but pretty
>slow) which only entagles the puzzle.

Interesting ... Sounds like the optimizer in the compiler is broken ... unless 
someone has ideas about how to debug this.  Can you compile with no 
optimization and SQLITE_DEBUG defined and see what happens?  Though, to me it 
sounds like the compiler and/or the optimizer is just broken (or perhaps the 
replacement standard library is broken and does not return properly aligned 
memory allocations) ... 

---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.



>
>--
>John Found 
>___
>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] Problems with compiling SQLite for MUSL.

2018-09-02 Thread John Found

On Sun, 02 Sep 2018 14:18:50 -0600
"Keith Medcalf"  wrote:

> 
> This is a compiler issue and has nothing to do with SQLite3.  Anything you 
> compiled using that compiler would exhibit the same problems ...

Well, I was almost sure, but as long as here I can find people understanding 
gcc and I am compiling sqlite after all, 
considered a good place to ask. ;)

> However, that the compiler does not automatically use the correct alignment 
> for the cpu architecture in use is puzzling, since this is something that one 
> would normally expect to be correct by default.  You did not say what 
> Operating System or CPU you are using ... this is probably important 
> information.  As is likely the version of GCC (use gcc -v or musl-gcc -v to 
> get the compiler's compile configuration).

The OS is 64bit Linux (Manjaro/Arch), the CPU is AMD A4-1200 (supports almost 
all extensions), gcc version is 8.2.0;

BTW, compiling with -O1 sometimes produces working result (but pretty slow) 
which only entagles the puzzle.

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

Re: [sqlite] Problems with compiling SQLite for MUSL.

2018-09-02 Thread Keith Medcalf


This is a compiler issue and has nothing to do with SQLite3.  Anything you 
compiled using that compiler would exhibit the same problems ...

The source for SQLite3 does not change the default compiler packing or 
alignment, so whatever alignment the compiler thinks is appropriate is what 
gets used.  

That said, the packing overrides for GCC (they are however dependent on the 
target CPU, and there are a myriad of different options which vary by target 
CPU and how the compiler was built) are likely:

-fpack-struct=n (where n is in bytes)
-mstructure-size-boundary=b (where b is in bits)
-malign-double (presumably this means double-word boundaries, or 64-bits)

However, that the compiler does not automatically use the correct alignment for 
the cpu architecture in use is puzzling, since this is something that one would 
normally expect to be correct by default.  You did not say what Operating 
System or CPU you are using ... this is probably important information.  As is 
likely the version of GCC (use gcc -v or musl-gcc -v to get the compiler's 
compile configuration).

---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
lot about anticipated traffic volume.

>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of John Found
>Sent: Sunday, 2 September, 2018 12:18
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] Problems with compiling SQLite for MUSL.
>
>
>I am trying to compile SQLite with 32bit MUSL, but probably mess some
>compiler options.
>
>The command I am using is:
>
>musl-gcc -O3 -shared -fno-stack-protector -
>DSQLITE_DEFAULT_MEMSTATUS=0 -DSQLITE_LIKE_DOESNT_MATCH_BLOBS -
>DSQLITE_MAX_EXPR_DEPTH=0 -DSQLITE_OMIT_DEPRECATED -D
>SQLITE_OMIT_PROGRESS_CALLBACK -DSQLITE_OMIT_SHARED_CACHE -
>DSQLITE_ENABLE_STAT4 -DSQLITE_ENABLE_FTS5 -DSQLITE_OMIT_COMPLETE -
>DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=1
>./sqlite3.c -o ./libsqlite3.so
>
>The code compiles without errors. The problem is that the code is
>compiled with SSE instructions, but in runtime crashes on reads and
>writes to unaligned memory addresses. In most cases the crashes are
>random, but mostly in sqlite3_prepare_v2 function;
>
>So, the question, how to make sqlite to compile with properly aligned
>variables in order to not crash. Is there some option about this (my
>gcc and generally C/C++ skills are pretty low) or I somehow messed
>the options elsewhere. Then what to check?
>
>
>--
>John Found 
>___
>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] Problems compiling FTS5 extension

2017-10-19 Thread Eugene Mirotin

Thanks for the tips!

Don't know about the segfault too but can ignore it for now — this same
file works well with the GUI app and with my Node.js program.

On Thu, Oct 19, 2017 at 6:38 PM Dan Kennedy  wrote:

> On 10/19/2017 08:40 PM, Eugene Mirotin wrote:
> > Hm, I think that's because the extension is already preloaded with my
> > version if sqlite. Which means I didn't even have to build it :)
> > But now is the question how would I reliably load / not load it in
> > production env if the target user may or may not have sqlite precompiled
> > with it?
>
> Right, it's an error to try to register a new version of a module -
> "fts5" in this case - that has already been registered.
>
> You could just assume that if the attempt to load fts5 dynamically fails
> it is already registered. Or you could try preparing the statement
> "SELECT fts5_source_id()" before loading the extension. If preparing the
> statement succeeds, fts5 is already present and you don't need to load it.
>
> Don't know why you might be getting the segfault.
>
> Dan.
>
>
> >
> > On Thu, Oct 19, 2017 at 3:30 PM Eugene Mirotin 
> wrote:
> >
> >> Well, now I have troubles loading this extension.
> >>
> >> I've built another one before, fts5stemmer.
> >>
> >> When using the CLI sqlite3 (version 3.20.1 from MacPorts):
> >>
> >> ❯ sqlite3
> >> SQLite version 3.20.1 2017-08-24 16:21:36
> >> Enter ".help" for usage hints.
> >> Connected to a transient in-memory database.
> >> Use ".open FILENAME" to reopen on a persistent database.
> >> sqlite> .load './fts5.dylib'
> >> Error: error during initialization:
> >> sqlite> .load './fts5stemmer.dylib'
> >> [1]35952 segmentation fault  sqlite3
> >>
> >> When using the GUI DB Browser for SQLite:
> >> fts5 extension reports the same error "Error: error during
> initialization:"
> >> fst5stemmer loads fine (or at least reports to)
> >>
> >> On Thu, Oct 19, 2017 at 3:09 PM Eugene Mirotin 
> wrote:
> >>
> >>> Thanks a lot Dan, that worked!
> >>> I'm fine with the trunk version for now but hope to see this in stable
> >>> eventually as I'll have to later build this extension for various
> platforms
> >>> for the release of my app.
> >>> Thanks again for the quick fix
> >>>
> >>> On Wed, Oct 18, 2017 at 6:06 PM Dan Kennedy 
> >>> wrote:
> >>>
>  On 10/18/2017 06:32 PM, Eugene Mirotin wrote:
> > In short the error I get is
> > fts5_storage.c:305:9: error: 'sqlite3_api_routines' has no member
> named
> > '__builtin___snprintf_chk'
> >
> > More details in SO question here:
> >
> 
> https://stackoverflow.com/questions/46793988/sqlite-trouble-building-fts5-loadable-extension
>  ,
> > please let me know if I should paste everything in my email.
> >
> > I've seen a similar problem reported before and somehow related to
>  XCode,
> > but that issue was reported to be fixed.
> >
> > Would be thankful for any tips, I haven't used C for years and have
> no
>  idea
> > where to start.
>  Please try with the latest trunk checkin:
> 
>  http://www.sqlite.org/src/info/cd0471ca9f75e7c8
> 
>  (click the "ZIP archive" link to download if you're not using fossil)
> 
>  To generate the sqlite3ext.h and sqlite3.h files required when
> compiling
>  fts5.c, run [make sqlite3.h sqlite3ext.h]. So, altogether, something
>  like:
> 
>  ./configure
>  make fts5.c sqlite3.h sqlite3ext.h
>  gcc -O2 -fPIC -shared fts5.c -o fts5.dylib
> 
>  Or, if you want to use a released version, after [make sqlite3ext.h]
>  replace the two instances of "snprintf" in the sqlite3ext.h with
>  "xsnprintf".
> 
>  Dan.
> 
> 
> 
> 
>  ___
>  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
>
>
> ___
> 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] Problems compiling FTS5 extension

2017-10-19 Thread Dan Kennedy

On 10/19/2017 08:40 PM, Eugene Mirotin wrote:

Hm, I think that's because the extension is already preloaded with my
version if sqlite. Which means I didn't even have to build it :)
But now is the question how would I reliably load / not load it in
production env if the target user may or may not have sqlite precompiled
with it?

Right, it's an error to try to register a new version of a module -
"fts5" in this case - that has already been registered.

You could just assume that if the attempt to load fts5 dynamically fails
it is already registered. Or you could try preparing the statement
"SELECT fts5_source_id()" before loading the extension. If preparing the
statement succeeds, fts5 is already present and you don't need to load it.

Don't know why you might be getting the segfault.

Dan.

On Thu, Oct 19, 2017 at 3:30 PM Eugene Mirotin wrote:

Well, now I have troubles loading this extension.

I've built another one before, fts5stemmer.

When using the CLI sqlite3 (version 3.20.1 from MacPorts):

❯ sqlite3
SQLite version 3.20.1 2017-08-24 16:21:36
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .load './fts5.dylib'
Error: error during initialization:
sqlite> .load './fts5stemmer.dylib'
[1]35952 segmentation fault sqlite3

When using the GUI DB Browser for SQLite:
fts5 extension reports the same error "Error: error during initialization:"
fst5stemmer loads fine (or at least reports to)

On Thu, Oct 19, 2017 at 3:09 PM Eugene Mirotin wrote:

Thanks a lot Dan, that worked!
I'm fine with the trunk version for now but hope to see this in stable
eventually as I'll have to later build this extension for various platforms
for the release of my app.
Thanks again for the quick fix

1 2 3 4 >

1 - 100 of 323 matches

Mail list logo