Re: Text search segmentation fault - Mailing list pgsql-general

It works on one of my servers:
SELECT version();
                                                  version
---------------------------------------------------------------------------------------------------------
  PostgreSQL 8.3.4 on i686-pc-linux-gnu, compiled by GCC cc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-59)

The one it fails on is running:
SELECT version();
                                                     version
----------------------------------------------------------------------------------------------------------------
  PostgreSQL 8.3.5 on x86_64-unknown-linux-gnu, compiled by GCC cc (GCC)
3.2.3 20030502 (Red Hat Linux 3.2.3-59)

Oleg Bartunov wrote:
> Tommy,
>
> I tried your example and didn't find any problem.
> My postgresql version is 8.3.3 and I didn't use stopwords, since I don't
> have them.
>
> arxiv=# select version();
>                                 version
> ------------------------------------------------------------------------
>  PostgreSQL 8.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.3
> (1 row)
>
> arxiv=# select ts_lexize('no_ispell',
> 'overbuljongterningpakkmesterassistent');
>                   ts_lexize
> ----------------------------------------------
>  {over,buljong,terning,pakk,mester,assistent}
> (1 row)
>
> Time: 922.364 ms
>
>
> Oleg
>
> On Thu, 29 Jan 2009, Tommy Gildseth wrote:
>
>> While trying to create a new dictionary for use with PostgreSQL text
>> search, I get a segfault. My Postgres version is 8.3.5
>>
>> The dictionary I use is the "Norwegian Bokm?l & Nynorsk (Norway) pack
>> for OOo 2.x" downloaded from
>> http://wiki.services.openoffice.org/wiki/Dictionaries#Norwegian_.28Norway.29
>>
>>
>> I've also uploaded the dictionary and affix-file used to this location:
>> http://folk.uio.no/tommygi/postgres/nb_no.dict
>> http://folk.uio.no/tommygi/postgres/nb_no.affix
>>
>> These are unpacked from the zip-file I got from the above location,
>> and converted to UTF-8 with the following commands:
>>  - iconv -f latin1 -t utf-8 nb_NO.dic > nb_no.dict
>>  - iconv -f latin1 -t utf-8 nb_NO.aff > nb_no.affix
>>
>> The command I use is this:
>> CREATE TEXT SEARCH DICTIONARY no_ispell (
>>        TEMPLATE = ispell,
>>        DictFile = nb_no,
>>        AffFile =  nb_no,
>>        StopWords = norwegian
>> );
>>
>>
>> I've uploaded a strace of the process at
>> http://folk.uio.no/tommygi/postgres/strace.txt
>> This is captured with strace -p<pid>. Since this is about the extent
>> of my knowledge of strace, please let me know if there's any other
>> options I should specify.
>>
>> Relevant parts of the postgres log file is included below.
>>
>> [2009-01-29 13:55:11.721 CET] [pgtest02] [:] [] [26466] [0] LOG:
>> server process (PID 12002) was terminated by signal 11: Segmentation
>> fault
>> [2009-01-29 13:55:11.721 CET] [pgtest02] [:] [] [26466] [0] LOG:
>> terminating any other active server processes
>> [2009-01-29 13:55:11.725 CET] [pgtest02] [:] [] [26466] [0] LOG:  all
>> server processes terminated; reinitializing
>> [2009-01-29 13:55:11.931 CET] [pgtest02] [:] [] [12018] [0] LOG:
>> database system was interrupted; last known up at 2009-01-29 13:42:05 CET
>> [2009-01-29 13:55:11.931 CET] [pgtest02] [:] [] [12018] [0] LOG:
>> database system was not properly shut down; automatic recovery in
>> progress
>> [2009-01-29 13:55:11.934 CET] [pgtest02] [:] [] [12018] [0] LOG:
>> record with zero length at 0/4A2F9A0
>> [2009-01-29 13:55:11.934 CET] [pgtest02] [:] [] [12018] [0] LOG:  redo
>> is not required
>> [2009-01-29 13:55:11.986 CET] [pgtest02] [fotoportal:postgres]
>> [192.168.6.137(49650)] [12019] [0] FATAL:  the database system is in
>> recovery mode
>> [2009-01-29 13:55:11.988 CET] [pgtest02] [fotoportal:postgres]
>> [192.168.6.137(49655)] [12020] [0] FATAL:  the database system is in
>> recovery mode
>> [2009-01-29 13:55:12.010 CET] [pgtest02] [:] [] [12023] [0] LOG:
>> autovacuum launcher started
>> [2009-01-29 13:55:12.011 CET] [pgtest02] [:] [] [26466] [0] LOG:
>> database system is ready to accept connections
>>
>>
>>
>
>     Regards,
>         Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83


--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39