[jira] [Commented] (HAWQ-1494) The bug can appear every time when I execute a specific sql: Unexpect internal error (setref.c:298), server closed the connection unexpectedly

2017-07-11 Thread fangpei (JIRA)

[ 
https://issues.apache.org/jira/browse/HAWQ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16082438#comment-16082438
 ] 

fangpei commented on HAWQ-1494:
---

To Ed Espino: I see, thanks!

> The bug can appear every time when I execute a specific sql:  Unexpect 
> internal error (setref.c:298), server closed the connection unexpectedly
> ---
>
> Key: HAWQ-1494
> URL: https://issues.apache.org/jira/browse/HAWQ-1494
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: fangpei
>Assignee: Radar Lei
> Fix For: 2.3.0.0-incubating
>
>
> When I execute a specific sql, a serious bug can happen every time. (Hawq 
> version is 2.2.0.0)
> BUG information:
> FATAL: Unexpect internal error (setref.c:298)
> DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
> list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
> Line: 298)
> HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
> termination.
> Note that its locks and other resources will not be released  until then.
> 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. Attemping reset: Succeeded.
> I use GDB to debug, the GDB information is the same every time. The 
> information is: 
> Loaded symbols for /lib64/libnss_files.so.2
> 0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
> (gdb) b setrefs.c:298
> Breakpoint 1 at 0x846063: file setrefs.c, line 298.
> (gdb) c 
> Continuing.
> Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
> plan=0x7fe8e930adb8) at setrefs.c:298
> 298 set ref s .c:没有那个文件或目录.
> (gdb) c 1923
> Will ignore next 1922 crossings of breakpoint 1. Continuing.
> Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
> plan=0x7fe869c70340) at setrefs.c:298
> 298 in setrefs.c
> (gdb) p list_length(allVars) 
> $1 = 1422
> (gdb) p var->varno 
> $2 = 65001
> (gdb) p list_length(glob->finalrtable) 
> $3 = 66515
> (gdb) p var->varattno 
> $4 = 31
> (gdb) p list_length(colNames) 
> $5 = 30
> (gdb) p list_length(rte->pseudocols) 
> $6 = 0
> the SQL sentence is just like :
> SELECT *
> FROM (select t.*,1001 as ttt from AAA t where  ( aaa = '3201066235'  
> or aaa = '3201066236'  or aaa = '3201026292'  or aaa = 
> '3201066293'  or aaa = '3201060006393' ) and (  bbb between 
> '20170601065900' and '20170601175100'  and (ccc = '2017-06-01' ))  union all  
> select t.*,1002 as ttt from AAA t where  ( aaa = '3201066007'  or aaa 
> = '3201066006' ) and (  bbb between '20170601072900' and 
> '20170601210100'  and ( ccc = '2017-06-01' ))  union all  select t.*,1003 as 
> ttt from AAA t where  ( aaa = '3201062772' ) and (  bbb between 
> '20170601072900' and '20170601170100'  and ( ccc = '2017-06-01' ))  union all 
>  select t.*,1004 as ttt from AAA t where  (aaa = '3201066115'  or aaa 
> = '3201066116'  or aaa = '3201066318'  or aaa = 
> '3201066319' ) and (  bbb between '20170601085900' and 
> '20170601163100' and ( ccc = '2017-06-01' ))  union all  select t.*,1005 as 
> ttt from AAA t where  ( aaa = '3201066180' or aaa = 
> '3201046385' ) and (  bbb between '20170601205900' and 
> '20170601230100'  and ( ccc = '2017-06-01' )) union all  select t.*,1006 as 
> ttt from AAA t where  ( aaa = '3201026423'  or aaa = 
> '3201026255'  or aaa = '3201066258'  or aaa = 
> '3201066259' ) and (  bbb between '20170601215900' and 
> '20170602004900'  and ( ccc = '2017-06-01'  or ccc = '2017-06-02' ))  union 
> all select t.*,1007 as ttt from AAA t where  ( aaa = '3201066175' or 
> aaa = '3201066004' ) and (  bbb between '20170602074900' and 
> '20170602182100'  and ( ccc = '2017-06-02'  )) union all select t.*,1008 as 
> ttt from AAA t where  ( aaa = '3201026648' ) and (  bbb between 
> '20170602132900' and '20170602134600'  and ( ccc = '2017-06-02' ))  union all 
>  select t.*,1009 as ttt from AAA t where  ( aaa = '3201062765'  or 
> aaa = '3201006282' ) and (  bbb between '20170602142900' and 
> '20170603175100'  and ( ccc = '2017-06-02'  or ccc = '2017-06-03' ))  union 
> all  select t.*,1010 as ttt from AAA t where  (aaa = '3201066060' ) 
> and (  bbb between '20170602165900' and '20170603034100'  and ( ccc = 
> '2017-06-02'  or ccc = '2017-06-03' ))  union all select t.*,1011 as ttt from 
> AAA t where  ( aaa = '32010662229'  or aaa = '3201066230'  or 
> aaa = '3201022783'  or aaa = '3201026304' 

[jira] [Updated] (HAWQ-1494) The bug can appear every time when I execute a specific sql: Unexpect internal error (setref.c:298), server closed the connection unexpectedly

2017-07-06 Thread fangpei (JIRA)

 [ 
https://issues.apache.org/jira/browse/HAWQ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

fangpei updated HAWQ-1494:
--
Description: 
When I execute a specific sql, a serious bug can happen every time. (Hawq 
version is 2.2.0.0)

BUG information:
FATAL: Unexpect internal error (setref.c:298)
DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
Line: 298)
HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
termination.
Note that its locks and other resources will not be released  until then.
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. Attemping reset: Succeeded.

I use GDB to debug, the GDB information is the same every time. The information 
is: 
Loaded symbols for /lib64/libnss_files.so.2
0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
(gdb) b setrefs.c:298
Breakpoint 1 at 0x846063: file setrefs.c, line 298.
(gdb) c 
Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe8e930adb8) at setrefs.c:298
298 set ref s .c:没有那个文件或目录.
(gdb) c 1923
Will ignore next 1922 crossings of breakpoint 1. Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe869c70340) at setrefs.c:298
298 in setrefs.c
(gdb) p list_length(allVars) 
$1 = 1422
(gdb) p var->varno 
$2 = 65001
(gdb) p list_length(glob->finalrtable) 
$3 = 66515
(gdb) p var->varattno 
$4 = 31
(gdb) p list_length(colNames) 
$5 = 30
(gdb) p list_length(rte->pseudocols) 
$6 = 0

