Обсуждение: Re: [HACKERS] parser error when trying to connect to postges db from tomcat

Grepping through the PostgreSQL source I can't find anything; perhaps
someone on -interfaces has a better idea...

On Wed, Apr 19, 2006 at 03:34:10PM +0000, danish.siddiqui@hovservices.com wrote:
> Hi,
> Im getting this error when I try to connect to a postgresql database 
> from a web application running on tomcat....
> 
> the error is from the postgersql logs
> 
> ERROR:  No parser with id 17555
> 
> The error below is from tomcat logs:
> -------
> (executing StatementCallback): encountered
> SQLException [ERROR: No parser with id 17555]; nested exception is 
> org.postgresql.util.PSQLException: ERROR: No parser with id 17555
> -------
> 
> Please advise...Iv been trying to find an answer for a long time
> Thanks
> 
> -- 
> Danish Siddiqui
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

> On Wed, Apr 19, 2006 at 03:34:10PM +0000, danish.siddiqui@hovservices.com wrote:
> > Hi,
> > Im getting this error when I try to connect to a postgresql database 
> > from a web application running on tomcat....
> > 
> > the error is from the postgersql logs
> > 
> > ERROR:  No parser with id 17555

Jim C. Nasby wrote:
> Grepping through the PostgreSQL source I can't find anything; perhaps
> someone on -interfaces has a better idea...

My first guess would be a user-defined function doing
RAISE EXCEPTION 'No parser with ...'

or something similar.


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera <alvherre@commandprompt.com> writes:
>> On Wed, Apr 19, 2006 at 03:34:10PM +0000, danish.siddiqui@hovservices.com wrote:
>>> ERROR:  No parser with id 17555

> Jim C. Nasby wrote:
>> Grepping through the PostgreSQL source I can't find anything; perhaps
>> someone on -interfaces has a better idea...

Not sure what you're grepping, but I see two hits in contrib/tsearch2
...

pgsql/contrib/tsearch2/ts_cfg.c:                 ts_error(ERROR, "No parser with id %d", id);
pgsql/contrib/tsearch2/wparser.c:                ts_error(ERROR, "No parser with id %d", id);

Now, what tsearch2 thinks a "parser" is I have no idea, but it seems
like the OP probably has a misconfigured tsearch2 installation.
        regards, tom lane