2020-10-18 01:00:01.082 CDT [59865] FATAL: database "egroves" does not exist 2020-10-18 21:02:28.675 CDT [4957] LOG: checkpoints are occurring too frequently (29 seconds apart) 2020-10-18 21:02:28.675 CDT [4957] HINT: Consider increasing the configuration parameter "max_wal_size". 2020-10-18 22:03:21.544 CDT [16125] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-18 22:03:21.544 CDT [16125] DETAIL: Key (item_id)=(DRK 04578) already exists. 2020-10-18 22:03:21.544 CDT [16125] STATEMENT: INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number, manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords, company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size, benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description, alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height, height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name, category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5, category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1, item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3, item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4, item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5, item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1, item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3, item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5, item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id, brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DRK 04578', '5973', 'FS_00202', 'Vanish® 90158', '90158', 'Sealed Air', 'Vanish®', 'Chemicals', 'Cleaners', 'Bathroom, Tile & Toilet Cleaners', '', '', '', 'TOILET BOWL CLEANER', 'VANISH BOWL CLEANER (ACID) 32-OZ., 12/CS (REPLACED OBSOLETE 90158)', 'Vanish® Bowl and Bathroom Cleaner, Non-Acid, 32 oz Container, Trigger Spray Bottle Container, Liquid Form, Fresh Odor/Scent, Clear Blue, 2% VOC, 6.5 to 7.5 pH, 1 Specific Gravity, Composition: n-Alkyl Dimethyl Benzyl Ammonium Chloride, Isopropyl Alcohol', 'Vanish® 90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue', 'Vanish® 90158; Chemicals; Cleaners; Bathroom, Tile & Toilet Cleaners; Vanish® 90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue', 'GROVES', 'EA', '2.3460', '4.1200', '2.400000000000', '1.0000', '• Cleans and disinfects in one step
• Powerful quaternary detergent thickened liquid for toilet bowls, urinals and general purpose bathroom cleaning and disinfecting
• Bactericidal, virucidal, odor neutralizer and deodorizer', 'Y', '47131829', '', 'TOILET BOWL CLEANER', 'd9f3969abaaeda415fd7848af33cb476a74cc1c65bae48108dd6cfe1e187fdee', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.0', '', '1514160000', 'Bathroom, Tile & Toilet Cleaners', '1500000000', '1514000000', '1514160000', '', '', '', 'Toilet Bowl Cleaner', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Active', '4629', '7998', '', '', '', '1', '2', '4.1200' ) 2020-10-18 22:05:15.121 CDT [16125] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-18 22:05:15.121 CDT [16125] DETAIL: Key (item_id)=(LTH LED P4BM) already exists. 2020-10-18 22:05:15.121 CDT [16125] STATEMENT: INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number, manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords, company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size, benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description, alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height, height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name, category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5, category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1, item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3, item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4, item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5, item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1, item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3, item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5, item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id, brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('LTH LED P4BM', '10515', 'GROVES_10514', 'LED Lenser® P4', 'P4', 'Leatherman Tool Group', 'LED Lenser®', 'Portable Lighting & Flashlights', 'Flashlights', 'Flashlights - Handheld', '', '', '', 'LED Flashlight', 'P4 BLUEMOON LL CLIP LIGHT 16 LUMEN, 27 METER', 'LED Lenser® P4 LED Flashlight, With Pocket Clip', 'LED Lenser® P4 LED Flashlight, With Pocket Clip', 'LED Lenser® P4; Portable Lighting & Flashlights; Flashlights; Flashlights - Handheld; LED Lenser® P4 LED Flashlight, With Pocket Clip', 'GROVES', 'EA', '14.3800', '25.2300', '.150000000000', '1.0000', '• High-end LED with white "Blue Moon" beam
• Battery life of 6 hours at 16 lumens
• Tail switch
• Hard gold-plated battery contacts to maximize efficiency and resist corrosion
• Modular design for easy replacement of parts
• Water resistant
• Includes 1 P4 LED flashlight, 1 set of batteries, 1 sheath, 1 lanyard, 1 clip & instruction manual', 'Y', '', 'The P4 is a focusable, handy everyday carry flashlight, no larger than the size of a ballpoint pen. It offers 18 lumens of bright white light, with a beam distance of 82 feet. This small miniature penlight can be clipped to your shirt or pants pocket and has a run time of 8.5 hours, perfect for use at work or at home.', 'LED Flashlight', 'a69dc3b2a8e576b7e981d82b4f04a191e72647122ed2bf1ffa489f2c71b68210', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.0', '', '131211000000', 'Flashlights - Handheld', '490000000000', '1143130000', '131211000000', '', '', '', 'LED Flashlight', '', '', 'GBTHX2MZJEAV.jpg', '', '', 'URL', 'GBTHX2MZJEAW.jpg', '', '', 'URL', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Active', '4063', '8112', '', '', '', '0', '2', '25.2300' ) 2020-10-18 22:07:33.895 CDT [16125] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-18 22:07:33.895 CDT [16125] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists. 2020-10-18 22:07:33.895 CDT [16125] STATEMENT: INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number, manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords, company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size, benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description, alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height, height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name, category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5, category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1, item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3, item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4, item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5, item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1, item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3, item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5, item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id, brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('SAF JS1500-38R', '18170', 'GROVES_18172', 'Saf-Tech CJS15RB-M', 'CJS15RB-M', 'Saf-Tech', 'Saf-Tech', 'Safety & Security', 'Personal Protective Equipment (PPE)', 'Clothing', 'Work Clothing', 'Coveralls & Overalls', '', 'Nomex Coveralls', 'INTL LOGO NOMEX CVRL/ROYAL BLUE-SZ. 38 REG.', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Saf-Tech CJS15RB-M; Safety & Security; Personal Protective Equipment (PPE); Clothing; Work Clothing; Coveralls & Overalls; Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'GROVES', 'EA', '75.1200', '131.7900', '2.000000000000', '1.0000', '• Lay down collar
• A sewn bi-swing back
• Elastic waist inserts and hemmed sleeves with snap closures
• It has bar tacked reinforcements at the stress points
• A 2-way Nomex® brass break away zipper and double stitched reinforcements', 'Y', '', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Nomex Coveralls', 'f17ddb7d878005ee442cfa51e18f60f79688d96ecac067a24048c439040ee317', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1163111811', 'Coveralls & Overalls', '1100000000', '1163000000', '1163110000', '1163111800', '1163111811', '', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', '', '', 'GROVES_18172.jpg', 'GROVES_18172_DET.jpg', 'GROVES_18172_HR.jpg', 'FILE', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Active', '4165', '7245', '', '', '', '0', '2', '131.7900' ) 2020-10-18 22:15:15.349 CDT [21442] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-18 22:15:15.349 CDT [21442] DETAIL: Key (item_id)=(DRK 04578) already exists. 2020-10-18 22:15:15.349 CDT [21442] STATEMENT: INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5, category_name_level_6, company_id, image_name, publish) VALUES ('DRK 04578', '5973', 'FS_00202', 'Chemicals', 'Cleaners', 'Bathroom, Tile & Toilet Cleaners', '', '', '', 'GROVES', 'Vanish_90158.jpg', 'Y') 2020-10-18 22:15:49.064 CDT [21442] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-18 22:15:49.064 CDT [21442] DETAIL: Key (item_id)=(LTH LED P4BM) already exists. 2020-10-18 22:15:49.064 CDT [21442] STATEMENT: INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5, category_name_level_6, company_id, image_name, publish) VALUES ('LTH LED P4BM', '10515', 'GROVES_10514', 'Portable Lighting & Flashlights', 'Flashlights', 'Flashlights - Handheld', '', '', '', 'GROVES', 'GROVES_10514.jpg', 'Y') 2020-10-18 22:15:53.261 CDT [21442] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-18 22:15:53.261 CDT [21442] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists. 2020-10-18 22:15:53.261 CDT [21442] STATEMENT: INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5, category_name_level_6, company_id, image_name, publish) VALUES ('SAF JS1500-38R', '18170', 'GROVES_18172', 'Safety & Security', 'Personal Protective Equipment (PPE)', 'Clothing', 'Work Clothing', 'Coveralls & Overalls', '', 'GROVES', 'GROVES_18172.jpg', 'Y') 2020-10-18 22:21:41.265 CDT [21899] ERROR: missing FROM-clause entry for table "temp_item_specs" at character 344 2020-10-18 22:21:41.265 CDT [21899] STATEMENT: update item_specs set number_value = A.number_value from ( SELECT item_id, spec_name, spec_value, spec_uom, CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN CASE WHEN item_specs.spec_value LIKE '%/%' THEN CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN fraction_to_decimal(item_specs.spec_value)::REAL WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1 AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN fraction_to_decimal(item_specs.spec_value)::REAL ELSE NULL END ELSE CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN item_specs.spec_value::REAL ELSE NULL END END ELSE NULL END as number_value FROM public.item_specs where number_value is null and CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN CASE WHEN item_specs.spec_value LIKE '%/%' THEN CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN fraction_to_decimal(item_specs.spec_value)::REAL WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1 AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN fraction_to_decimal(item_specs.spec_value)::REAL ELSE NULL END ELSE CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN item_specs.spec_value::REAL ELSE NULL END END ELSE NULL END is not null group by item_id, spec_name, spec_value, spec_uom, CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN CASE WHEN item_specs.spec_value LIKE '%/%' THEN CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN fraction_to_decimal(item_specs.spec_value)::REAL WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%' AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1 AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN fraction_to_decimal(item_specs.spec_value)::REAL ELSE NULL END ELSE CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN item_specs.spec_value::REAL ELSE NULL END END ELSE NULL END )A where trim(item_specs.spec_name) = trim(A.spec_name) and trim(item_specs.spec_value) = trim(A.spec_value) and trim(item_specs.item_id) = trim(A.item_id)