[icinga-users] idoutils: Column length too big for column 'long_output'

John.Greenhalgh at ses.com John.Greenhalgh at ses.com
Wed Aug 19 15:59:59 CEST 2009


When running the mysql.sql script I get an error.

Line 405 in mysql.sql is exceeding max column size 

I'm on mysql version 4.1.22 and the latest icinga from git

mysql> CREATE TABLE IF NOT EXISTS `icinga_eventhandlers` (
    ->   `eventhandler_id` int(11) NOT NULL auto_increment,
    ->   `instance_id` smallint(6) NOT NULL default '0',
    ->   `eventhandler_type` smallint(6) NOT NULL default '0',
    ->   `object_id` int(11) NOT NULL default '0',
    ->   `state` smallint(6) NOT NULL default '0',
    ->   `state_type` smallint(6) NOT NULL default '0',
    ->   `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
    ->   `start_time_usec` int(11) NOT NULL default '0',
    ->   `end_time` datetime NOT NULL default '0000-00-00 00:00:00',
    ->   `end_time_usec` int(11) NOT NULL default '0',
    ->   `command_object_id` int(11) NOT NULL default '0',
    ->   `command_args` varchar(255) character set latin1 NOT NULL default 
'',
    ->   `command_line` varchar(255) character set latin1 NOT NULL default 
'',
    ->   `timeout` smallint(6) NOT NULL default '0',
    ->   `early_timeout` smallint(6) NOT NULL default '0',
    ->   `execution_time` double NOT NULL default '0',
    ->   `return_code` smallint(6) NOT NULL default '0',
    ->   `output` varchar(255) character set latin1 NOT NULL default '',
    ->   `long_output` varchar(8192) NOT NULL default '',
    ->   PRIMARY KEY  (`eventhandler_id`),
    ->   UNIQUE KEY `instance_id` 
(`instance_id`,`object_id`,`start_time`,`start_time_usec`)
    -> ) ENGINE=MyISAM COMMENT='Historical host and service event 
handlers';
ERROR 1074 (42000): Column length too big for column 'long_output' (max = 
255); use BLOB or TEXT instead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20090819/4ec13213/attachment-0001.html>


More information about the icinga-users mailing list