Re: [GMG-Devel] unsaved pending instance, orphan, not attached to any parent MediaEntry

[Nagarjuna G]

On Sun, Apr 8, 2012 at 2:59 AM, Christopher Allan Webber
<address@hidden> wrote:
> Elrond just pushed a commit that might fix this.  Could you try doing a
> git pull and see if the problem persists?
>


the latest pull has the same problem for jpg files.  It works only for
png files.

I tested for a video, a small ogv file.  First after a while  I get
"Internal server error",  however I noticed the server was busy
transcoding the video.  After completing the transcoding, it failed
with the folloiwng error.

2012-04-08 10:25:38,100 INFO
[mediagoblin.media_types.video.transcoders] 100% done...
2012-04-08 10:25:39,369 INFO
[mediagoblin.media_types.video.transcoders] 100% done...
2012-04-08 10:25:39,372 INFO
[mediagoblin.media_types.video.transcoders] 100% done...
2012-04-08 10:25:39,378 INFO    [mediagoblin.media_types.video.transcoders] Done
2012-04-08 10:25:39,469 INFO
[mediagoblin.media_types.video.transcoders] Terminating MainLoop
2012-04-08 10:25:39,469 DEBUG
[mediagoblin.media_types.video.processing] Saving medium...
2012-04-08 10:25:39,471 DEBUG
[mediagoblin.media_types.video.processing] Saved medium
2012-04-08 10:25:39,484 WARNING [mediagoblin.processing] No idea what
happened here, but it failed: ProgrammingError('(ProgrammingError)
relation "video__mediadata" does not exist\nLINE 2: FROM
video__mediadata \n             ^\n',)
Error - <class 'sqlalchemy.exc.InternalError'>: (InternalError)
current transaction is aborted, commands ignored until end of
transaction block
 'UPDATE core__media_entries SET state=%(state)s,
fail_error=%(fail_error)s, fail_metadata=%(fail_metadata)s WHERE
core__media_entries.id = %(id_1)s' {'fail_metadata': '{}', 'state':
u'failed', 'id_1': 23, 'fail_error': None}
URL: http://media.gnowledge.org/submit/
File '/usr/lib/pymodules/python2.6/paste/exceptions/errormiddleware.py',
line 144 in __call__
  app_iter = self.application(environ, sr_checker)
File '/usr/lib/pymodules/python2.6/paste/urlmap.py', line 203 in __call__
  return app(environ, start_response)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/Beaker-1.5.4-py2.6.egg/beaker/middleware.py',
line 152 in __call__
  return self.wrap_app(environ, session_start_response)
File '/home/mediagoblin/mediagoblin/mediagoblin/app.py', line 194 in __call__
  return self.call_backend(environ, start_response)
File '/home/mediagoblin/mediagoblin/mediagoblin/app.py', line 181 in
call_backend
  response = controller(request)
File '/home/mediagoblin/mediagoblin/mediagoblin/decorators.py', line
50 in new_controller_func
  return controller(request, *args, **kwargs)
File '/home/mediagoblin/mediagoblin/mediagoblin/submit/views.py', line
134 in submit_start
  mark_entry_failed(entry._id, exc)
File '/home/mediagoblin/mediagoblin/mediagoblin/processing/__init__.py',
line 99 in mark_entry_failed
  u'fail_metadata': {}})
File '/home/mediagoblin/mediagoblin/mediagoblin/db/sql/util.py', line
284 in atomic_update
  synchronize_session=False)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/orm/query.py',
line 2160 in update
  result = session.execute(update_stmt, params=self._params)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/orm/session.py',
line 735 in execute
  clause, params or {})
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/engine/base.py',
line 1157 in execute
  params)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/engine/base.py',
line 1237 in _execute_clauseelement
  return self.__execute_context(context)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/engine/base.py',
line 1268 in __execute_context
  context.parameters[0], context=context)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/engine/base.py',
line 1367 in _cursor_execute
  context)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/engine/base.py',
line 1360 in _cursor_execute
  context)
File 
'/home/mediagoblin/mediagoblin/lib/python2.6/site-packages/SQLAlchemy-0.6.3-py2.6.egg/sqlalchemy/engine/default.py',
line 288 in do_execute
  cursor.execute(statement, parameters)
InternalError: (InternalError) current transaction is aborted,
commands ignored until end of transaction block
 'UPDATE core__media_entries SET state=%(state)s,
fail_error=%(fail_error)s, fail_metadata=%(fail_metadata)s WHERE
core__media_entries.id = %(id_1)s' {'fail_metadata': '{}', 'state':
u'failed', 'id_1': 23, 'fail_error': None}


CGI Variables
-------------
  CONTENT_TYPE: 'multipart/form-data;