the SQL sentence is just like :
SELECT *
FROM (select t.*,1001 as ttt from AAA t where  ( aaa = '3201066235'  or 
aaa = '3201066236'  or aaa = '3201026292'  or aaa = 
'3201066293'  or aaa = '3201060006393' ) and (  bbb between 
'20170601065900' and '20170601175100'  and (ccc = '2017-06-01' ))  union all  
select t.*,1002 as ttt from AAA t where  ( aaa = '3201066007'  or aaa = 
'3201066006' ) and (  bbb between '20170601072900' and '20170601210100' 
 and ( ccc = '2017-06-01' ))  union all  select t.*,1003 as ttt from AAA t 
where  ( aaa = '3201062772' ) and (  bbb between '20170601072900' and 
'20170601170100'  and ( ccc = '2017-06-01' ))  union all  select t.*,1004 as 
ttt from AAA t where  (aaa = '3201066115'  or aaa = 
'3201066116'  or aaa = '3201066318'  or aaa = 
'3201066319' ) and (  bbb between '20170601085900' and '20170601163100' 
and ( ccc = '2017-06-01' ))  union all  select t.*,1005 as ttt from AAA t where 
 ( aaa = '3201066180' or aaa = '3201046385' ) and (  bbb 
between '20170601205900' and '20170601230100'  and ( ccc = '2017-06-01' )) 
union all  select t.*,1006 as ttt from AAA t where  ( aaa = 
'3201026423'  or aaa = '3201026255'  or aaa = 
'3201066258'  or aaa = '3201066259' ) and (  bbb between 
'20170601215900' and '20170602004900'  and ( ccc = '2017-06-01'  or ccc = 
'2017-06-02' ))  union all select t.*,1007 as ttt from AAA t where  ( aaa = 
'3201066175' or aaa = '3201066004' ) and (  bbb between 
'20170602074900' and '20170602182100'  and ( ccc = '2017-06-02'  )) union all 
select t.*,1008 as ttt from AAA t where  ( aaa = '3201026648' ) and (  
bbb between '20170602132900' and '20170602134600'  and ( ccc = '2017-06-02' ))  
union all  select t.*,1009 as ttt from AAA t where  ( aaa = 
'3201062765'  or aaa = '3201006282' ) and (  bbb between 
'20170602142900' and '20170603175100'  and ( ccc = '2017-06-02'  or ccc = 
'2017-06-03' ))  union all  select t.*,1010 as ttt from AAA t where  (aaa = 
'3201066060' ) and (  bbb between '20170602165900' and '20170603034100' 
 and ( ccc = '2017-06-02'  or ccc = '2017-06-03' ))  union all select t.*,1011 
as ttt from AAA t where  ( aaa = '32010662229'  or aaa = 
'3201066230'  or aaa = '3201022783'  or aaa = 
'3201026304' ) and (  bbb between '20170603192900' and '20170604183100' 
 and ( ccc = '2017-06-03'  or ccc = '2017-06-04' ))  union all select t.*,1012 
as ttt from AAA t where  ( aaa = '3201136549' ) and (  bbb between 
'20170604071947' and '20170604220100'  and ( ccc = '2017-06-04' ))  union all 
select t.*1013 as ttt from AAA t where  ( aaa = '3201066061'  or aaa = 
'3201066062' ) and (  bbb between '20170604145900' and '20170604154100' 
 and ( ccc = '2017-06-04' ))  ) T0 
