2024-06-17 13:19:14 [scrapy.utils.log] INFO: Scrapy 2.11.0 started (bot: gazette) 2024-06-17 13:19:14 [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.10.7 (main, May 29 2023, 13:51:48) [GCC 12.2.0], pyOpenSSL 23.2.0 (OpenSSL 3.1.3 19 Sep 2023), cryptography 41.0.4, Platform Linux-5.19.0-46-generic-x86_64-with-glibc2.36 2024-06-17 13:19:14 [pr_apucarana] INFO: Collecting data from 2024-05-01 to 2024-05-31. 2024-06-17 13:19:14 [scrapy.addons] INFO: Enabled addons: [] 2024-06-17 13:19:14 [py.warnings] WARNING: /home/marcos/Documentos/querido-diario/venv/lib/python3.10/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-06-17 13:19:14 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.epollreactor.EPollReactor 2024-06-17 13:19:14 [scrapy.extensions.telnet] INFO: Telnet Password: e5dc16ea0387dab2 2024-06-17 13:19:14 [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', 'gazette.extensions.StatsPersist'] 2024-06-17 13:19:14 [scrapy.crawler] INFO: Overridden settings: {'BOT_NAME': 'gazette', 'COMMANDS_MODULE': 'gazette.commands', 'DOWNLOAD_TIMEOUT': 360, 'FILES_STORE_S3_ACL': 'public-read', 'LOG_FILE': 'log_pr_apucarana_intervalo_maio_24.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-06-17 13:19:14 [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-06-17 13:19:14 [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-06-17 13:19:14 [scrapy.middleware] INFO: Enabled item pipelines: ['gazette.pipelines.GazetteDateFilteringPipeline', 'gazette.pipelines.DefaultValuesPipeline', 'gazette.pipelines.QueridoDiarioFilesPipeline', 'spidermon.contrib.scrapy.pipelines.ItemValidationPipeline', 'gazette.pipelines.SQLDatabasePipeline'] 2024-06-17 13:19:14 [scrapy.core.engine] INFO: Spider opened 2024-06-17 13:19:14 [gazette.database.models] INFO: Populating 'querido_diario_spider' table - Please wait! 2024-06-17 13:19:14 [gazette.database.models] INFO: Populating 'querido_diario_spider' table - Done! 2024-06-17 13:19:14 [scrapy.extensions.logstats] INFO: Crawled 0 pages (at 0 pages/min), scraped 0 items (at 0 items/min) 2024-06-17 13:19:14 [scrapy.extensions.telnet] INFO: Telnet console listening on 127.0.0.1:6023 2024-06-17 13:19:15 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:15 [tzlocal] DEBUG: /etc/timezone found, contents: America/Sao_Paulo 2024-06-17 13:19:15 [tzlocal] DEBUG: /etc/localtime found 2024-06-17 13:19:15 [tzlocal] DEBUG: 2 found: {'/etc/timezone': 'America/Sao_Paulo', '/etc/localtime is a symlink to': 'America/Sao_Paulo'} 2024-06-17 13:19:16 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://apucarana.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) 2024-06-17 13:19:23 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:23 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:23 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-24. File Checksum: 0abfe558511afa9249bfcacdbe6ade2e. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:23 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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-05-24', 'edition_number': '9772', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22528%22%2C%22hash%22%3A%2204C1768F30CC68ED9DC92AB0F4C66AB4B636C247%22%7D&cidade=padrao'], 'files': [{'checksum': '0abfe558511afa9249bfcacdbe6ade2e', 'path': '4101408/2024-05-24/fd5d667ee805ce1b6facf7f15f22e318e387642f.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22528%22%2C%22hash%22%3A%2204C1768F30CC68ED9DC92AB0F4C66AB4B636C247%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:15.204487Z', 'territory_id': '4101408'} 2024-06-17 13:19:28 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:28 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:28 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-23. File Checksum: 6b9ab211524c607ff8f459369f4c8be6. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:28 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-23', 'edition_number': '9771', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22527%22%2C%22hash%22%3A%22FC4D17C05C2344182D468F179CABFBF2918869B3%22%7D&cidade=padrao'], 'files': [{'checksum': '6b9ab211524c607ff8f459369f4c8be6', 'path': '4101408/2024-05-23/d59f8cb121a310c4f259b98dc5b3a1f4a2def43b.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22527%22%2C%22hash%22%3A%22FC4D17C05C2344182D468F179CABFBF2918869B3%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.384720Z', 'territory_id': '4101408'} 2024-06-17 13:19:32 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:32 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:32 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-17. File Checksum: ae507645c08b4cbf4c479480200c93a5. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:32 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-17', 'edition_number': '9767', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22524%22%2C%22hash%22%3A%2239C0ED363E7585E711200EE5C96ACDCDC45C48C8%22%7D&cidade=padrao'], 'files': [{'checksum': 'ae507645c08b4cbf4c479480200c93a5', 'path': '4101408/2024-05-17/366aabe0ae771f9d5b879af784298f3ae3e7ef1d.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22524%22%2C%22hash%22%3A%2239C0ED363E7585E711200EE5C96ACDCDC45C48C8%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.390087Z', 'territory_id': '4101408'} 2024-06-17 13:19:34 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:34 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:34 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-27. File Checksum: b4de3f32c835e7b44f381cc4f93844f0. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:34 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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-05-27', 'edition_number': '9773', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22529%22%2C%22hash%22%3A%22BB668E70B652746D419AE2C3A3EA73F49414954E%22%7D&cidade=padrao'], 'files': [{'checksum': 'b4de3f32c835e7b44f381cc4f93844f0', 'path': '4101408/2024-05-27/fc75e634d1f317cd0f9b8322280caa6fac48a1b5.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22529%22%2C%22hash%22%3A%22BB668E70B652746D419AE2C3A3EA73F49414954E%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:15.202841Z', 'territory_id': '4101408'} 2024-06-17 13:19:34 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:34 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:34 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-15. File Checksum: 3e075a766c77ccd399c49aa362fea991. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:34 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-15', 'edition_number': '9765', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22522%22%2C%22hash%22%3A%22846FA553FFF12A2CCC35737A65500F7B5BDC1480%22%7D&cidade=padrao'], 'files': [{'checksum': '3e075a766c77ccd399c49aa362fea991', 'path': '4101408/2024-05-15/f3b8ac948a29b8dbb8cecb21829850fa8cd880d0.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22522%22%2C%22hash%22%3A%22846FA553FFF12A2CCC35737A65500F7B5BDC1480%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.393199Z', 'territory_id': '4101408'} 2024-06-17 13:19:36 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:36 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:36 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-16. File Checksum: d68fd9d608485148dba0015e3d5e3700. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:36 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-16', 'edition_number': '9766', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22523%22%2C%22hash%22%3A%226DD40442C016E39DC53F7FDEE84F8E6341ECAADB%22%7D&cidade=padrao'], 'files': [{'checksum': 'd68fd9d608485148dba0015e3d5e3700', 'path': '4101408/2024-05-16/d518d7c170b968559481d319fec1cfdb53993977.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22523%22%2C%22hash%22%3A%226DD40442C016E39DC53F7FDEE84F8E6341ECAADB%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.392118Z', 'territory_id': '4101408'} 2024-06-17 13:19:39 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:39 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:39 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-29. File Checksum: 6a768ac37990355763d5f856bc1db5f5. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:39 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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-05-29', 'edition_number': '9775', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22531%22%2C%22hash%22%3A%22B1EE65882517379BFE5FC04609C0FACB273CDCAC%22%7D&cidade=padrao'], 'files': [{'checksum': '6a768ac37990355763d5f856bc1db5f5', 'path': '4101408/2024-05-29/dd156d4f2c22b432a67a353c48c15711ad35c852.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22531%22%2C%22hash%22%3A%22B1EE65882517379BFE5FC04609C0FACB273CDCAC%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:15.198984Z', 'territory_id': '4101408'} 2024-06-17 13:19:40 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:40 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:41 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-13. File Checksum: 0eda10caca4e9601fb0fd5fca8d01b86. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:41 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-13', 'edition_number': '9763', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22520%22%2C%22hash%22%3A%22B0FD9CD8DBD6FA717ED1A7AD19B069743165CD47%22%7D&cidade=padrao'], 'files': [{'checksum': '0eda10caca4e9601fb0fd5fca8d01b86', 'path': '4101408/2024-05-13/cebfb8fbb630e3d5cecd5fdfd58355f231b65e03.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22520%22%2C%22hash%22%3A%22B0FD9CD8DBD6FA717ED1A7AD19B069743165CD47%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.395334Z', 'territory_id': '4101408'} 2024-06-17 13:19:44 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:44 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:44 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-09. File Checksum: 57980a6bf3e339a14ef70e65b5f635e2. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:44 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-09', 'edition_number': '9761', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22518%22%2C%22hash%22%3A%22E1D2409CE66F58C08ABDE7D58CF60C7F9E9B0D6B%22%7D&cidade=padrao'], 'files': [{'checksum': '57980a6bf3e339a14ef70e65b5f635e2', 'path': '4101408/2024-05-09/ce4fa0262c8aa7e776672edb443546e358960468.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22518%22%2C%22hash%22%3A%22E1D2409CE66F58C08ABDE7D58CF60C7F9E9B0D6B%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.397478Z', 'territory_id': '4101408'} 2024-06-17 13:19:44 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:44 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:45 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-14. File Checksum: 45cd0f9af09fa21b4e7cc67cec454e3c. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:45 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-14', 'edition_number': '9764', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22521%22%2C%22hash%22%3A%22B72BED9ACCDC2C0A33C41AABAE4C33DC99DB9EEA%22%7D&cidade=padrao'], 'files': [{'checksum': '45cd0f9af09fa21b4e7cc67cec454e3c', 'path': '4101408/2024-05-14/1c732487e033a4d1df296150dc16dc620756c944.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22521%22%2C%22hash%22%3A%22B72BED9ACCDC2C0A33C41AABAE4C33DC99DB9EEA%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.394264Z', 'territory_id': '4101408'} 2024-06-17 13:19:47 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:47 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:47 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-28. File Checksum: e91b2dac74cff61304ed96a3326ca67d. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:47 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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-05-28', 'edition_number': '9774', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22530%22%2C%22hash%22%3A%229EC7F166D65E5517A45113C6ADA4B372CBC54433%22%7D&cidade=padrao'], 'files': [{'checksum': 'e91b2dac74cff61304ed96a3326ca67d', 'path': '4101408/2024-05-28/3618a13fc3dea6f1c90197eb5ccd77c04c780025.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22530%22%2C%22hash%22%3A%229EC7F166D65E5517A45113C6ADA4B372CBC54433%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:15.201113Z', 'territory_id': '4101408'} 2024-06-17 13:19:49 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:49 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:49 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-08. File Checksum: e1c7fe6552506c404bfbd17756a9f66f. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:49 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-08', 'edition_number': '9760', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22517%22%2C%22hash%22%3A%22EC28D05A96051B88A154FA580FAA5134F64168BD%22%7D&cidade=padrao'], 'files': [{'checksum': 'e1c7fe6552506c404bfbd17756a9f66f', 'path': '4101408/2024-05-08/925372c163711148bd5d3c834f704621c1c82da2.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22517%22%2C%22hash%22%3A%22EC28D05A96051B88A154FA580FAA5134F64168BD%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.398635Z', 'territory_id': '4101408'} 2024-06-17 13:19:49 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:49 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:50 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-22. File Checksum: 7be395bba9ab184614b067901091d411. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:50 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-22', 'edition_number': '9770', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22526%22%2C%22hash%22%3A%229F924E5A7C715E7294F298CD6C70722E0CA8DDCE%22%7D&cidade=padrao'], 'files': [{'checksum': '7be395bba9ab184614b067901091d411', 'path': '4101408/2024-05-22/bb5cbdaafa9e45c89343ec7ee3787544ba5102e3.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22526%22%2C%22hash%22%3A%229F924E5A7C715E7294F298CD6C70722E0CA8DDCE%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.386600Z', 'territory_id': '4101408'} 2024-06-17 13:19:50 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://apucarana.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%222%22%7D%7D) 2024-06-17 13:19:51 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:51 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:51 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-03. File Checksum: 3489c3eae5ab646ea6222844cc61a50b. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:51 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-03', 'edition_number': '9757', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22514%22%2C%22hash%22%3A%227B573F3C9FEB84E00654F87559A9ECE29259E153%22%7D&cidade=padrao'], 'files': [{'checksum': '3489c3eae5ab646ea6222844cc61a50b', 'path': '4101408/2024-05-03/13ea8b6c894f99ecd07a28a37fea967c41a35fca.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22514%22%2C%22hash%22%3A%227B573F3C9FEB84E00654F87559A9ECE29259E153%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.401840Z', 'territory_id': '4101408'} 2024-06-17 13:19:52 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:52 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:53 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-06. File Checksum: bc30a6099efe8b95fe6a13efc5477c61. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:53 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-06', 'edition_number': '9758', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22515%22%2C%22hash%22%3A%22CC858951B8AFCC730216197F73BE2B1EA63D6CE9%22%7D&cidade=padrao'], 'files': [{'checksum': 'bc30a6099efe8b95fe6a13efc5477c61', 'path': '4101408/2024-05-06/e7ca9b4bce919ca9d1547e4ae459f959e3fa3f42.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22515%22%2C%22hash%22%3A%22CC858951B8AFCC730216197F73BE2B1EA63D6CE9%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.400786Z', 'territory_id': '4101408'} 2024-06-17 13:19:54 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:54 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:54 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-02. File Checksum: f4e5b469613247db417a43532458b08e. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:54 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-02', 'edition_number': '9756', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22513%22%2C%22hash%22%3A%227DB3E97ECBC7E3FE1477E6CAE8B3CDBAECA03002%22%7D&cidade=padrao'], 'files': [{'checksum': 'f4e5b469613247db417a43532458b08e', 'path': '4101408/2024-05-02/a6b013bc5b412cdd69e393e006c8e94a11999f4d.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22513%22%2C%22hash%22%3A%227DB3E97ECBC7E3FE1477E6CAE8B3CDBAECA03002%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.402935Z', 'territory_id': '4101408'} 2024-06-17 13:19:56 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:56 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:56 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-20. File Checksum: efd7044b900b86323cc7218be269e882. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:56 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-20', 'edition_number': '9768', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22525%22%2C%22hash%22%3A%2283D12330D4414A010EBEB5CDA27EDCC55714CD90%22%7D&cidade=padrao'], 'files': [{'checksum': 'efd7044b900b86323cc7218be269e882', 'path': '4101408/2024-05-20/f91428dd02b8f78635fce4be85dc61b6a6f0444e.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22525%22%2C%22hash%22%3A%2283D12330D4414A010EBEB5CDA27EDCC55714CD90%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.388425Z', 'territory_id': '4101408'} 2024-06-17 13:19:57 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:57 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:57 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-07. File Checksum: 7e4a3c7f149ae3eac66a1e8626d2b066. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:57 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-07', 'edition_number': '9759', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22516%22%2C%22hash%22%3A%22A702F64C6FEA5A669A465B925A57542C269A7C55%22%7D&cidade=padrao'], 'files': [{'checksum': '7e4a3c7f149ae3eac66a1e8626d2b066', 'path': '4101408/2024-05-07/1562d7bdcbdccc1c73fc5c5ae4c932b07fffc1f6.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22516%22%2C%22hash%22%3A%22A702F64C6FEA5A669A465B925A57542C269A7C55%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.399720Z', 'territory_id': '4101408'} 2024-06-17 13:19:57 [scrapy.core.engine] DEBUG: Crawled (200) (referer: None) 2024-06-17 13:19:57 [scrapy.pipelines.files] DEBUG: File (downloaded): Downloaded file from referred in 2024-06-17 13:19:57 [pr_apucarana] WARNING: Something wrong has happened when adding the gazette in the database. Date: 2024-05-10. File Checksum: 0b78fac3e2270f81bf1a5b3f267da3f6. Details: ('(sqlite3.IntegrityError) UNIQUE constraint failed: gazettes.territory_id, gazettes.date, gazettes.file_checksum',) 2024-06-17 13:19:57 [scrapy.core.scraper] DEBUG: Scraped from <200 https://apucarana.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%222%22%7D%7D> {'date': '2024-05-10', 'edition_number': '9762', 'file_urls': ['https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22519%22%2C%22hash%22%3A%22A8CACBCD6244BFA028D8162CD4FFAFE1D07101DB%22%7D&cidade=padrao'], 'files': [{'checksum': '0b78fac3e2270f81bf1a5b3f267da3f6', 'path': '4101408/2024-05-10/27967ce8a40a4805f2ab3de48f06eed8b5e97bdb.pdf', 'status': 'downloaded', 'url': 'https://apucarana.atende.net/atende.php?rot=54002&aca=737&processo=download¶metro=%7B%22codigo%22%3A%22519%22%2C%22hash%22%3A%22A8CACBCD6244BFA028D8162CD4FFAFE1D07101DB%22%7D&cidade=padrao'}], 'is_extra_edition': False, 'power': 'executive_legislative', 'scraped_at': '2024-06-17T16:19:16.396403Z', 'territory_id': '4101408'} 2024-06-17 13:19:57 [scrapy.core.engine] INFO: Closing spider (finished) 2024-06-17 13:19:57 [scrapy.extensions.feedexport] INFO: Stored csv feed (19 items) in: pr_apucarana_intervalo_maio_24.csv 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] ------------------------------ MONITORS ------------------------------ 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] Comparison Between Executions/Days without gazettes... OK 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] Requests/Items Ratio/Ratio of requests over items scraped count... OK 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] Error Count Monitor/test_stat_monitor... SKIPPED (Unable to find 'log_count/ERROR' in job stats.) 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] Finish Reason Monitor/Should have the expected finished reason(s)... OK 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] Item Validation Monitor/test_stat_monitor... SKIPPED (Unable to find 'spidermon/validation/fields/errors' in job stats.) 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] 5 monitors in 0.014s 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] OK (skipped=2) 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] -------------------------- FINISHED ACTIONS -------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] 0 actions in 0.000s 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] OK 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] --------------------------- PASSED ACTIONS --------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] 0 actions in 0.000s 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] OK 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] --------------------------- FAILED ACTIONS --------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] ---------------------------------------------------------------------- 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] 1 action in 0.000s 2024-06-17 13:19:57 [pr_apucarana] INFO: [Spidermon] OK (skipped=1) 2024-06-17 13:19:57 [scrapy.statscollectors] INFO: Dumping Scrapy stats: {'downloader/request_bytes': 11201, 'downloader/request_count': 22, 'downloader/request_method_count/GET': 22, 'downloader/response_bytes': 213660487, 'downloader/response_count': 22, 'downloader/response_status_count/200': 22, 'elapsed_time_seconds': 43.08376, 'feedexport/success_count/FileFeedStorage': 1, 'file_count': 19, 'file_status_count/downloaded': 19, 'finish_reason': 'finished', 'finish_time': datetime.datetime(2024, 6, 17, 16, 19, 57, 685486, tzinfo=datetime.timezone.utc), 'httpcompression/response_bytes': 74214, 'httpcompression/response_count': 3, 'item_scraped_count': 19, 'log_count/DEBUG': 64, 'log_count/INFO': 34, 'log_count/WARNING': 20, 'memusage/max': 123105280, 'memusage/startup': 123105280, 'request_depth_max': 2, 'response_received_count': 22, 'scheduler/dequeued': 3, 'scheduler/dequeued/memory': 3, 'scheduler/enqueued': 3, 'scheduler/enqueued/memory': 3, 'spidermon/validation/fields': 152, 'spidermon/validation/items': 19, 'spidermon/validation/validators': 1, 'spidermon/validation/validators/item/jsonschema': True, 'start_time': datetime.datetime(2024, 6, 17, 16, 19, 14, 601726, tzinfo=datetime.timezone.utc)} 2024-06-17 13:19:57 [scrapy.core.engine] INFO: Spider closed (finished)