strange way to crash - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject strange way to crash
Date
Msg-id Pine.LNX.4.21.0106211701400.24987-100000@aluminum.cs.pitt.edu
Whole thread Raw
Responses Re: strange way to crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I tried running the same query twice at the same time from a shell script:

#!/bin/bash
/usr/bin/time psql dbname uname -c 'select * from a_view where condition' &
/usr/bin/time psql dbname uname -c 'select * from a_view where condition' &


The system (linux) hangs after some time and the strange thing is that I can change between vconsoles with Alt+F[1-6]
butno other keyboard input goes through <!> hence I reboot. 

The query executes fine when ran by itself. Why should it crash if ran twice?

cheers,
thalis


pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: index on a box
Next
From: Tom Lane
Date:
Subject: Re: index on a box