I've successfully installed sab + sb + cp, but couchpotato has one problem. Importing is fine, adding movies to the wanted list is ok, but changing (the name of) an existing movie locks-up couchpotato. Refreshing ends up in a constant loading screen, restarting helps but the change is reverted.
The log file indicates that the database cannot be modified, but adding a movie is no problem. The database is clean and I only imported existing movies without any modification of the configuration. I also tried changing the permissions of the installation (including the database) to 777, but that didn't help either.
Code:
02-28 19:47:48 ERROR [31mException on /api/cad6be8c692c426f837a59ff1d3db6bf/movie.edit/ [GET][0m
Traceback (most recent call last):
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1687, in wsgi_app
response = self.full_dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1360, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1358, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1344, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/plugins/movie/main.py", line 409, in edit
db.commit()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/scoping.py", line 114, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 655, in commit
self.transaction.commit()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 313, in commit
self._prepare_impl()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 297, in _prepare_impl
self.session.flush()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 1587, in flush
self._flush(objects)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 1658, in _flush
flush_context.execute()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/unitofwork.py", line 331, in execute
rec.execute(self)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/unitofwork.py", line 475, in execute
uow
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/persistence.py", line 59, in save_obj
mapper, table, update)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/persistence.py", line 485, in _emit_update_statements
execute(statement, params)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1450, in execute
params)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1697, in _execute_context
context)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/base.py", line 1690, in _execute_context
context)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/engine/default.py", line 335, in do_execute
cursor.execute(statement, parameters)
OperationalError: (OperationalError) unable to open database file u'UPDATE librarytitle SET "default"=? WHERE librarytitle.id = ?' (0, 57)
02-28 19:47:50 ERROR [31mException on /api/cad6be8c692c426f837a59ff1d3db6bf/movie.list/ [GET][0m
Traceback (most recent call last):
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1687, in wsgi_app
response = self.full_dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1360, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1358, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1344, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/plugins/movie/main.py", line 222, in listView
total_movies, movies = self.list(status = status, limit_offset = limit_offset, starts_with = starts_with, search = search)
File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/plugins/movie/main.py", line 138, in list
total_count = q.count()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2519, in count
return self.from_self(col).scalar()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2164, in scalar
ret = self.one()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2133, in one
ret = list(self)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2176, in __iter__
return self._execute_and_instances(context)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2189, in _execute_and_instances
close_with_result=True)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2180, in _connection_from_session
**kw)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 729, in connection
close_with_result=close_with_result)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 733, in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 249, in _connection_for_bind
self._assert_is_active()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 173, in _assert_is_active
% self._rollback_exception
InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (OperationalError) unable to open database file u'UPDATE librarytitle SET "default"=? WHERE librarytitle.id = ?' (0, 57)
02-28 19:47:50 ERROR [31mException on /api/cad6be8c692c426f837a59ff1d3db6bf/movie.list/ [GET][0m
Traceback (most recent call last):
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1687, in wsgi_app
response = self.full_dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1360, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1358, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1344, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/plugins/movie/main.py", line 222, in listView
total_movies, movies = self.list(status = status, limit_offset = limit_offset, starts_with = starts_with, search = search)
File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/plugins/movie/main.py", line 138, in list
total_count = q.count()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2519, in count
return self.from_self(col).scalar()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2164, in scalar
ret = self.one()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2133, in one
ret = list(self)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2176, in __iter__
return self._execute_and_instances(context)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2189, in _execute_and_instances
close_with_result=True)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2180, in _connection_from_session
**kw)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 729, in connection
close_with_result=close_with_result)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 733, in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 249, in _connection_for_bind
self._assert_is_active()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 173, in _assert_is_active
% self._rollback_exception
InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (OperationalError) unable to open database file u'UPDATE librarytitle SET "default"=? WHERE librarytitle.id = ?' (0, 57)
02-28 19:47:50 ERROR [31m[chpotato.core.plugins.log] API log: {'line': u'479', 'type': u'error', 'message': u"chrome 25: \nUncaught TypeError: Cannot read property 'movies' of undefined", 'file': u'http://HOST/api/API_KEY/static/movie_plugin/list.js', 'page': u'http://HOST/manage/'}[0m
02-28 19:47:50 ERROR [31mException on /api/cad6be8c692c426f837a59ff1d3db6bf/notification.listener/ [GET][0m
Traceback (most recent call last):
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1687, in wsgi_app
response = self.full_dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1360, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1358, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/flask/app.py", line 1344, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/pbi/couchpotato-amd64/CouchPotato/couchpotato/core/notifications/core/main.py", line 216, in listener
.filter(or_(Notif.read == False, Notif.added > (time.time() - 259200))) \
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2066, in all
return list(self)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2176, in __iter__
return self._execute_and_instances(context)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2189, in _execute_and_instances
close_with_result=True)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/query.py", line 2180, in _connection_from_session
**kw)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 729, in connection
close_with_result=close_with_result)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 733, in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 249, in _connection_for_bind
self._assert_is_active()
File "/usr/pbi/couchpotato-amd64/CouchPotato/libs/sqlalchemy/orm/session.py", line 173, in _assert_is_active
% self._rollback_exception
InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (OperationalError) unable to open database file u'UPDATE librarytitle SET "default"=? WHERE librarytitle.id = ?' (0, 57)
Edit: I just wanted to make sure it wasn't a environment problem so I updated FreeNas to the latest version (8.3.1-RC1 instead of 8.3.1-BETA3) and created a new plugins jail. Next, I installed the CouchPotato plugin again which worked (so far) without any problems.