-->
  • Recent Articles

    CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time

    Error:
    12/06/2016 08:23:29 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select  poller_output.output,  poller_output.time,
    UNIX_TIMESTAMP(poller_output.time) as unix_time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num
    from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)
    order by poller_output.local_data_id  LIMIT 10000"










    Solution:

    1. Check the MariaDB for poller_output table in cacti Database. The table was not there.
    MariaDB [cacti]> DESCRIBE poller_output;
    ERROR 1017 (HY000): Can't find file: 'poller_output' (errno: 2)


    2. Tried to Drop the table.
    MariaDB [cacti]> DROP TABLE poller_output;
    ERROR 1051 (42S02): Unknown table 'poller_output'

    3. Checked the cacti.sql file and Picked the Paramater for poller_output table.

    4. Created the The table.
    MariaDB [cacti]> CREATE TABLE poller_output (
        ->   local_data_id mediumint(8) unsigned NOT NULL default '0',
        ->   rrd_name varchar(19) NOT NULL default '',
        ->   time datetime NOT NULL default '0000-00-00 00:00:00',
        ->   output text NOT NULL,
        ->   PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
        -> ) ENGINE=MyISAM;
    Query OK, 0 rows affected (0.00 sec)

    5. Checked the  poller_time table as it was in Error string, though it was okay. So left it untouched.
    MariaDB [cacti]> DESCRIBE poller_time;
    +------------+-----------------------+------+-----+---------------------+----------------+
    | Field      | Type                  | Null | Key | Default             | Extra          |
    +------------+-----------------------+------+-----+---------------------+----------------+
    | id         | mediumint(8) unsigned | NO   | PRI | NULL                | auto_increment |
    | pid        | int(11) unsigned      | NO   |     | 0                   |                |
    | poller_id  | smallint(5) unsigned  | NO   |     | 0                   |                |
    | start_time | datetime              | NO   |     | 0000-00-00 00:00:00 |                |
    | end_time   | datetime              | NO   |     | 0000-00-00 00:00:00 |                |
    +------------+-----------------------+------+-----+---------------------+----------------+
    5 rows in set (0.00 sec)

    MariaDB [cacti]> exit
    Bye


    6. The Error Stopped Now. Cheers.

    No comments