Skip to content

Instantly share code, notes, and snippets.

View bourroush's full-sized avatar

Guillaume Bourrousse bourroush

View GitHub Profile
➜ cineflixinternational git:(cedar) heroku pgbackups:restore HEROKU_POSTGRESQL_GOLD 'https://s3.amazonaws.com/me/items/3H0q/mydb.dump' --app cineflixcedar-app
HEROKU_POSTGRESQL_GOLD_URL (DATABASE_URL) <---restore--- mydb.dump
! WARNING: Destructive Action
! This command will affect the app: cineflixcedar-app
! To proceed, type "cineflixcedar-app" or re-run this command with --confirm cineflixcedar-app
> cineflixcedar-app
! Please add the pgbackups addon first via:
@bourroush
bourroush / gist:853e1f2bcdcb27f92038
Created December 15, 2014 09:42
Migration issue
== TieExistingOrdersToAccounts: migrating ====================================
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Table 'ttg.ring_sizings' doesn't exist: SHOW FULL FIELDS FROM `ring_sizings`/Users/boris/src/georgianjewelry/app/models/order_item.rb:18:in `ring_sizing_cost'
/Users/boris/src/georgianjewelry/app/models/order.rb:59:in `block in ring_sizing_total'
/Users/boris/src/georgianjewelry/app/models/order.rb:59:in `ring_sizing_total'
/Users/boris/src/georgianjewelry/app/models/order.rb:186:in `taxable_costs'
/Users/boris/src/georgianjewelry/app/models/order.rb:64:in `total'
/Users/boris/src/georgianjewelry/app/models/order.rb:190:in `update_cached_total'
➜ repo git:(master) cd /opt/boxen/repo
➜ repo git:(master) script/nuke --services --force
-> Removing /Library/LaunchDaemons/dev.dnsmasq.plist.
-> Removing /Library/LaunchDaemons/dev.mongodb.plist.
-> Removing /Library/LaunchDaemons/dev.nginx.plist.
-> Removing /Library/LaunchDaemons/dev.postgresql.plist.
➜ repo git:(master) boxen
Boxen is up-to-date.
Notice: Compiled catalog for guillaumes-macbook-pro.local in environment production in 3.41 seconds
Notice: /Stage[main]/Postgresql::Config/File[/Library/LaunchDaemons/dev.postgresql.plist]/ensure: defined content as '{md5}be6bf2dbd581e03419aea7dda187a4ec'
postgresql: stable 9.3.5 (bottled), devel 9.4beta2
http://www.postgresql.org/
Conflicts with: postgres-xc
/opt/boxen/homebrew/Cellar/postgresql/9.3.1-boxen (2918 files, 40M) *
Built from source
From: https://github.com/Homebrew/homebrew/blob/master/Library/Formula/postgresql.rb
==> Dependencies
Required: openssl ✔, readline ✔
Recommended: ossp-uuid ✔
==> Options
➜ ~ boxen
Notice: Compiled catalog for guillaumes-macbook-pro.local in environment production in 3.70 seconds
Notice: /Stage[main]/Ruby::Build/Repository[/opt/boxen/ruby-build]/ensure: ensure changed 'ee04b9d3c542bed4781acad33dbe0fd0563925e6' to 'v20140926'
Notice: /Stage[main]/Iterm2::Dev/Package[iTerm]/ensure: created
Error: Command exceeded timeout
Error: /Stage[main]/Postgresql::Service/Exec[wait-for-postgresql]/returns: change from notrun to 0 failed: Command exceeded timeout
Notice: /Stage[main]/Projects::Airware/Boxen::Project[airware]/Postgresql::Db[airware_test]/Exec[postgresql-db-airware_test]: Dependency Exec[wait-for-postgresql] has failures: true
Warning: /Stage[main]/Projects::Airware/Boxen::Project[airware]/Postgresql::Db[airware_test]/Exec[postgresql-db-airware_test]: Skipping because of failed dependencies
Notice: /Stage[main]/Projects::Airware/Boxen::Project[airware]/Postgresql::Db[airware_development]/Exec[postgresql-db-airware_development]: Dependency Exec[wait-for-postgresql] has failur
➜ recode git:(master) rails s
=> Booting WEBrick
=> Rails 4.1.5 application starting in development on http://0.0.0.0:3000
=> Run `rails server -h` for more startup options
=> Notice: server is listening on all interfaces (0.0.0.0). Consider using 127.0.0.1 (--binding option)
=> Ctrl-C to shutdown server
[2014-10-24 16:08:09] INFO WEBrick 1.3.1
[2014-10-24 16:08:09] INFO ruby 2.1.2 (2014-05-08) [x86_64-darwin13.0]
[2014-10-24 16:08:09] INFO WEBrick::HTTPServer#start: pid=3373 port=3000
+
+ The 'contrib' directory has been installed to:
+ #{HOMEBREW_PREFIX}/share/git-core/contrib
EOS
end
- def test
+ test do
HOMEBREW_REPOSITORY.cd do
- `#{bin}/git ls-files -- bin`.chomp == 'bin/brew'
var to = payload.order.email;
var params = payload.parameters;
var email = {};
var template = null;
for (var i = 0; i < payload.parameters.length; i++) {
if (payload.parameters[i].name === 'mandrill.order_confirmation.template') {
template = payload.parameters[i].value;
}
}
➜ zweet git:(features/mturk-mvp) ✗ script/bootstrap
Would you like to (re)initialize the database? (y/n) n
Would you like to retrieve a database snapshot from staging? (y/n) y
Creating database snapshot...
Restoring database snapshot...
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2428; 2606 17793 CONSTRAINT withdrawals_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR: constraint "withdrawals_pkey" of relation "withdrawals" does not exist
Command was: ALTER TABLE ONLY public.withdrawals DROP CONSTRAINT withdrawals_pkey;
➜ zweet git:(features/mturk-mvp) ✗ mkdir -p tmp/psql
➜ zweet git:(features/mturk-mvp) ✗ script/bootstrap
Would you like to (re)initialize the database? (y/n) n
Would you like to retrieve a database snapshot from staging? (y/n) y
Creating database snapshot...
Restoring database snapshot...
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2275; 1259 25142 INDEX index_receipts_on_chain_id u89yid
pg_restore: [archiver (db)] could not execute query: ERROR: index "index_receipts_on_chain_id" does not exist
Command was: DROP INDEX public.index_receipts_on_chain_id;