test/dummy/log/test.log in ip_to_country-0.0.2 vs test/dummy/log/test.log in ip_to_country-0.0.3

- old
+ new

@@ -3123,5 +3123,651 @@ ALTER TABLE geoips_tempo RENAME TO geoips; ALTER TABLE tmp RENAME TO geoips_tempo; DROP TABLE geoips_tempo;   (1.0ms) ROLLBACK +Connecting to database specified by database.yml +  (0.4ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.4ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (2.0ms) BEGIN + Fixture Delete (0.6ms) DELETE FROM "geoips" + Fixture Insert (0.5ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (13.3ms) COMMIT +  (0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.2ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.5ms) ROLLBACK +  (0.1ms) BEGIN +  (46.2ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.3ms) ROLLBACK +  (0.1ms) BEGIN +  (93.1ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (2.6ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (1.0ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.9ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (20.5ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.4ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (1.3ms) ROLLBACK +Connecting to database specified by database.yml +  (0.6ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.1ms) BEGIN + Fixture Delete (0.5ms) DELETE FROM "geoips" + Fixture Insert (0.6ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (12.0ms) COMMIT +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.2ms) BEGIN + IpToCountry::Geoip Load (1.3ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (58.6ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.0ms) BEGIN +  (39.4ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.6ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.6ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (27.7ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.9ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (1.2ms) ROLLBACK +Connecting to database specified by database.yml +  (0.6ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +Connecting to database specified by database.yml +  (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +Connecting to database specified by database.yml +  (0.4ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.2ms) BEGIN + Fixture Delete (0.6ms) DELETE FROM "geoips" + Fixture Insert (0.7ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (55.6ms) COMMIT +  (0.1ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.1ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (49.0ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (62.8ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.8ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.6ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (25.2ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.7ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (1.5ms) ROLLBACK +Connecting to database specified by database.yml +  (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.1ms) BEGIN + Fixture Delete (0.5ms) DELETE FROM "geoips" + Fixture Insert (2.4ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (25.0ms) COMMIT +  (0.1ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.1ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (40.3ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (38.2ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.7ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.9ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.8ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (33.8ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.4ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (0.7ms) ROLLBACK + IpToCountry::Geoip Load (12.3ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (0.7ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (2.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 +Connecting to database specified by database.yml +  (2.2ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.2ms) BEGIN + Fixture Delete (0.7ms) DELETE FROM "geoips" + Fixture Insert (0.6ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (29.0ms) COMMIT +  (1.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.2ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (100.5ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.6ms) ROLLBACK +  (0.0ms) BEGIN +  (0.3ms) ROLLBACK +  (0.1ms) BEGIN +  (52.2ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.8ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.9ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (23.2ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (2.6ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (1.2ms) ROLLBACK + IpToCountry::Geoip Load (18.3ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (0.9ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 +Connecting to database specified by database.yml +  (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.2ms) BEGIN + Fixture Delete (0.6ms) DELETE FROM "geoips" + Fixture Insert (1.0ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (17.1ms) COMMIT +  (0.3ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.2ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (40.6ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (38.7ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.8ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.9ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.4ms) ROLLBACK +  (0.1ms) BEGIN +  (18.1ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.5ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (0.7ms) ROLLBACK + IpToCountry::Geoip Load (1.3ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (1.1ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (2.5ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 + IpToCountry::Geoip Load (1.3ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 +Connecting to database specified by database.yml +  (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.4ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.2ms) BEGIN + Fixture Delete (0.4ms) DELETE FROM "geoips" + Fixture Insert (0.7ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (20.8ms) COMMIT +  (0.2ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.2ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (52.9ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.8ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.0ms) BEGIN +  (25.1ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.7ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.9ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.7ms) ROLLBACK +  (0.0ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (40.2ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.5ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (0.7ms) ROLLBACK + IpToCountry::Geoip Load (4.9ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 1254684475) and ip_to = (select min(ip_to) + from geoips where ip_to >= 1254684475)) LIMIT 1 +Connecting to database specified by database.yml +  (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateGeoips (1) +Unable to load geoip, underlying cause No such file to load -- geoip + + /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures' +/home/vince/Projets/ip_to_country/test/test_helper.rb:27:in `<class:TestCase>' +/home/vince/Projets/ip_to_country/test/test_helper.rb:24:in `<top (required)>' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require' +/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select' +/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>' +  (0.3ms) ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL +  (0.2ms) BEGIN + Fixture Delete (0.6ms) DELETE FROM "geoips" + Fixture Insert (0.9ms) INSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland') +  (24.4ms) COMMIT +  (0.1ms) ALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL +  (0.1ms) BEGIN + IpToCountry::Geoip Load (1.2ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (101.1ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (0.6ms) ROLLBACK +  (0.1ms) BEGIN +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +  (28.7ms)  DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.6ms) ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to) + from geoips where ip_to >= 35037184)) LIMIT 1 +  (0.7ms) ROLLBACK +  (0.1ms) BEGIN +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +  (36.3ms) DROP TABLE IF EXISTS geoips_tempo; + CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1; + +  (1.4ms)  ALTER TABLE geoips RENAME TO tmp; + ALTER TABLE geoips_tempo RENAME TO geoips; + ALTER TABLE tmp RENAME TO geoips_tempo; + DROP TABLE geoips_tempo; + +  (1.6ms) ROLLBACK + IpToCountry::Geoip Load (18.0ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 + IpToCountry::Geoip Load (0.9ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1 + IpToCountry::Geoip Load (0.8ms) SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to) + from geoips where ip_to >= 3232235778)) LIMIT 1