使用PostgreSQL数据库时uwsgi下的django应用程序无法启动 [英] django app under uwsgi failing to start when using postgresql database
问题描述
我在AWS上的 Ubuntu 14.04-> NGINX-> UWSGI-> DJANGO APP 中设置了一个应用. 使用sqllite3时，该应用程序运行完全正常，但是当我使用 django.db.backends.postgresql_psycopg2w 作为我的数据库引擎时，该应用程序无法加载，并且在uwsgi日志中发现了这一点:
I setup an app in Ubuntu 14.04 on AWS -> NGINX -> UWSGI -> DJANGO APP. The app runs completely fine when using sqllite3, but when I use django.db.backends.postgresql_psycopg2w as my database engine it fails to load and I find this in uwsgi logs:
- *** Starting uWSGI 2.0.12 (64bit) on [Mon Jan 18 05:36:25 2016] ***
- compiled with version: 4.8.4 on 18 January 2016 04:10:30
- os: Linux-3.13.0-48-generic #80-Ubuntu SMP Thu Mar 12 11:16:15 UTC 2015
- nodename: ip-172-31-55-58
- machine: x86_64
- clock source: unix
- detected number of CPU cores: 1
- current working directory: /var/www/carzumer_api
- detected binary path: /usr/local/bin/uwsgi
- !!! no internal routing support, rebuild with pcre support !!!
- setgid() to 33
- setuid() to 33
- chdir() to /var/www/carzumer_api/src/
- your processes number limit is 7862
- limiting address space of processes...
- your process address space limit is 134217728 bytes (128 MB)
- your memory page size is 4096 bytes
- *** WARNING: you have enabled harakiri without post buffering. Slow upload could be rejected on post-unbuffered webservers ***
- detected max file descriptor number: 1024
- lock engine: pthread robust mutexes
- thunder lock: disabled (you can enable it with --thunder-lock)
- uwsgi socket 0 bound to UNIX address /var/www/carzumer_api/run/uwsgi.sock fd 6
- Python version: 2.7.6 (default, Jun 22 2015, 18:01:27) [GCC 4.8.2]
- Set PythonHome to /var/www/carzumer_api/env
- *** Python threads support is disabled. You can enable it with --enable-threads ***
- Python main interpreter initialized at 0x2047200
- your server socket listen backlog is limited to 100 connections
- your mercy for graceful operations on workers is 60 seconds
- mapped 363840 bytes (355 KB) for 4 cores
- *** Operational MODE: preforking ***
Traceback (most recent call last):
File "./carzumer_api/wsgi.py", line 16, in <module>
application = get_wsgi_application()
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/core/wsgi.py", line 14, in get_wsgi_application
django.setup()
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/__init__.py", line 18, in setup
apps.populate(settings.INSTALLED_APPS)
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/apps/config.py", line 198, in import_models
self.models_module = import_module(models_module_name)
File "/usr/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/contrib/auth/models.py", line 41, in <module>
class Permission(models.Model):
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/models/base.py", line 139, in __new__
new_class.add_to_class('_meta', Options(meta, **kwargs))
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/models/base.py", line 324, in add_to_class
value.contribute_to_class(cls, name)
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/models/options.py", line 250, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/__init__.py", line 36, in __getattr__
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/utils.py", line 240, in __getitem__
backend = load_backend(db['ENGINE'])
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/usr/lib/python2.7/importlib/__init__.py", line 37, in import_module
__import__(name)
File "/var/www/carzumer_api/env/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 24, in <module>
raise ImproperlyConfigured("Error loading psycopg2 module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: libgpg-error.so.0: failed to map segment from shared object: Cannot allocate memory
- unable to load app 0 (mountpoint='') (callable not found or import error)
- *** no app loaded. going in full dynamic mode ***
- *** uWSGI is running in multiple interpreter mode ***
- spawned uWSGI master process (pid: 11351)
- spawned uWSGI worker 1 (pid: 11354, cores: 1)
- spawned uWSGI worker 2 (pid: 11355, cores: 1)
- --- no python application found, check your startup logs for errors ---
{address space usage: 81760256 bytes/77MB} {rss usage: 21651456 bytes/20MB} [pid: 11355|app: -1|req: -1/1] 127.0.0.1 () {32 vars in 351 bytes} [Mon Jan 18 05:37:50 2016] GET / => generated 21 bytes in 0 msecs (HTTP/1.1 500) 2 headers in 82 bytes (0 switches on core 0)
我已经使用apt-get安装了以下软件包: libpq-dev python-dev postgresql postgresql-contrib nginx python-pip
I have installed the following packages using apt-get: libpq-dev python-dev postgresql postgresql-contrib nginx python-pip
Also the psycopg2==2.6.1 package is installed in my venv.
有人能指出我正确的方向吗?我已经搜索了几个小时，却不知道为什么会失败.
Can anyone point me in the right direction, I have searched for hours now and have no idea why it's failing.
推荐答案
我终于弄清楚了我的问题所在.在我的uwsgi.ini文件中，我有
I finally figured out what my problem was. In my uwsgi.ini file I had
limit-as = 128
此开关将uwsgi进程的地址空间限制为128mb.我想这对于PostgreSQL驱动程序还不够.拆下开关后，一切都像灵符一样工作. 尽管最好找到一个有效的值，而不是完全删除该值.
This switch limits the address space of uwsgi process to 128mb. I guess that was not enough for PostgreSQL driver. After removing the switch everything works like a charm. Although it's better to find a value that works instead of just removing the value altogether.
这篇关于使用PostgreSQL数据库时uwsgi下的django应用程序无法启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
