Mailing List Archive: Too many category objects found

Too many category objects found

Nov 2, 2011, 10:22 AM

Post #1 of 6 (2572 views)

We just encountered this error on our bricolage 2.0 install when trying
to create any new story in one particular category. Anybody have a clue
for us?

Too many Bric::Biz::Category objects found.
View Error Details

Error Details (hide)

Fault Class
Bric::Util::Fault::Exception::DP
Description
Data Processing Exception
Timestamp
2011-11-02 11:09:17.000000
Package
Bric::Biz::Category
Filename
/usr/local/bricolage/lib/Bric/Biz/Category.pm
Line
270

Stack:

Trace begun at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 270
Bric::Biz::Category::lookup('Bric::Biz::Category',
'HASH(0x7fb458769d30)') called at
/usr/local/bricolage/lib/Bric/App/Callback/Profile/Story.pm line 432
Bric::App::Callback::Profile::Story::create('Bric::App::Callback::Profile::Story=HASH(0x7fb45874d210)')
called at /usr/share/perl5/Params/CallbackRequest.pm line 296
eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
Params::CallbackRequest::request('Params::CallbackRequest=HASH(0x7fb455325d58)',
'HASH(0x7fb4569789a8)', 'requester',
'MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)', 'apache_req',
'Apache2::Request=SCALAR(0x7fb458747a78)') called at
/usr/share/perl5/MasonX/Interp/WithCallbacks.pm line 119
MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)',
'comp', '/workflow/profile/story/new/1123', 'args',
'ARRAY(0x7fb458747e68)', 'ah',
'HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)', 'apache_req',
'Apache2::Request=SCALAR(0x7fb458747a78)') called at
/usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 868
eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm
line 867
HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
/usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 822
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
/usr/local/bricolage/lib/Bric/App/Handler.pm line 307
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called
at -e line 0
eval {...} at -e line 0

Thanks,

- cameron

--
- cameron miller
- Server Team Lead
- outhouse attendant, bricoleur
- http://staff.adams.edu/~cdmiller

Re: Too many category objects found [ In reply to ]

bret at pectopah

Nov 2, 2011, 10:27 AM

Post #2 of 6 (2476 views)

Permalink

Hi Cameron,

The Category->lookup() method only wants to find one category. In this
case, it looks like it found more than one.

In the database, is it possible that there's more than one active record
in the category record for the URI of the category in question?

Cheers,

Bret

On Wed, 2011-11-02 at 11:22 -0600, cdmiller wrote:
> We just encountered this error on our bricolage 2.0 install when trying
> to create any new story in one particular category. Anybody have a clue
> for us?
>
> Too many Bric::Biz::Category objects found.
> View Error Details
>
> Error Details (hide)
>
> Fault Class
> Bric::Util::Fault::Exception::DP
> Description
> Data Processing Exception
> Timestamp
> 2011-11-02 11:09:17.000000
> Package
> Bric::Biz::Category
> Filename
> /usr/local/bricolage/lib/Bric/Biz/Category.pm
> Line
> 270
>
> Stack:
>
> Trace begun at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 270
> Bric::Biz::Category::lookup('Bric::Biz::Category',
> 'HASH(0x7fb458769d30)') called at
> /usr/local/bricolage/lib/Bric/App/Callback/Profile/Story.pm line 432
> Bric::App::Callback::Profile::Story::create('Bric::App::Callback::Profile::Story=HASH(0x7fb45874d210)')
> called at /usr/share/perl5/Params/CallbackRequest.pm line 296
> eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
> Params::CallbackRequest::request('Params::CallbackRequest=HASH(0x7fb455325d58)',
> 'HASH(0x7fb4569789a8)', 'requester',
> 'MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)', 'apache_req',
> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
> /usr/share/perl5/MasonX/Interp/WithCallbacks.pm line 119
> MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)',
> 'comp', '/workflow/profile/story/new/1123', 'args',
> 'ARRAY(0x7fb458747e68)', 'ah',
> 'HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)', 'apache_req',
> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 868
> eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm
> line 867
> HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 822
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
> /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
> eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
> Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called
> at -e line 0
> eval {...} at -e line 0
>
> Thanks,
>
> - cameron
>

