Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2020
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.63 KB | None | 0 0
  1. LEFT OUTER JOIN core_page page ON (doc.basetreenode_ptr_id = page.document_id),
  2. LEFT OUTER JOIN django_content_type ctype ON (ctype.id = node.polymorphic_ctype_id),
  3. WHERE ctype.model = 'document';,
  4. ,
  5. ,
  6. DROP VIEW IF EXISTS node_access;,
  7. CREATE OR REPLACE VIEW node_access AS,
  8. SELECT,
  9. u.username,,
  10. n.id as node_id,,
  11. n.title as node_title,,
  12. acc.id as access_id,,
  13. acc.access_type,,
  14. acc.access_inherited,,
  15. perm.codename,,
  16. perm.id as perm_id,
  17. FROM core_basetreenode n,
  18. LEFT JOIN core_access acc ON n.id = acc.node_id,
  19. LEFT JOIN core_user u ON u.id = n.user_id,
  20. LEFT JOIN core_access_permissions acc_perm ON acc_perm.access_id = acc.id,
  21. LEFT JOIN auth_permission perm ON perm.id = acc_perm.permission_id,
  22. ORDER BY u.username, n.title;,
  23. ,
  24. DROP VIEW IF EXISTS table_size;,
  25. CREATE OR REPLACE VIEW table_size AS,
  26. SELECT ,
  27. schemaname AS table_schema,,
  28. relname AS table_name,,
  29. pg_size_pretty(pg_total_relation_size(relid)) AS total_size,,
  30. pg_size_pretty(pg_relation_size(relid)) AS data_size,,
  31. pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) AS external_size,
  32. FROM pg_catalog.pg_statio_user_tables,
  33. ORDER BY pg_total_relation_size(relid) DESC, pg_relation_size(relid) DESC;,
  34. Exception in thread django-main-thread:,
  35. Traceback (most recent call last):,
  36. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 220, in ensure_connection,
  37. self.connect(),
  38. File "/usr/local/lib/python3.7/dist-packages/django/utils/asyncio.py", line 26, in inner,
  39. return func(*args, **kwargs),
  40. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 197, in connect,
  41. self.connection = self.get_new_connection(conn_params),
  42. File "/usr/local/lib/python3.7/dist-packages/django/utils/asyncio.py", line 26, in inner,
  43. return func(*args, **kwargs),
  44. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/postgresql/base.py", line 185, in get_new_connection,
  45. connection = Database.connect(**conn_params),
  46. File "/usr/local/lib/python3.7/dist-packages/psycopg2/__init__.py", line 126, in connect,
  47. conn = _connect(dsn, connection_factory=connection_factory, **kwasync),
  48. psycopg2.OperationalError: could not translate host name "db" to address: No address associated with hostname,
  49. ,
  50. ,
  51. The above exception was the direct cause of the following exception:,
  52. ,
  53. Traceback (most recent call last):,
  54. File "/usr/lib/python3.7/threading.py", line 926, in _bootstrap_inner,
  55. self.run(),
  56. File "/usr/lib/python3.7/threading.py", line 870, in run,
  57. self._target(*self._args, **self._kwargs),
  58. File "/usr/local/lib/python3.7/dist-packages/django/utils/autoreload.py", line 53, in wrapper,
  59. fn(*args, **kwargs),
  60. File "/usr/local/lib/python3.7/dist-packages/django/core/management/commands/runserver.py", line 120, in inner_run,
  61. self.check_migrations(),
  62. File "/usr/local/lib/python3.7/dist-packages/django/core/management/base.py", line 458, in check_migrations,
  63. executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS]),
  64. File "/usr/local/lib/python3.7/dist-packages/django/db/migrations/executor.py", line 18, in __init__,
  65. self.loader = MigrationLoader(self.connection),
  66. File "/usr/local/lib/python3.7/dist-packages/django/db/migrations/loader.py", line 49, in __init__,
  67. self.build_graph(),
  68. File "/usr/local/lib/python3.7/dist-packages/django/db/migrations/loader.py", line 212, in build_graph,
  69. self.applied_migrations = recorder.applied_migrations(),
  70. File "/usr/local/lib/python3.7/dist-packages/django/db/migrations/recorder.py", line 76, in applied_migrations,
  71. if self.has_table():,
  72. File "/usr/local/lib/python3.7/dist-packages/django/db/migrations/recorder.py", line 56, in has_table,
  73. return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()),
  74. File "/usr/local/lib/python3.7/dist-packages/django/utils/asyncio.py", line 26, in inner,
  75. return func(*args, **kwargs),
  76. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 260, in cursor,
  77. return self._cursor(),
  78. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 236, in _cursor,
  79. self.ensure_connection(),
  80. File "/usr/local/lib/python3.7/dist-packages/django/utils/asyncio.py", line 26, in inner,
  81. return func(*args, **kwargs),
  82. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 220, in ensure_connection,
  83. self.connect(),
  84. File "/usr/local/lib/python3.7/dist-packages/django/db/utils.py", line 90, in __exit__,
  85. raise dj_exc_value.with_traceback(traceback) from exc_value,
  86. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 220, in ensure_connection,
  87. self.connect(),
  88. File "/usr/local/lib/python3.7/dist-packages/django/utils/asyncio.py", line 26, in inner,
  89. return func(*args, **kwargs),
  90. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/base/base.py", line 197, in connect,
  91. self.connection = self.get_new_connection(conn_params),
  92. File "/usr/local/lib/python3.7/dist-packages/django/utils/asyncio.py", line 26, in inner,
  93. return func(*args, **kwargs),
  94. File "/usr/local/lib/python3.7/dist-packages/django/db/backends/postgresql/base.py", line 185, in get_new_connection,
  95. connection = Database.connect(**conn_params),
  96. File "/usr/local/lib/python3.7/dist-packages/psycopg2/__init__.py", line 126, in connect,
  97. conn = _connect(dsn, connection_factory=connection_factory, **kwasync),
  98. django.db.utils.OperationalError: could not translate host name "db" to address: No address associated with hostname,
  99. ,
  100. ,
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement