Symlinks not working when pointing to another table.

Hello,

I've done lot of researches and tests but can't find any answer. I need
to share one table between two db, those two db are in the same path (
/var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to
the table in db1.
When I query the table from db2 I get this error :
'ERROR 1030 (HY000): Got error 140 from storage engine'
I'm sure it was working in previous version of MySQL, but from the last
version it's no longer working.

This is how it looks :

test-lan:/var/lib/mysql/test3# ls -alh
drwx------ 2 mysql mysql 4.0K 2010-08-30 13:28 .
drwxr-xr-x 6 mysql mysql 4.0K 2010-08-30 13:29 ..
lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.frm -> /var/lib/mysql/test/blbl.frm
lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYD -> /var/lib/mysql/test/blbl.MYD
lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYI -> /var/lib/mysql/test/blbl.MYI
-rw-rw---- 1 mysql mysql 65 2010-08-30 13:24 db.opt


I really need those symlinks, is there a way to make them working like
before ? ( old MySQL-server is fine )

Thanks,


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Symlinks not working when pointing to another table.

> -----Original Message-----
> From: Julien Lory [mailto:julien.lory@gmail.com]
> Sent: Thursday, September 02, 2010 12:31 PM
> To: mysql@lists.mysql.com
> Subject: Symlinks not working when pointing to another table.
>
> Hello,
>
> I've done lot of researches and tests but can't find any
> answer. I need
> to share one table between two db, those two db are in the
> same path (
> /var/lib/mysql/db1 & db2 ). I created symbolic links for db2
> pointing to
> the table in db1.
> When I query the table from db2 I get this error :
> 'ERROR 1030 (HY000): Got error 140 from storage engine'
> I'm sure it was working in previous version of MySQL, but
> from the last
> version it's no longer working.
>
> This is how it looks :
>
> test-lan:/var/lib/mysql/test3# ls -alh
> drwx------ 2 mysql mysql 4.0K 2010-08-30 13:28 .
> drwxr-xr-x 6 mysql mysql 4.0K 2010-08-30 13:29 ..
> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.frm ->
> /var/lib/mysql/test/blbl.frm
> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYD ->
> /var/lib/mysql/test/blbl.MYD
> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYI ->
> /var/lib/mysql/test/blbl.MYI
> -rw-rw---- 1 mysql mysql 65 2010-08-30 13:24 db.opt
>
>
> I really need those symlinks, is there a way to make them
> working like
> before ? ( old MySQL-server is fine )

Just out of curiosity. If you're using apparmor and this new directory is
on another partion or mount point or anything, you might have to add a rule
in apparmor's config for them...


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Symlinks not working when pointing to another table.

I'm using Debian Lenny ( up to date ), so there is no app armor /
selinux / grsec :/

ii mysql-client-5.0 5.0.51a-24+lenny4 MySQL
database client binaries
ii mysql-common 5.0.51a-24+lenny4 MySQL
database common files
ii mysql-server-5.0 5.0.51a-24+lenny4 MySQL
database server binaries


On 02/09/2010 16:18, Daevid Vincent wrote:
>
>
>
>> -----Original Message-----
>> From: Julien Lory [mailto:julien.lory@gmail.com]
>> Sent: Thursday, September 02, 2010 12:31 PM
>> To: mysql@lists.mysql.com
>> Subject: Symlinks not working when pointing to another table.
>>
>> Hello,
>>
>> I've done lot of researches and tests but can't find any
>> answer. I need
>> to share one table between two db, those two db are in the
>> same path (
>> /var/lib/mysql/db1& db2 ). I created symbolic links for db2
>> pointing to
>> the table in db1.
>> When I query the table from db2 I get this error :
>> 'ERROR 1030 (HY000): Got error 140 from storage engine'
>> I'm sure it was working in previous version of MySQL, but
>> from the last
>> version it's no longer working.
>>
>> This is how it looks :
>>
>> test-lan:/var/lib/mysql/test3# ls -alh
>> drwx------ 2 mysql mysql 4.0K 2010-08-30 13:28 .
>> drwxr-xr-x 6 mysql mysql 4.0K 2010-08-30 13:29 ..
>> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.frm ->
>> /var/lib/mysql/test/blbl.frm
>> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYD ->
>> /var/lib/mysql/test/blbl.MYD
>> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYI ->
>> /var/lib/mysql/test/blbl.MYI
>> -rw-rw---- 1 mysql mysql 65 2010-08-30 13:24 db.opt
>>
>>
>> I really need those symlinks, is there a way to make them
>> working like
>> before ? ( old MySQL-server is fine )
>>
> Just out of curiosity. If you're using apparmor and this new directory is
> on another partion or mount point or anything, you might have to add a rule
> in apparmor's config for them...
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Symlinks not working when pointing to another table.

On 9/2/2010 3:31 PM, Julien Lory wrote:
> Hello,
>
> I've done lot of researches and tests but can't find any answer. I need
> to share one table between two db, those two db are in the same path (
> /var/lib/mysql/db1 & db2 ). I created symbolic links for db2 pointing to
> the table in db1.
> When I query the table from db2 I get this error :
> 'ERROR 1030 (HY000): Got error 140 from storage engine'
> I'm sure it was working in previous version of MySQL, but from the last
> version it's no longer working.
>
> This is how it looks :
>
> test-lan:/var/lib/mysql/test3# ls -alh
> drwx------ 2 mysql mysql 4.0K 2010-08-30 13:28 .
> drwxr-xr-x 6 mysql mysql 4.0K 2010-08-30 13:29 ..
> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.frm ->
> /var/lib/mysql/test/blbl.frm
> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYD ->
> /var/lib/mysql/test/blbl.MYD
> lrwxrwxrwx 1 mysql mysql 28 2010-08-30 13:28 blbl.MYI ->
> /var/lib/mysql/test/blbl.MYI
> -rw-rw---- 1 mysql mysql 65 2010-08-30 13:24 db.opt
>
>
> I really need those symlinks, is there a way to make them working like
> before ? ( old MySQL-server is fine )
>

You cannot share one set of files (one table) between two different
MySQL instances. That also means that you cannot share a table between
the same instance by pretending it's something else by a symlink. The
storage engines are designed with the premise that they have exclusive
domain over the files they manage. Sharing is not part of their code.

If you need to expose a table from within a different database, you must
use a view.

--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org