Created
May 25, 2011 19:50
-
-
Save chadbailey59/991755 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
db2-dfw:/var/www/youversion.com/db/youversiondev# ./migrate | |
Buildfile: /var/www/youversion.com/db/youversiondev/build.xml | |
update-database: | |
[dbdeploy] dbdeploy null | |
[dbdeploy] Reading change scripts from directory /var/www/youversion.com/db/youversiondev/deltas... | |
[dbdeploy] Changes currently applied to database: | |
[dbdeploy] 1..19, 21, 23..27, 29..36, 39 | |
[dbdeploy] Scripts available: | |
[dbdeploy] 1..36, 38..42 | |
[dbdeploy] To be applied: | |
[dbdeploy] 20, 22, 28, 38, 40..42 | |
[dbdeploy] Applying #20: 0020.sql... | |
BUILD FAILED | |
/var/www/youversion.com/db/youversiondev/build.xml:56: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: PL/Python: Exception: Undefined index: Ps | |
Caching booklists... | |
Caching book names... | |
Locking tables... | |
Preparing... | |
Selecting bookmark_groups data... | |
Building CSV... | |
100000 processed. (iter time: 2.04359292984sec, total time: 2.04359292984sec) | |
200000 processed. (iter time: 2.05927610397sec, total time: 4.10286903381sec) | |
300000 processed. (iter time: 2.05292892456sec, total time: 6.15579795837sec) | |
400000 processed. (iter time: 2.05712008476sec, total time: 8.21291804314sec) | |
500000 processed. (iter time: 2.05914902687sec, total time: 10.27206707sec) | |
600000 processed. (iter time: 2.06229090691sec, total time: 12.3343579769sec) | |
700000 processed. (iter time: 2.05880403519sec, total time: 14.3931620121sec) | |
800000 processed. (iter time: 2.07297611237sec, total time: 16.4661381245sec) | |
900000 processed. (iter time: 2.06801199913sec, total time: 18.5341501236sec) | |
1000000 processed. (iter time: 2.07280087471sec, total time: 20.6069509983sec) | |
1100000 processed. (iter time: 2.07047605515sec, total time: 22.6774270535sec) | |
1200000 processed. (iter time: 2.06437087059sec, total time: 24.741797924sec) | |
1300000 processed. (iter time: 2.06711912155sec, total time: 26.8089170456sec) | |
1400000 processed. (iter time: 2.05469489098sec, total time: 28.8636119366sec) | |
1500000 processed. (iter time: 2.06786108017sec, total time: 30.9314730167sec) | |
1600000 processed. (iter time: 2.0945379734sec, total time: 33.0260109901sec) | |
1700000 processed. (iter time: 2.07168197632sec, total time: 35.0976929665sec) | |
1800000 processed. (iter time: 2.04998397827sec, total time: 37.1476769447sec) | |
1900000 processed. (iter time: 2.06084108353sec, total time: 39.2085180283sec) | |
2000000 processed. (iter time: 2.0568048954sec, total time: 41.2653229237sec) | |
2100000 processed. (iter time: 2.03802013397sec, total time: 43.3033430576sec) | |
2200000 processed. (iter time: 2.0450220108sec, total time: 45.3483650684sec) | |
2300000 processed. (iter time: 2.05085086823sec, total time: 47.3992159367sec) | |
2400000 processed. (iter time: 2.06084918976sec, total time: 49.4600651264sec) | |
2500000 processed. (iter time: 2.06912183762sec, total time: 51.529186964sec) | |
2600000 processed. (iter time: 2.05149698257sec, total time: 53.5806839466sec) | |
2700000 processed. (iter time: 2.07680010796sec, total time: 55.6574840546sec) | |
2800000 processed. (iter time: 2.05732989311sec, total time: 57.7148139477sec) | |
2900000 processed. (iter time: 2.0718421936sec, total time: 59.7866561413sec) | |
3000000 processed. (iter time: 2.04398584366sec, total time: 61.8306419849sec) | |
3100000 processed. (iter time: 2.05348014832sec, total time: 63.8841221333sec) | |
3200000 processed. (iter time: 2.08533096313sec, total time: 65.9694530964sec) | |
3300000 processed. (iter time: 2.058562994sec, total time: 68.0280160904sec) | |
3400000 processed. (iter time: 2.0506939888sec, total time: 70.0787100792sec) | |
3500000 processed. (iter time: 2.03295183182sec, total time: 72.111661911sec) | |
3600000 processed. (iter time: 2.03582215309sec, total time: 74.1474840641sec) | |
3700000 processed. (iter time: 2.04378390312sec, total time: 76.1912679672sec) | |
3800000 processed. (iter time: 2.05581617355sec, total time: 78.2470841408sec) | |
3900000 processed. (iter time: 2.04033899307sec, total time: 80.2874231339sec) | |
4000000 processed. (iter time: 2.03911089897sec, total time: 82.3265340328sec) | |
4100000 processed. (iter time: 2.04000306129sec, total time: 84.3665370941sec) | |
4200000 processed. (iter time: 2.05988192558sec, total time: 86.4264190197sec) | |
4300000 processed. (iter time: 2.08803701401sec, total time: 88.5144560337sec) | |
4400000 processed. (iter time: 2.10046195984sec, total time: 90.6149179935sec) | |
4500000 processed. (iter time: 2.06044006348sec, total time: 92.675358057sec) | |
Where: PL/Python function "dbdeploy_execute" | |
at com.dbdeploy.appliers.DirectToDbApplier.applyChangeScriptContent(DirectToDbApplier.java:50) | |
at com.dbdeploy.appliers.DirectToDbApplier.apply(DirectToDbApplier.java:29) | |
at com.dbdeploy.Controller.processChangeScripts(Controller.java:40) | |
at com.dbdeploy.DbDeploy.go(DbDeploy.java:111) | |
at com.dbdeploy.AntTarget.execute(AntTarget.java:35) | |
at org.apache.tools.ant.UnknownElement.execute(ant-1.8.0.jar.so) | |
at java.lang.reflect.Method.invoke(libgcj.so.10) | |
at org.apache.tools.ant.dispatch.DispatchUtils.execute(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Task.perform(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Target.execute(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Target.performTasks(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Project.executeSortedTargets(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Project.executeTarget(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Project.executeTargets(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Main.runBuild(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.Main.startAnt(ant-1.8.0.jar.so) | |
at org.apache.tools.ant.launch.Launcher.run(ant-launcher-1.8.0.jar.so) | |
at org.apache.tools.ant.launch.Launcher.main(ant-launcher-1.8.0.jar.so) | |
Caused by: org.postgresql.util.PSQLException: ERROR: PL/Python: Exception: Undefined index: Ps | |
Caching booklists... | |
Caching book names... | |
Locking tables... | |
Preparing... | |
Selecting bookmark_groups data... | |
Building CSV... | |
100000 processed. (iter time: 2.04359292984sec, total time: 2.04359292984sec) | |
200000 processed. (iter time: 2.05927610397sec, total time: 4.10286903381sec) | |
300000 processed. (iter time: 2.05292892456sec, total time: 6.15579795837sec) | |
400000 processed. (iter time: 2.05712008476sec, total time: 8.21291804314sec) | |
500000 processed. (iter time: 2.05914902687sec, total time: 10.27206707sec) | |
600000 processed. (iter time: 2.06229090691sec, total time: 12.3343579769sec) | |
700000 processed. (iter time: 2.05880403519sec, total time: 14.3931620121sec) | |
800000 processed. (iter time: 2.07297611237sec, total time: 16.4661381245sec) | |
900000 processed. (iter time: 2.06801199913sec, total time: 18.5341501236sec) | |
1000000 processed. (iter time: 2.07280087471sec, total time: 20.6069509983sec) | |
1100000 processed. (iter time: 2.07047605515sec, total time: 22.6774270535sec) | |
1200000 processed. (iter time: 2.06437087059sec, total time: 24.741797924sec) | |
1300000 processed. (iter time: 2.06711912155sec, total time: 26.8089170456sec) | |
1400000 processed. (iter time: 2.05469489098sec, total time: 28.8636119366sec) | |
1500000 processed. (iter time: 2.06786108017sec, total time: 30.9314730167sec) | |
1600000 processed. (iter time: 2.0945379734sec, total time: 33.0260109901sec) | |
1700000 processed. (iter time: 2.07168197632sec, total time: 35.0976929665sec) | |
1800000 processed. (iter time: 2.04998397827sec, total time: 37.1476769447sec) | |
1900000 processed. (iter time: 2.06084108353sec, total time: 39.2085180283sec) | |
2000000 processed. (iter time: 2.0568048954sec, total time: 41.2653229237sec) | |
2100000 processed. (iter time: 2.03802013397sec, total time: 43.3033430576sec) | |
2200000 processed. (iter time: 2.0450220108sec, total time: 45.3483650684sec) | |
2300000 processed. (iter time: 2.05085086823sec, total time: 47.3992159367sec) | |
2400000 processed. (iter time: 2.06084918976sec, total time: 49.4600651264sec) | |
2500000 processed. (iter time: 2.06912183762sec, total time: 51.529186964sec) | |
2600000 processed. (iter time: 2.05149698257sec, total time: 53.5806839466sec) | |
2700000 processed. (iter time: 2.07680010796sec, total time: 55.6574840546sec) | |
2800000 processed. (iter time: 2.05732989311sec, total time: 57.7148139477sec) | |
2900000 processed. (iter time: 2.0718421936sec, total time: 59.7866561413sec) | |
3000000 processed. (iter time: 2.04398584366sec, total time: 61.8306419849sec) | |
3100000 processed. (iter time: 2.05348014832sec, total time: 63.8841221333sec) | |
3200000 processed. (iter time: 2.08533096313sec, total time: 65.9694530964sec) | |
3300000 processed. (iter time: 2.058562994sec, total time: 68.0280160904sec) | |
3400000 processed. (iter time: 2.0506939888sec, total time: 70.0787100792sec) | |
3500000 processed. (iter time: 2.03295183182sec, total time: 72.111661911sec) | |
3600000 processed. (iter time: 2.03582215309sec, total time: 74.1474840641sec) | |
3700000 processed. (iter time: 2.04378390312sec, total time: 76.1912679672sec) | |
3800000 processed. (iter time: 2.05581617355sec, total time: 78.2470841408sec) | |
3900000 processed. (iter time: 2.04033899307sec, total time: 80.2874231339sec) | |
4000000 processed. (iter time: 2.03911089897sec, total time: 82.3265340328sec) | |
4100000 processed. (iter time: 2.04000306129sec, total time: 84.3665370941sec) | |
4200000 processed. (iter time: 2.05988192558sec, total time: 86.4264190197sec) | |
4300000 processed. (iter time: 2.08803701401sec, total time: 88.5144560337sec) | |
4400000 processed. (iter time: 2.10046195984sec, total time: 90.6149179935sec) | |
4500000 processed. (iter time: 2.06044006348sec, total time: 92.675358057sec) | |
Where: PL/Python function "dbdeploy_execute" | |
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) | |
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) | |
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) | |
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) | |
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) | |
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) | |
at com.dbdeploy.database.changelog.QueryExecuter.execute(QueryExecuter.java:22) | |
at com.dbdeploy.appliers.DirectToDbApplier.applyChangeScriptContent(DirectToDbApplier.java:47) | |
...18 more | |
Total time: 6 minutes 6 seconds |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment