Puppet users - Oct 2013 - Puppet dashboard stuck pending jobs - MySql Error: Incorrect string value

Hi have add issues with stuck pending jobs on my puppet dashboard.

Here is the error message from my delayed_job.log file in 
/usr/share/puppet-dashboard/log directory.

Report.create_from_yaml_file failed with ActiveRecord::StatementInvalid: 
Mysql::Error: Incorrect string value: ''\x96 $bas...'' for
column ''details''
at row 1: INSERT INTO `delayed_job_failures`

As anyone encountered this error before ?


-- 
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+unsubscribe@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.
For more options, visit https://groups.google.com/groups/opt_out.

I''ve seen similar errors, and I found it easier to simply delete the 
reports where this happened.. unfortunately puppet-dashboard is not 
entirely bugfree, and unmaintained.. :(

I''m hoping to replace puppet dashboard with 
https://github.com/nedap/puppetboard - but haven''t had time to work on
that
:)

-- 
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+unsubscribe@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.
For more options, visit https://groups.google.com/groups/opt_out.

I found the solution to my problem here:
http://projects.puppetlabs.com/issues/18411

ALTER TABLE delayed_job_failures MODIFY details BLOB;

that resolved the error for me.

On Friday, October 4, 2013 7:46:03 AM UTC-4, Julien Nephtali
wrote:
>
>
> Hi have add issues with stuck pending jobs on my puppet dashboard.
>
> Here is the error message from my delayed_job.log file in 
> /usr/share/puppet-dashboard/log directory.
>
> Report.create_from_yaml_file failed with ActiveRecord::StatementInvalid: 
> Mysql::Error: Incorrect string value: ''\x96 $bas...'' for
column ''details''
> at row 1: INSERT INTO `delayed_job_failures`
>
> As anyone encountered this error before ?
>
>
>
-- 
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+unsubscribe@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.
For more options, visit https://groups.google.com/groups/opt_out.