Child pages
  • Troubleshooting opExport

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Run a pull or push of the data manually from the GUI (not a pull request, an actual pull) may give you info on any errors that are occurring.
  • Do the schemas match? You could try pushing the schemas to the server again and then run push/pull
  • If all this works successfully double check the logs on both the MySQL server (the omkd logs as well as the MySQL daemon logs)

Some Data Not Updating

The symptoms were seen that some data was not updating, e.g. data for a particular table was not updating, server1, nodeStatus.  The data is copied from the opExport slavespollers, to the opExport DB server and stored temporalily in the location /usr/local/omk/var/save_queue, before the file is loaded it is cached in the sub-directory /usr/local/omk/var/save_queue/data

You can check the receipts for the data in /usr/local/omk/var, then ls -1 *SERVERIP* you will see this.

Code Block
-rw------- 1 root 505 160533 Dec 19 17:53 receipt-SERVERIP_cbqosPerformance
-rw------- 1 root 505 111295 Dec 19 17:52 receipt-SERVERIP_ciscoConfig
-rw------- 1 root 505 111386 Dec 19 17:51 receipt-SERVERIP_diskIOTable
-rw------- 1 root 505 111292 Dec 19 17:55 receipt-SERVERIP_interface
-rw------- 1 root 505 171639 Dec 19 17:51 receipt-SERVERIP_interfacePerformance
-rw------- 1 root 505 111298 Dec 19 17:51 receipt-SERVERIP_interfaceStatus
-rw------- 1 root 505    300 Dec 19 17:53 receipt-SERVERIP_ipslaPerformance
-rw------- 1 root 505 111294 Dec 19 17:52 receipt-SERVERIP_nmisConfig
-rw------- 1 root 505 111298 Dec 19 17:52 receipt-SERVERIP_nodeProperties
-rw------- 1 root 505    205 Dec 19 17:52 receipt-SERVERIP_nodes
-rw------- 1 root 505 222386 Dec 19 17:54 receipt-SERVERIP_nodeStatus
-rw------- 1 root 505 111383 Dec 19 17:53 receipt-SERVERIP_services
-rw------- 1 root 505 111382 Dec 19 17:50 receipt-SERVERIP_storage
-rw------- 1 root 505 111290 Dec 19 17:52 receipt-SERVERIP_system
-rw------- 1 root 505 494335 Dec 19 17:53 receipt-SERVERIP_systemPerformance
-rw------- 1 root 505    298 Dec 19 17:52 receipt-SERVERIP_upsPerformance

If any of these dates is not current time (within last 5 minutes), then

Files were found in this folder which prevented opExport from streaming new data, moving the file, e.g. stream-nodeStatus-SERVERIP-localhost.data out of the way, means that opExport can get back to business.

It is likely these files are left behind when a process times-out or fails before the stream data has been processed.