Skip to content

Instantly share code, notes, and snippets.

@phaus
Created July 9, 2012 20:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phaus/3078819 to your computer and use it in GitHub Desktop.
Save phaus/3078819 to your computer and use it in GitHub Desktop.
Deploying kickster to heroku still fails.
imotep:tmp philipp$ git clone https://github.com/jamesward/kickster.git
Cloning into 'kickster'...
remote: Counting objects: 499, done.
remote: Compressing objects: 100% (342/342), done.
remote: Total 499 (delta 199), reused 415 (delta 115)
Receiving objects: 100% (499/499), 532.20 KiB | 302 KiB/s, done.
Resolving deltas: 100% (199/199), done.
imotep:tmp philipp$ cd kickster/
imotep:kickster philipp$ heroku create -s cedar
Creating sharp-sky-4526... done, stack is cedar
http://sharp-sky-4526.herokuapp.com/ | git@heroku.com:sharp-sky-4526.git
Git remote heroku added
imotep:kickster philipp$ heroku addons:add heroku-postgresql:dev
Adding heroku-postgresql:dev to sharp-sky-4526... done, v2 (free)
Attached as HEROKU_POSTGRESQL_CYAN
Database has been created and is available
! WARNING: dev is in beta
! increased risk of data loss and downtime
! send feedback to dod-feedback@heroku.com
Use `heroku addons:docs heroku-postgresql:dev` to view documentation
imotep:kickster philipp$ heroku pg:info
=== HEROKU_POSTGRESQL_CYAN
Plan: Dev
Status: available
Connections: 1
PG Version: 9.1.3
Created: 2012-07-09 20:47 UTC
Data Size: 0 B
Tables: 0
Rows: 0
Fork/Follow: Unavailable
Conn Info: [Deprecated] Please use `heroku pg:credentials ` to view connection info
imotep:kickster philipp$ heroku pg:promote HEROKU_POSTGRESQL_CYAN
Promoting HEROKU_POSTGRESQL_CYAN to DATABASE_URL... done
imotep:kickster philipp$ git push heroku master
Counting objects: 499, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (258/258), done.
Writing objects: 100% (499/499), 532.20 KiB | 335 KiB/s, done.
Total 499 (delta 199), reused 499 (delta 199)
-----> Heroku receiving push
-----> Removing .DS_Store files
-----> Play! app detected
-----> Installing Play! 1.2.4.....
-----> done
-----> Installing ivysettings.xml..... done
-----> Building Play! application...
~ _ _
~ _ __ | | __ _ _ _| |
~ | '_ \| |/ _' | || |_|
~ | __/|_|\____|\__ (_)
~ |_| |__/
~
~ play! 1.2.4, http://www.playframework.org
~
1.2.4
Building Play! application at directory ./
Resolving dependencies: .play/play dependencies ./ --forProd --forceCopy --silent -Duser.home=/tmp/build_ufc3vhrsg408 2>&1
:: loading settings :: file = /tmp/build_ufc3vhrsg408/.ivy2/ivysettings.xml
~ Resolving dependencies using /tmp/build_ufc3vhrsg408/conf/dependencies.yml,
~
~ play->scaffold head (from playContributedModules)
~
~ Downloading required dependencies,
~
~ ~downloaded http://www.playframework.org/modules/scaffold-head.zip
~
~ Installing resolved dependencies,
~
~ modules/scaffold-head
~
~ Done!
~
Precompiling: .play/play precompile ./ --silent 2>&1
Listening for transport dt_socket at address: 8000
20:48:16,320 INFO ~ Starting /tmp/build_ufc3vhrsg408
20:48:16,325 INFO ~ Module scaffold is available (/tmp/build_ufc3vhrsg408/modules/scaffold-head)
20:48:16,930 INFO ~ Precompiling ...
20:48:23,153 INFO ~ Done.
-----> Discovering process types
Procfile declares types -> web
-----> Compiled slug size is 27.1MB
-----> Launching... done, v6
http://sharp-sky-4526.herokuapp.com deployed to Heroku
To git@heroku.com:sharp-sky-4526.git
* [new branch] master -> master
imotep:kickster philipp$ heroku open
Opening http://sharp-sky-4526.herokuapp.com
imotep:kickster philipp$ heroku logs --tail
2012-07-09T20:47:07+00:00 heroku[api]: Attach HEROKU_POSTGRESQL_CYAN resource by heroku-postgresql@addons.heroku.com
2012-07-09T20:47:07+00:00 heroku[api]: Release v2 created by heroku-postgresql@addons.heroku.com
2012-07-09T20:47:33+00:00 heroku[api]: Add DATABASE_URL config by philipp@haussleiter.de
2012-07-09T20:47:33+00:00 heroku[api]: Release v3 created by philipp@haussleiter.de
2012-07-09T20:48:09+00:00 heroku[slugc]: Slug compilation started
2012-07-09T20:48:32+00:00 heroku[api]: Add shared-database:5mb add-on by philipp@haussleiter.de
2012-07-09T20:48:32+00:00 heroku[api]: Release v4 created by philipp@haussleiter.de
2012-07-09T20:48:32+00:00 heroku[api]: Add PLAY_OPTS, PATH, JAVA_OPTS config by philipp@haussleiter.de
2012-07-09T20:48:32+00:00 heroku[api]: Release v5 created by philipp@haussleiter.de
2012-07-09T20:48:32+00:00 heroku[api]: Release v6 created by philipp@haussleiter.de
2012-07-09T20:48:32+00:00 heroku[api]: Deploy 23cb47a by philipp@haussleiter.de
2012-07-09T20:48:33+00:00 heroku[slugc]: Slug compilation finished
2012-07-09T20:48:36+00:00 heroku[web.1]: Starting process with command `play run --http.port=58903 --%prod -Dprecompiled=true`
2012-07-09T20:48:39+00:00 app[web.1]: 20:48:39,137 INFO ~ Starting /app
2012-07-09T20:48:39+00:00 app[web.1]: 20:48:39,140 INFO ~ Module scaffold is available (/app/modules/scaffold-head)
2012-07-09T20:48:39+00:00 app[web.1]: 20:48:39,367 INFO ~ Application is precompiled
2012-07-09T20:48:41+00:00 app[web.1]: 20:48:41,200 INFO ~ Connected to jdbc:postgresql://ec2-23-23-201-251.compute-1.amazonaws.com:5432/d9gg5725ag097b
2012-07-09T20:48:45+00:00 app[web.1]: 20:48:45,104 INFO ~ Application 'kickster' is now started !
2012-07-09T20:48:45+00:00 app[web.1]: 20:48:45,199 INFO ~ Listening for HTTP on port 58903 ...
2012-07-09T20:48:45+00:00 heroku[web.1]: State changed from starting to up
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/ dyno=web.1 queue=0 wait=0ms service=2551ms status=200 bytes=2862
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/img/favicon.png dyno=web.1 queue=0 wait=0ms service=89ms status=200 bytes=687
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/css/bootstrap-responsive.css dyno=web.1 queue=0 wait=0ms service=105ms status=200 bytes=14447
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/css/main.css dyno=web.1 queue=0 wait=0ms service=103ms status=200 bytes=1215
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/jquery-1.7.2.min.js dyno=web.1 queue=0 wait=0ms service=115ms status=200 bytes=94840
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/jquery-1.7.2.js dyno=web.1 queue=0 wait=0ms service=106ms status=200 bytes=252881
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/css/bootstrap.css dyno=web.1 queue=0 wait=0ms service=134ms status=200 bytes=99896
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/bootstrap.js dyno=web.1 queue=0 wait=0ms service=49ms status=200 bytes=50108
2012-07-09T20:48:51+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/bootstrap-dropdown.js dyno=web.1 queue=0 wait=0ms service=67ms status=404 bytes=352
2012-07-09T20:48:53+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/img/grass.png dyno=web.1 queue=0 wait=0ms service=75ms status=200 bytes=7431
2012-07-09T20:48:53+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/bootstrap-dropdown.js dyno=web.1 queue=0 wait=0ms service=6ms status=404 bytes=352
2012-07-09T20:48:58+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/players/index dyno=web.1 queue=0 wait=0ms service=54ms status=200 bytes=2972
2012-07-09T20:48:58+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/bootstrap-dropdown.js dyno=web.1 queue=0 wait=0ms service=7ms status=404 bytes=352
2012-07-09T20:49:00+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/players/create dyno=web.1 queue=0 wait=0ms service=137ms status=200 bytes=3545
2012-07-09T20:49:00+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/public/js/bootstrap-dropdown.js dyno=web.1 queue=0 wait=0ms service=6ms status=404 bytes=352
2012-07-09T20:49:05+00:00 app[web.1]: 20:49:05,987 ERROR ~ ERROR: operator does not exist: bigint = bytea
2012-07-09T20:49:05+00:00 app[web.1]: 20:49:05,987 WARN ~ SQL Error: 0, SQLState: 42883
2012-07-09T20:49:05+00:00 app[web.1]: Hint: No
operator matches the given name and argument type(s). You might need to add explicit type casts.
2012-07-09T20:49:05+00:00 app[web.1]: Position: 130
2012-07-09T20:49:06+00:00 heroku[router]: POST sharp-sky-4526.herokuapp.com/players/save dyno=web.1 queue=0 wait=0ms service=677ms status=500 bytes=417
2012-07-09T20:49:06+00:00 app[web.1]: 20:49:06,358 ERROR ~
2012-07-09T20:49:06+00:00 app[web.1]: @6b1khj13c
2012-07-09T20:49:06+00:00 app[web.1]:
2012-07-09T20:49:06+00:00 app[web.1]: Oops: UnexpectedException
2012-07-09T20:49:06+00:00 app[web.1]: An unexpected error occured caused by exception UnexpectedException: Unexpected Error
2012-07-09T20:49:06+00:00 app[web.1]:
2012-07-09T20:49:06+00:00 app[web.1]: Internal Server Error (500) for request POST /players/save
2012-07-09T20:49:06+00:00 app[web.1]:
2012-07-09T20:49:06+00:00 app[web.1]: play.exceptions.UnexpectedException: Unexpected Error
2012-07-09T20:49:06+00:00 app[web.1]: at play.plugins.PluginCollection.beforeActionInvocation(PluginCollection.java:594)
2012-07-09T20:49:06+00:00 app[web.1]: at play.mvc.ActionInvoker.invoke(ActionInvoker.java:134)
2012-07-09T20:49:06+00:00 app[web.1]: at play.data.validation.ValidationPlugin.beforeActionInvocation(ValidationPlugin.java:59)
2012-07-09T20:49:06+00:00 app[web.1]: at Invocation.HTTP Request(Play!)
2012-07-09T20:49:06+00:00 app[web.1]: Caused by: play.exceptions.UnexpectedException: Unexpected Error
2012-07-09T20:49:06
+00:00 app[web.1]: at play.data.binding.Binder.bind(Binder.java:111)
2012-07-09T20:49:06+00:00 app[web.1]: at play.plugins.PluginCollection.bind(PluginCollection.java:534)
2012-07-09T20:49:06+00:00 app[web.1]: at play.db.jpa.JPAPlugin.bind(JPAPlugin.java:84)
2012-07-09T20:49:06+00:00 app[web.1]: at play.mvc.ActionInvoker.getActionMethodArgs(ActionInvoker.java:642)
2012-07-09T20:49:06+00:00 app[web.1]: at play.data.validation.ValidationPlugin$Validator.validateAction(ValidationPlugin.java:96)
2012-07-09T20:49:06+00:00 app[web.1]: ... 3 more
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:307)
2012-07-09T20:49:06+00:00 app[web.1]: Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147)
2012-07-09T20:49:06+00:00 app[web.1]: at play.db.jpa.JPAPlugin.bind(JPAPlugin.java:79)
2012-07-09T20:49:06+00:00 app[web.1]: at play.data.validation.ValidationPlugin.beforeActionInvocation(ValidationPlugin.java:51)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214)
2012-07-09T20:49:06+00:00 app[web.1]: Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.doList(Loader.java:2536)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.list(Loader.java:2271)
2012-07-09T20:49:06+00:00 app[web.1]: ... 8 more
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
2012-07-09T20:49:06+00:00 app[web.1]: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
2012-07-09T20:49:06+00:00 app[web.1]: ... 9 more
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
2012-07-09T20:49:06+00:00 app[web.1]: Position: 130
2012-07-09T20:49:06+00:00 app[web.1]: at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
2012-07-09T20:49:06+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
2012-07-09T20:49:06+00:00 app[web.1]: Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = bytea
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:274)
2012-07-09T20:49:06+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
2012-07-09T20:49:06+00:00 app[web.1]: Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2012-07-09T20:49:06+00:00 app[web.1]: at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
2012-07-09T20:49:06+00:00 app[web.1]: ... 17 more
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.doQuery(Loader.java:802)
2012-07-09T20:49:06+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
2012-07-09T20:49:06+00:00 app[web.1]: at org.hibernate.loader.Loader.doList(Loader.java:2533)
2012-07-09T20:49:07+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/favicon.ico dyno=web.1 queue=0 wait=0ms service=107ms status=404 bytes=28
2012-07-09T20:49:07+00:00 heroku[router]: GET sharp-sky-4526.herokuapp.com/favicon.ico dyno=web.1 queue=0 wait=0ms service=19ms status=404 bytes=313
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment