Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - pzandvoort

Pages: [1] 2
1
General Support / Housekeeper / SQL Server Deadlock
« on: June 09, 2020, 05:07:00 pm »
Many nights at 2am, when the housekeeper runs, we get a few deadlocks on SQL Server.

SQL query failed (Query = "INSERT INTO idata_2301 (item_id,idata_timestamp,idata_value,raw_value) VALUES (1061,1591683195,'Ok','3')"): [Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

We also see some of the DELETE statements from the housekeeper failing for similar reasons: "SQL query failed (Query = "DELETE FROM idata_2637 WHERE (item_id=1817 AND idata_timestamp<1583907634) OR …" [Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction (Process ID 63) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

This doesn't happen every night, and the number of deadlocks isn't the same every time, but it's often enough that it's waking people up at 2am.

Anyone have any thoughts on where to go to troubleshoot?

netxms 3.3-323
SQL Server 2016 SP2 CU12 (13.0.5698.0)

Thanks!
Peter

2
General Support / ExternalParameters - Sequential?
« on: February 14, 2020, 12:01:33 am »
I can't find any documentation on it, but it looks like the agent polls ExternalParameters sequentially. Is this correct? If so, is there a way to run them simultaneously (say with some maximum degree of parallelism)?

I have a few external parameters that usually complete pretty quickly, but may sometimes take pretty long. It seems like they're pushing out some of the others....

3
General Support / Parameters in Event Monitor?
« on: August 31, 2018, 11:07:47 pm »
Maybe I'm just dense and not seeing it, but is there a way to display the event parameters in the Event Monitor? I guess the same question goes for a node's EventLog.
Many thanks,

Peter

4
General Support / Max Parameter Length?
« on: July 10, 2018, 09:09:55 pm »
I'm trying to use Service.Check(*) to check a URL. Unfortunately, the URL I need to check is really long and looks like this:

https://hostA.mydomain.com/file1.aspx?KaB6rTg6%2fcIKlmbmN%40ecOi%2fjkr%407oXTOfLonrtxEolozX7HjHuvdXzfSZLXGSyM%2fz%2f88GXwVAXPhKIP893OYWC1N4zkKcFEoGnXlORpSV0GyA%40ljEZT3xDK72S46Y6luNEnz0lBYEqb8bzPEJ%40V28pJbIRpMLDp3uKPUnqit19t%40I5uY%40bZtcGI7NXZ5O81c8HDPmmxYci%40xpL7oAqLR9A%3d%3d

The URL above doesn't work and results in a "Cannot get current parameter value: Requested data collection item is not supported by agent" error.
If I shorten the URL slightly, the error goes away and it actually makes the call (but then obviously I have the wrong URL!)

https://hostA.mydomain.com/file1.aspx?KaB6rTg6%2fcIKlmbmN%40ecOi%2fjkr%407oXTOfLonrtxEolozX7HjHuvdXzfSZLXGSyM%2fz%2f88GXwVAXPhKIP893OYWC1N4zkKcFEoGnXlORpSV0GyA%40ljEZT3xDK72S46Y6luNEnz0lBYEqb8bzPEJ%40V28pJbIRpMLDp3uKPUnqit19t%40I5uY%40bZtcG

... works. If I add one more character, it stops working.

Is there a length limit to what's passed to Service.Check? If so, what's the limit?
Thanks!

Peter


5
General Support / Parameters with quotes?
« on: March 23, 2018, 03:39:48 pm »
Trying to run WMI.Query(/root/somenamespace, SELECT * FROM class WHERE name="value", property)
WQL needs the quotes, but by the time the query executes the quotes have been stripped. The same issue exists when trying to pass something in quotes to a ExternalParameter, or any parameter for that matter.

Is there a way to use quotes in parameters?

Going through the code, it seems the quotes are being removed in AgentGetParameterArg....

6
General Support / Templates reset?
« on: October 30, 2017, 05:11:07 pm »
A few times I have made changes to the Windows template under \Templates\Operating Systems, only to find that it somehow automatically reverts overnight. Do the pre-built templates get recreated on a schedule somehow?

7
General Support / [Windows] Web Api install?
« on: September 06, 2017, 12:16:20 am »
I feel dumb for asking this, but going to ask anyway: Using a standard out-of-the-box netxms installation on Windows, how do you install the WebApi?

I understand that the WebUI runs on Jetty so there should already be a server. How do we add the web api to this so we have something to point Grafana to?

Many thanks!

8
Feature Requests / Dashboard Viewer?
« on: June 04, 2014, 05:34:49 pm »
I might have missed it, but I'm looking for a way to display dashboards not unlike the alarm viewer application.

Our current setup has 8 dedicated monitors that display various dashboards (they're just full screen web pages). Is there anyway I can display netxms dashboards this way?

9
General Support / Install Web Interface
« on: April 23, 2012, 07:04:03 am »
Windows 2008R2 (x64)

Although you can check the box in the installer (netxms-1.2.0-x64), it doesn't seem to install the webui. The separate webui install does create the WebUI folder and everything in it, but the service just hangs on "starting". The logs say that it can't find a jre, so I set JAVA_HOME to c:\netxms\bin\jre\bin and that makes it happier. However, it still won't start as "Local System", since it seems to search for temp folders. Manually running "java -war start.war" starts up the server properly in the console, but the gives the following error when you try to access the page:


Could not process server response:

Error: Operation "create" on target "w4" of type "null" failed:
No Adapter for type forms.widgets.Hyperlink
Properties:
parent = w12
style = NONE
bounds = 214,161,81,34
children =
tabIndex = 8

Uninstalled everything, reinstalled just the server. Installed tomcat 6 and deployed the nxmc war manually. Same error.

What am I missing???
Thanks!

Peter

10
Feature Requests / Maintenance Mode
« on: December 21, 2011, 07:14:55 am »
I've seen this topic come up a few times: Could you please make a way to 'put a node into maintenance mode'? Scheduled would be super-awesome, but I'll gladly take manual. I really don't want this thing to wake me up at 3 in the morning when somebody is doing maintenance :)

From browsing through the 1.1.7 source, it looks like you have quite a bit of it in place with the 'disabled' status for a node. Just suspend all polling while the node is in maintenance mode. No data collected. No events generated. Etc. Just a single event that the node has changed status (into maintenance mode) and one when it's come out of maintenance mode.

Please? Pretty please?

Peter

11
Feature Requests / Select polling IP address per DCI
« on: December 21, 2011, 06:54:15 am »
Not sure if this is already possible through some workaround or not. If it is, I can't figure out how :)

All my servers have some form of out-of-band management card or connection (Dell BMC, Dell DRAC, HP ILO, Generic IPMI, etc). This connection has a separate IP address that doesn't show up anywhere. I'd like to monitor some things from that connection and propagate it as part of the device status.

Optimally, I'd like to just add DCIs and select the IP address of the management card. Come to think of it, you'd need more than just the IP address: you'd need almost all the communication settings. Perhaps this is actually a device as a child of another device?

12
Feature Requests / Properties on containers?
« on: December 21, 2011, 06:47:45 am »
It might be very useful to be able to set properties on a container, and have those propagate hierarchically down the tree. I'm thinking of things like SNMP community strings, agent secrets, status calculation method, etc. Preferably with an option to override on a per sub-container or sub-node basis.

13
General Support / Cannot load MIB file from server - on console startup
« on: December 21, 2011, 06:23:36 am »
When starting up the java console (1.1.7) on a remote machine, an error occurs saying 'Load MIB file on startup' has encountered a problem. Cannot load MIB file from server: URI has an authority component.

This doesn't occur when you start the console on the server.

What gives?

14
General Support / Agent PDH.CounterValue
« on: December 18, 2010, 07:10:11 am »
Hello,
I'm trying to pull the total number of hits on a web site through an agent. I think I've tried just about every variation, but I just can't make it work! This seems so simple....

Shouldn't it just be:
1) Add a new DCI to my server
2) Pick "Agent" as the source
3) Select "PDH.CounterValue(*)" as the parameter
4) Enter "\Web Service(<instancename>)\Total Method Requests" as the parameter
???

I feel like I'm missing something really simple....
Help? Please?
Thanks!

Peter

15
General Support / Move node to cluster?
« on: October 12, 2010, 10:01:25 pm »
I've created two nodes and a cluster object. How do I move the nodes under the cluster? Or is the only option to recreate the nodes?

Pages: [1] 2