Error deploying play framework application on heroku

1.4k views Asked by At

I am trying to deploy my play framework app on heroku using commands from this link

every command works fine but on entering url of my heroku app on browser it gives error

An error occurred in the application and your page could not be served. Please try again in a few moments.If you are the application owner, check your logs for details.

and my logs

     $ heroku logs
←[36m2014-03-28T19:07:14.844022+00:00 app[web.1]:←[0m   at com.jolbox.bonecp.Bon
eCP.<init>(BoneCP.java:416)
←[36m2014-03-28T19:07:14.844084+00:00 app[web.1]:←[0m   at com.jolbox.bonecp.Bon
eCPDataSource.getConnection(BoneCPDataSource.java:120)
←[36m2014-03-28T19:07:14.844173+00:00 app[web.1]:←[0m   at play.api.db.BoneCPPlu
gin$$anonfun$onStart$1.apply(DB.scala:245)
←[36m2014-03-28T19:07:14.844274+00:00 app[web.1]:←[0m   ... 22 more
←[36m2014-03-28T19:07:14.843293+00:00 app[web.1]:←[0m   at org.sqlite.JDBC.conne
ct(JDBC.java:87)
←[36m2014-03-28T19:07:14.842752+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$.main(NettyServer.scala:274)
←[36m2014-03-28T19:07:14.843069+00:00 app[web.1]:←[0m Caused by: java.sql.SQLExc
eption: invalid database address: jdbc:postgresql://ec2-107-22-163-140.compute-1
.amazonaws.com:5432/d6s749rg71m651
←[36m2014-03-28T19:07:14.842849+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer.main(NettyServer.scala)
←[36m2014-03-28T19:07:14.842607+00:00 app[web.1]:←[0m   at scala.Option.map(Opti
on.scala:145)
←[36m2014-03-28T19:07:14.843293+00:00 app[web.1]:←[0m   at org.sqlite.JDBC.creat
eConnection(JDBC.java:110)
←[36m2014-03-28T19:07:14.843614+00:00 app[web.1]:←[0m   at java.sql.DriverManage
r.getConnection(DriverManager.java:620)
←[36m2014-03-28T19:07:14.843892+00:00 app[web.1]:←[0m   at com.jolbox.bonecp.Bon
eCP.obtainRawInternalConnection(BoneCP.java:363)
←[36m2014-03-28T19:07:14.843736+00:00 app[web.1]:←[0m   at java.sql.DriverManage
r.getConnection(DriverManager.java:200)
←[36m2014-03-28T19:07:16.130352+00:00 heroku[web.1]:←[0m Process exited with sta
tus 255
←[36m2014-03-28T19:07:16.141752+00:00 heroku[web.1]:←[0m State changed from star
ting to crashed
←[33m2014-03-28T19:07:44.845404+00:00 heroku[router]:←[0m at=error code=H10 desc
="App crashed" method=GET path=/ host=protected-anchorage-4936.herokuapp.com req
uest_id=7b22fdb3-3fc5-49ee-b1bb-cac8b2807bf2 fwd="14.96.131.39" dyno= connect= s
ervice= status=503 bytes=
←[32m2014-03-28T19:16:15+00:00 heroku[slug-compiler]:←[0m Slug compilation start
ed
←[32m2014-03-28T19:17:25+00:00 heroku[slug-compiler]:←[0m Slug compilation finis
hed
←[35m2014-03-28T19:17:25.404502+00:00 heroku[api]:←[0m Deploy eff2544 by singh_a
[email protected]
←[35m2014-03-28T19:17:25.404581+00:00 heroku[api]:←[0m Release v19 created by si
[email protected]
←[36m2014-03-28T19:17:25.898367+00:00 heroku[web.1]:←[0m State changed from cras
hed to starting
←[36m2014-03-28T19:17:32.749170+00:00 heroku[web.1]:←[0m Starting process with c
ommand `target/universal/stage/bin/shoplist  -Dhttp.port=${PORT} -DapplyEvolutio
ns.default=true -Ddb.default.driver=org.postgresql.Driver -Ddb.default.url=${DAT
ABASE_URL}`
←[36m2014-03-28T19:17:34.024991+00:00 app[web.1]:←[0m Picked up JAVA_TOOL_OPTION
S:  -Djava.rmi.server.useCodebaseOnly=true
←[36m2014-03-28T19:17:34.615701+00:00 app[web.1]:←[0m Play server process ID is
2
←[36m2014-03-28T19:17:35.776341+00:00 app[web.1]:←[0m DEBUG - JDBC URL = jdbc:po
stgresql://ec2-107-22-163-140.compute-1.amazonaws.com:5432/d6s749rg71m651, Usern
ame = wgvvlxnnjghjvl, partitions = 1, max (per partition) = 30, min (per partiti
on) = 5, idle max age = 10 min, idle test period = 1 min, strategy = DEFAULT
←[36m2014-03-28T19:17:36.042444+00:00 app[web.1]:←[0m INFO  - database [default]
 connected at jdbc:postgresql://ec2-107-22-163-140.compute-1.amazonaws.com:5432/
d6s749rg71m651
←[36m2014-03-28T19:17:36.623938+00:00 app[web.1]:←[0m DEBUG - select id, hash, a
pply_script, revert_script, state, last_problem from play_evolutions where state
 like 'applying_%'
←[36m2014-03-28T19:17:36.676247+00:00 app[web.1]:←[0m @6hl3hpiok: Database 'defa
ult' is in an inconsistent state!
←[36m2014-03-28T19:17:36.676489+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$.checkEvolutionsState(Evolutions.scala:193)
←[36m2014-03-28T19:17:36.673218+00:00 app[web.1]:←[0m ERROR - ERROR: syntax erro
r at or near "auto_increment"
←[36m2014-03-28T19:17:36.673218+00:00 app[web.1]:←[0m   Position: 57 [ERROR:0, S
QLSTATE:42601]
←[36m2014-03-28T19:17:36.676578+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$$anonfun$evolutionScript$2.apply(Evolutions.scala:311)
←[36m2014-03-28T19:17:36.676489+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$.databaseEvolutions(Evolutions.scala:348)
←[36m2014-03-28T19:17:36.676489+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$$anonfun$evolutionScript$2.apply(Evolutions.scala:313)
←[36m2014-03-28T19:17:36.676578+00:00 app[web.1]:←[0m   at scala.Option.map(Opti
on.scala:145)
←[36m2014-03-28T19:17:36.676170+00:00 app[web.1]:←[0m Oops, cannot start the ser
ver.
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$.evolutionScript(Evolutions.scala:311)
←[36m2014-03-28T19:17:36.677033+00:00 app[web.1]:←[0m   at play.api.Play$.start(
Play.scala:87)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.db.evolution

s.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:459)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at scala.collection.immu
table.List.foreach(List.scala:318)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin$$anonfun$onStart$1$$anonfun$apply$1.apply$mcV$sp(Evolutions.s
cala:462)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin.onStart(Evolutions.scala:459)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin.withLock(Evolutions.scala:507)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:461)
←[36m2014-03-28T19:17:36.677033+00:00 app[web.1]:←[0m   at play.core.StaticAppli
cation.<init>(ApplicationProvider.scala:52)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:36.677033+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1.apply$mcV$sp(Play.scala:88)
←[36m2014-03-28T19:17:36.677033+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:36.677301+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$.main(NettyServer.scala:274)
←[36m2014-03-28T19:17:36.677301+00:00 app[web.1]:←[0m   at play.core.ser
ver.NettyServer.main(NettyServer.scala)
←[36m2014-03-28T19:17:36.677301+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$$anonfun$main$3.apply(NettyServer.scala:279)
←[36m2014-03-28T19:17:36.677301+00:00 app[web.1]:←[0m   at scala.Option.map(Opti
on.scala:145)
←[36m2014-03-28T19:17:36.676791+00:00 app[web.1]:←[0m   at scala.collection.immu
table.List.foreach(List.scala:318)
←[36m2014-03-28T19:17:36.677301+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$$anonfun$main$3.apply(NettyServer.scala:274)
←[36m2014-03-28T19:17:36.677033+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:36.677033+00:00 app[web.1]:←[0m   at play.utils.Threads$.w
ithContextClassLoader(Threads.scala:18)
←[36m2014-03-28T19:17:36.677301+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$.createServer(NettyServer.scala:243)
←[36m2014-03-28T19:17:37.812494+00:00 heroku[web.1]:←[0m Process exited with sta
tus 255
←[36m2014-03-28T19:17:37.819425+00:00 heroku[web.1]:←[0m State changed from star
ting to crashed
←[36m2014-03-28T19:17:37.819966+00:00 heroku[web.1]:←[0m State changed from cras
hed to starting
←[36m2014-03-28T19:17:44.692801+00:00 heroku[web.1]:←[0m Starting process with c
ommand `target/universal/stage/bin/shoplist  -Dhttp.port=${PORT} -DapplyEvolutio
ns.default=true -Ddb.default.driver=org.postgresql.Driver -Ddb.default.url=${DAT
ABASE_URL}`
←[36m2014-03-28T19:17:45.897215+00:00 app[web.1]:←[0m Picked up JAVA_TOOL_OPTION
S:  -Djava.rmi.server.useCodebaseOnly=true
←[36m2014-03-28T19:17:46.781826+00:00 app[web.1]:←[0m Play server process ID is
2
←[36m2014-03-28T19:17:48.011081+00:00 app[web.1]:←[0m DEBUG - JDBC URL = jdbc:po
stgresql://ec2-107-22-163-140.compute-1.amazonaws.com:5432/d6s749rg71m651, Usern
ame = wgvvlxnnjghjvl, partitions = 1, max (per partition) = 30, min (per partiti
on) = 5, idle max age = 10 min, idle test period = 1 min, strategy = DEFAULT
←[36m2014-03-28T19:17:48.413328+00:00 app[web.1]:←[0m INFO  - database [default]
 connected at jdbc:postgresql://ec2-107-22-163-140.compute-1.amazonaws.com:5432/
d6s749rg71m651
←[36m2014-03-28T19:17:49.031934+00:00 app[web.1]:←[0m   Position: 57 [ERROR:0, S
QLSTATE:42601]
←[36m2014-03-28T19:17:49.035408+00:00 app[web.1]:←[0m @6hl3i0b63: Database 'defa
ult' is in an inconsistent state!
←[36m2014-03-28T19:17:49.014161+00:00 app[web.1]:←[0m DEBUG - select id, hash, a
pply_script, revert_script, state, last_problem from play_evolutions where state
 like 'applying_%'
←[36m2014-03-28T19:17:49.031934+00:00 app[web.1]:←[0m ERROR - ERROR: syntax erro
r at or near "auto_increment"
←[36m2014-03-28T19:17:49.035408+00:00 app[web.1]:←[0m Oops, cannot start the ser
ver.
←[36m2014-03-28T19:17:49.035739+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$$anonfun$evolutionScript$2.apply(Evolutions.scala:311)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$.evolutionScript(Evolutions.scala:311)
←[36m2014-03-28T19:17:49.035739+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$.checkEvolutionsState(Evolutions.scala:193)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin.withLock(Evolutions.scala:507)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin.onStart(Evolutions.scala:459)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:461)
←[36m2014-03-28T19:17:49.035739+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$.databaseEvolutions(Evolutions.scala:348)
←[36m2014-03-28T19:17:49.035739+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.Evolutions$$anonfun$evolutionScript$2.apply(Evolutions.scala:313)
←[36m2014-03-28T19:17:49.035739+00:00 app[web.1]:←[0m   at scala.Option.map(Opti
on.scala:145)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin$$anonfun$onStart$1$$anonfun$apply$1.apply$mcV$sp(Evolutions.s
cala:462)
←[36m2014-03-28T19:17:49.036575+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1.apply$mcV$sp(Play.scala:88)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at scala.collection.immu
table.List.foreach(List.scala:318)
←[36m2014-03-28T19:17:49.036575+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:49.036575+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.db.evolution
s.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:459)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at scala.collection.immu
table.List.foreach(List.scala:318)
←[36m2014-03-28T19:17:49.036232+00:00 app[web.1]:←[0m   at play.api.Play$$anonfu
n$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:88)
←[36m2014-03-28T19:17:49.036575+00:00 app[web.1]:←[0m   at play.utils.Threads$.w
ithContextClassLoader(Threads.scala:18)
←[36m2014-03-28T19:17:49.036575+00:00 app[web.1]:←[0m   at play.api.Play$.start(
Play.scala:87)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$.createServer(NettyServer.scala:243)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$.main(NettyServer.scala:274)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at play.core.StaticAppli
cation.<init>(ApplicationProvider.scala:52)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$$anonfun$main$3.apply(NettyServer.scala:279)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer$$anonfun$main$3.apply(NettyServer.scala:274)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at play.core.server.Nett
yServer.main(NettyServer.scala)
←[36m2014-03-28T19:17:49.036988+00:00 app[web.1]:←[0m   at scala.Option.map(Opti
on.scala:145)
←[36m2014-03-28T19:17:50.634268+00:00 heroku[web.1]:←[0m State changed from star
ting to crashed
←[36m2014-03-28T19:17:50.622291+00:00 heroku[web.1]:←[0m Process exited with sta
tus 255
←[33m2014-03-28T19:18:03.883698+00:00 heroku[router]:←[0m at=error code=H10 desc
="App crashed" method=GET path=/ host=protected-anchorage-4936.herokuapp.com req
uest_id=a54ed420-3fb9-444d-8fb1-b218b8c51284 fwd="14.96.131.39" dyno= connect= s
ervice= status=503 bytes=

I am new to heroku and not able to understand what the problem is thanks in advance.

2

There are 2 answers

35
James Ward On BEST ANSWER

Run play stage and then look in the target/universal/stage/bin directory to see what the start script is named. Then update your Procfile and repush to Heroku.

12
johanandren On

The error target/start: No such file or directory hints that heroku thinks your app is a play 2.1 app when it really is a play 2.2 app.

Read about the correct procfile for Play 2.2 here: https://devcenter.heroku.com/articles/play-support