[prev in list] [next in list] [prev in thread] [next in thread]
List: bricolage-bugs
Subject: [Bricolage-Bugs] [Bug 298] New: Timed content is not expiring or being published
From: bugzilla-daemon () thepirtgroup ! com
Date: 2003-01-25 17:50:42
[Download RAW message or body]
Summary: Timed content is not expiring or being published
Product: Bricolage
Version: 1.5.0 - Dev for 1.6.0
Platform: All
OS/Version: Linux
Status: NEW
Severity: critical
Priority: P2
Component: Unknown
AssignedTo: david@wheeler.net
ReportedBy: todd@lightship.tv
> I am using 1.5.0 on SGI's RedHat XFS port version 1.1 (kernel
> 2.4.18--build
> 17). I have the most current version of postgres installed (taken
> directly
> for postgres.org), apache 1.3.27, perl 5.8.0 and openssl 0.9.76g and
> the
> most current version of mod_ssl. I tried to get bricolage to run in
> debugging mode but only got this error:
>
> bric_apachectl debug: starting httpd -X
> [notice] Apache::DB initialized in child 28946
> Syntax error on line 82 of /usr/local/bricolage/conf/httpd.conf:
> No DB::DB routine defined at
> /usr/lib/perl5/site_perl/5.8.0/Bric/App/ApacheStartup.pm line 59.
> BEGIN failed--compilation aborted at
> /usr/lib/perl5/site_perl/5.8.0/Bric/App/ApacheStartup.pm line 59.
> Compilation failed in require at
> /usr/lib/perl5/site_perl/5.8.0/Bric/App/ApacheConfig.pm line 48.
> BEGIN failed--compilation aborted at
> /usr/lib/perl5/site_perl/5.8.0/Bric/App/ApacheConfig.pm line 48.
> Compilation failed in require at (eval 4) line 3.
>
> However, I have collected more information using the DBI_DEBUG and
> DBI_CALL_TRACE
>
> Here is the stack trace output that appeared from:
>
> sudo bric_dist_mon -U 'http://platoad:8090/' -u tatyree -p ******** -d
> -c
>
> ############# Prepare Query [2f6a 2a9e 6914 0185 8e12 bf65 a56e 8fc4]:
>
> SELECT u.id, u.login, u.password, u.active, p.prefix, p.fname,
> p.mname, p.lname, p.suffix, p.active
> FROM person p, usr u
> WHERE p.id = u.id AND u.active = 1 AND LOWER(u.login) LIKE ?
> ORDER BY p.lname, p.fname, p.mname
>
> #############
>
> ------------- Call Trace:
> Bric::Biz::Person::User (1412) =>
> Bric::Util::DBI::prepare_c()
> Bric::Biz::Person::User (289) =>
> Bric::Biz::Person::User::__ANON__()
> Bric::App::Auth (189) =>
> Bric::Biz::Person::User::lookup()
> main (137) => Bric::App::Auth::login()
> main (134) => (eval)()
> main (107) => main::send_jobs()
>
> +++++++++++++ Execute Query [2f6a 2a9e 6914 0185 8e12 bf65 a56e 8fc4]
> +++++++++++++ ARGS: tatyree
>
> ------------- Call Trace:
> Bric::Biz::Person::User (1422) => Bric::Util::DBI::execute()
> Bric::Biz::Person::User (289) =>
> Bric::Biz::Person::User::__ANON__()
> Bric::App::Auth (189) =>
> Bric::Biz::Person::User::lookup()
> main (137) => Bric::App::Auth::login()
> main (134) => (eval)()
> main (107) => main::send_jobs()
>
> ############# Prepare Query [23d4 08be debf 8d7b 719d 8c94 7f68 d72f]:
>
> SELECT id
> FROM job
> WHERE sched_time < ?
> AND comp_time IS NULL
> ORDER BY sched_time, id
>
> #############
>
> ------------- Call Trace:
> Bric::Dist::Job (1769) =>
> Bric::Util::DBI::prepare_ca()
> Bric::Dist::Job (464) =>
> Bric::Dist::Job::__ANON__()
> Bric::Dist::Client (254) =>
> Bric::Dist::Job::list_ids()
> main (142) =>
> Bric::Dist::Client::load_ids()
> main (134) => (eval)()
> main (107) => main::send_jobs()
>
> +++++++++++++ Execute Query [23d4 08be debf 8d7b 719d 8c94 7f68 d72f]:
> +++++++++++++ ARGS: 2003-01-23 19:49:53
>
>
> bric_dist_mon[29049]: Debug: Sending Job ID 1025 1026 for execution.
>
>
> And a trace of the same command from the main apache instance
> error_log:
>
>
> +----------------------############# Prepare Query [2f6a 2a9e 6914
> 0185 8e12
> bf65 a56e 8fc4]:
>
> SELECT u.id, u.login, u.password, u.active, p.prefix, p.fname,
> p.mname, p.lname, p.suffix, p.active
> FROM person p, usr u
> WHERE p.id = u.id AND u.active = 1 AND LOWER(u.login) LIKE ?
> ORDER BY p.lname, p.fname, p.mname
>
> #############
>
> ------------- Call Trace:
> Bric::Biz::Person::User (1412) =>
> Bric::Util::DBI::prepare_c()
> Bric::Biz::Person::User (289) =>
> Bric::Biz::Person::User::__ANON__()
> Bric::App::Auth (162) =>
> Bric::Biz::Person::User::lookup()
> Bric::App::AccessHandler (170) => Bric::App::Auth::auth()
> Bric::App::AccessHandler (132) => (eval)()
> main (0) =>
> Bric::App::AccessHandler::handler()
> main (0) => (eval)()
>
> +++++++++++++ Execute Query [2f6a 2a9e 6914 0185 8e12 bf65 a56e 8fc4]
> +++++++++++++ ARGS: tatyree
>
> ------------- Call Trace:
> Bric::Biz::Person::User (1422) => Bric::Util::DBI::execute()
> Bric::Biz::Person::User (289) =>
> Bric::Biz::Person::User::__ANON__()
> Bric::App::Auth (162) =>
> Bric::Biz::Person::User::lookup()
> Bric::App::AccessHandler (170) => Bric::App::Auth::auth()
> Bric::App::AccessHandler (132) => (eval)()
> main (0) =>
> Bric::App::AccessHandler::handler()
> main (0) => (eval)()
>
> ############# Prepare Query [5ae5 16be dff4 6fc7 15c8 75cd 7d05 523d]:
> SELECT
> id,key_name,pkg_name,disp_name,plural_name,description,distributor
> FROM class ORDER BY disp_name
> #############
>
> ------------- Call Trace:
> Bric::Util::Class (551) =>
> Bric::Util::DBI::prepare_c()
> Bric::Util::Class (258) =>
> Bric::Util::Class::_select_class()
> Bric::Util::Class (212) => Bric::Util::Class::list()
> Bric::App::Util (417) =>
> Bric::Util::Class::lookup()
> Bric::App::Util (411) =>
> Bric::App::Util::get_class_info()
> HTML::Mason::Commands (48) =>
> Bric::App::Util::get_package_name()
>
> +++++++++++++ Execute Query [5ae5 16be dff4 6fc7 15c8 75cd 7d05 523d]
> +++++++++++++ ARGS:
>
> ------------- Call Trace:
> Bric::Util::Class (552) => Bric::Util::DBI::execute()
> Bric::Util::Class (258) =>
> Bric::Util::Class::_select_class()
> Bric::Util::Class (212) => Bric::Util::Class::list()
> Bric::App::Util (417) =>
> Bric::Util::Class::lookup()
> Bric::App::Util (411) =>
> Bric::App::Util::get_class_info()
> HTML::Mason::Commands (48) =>
> Bric::App::Util::get_package_name()
>
> ############# Prepare Query [c759 51c7 fcab 2716 d28a 4c6a 4d88 d493]:
> SELECT DISTINCT s.id, s.priority, s.source__id, s.usr__id,
> s.element__id,
> s.publish_date, s.expire_date, s.cover_date, s.current_version,
> s.published_version, s.workflow__id, s.publish_status, s.primary_uri,
> s.active, i.id, i.name, i.description, i.story__id, i.version,
> i.usr__id,
> i.primary_oc__id, i.slug, i.checked_out FROM story s, story_instance i
> WHERE
> s.active=? AND s.usr__id=? AND i.checked_out=? AND
> s.current_version=i.version AND s.id=i.story__id ORDER BY s.cover_date
> #############
>
> ------------- Call Trace:
> Bric::Biz::Asset::Business::Story (1796) =>
> Bric::Util::DBI::prepare_ca()
> Bric::Biz::Asset::Business::Story (632) =>
> Bric::Biz::Asset::Business::Story::_do_list()
> HTML::Mason::Commands (64) =>
> Bric::Biz::Asset::Business::Story::list()
>
> +++++++++++++ Execute Query [c759 51c7 fcab 2716 d28a 4c6a 4d88 d493]
> +++++++++++++ ARGS: 1, 1024, 1
>
> ------------- Call Trace:
> Bric::Biz::Asset::Business::Story (1807) => Bric::Util::DBI::execute()
> Bric::Biz::Asset::Business::Story (632) =>
> Bric::Biz::Asset::Business::Story::_do_list()
> HTML::Mason::Commands (64) =>
> Bric::Biz::Asset::Business::Story::list()
>
> ############# Prepare Query [40ff dd29 aa19 95d9 8557 f2ee 21b9 5b47]:
> SELECT DISTINCT m.id, m.element__id, m.priority, m.source__id,
> m.current_version, m.published_version, m.usr__id, m.publish_date,
> m.expire_date, m.cover_date, m.workflow__id, m.publish_status,
> m.active,
> i.id, i.name, i.description, i.media__id, i.usr__id, i.version,
> i.media_type__id, i.primary_oc__id, i.category__id, i.file_size,
> i.file_name, i.location, i.uri, i.checked_out FROM media m,
> media_instance i
> WHERE m.active=? AND m.usr__id=? AND i.checked_out=? AND
> m.current_version=i.version AND m.id=i.media__id
> #############
>
> ------------- Call Trace:
> Bric::Biz::Asset::Business::Media (1475) =>
> Bric::Util::DBI::prepare_ca()
> Bric::Biz::Asset::Business::Media (469) =>
> Bric::Biz::Asset::Business::Media::_do_list()
> HTML::Mason::Commands (64) =>
> Bric::Biz::Asset::Business::Media::list()
>
> +++++++++++++ Execute Query [40ff dd29 aa19 95d9 8557 f2ee 21b9 5b47]
> +++++++++++++ ARGS: 1, 1024, 1
>
> ------------- Call Trace:
> Bric::Biz::Asset::Business::Media (1485) => Bric::Util::DBI::execute()
> Bric::Biz::Asset::Business::Media (469) =>
> Bric::Biz::Asset::Business::Media::_do_list()
> HTML::Mason::Commands (64) =>
> Bric::Biz::Asset::Business::Media::list()
>
> ############# Prepare Query [5763 54b0 620c 1d24 e612 75bc cc82 e785]:
> SELECT f.id,f.name ,f.priority ,f.description ,f.usr__id
> ,f.output_channel__id ,f.tplate_type ,f.element__id ,f.category__id
> ,f.file_name ,f.current_version ,f.deploy_status ,f.deploy_date
> ,f.expire_date ,f.workflow__id ,f.active ,i.id,i.formatting__id
> ,i.version
> ,i.usr__id ,i.data ,i.checked_out FROM formatting
> f,formatting_instance i
> WHERE f.id=i.formatting__id AND f.usr__id = ? AND i.checked_out = ? AND
> f.current_version=i.version AND f.active=? ORDER BY f.deploy_date
> #############
>
> ------------- Call Trace:
> Bric::Biz::Asset::Formatting (1799) =>
> Bric::Util::DBI::prepare_ca()
> Bric::Biz::Asset::Formatting (646) =>
> Bric::Biz::Asset::Formatting::_do_list()
> HTML::Mason::Commands (64) =>
> Bric::Biz::Asset::Formatting::list()
>
> +++++++++++++ Execute Query [5763 54b0 620c 1d24 e612 75bc cc82 e785]
> +++++++++++++ ARGS: 1024, 1, 1
>
> ------------- Call Trace:
> Bric::Biz::Asset::Formatting (1810) => Bric::Util::DBI::execute()
> Bric::Biz::Asset::Formatting (646) =>
> Bric::Biz::Asset::Formatting::_do_list()
> HTML::Mason::Commands (64) =>
> Bric::Biz::Asset::Formatting::list()
>
>
> ---------------------+
>
> I am installing everything on an old failover machine right now to see
> if it
> might work there. I'll let you know how it goes.
>
> Best,
> Todd
>
>
> ----- Original Message -----
> From: "David Wheeler" <david@wheeler.net>
> To: "Todd Tyree" <todd@lightship.tv>
> Sent: Thursday, January 23, 2003 5:31 PM
> Subject: Re: [Bricolage-General] Removal of content
>
>
>> On Thursday, January 23, 2003, at 12:37 AM, Todd Tyree wrote:
>>
>>> David,
>>>
>>> Tried that already. As bric_dist_mon is not yet fully documented, I
>>> have
>>> tried it against the admin interface port and the distribution port:
>>>
>>> Admin:
>>> $ sudo bric_dist_mon -c -U 'http://platoad:8090/' -u tatyree -p
>>> ******** -d
>>> bric_dist_mon[20288]: Debug: Checking for new jobs.
>>> bric_dist_mon[20288]: Debug: Sending Job ID 1026 1028 for execution.
>>
>> Hrm...so it's telling Bricolage to execute the jobs...
>>
>>> Nothing in the error log.
>>
>> Damn.
>>
>>> This is all it returns (checked /var/log/messages as well). Those
>>> two
>>> jobs
>>> are still showing in the queue. This is the message no matter how
>>> many
>>> times
>>> I run it. 'tatyree' has all administrative user permissions
>>> assigned.
>>
>> Sounds like a bug. Damn. What version are you running? I'll have to
>> play around with the distribution stuff to try to replicate this.
>> These
>> are expiration jobs? Do distribution jobs run properly and distribute
>> the files? What mover are you using? Do you have a "Move" action
>> associated with the destination?
http://bugzilla.bricolage.cc/show_bug.cgi?id=298
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
Bricolage-Bugs mailing list
Bricolage-Bugs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-bugs
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic