Failed to get libraries information on 6.0.1/6.0.2

phil · September 1, 2016, 6:38am

Upgraded my server to 6.0.1 beta and cant login via the newest client on linux. Does not work on Android and another Win7 machine. Web Frontend works fine.
Same for Windows 7 client, but a new user/server/account config did fix it.

Another bug: Since the new linux client the tray icon does not appear on Elementary OS.

The seafile.log and the ccnet.log does not show any errors on the client side. Only applet.log shows a lot of lines with some requests failed like these:

`[08/22/16 09:47:30]request failed for https://seafile.URL.com/api2/unseen_messages/:

Page unavailable

Sorry, but the requested page is unavailable due to a server hiccup.

Our eng`

daniel.pan · September 1, 2016, 8:59am

Please check the seahub_django_request.log at the server side.

phil · September 1, 2016, 9:08am

2016-09-01 17:06:17,600 [ERROR] django.request:256 handle_uncaught_exception Internal Server Error: /api2/repos/
Traceback (most recent call last):
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/core/handlers/base.py”, line 132, in get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/views/decorators/csrf.py”, line 58, in wrapped_view
return view_func(*args, **kwargs)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/views/generic/base.py”, line 71, in view
return self.dispatch(request, *args, **kwargs)
File “/home/seafile/seafile-server-6.0.1/seahub/seahub/api2/base.py”, line 23, in dispatch
response = super(APIView, self).dispatch(*a, **kw)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py”, line 466, in dispatch
response = self.handle_exception(exc)
File “/home/seafile/seafile-server-6.0.1/seahub/seahub/api2/base.py”, line 20, in handle_exception
return super(APIView, self).handle_exception(exc)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py”, line 454, in dispatch
self.initial(request, *args, **kwargs)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py”, line 376, in initial
self.perform_authentication(request)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py”, line 310, in perform_authentication
request.user
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/request.py”, line 353, in getattribute
return super(Request, self).getattribute(attr)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/request.py”, line 193, in user
self._authenticate()
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/request.py”, line 316, in _authenticate
user_auth_tuple = authenticator.authenticate(self)
File “/home/seafile/seafile-server-6.0.1/seahub/seahub/api2/authentication.py”, line 63, in authenticate
ret = self.authenticate_v2(request, key)
File “/home/seafile/seafile-server-6.0.1/seahub/seahub/api2/authentication.py”, line 92, in authenticate_v2
token = TokenV2.objects.get(key=key)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/manager.py”, line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py”, line 328, in get
num = len(clone)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py”, line 144, in len
self._fetch_all()
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py”, line 965, in _fetch_all
self._result_cache = list(self.iterator())
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py”, line 238, in iterator
results = compiler.execute_sql()
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/sql/compiler.py”, line 840, in execute_sql
cursor.execute(sql, params)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/utils.py”, line 64, in execute
return self.cursor.execute(sql, params)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/sqlite3/base.py”, line 318, in execute
return Database.Cursor.execute(self, query, params)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/sqlite3/base.py”, line 69, in
return lambda s: conv_func(s.decode(‘utf-8’))
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/sqlite3/utils.py”, line 7, in parse_datetime_with_timezone_support
dt = parse_datetime(value)
File “/home/seafile/seafile-server-6.0.1/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/utils/dateparse.py”, line 109, in parse_datetime
return datetime.datetime(**kw)
ValueError: year is out of range

thank you for your fast response!

varakh · September 1, 2016, 11:11am

I get this too @daniel.pan

api/v2.1/admin/devices/?platform=desktop&page=1&per_page=50&_=1472728018393 Failed to load resource: the server responded with a status of 500 (INTERNAL SERVER ERROR)

And in Admin view: Uncaught SyntaxError: Unexpected token < in JSON at position 0.

Cannot sync any client (mobile nor desktop) and devices are not viewable in web ui.

This is 6.0.2 and no beta!

Django Request Log:

