Custom Query (1173 matches)
Results (220 - 222 of 1173)
| Ticket | Resolution | Summary | Owner | Reporter |
|---|---|---|---|---|
| #5324 | no-action | Sql alchemy doesn't handle broken databases | ||
| Description |
My When trying to execute a new dbupdate, I've come across this: -> Updating main mediagoblin tables:
+ Running migration 24, "activity_migration"... Traceback (most recent call last):
File "./bin/gmg", line 9, in <module>
load_entry_point('mediagoblin==0.8.0', 'console_scripts', 'gmg')()
File "/srv/biblioteca/biblioteca.pirata.xyz/mediagoblin/gmg_commands/__init__.py", line 142, in main_cli
args.func(args)
File "/srv/biblioteca/biblioteca.pirata.xyz/mediagoblin/gmg_commands/dbupdate.py", line 160, in dbupdate
run_dbupdate(app_config, global_config)
File "/srv/biblioteca/biblioteca.pirata.xyz/mediagoblin/gmg_commands/dbupdate.py", line 128, in run_dbupdate
run_all_migrations(db, app_config, global_config)
File "/srv/biblioteca/biblioteca.pirata.xyz/mediagoblin/gmg_commands/dbupdate.py", line 155, in run_all_migrations
migration_manager.init_or_migrate()
File "/srv/biblioteca/biblioteca.pirata.xyz/mediagoblin/db/migration_tools.py", line 288, in init_or_migrate
migration_func(self.session)
File "/srv/biblioteca/biblioteca.pirata.xyz/mediagoblin/db/migrations.py", line 944, in activity_migration
ActivityIntermediator_R0.__table__.create(db.bind)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/schema.py", line 616, in create
checkfirst=checkfirst)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1479, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1122, in _run_visitor
**kwargs).traverse_single(element)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/sql/visitors.py", line 122, in traverse_single
return meth(obj, **kw)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/ddl.py", line 89, in visit_table
self.connection.execute(schema.CreateTable(table))
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 662, in execute
params)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 720, in _execute_ddl
compiled
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 874, in _execute_context
context)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
exc_info
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/util/compat.py", line 196, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 867, in _execute_context
context)
File "/srv/biblioteca/biblioteca.pirata.xyz/local/lib/python2.7/site-packages/SQLAlchemy-0.8.7-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py", line 324, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation "core__activity_intermediators" already exists
'\nCREATE TABLE core__activity_intermediators (\n\tid SERIAL NOT NULL, \n\ttype VARCHAR NOT NULL, \n\tPRIMARY KEY (id)\n)\n\n' {}
I suppose the SQL statment from sqlalchemy should have a "IF_NOT_EXISTS" right after the "CREATE TABLE", but it doesn't. My db remains broken, and thus the instance. |
|||
| #5323 | fixed | Audio submission failing | ||
| Description |
Audio submission tests are failing right now in master. Right now this looks like: mediagoblin/tests/test_submission.py ................
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> traceback >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Traceback (most recent call last):
File "/home/cwebber/devel/mediagoblin/mediagoblin/tests/test_submission.py", line 377, in test_audio
self.check_normal_upload('Audio', path)
File "/home/cwebber/devel/mediagoblin/mediagoblin/tests/test_submission.py", line 121, in check_normal_upload
**self.upload_data(filename))
File "/home/cwebber/devel/mediagoblin/mediagoblin/tests/test_submission.py", line 92, in do_post
response.follow()
File "/home/cwebber/devel/mediagoblin/local/lib/python2.7/site-packages/WebTest-1.4.3-py2.7.egg/webtest/app.py", line 159, in follow
% self.status)
AssertionError: You can only follow redirect responses (not 200 OK)
However this error is misleading, looking at the response that is gotten back, the submission form has the error <p class="form_field_error">Sorry, I don't support that file type :(</p> The real problem is when submitting the procedurally generated audio, which fails to be sniffed for the audio type. In the discover() method in mediagoblin/media_types/tools.py when the last line runs, an exception is thrown: > /home/cwebber/devel/mediagoblin/mediagoblin/media_types/tools.py(43)discover() -> discoverer = GstPbutils.Discoverer.new(60 * Gst.SECOND) (Pdb) n > /home/cwebber/devel/mediagoblin/mediagoblin/media_types/tools.py(44)discover() -> return discoverer.discover_uri(uri) (Pdb) discoverer.discover_uri(uri) *** Error: gst-stream-error-quark: No valid frames decoded before end of stream (7) (Pdb) So that's where the error is occurring. I wonder if maybe the procedurally generated audio is less than a second, and that's causing the error? Or it could be something else... |
|||
| #5322 | fixed | Translations compilation fails | ||
| Description | ||||
Note:
See TracQuery
for help on using queries.