--
Bret Dawson
Producer
Pectopah Productions Inc.
(416) 895-7635
bret@pectopah.com
www.pectopah.com

Re: Too many category objects found [ In reply to ]

cdmiller at adams

Nov 2, 2011, 10:42 AM

Post #3 of 6 (2483 views)

Permalink

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hmm,

We do have an inactive category with the same uri, but with an Uppercase
starting letter... We have both /academics/art and /academics/Art, and
their names are art and Art. Is the lookup not case sensitive?

- - cameron

On 11/02/2011 11:27 AM, Bret Dawson wrote:
> Hi Cameron,
>
> The Category->lookup() method only wants to find one category. In this
> case, it looks like it found more than one.
>
> In the database, is it possible that there's more than one active record
> in the category record for the URI of the category in question?
>
> Cheers,
>
> Bret
>
>
> On Wed, 2011-11-02 at 11:22 -0600, cdmiller wrote:
>> We just encountered this error on our bricolage 2.0 install when trying
>> to create any new story in one particular category. Anybody have a clue
>> for us?
>>
>> Too many Bric::Biz::Category objects found.
>> View Error Details
>>
>> Error Details (hide)
>>
>> Fault Class
>> Bric::Util::Fault::Exception::DP
>> Description
>> Data Processing Exception
>> Timestamp
>> 2011-11-02 11:09:17.000000
>> Package
>> Bric::Biz::Category
>> Filename
>> /usr/local/bricolage/lib/Bric/Biz/Category.pm
>> Line
>> 270
>>
>> Stack:
>>
>> Trace begun at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 270
>> Bric::Biz::Category::lookup('Bric::Biz::Category',
>> 'HASH(0x7fb458769d30)') called at
>> /usr/local/bricolage/lib/Bric/App/Callback/Profile/Story.pm line 432
>> Bric::App::Callback::Profile::Story::create('Bric::App::Callback::Profile::Story=HASH(0x7fb45874d210)')
>> called at /usr/share/perl5/Params/CallbackRequest.pm line 296
>> eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
>> Params::CallbackRequest::request('Params::CallbackRequest=HASH(0x7fb455325d58)',
>> 'HASH(0x7fb4569789a8)', 'requester',
>> 'MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)', 'apache_req',
>> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
>> /usr/share/perl5/MasonX/Interp/WithCallbacks.pm line 119
>> MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)',
>> 'comp', '/workflow/profile/story/new/1123', 'args',
>> 'ARRAY(0x7fb458747e68)', 'ah',
>> 'HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)', 'apache_req',
>> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
>> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 868
>> eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm
>> line 867
>> HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
>> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
>> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 822
>> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
>> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
>> /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
>> eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
>> Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called
>> at -e line 0
>> eval {...} at -e line 0
>>
>> Thanks,
>>
>> - cameron
>>
>

- --
- - cameron miller
- - Server Team Lead
- - outhouse attendant, bricoleur
- - http://staff.adams.edu/~cdmiller
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAk6xgQEACgkQLX8ayQuUiKEcqgCfWWCz8DRO4vyw28NwBCnqcmlY
KTQAoM2dzmMbJJ27wAP5IzWgSM+7atwY
=BbAA
-----END PGP SIGNATURE-----

Re: Too many category objects found [ In reply to ]

bret at pectopah

Nov 2, 2011, 11:24 AM

Post #4 of 6 (2515 views)

Permalink

Hi Cameron,

It looks like it's not case sensitive. See the _do_list() method in
Bric::Biz::Category.pm.

So I guess that's a bug.

It kind of makes sense to me that lookup() would only return an active
category, though. Would that be a break from how things are done in
other lookup() methods?

Cheers,

Bret

