Bug 386967 – dev-db/mysql-5.1.56 - ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/ha_federated.so' (errno: 2 undefined symbol: dynstr_append_mem)

• Status: RESOLVED NEEDINFO
• Product: Gentoo Linux

[Description Juan Manuel Docile 2011-10-12 19:10:13 UTC]

I just update MySQL from 5.0.84 to 5.1.56.

can't load FEDERATED engine.

Maybe is related to the bug on the URL. Is it posible bump to 5.1.60?

This doesn't work for me. http://forums.gentoo.org/viewtopic-p-6674375.html#6674375


Reproducible: Always

[Comment 1 Jeroen Roovers (RETIRED) 2011-10-18 15:17:56 UTC]

1) Please post your `emerge --info dev-db/mysql' output in a comment.
2) Please post the entire output/logs related to this bug in a comment.

[Comment 2 Juan Manuel Docile 2011-10-18 15:26:55 UTC]

Created attachment 290169 [details]
attached emerge --info dev-db/mysql

[Comment 3 Juan Manuel Docile 2011-10-18 15:31:02 UTC]

It does not show as an engine FEDERATED available with USE="extraengine"

mysql> show engines;
+------------+---------+---------------------------------------------------------
| Engine     | Support | Comment                                                        
+------------+---------+---------------------------------------------------------
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) 
| CSV        | YES     | CSV storage engine                                             
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     
| ARCHIVE    | YES     | Archive storage engine                                         
+------------+---------+---------------------------------------------------------
7 rows in set (0.00 sec)

[Comment 4 Jorge Manuel B. S. Vicetto (RETIRED) 2011-10-26 19:38:40 UTC]

(In reply to comment #0)
> I just update MySQL from 5.0.84 to 5.1.56.
> 
> can't load FEDERATED engine.
> 
> Maybe is related to the bug on the URL. Is it posible bump to 5.1.60?
> 
> This doesn't work for me.
> http://forums.gentoo.org/viewtopic-p-6674375.html#6674375
> 
> 
> Reproducible: Always

There's no mysql-5.1.60 - you got me searching for the package a few days :-P

I'm working on a few mysql issues and I'll see if I can fix this one soon.

[Comment 5 Juan Manuel Docile 2011-10-26 20:15:44 UTC]

Oh, I'm sorry so much. I read it at the last comment in http://bugs.mysql.com/bug.php?id=40942

[Comment 6 Samu Voutilainen 2011-11-26 20:02:10 UTC]

Maybe federated engine needs to be enabled with daemon config file, not my.cnf...?

[Comment 7 Juan Manuel Docile 2012-01-25 20:18:05 UTC]

Well, now the lastes Generally Available MySQL Server is 5.1.61.
May be fix this issue.

[Comment 8 Robin Johnson 2012-02-02 03:02:54 UTC]

Did you load the federated plugin at all?
Either with the Install plugin command, or add this to your my.cnf:

plugin-load=federated=ha_federated.so
loose-federated

[Comment 9 Jorge Manuel B. S. Vicetto (RETIRED) 2012-11-17 06:22:30 UTC]

Closing as we need more information.