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. Проблемы с сохранением истории полученных данных

Проблемы с сохранением истории полученных данных

Scheduled Pinned Locked Moved Support (Russian)
3 Posts 2 Posters 11.2k 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
    KArt
    wrote on last edited by
    #1

      Недавно мною было замечено, что при просмотре истории значений DCI параметров нету всех данных, полученных хотя бы за последнее время (за последний час-два, может доходить до 24 час). А есть ноды на которых очень нужны показания за последнее время или ночь каждую минуту для выяснения аварии.
      Я посмотрел логи netxms и там увидел вот такую ошибку:

    [22-Aug-2013 14:08:13.294] SQL query failed (Query = "INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists
    [22-Aug-2013 14:08:13.294] EVENT 52 (ID:7246156 F:0x0001 S:4 TAG:"") FROM netxms1.coreberg.com: Database query failed (Query: INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists)
    [22-Aug-2013 14:08:13.295] SQL query failed (Query = "INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): ERROR:  prepared statement "netxms_stmt_0x8b39a0" already exists
    [22-Aug-2013 14:08:13.295] EVENT 52 (ID:7246157 F:0x0001 S:4 TAG:"") FROM netxms1.coreberg.com: Database query failed (Query: INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: ERROR:  prepared statement "netxms_stmt_0x8b39a0" already exists)
    [22-Aug-2013 14:08:13.295] SQL query failed (Query = "INSERT INTO idata_294 (item_id,idata_timestamp,idata_value) VALUES (?,?,?)"): ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists
    [22-Aug-2013 14:08:13.295] EVENT 52 (ID:7246158 F:0x0001 S:4 TAG:"") FROM netxms1.coreberg.com: Database query failed (Query: INSERT INTO idata_294 (item_id,idata_timestamp,idata_value) VALUES (?,?,?); Error: ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists)
    

    В логах postgresql тоже самое:

    2013-08-22 02:08:12 EEST ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists
    2013-08-22 02:08:12 EEST STATEMENT:  INSERT INTO idata_294 (item_id,idata_timestamp,idata_value) VALUES ($1,$2,$3)
    2013-08-22 02:08:12 EEST ERROR:  prepared statement "netxms_stmt_0x8b39a0" already exists
    2013-08-22 02:08:12 EEST STATEMENT:  INSERT INTO idata_294 (item_id,idata_timestamp,idata_value) VALUES ($1,$2,$3)
    2013-08-22 02:08:12 EEST ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists
    2013-08-22 02:08:12 EEST STATEMENT:  INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES ($1,$2,$3)
    2013-08-22 02:08:12 EEST ERROR:  prepared statement "netxms_stmt_0x8b39a0" already exists
    2013-08-22 02:08:12 EEST STATEMENT:  INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES ($1,$2,$3)
    2013-08-22 02:08:12 EEST ERROR:  prepared statement "netxms_stmt_0xb44d20" already exists
    2013-08-22 02:08:12 EEST STATEMENT:  INSERT INTO idata_259 (item_id,idata_timestamp,idata_value) VALUES ($1,$2,$3)
    2013-08-22 02:08:12 EEST ERROR:  prepared statement "netxms_stmt_0x8b39a0" already exists
    

    Периодически ошибка пропадает, где то 2-3 раза в сутки, но потом снова одно и то же.
    С чем может быть связана ошибка и как ее можно решить?
    Стоит netxms-1.2.8, postgres-9.1, простая перезагрузка не помогла.

    Буду очень признателен за помощь.

    1 Reply Last reply
    0
    • K
      K
      KArt
      wrote on last edited by
      #2

      Так как не дождался ни от кого ответа. Переставил систему заново и все пошло нормально  🙂

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

        Я примерно представляю, в какой ситуации могла возникнуть такая ошибка, хотя повторить мне не удалось. На всякий случай изменил генерацию имен для prepared statements, в 1.2.9 это исправление войдет.

        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