warnergodfrey/postgresql-9.0-main.log

## postgresql-9.0-main.log
2011-09-26 03:42:15 UTC DETAIL:  Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
        Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
        Process 30908: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
        Process 31174: TRUNCATE TABLE "countries" RESTART IDENTITY CASCADE;
2011-09-26 03:42:15 UTC HINT:  See server log for query details.
2011-09-26 03:42:15 UTC STATEMENT:  INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
2011-09-26 03:42:30 UTC ERROR:  deadlock detected
2011-09-26 03:42:30 UTC DETAIL:  Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
        Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
        Process 30908: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
        Process 31174: TRUNCATE TABLE "countries" RESTART IDENTITY CASCADE;
2011-09-26 03:42:30 UTC HINT:  See server log for query details.
2011-09-26 03:42:30 UTC STATEMENT:  INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"

## rake console output
1) Api::InventoryNotification persisting to the database should return an error when a hotel cannot be found
     Failure/Error: @hotel_1      = Property.make(:api_source => api_source)
     PGError: ERROR:  deadlock detected
DETAIL:  Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
HINT:  See server log for query details.
: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
     # ./spec/support/blueprints.rb:173:in `make'
     # ./spec/models/api/inventory_notification_spec.rb:61:in `block (3 levels) in <top (required)>'
.................................
  2) Api::RatePlanNotification save should not save rate plans if message is invalid
     Failure/Error: let(:room_type)    { @room_type = RoomType.make }
     PGError: ERROR:  deadlock detected
DETAIL:  Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
HINT:  See server log for query details.
: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
     # ./spec/support/blueprints.rb:173:in `make'
	2011-09-26 03:42:15 UTC DETAIL: Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
	Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
	Process 30908: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
	Process 31174: TRUNCATE TABLE "countries" RESTART IDENTITY CASCADE;
	2011-09-26 03:42:15 UTC HINT: See server log for query details.
	2011-09-26 03:42:15 UTC STATEMENT: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
	2011-09-26 03:42:30 UTC ERROR: deadlock detected
	2011-09-26 03:42:30 UTC DETAIL: Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
	Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
	Process 30908: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
	Process 31174: TRUNCATE TABLE "countries" RESTART IDENTITY CASCADE;
	2011-09-26 03:42:30 UTC HINT: See server log for query details.
	2011-09-26 03:42:30 UTC STATEMENT: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
	1) Api::InventoryNotification persisting to the database should return an error when a hotel cannot be found
	Failure/Error: @hotel_1 = Property.make(:api_source => api_source)
	PGError: ERROR: deadlock detected
	DETAIL: Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
	Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
	HINT: See server log for query details.
	: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
	# ./spec/support/blueprints.rb:173:in `make'
	# ./spec/models/api/inventory_notification_spec.rb:61:in `block (3 levels) in <top (required)>'
	.................................
	2) Api::RatePlanNotification save should not save rate plans if message is invalid
	Failure/Error: let(:room_type) { @room_type = RoomType.make }
	PGError: ERROR: deadlock detected
	DETAIL: Process 30908 waits for RowExclusiveLock on relation 1103847 of database 1103761; blocked by process 31174.
	Process 31174 waits for AccessExclusiveLock on relation 1103799 of database 1103761; blocked by process 30908.
	HINT: See server log for query details.
	: INSERT INTO "properties" ("account_number", "api_source_id", "atdw_id", "cancellation_policy_id", "chain_id", "check_in_after", "check_out_before", "country_id", "created_at", "description", "gst_applicable", "latitude", "longitude", "maximum_child_age", "maximum_infant_age", "name", "number_of_rooms", "policy_info", "postcode", "property_category_id", "property_group_id", "rating", "rating_type", "region_id", "room_type_code_sequence", "state_id", "status", "street_address", "street_address_2", "suburb", "time_zone", "updated_at", "url") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33) RETURNING "id"
	# ./spec/support/blueprints.rb:173:in `make'