Hello Ramin, thanks for your answer.
I just wanted to say that varchar(65536) is mediumtext. As you can see in the table descriptions: mysql> describe report_logs; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | report_id | int(11) | NO | MUL | NULL | | | level | varchar(255) | YES | | NULL | | | message | mediumtext | YES | | NULL | | | source | text | YES | | NULL | | | tags | text | YES | | NULL | | | time | datetime | YES | | NULL | | | file | text | YES | | NULL | | | line | int(11) | YES | | NULL | | +-----------+--------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec) mysql> Also, thanks a lot for letting me know that BLOB and TEXT are 64kb while MEDIUMTEXT is 16MB. I did not have that in my mind. Cheers, X. On Wednesday, 9 July 2014 19:25:12 UTC+2, Ramin K wrote: > > It looks like you did this command 'alter table report_logs column > message mediumtext;' rather than varchar(65536). mediumtext is what it > should be changed to. Both BLOB and TEXT are 64kb while MEDIUMTEXT is > 16MB. > > Ramin > > On 7/9/2014 4:48 AM, Ximena Cardinali wrote: > > Hello, > > > > I had to apply also this other Solution: > > > > mysql> describe report_logs; > > +-----------+--------------+------+-----+---------+----------------+ > > | Field | Type | Null | Key | Default | Extra | > > +-----------+--------------+------+-----+---------+----------------+ > > | id | int(11) | NO | PRI | NULL | auto_increment | > > | report_id | int(11) | NO | MUL | NULL | | > > | level | varchar(255) | YES | | NULL | | > > | message | blob | YES | | NULL | | > > | source | text | YES | | NULL | | > > | tags | text | YES | | NULL | | > > | time | datetime | YES | | NULL | | > > | file | text | YES | | NULL | | > > | line | int(11) | YES | | NULL | | > > +-----------+--------------+------+-----+---------+----------------+ > > 9 rows in set (0.00 sec) > > > > mysql> ALTER TABLE report_logs MODIFY message VARCHAR(65536); > > Query OK, 46574 rows affected, 2 warnings (0.97 sec) > > Records: 46574 Duplicates: 0 Warnings: 2 > > > > mysql> describe report_logs; > > +-----------+--------------+------+-----+---------+----------------+ > > | Field | Type | Null | Key | Default | Extra | > > +-----------+--------------+------+-----+---------+----------------+ > > | id | int(11) | NO | PRI | NULL | auto_increment | > > | report_id | int(11) | NO | MUL | NULL | | > > | level | varchar(255) | YES | | NULL | | > > | message | mediumtext | YES | | NULL | | > > | source | text | YES | | NULL | | > > | tags | text | YES | | NULL | | > > | time | datetime | YES | | NULL | | > > | file | text | YES | | NULL | | > > | line | int(11) | YES | | NULL | | > > +-----------+--------------+------+-----+---------+----------------+ > > 9 rows in set (0.00 sec) > > > > mysql> > > > > For now, everything is working as expected. We will see in a few days, > > or after puppetdb Upgrade. > > > > X. > > > > On Monday, 16 June 2014 16:55:25 UTC+2, Ximena Cardinali wrote: > > > > Hello There, > > > > I've been struggling the last days with this issue. The situation is > > happening since I've upgrade Puppet to 3.6.0. > > > > _- Problem:_ > > On Puppet-Dashboard all Hosts are shown as *Unresponsive* and > > thousand of tasks are queued as *Failed*. > > > > _- Environment:_ > > OS: Debian Wheezy > > Puppet-Dashboard: 1.2.23 > > Puppet: 3.6.0 > > Facter: 2.0.1 > > Hiera: 1.3.2 > > > > _- Applied Solutions:_ > > > > * Solution 1: > > cd /usr/share/puppet-dashboard/ > > - Stop dashboard workers > > rm -v spool/* > > rake jobs:clear RAILS_ENV=production > > - Start dashboard workers. > > > > Good solution, but temporary, because the problem after a few days > > comes back. > > > > * Solution 2: > > I've also did the following update to the DB: > > mysql> ALTER TABLE delayed_job_failures MODIFY details BLOB; > > Which also did not work. > > > > Does anyone have any idea of what can be happening there? > > > > -- > > 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 [email protected] <javascript:> > > <mailto:[email protected] <javascript:>>. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/puppet-users/da0290f9-5120-4040-b1f4-227878317ebc%40googlegroups.com > > > < > https://groups.google.com/d/msgid/puppet-users/da0290f9-5120-4040-b1f4-227878317ebc%40googlegroups.com?utm_medium=email&utm_source=footer>. > > > > For more options, visit https://groups.google.com/d/optout. > > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/d113d823-00ab-498e-9698-a1a73601e79b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
