strange way to crash

Started by Thalis A. Kalfigopoulosalmost 25 years ago2 messagesgeneral
Jump to latest
#1Thalis A. Kalfigopoulos
thalis@cs.pitt.edu

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] but no 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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thalis A. Kalfigopoulos (#1)
Re: strange way to crash

"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:

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

Could you have run the system out of swap space?

regards, tom lane