Roxie deploy complete notification

Description

Is there any way to tell from ESP when Roxie has finished copying data and the query is safe to use? If not ESP, is there some other way short of looking at the roxie log for each node?

Conclusion

None
100% Done
Loading...

Activity

Show:

Anthony Fishbeck September 19, 2016 at 11:14 PM

There may already be an issue open to integrate "<control:numfilestoprocess/>" into EclWatch?

If so, you can close this one. If not, can you provide some service methods, and coordinate with Miguel to add this?

Stuart Ort May 9, 2016 at 6:21 PM

Currently eclwatch does not return the number of files that any roxie nodes need to copy. As long as "useRemoteResources" is set to true, roxie is safe to use (roxie will use the file remotely until it copies it local).

If you want to see how many files a node need to copy, do the following:
testsocket ip:9876 "<control:numfilestoprocess/>"
or
testsocket ip:9876 -lock "<control:numfiletorpocess/>" (will get the information for all nodes)

This will tell you how many files are in the queue on that node that roxie needs to try and copy.

If you want this information reported in eclwatch, that will be a new feature that can be looked into for 6.2 or later

Richard Chapman April 20, 2016 at 8:55 AM

please comment

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Components

Assignee

Reporter

Priority

Fix versions

Created March 10, 2016 at 2:37 PM
Updated September 29, 2016 at 6:40 AM
Resolved September 29, 2016 at 6:40 AM