Comments (9)
@ajpharrington So we've determined that this is an issue with new App Engine deployments and CloudSQL (not existing deployments that have already worked) -> we've assigned this bug to someone on the App Engine Infrastructure team to fix.
If you deploy your app and it works, it should continue to work. If one of your new deployments isn't working, you should be able to try again later and it will work.
from getting-started-python.
I described a potential solution (enabling Cloud SQL Admin API) here: #129 (comment)
from getting-started-python.
I was able to find a solution, so I will post it here for others:
I added the following to my yaml file. I think the main difference from the config, is that 'localhost' is omitted.
env_variables:
SQLALCHEMY_DATABASE_URI: >-
mysql+pymysql://user:password@/database?unix_socket=/cloudsql/project:us-central1:instance
from getting-started-python.
Interesting. @ryanmats can you see if you can reproduce? If so, we may need to update our connection strings.
from getting-started-python.
So I just tested this quite a few times and have gotten the error sometimes and a functional website other times. The error seems to be independent of whether or not I delete 'localhost' from the SQLALCHEMY_DATABASE_URI. I do know that CloudSQL has been having some flaky problems lately.
@ajpharrington Can you please do me a favor and try again both with and without localhost, back-to-back?
from getting-started-python.
@ryanmats I have tried again with and without 'localhost' in the connection string, and have found it does not make a difference. I even removed the env_variables from my yaml file, to check if the config file string works and it does. It is working as expected now, and I am not able to re-create the original error.
from getting-started-python.
@ajpharrington Thanks for checking. Several other developers have noticed issues like this recently, and we are looking into what could be the problem.
In the near future, please let us know if any already deployed and functional apps suddenly run into this bug. Trying to figure out if this is a CloudSQL issue or an App Engine issue. Thanks!
from getting-started-python.
@ryanmats I just followed the tutorial and I am consistently getting this error. I have tried making multiple new projects, fiddling with settings, however I still get the error with this codebase, as well as my actual app I am trying to deploy (that uses cloudsql).
Do you have any solutions or updates on this?
from getting-started-python.
@ajpharrington I tried your environment variable changes but they did not help.
from getting-started-python.
Related Issues (20)
- 'from google.cloud import store' should be 'datastore' HOT 1
- Error: google.auth.exceptions.DefaultCredentialsError: Could not automatically determine credentials. Please set GOOGLE_APPLICATION_CREDENTIALS HOT 2
- Cannot clone git synced repo from google cloud source repository HOT 1
- Folder column in the README is all 404's HOT 2
- bookshelf error on App Engine: "ImportError: cannot import name 'secure_filename' from 'werkzeug'" HOT 7
- testing: enable the Build Cop Bot HOT 1
- Cannot upload image HOT 1
- cleanup: snippet-bot full scan HOT 1
- Action Required: Fix Renovate Configuration
- Bookshelf requirements dependencies broken HOT 3
- 1-hello-world Directory won't exist HOT 3
- Conflicting dependencies in bookshelf app HOT 1
- issues following tutorial HOT 5
- Dependency Dashboard
- Add tests and automated CI HOT 3
- Update testing infrastructure to use Python 3.7 or higher
- Update the Ops Agent script via GitHub Workflow
- Update primary reviewer to python-samples-reviewers
- [email protected]/[email protected]
- Replace python-jose dependency HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from getting-started-python.