[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] Re: error when epadmin reindex



Only that command without options? I will see your video.
But if there's an error, please you can give us step by step to remove the
item using mysql query. Because I don't want accindently erase another item.

Regards,
Agung.
On Oct 26, 2015 5:52 PM, "Field A.N." <af05v at ecs.soton.ac.uk> wrote:

>
> epadmin reindex
>
> ...is the command (it's demoed in the search troubleshooting video at
> http://wiki.eprints.org/w/Training_Video:Search_Troubleshooting ), but if
> there are issues it might not be working properly.  If you don't have luck
> with that, you might need to remove them (carefully) using a mysql query.
>
> --
> Adam Field
> Business Relationship Manager and Community Lead
> EPrints Services
> +44 (0)23 8059 8814
>
>
>
>
>
> On 26 Oct 2015, at 06:08, Ajunk Pracetio wrote:
>
> > I can't found the command for clearing out the eprint_rindex table or
> the item with error.
> >
> > Thank you
> >
> > Regards,
> > Agung
> >
> > On Thu, Oct 22, 2015 at 6:30 PM, Field A.N. <af05v at ecs.soton.ac.uk>
> wrote:
> > Yes, clearing just the items with errors should be enough.
> >
> >
> > --
> > Adam Field
> > Business Relationship Manager and Community Lead
> > EPrints Services
> > +44 (0)23 8059 8814
> >
> >
> >
> >
> >
> > On 22 Oct 2015, at 12:26, Ajunk Pracetio wrote:
> >
> > > Ok Adam, I will try your suggest.
> > >
> > > Or maybe I only clear the item that have the problem?
> > >
> > > On Thu, Oct 22, 2015 at 5:29 PM, Field A.N. <af05v at ecs.soton.ac.uk>
> wrote:
> > > Issues with PDF files may be reported to the error log when EPrints
> gets them converted to text for indexing, and I wouldn't worry to much
> about that (though if you know which pdf files are causing the errors,
> perhaps you should inspect them and make sure the open successfully).  I'm
> not sure about the duplicate primary key issue.  You could try clearing out
> the eprint__rindex table (it's all automatically generated) and then
> reindexing your whole repository.
> > >
> > >
> > > --
> > > Adam Field
> > > Business Relationship Manager and Community Lead
> > > EPrints Services
> > > +44 (0)23 8059 8814
> > >
> > >
> > >
> > >
> > >
> > > On 21 Oct 2015, at 12:33, Ajunk Pracetio wrote:
> > >
> > > > I already try command bin/epadmin reindex sir eprint 292 --verbose
> --verbose and below is the result. It's too long, and I cut when error show
> up.
> > > >
> > > > .......
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > DBD::mysql::st execute failed: Duplicate entry 'documents--292' for
> key 'PRIMARY' at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm
> line 1287.
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__rindex`
> (`eprintid`,`field`,`word`) VALUES (?,?,?)
> > > > Database execute debug: INSERT INTO `eprint__index_grep`
> (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)
> > > > Indexed item: eprint/292
> > > >
> > > > It's still error about Duplicate entry, but there is still error
> like "illegal character", "Error: Restoring state when no valid states to
> pop", "Error: Missing or invalid 'Bounds' entry in stitching function",
> "Error: PDF file is damaged - attempting to reconstruct xref table...",
> "Error: Expected the optional content group list, but wasn't able to find
> it, or it isn't an Array", and "Error: Bad annotation destination"
> > > >
> > > > Thank you
> > > >
> > > > Regards,
> > > > Agung
> > > >
> > > >
> > > > On Wed, Oct 21, 2015 at 4:18 PM, Field A.N. <af05v at ecs.soton.ac.uk>
> wrote:
> > > > This won't fix the problem, it will just gather more information.
> > > >
> > > > --
> > > > Adam Field
> > > > Business Relationship Manager and Community Lead
> > > > EPrints Services
> > > > +44 (0)23 8059 8814
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On 21 Oct 2015, at 10:16, Ajunk Pracetio wrote:
> > > >
> > > > > If after I reindex that error item, and the problem still exist,
> what I must to do? is there any step that I must to do?
> > > > >
> > > > > my hardware spec :
> > > > > ProLiant ML150 G5
> > > > > RAM 6GB
> > > > >
> > > > > Regards,
> > > > > Agung
> > > > >
> > > > > On Wed, Oct 21, 2015 at 4:11 PM, Field A.N. <af05v at ecs.soton.ac.uk>
> wrote:
> > > > > Yes, that should be fine.
> > > > >
> > > > > What's the hardware spec of your server?
> > > > >
> > > > > --
> > > > > Adam Field
> > > > > Business Relationship Manager and Community Lead
> > > > > EPrints Services
> > > > > +44 (0)23 8059 8814
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > On 21 Oct 2015, at 10:01, Ajunk Pracetio wrote:
> > > > >
> > > > > > but the process very slow. my item only 1330, and it take about
> 1 day. Is there any problem with my indexer process? or maybe my RAM not
> enough? But, I will try it
> > > > > >
> > > > > > Btw, is it ok if I only reindex that item got error? using
> bin/epadmin reindex sir eprint 603 --verbose --verbose ?
> > > > > >
> > > > > > Regards,
> > > > > > Agung
> > > > > >
> > > > > > On Wed, Oct 21, 2015 at 3:41 PM, Field A.N. <
> af05v at ecs.soton.ac.uk> wrote:
> > > > > > Try running:
> > > > > >
> > > > > > bin/epadmin reindex sir eprint --verbose --verbose
> > > > > >
> > > > > > Two 'verbose' flags will increase the verbosity and show you the
> mysql query that's failing here.
> > > > > >
> > > > > > --
> > > > > > Adam Field
> > > > > > Business Relationship Manager and Community Lead
> > > > > > EPrints Services
> > > > > > +44 (0)23 8059 8814
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 21 Oct 2015, at 00:32, Ajunk Pracetio wrote:
> > > > > >
> > > > > > > I'm running EPrints 3.3.12. I already check using phpmyadmin
> and it's okay. Or maybe I must running mysqlcheck from command line?
> > > > > > >
> > > > > > > Is it possible to solve this error one by one, or the item
> must be reindex or maybe any other way?
> > > > > > >
> > > > > > > thank you
> > > > > > >
> > > > > > > On Tue, Oct 20, 2015 at 5:25 PM, Field A.N. <
> af05v at ecs.soton.ac.uk> wrote:
> > > > > > > What version of EPrints are your running?
> > > > > > >
> > > > > > > It looks like a database issue of some kind.  Have you tried
> running mysqlcheck?
> > > > > > >
> > > > > > > --
> > > > > > > Adam Field
> > > > > > > Business Relationship Manager and Community Lead
> > > > > > > EPrints Services
> > > > > > > +44 (0)23 8059 8814
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > On 20 Oct 2015, at 01:30, Ajunk Pracetio wrote:
> > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Yesterday I running command bin/epadmin reindex sir eprint
> --verbose
> > > > > > > > and I get a few like :
> > > > > > > >
> > > > > > > > DBD::mysql::st execute failed: Duplicate entry
> 'documents--604' for key 'PRIMARY' at
> /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 1287.
> > > > > > > >
> > > > > > > > Error (96): Illegal character '}'
> > > > > > > >
> > > > > > > > Error: Missing or invalid 'Bounds' entry in stitching
> function
> > > > > > > >
> > > > > > > > How I can fix this error?
> > > > > > > >
> > > > > > > > thank you
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > Life isn't valuable if you don't have someone to care
> > > > > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > > > > >
> > > > > > >
> > > > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Life isn't valuable if you don't have someone to care
> > > > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > > > >
> > > > > >
> > > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Life isn't valuable if you don't have someone to care
> > > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > > >
> > > > >
> > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Life isn't valuable if you don't have someone to care
> > > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > > *** Archive: http://www.eprints.org/tech.php/
> > > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > >
> > > >
> > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > *** Archive: http://www.eprints.org/tech.php/
> > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > *** EPrints developers Forum: http://forum.eprints.org/
> > > >
> > > >
> > > >
> > > > --
> > > > Life isn't valuable if you don't have someone to care
> > > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > > *** Archive: http://www.eprints.org/tech.php/
> > > > *** EPrints community wiki: http://wiki.eprints.org/
> > > > *** EPrints developers Forum: http://forum.eprints.org/
> > >
> > >
> > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > *** Archive: http://www.eprints.org/tech.php/
> > > *** EPrints community wiki: http://wiki.eprints.org/
> > > *** EPrints developers Forum: http://forum.eprints.org/
> > >
> > >
> > >
> > > --
> > > Life isn't valuable if you don't have someone to care
> > > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > > *** Archive: http://www.eprints.org/tech.php/
> > > *** EPrints community wiki: http://wiki.eprints.org/
> > > *** EPrints developers Forum: http://forum.eprints.org/
> >
> >
> > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > *** Archive: http://www.eprints.org/tech.php/
> > *** EPrints community wiki: http://wiki.eprints.org/
> > *** EPrints developers Forum: http://forum.eprints.org/
> >
> >
> >
> > --
> > Life isn't valuable if you don't have someone to care
> > *** Options:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> > *** Archive: http://www.eprints.org/tech.php/
> > *** EPrints community wiki: http://wiki.eprints.org/
> > *** EPrints developers Forum: http://forum.eprints.org/
>
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
> *** EPrints developers Forum: http://forum.eprints.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20151026/053fe370/attachment-0001.html