WHERE EXISTS (SELECT HHH
  FROM (SELECT HHH, COUNT(*)
  FROM (SELECT HHH, ttt, COUNT(*)
  FROM (select t.*,1001 as ttt from AAA t where  ( aaa = '3201066235'  
or aaa = '3201066236'  or aaa = '3201026292'  or aaa = 
'3201066293'  or aaa = '3201066393' ) and (  bbb between 

[jira] [Updated] (HAWQ-1494) The bug can appear every time when I execute a specific sql: Unexpect internal error (setref.c:298), server closed the connection unexpectedly

2017-07-03 Thread fangpei (JIRA)

 [ 
https://issues.apache.org/jira/browse/HAWQ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

fangpei updated HAWQ-1494:
--
Description: 
When I execute a specific sql, a serious bug can happen every time. (Hawq 
version is 2.2.0.0)

BUG information:
FATAL: Unexpect internal error (setref.c:298)
DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
Line: 298)
HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
termination.
Note that its locks and other resources will not be released  until then.
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. Attemping reset: Succeeded.

I use GDB to debug, the GDB information is the same every time. The information 
is: 
Loaded symbols for /lib64/libnss_files.so.2
0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
(gdb) b setrefs.c:298
Breakpoint 1 at 0x846063: file setrefs.c, line 298.
(gdb) c 
Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe8e930adb8) at setrefs.c:298
298 set ref s .c:没有那个文件或目录.
(gdb) c 1923
Will ignore next 1922 crossings of breakpoint 1. Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe869c70340) at setrefs.c:298
298 in setrefs.c
(gdb) p list_length(allVars) 
$1 = 1422
(gdb) p var->varno 
$2 = 65001
(gdb) p list_length(glob->finalrtable) 
$3 = 66515
(gdb) p var->varattno 
$4 = 31
(gdb) p list_length(colNames) 
$5 = 30
(gdb) p list_length(rte->pseudocols) 
$6 = 0

the SQL sentence is long, Occupies the entire screen, total 45 lines. the SQL 
sentence contain "nested select", many "union all", "where", "or", "and", and 
also have "group by" and "having".

I try to "explain this SQL" to get the execution plan, but it report the same 
error, and then can not get the execution plan.
I also try to "set optimizer=off" and retry the SQL sentence, but the same 
error happen, and "show optimizer" the optimizer  is "on" (automatically set 
"on").

  was:
When I execute a specific sql, a serious bug can happen every time. (Hawq 
version is 2.2.0.0)

BUG information:
FATAL: Unexpect internal error (setref.c:298)
DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
Line: 298)
HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
termination.
Note that its locks and other resources will not be released  until then.
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. Attemping reset: Succeeded.

I use GDB to debug, the GDB information is the same every time. The information 
is: 
Loaded symbols for /lib64/libnss_files.so.2
0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
(gdb) b setrefs.c:298
Breakpoint 1 at 0x846063: file setrefs.c, line 298.
(gdb) c 
Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe8e930adb8) at setrefs.c:298
298 set ref s .c:没有那个文件或目录.
(gdb) c 1923
Will ignore next 1922 crossings of breakpoint 1. Continuing.
Breakpoint 1, set_plan_referencesj〇utput_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe869c70340) at setrefs.c:298
298 in setrefs.c
(gdb) p list_length(allVars) 
$1 = 1422
(gdb) p var->varno 
$2 = 65001
(gdb) p list_length(glob->finalrtable) 
$3 = 66515
(gdb) p var->varattno 
$4 = 31
(gdb) p list_length(colNames) 
$5 = 30
(gdb) p list_length(rte->pseudocols) 
$6 = 0

