[OPEN-ILS-DEV] Evergreen 1.404..Can't search for patrons, or get wierd Postgres error

[Mike Rylander]

On Thu, Jun 11, 2009 at 4:31 PM, Hunt, Phil<hunt at nelinet.net> wrote:
> I finally figured out the proglems I was having with postgres 8.2

What version of Evergreen is this?

--miker

>
> I added 2 patrons, 1 as a system admin, one as a std patron.  It showed
> some relatively minor errors during the add, but I got 'User update
> succeeded', the errors seen were like this:
>
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Argument "1244750664.98621995.466378585992" isn't numeric in numeric ne
> (!=) at /openils/lib/perl5/OpenILS/Application/Actor.pm line 505,
> <STDIN> line 1.
> Argument "1244750664.98621995.466378585992" isn't numeric in numeric ne
> (!=) at /openils/lib/perl5/OpenILS/Application/Actor.pm line 505,
> <STDIN> line 1.
> Use of uninitialized value $p[2] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
>
>
>
> If I do a search by barcode, they lookup fine.
>
> If I do a search for patron, using any patron fields, I get this in the
> error log for actor...
>
> Use of uninitialized value in hash element at
> /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm line 193, <STDIN> line
> 1.
> received error : service=open-ils.storage :
> method=open-ils.storage.actor.user.crazy_search : params=$VAR1 =
> [{'email' => {'group' => 0,'value' =>
> 'normal at nowhere.com'}},51,['family_name ASC','first_given_name
> ASC','second_given_name ASC','dob DESC'],1,'4','2'];
>  Exception: OpenSRF::EX::ERROR 2009-06-11T16:24:35
> OpenILS::Application::AppUtils
> /openils/lib/perl5/OpenILS/Application/AppUtils.pm:178 System ERROR:
> Exception: OpenSRF::DomainObject::oilsMethodException
> 2009-06-11T16:24:35 OpenSRF::AppRequest
> /usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500>   *** Call
> to [open-ils.storage.actor.user.crazy_search] failed for session
> [1244751875.053172252.2513939484], thread trace [1]:
> DBD::Pg::db selectcol_arrayref failed: ERROR:  more than one row
> returned by a subquery used as an expression
> CONTEXT:  SQL function "org_unit_descendants" statement 1 [for Statement
> "              SELECT  DISTINCT LOWER(users.family_name),
> LOWER(users.first_given_name), LOWER(users.second_given_name),
> LOWER(users.dob), LOWER(users.id)
>                  FROM  actor.usr AS users
>                        JOIN (SELECT id as id FROM actor.usr u WHERE
> LOWER(email) ~ ?) AS search ON (search.id = users.id)
>                        JOIN actor.org_unit_descendants(4, 2) d ON (d.id
> = users.home_ou)
>
>                  WHERE users.deleted = FALSE
>                  ORDER BY LOWER(users.family_name) ASC,
> LOWER(users.first_given_name) ASC, LOWER(users.second_given_name) ASC,
> LOWER(users.dob) DESC, LOWER(users.id)
>                  LIMIT 51
> "] at /openils/lib/perl5/OpenILS/Application/Storage/Publisher/actor.pm
> line 572.
>
> Caught error from 'run' method: Exception: OpenSRF::EX::ERROR
> 2009-06-11T16:24:35 OpenSRF::Application
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm:200 System ERROR:
> Call to open-ils.storage for method
> open-ils.storage.actor.user.crazy_search
>  failed with exception: Exception: OpenSRF::EX::ERROR
> 2009-06-11T16:24:35 OpenILS::Application::AppUtils
> /openils/lib/perl5/OpenILS/Application/AppUtils.pm:179 System ERROR:
> Exception: OpenSRF::DomainObject::oilsMethodException
> 2009-06-11T16:24:35 OpenSRF::AppRequest
> /usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500>   *** Call
> to [open-ils.storage.actor.user.crazy_search] failed for session
> [1244751875.053172252.2513939484], thread trace [1]:
> DBD::Pg::db selectcol_arrayref failed: ERROR:  more than one row
> returned by a subquery used as an expression
> CONTEXT:  SQL function "org_unit_descendants" statement 1 [for Statement
> "              SELECT  DISTINCT LOWER(users.family_name),
> LOWER(users.first_given_name), LOWER(users.second_given_name),
> LOWER(users.dob), LOWER(users.id)
>                  FROM  actor.usr AS users
>                        JOIN (SELECT id as id FROM actor.usr u WHERE
> LOWER(email) ~ ?) AS search ON (search.id = users.id)
>                        JOIN actor.org_unit_descendants(4, 2) d ON (d.id
> = users.home_ou)
>
>                  WHERE users.deleted = FALSE
>                  ORDER BY LOWER(users.family_name) ASC,
> LOWER(users.first_given_name) ASC, LOWER(users.second_given_name) ASC,
> LOWER(users.dob) DESC, LOWER(users.id)
>                  LIMIT 51
> "] at /openils/lib/perl5/OpenILS/Application/Storage/Publisher/actor.pm
> line 572.
>
> ========================================
> So the questions are, why do I see these errors during an add?
>
> And 2) why does a simple lookup fail so badly....
>
> Phil Hunt
> Program Director, Information Technology
> NELINET, Inc.
>
> '   Direct Phone:  (508)597-1924
> '    1.508.460.7700 x1924
> 6     FAX (508)460-9455
> * hunt at NELINET.net
>
>
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com