On Wed, 2011-11-02 at 11:42 -0600, cdmiller wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hmm,
>
> We do have an inactive category with the same uri, but with an Uppercase
> starting letter... We have both /academics/art and /academics/Art, and
> their names are art and Art. Is the lookup not case sensitive?
>
> - - cameron
>
> On 11/02/2011 11:27 AM, Bret Dawson wrote:
> > Hi Cameron,
> >
> > The Category->lookup() method only wants to find one category. In this
> > case, it looks like it found more than one.
> >
> > In the database, is it possible that there's more than one active record
> > in the category record for the URI of the category in question?
> >
> > Cheers,
> >
> > Bret
> >
> >
> > On Wed, 2011-11-02 at 11:22 -0600, cdmiller wrote:
> >> We just encountered this error on our bricolage 2.0 install when trying
> >> to create any new story in one particular category. Anybody have a clue
> >> for us?
> >>
> >> Too many Bric::Biz::Category objects found.
> >> View Error Details
> >>
> >> Error Details (hide)
> >>
> >> Fault Class
> >> Bric::Util::Fault::Exception::DP
> >> Description
> >> Data Processing Exception
> >> Timestamp
> >> 2011-11-02 11:09:17.000000
> >> Package
> >> Bric::Biz::Category
> >> Filename
> >> /usr/local/bricolage/lib/Bric/Biz/Category.pm
> >> Line
> >> 270
> >>
> >> Stack:
> >>
> >> Trace begun at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 270
> >> Bric::Biz::Category::lookup('Bric::Biz::Category',
> >> 'HASH(0x7fb458769d30)') called at
> >> /usr/local/bricolage/lib/Bric/App/Callback/Profile/Story.pm line 432
> >> Bric::App::Callback::Profile::Story::create('Bric::App::Callback::Profile::Story=HASH(0x7fb45874d210)')
> >> called at /usr/share/perl5/Params/CallbackRequest.pm line 296
> >> eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
> >> Params::CallbackRequest::request('Params::CallbackRequest=HASH(0x7fb455325d58)',
> >> 'HASH(0x7fb4569789a8)', 'requester',
> >> 'MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)', 'apache_req',
> >> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
> >> /usr/share/perl5/MasonX/Interp/WithCallbacks.pm line 119
> >> MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)',
> >> 'comp', '/workflow/profile/story/new/1123', 'args',
> >> 'ARRAY(0x7fb458747e68)', 'ah',
> >> 'HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)', 'apache_req',
> >> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
> >> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 868
> >> eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm
> >> line 867
> >> HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
> >> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
> >> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 822
> >> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
> >> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
> >> /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
> >> eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
> >> Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called
> >> at -e line 0
> >> eval {...} at -e line 0
> >>
> >> Thanks,
> >>
> >> - cameron
> >>
> >
>
>
> - --
> - - cameron miller
> - - Server Team Lead
> - - outhouse attendant, bricoleur
> - - http://staff.adams.edu/~cdmiller
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
>
> iEYEARECAAYFAk6xgQEACgkQLX8ayQuUiKEcqgCfWWCz8DRO4vyw28NwBCnqcmlY
> KTQAoM2dzmMbJJ27wAP5IzWgSM+7atwY
> =BbAA
> -----END PGP SIGNATURE-----
>

--
Bret Dawson
Producer
Pectopah Productions Inc.
(416) 895-7635
bret@pectopah.com
www.pectopah.com

Re: Too many category objects found [ In reply to ]

cdmiller at adams

Nov 2, 2011, 3:43 PM

Post #5 of 6 (2485 views)

Permalink

For now I managed to ferret out the suspect inactive category entries
for the affected uri and things are working again. I'll look at the
code and set up a simple test case when I get the chance.

Thanks for the pointer to multiple categories being returned, it save me
plenty of time,

- cameron

