2024-09-14 11:38:26 [scrapy.utils.log] INFO: Scrapy 2.11.0 started (bot: gazette) 2024-09-14 11:38:26 [scrapy.utils.log] INFO: Versions: lxml 4.9.3.0, libxml2 2.10.3, cssselect 1.2.0, parsel 1.8.1, w3lib 2.1.2, Twisted 22.10.0, Python 3.8.19 (default, Apr 27 2024, 21:20:48) - [GCC 13.2.0], pyOpenSSL 23.2.0 (OpenSSL 3.1.3 19 Sep 2023), cryptography 41.0.4, Platform Linux-6.8.0-41-generic-x86_64-with-glibc2.38 2024-09-14 11:38:26 [pr_mambore] INFO: Collecting data from 2024-09-13 to 2024-09-14. 2024-09-14 11:38:26 [scrapy.addons] INFO: Enabled addons: [] 2024-09-14 11:38:26 [py.warnings] WARNING: /home/marcos/Documentos/querido-diario/.venv/lib/python3.8/site-packages/scrapy/utils/request.py:254: ScrapyDeprecationWarning: '2.6' is a deprecated value for the 'REQUEST_FINGERPRINTER_IMPLEMENTATION' setting. It is also the default value. In other words, it is normal to get this warning if you have not defined a value for the 'REQUEST_FINGERPRINTER_IMPLEMENTATION' setting. This is so for backward compatibility reasons, but it will change in a future version of Scrapy. See the documentation of the 'REQUEST_FINGERPRINTER_IMPLEMENTATION' setting for information on how to handle this deprecation. return cls(crawler) 2024-09-14 11:38:26 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.epollreactor.EPollReactor 2024-09-14 11:38:26 [scrapy.extensions.telnet] INFO: Telnet Password: 7900140a85da6999 2024-09-14 11:38:27 [scrapy.middleware] INFO: Enabled extensions: ['scrapy.extensions.corestats.CoreStats', 'scrapy.extensions.telnet.TelnetConsole', 'scrapy.extensions.memusage.MemoryUsage', 'scrapy.extensions.logstats.LogStats', 'spidermon.contrib.scrapy.extensions.Spidermon', 'gazette.extensions.StatsPersist'] 2024-09-14 11:38:27 [scrapy.crawler] INFO: Overridden settings: {'BOT_NAME': 'gazette', 'COMMANDS_MODULE': 'gazette.commands', 'DOWNLOAD_TIMEOUT': 360, 'FILES_STORE_S3_ACL': 'public-read', 'LOG_FILE': 'log_mambore.txt', 'NEWSPIDER_MODULE': 'gazette.spiders', 'SPIDER_MODULES': ['gazette.spiders'], 'TEMPLATES_DIR': 'templates', 'USER_AGENT': 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:108.0) ' 'Gecko/20100101 Firefox/108.0'} 2024-09-14 11:38:27 [scrapy.middleware] INFO: Enabled downloader middlewares: ['scrapy.downloadermiddlewares.httpauth.HttpAuthMiddleware', 'scrapy.downloadermiddlewares.downloadtimeout.DownloadTimeoutMiddleware', 'scrapy.downloadermiddlewares.defaultheaders.DefaultHeadersMiddleware', 'scrapy.downloadermiddlewares.useragent.UserAgentMiddleware', 'scrapy.downloadermiddlewares.retry.RetryMiddleware', 'scrapy.downloadermiddlewares.redirect.MetaRefreshMiddleware', 'scrapy.downloadermiddlewares.httpcompression.HttpCompressionMiddleware', 'scrapy.downloadermiddlewares.redirect.RedirectMiddleware', 'scrapy_zyte_smartproxy.ZyteSmartProxyMiddleware', 'scrapy.downloadermiddlewares.cookies.CookiesMiddleware', 'scrapy.downloadermiddlewares.httpproxy.HttpProxyMiddleware', 'scrapy.downloadermiddlewares.stats.DownloaderStats'] 2024-09-14 11:38:27 [scrapy.middleware] INFO: Enabled spider middlewares: ['scrapy.spidermiddlewares.httperror.HttpErrorMiddleware', 'scrapy.spidermiddlewares.offsite.OffsiteMiddleware', 'scrapy.spidermiddlewares.referer.RefererMiddleware', 'scrapy.spidermiddlewares.urllength.UrlLengthMiddleware', 'scrapy.spidermiddlewares.depth.DepthMiddleware'] 2024-09-14 11:38:27 [scrapy.middleware] INFO: Enabled item pipelines: ['gazette.pipelines.GazetteDateFilteringPipeline', 'gazette.pipelines.DefaultValuesPipeline', 'gazette.pipelines.QueridoDiarioFilesPipeline', 'spidermon.contrib.scrapy.pipelines.ItemValidationPipeline', 'gazette.pipelines.SQLDatabasePipeline'] 2024-09-14 11:38:27 [scrapy.core.engine] INFO: Spider opened 2024-09-14 11:38:27 [gazette.database.models] INFO: Populating 'territories' table - Please wait! 2024-09-14 11:38:27 [gazette.database.models] INFO: Populating 'territories' table - Done! 2024-09-14 11:38:27 [gazette.database.models] INFO: Populating 'querido_diario_spider' table - Please wait! 2024-09-14 11:38:27 [gazette.database.models] INFO: Populating 'querido_diario_spider' table - Done! 2024-09-14 11:38:27 [scrapy.extensions.logstats] INFO: Crawled 0 pages (at 0 pages/min), scraped 0 items (at 0 items/min) 2024-09-14 11:38:27 [scrapy.extensions.telnet] INFO: Telnet console listening on 127.0.0.1:6023 2024-09-14 11:38:27 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-09-14 11:38:27 [tzlocal] DEBUG: /etc/timezone found, contents: America/Bahia 2024-09-14 11:38:27 [tzlocal] DEBUG: /etc/localtime found 2024-09-14 11:38:27 [tzlocal] DEBUG: 2 found: {'/etc/timezone': 'America/Bahia', '/etc/localtime is a symlink to': 'America/Bahia'} 2024-09-14 11:38:30 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-09-14 11:38:30 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-09-14 11:38:30 [scrapy.core.scraper] DEBUG: Scraped from <200 https://mambore.atende.net/diariooficial/edicao/pagina/atende.php?rot=54015&aca=101&ajax=t&processo=loadPluginDiarioOficial¶metro=%7B%22codigoPlugin%22%3A1%2C%22filtroPlugin%22%3A%7B%22pagina%22%3A%221%22%7D%7D> {'date': '2024-09-13', 'edition_number': '1000', 'file_urls': ['https://mambore.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%221169%22%2C%22hash%22%3A%225659BEAEB2EA25F2D2A83AC2CC4164D0765704EE%22%7D&cidade=padrao'], 'files': [{'checksum': 'd92b8eeb4d906b0e532b4bf189457517', 'path': '4114005/2024-09-13/26bc746561f631e5c813f37b12c4365f816db0a8.pdf', 'status': 'downloaded', 'url': 'https://mambore.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%221169%22%2C%22hash%22%3A%225659BEAEB2EA25F2D2A83AC2CC4164D0765704EE%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-09-14T14:38:27.871508Z', 'territory_id': '4114005'} 2024-09-14 11:38:30 [scrapy.core.engine] INFO: Closing spider (finished) 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] ------------------------------ MONITORS ------------------------------ 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] Comparison Between Executions/Days without gazettes... OK 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] Requests/Items Ratio/Ratio of requests over items scraped count... OK 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] Error Count Monitor/test_stat_monitor... SKIPPED (Unable to find 'log_count/ERROR' in job stats.) 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] Finish Reason Monitor/Should have the expected finished reason(s)... OK 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] Item Validation Monitor/test_stat_monitor... SKIPPED (Unable to find 'spidermon/validation/fields/errors' in job stats.) 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] 5 monitors in 0.003s 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] OK (skipped=2) 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] -------------------------- FINISHED ACTIONS -------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] 0 actions in 0.000s 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] OK 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] --------------------------- PASSED ACTIONS --------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] 0 actions in 0.000s 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] OK 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] --------------------------- FAILED ACTIONS --------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] 1 action in 0.000s 2024-09-14 11:38:30 [pr_mambore] INFO: [Spidermon] OK (skipped=1) 2024-09-14 11:38:30 [scrapy.statscollectors] INFO: Dumping Scrapy stats: {'downloader/request_bytes': 936, 'downloader/request_count': 2, 'downloader/request_method_count/GET': 2, 'downloader/response_bytes': 7418216, 'downloader/response_count': 2, 'downloader/response_status_count/200': 2, 'elapsed_time_seconds': 3.452294, 'file_count': 1, 'file_status_count/downloaded': 1, 'finish_reason': 'finished', 'finish_time': datetime.datetime(2024, 9, 14, 14, 38, 30, 867649, tzinfo=datetime.timezone.utc), 'httpcompression/response_bytes': 23694, 'httpcompression/response_count': 1, 'item_scraped_count': 1, 'log_count/DEBUG': 8, 'log_count/INFO': 35, 'log_count/WARNING': 1, 'memusage/max': 124047360, 'memusage/startup': 124047360, 'response_received_count': 2, 'scheduler/dequeued': 1, 'scheduler/dequeued/memory': 1, 'scheduler/enqueued': 1, 'scheduler/enqueued/memory': 1, 'spidermon/validation/fields': 8, 'spidermon/validation/items': 1, 'spidermon/validation/validators': 1, 'spidermon/validation/validators/item/jsonschema': True, 'start_time': datetime.datetime(2024, 9, 14, 14, 38, 27, 415355, tzinfo=datetime.timezone.utc)} 2024-09-14 11:38:30 [scrapy.core.engine] INFO: Spider closed (finished)