Partners funtime

gistfile1.txt

Deleted field_partners field
Cleared cache

SELECT * 
FROM field_collection_item 
WHERE field_name='field_partners'
52 rows

SELECT * FROM field_collection_item_revision rev
JOIN field_collection_item item on item.item_id = rev.item_id 
WHERE field_name='field_partners'
142 rows

SELECT * FROM field_config
WHERE field_name='field_partners'
2 rows

SELECT * FROM field_config_instance
WHERE field_name='field_partners'
2 rows

Doing features-revert with dosomething_campaign and dosomething_taxonomy with missing field_partners stuff.

After features-revert, all queries return the same # of results.

DELETE FROM field_config
WHERE field_name='field_partners';

2 rows deleted

DELETE FROM field_config_instance
WHERE field_name='field_partners';

2 rows deleted

drush cc all

DELETE FROM
field_collection_item_revision
WHERE item_id IN (
  SELECT item_id FROM field_collection_item WHERE field_name='field_partners'
 )
 
 142 rows deleted
 
 DELETE FROM
field_collection_item
WHERE field_name = 'field_partners'

52 rows deleted

drush cc all


Warning: Unknown: GC cache entry '/vagrant/html/modules/file/file.install' (dev=21 ino=40985) was on gc-list for 3871 seconds in Unknown on line 0 Warning: Unknown: GC cache entry '/vagrant/html/modules/image/image.install' (dev=21 ino=69196) was on gc-list for 3871 seconds in Unknown on line 0 Warning: Unknown: GC cache entry '/vagrant/html/modules/taxonomy/taxonomy.install' (dev=21 ino=69161) was on gc-list for 3871 seconds in Unknown on line 0 Warning: Unknown: GC cache entry '/vagrant/html/modules/field/modules/text/text.install' (dev=21 ino=69099) was on gc-list for 3871 seconds in Unknown on line 0 Warning: Unknown: GC cache entry '/vagrant/html/includes/database/mysql/schema.inc' (dev=21 ino=40221) was on gc-list for 3871 seconds in Unknown on line 0 Warning: Unknown: GC cache entry '/vagrant/html/includes/database/schema.inc' (dev=21 ino=40203) was on gc-list for 3871 seconds in Unknown on line 0 Warning: Unknown: GC cache entry '/vagrant/html/includes/install.inc' (dev=21 ino=40192) was on gc-list for 3871 seconds in Unknown on line 0

What is GC cache?

Also note that here http://drupal.stackexchange.com/questions/46085/programatically-remove-a-field-from-a-node
While calling field_delete_field() and field_purge_batch() works, it keeps records in field_config_instance and field_config. Why is that? –  berkes Oct 9 '12 at 13:46

Running 
SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.tables
WHERE TABLE_NAME LIKE '%deleted%'
returns 5 tables.

Continues in day 2 https://gist.github.com/aaronschachter/4e7d47ae105a1da1a2af