Skip site navigation (1) Skip section navigation (2)

Re: Text search segmentation fault

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
Cc: General Postgres Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Text search segmentation fault
Date: 2009-01-29 13:35:36
Message-ID: Pine.LNX.4.64.0901291632390.9554@sn.sai.msu.ru (view raw or flat)
Thread:
Lists: pgsql-general
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

pgsql-general by date

Next:From: Teodor SigaevDate: 2009-01-29 13:39:46
Subject: Re: Text search segmentation fault
Previous:From: Gregory StarkDate: 2009-01-29 13:16:17
Subject: Pet Peeves?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group