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
  3. Database errors when DCI from templates deleted

Database errors when DCI from templates deleted

Scheduled Pinned Locked Moved Support
4 Posts 2 Posters 17.3k 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.
  • Dani@M3TU
    Dani@M3TU
    Dani@M3T
    wrote on last edited by
    #1

    When I delete DCIs from templates (not from nodes) I always get errors like this:

    Critical	SYS_DB_QUERY_FAILED	Database query failed (Query: DELETE FROM idata_1174 WHERE item_id=1354; Error: 42P01 ERROR:  relation "idata_1174" does not exist
    LINE 1: DELETE FROM idata_1174 WHERE item_id=1354
    Critical	SYS_DB_QUERY_FAILED	Database query failed (Query: DELETE FROM idata_384 WHERE item_id=526; Error: 42P01 ERROR:  relation "idata_384" does not exist
    LINE 1: DELETE FROM idata_384 WHERE item_id=526
    Critical	SYS_DB_QUERY_FAILED	Database query failed (Query: DELETE FROM idata_1139 WHERE item_id=825; Error: 42P01 ERROR:  relation "idata_1139" does not exist
    LINE 1: DELETE FROM idata_1139 WHERE item_id=825
    

    It's for older and for newly created DCIs in templates. NetXMS is V1.2.14.

    1 Reply Last reply
    0
    • Dani@M3TU
      Dani@M3TU
      Dani@M3T
      wrote on last edited by
      #2

      Has anybody an idea, it is a problem in our database or a known bug?

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

        Yes, it's known, low priority issue - it does not affect anything except scary record in log file (server tries to delete collected data for template itself - and fails, since idata_* tables are created only for nodes).

        1 Reply Last reply
        0
        • Dani@M3TU
          Dani@M3TU
          Dani@M3T
          wrote on last edited by
          #4

          Ok, everything clear. Thank's Alex

          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