<div dir="ltr">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.<div><br></div><div>.......<br><div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div><b><font color="#ff0000">DBD::mysql::st execute failed: Duplicate entry 'documents--292' for key 'PRIMARY' at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 1287.</font></b></div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__rindex` (`eprintid`,`field`,`word`) VALUES (?,?,?)</div><div>Database execute debug: INSERT INTO `eprint__index_grep` (`eprintid`,`fieldname`,`grepstring`) VALUES (?,?,?)</div><div>Indexed item: eprint/292</div></div><div><br></div><div>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"</div><div><br></div><div>Thank you</div><div><br></div><div>Regards,</div><div>Agung</div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Oct 21, 2015 at 4:18 PM, Field A.N. <span dir="ltr"><<a href="mailto:af05v@ecs.soton.ac.uk" target="_blank">af05v@ecs.soton.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">This won't fix the problem, it will just gather more information.<br>
<span class="im HOEnZb"><br>
--<br>
Adam Field<br>
Business Relationship Manager and Community Lead<br>
EPrints Services<br>
<a href="tel:%2B44%20%280%2923%208059%208814" value="+442380598814">+44 (0)23 8059 8814</a><br>
<br>
<br>
<br>
<br>
<br>
</span><div class="HOEnZb"><div class="h5">On 21 Oct 2015, at 10:16, Ajunk Pracetio wrote:<br>
<br>
> 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?<br>
><br>
> my hardware spec :<br>
> ProLiant ML150 G5<br>
> RAM 6GB<br>
><br>
> Regards,<br>
> Agung<br>
><br>
> On Wed, Oct 21, 2015 at 4:11 PM, Field A.N. <<a href="mailto:af05v@ecs.soton.ac.uk">af05v@ecs.soton.ac.uk</a>> wrote:<br>
> Yes, that should be fine.<br>
><br>
> What's the hardware spec of your server?<br>
><br>
> --<br>
> Adam Field<br>
> Business Relationship Manager and Community Lead<br>
> EPrints Services<br>
> <a href="tel:%2B44%20%280%2923%208059%208814" value="+442380598814">+44 (0)23 8059 8814</a><br>
><br>
><br>
><br>
><br>
><br>
> On 21 Oct 2015, at 10:01, Ajunk Pracetio wrote:<br>
><br>
> > 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<br>
> ><br>
> > Btw, is it ok if I only reindex that item got error? using bin/epadmin reindex sir eprint 603 --verbose --verbose ?<br>
> ><br>
> > Regards,<br>
> > Agung<br>
> ><br>
> > On Wed, Oct 21, 2015 at 3:41 PM, Field A.N. <<a href="mailto:af05v@ecs.soton.ac.uk">af05v@ecs.soton.ac.uk</a>> wrote:<br>
> > Try running:<br>
> ><br>
> > bin/epadmin reindex sir eprint --verbose --verbose<br>
> ><br>
> > Two 'verbose' flags will increase the verbosity and show you the mysql query that's failing here.<br>
> ><br>
> > --<br>
> > Adam Field<br>
> > Business Relationship Manager and Community Lead<br>
> > EPrints Services<br>
> > <a href="tel:%2B44%20%280%2923%208059%208814" value="+442380598814">+44 (0)23 8059 8814</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > On 21 Oct 2015, at 00:32, Ajunk Pracetio wrote:<br>
> ><br>
> > > 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?<br>
> > ><br>
> > > Is it possible to solve this error one by one, or the item must be reindex or maybe any other way?<br>
> > ><br>
> > > thank you<br>
> > ><br>
> > > On Tue, Oct 20, 2015 at 5:25 PM, Field A.N. <<a href="mailto:af05v@ecs.soton.ac.uk">af05v@ecs.soton.ac.uk</a>> wrote:<br>
> > > What version of EPrints are your running?<br>
> > ><br>
> > > It looks like a database issue of some kind. Have you tried running mysqlcheck?<br>
> > ><br>
> > > --<br>
> > > Adam Field<br>
> > > Business Relationship Manager and Community Lead<br>
> > > EPrints Services<br>
> > > <a href="tel:%2B44%20%280%2923%208059%208814" value="+442380598814">+44 (0)23 8059 8814</a><br>
> > ><br>
> > ><br>
> > ><br>
> > ><br>
> > ><br>
> > > On 20 Oct 2015, at 01:30, Ajunk Pracetio wrote:<br>
> > ><br>
> > > > Hi,<br>
> > > ><br>
> > > > Yesterday I running command bin/epadmin reindex sir eprint --verbose<br>
> > > > and I get a few like :<br>
> > > ><br>
> > > > DBD::mysql::st execute failed: Duplicate entry 'documents--604' for key 'PRIMARY' at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 1287.<br>
> > > ><br>
> > > > Error (96): Illegal character '}'<br>
> > > ><br>
> > > > Error: Missing or invalid 'Bounds' entry in stitching function<br>
> > > ><br>
> > > > How I can fix this error?<br>
> > > ><br>
> > > > thank you<br>
> > > ><br>
> > > ><br>
> > > > --<br>
> > > > Life isn't valuable if you don't have someone to care<br>
> > > > *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> > > > *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> > > > *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> > > > *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
> > ><br>
> > ><br>
> > > *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> > > *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> > > *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> > > *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
> > ><br>
> > ><br>
> > ><br>
> > > --<br>
> > > Life isn't valuable if you don't have someone to care<br>
> > > *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> > > *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> > > *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> > > *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
> ><br>
> ><br>
> > *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> > *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> > *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> > *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Life isn't valuable if you don't have someone to care<br>
> > *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> > *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> > *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> > *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
><br>
><br>
> *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
><br>
><br>
><br>
> --<br>
> Life isn't valuable if you don't have someone to care<br>
> *** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
> *** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
> *** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
> *** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
<br>
<br>
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="http://www.eprints.org/tech.php/" rel="noreferrer" target="_blank">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="http://wiki.eprints.org/" rel="noreferrer" target="_blank">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a href="http://forum.eprints.org/" rel="noreferrer" target="_blank">http://forum.eprints.org/</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Life isn't valuable if you don't have someone to care</div>
</div>