Menu
▾
▴
postgres-xc-developers
|
From: mei le <lem...@ya...> - 2010-10-18 02:49:52
|
Dears,
One bug occured.
template1=# create table t2(a int primary key);
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 2429) was terminated by signal 11: Segmentation fault
LOG: terminating any other active server processes
FATAL: failed to connect to pool manager: Connection refused
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
Failed.
!>
Truely,
Benny
|
|
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
|
|
From: Koichi S. <ko...@in...> - 2010-10-20 01:48:14
|
Hi, I'm afraid "from tt1, tt2" causes curtesian product of two tables, which may not be supported at present version. I suppose "select count(*) from tt1;" and "select count(*) from tt2;" will run without problems. Cheers; --- Koichi (2010年10月20日 10:37), mei le wrote: > 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 > > > > > ------------------------------------------------------------------------------ > Download new Adobe(R) Flash(R) Builder(TM) 4 > The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly > Flex(R) Builder(TM)) enable the development of rich applications that run > across multiple browsers and platforms. Download your free trials today! > http://p.sf.net/sfu/adobe-dev2dev > > > > _______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers |
|
From: Mason S. <mas...@en...> - 2010-10-20 15:27:16
|
Benny, Thanks for reporting this. It turns out this is working in the PGXC-sqlmed branch in the git repository. This branch will be merged into HEAD sometime soon and the issue will no longer occur. In general there are some improvements we should do for cartesian products. Thanks, Mason On 10/19/10 9:49 PM, Koichi Suzuki wrote: > Hi, > > I'm afraid "from tt1, tt2" causes curtesian product of two tables, which > may not be supported at present version. > I suppose "select count(*) from tt1;" and "select count(*) from tt2;" > will run without problems. > > Cheers; > --- > Koichi > > (2010年10月20日 10:37), mei le wrote: > >> 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 >> >> >> >> >> ------------------------------------------------------------------------------ >> Download new Adobe(R) Flash(R) Builder(TM) 4 >> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly >> Flex(R) Builder(TM)) enable the development of rich applications that run >> across multiple browsers and platforms. Download your free trials today! >> http://p.sf.net/sfu/adobe-dev2dev >> >> >> >> _______________________________________________ >> Postgres-xc-developers mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers >> > > ------------------------------------------------------------------------------ > Download new Adobe(R) Flash(R) Builder(TM) 4 > The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly > Flex(R) Builder(TM)) enable the development of rich applications that run > across multiple browsers and platforms. Download your free trials today! > http://p.sf.net/sfu/adobe-dev2dev > _______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers > -- Mason Sharp EnterpriseDB Corporation The Enterprise Postgres Company This e-mail message (and any attachment) is intended for the use of the individual or entity to whom it is addressed. This message contains information from EnterpriseDB Corporation that may be privileged, confidential, or exempt from disclosure under applicable law. If you are not the intended recipient or authorized to receive this for the intended recipient, any use, dissemination, distribution, retention, archiving, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete this message. |
|
From: Mason S. <mas...@en...> - 2010-10-18 04:51:57
|
Hi Benny, This was one of the items on the bug list I had previously sent to you. Thanks, Mason Sent from my IPhone On Oct 17, 2010, at 10:49 PM, mei le <lem...@ya...> wrote: > Dears, > > One bug occured. > > template1=# create table t2(a int primary key); > 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 2429) was terminated by signal 11: Segmentation fault > LOG: terminating any other active server processes > FATAL: failed to connect to pool manager: Connection refused > WARNING: terminating connection because of crash of another server process > DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. > HINT: In a moment you should be able to reconnect to the database and repeat your command. > Failed. > !> > > > Truely, > Benny > > > ------------------------------------------------------------------------------ > Download new Adobe(R) Flash(R) Builder(TM) 4 > The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly > Flex(R) Builder(TM)) enable the development of rich applications that run > across multiple browsers and platforms. Download your free trials today! > http://p.sf.net/sfu/adobe-dev2dev > _______________________________________________ > Postgres-xc-developers mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X