Looks like that was actually the problem. Searched google and came across
the fix. Had to change the type of the messages column to mediumtext and
the pending jobs started finishing. Did this by:
alter table report_logs change column message message VARCHAR(65536);
Just in case someone runs into this issue. Thanks.
On Sunday, February 10, 2013 10:56:14 AM UTC-8, Jagga Soorma wrote:
>
> Thanks for pointing me to the log location. Looks like this might be the
> cause of the problem:
>
> --
> ..snip
> 2013-02-10T10:40:35-0800: [Worker(delayed_job.3 host:ssfpcond01
> pid:25048)] Report.create_from_yaml_file failed with
> ActiveRecord::StatementInvalid: *Mysql::Error: Data too long for column
> 'details' at row 1: INSERT INTO `delayed_job_failures` *(`summary`,
> `read`, `updated_at`, `backtrace`, `details`, `created_at`)
> VALUES('Importing report report-18121-1179.
> yaml', 0, '2013-02-10 18:40:35', '--- \n-
> /usr/share/puppet-dashboard/vendor/rails/activerecord/lib/active_record/connection_adapters/a
> ..snip..
> --
>
> I am managing my passwd & group file via puppet which at times have huge
> amount of changes especially in the group file. This could possibly be
> causing this error. Is there a way to increase the size of the details
> column to enable it to accept larger data?
>
> Has anyone seen this issue before?
>
> Thanks again for your help with this.
>
> On Friday, February 8, 2013 1:53:02 PM UTC-8, Jagga Soorma wrote:
>>
>> Hi Guys,
>>
>> I am a new puppet user and wanted some type of monitoring for puppet so
>> deployed puppet-dashboard. It has been working very well for a few days
>> not, but all of a sudden I start getting pending tasks and they never
>> finish even after restarting all processes. They keep accumulating and
>> never seem to finish even though the clients are running fine. I have the
>> puppet-dashboard running on a different server than my puppetmaster. Is
>> there any way to troubleshoot what seems to be stuck and how to I get it
>> going without having to destroy the dashboard mysql db and recreating it
>> again? That is the only way I have got it working again but that is not
>> the correct way of doing this :) Any help would be appreciated.
>>
>> Thanks!
>>
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to puppet-users+unsubscr...@googlegroups.com.
To post to this group, send email to puppet-users@googlegroups.com.
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
