{"action":"created","issue":{"url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/448","labels_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/448/labels{/name}","comments_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/448/comments","events_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/448/events","html_url":"https://github.com/jprante/elasticsearch-river-jdbc/issues/448","id":55458456,"number":448,"title":"Can't setup incremental updates for table","user":{"login":"aeryaguzov","id":410611,"avatar_url":"https://avatars.githubusercontent.com/u/410611?v=3","gravatar_id":"","url":"https://api.github.com/users/aeryaguzov","html_url":"https://github.com/aeryaguzov","followers_url":"https://api.github.com/users/aeryaguzov/followers","following_url":"https://api.github.com/users/aeryaguzov/following{/other_user}","gists_url":"https://api.github.com/users/aeryaguzov/gists{/gist_id}","starred_url":"https://api.github.com/users/aeryaguzov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aeryaguzov/subscriptions","organizations_url":"https://api.github.com/users/aeryaguzov/orgs","repos_url":"https://api.github.com/users/aeryaguzov/repos","events_url":"https://api.github.com/users/aeryaguzov/events{/privacy}","received_events_url":"https://api.github.com/users/aeryaguzov/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-26T08:49:49Z","updated_at":"2015-01-26T21:32:52Z","closed_at":null,"body":"I've installed jdbc as plugin(latest version 1.4.0.9) to index mysql table using readme.\r\n\r\n1. It seems that schedule parameter does not work as expected.\r\n\r\nOn first start river plugin execute query and index data as expected (I see record about this in elasticsearch log file). \r\n\r\nI've setup schedule : \"0 0-59 0-23 ? * *\", so I expect that every minute I should see new log about river execution, but nothing happened. I've also executed curl on _river/jdbc/{name}/_state and see that never happened (counter:1, and all dates are setup for first run).\r\n\r\nDoes schedule parameter works with jdbc installed as plugin and how I can test it?\r\n\r\n2. It seems that $river.state.last_active_begin does not work as expected\r\n\r\nI've tailed mysql query log and see that on every query execution this parameter equals current timestamp, so I have not get any records from table since last river run.\r\n\r\nIs there some parameter that actually is a last river run timestamp?"},"comment":{"url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/comments/71542724","html_url":"https://github.com/jprante/elasticsearch-river-jdbc/issues/448#issuecomment-71542724","issue_url":"https://api.github.com/repos/jprante/elasticsearch-river-jdbc/issues/448","id":71542724,"user":{"login":"sawickil","id":7403841,"avatar_url":"https://avatars.githubusercontent.com/u/7403841?v=3","gravatar_id":"","url":"https://api.github.com/users/sawickil","html_url":"https://github.com/sawickil","followers_url":"https://api.github.com/users/sawickil/followers","following_url":"https://api.github.com/users/sawickil/following{/other_user}","gists_url":"https://api.github.com/users/sawickil/gists{/gist_id}","starred_url":"https://api.github.com/users/sawickil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sawickil/subscriptions","organizations_url":"https://api.github.com/users/sawickil/orgs","repos_url":"https://api.github.com/users/sawickil/repos","events_url":"https://api.github.com/users/sawickil/events{/privacy}","received_events_url":"https://api.github.com/users/sawickil/received_events","type":"User","site_admin":false},"created_at":"2015-01-26T21:32:52Z","updated_at":"2015-01-26T21:32:52Z","body":"\"schedule\" : \"0 * * * * ?\"\r\n\r\nyep, I also noticed that $river.state.last_active_begin did not work as expected. There are some other issues reported about this."}}