Announcement

Collapse

New forum rules

The forum get new posts rules.

A new user will be moderate for new post. After five valid posts, the user will be to have right to post without moderation.

If you have some issue to post or to connect, contact us.
See more
See less

Broker: Default central poller doesn't update

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Broker: Default central poller doesn't update

    Hello,

    since last week, my default central poller doesn't update anymore.
    When I check my broker logs in detailled format, i got 2 error messages :

    ...
    [1542902036] info: SQL: processing log of poller '' generated at 1542887444 (type 5)
    [1542902036] error: could not prepare insertion query for event 'log_entry' in table 'log_logs': could not prepare query: Failed to read from the .par file QMYSQL3: Unable to prepare statement
    ...
    [1542902050] info: BBDO: received acknowledgement for 1000 events
    [1542902050] error: feeder: error occured while processing client 'central-broker-master-input-6': TCP peer '127.0.0.1:55352' is dis connected
    [1542902050] info: multiplexing: '/var/lib/centreon-broker//central-broker-master.queue.central-broker-master-input-6' removed
    ...

    Do you know what to do to correct this ?
    I upload entire logfile of the broker in attachment.

    Here, I paste some other technical information :

    [root@centreon-central ~]# uname -a
    Linux centreon-central 3.10.0-693.21.1.el7.x86_64 #1 SMP Wed Mar 7 19:03:37 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

    Based on CentOS Linux release 7.4.1708 (Core)
    Centreon 2.8.22
    Centreon Engine 1.8.1
    Centreon Broker: 3.0.14

    I remain at your disposal for any information needed.
    Thank you in advance.

    Regards,
    Nicolas.

  • #2
    Hello Nicolas,

    It seems that your table is corrupt ?
    Anyway, I don't have a log_logs table in 2.8 version of Centreon.
    Could you paste a "show create table log_logs;" please ?

    Are you able to do a desc on this table too ?

    Regards,
    IceCat

    Comment

    Working...
    X