|
From: mei le <lem...@ya...> - 2010-10-20 01:37:51
|
Dears,
steps:
1.create table tt1(a int);
2.create table tt2(a int);
3.insert into tt1 values(1);insert into tt2 values(1);
4.select count(*) from tt1,tt2;
template1=# select count(*) from tt1,tt2;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: LOG: server process (PID 2239) was terminated by signal 11: Segmentation fault
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2010-10-20 09:36:17 CST
LOG: database system was not properly shut down; automatic recovery in progress
FATAL: failed to connect to pool manager: Connection refused
Failed.
!> LOG: record with zero length at 0/4DA980
LOG: redo is not required
Using aggregate functions on mutiple tables join will all cause such a problem.
Benny
|