Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.36 KB | None | 0 0
  1. Traceback (most recent call last):
  2. File "manage.py", line 292, in <module>
  3. cli()
  4. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 764, in __call__
  5. return self.main(*args, **kwargs)
  6. File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 557, in main
  7. return super(FlaskGroup, self).main(*args, **kwargs)
  8. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 717, in main
  9. rv = self.invoke(ctx)
  10. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
  11. return _process_result(sub_ctx.command.invoke(sub_ctx))
  12. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
  13. return _process_result(sub_ctx.command.invoke(sub_ctx))
  14. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 956, in invoke
  15. return ctx.invoke(self.callback, **ctx.params)
  16. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 555, in invoke
  17. return callback(*args, **kwargs)
  18. File "/usr/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
  19. return f(get_current_context(), *args, **kwargs)
  20. File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 412, in decorator
  21. return __ctx.invoke(f, *args, **kwargs)
  22. File "/usr/local/lib/python2.7/site-packages/click/core.py", line 555, in invoke
  23. return callback(*args, **kwargs)
  24. File "/code/similarity/manage.py", line 19, in add_metrics
  25. db.similarity.add_metrics(batch_size=batch_size)
  26. File "/code/db/similarity.py", line 40, in add_metrics
  27. submit_similarity_by_id(row["id"], metrics=metrics, connection=connection)
  28. File "/code/db/similarity.py", line 135, in submit_similarity_by_id
  29. insert_similarity(connection, id, vectors_info)
  30. File "/code/db/similarity.py", line 95, in insert_similarity
  31. connection.execute(query, params)
  32. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
  33. return meth(self, multiparams, params)
  34. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
  35. return connection._execute_clauseelement(self, multiparams, params)
  36. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
  37. distilled_params,
  38. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
  39. e, statement, parameters, cursor, context
  40. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
  41. util.raise_from_cause(sqlalchemy_exception, exc_info)
  42. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
  43. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  44. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
  45. cursor, statement, parameters, context
  46. File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
  47. cursor.execute(statement, parameters)
  48. sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column "mfccs" is of type double precision[] but expression is of type record
  49. LINE 18: (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  50. ^
  51. HINT: You will need to rewrite or cast the expression.
  52.  
  53. [SQL:
  54. INSERT INTO similarity (
  55. id,
  56. mfccs,
  57. mfccsw,
  58. gfccs,
  59. gfccsw,
  60. key,
  61. bpm,
  62. onsetrate,
  63. moods,
  64. instruments,
  65. dortmund,
  66. rosamerica,
  67. tzanetakis)
  68. VALUES (
  69. %(id)s,
  70. %(mfccs)s,
  71. %(mfccsw)s,
  72. %(gfccs)s,
  73. %(gfccsw)s,
  74. %(key)s,
  75. %(bpm)s,
  76. %(onsetrate)s,
  77. %(moods)s,
  78. %(instruments)s,
  79. %(dortmund)s,
  80. %(rosamerica)s,
  81. %(tzanetakis)s)
  82. ON CONFLICT (id)
  83. DO NOTHING
  84. ]
  85. [parameters: {'mfccsw': (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), 'instruments': (0.179228171706, 0.900771558285, 0.990711510181), 'bpm': (0.8852817827837376, 0.465055012951422), 'gfccsw': (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), 'rosamerica': (0.0568883195519, 0.718740284443, 0.0132432291284, 0.0109436586499, 0.00324274529703, 0.00300190248527, 0.192003265023, 0.00193662149832), 'gfccs': (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), 'tzanetakis': (0.0804266482592, 0.321710467339, 0.0536252483726, 0.160859629512, 0.0402149371803, 0.0804298371077, 0.0536201782525, 0.0643420740962, 0.0804299339652, 0.0643410608172), 'key': (6.123233995736766e-17, -1.0), 'dortmund': (2.0384117505e-08, 3.49227917695e-08, 2.0890572614e-06, 2.32902284125e-08, 1.21722067092e-07, 2.89254217023e-07, 2.15474249554e-10, 0.999997437, 2.01800770538e-10), 'mfccs': (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), 'id': 1000000, 'onsetrate': (-0.9835215527486577, 0.18079091591910632), 'moods': (0.169903963804, 0.329347163439, 1.16484097816e-05, 0.813150823116, 0.173156708479)}]
  86. (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement