Re: error "11"

On Fri, Dec 22, 2000 at 07:57:56AM -0500, Rob Arnold wrote:
> Need more info. How are your starting up? What options? Connecting from
> another machine?

Sorry. I just don't know what might be important!

I am running everything locally, and my system was fine for days, then
this suddenly started. I made no configuration changes. In fact, from
the same virtual terminal I ran a sql script with

psql -f createschema.sql

which ran fine. I then ran my next script in sequence, which inserts
some static data into some of the tables, and that script aborted. So
I doubt it is a configuration issue.

> The log you sent says that the system shutdown, started and then shut down
> again. According to the log the system is not running at all after Thu Dec
> 21 16:47:28 2000.

I checked using "ps -A | grep postmaster" and it was running. Then I
ran ps again and postmaster is still running under the same pid.

> I am getting a strange error from psql:
>
> psql: connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost'
> and accepting connections on Unix socket '5432'?
>
> Yes, the postmaster is running. I can run psql -l and get a list of my
> databases just fine.
>
> This is from the log file:
>
> Server process (pid 18539) exited with status 11 at Thu Dec 21 16:45:54 2000
> Terminating any active server processes...
> Server processes were terminated at Thu Dec 21 16:45:54 2000
> Reinitializing shared memory and semaphores
> 001221.16:45:54.490 [18540] DEBUG: Data Base System is starting up at Thu
> Dec 21 16:45:54 2000
> 001221.16:45:54.490 [18540] DEBUG: Data Base System was interrupted being
> in production at Thu Dec 21 16:45:47 2000
> 001221.16:45:54.497 [18540] DEBUG: Data Base System is in production state
> at Thu Dec 21 16:45:54 2000
> Smart Shutdown request at Thu Dec 21 16:47:28 2000
> 001221.16:47:28.607 [18632] DEBUG: Data Base System shutting down at Thu
> Dec 21 16:47:28 2000
> 001221.16:47:28.614 [18632] DEBUG: Data Base System shut down at Thu Dec 21
> 16:47:28 2000
>
> Which I hope will shed some light on the problem.
>
> I have not only restarted my postgresql service, I have rebooted the
> machine just to make sure. And ruined my previously stellar uptime. :-)
>
> --
> Dr. David C. Merrill http://www.lupercalia.net
> Linux Documentation Project dmerrill(at)lupercalia(dot)net
> Collection Editor & Coordinator http://www.linuxdoc.org
> Finger me for my public key
>
> To attempt an understanding of Muad'Dib without understanding his mortal
> enemies, the Harkonnens, is to attempt seeing Truth without knowing
> Falsehood.
> It is the attempt to see the Light without knowing Darkness. It cannot be.
> -- from "Manual of Muad'Dib" by the Princess Irulan

--
Dr. David C. Merrill http://www.lupercalia.net
Linux Documentation Project dmerrill(at)lupercalia(dot)net
Collection Editor & Coordinator http://www.linuxdoc.org
Finger me for my public key

Mine is the secret
That opens upon the door of youth,
And Mine is the cup of wine of life,
That is the Cauldron of Ceridwen
That is the holy grail of immortality.
-- from The Charge of the Goddess, Doreen Valiente