[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Reindex errors
- Subject: [EP-tech] Reindex errors
- From: drn at ecs.soton.ac.uk (David R Newman)
- Date: Tue, 30 May 2023 16:47:09 +0100
- In-reply-to: <CAKkNZ9D24P0t8L5CA_tUXUL=S3iS8Fm5B5ZyRbu_o19fUfx-Aw@mail.gmail.com>
- References: <CAKkNZ9B5xRLuWgv8T=WR5DHZSwLuRpu0vJyhqySNRvNTjg3ehA@mail.gmail.com> <CAKkNZ9D24P0t8L5CA_tUXUL=S3iS8Fm5B5ZyRbu_o19fUfx-Aw@mail.gmail.com> <CAKkNZ9D24P0t8L5CA_tUXUL=S3iS8Fm5B5ZyRbu_o19fUfx-Aw@mail.gmail.com> <0fb5f933-ce31-f9ec-b2db-c490c024fa28@ecs.soton.ac.uk>
Hi James,
I think the GitHub issue and commit you found should fix the issue you
reported, that was my intention when I made the change.
With regards to the other error:
?Internal Error: xref num 779 not found but needed, try to reconstruct<0a>
I think this may be fixed by
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F310&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311161855%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=afBaa2s0ZwXUrOADxF86TULvhfUMMfbAfNIOWS1qRPY%3D&reserved=0
Regards
David Newman
On 30/05/2023 16:41, James Kerwin via Eprints-tech wrote:
> *CAUTION:* This e-mail originated outside the University of Southampton.
> Found this:
>
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F247&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311161855%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=OXO%2Fq5AbazgL3Ucl4GZU%2FLd6REZIJ8EBiHKbBmbVkv4%3D&reserved=0
> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F247&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311161855%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=OXO%2Fq5AbazgL3Ucl4GZU%2FLd6REZIJ8EBiHKbBmbVkv4%3D&reserved=0>
>
> With this solution:
>
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fcommit%2F5e9826c41c8990c5053b1cff53d7f7ef76194365&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311161855%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=owZlsV%2B2R50i9Z0qBWBQIEAd9zCw%2Bzb6Fx%2BOcCUAu%2BY%3D&reserved=0
> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fcommit%2F5e9826c41c8990c5053b1cff53d7f7ef76194365&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311161855%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=owZlsV%2B2R50i9Z0qBWBQIEAd9zCw%2Bzb6Fx%2BOcCUAu%2BY%3D&reserved=0>
>
> My indexing.pl
> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Findexing.pl%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311318104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=cBIFhIzp6cGM3WIXX1bFepDxM1QyqcAPrhmMi42GKi8%3D&reserved=0>
> file isn't quite the same, but I get the general idea. In case it's
> helpful to anyone else.
>
> Thanks,
> James
>
> On Tue, May 30, 2023 at 3:51?PM James Kerwin <jkerwin2101 at gmail.com>
> wrote:
>
> Hi All,
>
> Wondering if anyone can lend me some knowledge. Crawling towards
> the end of my test repository server upgrade. Managed to import
> the MySQL database after some fussing about.
>
> Doing a reindex of the eprint dataset. Got a few missing phrase
> errors which is quite helpful.
>
> Got this one twice that I've no idea about:
>
> ?Internal Error: xref num 779 not found but needed, try to
> reconstruct<0a>
>
> A quick Google suggests it's something to do with PDFs? Should I
> be worried?
>
> This one has appeared a lot:
>
> DBD::mysql::st execute failed: Data too long for column 'word' at
> row 1 at /opt/eprints3/bin/../perl_lib/EPrints/Database.pm line 1283.
>
> It looks as though the column "word" appears in:
>
> document__rindex
> eprint__rindex
> request__rindex
> saved_search__rindex
> subject__rindex
> user__rindex
>
> In the eprint__rindex table the "word" column is varchar(128). I
> imagine if I change the length/type this error might go away. Is
> this the correct thing to do or is it a sign of something more
> serious?
>
> As this is my Test server it's a dry run for the Live server
> upgrade and I don't want to just ignore errors. The Live upgrade
> will need to be a much quicker affair and have as few delays as
> possible.
>
> Thanks,
> James
>
>
>
> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive:https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311318104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=qQXFWhpDanNOxFsmQ6dDVKqavSW2lKdEtwXMjmrwITw%3D&reserved=0
> *** EPrints community wiki:https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C7f05405a73b14c818f4508db61252112%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638210584311318104%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9BT7MaJf53qlLnscJjxTKZWIMRE3CIK%2FXqvYm7paraQ%3D&reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230530/3fa04b4f/attachment.html