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

[EP-tech] Re: error when epadmin reindex



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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20151021/3860c01c/attachment.html