{"action":"created","issue":{"url":"https://api.github.com/repos/azkaban/azkaban/issues/705","repository_url":"https://api.github.com/repos/azkaban/azkaban","labels_url":"https://api.github.com/repos/azkaban/azkaban/issues/705/labels{/name}","comments_url":"https://api.github.com/repos/azkaban/azkaban/issues/705/comments","events_url":"https://api.github.com/repos/azkaban/azkaban/issues/705/events","html_url":"https://github.com/azkaban/azkaban/issues/705","id":170787112,"number":705,"title":"Azkaban-3.1.0 web server running sql failed ","user":{"login":"mycFelix","id":4719414,"avatar_url":"https://avatars.githubusercontent.com/u/4719414?v=3","gravatar_id":"","url":"https://api.github.com/users/mycFelix","html_url":"https://github.com/mycFelix","followers_url":"https://api.github.com/users/mycFelix/followers","following_url":"https://api.github.com/users/mycFelix/following{/other_user}","gists_url":"https://api.github.com/users/mycFelix/gists{/gist_id}","starred_url":"https://api.github.com/users/mycFelix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mycFelix/subscriptions","organizations_url":"https://api.github.com/users/mycFelix/orgs","repos_url":"https://api.github.com/users/mycFelix/repos","events_url":"https://api.github.com/users/mycFelix/events{/privacy}","received_events_url":"https://api.github.com/users/mycFelix/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-08-12T02:23:17Z","updated_at":"2016-08-19T08:29:28Z","closed_at":"2016-08-17T21:42:44Z","body":"Hi~\r\n\r\nI tried to run azkaban-web-server-3.1.0 but failed in two server mode\r\n\r\nThe log's following:\r\n````\r\nSLF4J: Failed to load class \"org.slf4j.impl.StaticLoggerBinder\".\r\nSLF4J: Defaulting to no-operation (NOP) logger implementation\r\nSLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.\r\nException in thread \"main\" azkaban.executor.ExecutorManagerException: Error fetching active flows\r\n\tat azkaban.executor.JdbcExecutorLoader.fetchActiveFlows(JdbcExecutorLoader.java:216)\r\n\tat azkaban.executor.ExecutorManager.loadRunningFlows(ExecutorManager.java:431)\r\n\tat azkaban.executor.ExecutorManager.<init>(ExecutorManager.java:126)\r\n\tat azkaban.webapp.AzkabanWebServer.loadExecutorManager(AzkabanWebServer.java:261)\r\n\tat azkaban.webapp.AzkabanWebServer.<init>(AzkabanWebServer.java:197)\r\n\tat azkaban.webapp.AzkabanWebServer.main(AzkabanWebServer.java:739)\r\nCaused by: java.sql.SQLException: Unknown column 'ex.executor_id' in 'on clause' Query: SELECT ex.exec_id exec_id, ex.enc_type enc_type, ex.flow_data flow_data, et.host host, et.port port, ax.update_time axUpdateTime, et.id executorId, et.active executorStatus FROM execution_flows ex INNER JOIN  active_executing_flows ax ON ex.exec_id = ax.exec_id INNER JOIN  executors et ON ex.executor_id = et.id Parameters: []\r\n\tat org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)\r\n\tat org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:350)\r\n\tat org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:306)\r\n\tat azkaban.executor.JdbcExecutorLoader.fetchActiveFlows(JdbcExecutorLoader.java:212)\r\n\t... 5 more\r\n````\r\n\r\nThere might be running a wrong sql cause `ex.executor_id` doesn't exist in the table execution_flows,and it should be `ex.exec_id`?\r\n````\r\nmysql> desc execution_flows;\r\n+-------------+--------------+------+-----+---------+----------------+\r\n| Field       | Type         | Null | Key | Default | Extra          |\r\n+-------------+--------------+------+-----+---------+----------------+\r\n| exec_id     | int(11)      | NO   | PRI | NULL    | auto_increment |\r\n| project_id  | int(11)      | NO   | MUL | NULL    |                |\r\n| version     | int(11)      | NO   |     | NULL    |                |\r\n| flow_id     | varchar(128) | NO   |     | NULL    |                |\r\n| status      | tinyint(4)   | YES  |     | NULL    |                |\r\n| submit_user | varchar(64)  | YES  |     | NULL    |                |\r\n| submit_time | bigint(20)   | YES  |     | NULL    |                |\r\n| update_time | bigint(20)   | YES  |     | NULL    |                |\r\n| start_time  | bigint(20)   | YES  | MUL | NULL    |                |\r\n| end_time    | bigint(20)   | YES  | MUL | NULL    |                |\r\n| enc_type    | tinyint(4)   | YES  |     | NULL    |                |\r\n| flow_data   | longblob     | YES  |     | NULL    |                |\r\n+-------------+--------------+------+-----+---------+----------------+\r\n````"},"comment":{"url":"https://api.github.com/repos/azkaban/azkaban/issues/comments/240959545","html_url":"https://github.com/azkaban/azkaban/issues/705#issuecomment-240959545","issue_url":"https://api.github.com/repos/azkaban/azkaban/issues/705","id":240959545,"user":{"login":"mycFelix","id":4719414,"avatar_url":"https://avatars.githubusercontent.com/u/4719414?v=3","gravatar_id":"","url":"https://api.github.com/users/mycFelix","html_url":"https://github.com/mycFelix","followers_url":"https://api.github.com/users/mycFelix/followers","following_url":"https://api.github.com/users/mycFelix/following{/other_user}","gists_url":"https://api.github.com/users/mycFelix/gists{/gist_id}","starred_url":"https://api.github.com/users/mycFelix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mycFelix/subscriptions","organizations_url":"https://api.github.com/users/mycFelix/orgs","repos_url":"https://api.github.com/users/mycFelix/repos","events_url":"https://api.github.com/users/mycFelix/events{/privacy}","received_events_url":"https://api.github.com/users/mycFelix/received_events","type":"User","site_admin":false},"created_at":"2016-08-19T08:29:28Z","updated_at":"2016-08-19T08:29:28Z","body":"@fsi206914 - Thank you for your tips"}}
{"actor":{"display_login":"mycFelix"}}