budu / lobos

A library to create and manipulate SQL database schemas with migrations support.
http://budu.github.com/lobos/
267 stars 56 forks source link

Incomprehensible error on migrate #84

Open divs1210 opened 9 years ago

divs1210 commented 9 years ago

My projects.clj has these:

  [org.clojure/java.jdbc "0.3.3"]
  [org.postgresql/postgresql "9.2-1002-jdbc4"]
  [lobos "1.0.0-beta3"]

Getting this error every time I try to migrate:

org.postgresql.util.PSQLException: ERROR: syntax error at or near "T22"
  Position: 99
   QueryExecutorImpl.java:2157 org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
   QueryExecutorImpl.java:1886 org.postgresql.core.v3.QueryExecutorImpl.processResults
    QueryExecutorImpl.java:255 org.postgresql.core.v3.QueryExecutorImpl.execute
AbstractJdbc2Statement.java:555 org.postgresql.jdbc2.AbstractJdbc2Statement.execute
AbstractJdbc2Statement.java:403 org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
AbstractJdbc2Statement.java:395 org.postgresql.jdbc2.AbstractJdbc2Statement.execute
              (Unknown Source) sun.reflect.NativeMethodAccessorImpl.invoke0
NativeMethodAccessorImpl.java:57 sun.reflect.NativeMethodAccessorImpl.invoke
DelegatingMethodAccessorImpl.java:43 sun.reflect.DelegatingMethodAccessorImpl.invoke
               Method.java:606 java.lang.reflect.Method.invoke
             Reflector.java:93 clojure.lang.Reflector.invokeMatchingMethod
             Reflector.java:28 clojure.lang.Reflector.invokeInstanceMethod
               internal.clj:45 lobos.internal/execute*[fn]
               internal.clj:44 lobos.internal/execute*
               internal.clj:65 lobos.internal/execute[fn]
          connectivity.clj:154 lobos.connectivity/with-spec-connection
               internal.clj:58 lobos.internal/execute
               RestFn.java:423 clojure.lang.RestFn.invoke
                  core.clj:128 lobos.core/create*
               RestFn.java:423 clojure.lang.RestFn.invoke
             migrations.clj:21 db.migrations/reify
             migration.clj:257 lobos.migration/do-migrations
               RestFn.java:470 clojure.lang.RestFn.invoke
                  core.clj:200 lobos.core/migrate
               RestFn.java:397 clojure.lang.RestFn.invoke
                  AFn.java:152 clojure.lang.AFn.applyToHelper
               RestFn.java:132 clojure.lang.RestFn.applyTo
                  core.clj:624 clojure.core/apply
/home/redpanda/redpanda/smartcook-clj/src/db/migrations.clj:11 db.migrations/run-migrations
               RestFn.java:397 clojure.lang.RestFn.invoke
/home/redpanda/redpanda/smartcook-clj/src/db/migrations.clj:27 db.migrations/eval14257
            Compiler.java:6703 clojure.lang.Compiler.eval
            Compiler.java:6666 clojure.lang.Compiler.eval
                 core.clj:2927 clojure.core/eval
                   eval.clj:77 lighttable.nrepl.eval/->result
                  AFn.java:156 clojure.lang.AFn.applyToHelper
                  AFn.java:144 clojure.lang.AFn.applyTo
                  core.clj:626 clojure.core/apply
                 core.clj:2468 clojure.core/partial[fn]
               RestFn.java:408 clojure.lang.RestFn.invoke
                 core.clj:2559 clojure.core/map[fn]
               LazySeq.java:40 clojure.lang.LazySeq.sval
               LazySeq.java:49 clojure.lang.LazySeq.seq
                   RT.java:484 clojure.lang.RT.seq
                  core.clj:133 clojure.core/seq
                 core.clj:2595 clojure.core/filter[fn]
               LazySeq.java:40 clojure.lang.LazySeq.sval
               LazySeq.java:49 clojure.lang.LazySeq.seq
                   RT.java:484 clojure.lang.RT.seq
                  core.clj:133 clojure.core/seq
                 core.clj:2855 clojure.core/dorun
                 core.clj:2871 clojure.core/doall
                  eval.clj:126 lighttable.nrepl.eval/eval-clj
               RestFn.java:442 clojure.lang.RestFn.invoke
                  eval.clj:192 lighttable.nrepl.eval/eval2506[fn]
                  AFn.java:152 clojure.lang.AFn.applyToHelper
                  AFn.java:144 clojure.lang.AFn.applyTo
                  core.clj:624 clojure.core/apply
                 core.clj:1862 clojure.core/with-bindings*
               RestFn.java:425 clojure.lang.RestFn.invoke
                  eval.clj:177 lighttable.nrepl.eval/eval2506[fn]
                  eval.clj:176 lighttable.nrepl.eval/eval2506[fn]
              MultiFn.java:227 clojure.lang.MultiFn.invoke
                   core.clj:98 lighttable.nrepl.core/queued[fn]
                 core.clj:2402 clojure.core/comp[fn]
    interruptible_eval.clj:138 clojure.tools.nrepl.middleware.interruptible-eval/run-next[fn]
                   AFn.java:22 clojure.lang.AFn.run
  ThreadPoolExecutor.java:1145 java.util.concurrent.ThreadPoolExecutor.runWorker
   ThreadPoolExecutor.java:615 java.util.concurrent.ThreadPoolExecutor$Worker.run
               Thread.java:745 java.lang.Thread.run