Re: Error: server closed the connection unexpectedely

I believe this is a known problem with the cygwin version of 7.4.1.
7.4.2 should be available soon now that cygwin 1.5.10 has been
released. I believe their was a post in the pgsql-cygwin mailing list
from Jason Tishler with the reasons for waiting for 1.5.10.

Hopefully Jason can release 7.4.2 soon.

On Wed, 2004-05-26 at 09:17, Janez Kostanjek wrote:
> Hello everyone,
>
> this is my first post to postgres mailing list.
>
> System that I use:
> I am using Postgres under last CygWin published on public mirrors at
> the moment.
> OS system runing is Windows 2000 professional, 1024 or 256 or 512 MB
> of RAM and 40Gb of disk.
> Postmaster shows version 7.4.1
>
> Problem:
> When trying to create database using script file (containing only
> create DB, USERS, TABLES, INDEXES inside tables) using psql or
> pgadminIII after awhile (5 seconds or so) I get next error:
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> in log file I get this:
>
> LOG: server process (PID 1080) was terminated by signal 11
> LOG: terminating any other active server processes
> LOG: all server processes terminated; reinitializing
> LOG: database system was interrupted at 2004-05-26 15:55:48 CEDT
> LOG: checkpoint record is at 0/9DE7C8
> LOG: redo record is at 0/9DE7C8; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 534; next OID: 17142
> LOG: database system was not properly shut down; automatic recovery
> in progress
> LOG: redo starts at 0/9DE808
> LOG: startup process (PID 1396) was terminated by signal 11
> LOG: aborting startup due to startup process failure
>
> This error happens sooner if I use pgadminIII and later if I use psql.
> I have instaled ipc-daemon2. I tried also with cygserver configuring
> enough memory, nothing happened.
> I suspect error is somehow connected with size of one transaction. If
> transaction is small everything is OK. if transaction is large, this
> error happens.
>
> I get the same error when doing vacuum analyze or when inserting
> larger amount of staff into database inside one transaction.
>
> I tried to set next parameters from min to max in postgresql.conf but
> nothing helps (I get the same error).
> shared_buffers = 10000
> sort_mem = 2048
> vacuum_mem = 8192
> fsync = true
> wal_buffers = 32
> effective_cash_size = 5000
> default_statistics_target = 50
> tcpip_socket = true
> max_connections = 32
> other parameters are as default (I tried also with all parameters as
> default but problem remains the same).
>
> I also tested memory (RAM), tests came out OK.
>
>
> One interesting thing more:
> On Linux RH8.0, Postgres 7.4.2 everything works fine. Also tried with
> the same postgresql.conf file on Linux,postgres 7.4.2. works ok, on
> Windows under CygWin, last postgres 7.4.1 have this error.
>
>
>
>
> if somebody have a clue, what is going on here, please help.
>
> Janez Kostanjsek
> software engineer
>
>
>