Re: troubles with postgresql 7.0.2 - Mailing list pgsql-general

> After working a while with postgresql 7.0.2 from redhat 7.0, with upgrates
> at glibc 2.2.2 and a few other improvements, i have kernel 2.2.17 from rh
> 7.0 updates.
> And today my postmaster died with :
>
> The Postmaster has informed me that some other backend died abnormally and
> possibly corrupted shared memory.
>         I have rolled back the current transaction and am going to
> terminate your database system connection and exit.
>
> and i wasn't able to start again.
>
> /usr/bin/postmaster: reaping dead processes...
> /usr/bin/postmaster: CleanupProc: pid 1483 exited with status 139
> Server process (pid 1483) exited with status 139 at Thu May  3 10:29:59
> 2001
> Terminating any active server processes...
> Server processes were terminated at Thu May  3 10:29:59 2001
> Reinitializing shared memory and semaphores
> 010503.10:29:59.379  [1477] shmem_exit(0)
> binding ShmemCreate(key=52e389, size=1104896)
> 010503.10:29:59.595  [1484] DEBUG:  Data Base System is starting up at Thu
> May
> 3 10:29:59 2001
> 010503.10:29:59.596  [1484] DEBUG:  Data Base System was interrupted being
> in production at Thu May  3 10:25:58 2001
> 010503.10:29:59.599  [1484] DEBUG:  Data Base System is in production
> state at Thu May  3 10:29:59 2001
> 010503.10:29:59.599  [1484] proc_exit(0)
> 010503.10:29:59.600  [1484] shmem_exit(0)
> 010503.10:29:59.600  [1484] exit(0)
> /usr/bin/postmaster: reaping dead processes...
>
> this is the error message now, and i have no idee how can i resolv this.
> i use /usr/bin/pg_ctl -o "-i -d 5" -D /[datadir] start &
>
> Diana Cionoiu

Escuze me, I have find out more, the database still working, but take some
time after that query. i have 2 querys from php.

$mumu = pg_exec ($conn, "SELECT idl,datapromulgari,tipdocument,denumirea
from ldi where categoria=" . $categorie. " and denumirea LIKE '%" .
$denumirea . "%' and substr(dataemiterii,1,2) LIKE '%" . $luna ."%' and
substr(dataemiterii,3,2) LIKE '%" . $zi . "%' and substr(dataemiterii,5,4)
LIKE '%" . $an . "%' and descriere LIKE '%" . $descriere . "%' and
organemitent LIKE '%" . chop($organ) . "%' and publicat LIKE '%" .
chop($tippub) ."%' and tipdocument LIKE '%"  . chop($tipdoc). "%' order by
to_date(dataemiterii,'MMDDYYYY') ASC LIMIT "  . $nrlegi . "," . $nr );

first is working.

        $mimuv = pg_exec ($conn, "SELECT idl from ldi where categoria=" .
$categorie. " and denumirea LIKE '%" . $denumirea . "%' and
substr(dataemiterii,1,2) LIKE '%" . $luna ."%' and
substr(dataemiterii,3,2) LIKE '%" . $zi . "%' and substr(dataemiterii,5,4)
LIKE '%" . $an . "%' and descriere LIKE '%" . $descriere . "%' and
organemitent LIKE '%" . chop($organ) . "%' and publicat LIKE '%" .
chop($tippub) ."%' and tipdocument LIKE '%" . chop($tipdoc). "%'" );

second executed after first, give me the error message.

Diana