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 |