the SQL sentence is long, Occupies the entire screen, total 45 lines. the SQL 
sentence contain "nested select", many "union all", "where", "or", "and", and 
also have "group by" and "having".

I try to "explain this SQL" to get the execution plan, but it report the same 
error, and then can not get the execution plan.
I also try to "set optimizer=off" and retry the SQL sentence, but the same 
error happen, and "show optimizer" the optimizer  is "on" (automatically set 
"on").


> The bug can appear every time when I execute a specific sql:  Unexpect 
> internal error (setref.c:298), server closed the connection unexpectedly
> ---
>
> Key: HAWQ-1494
> URL: https://issues.apache.org/jira/browse/HAWQ-1494
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: fangpei
>Assignee: Radar Lei
> Fix For: 2.2.0.0-incubating
>
>
> When I execute a specific sql, a serious bug can happen every time. (Hawq 
> version is 2.2.0.0)
> BUG 

[jira] [Updated] (HAWQ-1494) The bug can appear every time when I execute a specific sql: Unexpect internal error (setref.c:298), server closed the connection unexpectedly

2017-07-02 Thread fangpei (JIRA)

 [ 
https://issues.apache.org/jira/browse/HAWQ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

fangpei updated HAWQ-1494:
--
Description: 
When I execute a specific sql, a serious bug can happen every time. (Hawq 
version is 2.2.0.0)

BUG information:
FATAL: Unexpect internal error (setref.c:298)
DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
Line: 298)
HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
termination.
Note that its locks and other resources will not be released  until then.
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. Attemping reset: Succeeded.

I use GDB to debug, the GDB information is the same every time. The information 
is: 
Loaded symbols for /lib64/libnss_files.so.2
0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
(gdb) b setrefs.c:298
Breakpoint 1 at 0x846063: file setrefs.c, line 298.
(gdb) c 
Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe8e930adb8) at setrefs.c:298
298 set ref s .c:没有那个文件或目录.
(gdb) c 1923
Will ignore next 1922 crossings of breakpoint 1. Continuing.
Breakpoint 1, set_plan_referencesj〇utput_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe869c70340) at setrefs.c:298
298 in setrefs.c
(gdb) p list_length(allVars) 
$1 = 1422
(gdb) p var->varno 
$2 = 65001
(gdb) p list_length(glob->finalrtable) 
$3 = 66515
(gdb) p var->varattno 
$4 = 31
(gdb) p list_length(colNames) 
$5 = 30
(gdb) p list_length(rte->pseudocols) 
$6 = 0

