Re: 'python manage.py makemigrations' doesn't work. I'm using PostgreSQL

154 views
Skip to first unread message

Jakob Damgaard Møller

unread,
Mar 13, 2020, 11:00:18 AM3/13/20
to django-res...@googlegroups.com
Is the  psycopg2 package installed ?

On Fri, Mar 13, 2020 at 9:42 AM Hanen ben ramdhane <benramdh...@gmail.com> wrote:
 python manage.py makemigrations
Traceback (most recent call last):
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection
    self.connect()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\postgresql\base.py", line 185, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\psycopg2\__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "manage.py", line 21, in <module>
    main()
  File "manage.py", line 17, in main
    execute_from_command_line(sys.argv)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line
    utility.execute()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\__init__.py", line 395, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\base.py", line 328, in run_from_argv
    self.execute(*args, **cmd_options)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\base.py", line 369, in execute
    output = self.handle(*args, **options)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\base.py", line 83, in wrapped
    res = handle_func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\commands\makemigrations.py", line 101, in handle
    loader.check_consistent_history(connection)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\migrations\loader.py", line 283, in check_consistent_history
    applied = recorder.applied_migrations()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\migrations\recorder.py", line 76, in applied_migrations
    if self.has_table():
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\migrations\recorder.py", line 56, in has_table
    return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 260, in cursor
    return self._cursor()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 236, in _cursor
    self.ensure_connection()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection
    self.connect()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection
    self.connect()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\postgresql\base.py", line 185, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\psycopg2\__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError
(env)
ASUS@user MINGW64 ~/Desktop/PFE1/mon-nar-02-payment-terminal-supervision-system/MyServerApp/server (Branch_HBR)
$ python manage.py makemigrations
Traceback (most recent call last):
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection
    self.connect()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\postgresql\base.py", line 185, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\psycopg2\__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "manage.py", line 21, in <module>
    main()
  File "manage.py", line 17, in main
    execute_from_command_line(sys.argv)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\__init__.py", line 401, in execute_from_command_line
    utility.execute()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\__init__.py", line 395, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\base.py", line 328, in run_from_argv
    self.execute(*args, **cmd_options)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\base.py", line 369, in execute
    output = self.handle(*args, **options)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\base.py", line 83, in wrapped
    res = handle_func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\core\management\commands\makemigrations.py", line 101, in handle
    loader.check_consistent_history(connection)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\migrations\loader.py", line 283, in check_consistent_history
    applied = recorder.applied_migrations()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\migrations\recorder.py", line 76, in applied_migrations
    if self.has_table():
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\migrations\recorder.py", line 56, in has_table
    return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 260, in cursor
    return self._cursor()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 236, in _cursor
    self.ensure_connection()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection
    self.connect()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\utils.py", line 90, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 220, in ensure_connection
    self.connect()
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\base\base.py", line 197, in connect
    self.connection = self.get_new_connection(conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\utils\asyncio.py", line 26, in inner
    return func(*args, **kwargs)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\django\db\backends\postgresql\base.py", line 185, in get_new_connection
    connection = Database.connect(**conn_params)
  File "C:\Users\ASUS\Desktop\PFE1\mon-nar-02-payment-terminal-supervision-system\MyServerApp\env\lib\site-packages\psycopg2\__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError

pg.png

msa.png


--
You received this message because you are subscribed to the Google Groups "Django REST framework" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-rest-fram...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-rest-framework/3b1ebaf3-32cd-4281-8db7-dd81a087af60%40googlegroups.com.


--
Jakob Damgaard Olsen
Tlf: 24613112

Abdulfatah Mohamed

unread,
Mar 16, 2020, 12:26:32 PM3/16/20
to django-res...@googlegroups.com

It can be some issues:

  1. PostgreSQL is not running. Check it with sudo service postgresql status

  2. Your PostgresSQl is not running on port 5432. You can check it typing sudo netstat -nl | grep postgres

  3. You have something wrong trying to connect to your db like the username, the password or the databasename. Check that they are what postgres ask for you to connect it and that is the db_name that you want to access to.

  4. Problems with postmaster.pid in postgres. It can happen because of a shutdown unproperly done. It makes to remind a pid alive that doesn't allow your server start. To fix it you have to:

     * rm /usr/local/var/postgres/postmaster.pid 
 * pg_resetxlog -f /usr/local/var/postgres

    After this it should run properly if you make the runserver of postgres

Reply all
Reply to author
Forward
0 new messages