You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:19:45 UTC
[jira] [Created] (TRAFODION-1105) LP Bug: 1438372 - Compiler
returns internal error from ../optimizer/opt.cpp line 6907
Alice Chen created TRAFODION-1105:
-------------------------------------
Summary: LP Bug: 1438372 - Compiler returns internal error from ../optimizer/opt.cpp line 6907
Key: TRAFODION-1105
URL: https://issues.apache.org/jira/browse/TRAFODION-1105
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Weishiun Tsai
Assignee: justin.du@hp.com
Priority: Critical
Fix For: 2.0-incubating
We are seeing an alarming rate of random compiler internal errors from ../optimizer/opt.cpp, line 6907:
*** ERROR[2235] Compiler Internal Error: Cannot produce a plan in optimizer pass one, originated from file ../optimizer/opt.cpp at line 6907.
The error is often returned from a simple DDL operation, such as a create table statement, or a create index statement. Sometimes it is also returned from the update statistics statement. Unfortunately, there is no certain way to reproduce this problem. The operations that saw this error were very basic operations and reran the same tests often did not reproduce the error again. However, in the last full SQL regression run on the v0327 build installed on a 6-node cluster, we saw a total of 223 occurrences of this error, which is quite alarming.
-bash-4.1$ grep "Compiler Internal Error" */*.log | grep 2235 | grep 6907 | wc -l
223
This bug report is filed to see if some analysis can be done from the source code to figure out why compiler is returning this internal error at such a high rate.
Here are some examples of the SQL operations returning this error from the v0327 run:
-----------------------------------
arkcase/arkt0149.log
SQL>create table b4table2
(a int not null, b int not null, c varchar(100) not null,
primary key (a));
--- SQL operation complete.
SQL>create index b4tab1x
on b4table1 (b);
*** ERROR[2235] Compiler Internal Error: Cannot produce a plan in optimizer pass one, originated from file ../optimizer/opt.cpp at line 6907. [2015-03-28 20:53:48]
*** ERROR[8804] The provided input statement does not exist in the current context. [2015-03-28 20:53:48]
*** ERROR[4082] Object TRAFODION.ARKCASE_ARKT0149.B4TABLE1 does not exist or is inaccessible. [2015-03-28 20:53:48]
-----------------------------------
arkcase/arkt1198.log
SQL>Update Statistics For Table BTA1P001 on every column;
*** ERROR[2235] Compiler Internal Error: Cannot produce a plan in optimizer pass one, originated from file ../optimizer/opt.cpp at line 6907. [2015-03-28 23:43:30]
*** ERROR[8804] The provided input statement does not exist in the current context. [2015-03-28 23:43:30]
*** ERROR[4082] Object TRAFODION.ARKCASE_ARKT1198.BTA1P001 does not exist or is inaccessible. [2015-03-28 23:43:30]
*** ERROR[2235] Compiler Internal Error: Cannot produce a plan in optimizer pass one, originated from file ../optimizer/opt.cpp at line 6907. [2015-03-28 23:43:30]
*** ERROR[8804] The provided input statement does not exist in the current context. [2015-03-28 23:43:30]
*** ERROR[4082] Object TRAFODION.ARKCASE_ARKT1198.BTA1P001 does not exist or is inaccessible. [2015-03-28 23:43:30]
*** ERROR[4082] Object TRAFODION.ARKCASE_ARKT1198.BTA1P001 does not exist or is inaccessible. [2015-03-28 23:43:30]
-----------------------------------
ddl/tab002.log
SQL>create table Female_actors (
f_no int not null not droppable,
f_name varchar(30) not null,
f_realname varchar(50) default null,
f_birthday date constraint md1 check (f_birthday > date '1900-01-01'),
primary key (f_no)
)
;
*** ERROR[2235] Compiler Internal Error: Cannot produce a plan in optimizer pass one, originated from file ../optimizer/opt.cpp at line 6907. [2015-03-29 06:50:34]
*** ERROR[8804] The provided input statement does not exist in the current context. [2015-03-29 06:50:34]
*** ERROR[4082] Object TRAFODION.DDL_TAB002.FEMALE_ACTORS does not exist or is inaccessible. [2015-03-29 06:50:34]
*** ERROR[1029] Object TRAFODION.DDL_TAB002.FEMALE_ACTORS could not be created. [2015-03-29 06:50:34]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)