the SQL sentence is long, Occupies the entire screen, total 45 lines. the SQL 
sentence contain "nested select", many "union all", "where", "or", "and", and 
also have "group by" and "having".

I try to "explain this SQL" to get the execution plan, but it report the same 
error, and then can not get the execution plan.
I also try to "set optimizer=off" and retry the SQL sentence, but the same 
error happen, and "show optimizer" the optimizer  is "on" (automatically set 
"on").

  was:
When I execute a specific sql, a serious bug can happen every time. (Hawq 
version is 2.2.0.0)

BUG information:
FATAL: Unexpect internal error (setref.c:298)
DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
Line: 298)
HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
termination.
Note that its locks and other resources will not be released  until then.
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. Attemping reset: Succeeded.

I use GDB to debug, the GDB information is the same every time. The information 
is: 
Loaded symbols for /lib64/libnss_files.so.2
0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
(gdb) b setrefs.c:298
Breakpoint 1 at 0x846063: file setrefs.c, line 298.
(gdb) c 
Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe8e930adb8) at setrefs.c:298
298 set ref s .c:没有那个文件或目录.
(gdb) c 1923
Will ignore next 1922 crossings of breakpoint 1. Continuing.
Breakpoint 1, set_plan_referencesj〇utput_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe869c70340) at setrefs.c:298
298 in setrefs.c
(gdb) p list_length(allVars) 
$1 = 1422
(gdb) p var->varno 
$2 = 65001
(gdb) p list_length(glob->finalrtable) 
$3 = 66515
(gdb) p var->varattno 
$4 = 31
(gdb) p list_length(colNames) 
$5 = 30
(gdb) p list_length(rte->pseudocols) 
$6 = 0

the SQL sentence is long, Occupies the entire screen, total 45 lines. the SQL 
sentence contain "nested select", many "union all", "where", "or", "and", and 
also have "group by" and "having".

I try to "explain this SQL" to get the execution plan, but it report the same 
error, and then can get the execution plan.
I also try to "set optimizer=off" and retry the SQL sentence, but the same 
error happen, and "show optimizer" the optimizer  is "on" (automatically set 
"on").


> The bug can appear every time when I execute a specific sql:  Unexpect 
> internal error (setref.c:298), server closed the connection unexpectedly
> ---
>
> Key: HAWQ-1494
> URL: https://issues.apache.org/jira/browse/HAWQ-1494
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: fangpei
>Assignee: Radar Lei
> Fix For: 2.2.0.0-incubating
>
>
> When I execute a specific sql, a serious bug can happen every time. (Hawq 
> version is 2.2.0.0)
> BUG 

[jira] [Created] (HAWQ-1494) The bug can appear every time when I execute a specific sql: Unexpect internal error (setref.c:298), server closed the connection unexpectedly

2017-07-02 Thread fangpei (JIRA)
fangpei created HAWQ-1494:
-

 Summary: The bug can appear every time when I execute a specific 
sql:  Unexpect internal error (setref.c:298), server closed the connection 
unexpectedly
 Key: HAWQ-1494
 URL: https://issues.apache.org/jira/browse/HAWQ-1494
 Project: Apache HAWQ
  Issue Type: Bug
  Components: Core
Reporter: fangpei
Assignee: Radar Lei
 Fix For: 2.2.0.0-incubating


When I execute a specific sql, a serious bug can happen every time. (Hawq 
version is 2.2.0.0)

BUG information:
FATAL: Unexpect internal error (setref.c:298)
DETAIL: AssertImply failed("!(!var->varattno >= 0) || (var->varattno <= 
list_length(colNames) + list_length(rte- >pseudocols)))", File: "setrefs.c", 
Line: 298)
HINT:  Process 239600 will wait for gp_debug_linger=120 seconds before 
termination.
Note that its locks and other resources will not be released  until then.
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. Attemping reset: Succeeded.

