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

BUG #1511: RPM install, PHP5

From: "ZOUARI Fourat" <fourat(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1511: RPM install, PHP5
Date: 2005-02-27 19:14:50
Message-ID: 20050227191450.DA648F0AC6@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1511
Logged by:          ZOUARI Fourat
Email address:      fourat(at)gmail(dot)com
PostgreSQL version: 8
Operating system:   Fedora Core 3
Description:        RPM install, PHP5
Details: 

Hello,
When selecting (from php) using this select :

SELECT msgid,content,timecreated,soa FROM sms_mo WHERE (LOWER(content) LIKE
'club%') AND (da='87000') AND  (timecreated > '2005-02-18 17:00:00') ORDER
BY msgid ASC

I get this error :
PANIQUE: ERRORDATA_STACK_SIZE exceeded server closed the connection
unexpectedly This probably means the server terminated abnormally before or
while processing the request.

when applying that select into phppgadmin interface there's no error.
but when commenting the line :
#client_encoding = LATIN9

in /var/lib/pgsql/data/postgresql.conf i will no longer have an
error... but got problems with charsets (i use frensh accents and arab
characters)

Here's what log contain :
here's what logs contain :
ATTENTION:  Laisse de ct les caractres UTF-8 inconvertibles 0xc389
ATTENTION:  Laisse de ct les caractres UTF-8 inconvertibles 0xf474e9
ATTENTION:  Laisse de ct les caractres UTF-8 inconvertibles 0xf474e9
ATTENTION:  Laisse de ct les caractres UTF-8 inconvertibles 0xf474e9
ATTENTION:  Laisse de ct les caractres UTF-8 inconvertibles 0xf474e9
PANIQUE:  ERRORDATA_STACK_SIZE exceeded
INSTRUCTION :  SELECT "MsgId" as msgid,"Content" as
content,"TimeCreated" as tc,"SOA" as oa FROM sms_mo WHERE
((LOWER("Content") LIKE 'club%')) AND (("DA"='87000'))  AND
("TimeCreated" > '2005-02-18 17:00:00') ORDER BY "MsgId" ASC;
TRACE:  processus serveur (PID 4359) a t arrt par le signal 6
TRACE:  Arrt des autres processus serveur actifs
TRACE:  Tous les processus serveur se sont arrts, rinitialisation
TRACE:  le systme de bases de donnes a t interrompu  2005-02-26
16:11:25 CET
TRACE:  l'enregistrement du point de vrification est  0/7BF31E0
TRACE:  r-excution de l'enregistrement  0/7BF31E0 ; l'annulation de
l'enregistrement est  0/0 ; arrt TRUE
TRACE:  prochain identifiant de transaction : 70998 ; prochain OID : 535489
TRACE:  le systme de bases de donnes n'a pas t arrt proprement
;
restauration automatique en cours
TRACE:  la r-excution commence  0/7BF321C
TRACE:  enregistrement de longueur nulle sur 0/7C05940
TRACE:  r-excution faite  0/7C05918
TRACE:  le systme de bases de donnes est prt

Here's what i have on my system :
postgresql-libs-8.0.0-1PGDG
postgresql-8.0.0-1PGDG
postgresql-devel-8.0.0-1PGDG
postgresql-server-8.0.0-1PGDG
PHP-5.0.2 with pgsql extension
and apache 2

pgsql-bugs by date

Next:From: Daniel AgutDate: 2005-02-28 12:38:13
Subject: Errors using Postgres 7.4.6
Previous:From: Thomas HallgrenDate: 2005-02-27 17:06:03
Subject: Re: BUG #1502: hash_seq_search might return removed entry

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