Skip to content
This repository has been archived by the owner on Sep 27, 2019. It is now read-only.

TPCC fails on CREATE statement with float type #267

Closed
linmagit opened this issue Sep 20, 2016 · 0 comments
Closed

TPCC fails on CREATE statement with float type #267

linmagit opened this issue Sep 20, 2016 · 0 comments
Assignees

Comments

@linmagit
Copy link
Member

With several latest fixes, we're able to run YCSB again using OLTPBench. However when trying to run TPCC, the system crashed with a CREATE statement with a float column type. It seems that the float type is not recognized by the system correctly:

[TRACE] [/home/lin/peloton/src/tcop/tcop.cpp:106:PrepareStatement()] 2016-09-19 23:27:13 - Prepare Statement CREATE TABLE customer ( c_w_id int NOT NULL PRIMARY KEY, c_d_id int NOT NULL PRIMARY KEY, c_id int NOT NULL PRIMARY KEY, c_discount decimal NOT NULL, c_credit char(2) NOT NULL, c_last varchar(16) NOT NULL, c_first varchar(16) NOT NULL, c_credit_lim decimal NOT NULL, c_balance decimal NOT NULL, c_ytd_payment float NOT NULL, c_payment_cnt int NOT NULL, c_delivery_cnt int NOT NULL, c_street_1 varchar(20) NOT NULL, c_street_2 varchar(20) NOT NULL, c_city varchar(20) NOT NULL, c_state char(2) NOT NULL, c_zip char(9) NOT NULL, c_phone char(16) NOT NULL, c_since timestamp NOT NULL, c_middle char(2) NOT NULL, c_data varchar(500) NOT NULL )
[TRACE] [/home/lin/peloton/src/parser/parser.cpp:70:BuildParseTree()] 2016-09-19 23:27:13 - Number of statements: 1
[TRACE] [/home/lin/peloton/src/optimizer/simple_optimizer.cpp:77:BuildPelotonPlanTree()] 2016-09-19 23:27:13 - Adding Create plan...
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_w_id; Is primary key: 1
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:52:CreatePlan()] 2016-09-19 23:27:13 - Added a primary key constraint on column "c_w_id"
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_d_id; Is primary key: 1
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:52:CreatePlan()] 2016-09-19 23:27:13 - Added a primary key constraint on column "c_d_id"
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_id; Is primary key: 1
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:52:CreatePlan()] 2016-09-19 23:27:13 - Added a primary key constraint on column "c_id"
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_discount; Is primary key: 0
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_credit; Is primary key: 0
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_last; Is primary key: 0
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_first; Is primary key: 0
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_credit_lim; Is primary key: 0
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_balance; Is primary key: 0
[TRACE] [/home/lin/peloton/src/planner/create_plan.cpp:46:CreatePlan()] 2016-09-19 23:27:13 - Column name: c_ytd_payment; Is primary key: 0
Exception Type :: Unknown Type
Message :: Unknown type.
terminate called after throwing an instance of 'peloton::Exception'
what(): Unknown type.

Thread 2 "peloton" received signal SIGABRT, Aborted.
[Switching to Thread 0x7ffff2fff700 (LWP 10113)]
0x00007ffff49a2418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
54 ../sysdeps/unix/sysv/linux/raise.c: No such file or directory.
(gdb) bt
#0 0x00007ffff49a2418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#1 0x00007ffff49a401a in __GI_abort () at abort.c:89
#2 0x00007ffff52e484d in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#3 0x00007ffff52e26b6 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#4 0x00007ffff52e2701 in std::terminate() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#5 0x00007ffff52e2919 in __cxa_throw () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#6 0x00007ffff767d678 in peloton::common::Type::GetTypeSize (type_id=peloton::common::Type::INVALID)

at /home/lin/peloton/src/common/type.cpp:71

#7 0x00007ffff764850a in peloton::planner::CreatePlan::CreatePlan (this=0x7ffff0966340, parse_tree=0x7ffff081c970)

at /home/lin/peloton/src/planner/create_plan.cpp:60

#8 0x00007ffff78bf27d in peloton::optimizer::SimpleOptimizer::BuildPelotonPlanTree (

parse_tree=std::unique_ptr<peloton::parser::SQLStatementList> containing 0x7ffff0942780)
at /home/lin/peloton/src/optimizer/simple_optimizer.cpp:79

#9 0x00007ffff78427fa in peloton::tcop::TrafficCop::PrepareStatement (

this=0x7ffff7dd5568 <peloton::tcop::TrafficCop::GetInstance()::traffic_cop>, statement_name="", 
query_string="CREATE TABLE customer (   c_w_id int NOT NULL PRIMARY KEY,   c_d_id int NOT NULL PRIMARY KEY,   c_id int NOT NULL PRIMARY KEY,   c_discount decimal NOT NULL,   c_credit char(2) NOT NULL,   c_last varc"..., error_message="") at /home/lin/peloton/src/tcop/tcop.cpp:114

#10 0x00007ffff786774c in peloton::wire::PacketManager::ExecParseMessage (this=0x7ffff3ca31c0, pkt=0x7ffff2ffe5d0,

responses=std::vector of length 0, capacity 1) at /home/lin/peloton/src/networking/protocol.cpp:307
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants