{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-trafodion/issues/542","repository_url":"https://api.github.com/repos/apache/incubator-trafodion","labels_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/542/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/542/comments","events_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/542/events","html_url":"https://github.com/apache/incubator-trafodion/pull/542","id":159763673,"number":542,"title":"[TRAFODION-2046]change DTM's memoryUsageChore default settings to ena…","user":{"login":"traflm","id":12948514,"avatar_url":"https://avatars.githubusercontent.com/u/12948514?v=3","gravatar_id":"","url":"https://api.github.com/users/traflm","html_url":"https://github.com/traflm","followers_url":"https://api.github.com/users/traflm/followers","following_url":"https://api.github.com/users/traflm/following{/other_user}","gists_url":"https://api.github.com/users/traflm/gists{/gist_id}","starred_url":"https://api.github.com/users/traflm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/traflm/subscriptions","organizations_url":"https://api.github.com/users/traflm/orgs","repos_url":"https://api.github.com/users/traflm/repos","events_url":"https://api.github.com/users/traflm/events{/privacy}","received_events_url":"https://api.github.com/users/traflm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-06-11T08:49:23Z","updated_at":"2016-06-11T08:49:44Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/incubator-trafodion/pulls/542","html_url":"https://github.com/apache/incubator-trafodion/pull/542","diff_url":"https://github.com/apache/incubator-trafodion/pull/542.diff","patch_url":"https://github.com/apache/incubator-trafodion/pull/542.patch"},"body":"…ble memory threthold\r\n\r\nChange the default behavior of DTM to restrict the memory usage in Region Server to 90%, if above that threshold, stop all new transaction operations until memory released under the threshold."},"comment":{"url":"https://api.github.com/repos/apache/incubator-trafodion/issues/comments/225345221","html_url":"https://github.com/apache/incubator-trafodion/pull/542#issuecomment-225345221","issue_url":"https://api.github.com/repos/apache/incubator-trafodion/issues/542","id":225345221,"user":{"login":"traflm","id":12948514,"avatar_url":"https://avatars.githubusercontent.com/u/12948514?v=3","gravatar_id":"","url":"https://api.github.com/users/traflm","html_url":"https://github.com/traflm","followers_url":"https://api.github.com/users/traflm/followers","following_url":"https://api.github.com/users/traflm/following{/other_user}","gists_url":"https://api.github.com/users/traflm/gists{/gist_id}","starred_url":"https://api.github.com/users/traflm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/traflm/subscriptions","organizations_url":"https://api.github.com/users/traflm/orgs","repos_url":"https://api.github.com/users/traflm/repos","events_url":"https://api.github.com/users/traflm/events{/privacy}","received_events_url":"https://api.github.com/users/traflm/received_events","type":"User","site_admin":false},"created_at":"2016-06-11T08:49:44Z","updated_at":"2016-06-11T08:49:44Z","body":"Test steps:\r\n\r\nHere is the test case:\r\n\r\ncreate table testoom (uniq int not null,\r\n c100k char(200), c10K char(200) , c1K char(200), c100 char(200),\r\n c10 char(200), c1 int )\r\n STORE BY (uniq)\r\n  ATTRIBUTES ALIGNED FORMAT\r\n   ;\r\n\r\n  upsert using load into testoom select\r\n0 + (100000 * x100000) + (10000 * x10000) + (1000 * x1000) +\r\n (100 * x100) + (10 * x10) +( 1 * x1),\r\n'111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',\r\n'111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',\r\n'111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',\r\n'111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',\r\n'111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',\r\n0\r\nfrom (values(0)) t\r\ntranspose 0,1,2,3,4,5,6,7,8,9 as x100000\r\ntranspose 0,1,2,3,4,5,6,7,8,9 as x10000\r\ntranspose 0,1,2,3,4,5,6,7,8,9 as x1000\r\ntranspose 0,1,2,3,4,5,6,7,8,9 as x100\r\ntranspose 0,1,2,3,4,5,6,7,8,9 as x10\r\ntranspose 0,1,2,3,4,5,6,7,8,9 as x1;\r\n\r\nupdate testoom set c10 = '211111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111'  where c1 =0;\r\n\r\nbefore test, change hbase-env.sh, change the Heap size to 500M.\r\n\r\nWithout the change, update will hang forever, and HBase RS OOM killed.\r\nWith this change, update will fail with proper message.\r\n\t\r\n*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::insertRow returned error HBASE_ACCESS_ERROR(-706). Cause:\r\njava.io.IOException: org.apache.hadoop.hbase.client.transactional.MemoryUsageException: put memory usage exceeds 90 percent, trxId is 4\r\norg.apache.hadoop.hbase.client.transactional.TransactionalTable.put(TransactionalTable.java:353)\r\norg.apache.hadoop.hbase.client.transactional.RMInterface.put(RMInterface.java:313)\r\norg.trafodion.sql.HTableClient.putRow(HTableClient.java:1558)\r\norg.trafodion.sql.HBaseClient.insertRow(HBaseClient.java:1620)\r\n"}}
{"actor":{"display_login":"traflm"}}