21:34:10,342 INFO [KeywordAdminServiceImpl] Keywords import started. 21:34:11,490 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_window_replacement-11960.csv' file - keywords into keywords_tmp table 21:34:16,386 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-acura_leasing-10220.csv' file - keywords into keywords_tmp table 21:34:21,180 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-ant_control-10847.csv' file - keywords into keywords_tmp table 21:34:26,282 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-subaru_dealerships-10191.csv' file - keywords into keywords_tmp table 21:34:30,150 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-vw_leasing-10218.csv' file - keywords into keywords_tmp table 21:34:36,726 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-roof_repair-10961.csv' file - keywords into keywords_tmp table 21:34:39,838 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-lexus_dealerships-10195.csv' file - keywords into keywords_tmp table 21:34:43,716 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_window_repair-11961.csv' file - keywords into keywords_tmp table 21:34:48,541 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-art_insurance-11487.csv' file - keywords into keywords_tmp table 21:34:56,891 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-outdoor_storage-11680.csv' file - keywords into keywords_tmp table 21:35:03,027 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tennis_lessons-10518.csv' file - keywords into keywords_tmp table 21:35:06,010 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mazda_dealerships-10187.csv' file - keywords into keywords_tmp table 21:35:09,917 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tricycles-11811.csv' file - keywords into keywords_tmp table 21:35:14,658 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bed_&_breakfasts-10004.csv' file - keywords into keywords_tmp table 21:35:24,894 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-data_recovery-11242.csv' file - keywords into keywords_tmp table 21:35:28,688 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-pet_grooming-10861.csv' file - keywords into keywords_tmp table 21:35:31,764 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-air_freight-11656.csv' file - keywords into keywords_tmp table 21:35:35,849 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-family_doctors-10439.csv' file - keywords into keywords_tmp table 21:35:38,788 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-veneers-11343.csv' file - keywords into keywords_tmp table 21:35:43,303 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-sump_pump_installation-11993.csv' file - keywords into keywords_tmp table 21:35:49,992 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-chevy_dealerships-10181.csv' file - keywords into keywords_tmp table 21:35:55,010 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-computers-11236.csv' file - keywords into keywords_tmp table 21:35:59,737 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-shower_repair-11941.csv' file - keywords into keywords_tmp table 21:36:05,858 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_dodges-11140.csv' file - keywords into keywords_tmp table 21:36:10,621 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-auditors-10014.csv' file - keywords into keywords_tmp table 21:36:13,744 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cat_insurance-11468.csv' file - keywords into keywords_tmp table 21:36:19,223 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-personal_trainers-10521.csv' file - keywords into keywords_tmp table 21:36:22,724 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-windshield_replacement-11962.csv' file - keywords into keywords_tmp table 21:36:29,091 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-maid_service-10310.csv' file - keywords into keywords_tmp table 21:36:32,791 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cadillac_leasing-10208.csv' file - keywords into keywords_tmp table 21:36:37,696 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-kia_parts-10251.csv' file - keywords into keywords_tmp table 21:36:41,544 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-villa_rentals-11261.csv' file - keywords into keywords_tmp table 21:36:45,446 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-pet_shipping-11652.csv' file - keywords into keywords_tmp table 21:36:53,697 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-rental_storage-11681.csv' file - keywords into keywords_tmp table 21:36:58,287 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-flooring-10383.csv' file - keywords into keywords_tmp table 21:37:04,144 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-spa_resorts-10001.csv' file - keywords into keywords_tmp table 21:37:10,454 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-breakfast_restaurants-10953.csv' file - keywords into keywords_tmp table 21:37:16,717 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-chinese_restaurants-10948.csv' file - keywords into keywords_tmp table 21:37:21,551 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_parts-10264.csv' file - keywords into keywords_tmp table 21:37:27,149 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-alternators-10266.csv' file - keywords into keywords_tmp table 21:37:31,894 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_kias-11147.csv' file - keywords into keywords_tmp table 21:37:36,628 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-kia_dealerships-10190.csv' file - keywords into keywords_tmp table 21:37:40,458 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_restoration-10229.csv' file - keywords into keywords_tmp table 21:37:43,502 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-gmc_parts-10247.csv' file - keywords into keywords_tmp table 21:37:47,357 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-boiler_installation-11935.csv' file - keywords into keywords_tmp table 21:37:55,252 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-animal_control-10853.csv' file - keywords into keywords_tmp table 21:38:02,858 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_shipping-11654.csv' file - keywords into keywords_tmp table 21:38:12,323 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-chrysler_leasing-10210.csv' file - keywords into keywords_tmp table 21:38:17,207 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-chrysler_dealerships-10186.csv' file - keywords into keywords_tmp table 21:38:21,135 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-driveway_paving-10331.csv' file - keywords into keywords_tmp table 21:38:25,653 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-motorcycle_shipping-11852.csv' file - keywords into keywords_tmp table 21:38:29,643 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-travel_agents-11805.csv' file - keywords into keywords_tmp table 21:38:34,166 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-air_conditioning_installation-10034.csv' file - keywords into keywords_tmp table 21:38:49,075 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-crankshafts-10271.csv' file - keywords into keywords_tmp table 21:38:53,426 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-gmc_dealerships-10185.csv' file - keywords into keywords_tmp table 21:38:57,312 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-concrete_patios-10333.csv' file - keywords into keywords_tmp table 21:39:02,683 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-moving_companies-11657.csv' file - keywords into keywords_tmp table 21:39:15,902 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-spa_treatments-11011.csv' file - keywords into keywords_tmp table 21:39:19,826 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-securities_lawyers-10687.csv' file - keywords into keywords_tmp table 21:39:23,844 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-kia_leasing-10214.csv' file - keywords into keywords_tmp table 21:39:28,493 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-scaffolding-10343.csv' file - keywords into keywords_tmp table 21:39:33,191 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mechanics-10766.csv' file - keywords into keywords_tmp table 21:39:36,360 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-home_water_filters-11620.csv' file - keywords into keywords_tmp table 21:39:41,464 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-earnosethroat-10426.csv' file - keywords into keywords_tmp table 21:39:47,226 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-barber_schools-10593.csv' file - keywords into keywords_tmp table 21:39:49,053 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bee_control-10850.csv' file - keywords into keywords_tmp table 21:39:55,982 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_speakers-10270.csv' file - keywords into keywords_tmp table 21:40:01,330 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-auto_parts-10263.csv' file - keywords into keywords_tmp table 21:40:05,358 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-immigration_lawyers-10681.csv' file - keywords into keywords_tmp table 21:40:09,768 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-italian_restaurants-10944.csv' file - keywords into keywords_tmp table 21:40:14,641 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-window_washing-10306.csv' file - keywords into keywords_tmp table 21:40:17,946 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-long_distance_moving-11854.csv' file - keywords into keywords_tmp table 21:40:23,136 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cockroach_control-10855.csv' file - keywords into keywords_tmp table 21:40:28,500 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_maintenance-10232.csv' file - keywords into keywords_tmp table 21:40:32,505 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-nissan_leasing-10202.csv' file - keywords into keywords_tmp table 21:40:37,416 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bankruptcy_lawyers-10674.csv' file - keywords into keywords_tmp table 21:40:43,076 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-road_bikes-10140.csv' file - keywords into keywords_tmp table 21:40:49,271 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_mazdas-11149.csv' file - keywords into keywords_tmp table 21:40:54,026 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-shower_installation-11940.csv' file - keywords into keywords_tmp table 21:41:00,481 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-storage_solutions-11693.csv' file - keywords into keywords_tmp table 21:41:05,092 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-painting_contractors-11888.csv' file - keywords into keywords_tmp table 21:41:10,195 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-criminal_defense_lawyers-10676.csv' file - keywords into keywords_tmp table 21:41:15,718 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-concrete_contractors-10335.csv' file - keywords into keywords_tmp table 21:41:20,898 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-fountains-11408.csv' file - keywords into keywords_tmp table 21:41:24,124 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-rat_control-10854.csv' file - keywords into keywords_tmp table 21:41:29,627 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-home_construction-10346.csv' file - keywords into keywords_tmp table 21:41:35,210 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-industrial_cleaning-11872.csv' file - keywords into keywords_tmp table 21:41:43,015 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_lexus-11148.csv' file - keywords into keywords_tmp table 21:41:50,676 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-dodge_parts-10255.csv' file - keywords into keywords_tmp table 21:41:54,520 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-buffets-10957.csv' file - keywords into keywords_tmp table 21:41:58,867 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-carburetors-10277.csv' file - keywords into keywords_tmp table 21:42:03,416 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_gmcs-11143.csv' file - keywords into keywords_tmp table 21:42:08,090 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_cadillacs-11136.csv' file - keywords into keywords_tmp table 21:42:12,852 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-fire_insurance-11463.csv' file - keywords into keywords_tmp table 21:42:17,418 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-dodge_leasing-10212.csv' file - keywords into keywords_tmp table 21:42:22,250 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-jeep_leasing-10207.csv' file - keywords into keywords_tmp table 21:42:26,968 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-meditation-10539.csv' file - keywords into keywords_tmp table 21:42:30,815 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-hyundai_dealerships-10192.csv' file - keywords into keywords_tmp table 21:42:34,808 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tax_software-11263.csv' file - keywords into keywords_tmp table 21:42:38,793 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-lasik-10431.csv' file - keywords into keywords_tmp table 21:42:43,462 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tankless_water_heaters-10891.csv' file - keywords into keywords_tmp table 21:42:49,807 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-buick_dealerships-10189.csv' file - keywords into keywords_tmp table 21:42:53,663 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cadillac_parts-10242.csv' file - keywords into keywords_tmp table 21:42:57,519 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-vegetarian_restaurants-10954.csv' file - keywords into keywords_tmp table 21:43:02,859 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-antifreeze-11290.csv' file - keywords into keywords_tmp table 21:43:06,988 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cloud_storage-11490.csv' file - keywords into keywords_tmp table 21:43:11,995 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-trademark_lawyers-10690.csv' file - keywords into keywords_tmp table 21:43:17,013 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-wisdom_teeth_removal-11348.csv' file - keywords into keywords_tmp table 21:43:21,432 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-van_rental-10283.csv' file - keywords into keywords_tmp table 21:43:25,894 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-accountants-10013.csv' file - keywords into keywords_tmp table 21:43:29,261 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-remodeling-10379.csv' file - keywords into keywords_tmp table 21:43:35,362 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bicycles-10134.csv' file - keywords into keywords_tmp table 21:43:40,714 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-facials-11016.csv' file - keywords into keywords_tmp table 21:43:44,085 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-express_shipping-11651.csv' file - keywords into keywords_tmp table 21:43:48,621 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-vacation_rentals-10007.csv' file - keywords into keywords_tmp table 21:43:52,529 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-security_lights-10713.csv' file - keywords into keywords_tmp table 21:43:56,429 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mercedes_dealerships-10179.csv' file - keywords into keywords_tmp table 21:44:00,330 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-vegan_restaurants-10955.csv' file - keywords into keywords_tmp table 21:44:05,432 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-root_canals-11342.csv' file - keywords into keywords_tmp table 21:44:09,785 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-toilet_repair-11943.csv' file - keywords into keywords_tmp table 21:44:16,845 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mufflers-10278.csv' file - keywords into keywords_tmp table 21:44:20,718 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mountain_bikes-10139.csv' file - keywords into keywords_tmp table 21:44:25,488 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-acura_parts-10256.csv' file - keywords into keywords_tmp table 21:44:29,396 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-business_moving-11853.csv' file - keywords into keywords_tmp table 21:44:37,292 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-building_insurance-11474.csv' file - keywords into keywords_tmp table 21:44:42,100 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-electrical_installation-10475.csv' file - keywords into keywords_tmp table 21:44:45,230 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-french_restaurants-10952.csv' file - keywords into keywords_tmp table 21:44:50,006 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-spark_plugs-10267.csv' file - keywords into keywords_tmp table 21:44:53,435 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-periodontists-11350.csv' file - keywords into keywords_tmp table 21:44:59,131 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-saab_parts-10243.csv' file - keywords into keywords_tmp table 21:45:02,951 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-seafood_restaurants-11205.csv' file - keywords into keywords_tmp table 21:45:07,802 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-oncologists-10442.csv' file - keywords into keywords_tmp table 21:45:10,632 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-attorneys-10691.csv' file - keywords into keywords_tmp table 21:45:13,945 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-subaru_leasing-10215.csv' file - keywords into keywords_tmp table 21:45:18,768 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-pedicures-11014.csv' file - keywords into keywords_tmp table 21:45:21,919 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-drain_cleaning-10893.csv' file - keywords into keywords_tmp table 21:45:25,658 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-package_shipping-11850.csv' file - keywords into keywords_tmp table 21:45:32,551 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tank_cleaning-11873.csv' file - keywords into keywords_tmp table 21:45:37,964 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cruiser_bikes-10143.csv' file - keywords into keywords_tmp table 21:45:44,178 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bat_control-10275.csv' file - keywords into keywords_tmp table 21:45:49,564 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_fords-11141.csv' file - keywords into keywords_tmp table 21:45:54,320 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-business_insurance-11459.csv' file - keywords into keywords_tmp table 21:45:59,217 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-indian_restaurants-10949.csv' file - keywords into keywords_tmp table 21:46:04,299 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-will_lawyers-10693.csv' file - keywords into keywords_tmp table 21:46:07,994 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mexican_restaurants-10946.csv' file - keywords into keywords_tmp table 21:46:12,984 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_chryslers-11139.csv' file - keywords into keywords_tmp table 21:46:17,865 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-office_supplies-11571.csv' file - keywords into keywords_tmp table 21:46:20,759 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-estate_lawyers-10696.csv' file - keywords into keywords_tmp table 21:46:24,026 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cardiologists-10423.csv' file - keywords into keywords_tmp table 21:46:28,008 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-lexus_parts-10252.csv' file - keywords into keywords_tmp table 21:46:31,741 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-real_estate_agents-10910.csv' file - keywords into keywords_tmp table 21:46:34,605 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-house_cleaning-10307.csv' file - keywords into keywords_tmp table 21:46:38,260 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-commercial_construction-10339.csv' file - keywords into keywords_tmp table 21:46:41,750 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-volvo_leasing-10199.csv' file - keywords into keywords_tmp table 21:46:46,414 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-boiler_repair-11936.csv' file - keywords into keywords_tmp table 21:46:50,943 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-restaurants-10945.csv' file - keywords into keywords_tmp table 21:46:55,974 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_autos-11133.csv' file - keywords into keywords_tmp table 21:47:00,771 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-steel_fabrication-10344.csv' file - keywords into keywords_tmp table 21:47:04,513 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-oil_changes-10228.csv' file - keywords into keywords_tmp table 21:47:09,255 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-rv_parks-11260.csv' file - keywords into keywords_tmp table 21:47:14,805 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-shipping-11648.csv' file - keywords into keywords_tmp table 21:47:19,029 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-family_physicians-10427.csv' file - keywords into keywords_tmp table 21:47:21,726 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-taxis-11127.csv' file - keywords into keywords_tmp table 21:47:26,951 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mosquito_control-11204.csv' file - keywords into keywords_tmp table 21:47:32,237 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-moving_storage-11679.csv' file - keywords into keywords_tmp table 21:47:37,865 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-emergency_locksmiths-10989.csv' file - keywords into keywords_tmp table 21:47:40,274 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-shingle_roofing-10960.csv' file - keywords into keywords_tmp table 21:47:44,115 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-computer_recycling-11241.csv' file - keywords into keywords_tmp table 21:47:49,021 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cpas-10011.csv' file - keywords into keywords_tmp table 21:47:52,587 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-property_management-10915.csv' file - keywords into keywords_tmp table 21:47:57,055 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-dentures-11346.csv' file - keywords into keywords_tmp table 21:48:02,290 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-plastic_surgery-10436.csv' file - keywords into keywords_tmp table 21:48:07,170 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-septic_tank_installation-11937.csv' file - keywords into keywords_tmp table 21:48:14,285 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-building_contractors-10375.csv' file - keywords into keywords_tmp table 21:48:19,063 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-doctors-10425.csv' file - keywords into keywords_tmp table 21:48:21,767 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-storage_facilities-11693.csv' file - keywords into keywords_tmp table 21:48:27,732 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-dog_insurance-11473.csv' file - keywords into keywords_tmp table 21:48:33,352 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-septic_tanks-10888.csv' file - keywords into keywords_tmp table 21:48:37,780 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-nissan_parts-10240.csv' file - keywords into keywords_tmp table 21:48:41,626 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-freight_shipping-11655.csv' file - keywords into keywords_tmp table 21:48:45,567 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-foundation_contractors-11306.csv' file - keywords into keywords_tmp table 21:48:49,392 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-life_insurance-11455.csv' file - keywords into keywords_tmp table 21:48:55,599 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-accounting_software-11264.csv' file - keywords into keywords_tmp table 21:49:00,395 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-ford_leasing-10205.csv' file - keywords into keywords_tmp table 21:49:05,119 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cabin_rentals-11979.csv' file - keywords into keywords_tmp table 21:49:09,633 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_volvos-11156.csv' file - keywords into keywords_tmp table 21:49:14,347 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-flood_insurance-11461.csv' file - keywords into keywords_tmp table 21:49:18,777 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_batteries-10265.csv' file - keywords into keywords_tmp table 21:49:22,556 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-apartment_rentals-10911.csv' file - keywords into keywords_tmp table 21:49:25,605 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-window_repair-11193.csv' file - keywords into keywords_tmp table 21:49:32,264 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-chevy_parts-10246.csv' file - keywords into keywords_tmp table 21:49:37,526 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-dance_classes-10519.csv' file - keywords into keywords_tmp table 21:49:40,325 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-construction-10340.csv' file - keywords into keywords_tmp table 21:49:45,044 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-beauty_salons-11012.csv' file - keywords into keywords_tmp table 21:49:49,306 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-jeep_dealerships-10182.csv' file - keywords into keywords_tmp table 21:49:53,233 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-electric_bikes-11814.csv' file - keywords into keywords_tmp table 21:49:59,517 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-jewelry_insurance-11472.csv' file - keywords into keywords_tmp table 21:50:22,393 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mercedes_leasing-10204.csv' file - keywords into keywords_tmp table 21:50:27,233 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-international_shipping-11650.csv' file - keywords into keywords_tmp table 21:50:31,609 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-metal_fabrication-10501.csv' file - keywords into keywords_tmp table 21:50:36,225 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-office_cleaning-11234.csv' file - keywords into keywords_tmp table 21:50:41,957 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-commercial_plumbers-11995.csv' file - keywords into keywords_tmp table 21:50:50,579 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-honda_parts-10238.csv' file - keywords into keywords_tmp table 21:50:54,403 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-storage_solutions-11699.csv' file - keywords into keywords_tmp table 21:50:59,910 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-courier_services-11653.csv' file - keywords into keywords_tmp table 21:51:04,612 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bike_lights-11230.csv' file - keywords into keywords_tmp table 21:51:10,604 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bmw_parts-10241.csv' file - keywords into keywords_tmp table 21:51:14,455 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_vans-11155.csv' file - keywords into keywords_tmp table 21:51:17,977 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-buick_leasing-10213.csv' file - keywords into keywords_tmp table 21:51:22,646 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-faucet_&_sink_installation-11933.csv' file - keywords into keywords_tmp table 21:51:34,912 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-fire_alarms-10982.csv' file - keywords into keywords_tmp table 21:51:38,790 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-teeth_cleaning-11345.csv' file - keywords into keywords_tmp table 21:51:42,388 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-sump_pumps-10890.csv' file - keywords into keywords_tmp table 21:51:47,748 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_subarus-11152.csv' file - keywords into keywords_tmp table 21:51:52,539 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-concrete_floors-10330.csv' file - keywords into keywords_tmp table 21:51:58,166 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-vw_parts-10260.csv' file - keywords into keywords_tmp table 21:52:03,501 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-trust_lawyers-10680.csv' file - keywords into keywords_tmp table 21:52:07,246 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-jeep_parts-10248.csv' file - keywords into keywords_tmp table 21:52:11,130 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-locksmiths-10988.csv' file - keywords into keywords_tmp table 21:52:14,378 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-veterinarians-10860.csv' file - keywords into keywords_tmp table 21:52:19,505 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-water_heater_installation-11944.csv' file - keywords into keywords_tmp table 21:52:28,086 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-smog_checks-10224.csv' file - keywords into keywords_tmp table 21:52:33,461 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-cadillac_dealerships-10184.csv' file - keywords into keywords_tmp table 21:52:37,427 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_rental-10279.csv' file - keywords into keywords_tmp table 21:52:42,897 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-flower_delivery-10419.csv' file - keywords into keywords_tmp table 21:52:47,870 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-lincoln_dealerships-10183.csv' file - keywords into keywords_tmp table 21:52:51,814 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-chevy_leasing-10206.csv' file - keywords into keywords_tmp table 21:52:58,597 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-computer_software-11240.csv' file - keywords into keywords_tmp table 21:53:02,423 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-toyota_parts-10239.csv' file - keywords into keywords_tmp table 21:53:05,780 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-event_insurance-11480.csv' file - keywords into keywords_tmp table 21:53:09,322 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_nissans-11151.csv' file - keywords into keywords_tmp table 21:53:12,923 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-radiators-10272.csv' file - keywords into keywords_tmp table 21:53:17,273 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_chevys-11138.csv' file - keywords into keywords_tmp table 21:53:25,242 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-roofing_installation-10959.csv' file - keywords into keywords_tmp table 21:53:30,073 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-boilers-10895.csv' file - keywords into keywords_tmp table 21:53:37,529 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-international_moving-11855.csv' file - keywords into keywords_tmp table 21:53:43,634 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bed_bug_control-10856.csv' file - keywords into keywords_tmp table 21:53:47,433 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-psychologists-10438.csv' file - keywords into keywords_tmp table 21:53:49,835 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-business_lawyers-10675.csv' file - keywords into keywords_tmp table 21:53:51,833 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_cars-11137.csv' file - keywords into keywords_tmp table 21:53:56,598 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bmx_bikes-11812.csv' file - keywords into keywords_tmp table 21:54:00,543 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-self_storage-11683.csv' file - keywords into keywords_tmp table 21:54:03,548 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-ford_dealerships-10180.csv' file - keywords into keywords_tmp table 21:54:07,185 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-lawyers-10682.csv' file - keywords into keywords_tmp table 21:54:10,623 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-campgrounds-10006.csv' file - keywords into keywords_tmp table 21:54:15,689 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-fertility_treatment-10441.csv' file - keywords into keywords_tmp table 21:54:20,073 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mazda_leasing-10211.csv' file - keywords into keywords_tmp table 21:54:25,353 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-electricians-10377.csv' file - keywords into keywords_tmp table 21:54:27,971 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_vws-11157.csv' file - keywords into keywords_tmp table 21:54:34,537 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-furniture_moving-11658.csv' file - keywords into keywords_tmp table 21:54:39,302 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-real_estate-10909.csv' file - keywords into keywords_tmp table 21:54:44,851 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-water_fountains-11570.csv' file - keywords into keywords_tmp table 21:54:52,247 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bike_tires-11229.csv' file - keywords into keywords_tmp table 21:55:00,805 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tanning_salons-11017.csv' file - keywords into keywords_tmp table 21:55:05,043 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-honda_dealerships-10175.csv' file - keywords into keywords_tmp table 21:55:09,638 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-pilates_classes-10537.csv' file - keywords into keywords_tmp table 21:55:13,339 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-men's_clothing-10045.csv' file - keywords into keywords_tmp table 21:55:18,937 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-auto_body-10236.csv' file - keywords into keywords_tmp table 21:55:25,084 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_servicing-10227.csv' file - keywords into keywords_tmp table 21:55:30,925 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-disability_lawyers-10688.csv' file - keywords into keywords_tmp table 21:55:36,034 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_towing-10234.csv' file - keywords into keywords_tmp table 21:55:42,175 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-orthopedic_surgeons-10433.csv' file - keywords into keywords_tmp table 21:55:49,131 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-drop_shipping-11649.csv' file - keywords into keywords_tmp table 21:55:54,528 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-gymnastics_classes-10517.csv' file - keywords into keywords_tmp table 21:55:57,767 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-concrete_stamping-10332.csv' file - keywords into keywords_tmp table 21:56:02,769 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bathtub_installation-11931.csv' file - keywords into keywords_tmp table 21:56:19,010 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-disability_insurance-11470.csv' file - keywords into keywords_tmp table 21:56:23,409 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_washes-10235.csv' file - keywords into keywords_tmp table 21:56:26,925 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-water_tanks-10885.csv' file - keywords into keywords_tmp table 21:56:30,842 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_painting-10225.csv' file - keywords into keywords_tmp table 21:56:42,055 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-gyms-10520.csv' file - keywords into keywords_tmp table 21:56:45,339 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-drain_repair-11984.csv' file - keywords into keywords_tmp table 21:56:54,370 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-subaru_parts-10257.csv' file - keywords into keywords_tmp table 21:56:58,177 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-gmc_leasing-10209.csv' file - keywords into keywords_tmp table 21:57:03,010 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-health_insurance-11460.csv' file - keywords into keywords_tmp table 21:57:07,487 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-boot_camps-10522.csv' file - keywords into keywords_tmp table 21:57:11,338 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_upholstery-10230.csv' file - keywords into keywords_tmp table 21:57:15,268 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-plumbers-10378.csv' file - keywords into keywords_tmp table 21:57:21,213 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-garbage_disposal_repair-10886.csv' file - keywords into keywords_tmp table 21:57:25,605 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-container_shipping-11851.csv' file - keywords into keywords_tmp table 21:57:29,970 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-bike_shops-10137.csv' file - keywords into keywords_tmp table 21:57:34,416 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-computer_support-11488.csv' file - keywords into keywords_tmp table 21:57:38,966 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-retaining_walls-10334.csv' file - keywords into keywords_tmp table 21:57:44,754 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-tile_roofing-10963.csv' file - keywords into keywords_tmp table 21:57:48,805 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-children's_clothing-10047.csv' file - keywords into keywords_tmp table 21:57:58,766 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-yoga-10536.csv' file - keywords into keywords_tmp table 21:58:03,568 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-auto_dealerships-10173.csv' file - keywords into keywords_tmp table 21:58:07,512 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-hotels-10002.csv' file - keywords into keywords_tmp table 21:58:13,257 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-insurance-11454.csv' file - keywords into keywords_tmp table 21:58:18,264 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_window_tinting-10231.csv' file - keywords into keywords_tmp table 21:58:24,468 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_mechanics-10765.csv' file - keywords into keywords_tmp table 21:58:30,313 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-contractors-10376.csv' file - keywords into keywords_tmp table 21:58:34,864 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-used_buicks-11135.csv' file - keywords into keywords_tmp table 21:58:39,597 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-toilet_installation-11942.csv' file - keywords into keywords_tmp table 21:58:46,154 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mole_control-11598.csv' file - keywords into keywords_tmp table 21:58:51,663 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-water_heaters-10748.csv' file - keywords into keywords_tmp table 21:58:56,349 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-mazda_parts-10249.csv' file - keywords into keywords_tmp table 21:59:00,124 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-basement_finishing-10380.csv' file - keywords into keywords_tmp table 21:59:04,505 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-pest_control-10845.csv' file - keywords into keywords_tmp table 21:59:10,321 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.TransactionReaper_18] - TransactionReaper::check timeout for TX -3f57e174:ea75:515c04cf:9a in state RUN 21:59:10,327 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_58] - Abort of action id -3f57e174:ea75:515c04cf:9a invoked while multiple threads active within it. 21:59:10,328 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.CheckedAction_2] - CheckedAction::check - atomic action -3f57e174:ea75:515c04cf:9a aborting with 1 threads active! 21:59:10,827 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.TransactionReaper_18] - TransactionReaper::check timeout for TX -3f57e174:ea75:515c04cf:9a in state CANCEL 21:59:10,939 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-acura_dealerships-10196.csv' file - keywords into keywords_tmp table 21:59:10,973 ERROR [BatchInsertUtil] error inserting SQL rows into biz_function_location.keywordImport_tmp from file /tmp/keywordDAO2013-04-038827137704087622662.tmp org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57e174:ea75:515c04cf:9a status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57e174:ea75:515c04cf:9a status: ActionStatus.ABORTING >) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:614) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:883) at com.thesearchagency.core.smb.dao.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:82) at com.thesearchagency.core.smb.dao.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:150) at com.thesearchagency.core.smb.dao.keyword.KeywordDAO.createTmpKeywordsTable(KeywordDAO.java:265) at com.thesearchagency.core.smb.dao.keyword.KeywordDAO.syncKeywords(KeywordDAO.java:107) at com.thesearchagency.core.smb.service.keyword.service.impl.KeywordAdminServiceImpl.importKeywords(KeywordAdminServiceImpl.java:169) at com.thesearchagency.core.smb.service.keyword.service.KeywordAdminService.downloadAndImportKeywords(KeywordAdminService.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_8986844.invoke(InvocationContextInterceptor_z_fillMethod_8986844.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_8986844.invoke(InvocationContextInterceptor_z_setup_8986844.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176) at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207) at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164) at $Proxy518.downloadAndImportKeywords(Unknown Source) at com.thesearchagency.core.smb.service.keyword.service.jmx.KeywordListMonitorJMX.triggerKeywordFileDownloadAndImport(KeywordListMonitorJMX.java:45) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_8986844.invoke(InvocationContextInterceptor_z_fillMethod_8986844.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_8986844.invoke(InvocationContextInterceptor_z_setup_8986844.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.service.ServiceContainer.localInvoke(ServiceContainer.java:451) at org.jboss.ejb3.service.ServiceMBeanDelegate.invoke(ServiceMBeanDelegate.java:215) at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668) at org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:258) at org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:223) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet$3.run(HtmlAdaptorServlet.java:380) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet$3.run(HtmlAdaptorServlet.java:377) at java.security.AccessController.doPrivileged(Native Method) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorServlet.java:376) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorServlet.java:287) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdaptorServlet.java:104) at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServlet.java:86) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:679) Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57e174:ea75:515c04cf:9a status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57e174:ea75:515c04cf:9a status: ActionStatus.ABORTING >) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) ... 140 more Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57e174:ea75:515c04cf:9a status: ActionStatus.ABORTING > at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:370) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89) ... 142 more 21:59:10,975 INFO [KeywordDAO] Loading '/usr/local/tsa/mms_keywords/keywords-car_dealerships-10172.csv' file - keywords into keywords_tmp table .....