<div dir="ltr"><div><div><div><div><div><div><div>Hi Mateus,<br><br></div>I could solve this problem by commenting out the line: "die "The master dabase must be defined with a collection" if $self->o('master_db') and not $self->o('collection');"<br><br></div>in LoadMembers_conf.pm. The member_db is now correctly set up.<br><br></div>However, when I run the Protein trees pipeline I get the following error message <br><br>mysql> SELECT * FROM msg;<br>+-------------+-------------------------------+----------------+--------+---------+-----------+---------------------+-------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+<br>| analysis_id | logic_name | log_message_id | job_id | role_id | worker_id | when_logged | retry | status | msg | is_error |<br>+-------------+-------------------------------+----------------+--------+---------+-----------+---------------------+-------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+<br>| 9 | copy_ncbi_table | 1 | 5 | 3 | 3 | 2018-01-12 14:21:39 | 0 | WRITE_OUTPUT | Successfully copied 1646504 'ncbi_taxa_node' rows | 0 |<br>| 9 | copy_ncbi_table | 2 | 6 | 4 | 4 | 2018-01-12 14:25:27 | 0 | WRITE_OUTPUT | Successfully copied 2504391 'ncbi_taxa_name' rows | 0 |<br>| 10 | populate_method_links_from_db | 3 | 7 | 6 | 6 | 2018-01-12 14:26:54 | 0 | WRITE_OUTPUT | Successfully copied 18 'method_link' rows | 0 |<br>| 16 | create_mlss_ss | 4 | 10 | 9 | 9 | 2018-01-12 14:29:56 | 0 | FETCH_INPUT | Cannot find the method_link 'ENSEMBL_HOMOEOLOGUES' at /home/hd/hd_hd/hd_cc141/EnsEMBL/ensembl-compara/modules/Bio/EnsEMBL/Compara/RunnableDB/PrepareSpeciesSetsMLSS.pm line 70. | 1 |<br>| 16 | create_mlss_ss | 5 | 10 | 10 | 10 | 2018-01-12 14:30:57 | 1 | FETCH_INPUT | Cannot find the method_link 'ENSEMBL_HOMOEOLOGUES' at /home/hd/hd_hd/hd_cc141/EnsEMBL/ensembl-compara/modules/Bio/EnsEMBL/Compara/RunnableDB/PrepareSpeciesSetsMLSS.pm line 70. | 1 |<br>| 16 | create_mlss_ss | 6 | 10 | 11 | 11 | 2018-01-12 14:31:58 | 2 | FETCH_INPUT | Cannot find the method_link 'ENSEMBL_HOMOEOLOGUES' at /home/hd/hd_hd/hd_cc141/EnsEMBL/ensembl-compara/modules/Bio/EnsEMBL/Compara/RunnableDB/PrepareSpeciesSetsMLSS.pm line 70. | 1 |<br>| 16 | create_mlss_ss | 7 | 10 | 12 | 12 | 2018-01-12 14:33:00 | 3 | FETCH_INPUT | Cannot find the method_link 'ENSEMBL_HOMOEOLOGUES' at /home/hd/hd_hd/hd_cc141/EnsEMBL/ensembl-compara/modules/Bio/EnsEMBL/Compara/RunnableDB/PrepareSpeciesSetsMLSS.pm line 70. | 1 |<br>| 16 | create_mlss_ss | 8 | 10 | 13 | 13 | 2018-01-12 14:38:36 | 1 | FETCH_INPUT | Cannot find the method_link 'ENSEMBL_HOMOEOLOGUES' at /home/hd/hd_hd/hd_cc141/EnsEMBL/ensembl-compara/modules/Bio/EnsEMBL/Compara/RunnableDB/PrepareSpeciesSetsMLSS.pm line 70. | 1 |<br>+-------------+-------------------------------+----------------+--------+---------+-----------+---------------------+-------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+<br>8 rows in set (0.01 sec)<br><br></div>I wasn't aware about this method_link.<br><br></div>Do you know how can I fix this?<br><br></div>Thanks,<br></div>Francesco.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-01-11 13:28 GMT+01:00 Francesco Lamanna <span dir="ltr"><<a href="mailto:francesco.lamanna@gmail.com" target="_blank">francesco.lamanna@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Hi Mateus,<br><br></div>if I try to initialize the LoadMemebers pipeline without “<span style="font-family:"Courier New"">--collection ensembl</span>”, I get the following error:<br><br>The following options are missing:<br> {'collection'}<br><br></div>I also tried to set 'collection' => undef, in the conf file, but I get another error:<br><br>The master dabase must be defined with a collection at /home/hd/hd_hd/hd_cc141/<wbr>EnsEMBL/ensembl-compara/<wbr>modules/Bio/EnsEMBL/Compara/<wbr>PipeConfig/LoadMembers_conf.pm line 190.<br><br></div>Cheers,<br></div>Francesco<br></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2018-01-11 12:01 GMT+01:00 Mateus Patricio <span dir="ltr"><<a href="mailto:mateus@ebi.ac.uk" target="_blank">mateus@ebi.ac.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Hi Francesco,<div><br></div><div>In your case the solution should be starting the LoadMembers without the option “<span style="font-family:'Courier New'">--collection ensembl</span>”.</div><div><br></div><div>If you start the pipeline without it, it should use all the current species in your master database.</div><div><br></div><div>In Ensembl we have different collections that are used for different purposes, and the default one is “<span style="font-family:'Courier New'">ensembl</span>”.</div><div><br></div><div>Please let me know if this works.</div><div><br></div><div>Cheers,</div><div><br></div><div>Mateus.</div><div><div class="m_-5310891173211122331h5"><div><br></div><div><br><div><blockquote type="cite"><div>On 11 Jan 2018, at 10:13, Francesco Lamanna <<a href="mailto:francesco.lamanna@gmail.com" target="_blank">francesco.lamanna@gmail.com</a>> wrote:</div><br class="m_-5310891173211122331m_6553179308464348895Apple-interchange-newline"><div><div dir="ltr"><div><div><div><div>Hi Mateus,<br><br></div>many thanks for your answer.<br><br></div>I am trying to launch the LoadMembers pipeline in order to make a member_db, but I get the following error:<br><br>mysql> SELECT * from msg;<br>+-------------+---------------<wbr>---------+----------------+---<wbr>-----+---------+-----------+--<wbr>-------------------+-------+--<wbr>------------+-----------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-+----------+<br>| analysis_id | logic_name | log_message_id | job_id | role_id | worker_id | when_logged | retry | status | msg <wbr> <wbr> <wbr> <wbr> <wbr> | is_error |<br>+-------------+---------------<wbr>---------+----------------+---<wbr>-----+---------+-----------+--<wbr>-------------------+-------+--<wbr>------------+-----------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-+----------+<br>| 3 | copy_table_from_master | 1 | 4 | 3 | 3 | 2018-01-11 11:04:02 | 0 | WRITE_OUTPUT | Successfully copied 1646504 'ncbi_taxa_node' rows <wbr> <wbr> <wbr> <wbr> | 0 |<br>| 3 | copy_table_from_master | 2 | 5 | 4 | 4 | 2018-01-11 11:05:46 | 0 | WRITE_OUTPUT | Successfully copied 2504391 'ncbi_taxa_name' rows <wbr> <wbr> <wbr> <wbr> | 0 |<br>| 4 | load_genomedb_factory | 3 | 3 | 5 | 5 | 2018-01-11 11:07:06 | 0 | FETCH_INPUT | Could not fetch collection ss with name=ensembl at /home/hd/hd_hd/hd_cc141/EnsEMB<wbr>L/ensembl-compara/modules/Bio/<wbr>EnsEMBL/Compara/RunnableDB/<wbr>GenomeDBFactory.pm line 106. | 1 |<br>| 4 | load_genomedb_factory | 4 | 3 | 6 | 6 | 2018-01-11 11:08:00 | 1 | FETCH_INPUT | Could not fetch collection ss with name=ensembl at /home/hd/hd_hd/hd_cc141/EnsEMB<wbr>L/ensembl-compara/modules/Bio/<wbr>EnsEMBL/Compara/RunnableDB/<wbr>GenomeDBFactory.pm line 106. | 1 |<br>| 4 | load_genomedb_factory | 5 | 3 | 7 | 7 | 2018-01-11 11:08:25 | 2 | FETCH_INPUT | Could not fetch collection ss with name=ensembl at /home/hd/hd_hd/hd_cc141/EnsEMB<wbr>L/ensembl-compara/modules/Bio/<wbr>EnsEMBL/Compara/RunnableDB/<wbr>GenomeDBFactory.pm line 106. | 1 |<br>| 4 | load_genomedb_factory | 6 | 3 | 8 | 8 | 2018-01-11 11:09:25 | 3 | FETCH_INPUT | Could not fetch collection ss with name=ensembl at /home/hd/hd_hd/hd_cc141/EnsEMB<wbr>L/ensembl-compara/modules/Bio/<wbr>EnsEMBL/Compara/RunnableDB/<wbr>GenomeDBFactory.pm line 106. | 1 |<br>+-------------+---------------<wbr>---------+----------------+---<wbr>-----+---------+-----------+--<wbr>-------------------+-------+--<wbr>------------+-----------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-+----------+<br>6<br><br></div>Cheers,<br></div>Francesco. <br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-01-10 17:31 GMT+01:00 Mateus Patricio <span dir="ltr"><<a href="mailto:mateus@ebi.ac.uk" target="_blank">mateus@ebi.ac.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>Hi Francesco</div><div><br></div><div>The protein tree pipeline reuses the genes and sequence members from the 'reuse_db' parameter, which in this case should point to a members database.</div><div><br></div><div>This members database can be created by running the LoadMembers pipeline.</div><div><br></div><div>You can initiate the pipeline with the following command line:</div><div><br></div><div><font face="Courier New"><a href="http://init_pipeline.pl/" target="_blank">init_pipeline.pl</a> Bio::EnsEMBL::Compara::PipeCon<wbr>fig::EBI::Ensembl::LoadMembers<wbr>_conf --collection ensembl</font></div><div><br></div><div>Then you should point the parameter reuse_db to this database on your Protein Tree config file.</div><div><br></div><div><font face="Courier New">'reuse_db' => '<a>mysql://ensro@host:port/datab<wbr>ase</a>',</font></div><div><br></div><div>Please do let me know if you have further questions.</div><div><br></div><div>Cheers,</div><div><br></div><div>Mateus.</div><div><br></div><div><br></div><div><blockquote type="cite"><div><div class="m_-5310891173211122331m_6553179308464348895h5"><div>On 10 Jan 2018, at 16:06, Francesco Lamanna <<a href="mailto:francesco.lamanna@gmail.com" target="_blank">francesco.lamanna@gmail.com</a>> wrote:</div><br class="m_-5310891173211122331m_6553179308464348895m_-3026777456766023304Apple-interchange-newline"></div></div><div><div><div class="m_-5310891173211122331m_6553179308464348895h5"><div dir="ltr"><div><div><div><div><div>Hi all,<br><br></div>when I try to run the protein tree pipeline (v91) using the core Human and Chicken genomes I get the following error message:<br><br>mysql> SELECT * from msg;<br>+-------------+---------------<wbr>----------------+-------------<wbr>---+--------+---------+-------<wbr>----+---------------------+---<wbr>----+--------------+----------<wbr>------------------------------<wbr>------------------------------<wbr>--------------+----------+<br>| analysis_id | logic_name | log_message_id | job_id | role_id | worker_id | when_logged | retry | status | msg <wbr> <wbr> | is_error |<br>+-------------+---------------<wbr>----------------+-------------<wbr>---+--------+---------+-------<wbr>----+---------------------+---<wbr>----+--------------+----------<wbr>------------------------------<wbr>------------------------------<wbr>--------------+----------+<br>| 9 | copy_ncbi_table | 1 | 5 | 3 | 4 | 2018-01-10 16:40:13 | 0 | WRITE_OUTPUT | Successfully copied 1646504 'ncbi_taxa_node' rows <wbr> | 0 |<br>| 9 | copy_ncbi_table | 2 | 6 | 4 | 3 | 2018-01-10 16:42:04 | 0 | WRITE_OUTPUT | Successfully copied 2504391 'ncbi_taxa_name' rows <wbr> | 0 |<br>| 10 | populate_method_links_from_db | 3 | 7 | 6 | 6 | 2018-01-10 16:43:44 | 0 | WRITE_OUTPUT | Successfully copied 18 'method_link' rows <wbr> | 0 |<br>| 25 | genome_member_copy | 4 | 13 | 11 | 11 | 2018-01-10 16:47:49 | 0 | FETCH_INPUT | ParamError: value for param_required('reuse_db') is required and has to be defined | 1 |<br>| 25 | genome_member_copy | 5 | 14 | 12 | 12 | 2018-01-10 16:47:49 | 0 | FETCH_INPUT | ParamError: value for param_required('reuse_db') is required and has to be defined | 1 |<br>+-------------+---------------<wbr>----------------+-------------<wbr>---+--------+---------+-------<wbr>----+---------------------+---<wbr>----+--------------+----------<wbr>------------------------------<wbr>------------------------------<wbr>--------------+----------+<br><br></div>I have no clue about what to put in the 'reuse_db' parameter (nor could I find any information in the compara docs). <br><br></div>Can anyone please help me to solve this issue?<br><br></div>Thanks,<br></div>Francesco.<br></div></div></div>
______________________________<wbr>_________________<br>Dev mailing list <a href="mailto:Dev@ensembl.org" target="_blank">Dev@ensembl.org</a><br>Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev" target="_blank">http://lists.ensembl.org/mailm<wbr>an/listinfo/dev</a><br>Ensembl Blog: <a href="http://www.ensembl.info/" target="_blank">http://www.ensembl.info/</a><br></div></blockquote></div><br></div><br>______________________________<wbr>_________________<br>
Dev mailing list <a href="mailto:Dev@ensembl.org" target="_blank">Dev@ensembl.org</a><br>
Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev" rel="noreferrer" target="_blank">http://lists.ensembl.org/mailm<wbr>an/listinfo/dev</a><br>
Ensembl Blog: <a href="http://www.ensembl.info/" rel="noreferrer" target="_blank">http://www.ensembl.info/</a><br>
<br></blockquote></div><br></div>
______________________________<wbr>_________________<br>Dev mailing list <a href="mailto:Dev@ensembl.org" target="_blank">Dev@ensembl.org</a><br>Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev" target="_blank">http://lists.ensembl.org/mailm<wbr>an/listinfo/dev</a><br>Ensembl Blog: <a href="http://www.ensembl.info/" target="_blank">http://www.ensembl.info/</a><br></div></blockquote></div><br></div></div></div></div><br>______________________________<wbr>_________________<br>
Dev mailing list <a href="mailto:Dev@ensembl.org" target="_blank">Dev@ensembl.org</a><br>
Posting guidelines and subscribe/unsubscribe info: <a href="http://lists.ensembl.org/mailman/listinfo/dev" rel="noreferrer" target="_blank">http://lists.ensembl.org/mailm<wbr>an/listinfo/dev</a><br>
Ensembl Blog: <a href="http://www.ensembl.info/" rel="noreferrer" target="_blank">http://www.ensembl.info/</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>