I use GDB to debug, the GDB information is the same every time. The information 
is: 
Loaded symbols for /lib64/libnss_files.so.2
0x0032dd40eb5c in recv 0 from /lib64/libpthread.so.0
(gdb) b setrefs.c:298
Breakpoint 1 at 0x846063: file setrefs.c, line 298.
(gdb) c 
Continuing.
Breakpoint 1, set_plan_references_output_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe8e930adb8) at setrefs.c:298
298 set ref s .c:没有那个文件或目录.
(gdb) c 1923
Will ignore next 1922 crossings of breakpoint 1. Continuing.
Breakpoint 1, set_plan_referencesj〇utput_asserts (glob=0x7fe96fbccab0, 
plan=0x7fe869c70340) at setrefs.c:298
298 in setrefs.c
(gdb) p list_length(allVars) 
$1 = 1422
(gdb) p var->varno 
$2 = 65001
(gdb) p list_length(glob->finalrtable) 
$3 = 66515
(gdb) p var->varattno 
$4 = 31
(gdb) p list_length(colNames) 
$5 = 30
(gdb) p list_length(rte->pseudocols) 
$6 = 0

the SQL sentence is long, Occupies the entire screen, total 45 lines. the SQL 
sentence contain "nested select", many "union all", "where", "or", "and", and 
also have "group by" and "having".

I try to "explain this SQL" to get the execution plan, but it report the same 
error, and then can get the execution plan.
I also try to "set optimizer=off" and retry the SQL sentence, but the same 
error happen, and "show optimizer" the optimizer  is "on" (automatically set 
"on").



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)


[jira] [Commented] (HAWQ-1471) "Build and Install" under Red Hat 6.X environment, gcc / gcc-c++ version 4.7.2 is too low to install hawq

2017-05-24 Thread fangpei (JIRA)

[ 
https://issues.apache.org/jira/browse/HAWQ-1471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16022711#comment-16022711
 ] 

fangpei commented on HAWQ-1471:
---

OK, thank you! After you modified the wiki page, the description of the GCC 
version became clear, and this can make more users avoid this error. Cool!

> "Build and Install" under Red Hat 6.X environment, gcc / gcc-c++ version 
> 4.7.2 is too low to install hawq
> -
>
> Key: HAWQ-1471
> URL: https://issues.apache.org/jira/browse/HAWQ-1471
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: fangpei
>Assignee: Paul Guo
> Fix For: 2.3.0.0-incubating
>
>
> My OS environment is Red Hat 6.5. I referred to the  website 
> "https://cwiki.apache.org//confluence/display/HAWQ/Build+and+Install; to 
> build and install hawq. I installed the GCC version specified on the website 
> (gcc 4.7.2 / gcc-c++ 4.7.2), but the error happened:
> "error: 'Hdfs::Internal::Once' cannot be thread-local because it has 
> non-trivial type 'std::once_flag'" 
> or
> "error : 'Yarn:Internal::Once' cannot be thread-local because it has 
> non-trivial type 'std::once_flag'"
> I found that GCC support for C ++ 11 is not good, leading to the 
> emergence of the error.
> So I installed gcc 4.8.5 / gcc-c++ 4.8.5, and the problem was resolved. 
> gcc / gcc-c++ version 4.7.2 is too low to install hawq, I suggest 
> updating the website about gcc / gcc-c++ version requirement.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Updated] (HAWQ-1471) "Build and Install" under Red Hat 6.X environment, gcc / gcc-c++ version 4.7.2 is too low to install hawq

