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.

Reply via email to