SQL SQLAlchemy issue keep happened

Imefungwa Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua

$30-250 USD

Kulipwa wakati wa kujifungua

Imefungwa Kulipwa wakati wa kujifungua

I have a bot that almost finished but only one bug haven't found solution yet, I need someone to fix this issue.

This is a bot that will keep visit specific website and rotate IP each time.

Bot was written in Python 3 using latest beta ChromeDriver 76.0.3809.68, stable versions were previously used but the issue was keep reproducing.

App is concurrently run Chrome Driver to emulate traffic visits on projects on [login to view URL] website.

Currently there are 5 threads that are using StormProxies service for IP hiding.

One of the solutions to avoid running out of memory in case of broken proxies and hanging Chrome session was to run ‘killall chrome’ every 2 hours. To implement this task cron task was created

1. crontab -e

2. 0 */2 * * * killall chrome

After migration from SQLite to Postgres after some period (not permanent) of bot execution it hangs with following SQLAlchemy errors:

1. 2019-06-18 00:37:05 : rank_project : This session is in 'prepared' state; no further SQL can be emitted within this transaction.

2. 2019-07-16 02:28:32 : rank_project : Instance '<AccountRankTask at 0x7f4828acca90>' is not persistent within this Session

To solve this errors different variations of DB engine and Session options was applied but none of them actually resolved an issue.

Migration was done since SQLite was not able handle multiple transactions due to it lightweight architecture that lock DB file for writing (current errors ‘OperationalError: database is locked’ began to appear)

Python MySQL Selenium Webdriver

Kitambulisho cha Mradi: #20580447

Kuhusu mradi

6 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

6 wafanyakazi huru wanazabuni wastani wa $142 kwa kazi hii

Picha ya Profaili ya adampohp79
adampohp79

Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Zaidi

$140 USD kwa siku 7
(Maoni 65)
6.1
Picha ya Profaili ya BlackEagle86
BlackEagle86

I am a Python,DataBase expert! I read your job description carefully and I can do your job perfectly. I have developed many pythons projects So I can know what you mean and I am ready for you now. If you hire me, I wil Zaidi

$140 USD kwa siku 7
(Maoni 9)
5.3
Picha ya Profaili ya sodiqa32
sodiqa32

Hello, I am pleasure with your job as detailed. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like Zaidi

$30 USD kwa siku 1
(Maoni 17)
5.3
Tuma Mradi Kama huu