Skip to content

Instantly share code, notes, and snippets.

@chadbailey59
Created May 25, 2011 19:50
Show Gist options
  • Save chadbailey59/991755 to your computer and use it in GitHub Desktop.
Save chadbailey59/991755 to your computer and use it in GitHub Desktop.
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