2024-08-01 05:15:51 [scrapy.utils.log] INFO: Scrapy 2.11.2 started (bot: catalog_discovery) 2024-08-01 05:15:51 [scrapy.utils.log] INFO: Versions: lxml 5.2.2.0, libxml2 2.12.6, cssselect 1.2.0, parsel 1.9.1, w3lib 2.1.2, Twisted 24.3.0, Python 3.11.9 (main, Jul 23 2024, 07:22:56) [GCC 12.2.0], pyOpenSSL 24.1.0 (OpenSSL 3.2.1 30 Jan 2024), cryptography 42.0.7, Platform Linux-6.4.10-dirty-x86_64-with-glibc2.36 2024-08-01 05:15:51 [scrapy.addons] INFO: Enabled addons: [] 2024-08-01 05:15:51 [scrapy.extensions.telnet] INFO: Telnet Password: 15c26f279c9f458b 2024-08-01 05:15:51 [scrapy.middleware] INFO: Enabled extensions: ['scrapy.extensions.corestats.CoreStats', 'scrapy.extensions.telnet.TelnetConsole', 'scrapy.extensions.memusage.MemoryUsage', 'scrapy.extensions.feedexport.FeedExporter', 'scrapy.extensions.logstats.LogStats', 'spidermon.contrib.scrapy.extensions.Spidermon'] 2024-08-01 05:15:51 [scrapy.crawler] INFO: Overridden settings: {'BOT_NAME': 'catalog_discovery', 'CONCURRENT_ITEMS': 1000, 'CONCURRENT_REQUESTS': 32, 'FEED_EXPORT_ENCODING': 'utf-8', 'LOG_FILE': '/var/lib/scrapyd/logs/catalog_discovery/staples/1a3b7c6e4fc511efae8d4200a9fe0102.log', 'LOG_LEVEL': 'INFO', 'NEWSPIDER_MODULE': 'catalog_discovery.spiders', 'REQUEST_FINGERPRINTER_CLASS': 'scrapy_poet.ScrapyPoetRequestFingerprinter', 'REQUEST_FINGERPRINTER_IMPLEMENTATION': '2.7', 'RETRY_TIMES': 5, 'SPIDER_MODULES': ['catalog_discovery.spiders'], 'TWISTED_REACTOR': 'twisted.internet.asyncioreactor.AsyncioSelectorReactor', 'USER_AGENT': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:125.0) ' 'Gecko/20100101 Firefox/125.0'} 2024-08-01 05:15:51 [scrapy_poet.injection] INFO: Loading providers: [, , , , , , ] 2024-08-01 05:15:51 [scrapy.middleware] INFO: Enabled downloader middlewares: ['scrapy.downloadermiddlewares.offsite.OffsiteMiddleware', 'scrapy.downloadermiddlewares.httpauth.HttpAuthMiddleware', 'scrapy.downloadermiddlewares.downloadtimeout.DownloadTimeoutMiddleware', 'scrapy.downloadermiddlewares.defaultheaders.DefaultHeadersMiddleware', 'scrapy.downloadermiddlewares.useragent.UserAgentMiddleware', 'scrapy.downloadermiddlewares.httpproxy.HttpProxyMiddleware', 'scrapy_poet.InjectionMiddleware', 'scrapy.downloadermiddlewares.retry.RetryMiddleware', 'scrapy.downloadermiddlewares.redirect.MetaRefreshMiddleware', 'scrapy.downloadermiddlewares.httpcompression.HttpCompressionMiddleware', 'scrapy.downloadermiddlewares.redirect.RedirectMiddleware', 'scrapy.downloadermiddlewares.cookies.CookiesMiddleware', 'scrapy_poet.DownloaderStatsMiddleware'] 2024-08-01 05:15:51 [scrapy.middleware] INFO: Enabled spider middlewares: ['scrapy.spidermiddlewares.httperror.HttpErrorMiddleware', 'scrapy_poet.RetryMiddleware', 'scrapy.spidermiddlewares.referer.RefererMiddleware', 'scrapy.spidermiddlewares.urllength.UrlLengthMiddleware', 'scrapy.spidermiddlewares.depth.DepthMiddleware'] 2024-08-01 05:15:51 [scrapy.middleware] INFO: Enabled item pipelines: ['scraping_utils.pipelines.DuplicatesFilterPipeline', 'scraping_utils.pipelines.AttachSupplierPipeline', 'spidermon.contrib.scrapy.pipelines.ItemValidationPipeline'] 2024-08-01 05:15:51 [scrapy.core.engine] INFO: Spider opened 2024-08-01 05:15:51 [scrapy.extensions.logstats] INFO: Crawled 0 pages (at 0 pages/min), scraped 0 items (at 0 items/min) 2024-08-01 05:15:51 [scrapy.extensions.telnet] INFO: Telnet console listening on 127.0.0.1:6023 2024-08-01 05:15:56 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:1 2024-08-01 05:15:57 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:2 2024-08-01 05:15:58 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:3 2024-08-01 05:16:00 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:4 2024-08-01 05:16:01 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:5 2024-08-01 05:16:02 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:6 2024-08-01 05:16:04 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:7 2024-08-01 05:16:06 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:8 2024-08-01 05:16:07 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:9 2024-08-01 05:16:09 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:10 2024-08-01 05:16:11 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:11 2024-08-01 05:16:12 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:12 2024-08-01 05:16:13 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:13 2024-08-01 05:16:15 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:14 2024-08-01 05:16:16 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:15 2024-08-01 05:16:18 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:16 2024-08-01 05:16:19 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:17 2024-08-01 05:16:21 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:18 2024-08-01 05:16:22 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:19 2024-08-01 05:16:24 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:20 2024-08-01 05:16:26 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:21 2024-08-01 05:16:27 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:22 2024-08-01 05:16:28 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:23 2024-08-01 05:16:30 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:24 2024-08-01 05:16:31 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:25 2024-08-01 05:16:33 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:26 2024-08-01 05:16:35 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:27 2024-08-01 05:16:36 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:28 2024-08-01 05:16:37 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:29 2024-08-01 05:16:39 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:30 2024-08-01 05:16:40 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:31 2024-08-01 05:16:42 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:32 2024-08-01 05:16:43 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:33 2024-08-01 05:16:45 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:34 2024-08-01 05:16:47 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:35 2024-08-01 05:16:48 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:36 2024-08-01 05:16:49 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:37 2024-08-01 05:16:51 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:38 2024-08-01 05:16:51 [scrapy.extensions.logstats] INFO: Crawled 5 pages (at 5 pages/min), scraped 96593 items (at 96593 items/min) 2024-08-01 05:16:52 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:39 2024-08-01 05:16:54 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:40 2024-08-01 05:16:56 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:41 2024-08-01 05:16:57 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:42 2024-08-01 05:16:58 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:43 2024-08-01 05:17:00 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:44 2024-08-01 05:17:02 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:45 2024-08-01 05:17:03 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:46 2024-08-01 05:17:05 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:47 2024-08-01 05:17:06 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:48 2024-08-01 05:17:08 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:49 2024-08-01 05:17:09 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:50 2024-08-01 05:17:11 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:51 2024-08-01 05:17:12 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:52 2024-08-01 05:17:14 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:53 2024-08-01 05:17:15 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:54 2024-08-01 05:17:17 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:55 2024-08-01 05:17:18 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:56 2024-08-01 05:17:20 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:57 2024-08-01 05:17:22 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:58 2024-08-01 05:17:23 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:59 2024-08-01 05:17:25 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:60 2024-08-01 05:17:26 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:61 2024-08-01 05:17:28 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:62 2024-08-01 05:17:29 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:63 2024-08-01 05:17:31 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:64 2024-08-01 05:17:32 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:65 2024-08-01 05:17:34 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:66 2024-08-01 05:17:35 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:67 2024-08-01 05:17:37 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:68 2024-08-01 05:17:38 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:69 2024-08-01 05:17:40 [scrapy.core.engine] INFO: Closing spider (finished) 2024-08-01 05:17:40 [staples] INFO: [Spidermon] ------------------------------ MONITORS ------------------------------ 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Extracted Items Monitor/test_stat_monitor... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Item Validation Monitor/test_stat_monitor... SKIPPED (Unable to find 'spidermon/validation/fields/errors' in job stats.) 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Error Count Monitor/test_stat_monitor... SKIPPED (Unable to find 'log_count/ERROR' in job stats.) 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Warning Count Monitor/test_stat_monitor... SKIPPED (Unable to find 'log_count/WARNING' in job stats.) 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Finish Reason Monitor/Should have the expected finished reason(s)... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Unwanted HTTP codes monitor/Should not hit the limit of unwanted http status... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Field Coverage Monitor/test_check_if_field_coverage_rules_are_met... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Retry Count monitor/Should not hit the limit of requests that reached the maximum retry amount... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Downloader Exceptions monitor/test_stat_monitor... SKIPPED (Unable to find 'downloader/exception_count' in job stats.) 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Successful Requests monitor/Should have at least the minimum number of successful requests... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] Total Requests monitor/Should not hit the total limit of requests... OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] 11 monitors in 0.002s 2024-08-01 05:17:40 [staples] INFO: [Spidermon] OK (skipped=4) 2024-08-01 05:17:40 [staples] INFO: [Spidermon] -------------------------- FINISHED ACTIONS -------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] 0 actions in 0.000s 2024-08-01 05:17:40 [staples] INFO: [Spidermon] OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] --------------------------- PASSED ACTIONS --------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] 0 actions in 0.000s 2024-08-01 05:17:40 [staples] INFO: [Spidermon] OK 2024-08-01 05:17:40 [staples] INFO: [Spidermon] --------------------------- FAILED ACTIONS --------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-08-01 05:17:40 [staples] INFO: [Spidermon] 0 actions in 0.000s 2024-08-01 05:17:40 [staples] INFO: [Spidermon] OK 2024-08-01 05:17:40 [scrapy.extensions.feedexport] INFO: Stored bq feed (2500 items) in: bq://response-elt.scraper_data.catalog_urls/batch:70 2024-08-01 05:17:40 [scrapy.extensions.feedexport] INFO: Stored bq feed (202 items) in: bq://response-elt.scraper_data.catalog_urls/batch:71 2024-08-01 05:17:40 [scrapy.statscollectors] INFO: Dumping Scrapy stats: {'downloader/request_bytes': 9084, 'downloader/request_count': 5, 'downloader/request_method_count/GET': 5, 'downloader/response_bytes': 3168255, 'downloader/response_count': 5, 'downloader/response_status_count/200': 5, 'elapsed_time_seconds': 108.199897, 'feedexport/success_count/BigQueryFeedStorage': 71, 'finish_reason': 'finished', 'finish_time': datetime.datetime(2024, 8, 1, 5, 17, 40, 142493, tzinfo=datetime.timezone.utc), 'httpcompression/response_bytes': 3164173, 'httpcompression/response_count': 5, 'item_scraped_count': 175202, 'log_count/INFO': 110, 'memusage/max': 573251584, 'memusage/startup': 113328128, 'poet/injector/catalog_discovery.pages.staples.StaplesSitemapPageObject': 5, 'request_depth_max': 1, 'response_received_count': 5, 'scheduler/dequeued': 5, 'scheduler/dequeued/memory': 5, 'scheduler/enqueued': 5, 'scheduler/enqueued/memory': 5, 'spidermon/validation/fields': 700808, 'spidermon/validation/items': 175202, 'spidermon/validation/validators': 1, 'spidermon/validation/validators/item/jsonschema': True, 'spidermon_field_coverage/dict/name': 1.0, 'spidermon_field_coverage/dict/sku': 1.0, 'spidermon_field_coverage/dict/supplier': 1.0, 'spidermon_field_coverage/dict/url': 1.0, 'spidermon_item_scraped_count': 175202, 'spidermon_item_scraped_count/dict': 175202, 'spidermon_item_scraped_count/dict/name': 175202, 'spidermon_item_scraped_count/dict/sku': 175202, 'spidermon_item_scraped_count/dict/supplier': 175202, 'spidermon_item_scraped_count/dict/url': 175202, 'start_time': datetime.datetime(2024, 8, 1, 5, 15, 51, 942596, tzinfo=datetime.timezone.utc)} 2024-08-01 05:17:40 [scrapy.core.engine] INFO: Spider closed (finished)