Community Forums

1. 

   subojac
   Member
   Posted 13 years ago

   Hi, need some help. Installed Mediacore today following the step-by-step instructions for Mac. Everything worked fine, but uploading suddenly stopped working. It was working before and just stopped randomly. Terminal is throwing this error:

   Last login: Thu Apr 14 15:10:00 on ttys000
   Video-Server:~ serverserver$ source mediacore_env/bin/activate
   (mediacore_env)Video-Server:~ serverserver$ cd MediaCore-0.9.0
   (mediacore_env)Video-Server:MediaCore-0.9.0 serverserver$ paster serve --reload deployment.ini
   Starting subprocess with file monitor
   Starting server in PID 296.
   15:12:42,674 INFO [paste.httpserver.ThreadPool] [MainThread] Cannot use kill_thread_limit as ctypes/killthread is not available
   serving on 0.0.0.0:8080 view at http://127.0.0.1:8080
   Error - <class 'sqlalchemy.exc.IntegrityError'>: (IntegrityError) (1062, "Duplicate entry '12' for key 'PRIMARY'") 'INSERT INTO media (type, slug, podcast_id, reviewed, encoded, publishable, created_on, modified_on, publish_on, publish_until, title, subtitle, description, description_plain, notes, duration, views, likes, dislikes, popularity_points, popularity_likes, popularity_dislikes, author_name, author_email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (None, '_stub_image022jpg', None, False, False, False, datetime.datetime(2011, 4, 14, 15, 14, 14, 67600), datetime.datetime(2011, 4, 14, 15, 14, 14, 67612), None, None, 'image022.jpg', None, None, None, None, 0, 0, 0, 0, 0, 0, 0, 'Jakes', 'jacobus.vaneeden@me.com')
   URL: http://localhost:8080/admin/media/new/save_thumb
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/WebError-0.10.3-py2.5.egg/weberror/errormiddleware.py', line 162 in __call__
   app_iter = self.application(environ, sr_checker)
   File '/Users/serverserver/mediacore-0.9.0/mediacore/config/middleware.py', line 78 in __call__
   return self.app(environ, start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/ToscaWidgets-0.9.9-py2.5.egg/tw/core/middleware.py', line 43 in __call__
   return self.wsgi_app(environ, start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/ToscaWidgets-0.9.9-py2.5.egg/tw/core/middleware.py', line 68 in wsgi_app
   resp = req.get_response(self.application)
   File 'build/bdist.macosx-10.6-i386/egg/webob/request.py', line 937 in get_response
   File 'build/bdist.macosx-10.6-i386/egg/webob/request.py', line 906 in call_application
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/ToscaWidgets-0.9.9-py2.5.egg/tw/core/resource_injector.py', line 68 in _injector
   resp = req.get_response(app)
   File 'build/bdist.macosx-10.6-i386/egg/webob/request.py', line 937 in get_response
   File 'build/bdist.macosx-10.6-i386/egg/webob/request.py', line 906 in call_application
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/repoze.who-1.0.18-py2.5.egg/repoze/who/middleware.py', line 107 in __call__
   app_iter = app(environ, wrapper.wrap_start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Beaker-1.5.4-py2.5.egg/beaker/middleware.py', line 152 in __call__
   return self.wrap_app(environ, session_start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Routes-1.12.3-py2.5.egg/routes/middleware.py', line 131 in __call__
   response = self.app(environ, start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Pylons-0.10-py2.5.egg/pylons/wsgiapp.py', line 124 in __call__
   response = self.dispatch(controller, environ, start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Pylons-0.10-py2.5.egg/pylons/wsgiapp.py', line 327 in dispatch
   return controller(environ, start_response)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Pylons-0.10-py2.5.egg/pylons/controllers/core.py', line 225 in __call__
   response = self._dispatch_call()
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Pylons-0.10-py2.5.egg/pylons/controllers/core.py', line 176 in _dispatch_call
   response = self._inspect_call(func)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Pylons-0.10-py2.5.egg/pylons/controllers/core.py', line 108 in _inspect_call
   result = self._perform_call(func, args)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/Pylons-0.10-py2.5.egg/pylons/controllers/core.py', line 60 in _perform_call
   return func(**args)
   File '/Users/serverserver/mediacore-0.9.0/mediacore/lib/decorators.py', line 86 in wrapped_f
   result = f(*args, **kwargs)
   File '/Users/serverserver/mediacore-0.9.0/mediacore/lib/decorators.py', line 234 in validate
   return self.func(*args, **kwargs)
   File '<string>', line 2 in save_thumb
   File '/Users/serverserver/mediacore-0.9.0/mediacore/lib/decorators.py', line 575 in autocommit
   result = func(*args, **kwargs)
   File '<string>', line 2 in save_thumb
   File '/Users/serverserver/mediacore-0.9.0/mediacore/lib/decorators.py', line 544 in wrapper
   result = func(*args, **kwargs)
   File '/Users/serverserver/MediaCore-0.9.0/mediacore/controllers/admin/media.py', line 548 in save_thumb
   DBSession.flush()
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/orm/scoping.py', line 139 in do
   return getattr(self.registry(), name)(*args, **kwargs)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/orm/session.py', line 1397 in flush
   self._flush(objects)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/orm/session.py', line 1478 in _flush
   flush_context.execute()
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 304 in execute
   rec.execute(self)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/orm/unitofwork.py', line 448 in execute
   uow
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/orm/mapper.py', line 1872 in _save_obj
   execute(statement, params)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/engine/base.py', line 1191 in execute
   params)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/engine/base.py', line 1271 in _execute_clauseelement
   return self.__execute_context(context)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/engine/base.py', line 1302 in __execute_context
   context.parameters[0], context=context)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/engine/base.py', line 1401 in _cursor_execute
   context)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/engine/base.py', line 1394 in _cursor_execute
   context)
   File '/Users/serverserver/mediacore_env/lib/python2.5/site-packages/SQLAlchemy-0.6.5-py2.5.egg/sqlalchemy/engine/default.py', line 299 in do_execute
   cursor.execute(statement, parameters)
   File 'build/bdist.macosx-10.6-i386/egg/MySQLdb/cursors.py', line 174 in execute
   File 'build/bdist.macosx-10.6-i386/egg/MySQLdb/connections.py', line 36 in defaulterrorhandler
   IntegrityError: (IntegrityError) (1062, "Duplicate entry '12' for key 'PRIMARY'") 'INSERT INTO media (type, slug, podcast_id, reviewed, encoded, publishable, created_on, modified_on, publish_on, publish_until, title, subtitle, description, description_plain, notes, duration, views, likes, dislikes, popularity_points, popularity_likes, popularity_dislikes, author_name, author_email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (None, '_stub_image022jpg', None, False, False, False, datetime.datetime(2011, 4, 14, 15, 14, 14, 67600), datetime.datetime(2011, 4, 14, 15, 14, 14, 67612), None, None, 'image022.jpg', None, None, None, None, 0, 0, 0, 0, 0, 0, 0, 'Jakes', 'jacobus.vaneeden@me.com')

   CGI Variables
   -------------
   AUTH_TYPE: 'cookie'
   CONTENT_LENGTH: '47749'
   CONTENT_TYPE: 'multipart/form-data; boundary=----------gL6ei4Ij5cH2cH2GI3gL6Ij5gL6gL6; charset=utf-8'
   HTTP_ACCEPT_TYPES: 'text/*'
   HTTP_CONNECTION: 'close'
   HTTP_COOKIE: 'authtkt="5ea9b75881519a8fd069ce50ec2e82d04da6f2f9jakes !userid_type:unicode"'
   HTTP_HOST: 'localhost:8080'
   HTTP_USER_AGENT: 'Adobe Flash Player 10'
   HTTP_X_FLASH_VERSION: '10,1,102,64'
   PATH_INFO: '/admin/media/new/save_thumb'
   REMOTE_ADDR: '127.0.0.1'
   REMOTE_USER: u'jakes '
   REMOTE_USER_DATA: 'userid_type:unicode'
   REMOTE_USER_TOKENS: ['']
   REQUEST_METHOD: 'POST'
   SERVER_NAME: '0.0.0.0'
   SERVER_PORT: '8080'
   SERVER_PROTOCOL: 'HTTP/1.1'

   WSGI Variables
   --------------
   application: <mediacore.config.middleware.FastCGIScriptStripperMiddleware object at 0x104034790>
   beaker.get_session: <bound method SessionMiddleware._get_session of <beaker.middleware.SessionMiddleware object at 0x10402de50>>
   beaker.session: {'_accessed_time': 1302786854.0897641, '_creation_time': 1302786854.0897641}
   paste.cookies: (<SimpleCookie: authtkt='5ea9b75881519a8fd069ce50ec2e82d04da6f2f9jakes !userid_type:unicode'>, 'authtkt="5ea9b75881519a8fd069ce50ec2e82d04da6f2f9jakes !userid_type:unicode"')
   paste.httpserver.thread_pool: <paste.httpserver.ThreadPool object at 0x1025dc850>
   paste.parsed_formvars: (MultiDict([('Filename', 'image022.jpg'), ('authtkt', '"5ea9b75881519a8fd069ce50ec2e82d04da6f2f9jakes !userid_type:unicode"'), ('thumb', FieldStorage('thumb', 'image022.jpg')), ('Upload', 'Submit Query')]), <open file '<fdopen>', mode 'w+b' at 0x104af3be8>)
   paste.registry: <paste.registry.Registry object at 0x104e756d0>
   paste.throw_errors: True
   pylons.action_method: <bound method MediaController.save_thumb of <mediacore.controllers.admin.media.MediaController object at 0x104ddb550>>
   pylons.controller: <mediacore.controllers.admin.media.MediaController object at 0x104ddb550>
   pylons.environ_config: {'session': 'beaker.session', 'cache': 'beaker.cache'}
   pylons.pylons: <pylons.util.PylonsContext object at 0x104ddb790>
   pylons.routes_dict: {'action': u'save_thumb', 'controller': u'admin/media', 'id': u'new'}
   repoze.what.adapters: {'groups': {'sql_auth': <repoze.what.plugins.sql.adapters.SqlGroupsAdapter object at 0x10402de90>}, 'permissions': {'sql_auth': <repoze.what.plugins.sql.adapters.SqlPermissionsAdapter object at 0x10402ded0>}}
   repoze.what.credentials: {'repoze.what.userid': u'jakes ', 'groups': (u'admins',), 'permissions': (u'admin', u'edit')}
   repoze.who.identity: <repoze.who identity (hidden, dict-like) at 4377846720>
   repoze.who.logger: None
   repoze.who.plugins: {'form': <FriendlyFormPlugin 4362264464>, 'main_identifier': <FriendlyFormPlugin 4362264464>, 'authorization_md': <repoze.what.middleware.AuthorizationMetadata object at 0x104034050>, 'cookie': <AuthTktCookiePlugin 4362264400>, 'sqlauth': <repoze.who.plugins.sa.SQLAlchemyAuthenticatorPlugin object at 0x10402df10>, 'sql_user_md': <repoze.who.plugins.sa.SQLAlchemyUserMDPlugin object at 0x10402dfd0>}
   routes.route: <routes.route.Route object at 0x103dae390>
   routes.url: <routes.util.URLGenerator object at 0x104ddb310>
   toscawidgets.framework: <tw.mods.pylonshf.PylonsHostFramework object at 0x104034710>
   toscawidgets.javascript.require_once: False
   toscawidgets.prefix: '/toscawidgets'
   webob._parsed_query_vars: (GET([]), '')
   webob.adhoc_attrs: {'errors': 'ignore', 'language': 'en-us'}
   wsgi process: 'Multithreaded'
   wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x104ddb310>, {'action': u'save_thumb', 'controller': u'admin/media', 'id': u'new'})
   ------------------------------------------------------------

   <p>Additionally an error occurred while sending the <weberror.reporter.EmailReporter object at 0x1011d0050> report:

   Traceback (most recent call last):
     File "/Users/serverserver/mediacore_env/lib/python2.5/site-packages/WebError-0.10.3-py2.5.egg/weberror/errormiddleware.py", line 450, in send_report
       rep.report(exc_data)
     File "/Users/serverserver/mediacore_env/lib/python2.5/site-packages/WebError-0.10.3-py2.5.egg/weberror/reporter.py", line 45, in report
       server = smtplib.SMTP(self.smtp_server)
     File "/opt/local/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/smtplib.py", line 244, in __init__
       (code, msg) = self.connect(host, port)
     File "/opt/local/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/smtplib.py", line 310, in connect
       raise socket.error, msg
   error: (61, 'Connection refused')
   

   </p>

   Any suggestions.

   I would also like to change my storage from the local data dir to a external drive, /Volumes/HD/data/media.
   I know I have to change media_dir = %(here)s/data/media, but every permutation I've tried doesn't work (what I mean is it didn't work before the uploads started failing in general).

   So, how do I fix my Uploads, and how do I change the local storage from media_dir = %(here)s/data/media to /Volumes/HD/data/media
2. 

   subojac
   Member
   Posted 13 years ago

   update from Weberror Trackback:

   RL: http://localhost:8080/upload/submit_async
   Module weberror.evalexception:431 in respond view
   >> app_iter = self.application(environ, detect_start_response)
   Module mediacore.config.middleware:78 in __call__ view
   >> return self.app(environ, start_response)
   Module tw.core.middleware:43 in __call__ view
   >> return self.wsgi_app(environ, start_response)
   Module tw.core.middleware:68 in wsgi_app view
   >> resp = req.get_response(self.application)
   Module webob.request:937 in get_response view
   Module webob.request:906 in call_application view
   Module tw.core.resource_injector:68 in _injector view
   >> resp = req.get_response(app)
   Module webob.request:937 in get_response view
   Module webob.request:906 in call_application view
   Module repoze.who.middleware:107 in __call__ view
   >> app_iter = app(environ, wrapper.wrap_start_response)
   Module beaker.middleware:152 in __call__ view
   >> return self.wrap_app(environ, session_start_response)
   Module routes.middleware:131 in __call__ view
   >> response = self.app(environ, start_response)
   Module pylons.wsgiapp:124 in __call__ view
   >> response = self.dispatch(controller, environ, start_response)
   Module pylons.wsgiapp:327 in dispatch view
   >> return controller(environ, start_response)
   Module pylons.controllers.core:225 in __call__ view
   >> response = self._dispatch_call()
   Module pylons.controllers.core:176 in _dispatch_call view
   >> response = self._inspect_call(func)
   Module pylons.controllers.core:108 in _inspect_call view
   >> result = self._perform_call(func, args)
   Module pylons.controllers.core:60 in _perform_call view
   >> return func(**args)
   Module mediacore.lib.decorators:86 in wrapped_f view
   >> result = f(*args, **kwargs)
   Module mediacore.lib.decorators:234 in validate view
   >> return self.func(*args, **kwargs)
   Module mediacore.controllers.upload:2 in submit_async view
   Module mediacore.lib.decorators:575 in autocommit view
   >> result = func(*args, **kwargs)
   Module mediacore.controllers.upload:2 in submit_async view
   Module mediacore.lib.decorators:544 in wrapper view
   >> result = func(*args, **kwargs)
   Module mediacore.controllers.upload:137 in submit_async view
   >> None, kwargs['file'], kwargs['url'],
   Module mediacore.controllers.upload:190 in save_media_obj view
   >> DBSession.flush()
   Module sqlalchemy.orm.scoping:139 in do view
   >> return getattr(self.registry(), name)(*args, **kwargs)
   Module sqlalchemy.orm.session:1397 in flush view
   >> self._flush(objects)
   Module sqlalchemy.orm.session:1478 in _flush view
   >> flush_context.execute()
   Module sqlalchemy.orm.unitofwork:304 in execute view
   >> rec.execute(self)
   Module sqlalchemy.orm.unitofwork:448 in execute view
   >> uow
   Module sqlalchemy.orm.mapper:1872 in _save_obj view
   >> execute(statement, params)
   Module sqlalchemy.engine.base:1191 in execute view
   >> params)
   Module sqlalchemy.engine.base:1271 in _execute_clauseelement view
   >> return self.__execute_context(context)
   Module sqlalchemy.engine.base:1302 in __execute_context view
   >> context.parameters[0], context=context)
   Module sqlalchemy.engine.base:1401 in _cursor_execute view
   >> context)
   Module sqlalchemy.engine.base:1394 in _cursor_execute view
   >> context)
   Module sqlalchemy.engine.default:299 in do_execute view
   >> cursor.execute(statement, parameters)
   Module MySQLdb.cursors:174 in execute view
   Module MySQLdb.connections:36 in defaulterrorhandler view
   IntegrityError: (IntegrityError) (1062, "Duplicate entry '7' for key 'PRIMARY'") 'INSERT INTO media (type, slug, podcast_id, reviewed, encoded, publishable, created_on, modified_on, publish_on, publish_until, title, subtitle, description, description_plain, notes, duration, views, likes, dislikes, popularity_points, popularity_likes, popularity_dislikes, author_name, author_email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (None, 'sdfsdf', None, False, False, False, datetime.datetime(2011, 4, 14, 16, 38, 16, 738869), datetime.datetime(2011, 4, 14, 16, 38, 16, 738881), None, None, 'sdfsdf', None, '<p>sdfsdf</p>', 'sdfsdf', None, 0, 0, 0, 0, 0, 0, 0, 'sdfs', 'sdf@gmail.com')
3. 

   Felix Schwarz
   MediaDrop developer
   Posted 13 years ago

   Well, it looks like MediaCore tries to assign the same media ID twice. I think this might happen if the database schema is bad (e.g. no auto_increment attribute). Maybe try to build a new installation? Alternatively, you could post the output of 'show fields from media' from the mysql console.

   Changing the storage location should be as easy as changing the config + moving the existing dir. Can you be more specific about the error you see?

   fs

   PS: If you post tracebacks, what about using the 'code' tag? This will preserve some line breaks etc.

RSS feed for this topic

Reply

You must log in to post.