Stack Overflow
Stack Overflow

Questions tagged [operationalerror]

85 questions
31
votes
5 answers

django.db.utils.OperationalError: fe_sendauth: no password supplied

I have cloned a repo from github and working on it. The project was in django and using postgres as database. This project is now on the production side and I need to make some changes to it. The database specs is : DATABASES = { 'default': { …
the_unknown_spirit
  • 2,518
  • 7
  • 34
  • 56
15
votes
1 answer

How to increase connection timeout using sqlalchemy with sqlite in python

I am using sqlite (v2.6.0) as database backend and using sqlalchemy(v0.7.9) to operate it. Recently I got a error OperationalError: (OperationalError) database is locked By searching stackoverflow a possible solution is to increase the timeout of a…
user1817188
  • 487
  • 1
  • 7
  • 14
14
votes
2 answers

MySQL OperationalError when running a Flask server (Apache) for some days

I have a Flask server under Apache which I'm using as a Rest API for an app and when the server is running for 2 - 3 days it suddenly stops working and raises OperationalError: MySQL Connection not available. The error always happens at the login…
Grender
  • 1,589
  • 2
  • 17
  • 44
7
votes
2 answers

python: sqlalchemy - how do I ensure connection not stale using new event system

I am using the sqlalchemy package in python. I have an operation that takes some time to execute after I perform an autoload on an existing table. This causes the following error when I attempt to use the connection: sqlalchemy.exc.OperationalError:…
codingknob
  • 11,108
  • 25
  • 89
  • 126
6
votes
6 answers

Operational Error No such table Django

Hi I am doing the djangogirls tutorial and have come across the OperationalError no such table: blog_post. This works perfect on my virtual environment, but I get the OperationalError after pushing to heroku. I am using Django 1.7.7. More…
djangogirl
  • 81
  • 1
  • 5
3
votes
1 answer

How to fix this error django.db.utils.OperationalError: could not translate host name "db" to address . Docker

I am using Pyscopg. DOCKER-COMPOSE: version: '3.7' services: web: build: . command: python3 /code/manage.py runserver 0.0.0.0:8000 volumes: - .:/code ports: - 8000:8000 depends_on: - db2 db2: image:…
Vlad Malinovski
  • 51
  • 1
  • 3
3
votes
1 answer

Getting "sqlite3.OperationalError: no such column:"

I am new to python (as I am sure you can tell from my code) and have basically written a sample script to test some core commands so I can better understand how things work. I have gotten everything running as designed except the last "insert"…
Oldtimer
  • 45
  • 1
  • 5
3
votes
0 answers

mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')

I got this error when I execute my query File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in…
parik
  • 2,313
  • 12
  • 39
  • 67
2
votes
1 answer

psycopg2.OperationalError: could not translate host name "
" to address: Temporary failure in name resolution

I have looked through similar posts on SO and they seem to be specific to using Docker environments and haven't been much helpful. Ours is a little different, we do run a docker image of Airflow hosted on Azure App Service but it connects to hosted…
Vinay Kulkarni
  • 300
  • 1
  • 5
  • 13
2
votes
4 answers

OperationalError: no such module: fts4

Hi I´ve tried to run a fuzzymatcher code and the error below pops up: OperationalError: no such module: fts4 Any suggestions? Thanks in advance Edit: I've already tried downloading the sqlite zip from the website and saving it in DLLs files but it…
Arleth
  • 49
  • 2
  • 4
2
votes
0 answers

flask-sqlalchemy rollback best practices

I am trying to find some clarity on the best practices for where in a flask application database errors should best be handled and rollback should be performed. I have looked through the SQLAlchemy docs and I have not found any recommendations on…
dirtAndCoffee
  • 36
  • 2
2
votes
1 answer

sqlite3.connect not working with relative path

While using a relative path, I'm getting an error with Sqlite3: OperationalError: unable to open database file, But with an absolute path it works well. Below are the samples: #database_filepath = 'Data/DatabaseFile.db' def…
Chintan Upadhyay
  • 31
  • 1
  • 4
2
votes
1 answer

OperationalError: near "%": syntax error with sqlite3 in Python

I'm using the sqlite3 package in Python and trying to select a single entry from a table called orders. I would like to get the entry where the value for column order_date ends in 18 (it's a varchar column where the actual value of this entry is…
conveniencesample
  • 23
  • 4
2
votes
1 answer

Flask - SQLAlchemy OperationalError

I've come into the following error: sqlalchemy.exc.OperationalError OperationalError: (OperationalError) no such table: user u'SELECT user.id AS user_id, user.name AS user_name, user.password AS user_password \nFROM user \nWHERE user.id = ?'…
phouse512
  • 650
  • 4
  • 15
  • 27
2
votes
2 answers

operational error - no such table - Django, mptt

I'm running into a DB related problem in Django that I don't understand. I define an MPTT model like so: class Image(MPTTModel): name = models.CharField(max_length=50) parent = TreeForeignKey('self', null=True, blank=True,…
David J.
  • 1,753
  • 13
  • 47
  • 96
1
2 3 4 5 6