From: | Diana Cionoiu <diana(at)softwaresolutions(dot)ro> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: troubles with postgresql 7.0.2 |
Date: | 2001-05-03 08:00:56 |
Message-ID: | Pine.LNX.4.30.0105031057450.743-100000@tudor.softwaresolutions.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2001-05-03 08:06:41 | Re: stored procedures |
Previous Message | DaVinci | 2001-05-03 07:53:34 | Views and Rules again |