What version of Hypertable are you running?
On Tue, Dec 10, 2013 at 5:03 AM, Hatice Çobanoğlu < [email protected]> wrote: > Hi Doug, > i check the DfsBroker.hadoop.log files for the word "Exception" and not > see anything about this word. > > i use version of CDH4 (4.6.0), hadoop 2.0.0, ubuntu 12.04 > > > 2013/12/9 Doug Judd <[email protected]> > >> Hi Hatice, >> >> The following error could be the culprit: >> >> >> 1386592901 ERROR ThriftBroker : flush (/root/src/hypertable/src/cc/ >> Hypertable/Lib/TableMutator.cc:183): Hypertable::Exception: - DFS >> BROKER i/o error >> >> Please grep through the DfsBroker.hadoop.log files for the word >> "Exception" to see what kind of errors the DfsBroker is encountering. >> Also, what version of Hadoop are you running? >> >> - Doug >> >> >> >> >> On Mon, Dec 9, 2013 at 6:57 AM, Hatice Çobanoğlu < >> [email protected]> wrote: >> >>> hi doug, >>> i restart ht (cap stop / cap start), i can select or insert. everything >>> is ok. but thriftbroker log write a lot. one of the thrift log as following: >>> >>> 1386600835.533673000 API mutator_set_cell: API mutator_set_cell: >>> mutator=63393536 cell={Cell: {Key: row=' >>> http://allfree-4u.com/fs_gay/gay-twink-porn-movies/link' cf='guid' >>> flag=255} value='031f1713-f57e-4591-8283-bfb445f9a634'} latency=0 >>> 1386600835.534667000 API namespace_open: API namespace_open: namespace >>> name=crawler id=1142522706 latency=0 >>> 1386600835.534874000 API mutator_set_cell: API mutator_set_cell: >>> mutator=43919680 cell={Cell: {Key: row='929999-fetshop.com' >>> cf='oncelik' cq='b' flag=255} value='0'} latency=0 >>> 1386600835.535570000 API hql_exec: API hql_exec: namespace=2860583658 >>> hql=select link FROM links where >>> row='designsponge.com_designspongeonline.com_ >>> http://designspongeonline.com/category/diy-projects?technique=carpentry&showposts=20&materials=leather' >>> cell_limit 1 noflush=0 unbuffered=0 latency=0 >>> 1386600835.536486000 API mutator_set_cell: API mutator_set_cell: >>> mutator=43922560 cell={Cell: {Key: >>> row='so_worked_up_and_horny####999997.009661####d90e93a8-36a3-4f8e-8a40-f2a39325c4f5' >>> cf='urlguid' flag=255} value='tons of pics of hot girls squirting >>> everywhere we have nothing but sexy girls squirting in videos and pictures >>> watch as these hotties get so worked up and horny that their pussies squirt >>> many feet in the air come and see her squirt her load all over herself the >>> cameras and even into some hungry mouths not all girls can squirt like this >>> so we thought we would make a huge collection of only squirting these >>> chicks love getting wet and wild in all the videos in our galleries if she >>> doesnt squirt you wont find her here we know how many guys have a squirting >>> fetish so we bring it to life for you watch for new squirting updates every >>> week'} latency=0 >>> 1386600835.536602000 API mutator_open: API mutator_open: >>> namespace=1142522706table=result flags=0 flush_interval=0 >>> async_mutator=68997312 latency=0 >>> 1386600835.536150000 API hql_exec: API hql_exec: >>> namespace=3019239709hql=select link FROM links where >>> row='designspongeonline.com_ >>> http://designspongeonline.com/category/diy-projects?technique=carpentry&showposts=20&materials=leather_designsponge.com' >>> cell_limit 1 noflush=0 unbuffered=0 latency=0 >>> 1386600835.536691000 API namespace_close: API namespace_close: >>> namespace=2860583658 latency=0 >>> 1386600835.518349000 API mutator_flush: API mutator_flush: >>> mutator=63400256 done latency=19 >>> 1386600835.526528000 API mutator_flush: API mutator_flush: >>> mutator=63396416 done latency=11 >>> 1386600835.538701000 API namespace_close: API namespace_close: namespace= >>> 3019239709 latency=0 >>> 1386600835.539385000 API mutator_flush: API mutator_flush: >>> mutator=63400256 done latency=0 >>> 1386600835.539378000 API mutator_close: API mutator_close: >>> mutator=63400256 latency=0 >>> 1386600835.540058000 API namespace_close: API namespace_close: namespace= >>> 3256284611 latency=0 >>> 1386600835.534128000 API mutator_flush: API mutator_flush: >>> mutator=63393536 done latency=6 >>> 1386600835.540847000 API mutator_flush: API mutator_flush: >>> mutator=63393536 done latency=0 >>> 1386600835.540841000 API mutator_close: API mutator_close: >>> mutator=63393536 latency=0 >>> 1386600835.541401000 API namespace_close: API namespace_close: >>> namespace=4251420742 latency=0 >>> 1386600835.542443000 API namespace_open: API namespace_open: namespace >>> name=crawler id=1156035969 latency=0 >>> 1386600835.542945000 API namespace_open: API namespace_open: namespace >>> name=crawler id=2980656141 latency=0 >>> 1386600835.543333000 API mutator_set_cell: API mutator_set_cell: >>> mutator=68997312 cell={Cell: {Key: >>> row='the_month####999997.585027####8d975b47-c5c6-41e3-a1f1-80fbb7d2c7f3' >>> cf='urlguid' flag=255} value='well ı am finally done look ı am even done >>> before the month of april ı spent pretty much all day making this unit >>> normally it only takes me a couple hours not this one not even sure why it >>> took all day'} latency=0 >>> 1386600835.544141000 API namespace_open: API namespace_open: namespace >>> name=crawler id=1774589716 latency=0 >>> 1386600835.544478000 API namespace_open: API namespace_open: namespace >>> name=crawler id=1052633510 latency=0 >>> 1386600835.1386600835542867000.543350000 API hql_exec: API hql_exec: >>> namespace=2980656141 hql=select guid FROM urls where row=' >>> http://www.gayqualitysites.com/wellhungmodelboys/index.htm' cell_limit >>> 1 noflush=0 unbuffered=0 latency=1 >>> API mutator_flush: API mutator_flush: mutator=43919680 done latency=2 >>> 1386600835.545779000 API mutator_flush: API mutator_flush: >>> mutator=43919680 done latency=0 >>> 1386600835.545772000 API mutator_close: API mutator_close: >>> mutator=43919680 latency=0 >>> 1386600835.546109000 API namespace_close: API namespace_close: >>> namespace=1984545983 latency=0 >>> 1386600835.546454000 API namespace_open: API namespace_open: namespace >>> name=crawler id=2689713404 latency=0 >>> 1386600835.548529000 API namespace_open: API namespace_open: namespace >>> name=crawler id=3127981135 latency=0 >>> 1386600835.550342000 API mutator_open: API mutator_open: >>> namespace=305562593table=links flags=0 flush_interval=0 >>> async_mutator=43912000 latency=0 >>> 1386600835.550619000 API mutator_open: API mutator_open: >>> namespace=1052633510table=icerik flags=0 flush_interval=0 >>> async_mutator=63610368 latency=0 >>> 1386600835.550759000 API hql_exec: API hql_exec: namespace=1774589716 >>> hql=select link FROM links where row='designspongeonline.com_ >>> http://designspongeonline.com/category/diy-projects?technique=carpentry&showposts=20&materials=leather_designsponge.com' >>> cell_limit 1 noflush=0 unbuffered=0 latency=0 >>> 1386600835.551684000 API mutator_flush: API mutator_flush: >>> mutator=63396416 done latency=0 >>> 1386600835.551677000 API mutator_close: API mutator_close: >>> mutator=63396416 latency=0 >>> 1386600835.552156000 API namespace_open: API namespace_open: namespace >>> name=crawler id=1162137437 latency=0 >>> 1386600835.552195000 API namespace_close: API namespace_close: >>> namespace=1591027820 latency=0 >>> 1386600835.552614000 API namespace_close: API namespace_close: >>> namespace=1774589716 latency=0 >>> 1386600835.552643000 API namespace_open: API namespace_open: namespace >>> name=crawler id=3720199858 latency=0 >>> 1386600835.526241000 API mutator_flush: API mutator_flush: >>> mutator=69000192 done latency=26 >>> 1386600835.553304000 API mutator_open: API mutator_open: >>> namespace=2689713404table=urls flags=0 flush_interval=0 >>> async_mutator=63393536 latency=0 >>> 1386600835.553693000 API mutator_flush: API mutator_flush: >>> mutator=69000192 done latency=0 >>> 1386600835.553687000 API mutator_close: API mutator_close: >>> mutator=69000192 latency=0 >>> 1386600835.554217000 API namespace_close: API namespace_close: >>> namespace=3838016151 latency=0 >>> 1386600835.554592000 API namespace_open: API namespace_open: namespace >>> name=crawler id=3383002693 latency=0 >>> 1386600835.554945000 API namespace_open: API namespace_open: namespace >>> name=crawler id=3841379418 latency=0 >>> 1386600835.555626000 API mutator_set_cell: API mutator_set_cell: >>> mutator=63393536 cell={Cell: {Key: row=' >>> http://www.gayqualitysites.com/wellhungmodelboys/index.htm' cf='guid' >>> flag=255} value='246ea99e-4b66-4ea4-8116-400791e203ff'} latency=0 >>> 1386600835.555285000 API hql_exec: API hql_exec: namespace=3841379418 >>> hql=select link FROM links where row='picshag.com_ >>> http://picshag.com/envelope-warning.html_orgagsm.com' cell_limit 1 >>> noflush=0 unbuffered=0 latency=0 >>> 1386600835.556588000 API mutator_open: API mutator_open: >>> namespace=3841379418table=links flags=0 flush_interval=0 >>> async_mutator=69000192 latency=0 >>> 1386600835.557017000 API mutator_set_cell: API mutator_set_cell: >>> mutator=69000192 cell={Cell: {Key: row='picshag.com_ >>> http://picshag.com/envelope-warning.html_orgagsm.com' cf='link' cq='d' >>> flag=255} value='http://orgagsm.com/photos/perfec >>> >>> >>> >>> do any problems have, or not? >>> >>> >>> 2013/12/9 Hatice Çobanoğlu <[email protected]> >>> >>>> Hi Doug, >>>> i added ThriftBroker.API.Logging=true to hypertable.cfg file and cap >>>> push_config. and then restart the ThriftBrokers. ThriftBroker.log file >>>> as following, >>>> >>>> hadoop59 's ThriftBroker log: >>>> >>>> tcmalloc: large alloc 1668055040 bytes == 0x34ce000 @ >>>> tcmalloc: large alloc 1668055040 bytes == 0x34ce000 @ >>>> 1386592292.534763000 API namespace_open: API namespace_open: namespace >>>> name=crawler id=3625439156 latency=0 >>>> 1386592892 ERROR ThriftBroker : handle_error >>>> (/root/src/hypertable/src/cc/Hypertable/Lib/TableScannerAsync.cc:385): >>>> Received error: is_create=1 - Hypertable::Exception: Event: type=ERROR >>>> "HYPERTABLE request timeout" from=172.16.200.153:38060 - HYPERTABLE >>>> request timeout >>>> 1386592892 ERROR ThriftBroker : handle_error >>>> (/root/src/hypertable/src/cc/Hypertable/Lib/TableScannerAsync.cc:402): >>>> Hypertable::Exception: Event: type=ERROR "HYPERTABLE request timeout" from= >>>> 172.16.200.153:38060 - HYPERTABLE request timeout >>>> 1386592892 ERROR ThriftBroker : hql_exec >>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:584): virtual >>>> void >>>> Hypertable::ThriftBroker::ServerHandler::hql_exec(Hypertable::ThriftGen::HqlResult&, >>>> Hypertable::ThriftGen::Namespace, const Hypertable::String&, bool, bool) >>>> namespace=3625439156 hql=select guid FROM urls where row=' >>>> http://washingtonpost.com/business/capitalbusiness/kastle-systems-has-seen-video-mobile-technology-transform-its-security-business/2013/12/07/62a071c4-5de8-11e3-95c2-13623eb2b0e1_story.html?tid=hpModule_1728cf4a-8a79-11e2-98d9-3012c1cd8d1e' >>>> cell_limit 1 noflush=0 unbuffered=0: Hypertable::Exception: Event: >>>> type=ERROR "HYPERTABLE request timeout" from=172.16.200.153:38060 - >>>> HYPERTABLE request timeout >>>> at bool Hypertable::TableScanner::next(Hypertable::Cell&) >>>> (/root/src/hypertable/src/cc/Hypertable/Lib/TableScanner.cc:82) >>>> 1386592892.639819000 API namespace_close: API namespace_close: >>>> namespace=3625439156 latency=0 >>>> 1386592892.640398000 API namespace_open: API namespace_open: namespace >>>> name=crawler id=2342619381 latency=0 >>>> 1386592902.650809000 API namespace_open: API namespace_open: namespace >>>> name=crawler id=970823060 latency=0 >>>> >>>> >>>> hadoop152 ThriftBroker log: >>>> >>>> 1386592891.786474000 API namespace_close: API namespace_close: >>>> namespace=2282353234 latency=0 >>>> 1386592891 ERROR ThriftBroker : TSocket::peek() recv() <Host: >>>> 172.16.200.30 Port: 56469>Connection reset by peer >>>> 1386592891 ERROR ThriftBroker : TThreadedServer client died: recv(): >>>> Connection reset by peer >>>> 1386592901 ERROR ThriftBroker : flush >>>> (/root/src/hypertable/src/cc/Hypertable/Lib/TableMutator.cc:183): >>>> Hypertable::Exception: - DFS BROKER i/o error >>>> at void >>>> Hypertable::TableMutator::wait_for_flush_completion(Hypertable::TableMutatorAsync*) >>>> (/root/src/hypertable/src/cc/Hypertable/Lib/TableMutator.cc:210) >>>> Failed: (2013-12-09#ali_ata_bak,parametre,-9223372036854775806) - DFS >>>> BROKER i/o error >>>> 1386592901 ERROR ThriftBroker : hql_exec >>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:584): virtual >>>> void >>>> Hypertable::ThriftBroker::ServerHandler::hql_exec(Hypertable::ThriftGen::HqlResult&, >>>> Hypertable::ThriftGen::Namespace, const Hypertable::String&, bool, bool) >>>> namespace=1660590572 hql=insert into sorgukayit values >>>> ('2013-12-09#ali_ata_bak','parametre','172.16.59.67') noflush=0 >>>> unbuffered=0: Hypertable::Exception: - DFS BROKER i/o error >>>> at void >>>> Hypertable::TableMutator::wait_for_flush_completion(Hypertable::TableMutatorAsync*) >>>> (/root/src/hypertable/src/cc/Hypertable/Lib/TableMutator.cc:210) >>>> 1386593491 WARN ThriftBroker : >>>> (/root/src/hypertable/src/cc/AsyncComm/IOHandlerData.cc:596) Received >>>> response for non-pending event (id=19,version=1,total_len=91) >>>> >>>> >>>> >>>> and now we can not insert or select on ht shell. >>>> >>>> >>>> >>>> >>>> >>>> 2013/12/6 Doug Judd <[email protected]> >>>> >>>>> Hi Hatice, >>>>> >>>>> Add the following property to your hypertable.cfg file: >>>>> >>>>> ThriftBroker.API.Logging=true >>>>> >>>>> and then restart the ThriftBrokers and wait for the problem to happen >>>>> again. Once it does, send me the ThriftBroker.log file of the >>>>> ThriftBroker >>>>> that crashed. It will include more information that will help me diagnose >>>>> the problem. Thanks! >>>>> >>>>> - Doug >>>>> >>>>> >>>>> On Fri, Dec 6, 2013 at 6:09 AM, Hatice Çobanoğlu < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi everyone, >>>>>> i have 7 thriftboker in cluster. and i've problem oen of them as >>>>>> following. >>>>>> >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386334385 ERROR ThriftBroker : get_namespace >>>>>> (/root/src/hypertable/src/cc/ThriftBroker/ThriftBroker.cc:2177): Bad >>>>>> namespace id - 0 >>>>>> 1386335515 ERROR ThriftBroker : TThreadedServer exception: >>>>>> St9bad_alloc: std::bad_alloc >>>>>> 1386335532 ERROR ThriftBroker : TThreadedServer exception: >>>>>> St9bad_alloc: std::bad_alloc >>>>>> 1386335593 ERROR ThriftBroker : TThreadedServer exception: >>>>>> St9bad_alloc: std::bad_alloc >>>>>> 1386335653 ERROR ThriftBroker : TThreadedServer exception: >>>>>> St9bad_alloc: std::bad_alloc >>>>>> 1386336456 INFO ThriftBroker : >>>>>> (/root/src/hypertable/src/cc/Common/Config.cc:591) Initializing >>>>>> ThriftBroker (Hypertable 0.9.7.13 (v0.9$ >>>>>> CPU cores count=24 >>>>>> >>>>>> when have these problems, restart thriftbroker which closed and >>>>>> system continue. why thrift give this error log? >>>>>> not: connect to thrift with 32 client. >>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Hypertable Development" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> To post to this group, send email to [email protected]. >>>>>> Visit this group at http://groups.google.com/group/hypertable-dev. >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Doug Judd >>>>> CEO, Hypertable Inc. >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Hypertable Development" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at http://groups.google.com/group/hypertable-dev. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>> >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Hypertable Development" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/hypertable-dev. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> >> >> -- >> Doug Judd >> CEO, Hypertable Inc. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Hypertable Development" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/hypertable-dev. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > You received this message because you are subscribed to the Google Groups > "Hypertable Development" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/hypertable-dev. > For more options, visit https://groups.google.com/groups/opt_out. > -- Doug Judd CEO, Hypertable Inc. -- You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/hypertable-dev. For more options, visit https://groups.google.com/groups/opt_out.
