zlw/gist:1244628

## gistfile1.sql
ruby-1.9.2-p180 :053 > User.rebuild!
   (0.2ms)   DELETE FROM "users_hierarchies"

  User Load (0.8ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" IS NULL
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 43
  User Load (1.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 41
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 20
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 17
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 45
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 38
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 18
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 26
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 42
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 60
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 55
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 12
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 44
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 21
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 40
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 34
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 11
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 23
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 37
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 39
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 9
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 28
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 28 LIMIT 1
   (0.1ms)  BEGIN
   (0.1ms)  COMMIT
  User Load (0.4ms)  SELECT "users".* FROM "users" INNER JOIN "users_hierarchies" ON "users"."id" = "users_hierarchies"."ancestor_id" WHERE "users_hierarchies"."descendant_id" = 28 ORDER BY generations asc
   (0.1ms)  BEGIN
  SQL (0.9ms)  INSERT INTO "users_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3)  [["ancestor_id", nil], ["descendant_id", nil], ["generations", nil]]
   (0.1ms)  ROLLBACK
ActiveRecord::StatementInvalid: PGError: ERROR:  null value in column "ancestor_id" violates not-null constraint
: INSERT INTO "users_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3)
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:976:in `get_last_result'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:976:in `exec_cache'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:548:in `block in exec_query'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract_adapter.rb:222:in `block in log'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:546:in `exec_query'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/database_statements.rb:54:in `exec_insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/database_statements.rb:81:in `insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/relation.rb:68:in `insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/persistence.rb:306:in `create'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/timestamp.rb:51:in `create'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/callbacks.rb:268:in `block in create'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/callbacks.rb:390:in `_run_create_callbacks'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/callbacks.rb:81:in `run_callbacks'
... 19 levels...
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:123:in `add_child'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:210:in `rebuild_node_and_children'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:211:in `block in rebuild_node_and_children'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/associations/collection_proxy.rb:80:in `each'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/associations/collection_proxy.rb:80:in `method_missing'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:211:in `rebuild_node_and_children'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:179:in `block in rebuild!'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/relation.rb:14:in `each'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/relation.rb:14:in `each'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:179:in `rebuild!'
	from (irb):53
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/commands/console.rb:45:in `start'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/commands/console.rb:8:in `start'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/commands.rb:40:in `<top (required)>'
	from script/rails:6:in `require'
	from script/rails:6:in `<main>'ruby-1.9.2-p180 :054 >
	ruby-1.9.2-p180 :053 > User.rebuild!
	(0.2ms) DELETE FROM "users_hierarchies"

	User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" IS NULL
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 43
	User Load (1.7ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 41
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 20
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 17
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 45
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 38
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 18
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 26
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 42
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 60
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 55
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 12
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 44
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 21
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 40
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 34
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 11
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 23
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 37
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 39
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 9
	User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."invited_by_id" = 28
	User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 28 LIMIT 1
	(0.1ms) BEGIN
	(0.1ms) COMMIT
	User Load (0.4ms) SELECT "users".* FROM "users" INNER JOIN "users_hierarchies" ON "users"."id" = "users_hierarchies"."ancestor_id" WHERE "users_hierarchies"."descendant_id" = 28 ORDER BY generations asc
	(0.1ms) BEGIN
	SQL (0.9ms) INSERT INTO "users_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3) [["ancestor_id", nil], ["descendant_id", nil], ["generations", nil]]
	(0.1ms) ROLLBACK
	ActiveRecord::StatementInvalid: PGError: ERROR: null value in column "ancestor_id" violates not-null constraint
	: INSERT INTO "users_hierarchies" ("ancestor_id", "descendant_id", "generations") VALUES ($1, $2, $3)
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:976:in `get_last_result'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:976:in `exec_cache'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:548:in `block in exec_query'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract_adapter.rb:222:in `block in log'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/postgresql_adapter.rb:546:in `exec_query'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/database_statements.rb:54:in `exec_insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/database_statements.rb:81:in `insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/relation.rb:68:in `insert'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/persistence.rb:306:in `create'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/timestamp.rb:51:in `create'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/callbacks.rb:268:in `block in create'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/callbacks.rb:390:in `_run_create_callbacks'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activesupport-3.1.0.rc4/lib/active_support/callbacks.rb:81:in `run_callbacks'
	... 19 levels...
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:123:in `add_child'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:210:in `rebuild_node_and_children'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:211:in `block in rebuild_node_and_children'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/associations/collection_proxy.rb:80:in `each'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/associations/collection_proxy.rb:80:in `method_missing'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:211:in `rebuild_node_and_children'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:179:in `block in rebuild!'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/relation.rb:14:in `each'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/activerecord-3.1.0.rc4/lib/active_record/relation.rb:14:in `each'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/closure_tree-1.0.0/lib/closure_tree/acts_as_tree.rb:179:in `rebuild!'
	from (irb):53
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/commands/console.rb:45:in `start'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/commands/console.rb:8:in `start'
	from /home/rubyapp/prokliencki/shared/bundle/ruby/1.9.1/gems/railties-3.1.0.rc4/lib/rails/commands.rb:40:in `<top (required)>'
	from script/rails:6:in `require'
	from script/rails:6:in `<main>'ruby-1.9.2-p180 :054 >