On 11/02/2011 12:24 PM, Bret Dawson wrote:
> Hi Cameron,
>
> It looks like it's not case sensitive. See the _do_list() method in
> Bric::Biz::Category.pm.
>
> So I guess that's a bug.
>
> It kind of makes sense to me that lookup() would only return an active
> category, though. Would that be a break from how things are done in
> other lookup() methods?
>
> Cheers,
>
> Bret
>
>
> On Wed, 2011-11-02 at 11:42 -0600, cdmiller wrote:
> Hmm,
>
> We do have an inactive category with the same uri, but with an Uppercase
> starting letter... We have both /academics/art and /academics/Art, and
> their names are art and Art. Is the lookup not case sensitive?
>
> - cameron
>
> On 11/02/2011 11:27 AM, Bret Dawson wrote:
>>>> Hi Cameron,
>>>>
>>>> The Category->lookup() method only wants to find one category. In this
>>>> case, it looks like it found more than one.
>>>>
>>>> In the database, is it possible that there's more than one active record
>>>> in the category record for the URI of the category in question?
>>>>
>>>> Cheers,
>>>>
>>>> Bret
>>>>
>>>>
>>>> On Wed, 2011-11-02 at 11:22 -0600, cdmiller wrote:
>>>>> We just encountered this error on our bricolage 2.0 install when trying
>>>>> to create any new story in one particular category. Anybody have a clue
>>>>> for us?
>>>>>
>>>>> Too many Bric::Biz::Category objects found.
>>>>> View Error Details
>>>>>
>>>>> Error Details (hide)
>>>>>
>>>>> Fault Class
>>>>> Bric::Util::Fault::Exception::DP
>>>>> Description
>>>>> Data Processing Exception
>>>>> Timestamp
>>>>> 2011-11-02 11:09:17.000000
>>>>> Package
>>>>> Bric::Biz::Category
>>>>> Filename
>>>>> /usr/local/bricolage/lib/Bric/Biz/Category.pm
>>>>> Line
>>>>> 270
>>>>>
>>>>> Stack:
>>>>>
>>>>> Trace begun at /usr/local/bricolage/lib/Bric/Biz/Category.pm line 270
>>>>> Bric::Biz::Category::lookup('Bric::Biz::Category',
>>>>> 'HASH(0x7fb458769d30)') called at
>>>>> /usr/local/bricolage/lib/Bric/App/Callback/Profile/Story.pm line 432
>>>>> Bric::App::Callback::Profile::Story::create('Bric::App::Callback::Profile::Story=HASH(0x7fb45874d210)')
>>>>> called at /usr/share/perl5/Params/CallbackRequest.pm line 296
>>>>> eval {...} at /usr/share/perl5/Params/CallbackRequest.pm line 286
>>>>> Params::CallbackRequest::request('Params::CallbackRequest=HASH(0x7fb455325d58)',
>>>>> 'HASH(0x7fb4569789a8)', 'requester',
>>>>> 'MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)', 'apache_req',
>>>>> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
>>>>> /usr/share/perl5/MasonX/Interp/WithCallbacks.pm line 119
>>>>> MasonX::Interp::WithCallbacks::make_request('MasonX::Interp::WithCallbacks=HASH(0x7fb45868bf48)',
>>>>> 'comp', '/workflow/profile/story/new/1123', 'args',
>>>>> 'ARRAY(0x7fb458747e68)', 'ah',
>>>>> 'HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)', 'apache_req',
>>>>> 'Apache2::Request=SCALAR(0x7fb458747a78)') called at
>>>>> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 868
>>>>> eval {...} at /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm
>>>>> line 867
>>>>> HTML::Mason::ApacheHandler::prepare_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
>>>>> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
>>>>> /usr/local/share/perl/5.10.1/HTML/Mason/ApacheHandler.pm line 822
>>>>> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fb45867f700)',
>>>>> 'Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called at
>>>>> /usr/local/bricolage/lib/Bric/App/Handler.pm line 307
>>>>> eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 296
>>>>> Bric::App::Handler::handler('Apache2::RequestRec=SCALAR(0x7fb458739aa0)') called
>>>>> at -e line 0
>>>>> eval {...} at -e line 0
>>>>>
>>>>> Thanks,
>>>>>
>>>>> - cameron
>>>>>
>>>>
>
>
>>

--
- cameron miller
- Server Team Lead
- outhouse attendant, bricoleur
- http://staff.adams.edu/~cdmiller

Re: Too many category objects found [ In reply to ]

david at kineticode

Nov 3, 2011, 10:55 AM

Post #6 of 6 (2477 views)

Permalink

On Nov 2, 2011, at 3:43 PM, cdmiller wrote:

> For now I managed to ferret out the suspect inactive category entries
> for the affected uri and things are working again. I'll look at the
> code and set up a simple test case when I get the chance.

Much obliged.

David