ValueError: year is out of range 2016-09-01 13:19:39,465 [ERROR] django.request:256 handle_uncaught_exception Internal Server Error: /api2/repos/ Traceback (most recent call last): File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/core/handlers/base.py", line 132, in get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/views/decorators/csrf.py", line 58, in wrapped_view return view_func(*args, **kwargs) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/views/generic/base.py", line 71, in view return self.dispatch(request, *args, **kwargs) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/seahub/api2/base.py", line 23, in dispatch response = super(APIView, self).dispatch(*a, **kw) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py", line 466, in dispatch response = self.handle_exception(exc) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/seahub/api2/base.py", line 20, in handle_exception return super(APIView, self).handle_exception(exc) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py", line 454, in dispatch self.initial(request, *args, **kwargs) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py", line 376, in initial self.perform_authentication(request) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/views.py", line 310, in perform_authentication request.user File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/request.py", line 353, in __getattribute__ return super(Request, self).__getattribute__(attr) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/request.py", line 193, in user self._authenticate() File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/djangorestframework-3.3.2-py2.7.egg/rest_framework/request.py", line 316, in _authenticate user_auth_tuple = authenticator.authenticate(self) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/seahub/api2/authentication.py", line 63, in authenticate ret = self.authenticate_v2(request, key) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/seahub/api2/authentication.py", line 92, in authenticate_v2 token = TokenV2.objects.get(key=key) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/manager.py", line 127, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py", line 328, in get num = len(clone) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py", line 144, in __len__ self._fetch_all() File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py", line 965, in _fetch_all self._result_cache = list(self.iterator()) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/query.py", line 238, in iterator results = compiler.execute_sql() File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/models/sql/compiler.py", line 840, in execute_sql cursor.execute(sql, params) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/sqlite3/base.py", line 318, in execute return Database.Cursor.execute(self, query, params) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/sqlite3/base.py", line 69, in <lambda> return lambda s: conv_func(s.decode('utf-8')) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/db/backends/sqlite3/utils.py", line 7, in parse_datetime_with_timezone_support dt = parse_datetime(value) File "/srv/seafile/domain.tld/haiwen/seafile-server-6.0.2/seahub/thirdpart/Django-1.8.10-py2.7.egg/django/utils/dateparse.py", line 109, in parse_datetime return datetime.datetime(**kw) ValueError: year is out of range

phil · September 2, 2016, 8:41am

UPDATE: updated to 6.0.2. same issue.

UPDATE 2: the workaround mentioned here worked, but i thought the problem should get fixed in the next (6.0.2?) release?

github.com/haiwen/seafile

[Seafile-server 6.0.0] Use valid default tokenv2 creation datetime

haiwen:master ← edacval:fix-default-token-creation-time

opened 12:29AM - 13 Aug 16 UTC

edacval

+1 -1

