← Back to team overview

maria-discuss team mailing list archive

Re: Orphaned TokuDB tables

 

On Tue, Aug 2, 2016 at 10:13 AM, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:

> Hi, Rich!
>
> Shall we include it in packages together with ha_tokudb.so?
> Or is it too dangerous for that?
>

It depends on how prevalent this problem is.  If there are just a few
instances of this problem, then maybe this tool should just be available
for support people to use.  However, if this problem starts to cost too
much, then perhaps the tool could be integrated into mysqld instead of
being a standalone tool.

In the long term, transactional DDL in the mysql server is the way to go as
it would close all of the holes.  In addition, there probably is some bug
in the interaction between the MySQL server and TokuDB WRT table creation
and deletion that may need to be fixed.  However, I was unable to find this
bug when working at Tokutek.


> On Aug 02, Rich Prohaska wrote:
> > Hello All,
> >
> > Sometimes, TokuDB gets left in a state where it thinks that parts of a
> > table exist (as observed in TokuDB's file map), but not all of the
> > underlying files (the TokuDB data files and/or the frm file) exist.  This
> > probably occurs due to the interaction between the non-transactional DDL
> > that MySQL/MariaDB uses to create or drop tables, and the transactional
> > TokuDB engine underneath.  There is some bug there.
> >
> > I added the tokudb_delete_dnames_from_directory tool to the
> > https://github.com/prohaska7/mariadb-server/tree/fix-tokudb-filemap
> > branch.  This standalone tool can be used to delete dnames from the
> > tokudb.directory.
>
> Regards,
> Sergei
> Chief Architect MariaDB
> and security@xxxxxxxxxxx
>

References