[ensembl-dev] skip lock tables for ensembl-compara

Francesco Lamanna francesco.lamanna at gmail.com
Wed Nov 8 17:36:10 GMT 2017


Hello,

I am trying to apply the ProteinTrees pipeline to a set of Ensembl and
non-Ensembl genomes.

When running the pipeline without a master database (via beekeeper.pl) I
get the following error:

ensembl_compara_90 ncbi_taxa_node  | sed "s/ENGINE=MyISAM/ENGINE=InnoDB/"
|  mysql -h127.0.0.1 -P3306 -uroot -p$EHIVE_TMP_PASSWORD_0
hd_cc141_test_protein_trees_no_master_90' resulted in an error code=2
stderr is: mysql: [Warning] Using a password on the command line interface
can be insecure.
mysqldump: Got error: 1044: Access denied for user 'anonymous'@'%' to
database 'ensembl_compara_90' when doing LOCK TABLES


Is there a way to pass --skip-lock-tables to the pipeline (e.g. in the conf
file) in order to be able to dump the database?

Thanks,
Francesco.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20171108/a105d87f/attachment.html>


More information about the Dev mailing list