Hi Bruce, I have created a new issue (http://code.google.com/p/hypertable/issues/detail?id=170 ) to track this bug. I was able to reproduce the second issue you mentioned but not the first (possibly that issue is not in the latest release 0.9.0.12 ?).
Thanks, Sanjit On Nov 10, 2008, at 5:07 PM, bruce kissinger wrote: > Sanjit, > > Yes - here's the information. Please let me know if you need any > more information. Now that I look more closely I realize that the > error is not so much related to dropping tables as it is to creating > new ones. Sorry if I sent you on a wild goose chase. > > Environment > ----------------- > Ubuntu Linux > hypertable-0.9.0.11-alpha > running with "local" option > > Background > ----------------- > This is a stock installation. Earlier I created a table named "wiki". > > Example 1 > --------------- > [EMAIL PROTECTED]:/opt/hypertable/hypertable-0.9.0.11-alpha$ > hypertable > > Welcome to the hypertable command interpreter. > For information about Hypertable, visit http://www.hypertable.org/ > > Type 'help' for a list of commands, or 'help shell' for a > list of shell meta commands. > > hypertable> show tables; > METADATA > wiki > hypertable> create table wiki2 (title, url, abstract); > hypertable> delete table wiki2; > Error: parse error at: delete table wiki2 - HYPERTABLE HQL parse error > hypertable> delete wiki2; > Error: parse error at: delete wiki2 - HYPERTABLE HQL parse error > hypertable> drop table wiki2; > hypertable> show tables; > METADATA > wiki > hypertable> create table wiki2 (title, url, abstract); > 1226102981 ERROR hypertable : (/opt/hypertable/hypertable-0.9.0.11- > alpha/src/cc/Hypertable/Lib/MasterClient.cc:102) Master 'create > table' error, tablename=wiki2 : Problem issuing 'load range' command > for wiki2[..��] at server 127.0.1.1:51678 - RANGE SERVER range > already loaded > Error: - RANGE SERVER range already loaded > > > Example 2 > --------------- > [EMAIL PROTECTED]:/opt/hypertable/hypertable-0.9.0.11-alpha$ > hypertable > > Welcome to the hypertable command interpreter. > For information about Hypertable, visit http://www.hypertable.org/ > > Type 'help' for a list of commands, or 'help shell' for a > list of shell meta commands. > > hypertable> show tables; > METADATA > wiki > hypertable> create table wiki2 (title, url, abstract); > hypertable> drop table wiki2; > hypertable> show tables; > METADATA > wiki > hypertable> create table wiki2 (title, url, abstract); > hypertable> show tables; > METADATA > wiki <== Notice > how this table is listed twice > wiki2 > wiki <== Notice > how this table is listed twice > hypertable> drop table wiki2; > hypertable> show tables; > METADATA > wiki > > > > Bruce Kissinger > > 2008/11/10 Sanjit Jhala <[EMAIL PROTECTED]> > Hi Bruce, > > Can you send me more detail so I can recreate the problem? > > Thanks, > Sanjit > > > On Nov 7, 2008, at 6:37 PM, bruce kissinger wrote: > >> I WAS able to duplicate the problem. If you would like the details >> let me know and I can email a couple of examples to you. >> >> Bruce >> >> 2008/11/7 Doug Judd <[EMAIL PROTECTED]> >> Thanks, Bruce! We'll give that a try. - Doug >> >> 2008/11/7 bruce kissinger <[EMAIL PROTECTED]> >> >> Doug, >> >> I don't know if it will help or not, but I've seen some flakey >> problems trying to delete tables in the past. I'll try to see if I >> can duplicate it. >> I think I did something like: >> >> 1) Started the command shell >> >> 2) Created a table >> >> 3) Immediately tried to delete it. At this stage I got an error. >> >> I found that if I created the table, exited the shell, started the >> command shell back up again and then tried to delete the table it >> worked correctly. >> >> Bruce >> >> 2008/11/7 Doug Judd <[EMAIL PROTECTED]> >> >> Hi Rafal, >> >> Thanks, these are the correct files. I looked into it a bit, but >> didn't see anything obvious. I'm going to have Sanjit take a look >> at it in more depth as soon as he finishes the task he's currently >> working on. >> >> - Doug >> >> 2008/11/7 Rafal Zarajczyk <[EMAIL PROTECTED]> >> >> Where is this file? It's not present in log directory of my >> Hypertable >> installation dir. There are 4 other files, which I uploaded to: >> http://groups.google.com/group/hypertable-dev/web/log.tar.gz. >> The last operation in the logs is this drop table, but creating of >> _test_table_8 was long time ago, and I'm not sure if it's still >> visible in the logs. >> >> What's wierd, after creating this table, I noticed two instances of >> _test_table_8. First drop operation was successful, and one table >> disapeared. But the second remained... >> >> BTW: >> hypertable> select * from '_test_table_8'; >> Error: Problem getting attribute 'table_id' of hyperspace file '/ >> hypertable/tables/_test_table_8' - HYPERSPACE attribute not found >> hypertable> >> >> >> Rafał Zarajczyk >> >> On 6 Lis, 19:15, "Doug Judd" <[EMAIL PROTECTED]> wrote: >> > That's strange. Can you post the Hypertable.log file? If it's >> not too big, >> > just attach it to the e-mail, otherwise you can upload it here: >> > >> > http://groups.google.com/group/hypertable-dev/files >> > >> > - Doug >> > >> > On Thu, Nov 6, 2008 at 7:53 AM, Rafal Zarajczyk >> <[EMAIL PROTECTED]>wrote: >> > >> > >> > >> > > I get a strange error when I try to drop table: >> > >> > > hypertable> show tables; >> > > A >> > > METADATA >> > > UBrecrep_recrep >> > > _test_table_8 >> > > t1 >> > > hypertable> drop table '_test_table_8'; >> > > 1225986718 ERROR hypertable : (/home/rzarajczyk/ >> hypertable-0.9.0.11- >> > > alpha/src/cc/Hypertable/Lib/MasterClient.cc:214) Master 'drop >> table' >> > > error : Problem getting attribute 'table_id' of hyperspace file >> '/ >> > > hypertable/tables/_test_table_8' >> > > Error: - HYPERSPACE attribute not found >> > >> > > I created the table using C++ API and there were no errors. >> >> >> >> >> >> >> >> >> >> >> >> >> >> > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/hypertable-dev?hl=en -~----------~----~----~----~------~----~------~--~---