boundary=----WebKitFormBoundaryzkVQ5MigwjwDIs6d'
  CSRF_TOKEN: u'11459717970219068911'
  DOCUMENT_ROOT: '/var/www/'
  GATEWAY_INTERFACE: 'CGI/1.1'
  HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  HTTP_ACCEPT_CHARSET: 'ISO-8859-1,utf-8;q=0.7,*;q=0.3'
  HTTP_ACCEPT_ENCODING: 'gzip,deflate,sdch'
  HTTP_ACCEPT_LANGUAGE: 'en-US,en;q=0.8'
  HTTP_CACHE_CONTROL: 'max-age=0'
  HTTP_CONNECTION: 'keep-alive'
  HTTP_COOKIE: 'mediagoblin_csrftoken=11459717970219068911;
mediagoblin=251fce72a83d21e72fd33ab3c76240e7;
mediagoblin_csrftoken=11459717970219068911'
  HTTP_HOST: 'media.gnowledge.org'
  HTTP_ORIGIN: 'http://media.gnowledge.org'
  HTTP_REFERER: 'http://media.gnowledge.org/submit/'
  HTTP_USER_AGENT: 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.11
(KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11'
  PATH: '/usr/local/bin:/usr/bin:/bin'
  PATH_INFO: '/submit/'
  PATH_TRANSLATED: '/var/www/mg.fcgi/submit/'
  REMOTE_ADDR: '158.144.32.52'
  REMOTE_PORT: '52679'
  REQUEST_METHOD: 'POST'
  REQUEST_URI: '/submit/'
  SCRIPT_FILENAME: '/var/www/mg.fcgi'
  SCRIPT_URI: 'http://media.gnowledge.org/submit/'
  SCRIPT_URL: '/submit/'
  SERVER_ADDR: '158.144.44.223'
  SERVER_ADMIN: 'address@hidden'
  SERVER_NAME: 'media.gnowledge.org'
  SERVER_PORT: '80'
  SERVER_PROTOCOL: 'HTTP/1.1'
  SERVER_SIGNATURE: '<address>Apache/2.2.16 (Debian) Server at
media.gnowledge.org Port 80</address>\n'
  SERVER_SOFTWARE: 'Apache/2.2.16 (Debian)'


WSGI Variables
--------------
  application: {(None, ''): <beaker.middleware.SessionMiddleware
object at 0x2b08490>, (None, '/mgoblin_static'): <StaticURLParser
'/home/mediagoblin/mediagoblin/mediagoblin/static'>, (None,
'/mgoblin_media'): <StaticURLParser
'/home/mediagoblin/mediagoblin/user_dev/media/public'>}
  beaker.get_session: <bound method SessionMiddleware._get_session of
<beaker.middleware.SessionMiddleware object at 0x2b08490>>
  beaker.session: {'user_id': u'1', '_accessed_time':
1333880613.901396, 'messages': [], '_creation_time':
1333873680.940362}
  paste.throw_errors: True
  webob._body_file:
(<LimitedLengthFile(<flup.server.fcgi_base.InputStream object at
0x316d850>, maxlen=970809)>, <flup.server.fcgi_base.InputStream object
at 0x316d850>)
  webob._parsed_cookies: ({'mediagoblin_csrftoken':
'11459717970219068911', 'mediagoblin':
'251fce72a83d21e72fd33ab3c76240e7'},
'mediagoblin_csrftoken=11459717970219068911;
mediagoblin=251fce72a83d21e72fd33ab3c76240e7;
mediagoblin_csrftoken=11459717970219068911')
  webob._parsed_post_vars: (MultiDict([('file', FieldStorage('file',
'goblin.ogv')), ('title', 'sample screen capture of mediagoblin
session'), ('description', 'created to test mediagoblin.'), ('tags',
'ogv, mediagoblin'), ('license',
'http://creativecommons.org/licenses/by-sa/3.0/'), ('csrf_token',
'11459717970219068911')]), <FakeCGIBody at 0x324eb50 viewing
MultiDict([('fi...1')])>)
  webob._parsed_query_vars: (GET([]), '')
  webob.adhoc_attrs: {'locale': 'en_US', 'staticdirect':
<mediagoblin.staticdirect.RemoteStaticDirect object at 0x2afe790>,
'app': <mediagoblin.app.MediaGoblinApp object at 0x138b110>, 'db':
<mediagoblin.db.sql.open.DatabaseMaster object at 0x2afe410>,
'urlgen': <routes.util.URLGenerator object at 0x3175950>,
'start_response': <function session_start_response at 0x3132cf8>,
'session': {'user_id': u'1', '_accessed_time': 1333880613.901396,
'messages': [], '_creation_time': 1333873680.940362}, 'full_path':
'/submit/', 'template_env': <jinja2.environment.Environment object at
0x2b1fed0>, 'matchdict': {'controller':
u'mediagoblin.submit.views:submit_start'}, 'user':
<mediagoblin.db.sql.models.User object at 0x31698d0>}
  webob.is_body_readable: True
  webob.is_body_seekable: False
  wsgi process: 'Multiprocess'