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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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