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 -~----------~----~----~----~------~----~------~--~---
