{"id":1896,"date":"2012-12-13T14:41:44","date_gmt":"2012-12-13T19:41:44","guid":{"rendered":"http:\/\/hstore.cs.brown.edu\/?page_id=1896"},"modified":"2013-01-05T15:50:25","modified_gmt":"2013-01-05T20:50:25","slug":"executorstatus","status":"publish","type":"page","link":"https:\/\/hstore.cs.brown.edu\/documentation\/system-procedures\/executorstatus\/","title":{"rendered":"@ExecutorStatus"},"content":{"rendered":"<p id=\"top\" \/><div class=\"prevpage\"><B>\u00ab<\/B> <a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/system-procedures\/adhoc\/\" title=\"@AdHoc\">@AdHoc<\/a><\/div> <div class=\"nextpage\"><a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/system-procedures\/garbagecollection\/\" title=\"@GarbageCollection\">@GarbageCollection<\/a> <B>\u00bb<\/B><\/div><div style=\"clear:both;\"><\/div><\/p>\n<h2 class=\"sysproc\">@ExecutorStatus<\/h2>\n<p>Force the HStoreSiteStatus daemon to dump the status of a node to the target HStoreSite&#8217;s server log file.<br \/>\nThe amount of information that is dumped in the output can be controlled with the following HStoreConf parameters:<\/p>\n<ul>\n<li><a href=\"\/documentation\/configuration\/properties-file\/site#status_show_txn_info\" class=\"property\">site.status_show_txn_info<\/a> &#8211; Show transaction profiling information\n<li><a href=\"\/documentation\/configuration\/properties-file\/site#status_show_executor_info\" class=\"property\">site.status_show_executor_info<\/a> &#8211; Show PartitionExecutor profiling information\n<li><a href=\"\/documentation\/configuration\/properties-file\/site#status_show_thread_info\" class=\"property\">site.status_show_thread_info<\/a> &#8211; Show the current state of all threads in the JVM\n<li><a href=\"\/documentation\/configuration\/properties-file\/site#pool_profiling\" class=\"property\">site.pool_profiling<\/a> &#8211; Show the number of objects in the various object pools for the DBMS\n<\/ul>\n<h3 class=\"sysproc\">Input Parameters<\/h3>\n<table class=\"sysproc\">\n<tr>\n<th>Name<\/th>\n<th>Type<\/th>\n<th>Description<\/th>\n<\/tr>\n<tr>\n<td class=\"sysproc-name\">PARTITION<\/td>\n<td class=\"sysproc-type\">Integer<\/td>\n<td class=\"sysproc-desc\">The id of the partition for the node that you want to dump its current status.<\/td>\n<\/tr>\n<\/table>\n<h3 class=\"sysproc\">Return Values<\/h3>\n<p>A single-row, single-column VoltTable indicating that the status of the operation.<br \/>\n1 &#8211; The operation completed succesfully.<br \/>\n0 &#8211; The operation failed. Refer the site logs to determine why.<\/p>\n<h3 class=\"sysproc\">Java Example<\/h3>\n\n<div class=\"wp_syntax\"><table><tr><td class=\"code\"><pre class=\"java\" style=\"font-family:monospace;\">Client client <span style=\"color: #339933;\">=<\/span> ClientFactory.<span style=\"color: #006633;\">createClient<\/span><span style=\"color: #009900;\">&#40;<\/span><span style=\"color: #009900;\">&#41;<\/span><span style=\"color: #339933;\">;<\/span>\nclient <span style=\"color: #339933;\">=<\/span> client.<span style=\"color: #006633;\">createConnection<\/span><span style=\"color: #009900;\">&#40;<\/span>hostname, port<span style=\"color: #009900;\">&#41;<\/span><span style=\"color: #339933;\">;<\/span>\nClientResponse cresponse <span style=\"color: #339933;\">=<\/span> client.<span style=\"color: #006633;\">callProcedure<\/span><span style=\"color: #009900;\">&#40;<\/span><span style=\"color: #0000ff;\">&quot;@ExecutorStatus&quot;<\/span>, partitionId<span style=\"color: #009900;\">&#41;<\/span><span style=\"color: #339933;\">;<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n<h3 class=\"sysproc\">Command-Line Example<\/h3>\n\n<div class=\"wp_syntax\"><table><tr><td class=\"code\"><pre class=\"bash\" style=\"font-family:monospace;\">hstore<span style=\"color: #000000; font-weight: bold;\">&gt;<\/span> EXEC <span style=\"color: #000000; font-weight: bold;\">@<\/span>ExecutorStatus <span style=\"color: #000000;\">1<\/span><\/pre><\/td><\/tr><\/table><\/div>\n\n<p><div class=\"prevpage\"><B>\u00ab<\/B> <a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/system-procedures\/adhoc\/\" title=\"@AdHoc\">@AdHoc<\/a><\/div> <div class=\"nextpage\"><a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/system-procedures\/garbagecollection\/\" title=\"@GarbageCollection\">@GarbageCollection<\/a> <B>\u00bb<\/B><\/div><div style=\"clear:both;\"><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>@ExecutorStatus Force the HStoreSiteStatus daemon to dump the status of a node to the target HStoreSite&#8217;s server log file. The amount of information that is dumped in the output can be controlled with the following HStoreConf parameters: site.status_show_txn_info &#8211; Show transaction profiling information site.status_show_executor_info &#8211; Show PartitionExecutor profiling information site.status_show_thread_info &#8211; Show the current state [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":1891,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1896"}],"collection":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/comments?post=1896"}],"version-history":[{"count":8,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1896\/revisions"}],"predecessor-version":[{"id":2047,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1896\/revisions\/2047"}],"up":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1891"}],"wp:attachment":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/media?parent=1896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}