2017-05-23 Thread fangpei (JIRA)

 [ 
https://issues.apache.org/jira/browse/HAWQ-1471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

fangpei updated HAWQ-1471:
--
Description: 
My OS environment is Red Hat 6.5. I referred to the  website 
"https://cwiki.apache.org//confluence/display/HAWQ/Build+and+Install; to build 
and install hawq. I installed the GCC version specified on the website (gcc 
4.7.2 / gcc-c++ 4.7.2), but the error happened:
"error: 'Hdfs::Internal::Once' cannot be thread-local because it has 
non-trivial type 'std::once_flag'" 
or
"error : 'Yarn:Internal::Once' cannot be thread-local because it has 
non-trivial type 'std::once_flag'"
I found that GCC support for C ++ 11 is not good, leading to the emergence 
of the error.
So I installed gcc 4.8.5 / gcc-c++ 4.8.5, and the problem was resolved. 
gcc / gcc-c++ version 4.7.2 is too low to install hawq, I suggest updating 
the website about gcc / gcc-c++ version requirement.

  was:
My OS environment is Red Hat 6.5. I referred to the  website 
"https://cwiki.apache.org//confluence/display/HAWQ/Build+and+Install; to build 
and install hawq. I installed the GCC version specified on the website (gcc 
4.7.2 / gcc-c++ 4.7.2), but the error happened:
"error: 'Hdfs::Internal::Once' cannot be thread-local because it has 
non-trivial type 'std::once_flag'" 
or
"error : 'Yarn:Internal::Once' cannot be thread-local because it has 
non-trivial type 'std::once_flag'"
I found that GCC support for C ++ 11 is not good, leading to the emergence 
of the error.
So I installed gcc 4.8.5, and the problem was resolved. 
gcc / gcc-c++ version 4.7.2 is too low to install hawq, I suggest updating 
the website about gcc / gcc-c++ version requirement.


> "Build and Install" under Red Hat 6.X environment, gcc / gcc-c++ version 
> 4.7.2 is too low to install hawq
> -
>
> Key: HAWQ-1471
> URL: https://issues.apache.org/jira/browse/HAWQ-1471
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: fangpei
>Assignee: Ed Espino
>
> My OS environment is Red Hat 6.5. I referred to the  website 
> "https://cwiki.apache.org//confluence/display/HAWQ/Build+and+Install; to 
> build and install hawq. I installed the GCC version specified on the website 
> (gcc 4.7.2 / gcc-c++ 4.7.2), but the error happened:
> "error: 'Hdfs::Internal::Once' cannot be thread-local because it has 
> non-trivial type 'std::once_flag'" 
> or
> "error : 'Yarn:Internal::Once' cannot be thread-local because it has 
> non-trivial type 'std::once_flag'"
> I found that GCC support for C ++ 11 is not good, leading to the 
> emergence of the error.
> So I installed gcc 4.8.5 / gcc-c++ 4.8.5, and the problem was resolved. 
> gcc / gcc-c++ version 4.7.2 is too low to install hawq, I suggest 
> updating the website about gcc / gcc-c++ version requirement.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (HAWQ-1471) "Build and Install" under Red Hat 6.X environment, gcc / gcc-c++ version 4.7.2 is too low to install hawq

2017-05-23 Thread fangpei (JIRA)
fangpei created HAWQ-1471:
-

 Summary: "Build and Install" under Red Hat 6.X environment, gcc / 
gcc-c++ version 4.7.2 is too low to install hawq
 Key: HAWQ-1471
 URL: https://issues.apache.org/jira/browse/HAWQ-1471
 Project: Apache HAWQ
  Issue Type: Improvement
  Components: Build
Reporter: fangpei
Assignee: Ed Espino


My OS environment is Red Hat 6.5. I referred to the  website 
"https://cwiki.apache.org//confluence/display/HAWQ/Build+and+Install; to build 
and install hawq. I installed the GCC version specified on the website (4.7.2 / 
gcc-c++ 4.7.2), but the error happened:
"error: 'Hdfs::Internal::Once' cannot be thread-local because it has 
non-trivial type 'std::once_flag'" 
or
"error : 'Yarn:Internal::Once' cannot be thread-local because it has 
non-trivial type 'std::once_flag'"
I found that GCC support for C ++ 11 is not good, leading to the emergence 
of the error.
So I installed gcc 4.8.5, and the problem was resolved. 
gcc / gcc-c++ version 4.7.2 is too low to install hawq, I suggest updating 
the website about gcc / gcc-c++ version requirement.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)