{"action":"created","issue":{"url":"https://api.github.com/repos/apache/spark/issues/9345","labels_url":"https://api.github.com/repos/apache/spark/issues/9345/labels{/name}","comments_url":"https://api.github.com/repos/apache/spark/issues/9345/comments","events_url":"https://api.github.com/repos/apache/spark/issues/9345/events","html_url":"https://github.com/apache/spark/pull/9345","id":113961196,"number":9345,"title":"[SPARK-10890][SQL] don't log expected JdbcSQLException during incompatible Insert test","user":{"login":"ckadner","id":12246093,"avatar_url":"https://avatars.githubusercontent.com/u/12246093?v=3","gravatar_id":"","url":"https://api.github.com/users/ckadner","html_url":"https://github.com/ckadner","followers_url":"https://api.github.com/users/ckadner/followers","following_url":"https://api.github.com/users/ckadner/following{/other_user}","gists_url":"https://api.github.com/users/ckadner/gists{/gist_id}","starred_url":"https://api.github.com/users/ckadner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ckadner/subscriptions","organizations_url":"https://api.github.com/users/ckadner/orgs","repos_url":"https://api.github.com/users/ckadner/repos","events_url":"https://api.github.com/users/ckadner/events{/privacy}","received_events_url":"https://api.github.com/users/ckadner/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-10-29T01:45:13Z","updated_at":"2015-10-30T00:27:22Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/apache/spark/pulls/9345","html_url":"https://github.com/apache/spark/pull/9345","diff_url":"https://github.com/apache/spark/pull/9345.diff","patch_url":"https://github.com/apache/spark/pull/9345.patch"},"body":"[SPARK-10890: \"Column count does not match; SQL statement:\" error in JDBCWriteSuite](https://issues.apache.org/jira/browse/SPARK-10890)\r\nThe `org.h2.jdbc.JdbcSQLException` is logged by `org.apache.spark.executor.Executor` and again by `org.apache.spark.scheduler.TaskSetManager`, so we would need to influence their log behavior / log levels. \r\nAbsent any properties or API to do that,  the easiest way to suppress the logging of the expected exception is to temporarily increase the log threshold to `FATAL` while the test case is executed and restore the original log level right after. This could be done globally `org.apache.log4j.RootLogger` or just for `org.apache.spark.executor.Executor` and `org.apache.spark.scheduler.TaskSetManager`\r\nI realize this is a _\"hack\"_ with the side effect of suppressing any other log message of less than FATAL severity during the test case execution. Discussion invited :-)"},"comment":{"url":"https://api.github.com/repos/apache/spark/issues/comments/152364190","html_url":"https://github.com/apache/spark/pull/9345#issuecomment-152364190","issue_url":"https://api.github.com/repos/apache/spark/issues/9345","id":152364190,"user":{"login":"AmplabJenkins","id":4031291,"avatar_url":"https://avatars.githubusercontent.com/u/4031291?v=3","gravatar_id":"","url":"https://api.github.com/users/AmplabJenkins","html_url":"https://github.com/AmplabJenkins","followers_url":"https://api.github.com/users/AmplabJenkins/followers","following_url":"https://api.github.com/users/AmplabJenkins/following{/other_user}","gists_url":"https://api.github.com/users/AmplabJenkins/gists{/gist_id}","starred_url":"https://api.github.com/users/AmplabJenkins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AmplabJenkins/subscriptions","organizations_url":"https://api.github.com/users/AmplabJenkins/orgs","repos_url":"https://api.github.com/users/AmplabJenkins/repos","events_url":"https://api.github.com/users/AmplabJenkins/events{/privacy}","received_events_url":"https://api.github.com/users/AmplabJenkins/received_events","type":"User","site_admin":false},"created_at":"2015-10-30T00:27:22Z","updated_at":"2015-10-30T00:27:22Z","body":"Merged build started."}}