Hi, After upgrade, Seahub crashes with error: ``` 2016-08-13 01:43:03,844 [ERRO…R] django.request:256 handle_uncaught_exception Internal Server Error: /api2/account/info/ Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/lib/python2.7/site-packages/django/views/decorators/csrf.py", line 58, in wrapped_view return view_func(*args, **kwargs) File "/usr/lib/python2.7/site-packages/django/views/generic/base.py", line 71, in view return self.dispatch(request, *args, **kwargs) File "/srv/seafile/example.com/seafile-server/seahub/seahub/api2/base.py", line 23, in dispatch response = super(APIView, self).dispatch(*a, **kw) File "/usr/lib/python2.7/site-packages/rest_framework/views.py", line 466, in dispatch response = self.handle_exception(exc) File "/srv/seafile/example.com/seafile-server/seahub/seahub/api2/base.py", line 20, in handle_exception return super(APIView, self).handle_exception(exc) File "/usr/lib/python2.7/site-packages/rest_framework/views.py", line 454, in dispatch self.initial(request, *args, **kwargs) File "/usr/lib/python2.7/site-packages/rest_framework/views.py", line 376, in initial self.perform_authentication(request) File "/usr/lib/python2.7/site-packages/rest_framework/views.py", line 310, in perform_authentication request.user File "/usr/lib/python2.7/site-packages/rest_framework/request.py", line 353, in __getattribute__ return super(Request, self).__getattribute__(attr) File "/usr/lib/python2.7/site-packages/rest_framework/request.py", line 193, in user self._authenticate() File "/usr/lib/python2.7/site-packages/rest_framework/request.py", line 316, in _authenticate user_auth_tuple = authenticator.authenticate(self) File "/srv/seafile/example.com/seafile-server/seahub/seahub/api2/authentication.py", line 63, in authenticate ret = self.authenticate_v2(request, key) File "/srv/seafile/example.com/seafile-server/seahub/seahub/api2/authentication.py", line 92, in authenticate_v2 token = TokenV2.objects.get(key=key) File "/usr/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 328, in get num = len(clone) File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 144, in __len__ self._fetch_all() File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 965, in _fetch_all self._result_cache = list(self.iterator()) File "/usr/lib/python2.7/site-packages/django/db/models/query.py", line 238, in iterator results = compiler.execute_sql() File "/usr/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 840, in execute_sql cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 318, in execute return Database.Cursor.execute(self, query, params) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 69, in <lambda> return lambda s: conv_func(s.decode('utf-8')) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/utils.py", line 7, in parse_datetime_with_timezone_support dt = parse_datetime(value) File "/usr/lib/python2.7/site-packages/django/utils/dateparse.py", line 109, in parse_datetime return datetime.datetime(**kw) ValueError: year is out of range ``` According to [https://docs.python.org/2/library/datetime.html](url), the smallest year number allowed in a date or datetime object. MINYEAR is 1 Quick workaround: ``` sqlite3 /path/to/seahub.db UPDATE api2_tokenv2 SET created_at='0001-01-01 00:00:00' WHERE created_at='0000-00-00 00:00:00'; .quit ```

daniel.pan · September 2, 2016, 9:11am

Did you use the 6.0.0 release before?

The database upgrade script in 6.0.0 is wrong. If you ever run that version, you have to fix the database table manually. The minor upgrade script does not touch database.

If you upgrade from 5.1.x to 6.0.1 or 6.0.2 directly, there should be no such problem.

Kevin · September 2, 2016, 10:43am

Daniel,

I just upgraded from 5.1.4 to 6.0.2 but I’m experiencing the same problem.

Edit:

github.com

haiwen/seafile/blob/v6.0.0-server/scripts/upgrade/sql/6.0.0/sqlite3/seahub.sql#L24


CREATE TABLE IF NOT EXISTS "two_factor_statictoken" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "token" varchar(16) NOT NULL, "device_id" integer NOT NULL REFERENCES "two_factor_staticdevice" ("id"));
CREATE TABLE IF NOT EXISTS "two_factor_totpdevice" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "user" varchar(255) NOT NULL UNIQUE, "name" varchar(64) NOT NULL, "confirmed" bool NOT NULL, "key" varchar(80) NOT NULL, "step" smallint unsigned NOT NULL, "t0" bigint NOT NULL, "digits" smallint unsigned NOT NULL, "tolerance" smallint unsigned NOT NULL, "drift" smallint NOT NULL, "last_t" bigint NOT NULL);
CREATE INDEX IF NOT EXISTS "two_factor_statictoken_94a08da1" ON "two_factor_statictoken" ("token");
CREATE INDEX IF NOT EXISTS "two_factor_statictoken_9379346c" ON "two_factor_statictoken" ("device_id");


CREATE TABLE IF NOT EXISTS "invitations_invitation" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "token" varchar(40) NOT NULL, "inviter" varchar(255) NOT NULL, "accepter" varchar(255) NOT NULL, "invite_time" datetime NOT NULL, "accept_time" datetime NULL, "invite_type" varchar(20) NOT NULL, "expire_time" datetime NOT NULL);
CREATE INDEX IF NOT EXISTS "invitations_invitation_94a08da1" ON "invitations_invitation" ("token");
CREATE INDEX IF NOT EXISTS "invitations_invitation_d5dd16f8" ON "invitations_invitation" ("inviter");


ALTER TABLE api2_tokenv2 ADD COLUMN wiped_at datetime DEFAULT NULL;
ALTER TABLE api2_tokenv2 ADD COLUMN created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

This won’t change existing columns does it?

c0urier · September 2, 2016, 10:47am

Hi Daniel

I just did the upgrade fra 5.1.4 to 6.0.2 and I have the exact same error:
ValueError: year is out of range in seahub_django_request.log

phil · September 2, 2016, 10:55am

I upgraded from 5.1.x to 6.0.1 beta and then to 6.0.2 with all the given scripts.

varakh · September 2, 2016, 11:16am

I upgraded from 5.1.4 to 6.0.2, no update steps inbetween.

dakira · September 2, 2016, 11:31am

Same for me: Upgrade from 5.1.4 to 6.0.2. Everything stopped working.

daniel.pan · September 2, 2016, 11:40am

We will look into the problem and fix it soon.

daniel.pan · September 3, 2016, 7:18am

A fixed version is ready.

For users that already have the problem, use the following command to fix it.

sqlite3 /path/to/seahub.db
UPDATE api2_tokenv2 SET created_at='0001-01-01 00:00:00' WHERE created_at='0000-00-00 00:00:00';
.quit

dakira · September 5, 2016, 11:27am

@daniel.pan what about MySQL. Should I run this query there as well?

daniel.pan · September 6, 2016, 2:06am

MySQL doesn’t have this kind of bug.