I have a user who was getting server errors when uploading media. He was tagging his upload as "tag,#tag". "tag", "#tag", "Tag", and possibly other permutations are given the same tag number in my postgresql database.

mediagoblin-prod=# select distinct tag from core__media_tags where name='tag';
 tag
------
 1742
(1 row)

mediagoblin-prod=# select distinct tag from core__media_tags where name='#tag';
 tag
------
 1742
(1 row)

mediagoblin-prod=# select distinct tag from core__media_tags where name='Tag';
 tag
------
 1742
(1 row)

This causes a foreign key constraint violation when attempting to add "#tag" to core__media_tags.

Error - <class 'sqlalchemy.exc.IntegrityError'>: (IntegrityError) duplicate key value violates unique constraint "core__media_tags_tag_media_entry_key"
DETAIL:  Key (tag, media_entry)=(337, 3534) already exists.
 'INSERT INTO core__media_tags (media_entry, tag, name) VALUES (%(media_entry)s, %(tag)s, %(name)s) RETURNING core__media_tags.id' {'tag': 337, 'name': u'#tag', 'media_entry': 3534}

I can reproduce this error by uploading by own media tagged as "tag,#tag". Interestingly, if I tag the media as "tag,tag" then I do not get the foreign key constraint violation. If we can ignore duplicate identical tags in the upload (tag, tag), then I think it would be good if we could also ignore tags which result in duplicate tag numbers in the table.

breton suggested I tag with under the 0.8.0 milestone.

Encountered an issue with pybabel when trying to do the ./bootstrap.sh step. python-babel is installed in the proper directory (not necessarily as part of the site packages

mediagoblin@jessie:/srv/mediagoblin.chicagolug.org/mediagoblin$ ./bin/pip install Babel Requirement already satisfied (use --upgrade to upgrade): Babel in ./lib/python2.7/site-packages/Babel-1.3-py2.7.egg

Here's the error output

mediagoblin@jessie:/srv/mediagoblin.chicagolug.org/mediagoblin$ ./bootstrap.sh && ./configure && make autoreconf: Entering directory `.' autoreconf: configure.ac: not using Gettext autoreconf: running: aclocal --force autoreconf: configure.ac: tracing autoreconf: configure.ac: not using Libtool autoreconf: running: /usr/bin/autoconf --force autoreconf: configure.ac: not using Autoheader autoreconf: configure.ac: not using Automake autoreconf: Leaving directory `.' checking for python2.7... python2.7 checking for virtualenv... virtualenv checking for a thread-safe mkdir -p... /bin/mkdir -p checking for a BSD-compatible install... /usr/bin/install -c configure: creating ./config.status config.status: creating Makefile config.status: creating mediagoblin/_version.py ./devtools/update_extlib.sh ./devtools/compile_translations.sh Traceback (most recent call last):

File "./bin/pybabel", line 9, in <module>

load_entry_point('mediagoblin==0.8.0.dev', 'console_scripts', 'pybabel')()

File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 356, in load_entry_point

return get_distribution(dist).load_entry_point(group, name)

File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2476, in load_entry_point

return ep.load()

File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 2190, in load

__name__)

ImportError: No module named babel.messages.frontend Makefile:118: recipe for target 'i18n' failed make: * [i18n] Error 1

i uploaded a jpg and want to delete it now.

i clicked to delete it and get an internal server error page:

URL: http://hipsterpunk.com/u/davidak/m/454/confirm-delete/
File '/var/www/mediagoblin/lib/python2.7/site-packages/Paste-1.7.5.1-py2.7.egg/paste/exceptions/errormiddleware.py', line 144 in __call__
  app_iter = self.application(environ, sr_checker)
File '/var/www/mediagoblin/lib/python2.7/site-packages/Paste-1.7.5.1-py2.7.egg/paste/urlmap.py', line 203 in __call__
  return app(environ, start_response)
File '/var/www/mediagoblin/lib/python2.7/site-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py', line 155 in __call__
  return self.wrap_app(environ, session_start_response)
File '/var/www/mediagoblin/mediagoblin/app.py', line 236 in __call__
  return self.call_backend(environ, start_response)
File '/var/www/mediagoblin/mediagoblin/app.py', line 216 in call_backend
  response = controller(request)
File '/var/www/mediagoblin/mediagoblin/decorators.py', line 224 in wrapper
  return controller(request, media=media, *args, **kwargs)
File '/var/www/mediagoblin/mediagoblin/decorators.py', line 48 in new_controller_func
  return controller(request, *args, **kwargs)
File '/var/www/mediagoblin/mediagoblin/decorators.py', line 78 in wrapper
  return controller(request, *args, **kwargs)
File '/var/www/mediagoblin/mediagoblin/user_pages/views.py', line 284 in media_confirm_delete
  media.delete()
File '/var/www/mediagoblin/mediagoblin/db/models.py', line 261 in delete
  super(MediaEntry, self).delete(**kwargs)
File '/var/www/mediagoblin/mediagoblin/db/base.py', line 59 in delete
  sess.commit()
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/orm/session.py', line 703 in commit
  self.transaction.commit()
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/orm/session.py', line 365 in commit
  t[1].commit()
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/engine/base.py', line 2045 in commit
  self._do_commit()
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/engine/base.py', line 2075 in _do_commit
  self.connection._commit_impl()
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/engine/base.py', line 1280 in _commit_impl
  self._handle_dbapi_exception(e, None, None, None, None)
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/engine/base.py', line 1277 in _commit_impl
  self.engine.dialect.do_commit(self.connection)
File '/var/www/mediagoblin/lib/python2.7/site-packages/SQLAlchemy-0.7.9-py2.7-linux-i686.egg/sqlalchemy/engine/default.py', line 307 in do_commit
  connection.commit()
OperationalError: (OperationalError) database is locked None None

SERVER_SOFTWARE 'Apache/2.2.17 (Ubuntu)' HTTP_USER_AGENT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2125.122 Safari/537.36'

after that, the image was deleted but the database entry is still there: ​http://hipsterpunk.com/u/davidak/m/foto-am-20-03-15-um-21-54/