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 <do...@hypertable.com<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 <do...@hypertable.com<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, <wuxin6...@gmail.com <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, <wuxin6...@gmail.com> 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, <wuxin6...@gmail.com> 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 hypertable-de...@googlegroups.com.
>>>>>>>> To post to this group, send email to hyperta...@googlegroups.com.
>>>>>>>>
>>>>>>>> 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 hypertable-de...@googlegroups.com.
>>>>>> To post to this group, send email to hyperta...@googlegroups.com.
>>>>>> 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 hypertable-de...@googlegroups.com <javascript:>.
>>>> To post to this group, send email to
>>>> hyperta...@googlegroups.com<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 hypertable-dev+unsubscr...@googlegroups.com.
To post to this group, send email to hypertable-dev@googlegroups.com.
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>
