heroku - 在 heroku 上部署 play 框架应用程序时出错

Question

我正在尝试使用来自 link 的命令在 heroku 上部署我的 play 框架应用程序

每个命令都可以正常工作，但是在浏览器上输入我的 heroku 应用程序的 url 时出现错误

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.

和我的日志

     $ 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
kash@outlook.com
←[35m2014-03-28T19:17:25.404581+00:00 heroku[api]:←[0m Release v19 created by si
ngh_akash@outlook.com
←[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=

我是 heroku 的新手，无法理解问题所在提前致谢。

Answer 1

运行 play stage 然后查看 target/universal/stage/bin 目录以查看启动脚本的名称。然后更新您的 Procfile 并重新推送到 Heroku。