440118 - Full-Text Search module doesn't work on Debian

Status: RESOLVED FIXED

(Core :: SQLite and Embedded Database Bindings, defect)

Description

[Adam Kowalczyk]

Attempting to use the Full-Text Search module in Debian results in an error: "no such module: fts3". Debian and some other distributions make Firefox use system sqlite. I suspect that either they don't include FTS at all or they build it as a standalone shared library. Both of which would break platform parity.

Comment 1

[Shawn Wilsher :sdwilsh]

We either need to add a check that FTS is enabled in system sqlite, or disallow system sqlite.

Comment 2

[Dan Mosedale (:dmosedale, :dmose)]

The quickest road to getting the Debian-specific instance of this fixed is to file a bug in the Debian bug-tracking system, I suspect.

Comment 3

[Christopher Blizzard (:blizzard)]

Also, Debian doesn't include Firefox.  They have their own unbranded version called ice weasel.

Comment 4

[Reed Loden [:reed]]

Mike, can you either get the FTS module enabled on Debian's sqlite or disable system sqlite? Thanks!

Comment 5

[Shawn Wilsher :sdwilsh]

Just to be clear - add-on authors will expect FTS to be enabled by default.

Comment 6

[Mike Hommey [:glandium]]

(In reply to comment #4)
> Mike, can you either get the FTS module enabled on Debian's sqlite or disable
> system sqlite? Thanks!

If it doesn't change sqlite ABI, this should be possible.

Comment 7

[Christopher Blizzard (:blizzard)]

Even if it does change the sqlite ABI you can always switch back to the internal copy of sqlite, yeah?

Comment 8

[Mike Hommey [:glandium]]

(In reply to comment #7)
> Even if it does change the sqlite ABI you can always switch back to the
> internal copy of sqlite, yeah?

Technically, yes, we can. Practically, we'd rather avoid.

Comment 9

[Adam Kowalczyk]

I got a report from one of the users of my extension suggesting that Gentoo has the same issue.

Comment 10

[Shawn Wilsher :sdwilsh]

(In reply to comment #9)
> I got a report from one of the users of my extension suggesting that Gentoo has
> the same issue.
I imagine anyone using system sqlite will hit this since I don't think most system sqlite's will compile with FTS enabled.

Comment 11

[Mike Hommey [:glandium]]

It should work in Debian, now:

http://packages.qa.debian.org/s/sqlite3/news/20080625T233203Z.html

sqlite3 (3.5.9-3) unstable; urgency=low
   * Enable full text search (closes: #487914).

Comment 12

[Shawn Wilsher :sdwilsh]

I'll also note that any distro actually running our unit tests would be aware of this issue as well.

Comment 13

[Mike Hommey [:glandium]]

(In reply to comment #12)
> I'll also note that any distro actually running our unit tests would be aware
> of this issue as well.

Well, maybe mozilla.org should run the unit tests under linux, too...

../../_tests/xpcshell-simple/xpcom/unit/test_bug364285-1.js: FAIL
../../_tests/xpcshell-simple/xpcom/unit/test_bug364285-1.js.log:
>>>>>>>
*** test pending
*** exiting
*** CHECK FAILED:  CAA:89 ==  CAA:89
JS frame :: ../../tools/test-harness/xpcshell-simple/head.js :: do_throw :: line 99
JS frame :: ../../tools/test-harness/xpcshell-simple/head.js :: do_check_eq :: line 114
JS frame :: ../../_tests/xpcshell-simple/xpcom/unit/test_bug364285-1.js :: create_file :: line 33
JS frame :: ../../_tests/xpcshell-simple/xpcom/unit/test_bug364285-1.js :: test_create :: line 40
JS frame :: ../../_tests/xpcshell-simple/xpcom/unit/test_bug364285-1.js :: run_test :: line 49
JS frame :: ../../tools/test-harness/xpcshell-simple/tail.js :: _execute_test :: line 41
JS frame :: ../../tools/test-harness/xpcshell-simple/execute_test.js :: <TOP_LEVEL> :: line 38
2147500036
*** FAIL ***

<<<<<<<

(and that's only the first one)

Comment 14

[Reed Loden [:reed]]

(In reply to comment #13)
> (In reply to comment #12)
> > I'll also note that any distro actually running our unit tests would be aware
> > of this issue as well.
> 
> Well, maybe mozilla.org should run the unit tests under linux, too...

We do run them under Linux.

See http://tinderbox.mozilla.org/Firefox/ (Linux qm-centos5-04 dep unit test) and http://tinderbox.mozilla.org/Mozilla2/ (Linux mozilla-central qm-centos5-moz2-01 dep unit test).

Comment 15

[Shawn Wilsher :sdwilsh]

(In reply to comment #13)
> Well, maybe mozilla.org should run the unit tests under linux, too...
If you are seeing failures, you probably have some bugs in your local tree.

Comment 16

[Mike Hommey [:glandium]]

(In reply to comment #15)
> (In reply to comment #13)
> > Well, maybe mozilla.org should run the unit tests under linux, too...
> If you are seeing failures, you probably have some bugs in your local tree.

Except I get the same with vanilla mozilla.org tarballs. But that's enough offtopic.

Comment 17

[Mike Shaver (:shaver emeritus)]

bug numbers for these debian-specific failures?

Comment 18

[Mike Hommey [:glandium]]

(In reply to comment #17)
> bug numbers for these debian-specific failures?

#442627

Comment 19

[Mike Hommey [:glandium]]

As far as Debian is concerned, this bug is fixed. Please reopen and retitle if it is still a concern on other distros.