Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support (Russian)
  3. Ошибки после обновления с 1.0.7 до 1.2.0

Ошибки после обновления с 1.0.7 до 1.2.0

Scheduled Pinned Locked Moved Support (Russian)
25 Posts 5 Posters 37.5k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K
    K
    kozlov_ao
    wrote on last edited by
    #3

    Подтверждаю, проблема с графиками присутствует.

    1 Reply Last reply
    0
    • B
      B
      blacat
      wrote on last edited by
      #4

      Аналогично на 1.2.0 часто ловлю "MySQL server has gone away"
      Мускуль тюнил по всякому. Не спасает.
      Решает только рестарт netxmsd.

      1 Reply Last reply
      0
      • V
        V
        Victor Kirhenshtein
        wrote on last edited by
        #5

        А в логах mysql'а можно что-то найти? NetXMS сервер использует пул соединений с сервером - может ли быть так, что на сервере стоит маленький idle time для соединений?

        1 Reply Last reply
        0
        • K
          K
          kozlov_ao
          wrote on last edited by
          #6

          Я не админ БД, поэтому крайне тупой вопрос:
          Где и как это посмотреть? mysql не ведет свой лог в текстовом виде...(хотя может это особенности настройки)...

          1 Reply Last reply
          0
          • A
            A
            Alex Kirhenshtein
            wrote on last edited by
            #7

            Путь к файлу лога можно посмотреть таким SQL запросом:

            mysql> show global variables like 'log_error';
            +---------------+--------------------------+
            | Variable_name | Value                    |
            +---------------+--------------------------+
            | log_error     | /var/log/mysql/error.log |
            +---------------+--------------------------+
            1 row in set (0.00 sec)
            

            Проверьте параметр log_warnings:

            mysql> show global variables like 'log_warnings';
            +---------------+-------+
            | Variable_name | Value |
            +---------------+-------+
            | log_warnings  | 1     |
            +---------------+-------+
            1 row in set (0.00 sec)
            

            Если значение меньше двух, то поменяйте:

            mysql> set global log_warnings = 2;
            Query OK, 0 rows affected (0.00 sec)
            

            После чего перезапустите netxmsd и повторите ошибку. Рестарт mysql не требуется.

            1 Reply Last reply
            0
            • B
              B
              blacat
              wrote on last edited by
              #8

              Виктор, я таймауты по всякому менял. и увеличивал сильно и сокращал.
              Результат тот же.
              В логах мускуля чисто, влогах netxmsd описанное выше.

              Сейчас попробую еще ворнингов в логе мускуля повключать...

              1 Reply Last reply
              0
              • K
                K
                kozlov_ao
                wrote on last edited by
                #9

                Сделал все, что писали раньше, но результата нет...
                в логах ошибок mysql-пусто, в логах NetXMS-ловим те-же ошибки.
                в логах запросов mysql вылазиет вот это:

                120531 16:43:11       4 Prepare     [1512] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Execute     [1512] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=122 AND idata_timestamp>=1338464782 AND idata_timestamp<=1338468382 ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Prepare     [1513] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Execute     [1513] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=123 AND idata_timestamp>=1338464782 AND idata_timestamp<=1338468382 ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Prepare     [1514] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Execute     [1514] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=197 AND idata_timestamp>=1338464782 AND idata_timestamp<=1338468382 ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Prepare     [1515] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000
                                      4 Execute     [1515] SELECT idata_timestamp,idata_value FROM idata_131 WHERE item_id=196 AND idata_timestamp>=1338464782 AND idata_timestamp<=1338468382 ORDER BY idata_timestamp DESC LIMIT 200000
                120531 16:43:14       3 Prepare     [64244] SELECT var_value FROM config WHERE var_name=?
                                      3 Execute     [64244] SELECT var_value FROM config WHERE var_name='CapabilityExpirationTime'
                
                1 Reply Last reply
                0
                • K
                  K
                  kozlov_ao
                  wrote on last edited by
                  #10

                  Никому не удалось побороть эту проблему?

                  1 Reply Last reply
                  0
                  • I
                    I
                    inspirit
                    wrote on last edited by
                    #11

                    Пока нет. Логи выглядят нормально. Данные в базу тоже пишутся нормально. Непонятно куда копать.

                    1 Reply Last reply
                    0
                    • V
                      V
                      Victor Kirhenshtein
                      wrote on last edited by
                      #12

                      Я внес некоторые изменения в MySQL драйвер. Посмотрим, поможет или нет. Сегодня вечером сделаю сборку.

                      1 Reply Last reply
                      0
                      • K
                        K
                        kozlov_ao
                        wrote on last edited by
                        #13

                        ок, ждем..

                        1 Reply Last reply
                        0
                        • B
                          B
                          blacat
                          wrote on last edited by
                          #14

                          MySQL наконец-то что-то сказал в логах на это:

                          120605  5:22:09 [Warning] Aborted connection 26096 to db: 'netxms' user: 'netxms' host: '127.0.0.1' (Got timeout reading communication packets)

                          1 Reply Last reply
                          0
                          • V
                            V
                            Victor Kirhenshtein
                            wrote on last edited by
                            #15

                            Сделал версию 1.2.1. Если я правильно определил в чем проблема, то должно заработать. 🙂

                            1 Reply Last reply
                            0
                            • I
                              I
                              inspirit
                              wrote on last edited by
                              #16

                              Не собирается.

                              Making all in lmsensors
                              make[5]: Entering directory `/root/netxms-1.2.1/src/agent/subagents/lmsensors'
                                CXX    main.lo
                              main.cpp: In function ‘bool getSensorValue(char*, char*, double*)’:
                              main.cpp:57: error: cannot convert ‘sensors_chip_name*’ to ‘int*’ for argument ‘1’ to ‘const sensors_chip_name* sensors_get_detected_chips(int*)’
                              main.cpp:58: error: expected initializer before ‘*’ token
                              main.cpp:61: error: ‘feature’ was not declared in this scope
                              main.cpp:61: error: ‘sensors_get_features’ was not declared in this scope
                              main.cpp:73: error: ‘sensors_subfeature_type’ was not declared in this scope
                              main.cpp:73: error: expected `;' before ‘types’
                              main.cpp:74: error: ‘types’ was not declared in this scope
                              main.cpp:74: error: ‘SENSORS_SUBFEATURE_UNKNOWN’ was not declared in this scope
                              main.cpp:76: error: ‘SENSORS_FEATURE_TEMP’ was not declared in this scope
                              main.cpp:77: error: ‘SENSORS_SUBFEATURE_TEMP_INPUT’ was not declared in this scope
                              main.cpp:79: error: ‘SENSORS_FEATURE_IN’ was not declared in this scope
                              main.cpp:80: error: ‘SENSORS_SUBFEATURE_IN_INPUT’ was not declared in this scope
                              main.cpp:82: error: ‘SENSORS_FEATURE_FAN’ was not declared in this scope
                              main.cpp:83: error: ‘SENSORS_SUBFEATURE_FAN_INPUT’ was not declared in this scope
                              main.cpp:85: error: ‘SENSORS_FEATURE_VID’ was not declared in this scope
                              main.cpp:86: error: ‘SENSORS_SUBFEATURE_VID’ was not declared in this scope
                              main.cpp:88: error: ‘SENSORS_FEATURE_POWER’ was not declared in this scope
                              main.cpp:94: error: ‘SENSORS_SUBFEATURE_POWER_INPUT’ was not declared in this scope
                              main.cpp:95: error: ‘SENSORS_SUBFEATURE_POWER_AVERAGE’ was not declared in this scope
                              main.cpp:97: error: ‘SENSORS_FEATURE_ENERGY’ was not declared in this scope
                              main.cpp:98: error: ‘SENSORS_SUBFEATURE_ENERGY_INPUT’ was not declared in this scope
                              main.cpp💯 error: ‘SENSORS_FEATURE_CURR’ was not declared in this scope
                              main.cpp:101: error: ‘SENSORS_SUBFEATURE_CURR_INPUT’ was not declared in this scope
                              main.cpp:105: error: expected initializer before ‘*’ token
                              main.cpp:106: error: ‘subFeature’ was not declared in this scope
                              main.cpp:107: error: ‘sensors_get_subfeature’ was not declared in this scope
                              main.cpp:109: error: ‘subFeature’ was not declared in this scope
                              main.cpp:111: error: ‘sensors_get_value’ was not declared in this scope
                              main.cpp:113: error: ‘SENSORS_FEATURE_TEMP’ was not declared in this scope
                              main.cpp:124: error: ‘sensors_free_chip_name’ was not declared in this scope
                              make[5]: *** [main.lo] Error 1
                              make[5]: Leaving directory `/root/netxms-1.2.1/src/agent/subagents/lmsensors'
                              make[4]: *** [all-recursive] Error 1
                              make[4]: Leaving directory `/root/netxms-1.2.1/src/agent/subagents'
                              make[3]: *** [all-recursive] Error 1
                              make[3]: Leaving directory `/root/netxms-1.2.1/src/agent'
                              make[2]: *** [all-recursive] Error 1
                              make[2]: Leaving directory `/root/netxms-1.2.1/src'
                              make[1]: *** [all-recursive] Error 1
                              make[1]: Leaving directory `/root/netxms-1.2.1'
                              make: *** [all] Error 2

                              Стоит Centos 5.2
                              lm_sensors-2.10.7-9.el5
                              lm_sensors-devel-2.10.7-9.el5

                              Это виртуалка, так что никаких сенсоров там нет 🙂
                              что делать?

                              1 Reply Last reply
                              0
                              • A
                                A
                                Alex Kirhenshtein
                                wrote on last edited by
                                #17

                                Код написан под lm_sensors-3, но вот configure не проверяет версию - только наличие.
                                Постараюсь сегодня починить.

                                1 Reply Last reply
                                0
                                • V
                                  V
                                  Victor Kirhenshtein
                                  wrote on last edited by
                                  #18

                                  Можно попробовать деинсталлировать lm_sensors или только lm_sensors-devel-2.10.7-9.el5, раз они все равно на виртуалке не нужны.

                                  1 Reply Last reply
                                  0
                                  • B
                                    B
                                    blacat
                                    wrote on last edited by
                                    #19

                                    Спасибо, Виктор.
                                    Обновляемся ))

                                    1 Reply Last reply
                                    0
                                    • K
                                      K
                                      kozlov_ao
                                      wrote on last edited by
                                      #20

                                      нее.. я до вечера подожду. 🙂 машина боевая.
                                      Сразу вопрос (сорри за офтоп). Под Unix появился lmsensors, а под винду ниче вразумительного не придумалии случаем? 🙂

                                      1 Reply Last reply
                                      0
                                      • I
                                        I
                                        inspirit
                                        wrote on last edited by
                                        #21

                                        Обновились. Пока живет. 🙂

                                        1 Reply Last reply
                                        0
                                        • I
                                          I
                                          inspirit
                                          wrote on last edited by
                                          #22

                                          Живет стабильно. Спасибо за оперативность 🙂

                                          1 Reply Last reply
                                          0

                                          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                                          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                                          With your input, this post could be even better 💗

                                          Register Login
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          Powered by NodeBB Contributors
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups