Databases
StackOverflow2013
Postsdbo
POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
    primarykey
    data
    text
    <p>I try to set up the computer database sample on oracle 10g database but I get an error with the evolution script : after create the <code>play_evolution</code> table and <code>Company</code> and <code>Computer</code> table of the sample, play ask me to make the evolution script to put data into these database : <img src="https://i.stack.imgur.com/20ZVz.png" alt="enter image description here"></p> <p>But when I try <code>Apply this script now!</code> I get this result : </p> <pre><code>2012-11-26 11:33:12,324 - [INFO] - from play in play-akka.actor.default-dispatcher-1 database [default] connected at jdbc:oracle:thin:@10.0.2.15:1521:orcl 2012-11-26 11:33:13,166 - [ERROR] - from application in New I/O worker #1 ! @6celgd3g6 - Internal server error, for request [GET /] -&gt; play.api.db.evolutions.InvalidDatabaseRevision: Database 'default' needs evolution! [An SQL script need to be run on your database.] at play.api.db.evolutions.EvolutionsPlugin$$anonfun$onStart$1$$anonfun$apply$1.apply$mcV$sp(Evolutions.scala:427) ~[play_2.9.1.jar:2.0.4] at play.api.db.evolutions.EvolutionsPlugin.withLock(Evolutions.scala:448) ~[play_2.9.1.jar:2.0.4] at play.api.db.evolutions.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:414) ~[play_2.9.1.jar:2.0.4] at play.api.db.evolutions.EvolutionsPlugin$$anonfun$onStart$1.apply(Evolutions.scala:412) ~[play_2.9.1.jar:2.0.4] at scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.scala:59) ~[scala-library.jar:0.11.3] at scala.collection.immutable.List.foreach(List.scala:45) ~[scala-library.jar:0.11.3] at play.api.db.evolutions.EvolutionsPlugin.onStart(Evolutions.scala:412) ~[play_2.9.1.jar:2.0.4] at play.api.Play$$anonfun$start$1.apply(Play.scala:60) ~[play_2.9.1.jar:2.0.4] at play.api.Play$$anonfun$start$1.apply(Play.scala:60) ~[play_2.9.1.jar:2.0.4] at scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.scala:59) ~[scala-library.jar:0.11.3] at scala.collection.immutable.List.foreach(List.scala:45) ~[scala-library.jar:0.11.3] at play.api.Play$.start(Play.scala:60) ~[play_2.9.1.jar:2.0.4] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$3$$anonfun$1.apply(ApplicationProvider.scala:125) ~[play_2.9.1.jar:2.0.4] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$3$$anonfun$1.apply(ApplicationProvider.scala:112) ~[play_2.9.1.jar:2.0.4] at scala.Option.map(Option.scala:133) ~[scala-library.jar:0.11.3] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$3.apply(ApplicationProvider.scala:112) ~[play_2.9.1.jar:2.0.4] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$3.apply(ApplicationProvider.scala:110) ~[play_2.9.1.jar:2.0.4] at scala.Either$RightProjection.flatMap(Either.scala:277) ~[scala-library.jar:0.11.3] at play.core.ReloadableApplication$$anonfun$get$1.apply(ApplicationProvider.scala:110) ~[play_2.9.1.jar:2.0.4] at play.core.ReloadableApplication$$anonfun$get$1.apply(ApplicationProvider.scala:110) ~[play_2.9.1.jar:2.0.4] at akka.dispatch.Future$$anon$3.liftedTree1$1(Future.scala:195) ~[akka-actor.jar:2.0.2] at akka.dispatch.Future$$anon$3.run(Future.scala:194) ~[akka-actor.jar:2.0.2] at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:94) ~[akka-actor.jar:2.0.2] at akka.jsr166y.ForkJoinTask$AdaptedRunnableAction.exec(ForkJoinTask.java:1381) ~[akka-actor.jar:2.0.2] at akka.jsr166y.ForkJoinTask.doExec(ForkJoinTask.java:259) ~[akka-actor.jar:2.0.2] at akka.jsr166y.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:975) ~[akka-actor.jar:2.0.2] at akka.jsr166y.ForkJoinPool.runWorker(ForkJoinPool.java:1479) ~[akka-actor.jar:2.0.2] at akka.jsr166y.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:104) ~[akka-actor.jar:2.0.2] </code></pre> <p>and the application stay on the <code>needs evolution page</code> and the tables are empty in the DB so apparently the script failed (I try it directly on SQL into oracle 10g and the script is working). Anyone can help me for to solved the problem ?</p> <p><strong>EDIT 1: Here is my configuration file</strong></p> <pre><code>application.name=computer-database application.secret="E27D^[_&lt;Lpt0vjad]de;3/i;tx3gpRmG4Byof/3nahO/dIo9gbsMWut1w3xg[&gt;9W" db.default.url="jdbc:oracle:thin:@10.0.2.15:1521:orcl" db.default.driver=oracle.jdbc.driver.OracleDriver db.default.user=play db.default.password=play ebean.default="models.*" "assets.cache./public/stylesheets/bootstrap.min.css"="max-age=3600" logger=ERROR logger.play=INFO logger.application=DEBUG </code></pre> <p><strong>EDIT 2:</strong> I have tried with the JPA version of the sample : I get a similar error : The same screen (<code>Database 'default' needs evolution!</code>) and when I click on <code>Apply this script now!</code> I get exactly the same stack error in log file</p> <p><strong>EDIT 3 :</strong> When I clean the DB, The application ask me to make the first evolution script (the structure of the tables and the data in the same time) so I accept to apply it : He create the tables on my DB but he doesn't insert the data and print the secrond screen where I'm blocked.... And at the begining, I got an error when the application try to create the play_evolution table. After some googled, I found that apparently the code for play_evolution is not working with oracle because of wrong type of fields.... So I created it manually</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAdrien A.
    1. USAdrien A.
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
      1. USAdrien A.
      1. VTBountyStart
    3. VO
      singulars
      1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
      1. USBrownFurSeal
      1. VTFavorite
    1. COSee if it's a [configuration problem](http://stackoverflow.com/q/10303333/315306)
      singulars
      1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
      1. USRaffaele
    2. COit's not working (it's worse) because the application can't connect to my DB without user string :x. I edit my post to put the configuration file but I'm not sure it's a problem of connection string to my DB because the application access to the DB to check if the content of the database is ok. If my login or password or connection string were wrong, I get another error I think
      singulars
      1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
      1. USAdrien A.
    3. COdoes your database allows enough connections ?
      singulars
      1. POplay framework error in New I/O worker #1 when applying evolution script (JPA and Ebean version)
      1. USnico_ekito
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload