{"action":"created","issue":{"url":"https://api.github.com/repos/yogthos/migratus/issues/42","labels_url":"https://api.github.com/repos/yogthos/migratus/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/yogthos/migratus/issues/42/comments","events_url":"https://api.github.com/repos/yogthos/migratus/issues/42/events","html_url":"https://github.com/yogthos/migratus/issues/42","id":110124430,"number":42,"title":"Single-statement rollback migration failing with \"Too many update results were returned\"","user":{"login":"node13h","id":3377821,"avatar_url":"https://avatars.githubusercontent.com/u/3377821?v=3","gravatar_id":"","url":"https://api.github.com/users/node13h","html_url":"https://github.com/node13h","followers_url":"https://api.github.com/users/node13h/followers","following_url":"https://api.github.com/users/node13h/following{/other_user}","gists_url":"https://api.github.com/users/node13h/gists{/gist_id}","starred_url":"https://api.github.com/users/node13h/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/node13h/subscriptions","organizations_url":"https://api.github.com/users/node13h/orgs","repos_url":"https://api.github.com/users/node13h/repos","events_url":"https://api.github.com/users/node13h/events{/privacy}","received_events_url":"https://api.github.com/users/node13h/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-06T23:41:31Z","updated_at":"2015-10-07T00:08:20Z","closed_at":null,"body":"Down file contains single statement ```DROP TABLE users;```\r\nUsing org.postgresql/postgresql \"9.4-1203-jdbc41\"\r\n\r\nWhen I remove semicolon - rollback completes successfully.\r\n\r\n```\r\n02:26:51.002 [main] INFO  migratus.core - Starting migrations\r\n02:26:51.421 [main] INFO  migratus.core - Running down for [20151007011602]\r\n02:26:51.422 [main] INFO  migratus.core - Down 20151007011602-add-users-table\r\n02:26:51.436 [main] DEBUG migratus.database - found 1 down migrations\r\n02:26:52.470 [main] DEBUG migratus.database - found 1 down migrations\r\n02:26:55.204 [main] DEBUG migratus.database - found 1 down migrations\r\n02:26:55.212 [main] INFO  migratus.core - Ending migrations\r\nException in thread \"main\" org.postgresql.util.PSQLException: Too many update results were returned., compiling:(/tmp/form-init6425292863827031544.clj:1:73)\r\n\tat clojure.lang.Compiler.load(Compiler.java:7239)\r\n\tat clojure.lang.Compiler.loadFile(Compiler.java:7165)\r\n\tat clojure.main$load_script.invoke(main.clj:275)\r\n\tat clojure.main$init_opt.invoke(main.clj:280)\r\n\tat clojure.main$initialize.invoke(main.clj:308)\r\n\tat clojure.main$null_opt.invoke(main.clj:343)\r\n\tat clojure.main$main.doInvoke(main.clj:421)\r\n\tat clojure.lang.RestFn.invoke(RestFn.java:421)\r\n\tat clojure.lang.Var.invoke(Var.java:383)\r\n\tat clojure.lang.AFn.applyToHelper(AFn.java:156)\r\n\tat clojure.lang.Var.applyTo(Var.java:700)\r\n\tat clojure.main.main(main.java:37)\r\nCaused by: org.postgresql.util.PSQLException: Too many update results were returned.\r\n\tat org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleCommandStatus(AbstractJdbc2Statement.java:2688)\r\n\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)\r\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338)\r\n\tat org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2898)\r\n\tat clojure.java.jdbc$execute_batch.invoke(jdbc.clj:401)\r\n\tat clojure.java.jdbc$db_do_commands$fn__807.invoke(jdbc.clj:675)\r\n\tat clojure.java.jdbc$db_transaction_STAR_.doInvoke(jdbc.clj:584)\r\n\tat clojure.lang.RestFn.invoke(RestFn.java:425)\r\n\tat clojure.java.jdbc$db_do_commands.doInvoke(jdbc.clj:674)\r\n\tat clojure.lang.RestFn.applyTo(RestFn.java:142)\r\n\tat clojure.core$apply.invoke(core.clj:636)\r\n\tat clojure.java.jdbc$db_do_commands.doInvoke(jdbc.clj:668)\r\n\tat clojure.lang.RestFn.invoke(RestFn.java:425)\r\n\tat migratus.database$down_STAR_$fn__1276.invoke(database.clj:73)\r\n\tat clojure.java.jdbc$db_transaction_STAR_.doInvoke(jdbc.clj:584)\r\n\tat clojure.lang.RestFn.invoke(RestFn.java:425)\r\n\tat migratus.database$down_STAR_.invoke(database.clj:66)\r\n\tat clojure.lang.AFn.applyToHelper(AFn.java:165)\r\n\tat clojure.lang.AFn.applyTo(AFn.java:144)\r\n\tat clojure.core$apply.invoke(core.clj:630)\r\n\tat robert.bruce$try_try_again$fn__1018.invoke(bruce.clj:118)\r\n\tat robert.bruce$retry.invoke(bruce.clj:94)\r\n\tat robert.bruce$retry$fn__1011.invoke(bruce.clj:109)\r\n\tat clojure.core$trampoline.invoke(core.clj:6037)\r\n\tat clojure.core$trampoline.doInvoke(core.clj:6042)\r\n\tat clojure.lang.RestFn.invoke(RestFn.java:439)\r\n\tat robert.bruce$try_try_again.doInvoke(bruce.clj:118)\r\n\tat clojure.lang.RestFn.invoke(RestFn.java:512)\r\n\tat migratus.database.Migration.down(database.clj:156)\r\n\tat migratus.core$run_down.invoke(core.clj:87)\r\n\tat migratus.core$rollback_STAR_.invoke(core.clj:96)\r\n\tat migratus.core$run.invoke(core.clj:25)\r\n\tat migratus.core$rollback.invoke(core.clj:106)\r\n\tat user$eval1567.invoke(form-init6425292863827031544.clj:1)\r\n\tat clojure.lang.Compiler.eval(Compiler.java:6782)\r\n\tat clojure.lang.Compiler.eval(Compiler.java:6772)\r\n\tat clojure.lang.Compiler.load(Compiler.java:7227)\r\n\t... 11 more\r\nSubprocess failed\r\n```"},"comment":{"url":"https://api.github.com/repos/yogthos/migratus/issues/comments/146040340","html_url":"https://github.com/yogthos/migratus/issues/42#issuecomment-146040340","issue_url":"https://api.github.com/repos/yogthos/migratus/issues/42","id":146040340,"user":{"login":"node13h","id":3377821,"avatar_url":"https://avatars.githubusercontent.com/u/3377821?v=3","gravatar_id":"","url":"https://api.github.com/users/node13h","html_url":"https://github.com/node13h","followers_url":"https://api.github.com/users/node13h/followers","following_url":"https://api.github.com/users/node13h/following{/other_user}","gists_url":"https://api.github.com/users/node13h/gists{/gist_id}","starred_url":"https://api.github.com/users/node13h/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/node13h/subscriptions","organizations_url":"https://api.github.com/users/node13h/orgs","repos_url":"https://api.github.com/users/node13h/repos","events_url":"https://api.github.com/users/node13h/events{/privacy}","received_events_url":"https://api.github.com/users/node13h/received_events","type":"User","site_admin":false},"created_at":"2015-10-07T00:08:20Z","updated_at":"2015-10-07T00:08:20Z","body":"Thanks for the 76b71e102ecc2ebc7d2ba0ab6c09d3b1446c4fe4\r\nHope to see 0.8.7 at clojars soon :)"}}