{"action":"closed","issue":{"url":"https://api.github.com/repos/cmu-db/peloton/issues/267","repository_url":"https://api.github.com/repos/cmu-db/peloton","labels_url":"https://api.github.com/repos/cmu-db/peloton/issues/267/labels{/name}","comments_url":"https://api.github.com/repos/cmu-db/peloton/issues/267/comments","events_url":"https://api.github.com/repos/cmu-db/peloton/issues/267/events","html_url":"https://github.com/cmu-db/peloton/issues/267","id":177955039,"number":267,"title":"TPCC fails on CREATE statement with float type","user":{"login":"malin1993ml","id":5907405,"avatar_url":"https://avatars.githubusercontent.com/u/5907405?v=3","gravatar_id":"","url":"https://api.github.com/users/malin1993ml","html_url":"https://github.com/malin1993ml","followers_url":"https://api.github.com/users/malin1993ml/followers","following_url":"https://api.github.com/users/malin1993ml/following{/other_user}","gists_url":"https://api.github.com/users/malin1993ml/gists{/gist_id}","starred_url":"https://api.github.com/users/malin1993ml/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/malin1993ml/subscriptions","organizations_url":"https://api.github.com/users/malin1993ml/orgs","repos_url":"https://api.github.com/users/malin1993ml/repos","events_url":"https://api.github.com/users/malin1993ml/events{/privacy}","received_events_url":"https://api.github.com/users/malin1993ml/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"MattPerron","id":7608614,"avatar_url":"https://avatars.githubusercontent.com/u/7608614?v=3","gravatar_id":"","url":"https://api.github.com/users/MattPerron","html_url":"https://github.com/MattPerron","followers_url":"https://api.github.com/users/MattPerron/followers","following_url":"https://api.github.com/users/MattPerron/following{/other_user}","gists_url":"https://api.github.com/users/MattPerron/gists{/gist_id}","starred_url":"https://api.github.com/users/MattPerron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MattPerron/subscriptions","organizations_url":"https://api.github.com/users/MattPerron/orgs","repos_url":"https://api.github.com/users/MattPerron/repos","events_url":"https://api.github.com/users/MattPerron/events{/privacy}","received_events_url":"https://api.github.com/users/MattPerron/received_events","type":"User","site_admin":false},"assignees":[{"login":"MattPerron","id":7608614,"avatar_url":"https://avatars.githubusercontent.com/u/7608614?v=3","gravatar_id":"","url":"https://api.github.com/users/MattPerron","html_url":"https://github.com/MattPerron","followers_url":"https://api.github.com/users/MattPerron/followers","following_url":"https://api.github.com/users/MattPerron/following{/other_user}","gists_url":"https://api.github.com/users/MattPerron/gists{/gist_id}","starred_url":"https://api.github.com/users/MattPerron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MattPerron/subscriptions","organizations_url":"https://api.github.com/users/MattPerron/orgs","repos_url":"https://api.github.com/users/MattPerron/repos","events_url":"https://api.github.com/users/MattPerron/events{/privacy}","received_events_url":"https://api.github.com/users/MattPerron/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-09-20T03:31:55Z","updated_at":"2016-09-21T01:35:49Z","closed_at":"2016-09-21T01:35:49Z","body":"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:\r\n\r\n[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 )\r\n[TRACE] [/home/lin/peloton/src/parser/parser.cpp:70:BuildParseTree()] 2016-09-19 23:27:13 - Number of statements: 1\r\n[TRACE] [/home/lin/peloton/src/optimizer/simple_optimizer.cpp:77:BuildPelotonPlanTree()] 2016-09-19 23:27:13 - Adding Create plan...\r\n[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\r\n[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\"\r\n[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\r\n[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\"\r\n[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\r\n[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\"\r\n[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\r\n[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\r\n[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\r\n[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\r\n[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\r\n[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\r\n[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\r\nException Type :: Unknown Type\r\nMessage :: Unknown type.\r\nterminate called after throwing an instance of 'peloton::Exception'\r\n  what():  Unknown type.\r\n\r\nThread 2 \"peloton\" received signal SIGABRT, Aborted.\r\n[Switching to Thread 0x7ffff2fff700 (LWP 10113)]\r\n0x00007ffff49a2418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54\r\n54\t../sysdeps/unix/sysv/linux/raise.c: No such file or directory.\r\n(gdb) bt\r\n#0  0x00007ffff49a2418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54\r\n#1  0x00007ffff49a401a in __GI_abort () at abort.c:89\r\n#2  0x00007ffff52e484d in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6\r\n#3  0x00007ffff52e26b6 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6\r\n#4  0x00007ffff52e2701 in std::terminate() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6\r\n#5  0x00007ffff52e2919 in __cxa_throw () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6\r\n#6  0x00007ffff767d678 in peloton::common::Type::GetTypeSize (type_id=peloton::common::Type::INVALID)\r\n    at /home/lin/peloton/src/common/type.cpp:71\r\n#7  0x00007ffff764850a in peloton::planner::CreatePlan::CreatePlan (this=0x7ffff0966340, parse_tree=0x7ffff081c970)\r\n    at /home/lin/peloton/src/planner/create_plan.cpp:60\r\n#8  0x00007ffff78bf27d in peloton::optimizer::SimpleOptimizer::BuildPelotonPlanTree (\r\n    parse_tree=std::unique_ptr<peloton::parser::SQLStatementList> containing 0x7ffff0942780)\r\n    at /home/lin/peloton/src/optimizer/simple_optimizer.cpp:79\r\n#9  0x00007ffff78427fa in peloton::tcop::TrafficCop::PrepareStatement (\r\n    this=0x7ffff7dd5568 <peloton::tcop::TrafficCop::GetInstance()::traffic_cop>, statement_name=\"\", \r\n    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\r\n#10 0x00007ffff786774c in peloton::wire::PacketManager::ExecParseMessage (this=0x7ffff3ca31c0, pkt=0x7ffff2ffe5d0, \r\n    responses=std::vector of length 0, capacity 1) at /home/lin/peloton/src/networking/protocol.cpp:307\r\n"}}
{"actor":{"display_login":"MattPerron"}}