Skip to content

Instantly share code, notes, and snippets.

@alikins

alikins/querythatfails

Created August 18, 2020 12:58
Show Gist options
  • Save alikins/b1c01e772365d28dcd7c39d5e5b69b0c to your computer and use it in GitHub Desktop.
Save alikins/b1c01e772365d28dcd7c39d5e5b69b0c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
querythatfails
worker_1 | SELECT T7."pulp_id",
worker_1 | T7."pulp_created",
worker_1 | T7."pulp_last_updated",
worker_1 | T7."pulp_type",
worker_1 | T7."upstream_id",
worker_1 | "ansible_collectionversion"."content_ptr_id",
worker_1 | "ansible_collectionversion"."authors",
worker_1 | "ansible_collectionversion"."contents",
worker_1 | "ansible_collectionversion"."dependencies",
worker_1 | "ansible_collectionversion"."description",
worker_1 | "ansible_collectionversion"."docs_blob",
worker_1 | "ansible_collectionversion"."documentation",
worker_1 | "ansible_collectionversion"."homepage",
worker_1 | "ansible_collectionversion"."issues",
worker_1 | "ansible_collectionversion"."license",
worker_1 | "ansible_collectionversion"."name",
worker_1 | "ansible_collectionversion"."namespace",
worker_1 | "ansible_collectionversion"."repository",
worker_1 | "ansible_collectionversion"."version",
worker_1 | "ansible_collectionversion"."is_highest",
worker_1 | "ansible_collectionversion"."certification",
worker_1 | "ansible_collectionversion"."collection_id",
worker_1 | "ansible_collectionversion"."search_vector"
worker_1 | FROM "ansible_collectionversion"
worker_1 | INNER JOIN "ansible_collection" ON ("ansible_collectionversion"."collection_id" = "ansible_collection"."pulp_id")
worker_1 | INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id")
worker_1 | INNER JOIN "core_repositorycontent" ON ("core_content"."pulp_id" = "core_repositorycontent"."content_id")
worker_1 | INNER JOIN "core_content" T7 ON ("ansible_collectionversion"."content_ptr_id" = T7."pulp_id")
worker_1 | LEFT OUTER JOIN "core_repositorycontent" T8 ON (T7."pulp_id" = T8."content_id")
worker_1 | WHERE ("ansible_collection"."namespace" IN
worker_1 | (SELECT U0."id"
worker_1 | FROM "galaxy_namespace" U0
worker_1 | INNER JOIN "galaxy_synclist_namespaces" U1 ON (U0."id" = U1."namespace_id")
worker_1 | WHERE U1."synclist_id" = 181)
worker_1 | AND "ansible_collectionversion"."is_highest" = TRUE
worker_1 | AND "core_repositorycontent"."repository_id" = 'be47fc18-87b9-46c0-aa7f-e38183e57e04'::UUID
worker_1 | AND "ansible_collectionversion"."collection_id" IN
worker_1 | (SELECT U0."pulp_id"
worker_1 | FROM "ansible_collection" U0
worker_1 | INNER JOIN "galaxy_synclist_collections" U1 ON (U0."pulp_id" = U1."collection_id")
worker_1 | WHERE U1."synclist_id" = 181)
worker_1 | AND T8."repository_id" = 'ddc31cc8-7ea8-4e92-8467-807c0459ce60'::UUID)
worker_1 | ERROR 2020-08-18 12:53:21,369 rq.worker worker.handle_exception:984 109 django.db.utils.ProgrammingError: operator does not exist: character varying = integer
worker_1 | LINE 1: ...tent_id") WHERE ("ansible_collection"."namespace" IN (SELECT...
worker_1 | ^
worker_1 | HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
worker_1 |
worker_1 | Traceback (most recent call last):
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
worker_1 | return self.cursor.execute(sql, params)
worker_1 | psycopg2.errors.UndefinedFunction: operator does not exist: character varying = integer
worker_1 | LINE 1: ...tent_id") WHERE ("ansible_collection"."namespace" IN (SELECT...
worker_1 | ^
worker_1 | HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
worker_1 |
worker_1 |
worker_1 | The above exception was the direct cause of the following exception:
worker_1 |
worker_1 | Traceback (most recent call last):
worker_1 | File "/venv/lib64/python3.6/site-packages/rq/worker.py", line 934, in perform_job
worker_1 | rv = job.perform()
worker_1 | File "/venv/lib64/python3.6/site-packages/rq/job.py", line 686, in perform
worker_1 | self._result = self._execute()
worker_1 | File "/venv/lib64/python3.6/site-packages/rq/job.py", line 692, in _execute
worker_1 | return self.func(*self.args, **self.kwargs)
worker_1 | File "/src/galaxy_ng/galaxy_ng/app/tasks/synclist.py", line 160, in curate_synclist_repository
worker_1 | pf([x.natural_key() for x in collection_versions]))
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 274, in __iter__
worker_1 | self._fetch_all()
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 1242, in _fetch_all
worker_1 | self._result_cache = list(self._iterable_class(self))
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 55, in __iter__
worker_1 | results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py", line 1140, in execute_sql
worker_1 | cursor.execute(sql, params)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute
worker_1 | return super().execute(sql, params)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
worker_1 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
worker_1 | return executor(sql, params, many, context)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
worker_1 | return self.cursor.execute(sql, params)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
worker_1 | raise dj_exc_value.with_traceback(traceback) from exc_value
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
worker_1 | return self.cursor.execute(sql, params)
worker_1 | django.db.utils.ProgrammingError: operator does not exist: character varying = integer
worker_1 | LINE 1: ...tent_id") WHERE ("ansible_collection"."namespace" IN (SELECT...
worker_1 | ^
worker_1 | HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
worker_1 |
worker_1 |
worker_1 | Traceback (most recent call last):
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
worker_1 | return self.cursor.execute(sql, params)
worker_1 | psycopg2.errors.UndefinedFunction: operator does not exist: character varying = integer
worker_1 | LINE 1: ...tent_id") WHERE ("ansible_collection"."namespace" IN (SELECT...
worker_1 | ^
worker_1 | HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
worker_1 |
worker_1 |
worker_1 | The above exception was the direct cause of the following exception:
worker_1 |
worker_1 | Traceback (most recent call last):
worker_1 | File "/venv/lib64/python3.6/site-packages/rq/worker.py", line 934, in perform_job
worker_1 | rv = job.perform()
worker_1 | File "/venv/lib64/python3.6/site-packages/rq/job.py", line 686, in perform
worker_1 | self._result = self._execute()
worker_1 | File "/venv/lib64/python3.6/site-packages/rq/job.py", line 692, in _execute
worker_1 | return self.func(*self.args, **self.kwargs)
worker_1 | File "/src/galaxy_ng/galaxy_ng/app/tasks/synclist.py", line 160, in curate_synclist_repository
worker_1 | pf([x.natural_key() for x in collection_versions]))
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 274, in __iter__
worker_1 | self._fetch_all()
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 1242, in _fetch_all
worker_1 | self._result_cache = list(self._iterable_class(self))
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 55, in __iter__
worker_1 | results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py", line 1140, in execute_sql
worker_1 | cursor.execute(sql, params)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute
worker_1 | return super().execute(sql, params)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
worker_1 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
worker_1 | return executor(sql, params, many, context)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
worker_1 | return self.cursor.execute(sql, params)
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
worker_1 | raise dj_exc_value.with_traceback(traceback) from exc_value
worker_1 | File "/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
worker_1 | return self.cursor.execute(sql, params)
worker_1 | django.db.utils.ProgrammingError: operator does not exist: character varying = integer
worker_1 | LINE 1: ...tent_id") WHERE ("ansible_collection"."namespace" IN (SELECT...
worker_1 | ^
worker_1 | HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
worker_1 |
worker_1 |
Raw
querythatworks
SELECT T7."pulp_id",
T7."pulp_created",
T7."pulp_last_updated",
T7."pulp_type",
T7."upstream_id",
"ansible_collectionversion"."content_ptr_id",
"ansible_collectionversion"."authors",
"ansible_collectionversion"."contents",
"ansible_collectionversion"."dependencies",
"ansible_collectionversion"."description",
"ansible_collectionversion"."docs_blob",
"ansible_collectionversion"."documentation",
"ansible_collectionversion"."homepage",
"ansible_collectionversion"."issues",
"ansible_collectionversion"."license",
"ansible_collectionversion"."name",
"ansible_collectionversion"."namespace",
"ansible_collectionversion"."repository",
"ansible_collectionversion"."version",
"ansible_collectionversion"."is_highest",
"ansible_collectionversion"."certification",
"ansible_collectionversion"."collection_id",
"ansible_collectionversion"."search_vector"
FROM "ansible_collectionversion"
INNER JOIN "ansible_collection" ON ("ansible_collectionversion"."collection_id" = "ansible_collection"."pulp_id")
INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id")
INNER JOIN "core_repositorycontent" ON ("core_content"."pulp_id" = "core_repositorycontent"."content_id")
INNER JOIN "core_content" T7 ON ("ansible_collectionversion"."content_ptr_id" = T7."pulp_id")
LEFT OUTER JOIN "core_repositorycontent" T8 ON (T7."pulp_id" = T8."content_id")
WHERE ("ansible_collection"."namespace" IN
(SELECT U0."name"
FROM "galaxy_namespace" U0
INNER JOIN "galaxy_synclist_namespaces" U1 ON (U0."id" = U1."namespace_id")
WHERE U1."synclist_id" = 189)
AND "ansible_collectionversion"."is_highest" = TRUE
AND "core_repositorycontent"."repository_id" = 'be47fc18-87b9-46c0-aa7f-e38183e57e04'::UUID
AND "ansible_collectionversion"."collection_id" IN
(SELECT U0."pulp_id"
FROM "ansible_collection" U0
INNER JOIN "galaxy_synclist_collections" U1 ON (U0."pulp_id" = U1."collection_id")
WHERE U1."synclist_id" = 189)
AND T8."repository_id" = 'af625c2c-9514-4d5b-9ce3-bb11ae7a4fb1'::UUID)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment