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. Issue with Query

Issue with Query

Scheduled Pinned Locked Moved Support
4 Posts 2 Posters 19.4k 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.
  • F
    F
    FHSRZ
    wrote on last edited by
    #1

    Hello Community,

    i have an issue with a SQL Query. This is how the netxmsd Log looks like. If i have this Error Message NetXMS Service will stop.

    2018.02.17 05:48:12.995 *E* SQL query failed (Query = "INSERT INTO idata_1 (item_id,idata_timestamp,idata_value) VALUES (1,0,'\004\004')"): 42P01 FEHLER:  Relation idata_1 existiert nicht LINE 1: INSERT INTO idata_1 (item_id,idata_timestamp,idata_value) VA...

    Any help?

    Best Regards

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

      Hi,

      seems to be a bug in server. What version you are running and on what OS? Do you have crash dumps?

      Best regards,
      Victor

      1 Reply Last reply
      0
      • F
        F
        FHSRZ
        wrote on last edited by
        #3

        Hi,

        i run a Debian 9.3.0 (Stretch) with NetXMS 2.2.2
        No, i don't have Crash Dumps

        Best Regards

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

          Hi,

          on Debian core dump generation disabled by default. Please try to enable it and provide us with core file. There are also slight chance that this is known issue fixed in 2.2.3 or upcoming 2.2.4 (will be released within few days).

          Best regards,
          Victor

          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