Re: [Gusdev-gusdev] Re: LoadTaxon.pm

[Deborah F. P. <pi...@pc...>]

Several of the attributes in taxon (ncbi_tax_id, parent_id and taxon_id)
should be indexed or they will cause the plugin to run very slowly at
several points. That was the reason for the line:  $dbh->do("analyze table
sres.Taxon compute statistics"); However, I suspect the line is not
accomplishing what I intended because of the permission issue and I
understand that it is platform specific. For those reasons, the line
should be removed (I will remove it now and update cvs).

                                                  Debbie



On Fri, 7 Mar 2003, Arnaud Kerhornou wrote:

> Another thing. At some point the code is trying to analyse the
> SRes.TaxonName table. I've got an insufficient privileges error.
>
> I've got two database logins which are used for connecting the database
> from the perl object layer:
> * databaseLogin=GUSrw
> * readOnlyDatabaseLogin=GUSro
>
> I guess the effective login to populate GUS is GUSrw, is that correct?
> Probably a question for you Martin. Does GUSrw have enough privileges to
> execute analyse table statements on any schemas (in particular the SRes
> shema) ?
>
> Arnaud
>
> ---------------------->
> DBD::Oracle::db do failed: ORA-01031: insufficient privileges (DBD
> ERROR: OCIStmtExecute) at /nfs/team81/axk/projects/
> gus/gus.deployment/lib/perl/GUS/Common/Plugin/LoadTaxon.pm line 304,
> <NODES> line 2.
> <----------------------
>
> line 304:   $dbh->do("analyze table sres.TaxonName compute statistics");
>
> Deborah F. Pinney wrote:
>
> >I didn't experience this problem. However, in looking over the
> >LoadTaxon.pm code I noticed that there was still a commented out line
> >that should have been corrected. This line is used only for restarting.
> >I have uncommented it and submitted to cvs. Please update your file.
> >
> >                                             Deborah Pinney
> >
> >
> >
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger
> for complex code. Debugging C/C++ programs can leave you feeling lost and
> disoriented. TotalView can help you find your way. Available on major UNIX
> and Linux platforms. Try it free. www.etnus.com
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>