Unknown table '$vtable_43'

7 posts / 0 new
Last post
dankins
dankins's picture
Offline
Last seen: 1 year 4 months ago
Joined: Nov 10 2010
Junior Boarder

Posts: 9

Dan Kinsley
Unknown table '$vtable_43'

Hello,
I am running InfiniDB 2.0.3 on an Ubuntu VM, connecting using Squirrelsql and MySQL jdbc drivers. I loaded up a fact table with 50 million records and am able to run queries against it with great results.

However, any time I run a query, I receive a warning like "Warning: Unknown table '$vtable_44'". What could be causing this? I see that the "infinidb_vtable" schema is present, and the user has ALL access to it. When I run the query using idbmysql I see similar warnings when I run "show warnings".

Any hints?

Thanks,
Dan Kinsley

davidhill
davidhill's picture
Offline
Last seen: 1 month 3 weeks ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
Re:Unknown table '$vtable_43'

Ops, I mis-posted and re-editted my post. I did see you were just use the database to run the selects, not create the tables there. I see you get the error when using the '
warehouse' user.

dankins
dankins's picture
Offline
Last seen: 1 year 4 months ago
Joined: Nov 10 2010
Junior Boarder

Posts: 9

Dan Kinsley
Re:Unknown table '$vtable_43'

Hi David,
Thanks for the reply. I have been creating all of my tables in the "warehouse" schema (as you can see in the query I posted earlier).

Consider the following:
[code]
mysql> use warehouse;
Database changed
mysql> create table foo(id int) engine=infinidb;
Query OK, 0 rows affected (20.64 sec)

mysql> show warnings;
Empty set (0.00 sec)

mysql> insert into foo VALUES(1);
Query OK, 1 row affected (8.10 sec)

mysql> show warnings;
Empty set (0.00 sec)

mysql> select id from foo;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (2.64 sec)

mysql> show warnings;
+-------+------+----------------------------+
| Level | Code | Message |
+-------+------+----------------------------+
| Note | 1051 | Unknown table '$vtable_89' |
+-------+------+----------------------------+
1 row in set (0.00 sec)
[/code]

I have not been creating tables in the infinidb_vtable schema, I was using it to illustrate that their were no "$vtable_%" tables there.

I realize that this is a warning and isn't really affecting anything major, it is just a little annoying to see it every time I run a query. Now this is in a VM on my desktop, and only has access to 1GB of memory... could this be related? Could this just be a fluke and I should reinstall and try again?

Thanks again for the help with this.

- Dan

davidhill
davidhill's picture
Offline
Last seen: 1 month 3 weeks ago
Joined: Oct 27 2009
Administrator

Posts: 595

david hill
Re:Unknown table '$vtable_43'

Hey Dan, so your issue is a bit different.

The warning you are seeing is normal and it's occurring because it looks like you are using the 'infinidb_vtable' database. This database is for use by the InfiniDB software to create the temporary vtables. It's not intended to be used by users.
So you should be doing your selects in the database of 'warehouse'

Hope this helps...

David H
Calpont

dankins
dankins's picture
Offline
Last seen: 1 year 4 months ago
Joined: Nov 10 2010
Junior Boarder

Posts: 9

Dan Kinsley
Re:Unknown table '$vtable_43'

Not sure if this is useful, but is an example from debug.log that gave the warning:

Mar 3 17:59:27 ubuntu ExeMgr[1465]: 27.754992 |44|0|0| D 16 CAL0041: Start SQL statement: select max(date_tk) from ft_mytable
Mar 3 17:59:30 ubuntu ExeMgr[1465]: 30.615507 |44|0|0| D 16 CAL0042: End SQL statement

radams
radams's picture
Offline
Last seen: 3 days 10 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Re:Unknown table '$vtable_43'

Dan,

Thank you for downloading and trying out infiniDB.

It sounds like a tempory table which is created for DDL/DML
commands may have hung and not been deleted. You may
want to read the forum post below which had a similar issue.

http://www.infinidb.org/index.php?option=com_kunena&Itemid=64&func=view&...

For your circumstance please try using this drop table.

DROP TABLE $vtable_44 RESTRICT;

Thank you,

Robert
Calpont

dankins
dankins's picture
Offline
Last seen: 1 year 4 months ago
Joined: Nov 10 2010
Junior Boarder

Posts: 9

Dan Kinsley
Re:Unknown table '$vtable_43'

Robert,
Thanks for your reply. Should you be able to view these tables using "show tables"? Will they be in the "infinidb_vtable" schema?

[code]
mysql> use infinidb_vtable;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> select max(id) from warehouse.ft_voip_calls;
+----------+
| max(id) |
+----------+
| 45602639 |
+----------+
1 row in set (3.03 sec)

mysql> show warnings;
+-------+------+----------------------------+
| Level | Code | Message |
+-------+------+----------------------------+
| Note | 1051 | Unknown table '$vtable_89' |
+-------+------+----------------------------+
1 row in set (0.00 sec)

mysql> drop table $vtable_89 RESTRICT;
ERROR 1051 (42S02): Unknown table '$vtable_89'
mysql> show tables;
Empty set (0.00 sec)
[/code]

Could this be something else I have misconfigured?

Thanks,
Dan Kinsley