Nagios Support Forum

--001636c5c24ad9fb9504752911c6
Content-Type: text/plain; charset=ISO-8859-1

Here is an actual query which is coming as empty. Please advise on this.
Thanks

INSERT INTO nagios_hostchecks SET instance_id='1', host_object_id='1501',
check_type='0', is_raw_check='0', current_check_attempt='1',
max_check_attempts='3', state='0', state_type='1',
start_time=FROM_UNIXTIME(1254718978), start_time_usec='231137',
end_time=FROM_UNIXTIME(0), end_time_usec='0', timeout='30',
early_timeout='0', execution_time='0.000000', latency='0.230000',
return_code='0', output='', perfdata='(null)', command_object_id='2',
command_args='', command_line='/usr/lib64/nagios/plugins/check_fping -H
xxxxx\.net\.xxxxxx -w 3000\.0,100% -c 3000\.0,100% -n 1' ON DUPLICATE KEY
UPDATE instance_id='1', host_object_id='1501', check_type='0',
is_raw_check='0', current_check_attempt='1', max_check_attempts='3',
state='0', state_type='1', start_time=FROM_UNIXTIME(1254718978),
start_time_usec='231137', end_time=FROM_UNIXTIME(0), end_time_usec='0',
timeout='30', early_timeout='0', execution_time='0.000000',
latency='0.230000', return_code='0', output='', perfdata='(null)' |
| 612 | root | localhost | nagios | Query | 0 | NULL | show full
processlist



On Mon, Oct 5, 2009 at 3:11 AM, shadih rahman wrote:

> I used alter table for all table mentioned in the patch.
>
> cat mysql-upgrade-1.4b8.sql
> ALTER TABLE `nagios_hostchecks` ADD COLUMN `long_output` varchar(8192) NOT
> NULL default '' AFTER `output`;
> ALTER TABLE `nagios_hoststatus` ADD COLUMN `long_output` varchar(8192) NOT
> NULL default '' AFTER `output`;
> ALTER TABLE `nagios_servicechecks` ADD COLUMN `long_output` varchar(8192)
> NOT NULL default '' AFTER `output`;
> ALTER TABLE `nagios_servicestatus` ADD COLUMN `long_output` varchar(8192)
> NOT NULL default '' AFTER `output`;
> ALTER TABLE `nagios_statehistory` ADD COLUMN `long_output` varchar(8192)
> NOT NULL default '' AFTER `output`;
>
> ALTER TABLE `nagios_eventhandlers` ADD COLUMN `long_output` varchar(8192)
> NOT NULL default '' AFTER `output`;
> ALTER TABLE `nagios_systemcommands` ADD COLUMN `long_output` varchar(8192)
> NOT NULL default '' AFTER `output`;
> ALTER TABLE `nagios_notifications` ADD COLUMN `long_output` varchar(8192)
> NOT NULL default '' AFTER `output`;
>
>
>
>
> mysql> desc nagios_hostchecks
> -> ;
>
> +-----------------------+---------------+------+-----+---------------------+----------------+
> | Field | Type | Null | Key | Default
> | Extra |
>
> +-----------------------+---------------+------+-----+---------------------+----------------+
> | hostcheck_id | int(11) | NO | PRI | NULL
> | auto_increment |
> | instance_id | smallint(6) | NO | MUL | 0
> | |
> | host_object_id | int(11) | NO | | 0
> | |
> | check_type | smallint(6) | NO | | 0
> | |
> | is_raw_check | smallint(6) | NO | | 0
> | |
> | current_check_attempt | smallint(6) | NO | | 0
> | |
> | max_check_attempts | smallint(6) | NO | | 0
> | |
> | state | smallint(6) | NO | | 0
> | |
> | state_type | smallint(6) | NO | | 0
> | |
> | start_time | datetime | NO | MUL | 0000-00-00 00:00:00
> | |
> | start_time_usec | int(11) | NO | | 0
> | |
> | end_time | datetime | NO | | 0000-00-00 00:00:00
> | |
> | end_time_usec | int(11) | NO | | 0
> | |
> | command_object_id | int(11) | NO | | 0
> | |
> | command_args | varchar(255) | NO | |
> | |
> | command_line | varchar(255) | NO | |
> | |
> | timeout | smallint(6) | NO | | 0
> | |
> | early_timeout | smallint(6) | NO | |

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]