[aur-dev] Internal server error while searching for "es"
dpmcgee at gmail.com
Wed Jun 22 10:45:24 EDT 2011
On Wed, Jun 22, 2011 at 5:37 AM, Tuxce <tuxce.net at gmail.com> wrote:
> Hi, as yaourt maintainer, I received a bug ticket about yaourt giving
> an error while searching for "es" on AUR. It seems that searching for
> "es" with rpc (and maybe only "es") returns an internal server error.
> But I cannot reproduce it on a local installed aur (even at version
> If it's better to open a task on the bugtracker, just let me know.
'as' breaks it as well. Best guess is the result set is simply too
large and we hit PHP memory limits. See the following, which is
similar to the query that is being ran. The 'is' query works as the
scales tip somewhere between those result counts.
Is there a reason to ever return more than 5000 results? Your query
really sucks if you are getting that many hits.
mysql> select count(*) from Packages where Name like '%es%' or
Description like '%es%';
mysql> select count(*) from Packages where Name like '%as%' or
Description like '%as%';
mysql> select count(*) from Packages where Name like '%is%' or
Description like '%is%';
More information about the aur-dev