Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Traceback (most recent call last):
- File "manage.py", line 292, in <module>
- cli()
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 764, in __call__
- return self.main(*args, **kwargs)
- File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 557, in main
- return super(FlaskGroup, self).main(*args, **kwargs)
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 717, in main
- rv = self.invoke(ctx)
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
- return _process_result(sub_ctx.command.invoke(sub_ctx))
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1137, in invoke
- return _process_result(sub_ctx.command.invoke(sub_ctx))
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 956, in invoke
- return ctx.invoke(self.callback, **ctx.params)
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 555, in invoke
- return callback(*args, **kwargs)
- File "/usr/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func
- return f(get_current_context(), *args, **kwargs)
- File "/usr/local/lib/python2.7/site-packages/flask/cli.py", line 412, in decorator
- return __ctx.invoke(f, *args, **kwargs)
- File "/usr/local/lib/python2.7/site-packages/click/core.py", line 555, in invoke
- return callback(*args, **kwargs)
- File "/code/similarity/manage.py", line 19, in add_metrics
- db.similarity.add_metrics(batch_size=batch_size)
- File "/code/db/similarity.py", line 40, in add_metrics
- submit_similarity_by_id(row["id"], metrics=metrics, connection=connection)
- File "/code/db/similarity.py", line 135, in submit_similarity_by_id
- insert_similarity(connection, id, vectors_info)
- File "/code/db/similarity.py", line 95, in insert_similarity
- connection.execute(query, params)
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
- return meth(self, multiparams, params)
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
- distilled_params,
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
- e, statement, parameters, cursor, context
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
- util.raise_from_cause(sqlalchemy_exception, exc_info)
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
- reraise(type(exception), exception, tb=exc_tb, cause=cause)
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
- cursor, statement, parameters, context
- File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
- cursor.execute(statement, parameters)
- sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column "mfccs" is of type double precision[] but expression is of type record
- LINE 18: (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
- ^
- HINT: You will need to rewrite or cast the expression.
- [SQL:
- INSERT INTO similarity (
- id,
- mfccs,
- mfccsw,
- gfccs,
- gfccsw,
- key,
- bpm,
- onsetrate,
- moods,
- instruments,
- dortmund,
- rosamerica,
- tzanetakis)
- VALUES (
- %(id)s,
- %(mfccs)s,
- %(mfccsw)s,
- %(gfccs)s,
- %(gfccsw)s,
- %(key)s,
- %(bpm)s,
- %(onsetrate)s,
- %(moods)s,
- %(instruments)s,
- %(dortmund)s,
- %(rosamerica)s,
- %(tzanetakis)s)
- ON CONFLICT (id)
- DO NOTHING
- ]
- [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)}]
- (Background on this error at: http://sqlalche.me/e/f405)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement