Skip to content

Instantly share code, notes, and snippets.

@emtwo
Created April 22, 2020 21:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save emtwo/40f0b79f66ee0094657ded604e67473b to your computer and use it in GitHub Desktop.
Save emtwo/40f0b79f66ee0094657ded604e67473b to your computer and use it in GitHub Desktop.
04/22/20 20:21:52 - Creating temp table for import: tmp_import_release.
04/22/20 20:21:53 - Copying GCS file glam-extract-firefox-release-000000000000.csv to local file /tmp/tmpflts164r.
04/22/20 20:25:01 - Importing file into temp table.
Traceback (most recent call last):
File "./manage.py", line 11, in <module>
execute_from_command_line(sys.argv)
File "/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 401, in execute_from_command_line
utility.execute()
File "/venv/lib/python3.8/site-packages/django/core/management/__init__.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/venv/lib/python3.8/site-packages/django/core/management/base.py", line 328, in run_from_argv
self.execute(*args, **cmd_options)
File "/venv/lib/python3.8/site-packages/django/core/management/base.py", line 369, in execute
output = self.handle(*args, **options)
File "/app/glam/api/management/commands/import_aggs.py", line 60, in handle
self.import_file(tmp_table, fp)
File "/app/glam/api/management/commands/import_aggs.py", line 108, in import_file
cursor.copy_expert(sql, tmp_file)
File "/venv/lib/python3.8/site-packages/django/db/backends/postgresql/base.py", line 322, in copy_expert
return self.cursor.copy_expert(sql, file, *args)
psycopg2.errors.InvalidTextRepresentation: invalid input syntax for integer: "channel"
CONTEXT: COPY tmp_import_release, line 1, column channel: "channel"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment