Hi Doug:
I just do what you said. and test result as appendix.
in file
1.capfile_0.9.7.13 means use your first supplyed hyertable-v0.9.7.13.
and
2. capfile_0.9.7.14.6a57db0 means use 0.9.7.14.6a57db0 version you
given.
在 2013年12月13日星期五UTC+8上午8时18分48秒，Doug Judd写道：
>
> I was able to reproduce the problem and have come up with a fix which you
> can find in the following package:
>
>
> http://www.hypertable.com/pub/hypertable-0.9.7.14.6a57db0-linux-x86_64.tar.bz2
>
> Please give this one a try and report back, letting us know if it does
> indeed fix the problem. Thanks!
>
> - Doug
>
>
> On Thu, Dec 12, 2013 at 7:37 AM, Doug Judd <[email protected]<javascript:>
> > wrote:
>
>> I think I know what's going on here. I will build you a fixed package
>> today. If you could give it a try and report back, I'd greatly appreciate
>> it.
>>
>> - Doug
>>
>>
>> On Thu, Dec 12, 2013 at 7:22 AM, Doug Judd <[email protected]<javascript:>
>> > wrote:
>>
>>> Thanks. Are you certain that these log entries were gathered *after*
>>> you ran the problematic query?
>>>
>>>
>>>
>>> On Thu, Dec 12, 2013 at 12:58 AM, <[email protected] <javascript:>>wrote:
>>>
>>>> Please check the attach file.
>>>>
>>>>
>>>> 在 2013年12月11日星期三UTC+8上午3时19分42秒，Doug Judd写道：
>>>>>
>>>>> Thanks. I've built an instrumented version of Hypertable which you
>>>>> can find here:
>>>>>
>>>>> http://www.hypertable.com/pub/hypertable-0.9.7.14.7266ca8-
>>>>> linux-x86_64.tar.bz2
>>>>>
>>>>> Please upgrade to this version and then start the cluster. Once the
>>>>> cluster is back up on the instrumented version, run the problem query:
>>>>>
>>>>> hypertable> select * from TAB_CDR_EVENT where
>>>>> '8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row
>>>>> regexp "B..$" limit 1;
>>>>>
>>>>> After the query has finished, grep for "issue1175" in the RangeServer
>>>>> logs and post the output. For example:
>>>>>
>>>>> cap shell
>>>>> cap> fgrep issue1175 /opt/hypertable/current/log/
>>>>> Hypertable.RangeServer.log
>>>>>
>>>>> Thanks for your help!
>>>>>
>>>>> - Doug
>>>>>
>>>>>
>>>>> On Mon, Dec 9, 2013 at 11:57 PM, <[email protected]> wrote:
>>>>>
>>>>>> Yes, 64 bit. tar is ok.
>>>>>>
>>>>>> It is OS information.
>>>>>> [cloudil@dlxa101 ~]$ uname -a
>>>>>> Linux dlxa101 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT
>>>>>> 2012 x86_64 x86_64 x86_64 GNU/Linux
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>> On Tuesday, December 10, 2013 1:37:44 PM UTC+8, Doug Judd wrote:
>>>>>>
>>>>>>> That would be great, thanks! I will build you an instrumented
>>>>>>> version tomorrow and post a pointer to the package. In the meantime,
>>>>>>> try
>>>>>>> not to insert or delete any data from the table. What architecture and
>>>>>>> package type would you like me to build? 64-bit .tar.bz2?
>>>>>>>
>>>>>>> - Doug
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Dec 9, 2013 at 7:22 PM, <[email protected]> wrote:
>>>>>>>
>>>>>>>> Ok, it is my pleasure. Where can I get the instrumented version?
>>>>>>>>
>>>>>>>> thanks
>>>>>>>>
>>>>>>>> 在 2013年12月10日星期二UTC+8上午3时57分53秒，Doug Judd写道：
>>>>>>>>
>>>>>>>>> Great, thank you. Would you be willing to run an instrumented
>>>>>>>>> version of Hypertable? It would help pin down exactly where the
>>>>>>>>> error is
>>>>>>>>> occurring.
>>>>>>>>>
>>>>>>>>> - Doug
>>>>>>>>>
>>>>>>>>> --
>>>>>>>> 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.
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> 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] <javascript:>.
>>>> To post to this group, send email to
>>>> [email protected]<javascript:>
>>>> .
>>>> 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.
>>>
>>
>>
>>
>> --
>> Doug Judd
>> CEO, Hypertable Inc.
>>
>
>
>
> --
> 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.
操作命令：
0. 先到 ht shell 下执行
select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 1 RETURN_DELETES;
select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 2 RETURN_DELETES;
记录结果
1. cd /dinglicom
2. cap stop 执行3遍
3. cp -p capfile_0.9.7.14.6a57db0 capfile
4. cap upgrade
5. cap start
6. ./ht shell
7. use dinglicom;
8. 执行 select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 1 RETURN_DELETES;
select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 2 RETURN_DELETES;
记录结果
测试结果：
1.capfile_0.9.7.13
[cloudil@dlxa101 bin]$ ./ht shell
Welcome to the hypertable command interpreter.
For information about Hypertable, visit http://hypertable.com
Type 'help' for a list of commands, or 'help shell' for a
list of shell meta commands.
Elapsed time: 0.00 s
hypertable> use dinglicom;
Elapsed time: 0.00 s
hypertable> get listing;
TAB_CDR_EVENT
^TAB_CDR_EVENT
Elapsed time: 0.00 s
hypertable> select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 1 RETURN_DELETES;
8795741618-51015A93BHE CALLED_NUMBER 1167645056-51015A93
8795741618-51015A93BHE IMSI 46002795741340451015A93
8795741618-51015A93BHE IMEI 352739032789967851015A93
8795741618-51015A93BHE CDR_RESULT 25551015A93
8795741618-51015A93BHE TMSI 1819090051015A93
8795741618-51015A93BHE F1:F1
18795741618\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%.\0\0\0\0\n%?\0\0\0\0?\0\0.\0\0??\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0?\0f?0\0\0??].t\0?\0f?0\0\0].t\0\0\0XcXP.?\0\0-\0\0\0
8795741618-51015A93BHE F2:F2
H?.\0\0\0\0\0\0\0\0\0\0XP\0\0Xc????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\t\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/\0\0\0M\0\0\0
Elapsed time: 3.63 s
Avg value size: 57.86 bytes
Avg key size: 23.57 bytes
Throughput: 157.13 bytes/s
Total cells: 7
Throughput: 1.93 cells/s
hypertable> select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 2 RETURN_DELETES;
8795741618-51015A93BHE CALLED_NUMBER 1167645056-51015A93
8795741618-51015A93BHE IMSI 46002795741340451015A93
8795741618-51015A93BHE IMEI 352739032789967851015A93
8795741618-51015A93BHE CDR_RESULT 25551015A93
8795741618-51015A93BHE TMSI 1819090051015A93
8795741618-51015A93BHE F1:F1
18795741618\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%.\0\0\0\0\n%?\0\0\0\0?\0\0.\0\0??\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0?\0f?0\0\0??].t\0?\0f?0\0\0].t\0\0\0XcXP.?\0\0-\0\0\0
8795741618-51015A93BHE F2:F2
H?.\0\0\0\0\0\0\0\0\0\0XP\0\0Xc????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\t\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/\0\0\0M\0\0\0
8795741715-51015AD0BHE CALLED_NUMBER 1167645056-51015AD0
8795741715-51015AD0BHE IMSI 46002795741693651015AD0
8795741715-51015AD0BHE IMEI 865780000385677851015AD0
8795741715-51015AD0BHE CDR_RESULT 25551015AD0
8795741715-51015AD0BHE TMSI 164538176751015AD0
8795741715-51015AD0BHE F1:F1
18795741715\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%E\n\0\0\0\0\n%.0\0\0\0?\0\0?\0\0??\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0?\0f?0\0\0??.\t\0?\0f?0\0\0.\t\0\0\0???P)?\0\0'\0\0\0
8795741715-51015AD0BHE F2:F2
..隈?\0\0\0\0\0\0\0\0\0\0?\0\0??????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0,\0\0\0;\0\0\0
Elapsed time: 23.08 s
Avg value size: 58.00 bytes
Avg key size: 23.57 bytes
Throughput: 49.48 bytes/s
Total cells: 14
Throughput: 0.61 cells/s
hypertable>
2. capfile_0.9.7.14.6a57db0
[cloudil@dlxa101 ~]$ cd /dinglicom/hypertable/current/bin/
[cloudil@dlxa101 bin]$ ./ht shell
Welcome to the hypertable command interpreter.
For information about Hypertable, visit http://hypertable.com
Type 'help' for a list of commands, or 'help shell' for a
list of shell meta commands.
Elapsed time: 0.00 s
hypertable> use dinglicom;
Elapsed time: 0.00 s
hypertable> get listing;
TAB_CDR_EVENT
^TAB_CDR_EVENT
Elapsed time: 0.00 s
hypertable> select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 1 RETURN_DELETES;
8795741618-51015A93BHE CALLED_NUMBER 1167645056-51015A93
8795741618-51015A93BHE IMSI 46002795741340451015A93
8795741618-51015A93BHE IMEI 352739032789967851015A93
8795741618-51015A93BHE CDR_RESULT 25551015A93
8795741618-51015A93BHE TMSI 1819090051015A93
8795741618-51015A93BHE F1:F1
18795741618\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%.\0\0\0\0\n%?\0\0\0\0?\0\0.\0\0??\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0?\0f?0\0\0??].t\0?\0f?0\0\0].t\0\0\0XcXP.?\0\0-\0\0\0
8795741618-51015A93BHE F2:F2
H?.\0\0\0\0\0\0\0\0\0\0XP\0\0Xc????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\t\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/\0\0\0M\0\0\0
Elapsed time: 2.42 s
Avg value size: 57.86 bytes
Avg key size: 23.57 bytes
Throughput: 235.26 bytes/s
Total cells: 7
Throughput: 2.89 cells/s
hypertable> select * from TAB_CDR_EVENT where
'8795741566-51015A61BHE'<ROW<='D0000000000000000000zH ' and row regexp "B..$"
limit 2 RETURN_DELETES;
8795741618-51015A93BHE CALLED_NUMBER 1167645056-51015A93
8795741618-51015A93BHE IMSI 46002795741340451015A93
8795741618-51015A93BHE IMEI 352739032789967851015A93
8795741618-51015A93BHE CDR_RESULT 25551015A93
8795741618-51015A93BHE TMSI 1819090051015A93
8795741618-51015A93BHE F1:F1
18795741618\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%.\0\0\0\0\n%?\0\0\0\0?\0\0.\0\0??\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0?\0f?0\0\0??].t\0?\0f?0\0\0].t\0\0\0XcXP.?\0\0-\0\0\0
8795741618-51015A93BHE F2:F2
H?.\0\0\0\0\0\0\0\0\0\0XP\0\0Xc????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\t\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/\0\0\0M\0\0\0
8795741715-51015AD0BHE CALLED_NUMBER 1167645056-51015AD0
8795741715-51015AD0BHE IMSI 46002795741693651015AD0
8795741715-51015AD0BHE IMEI 865780000385677851015AD0
8795741715-51015AD0BHE CDR_RESULT 25551015AD0
8795741715-51015AD0BHE TMSI 164538176751015AD0
8795741715-51015AD0BHE F1:F1
18795741715\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n%E\n\0\0\0\0\n%.0\0\0\0?\0\0?\0\0??\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0?\0f?0\0\0??.\t\0?\0f?0\0\0.\t\0\0\0???P)?\0\0'\0\0\0
8795741715-51015AD0BHE F2:F2
..隈?\0\0\0\0\0\0\0\0\0\0?\0\0??????????\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0??\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0,\0\0\0;\0\0\0
Elapsed time: 2.61 s
Avg value size: 58.00 bytes
Avg key size: 23.57 bytes
Throughput: 437.00 bytes/s
Total cells: 14
Throughput: 5.36 cells/s
hypertable>
