Package Details: firefox-syncstorage 0.18.2-1

Git Clone URL: https://aur.archlinux.org/firefox-syncstorage.git (read-only, click to copy)
Package Base: firefox-syncstorage
Description: Sync storage server with built-in token server for running a self-hosted firefox sync server
Upstream URL: https://github.com/mozilla-services/syncstorage-rs
Keywords: firefox mozilla sync syncserver
Licenses: MPL-2.0
Submitter: SunRed
Maintainer: SunRed (jewelux)
Last Packager: SunRed
Votes: 8
Popularity: 0.000023
First Submitted: 2022-09-23 20:40 (UTC)
Last Updated: 2024-12-07 08:00 (UTC)

Latest Comments

« First ‹ Previous 1 2 3

Teyro commented on 2019-02-13 19:20 (UTC)

Getting this error in 1.8... [code] ERROR:syncstorage.views:Could not apply batch ERROR:syncstorage.views:BackendError

(sqlite3.OperationalError) no such column: batch_upload_items.userid [SQL: u"\n INSERT OR REPLACE INTO bso\n (userid, collection, id, sortindex, payload,\n payload_size, ttl, modified)\n SELECT\n batch_uploads.userid,\n batch_uploads.collection,\n batch_upload_items.id,\n COALESCE(batch_upload_items.sortindex, existing.sortindex),\n COALESCE(batch_upload_items.payload, existing.payload, ''),\n COALESCE(batch_upload_items.payload_size, existing.payload_size, 0),\n COALESCE(batch_upload_items.ttl_offset + ?, existing.ttl, ?),\n ?\n FROM batch_uploads\n LEFT JOIN batch_upload_items\n ON\n batch_upload_items.batch = batch_uploads.batch AND\n batch_upload_items.userid = batch_uploads.userid\n LEFT OUTER JOIN bso AS existing\n ON\n existing.userid = batch_uploads.userid AND\n existing.collection = batch_uploads.collection AND\n existing.id = batch_upload_items.id\n WHERE\n batch_uploads.batch = ? AND\n batch_uploads.userid = ?\n / [queryName=APPLY_BATCH_INSERT] /"] [parameters: (1550085553, 2100000000, 1550085553090L, 1550085553091L, 1)] (Background on this error at: http://sqlalche.me/e/e3q8) ERROR:mozsvc:68a5000cba6e610cdb2beb672887bdcf ERROR:mozsvc:BackendError

(sqlite3.OperationalError) no such column: batch_upload_items.userid [SQL: u"\n INSERT OR REPLACE INTO bso\n (userid, collection, id, sortindex, payload,\n payload_size, ttl, modified)\n SELECT\n batch_uploads.userid,\n batch_uploads.collection,\n batch_upload_items.id,\n COALESCE(batch_upload_items.sortindex, existing.sortindex),\n COALESCE(batch_upload_items.payload, existing.payload, ''),\n COALESCE(batch_upload_items.payload_size, existing.payload_size, 0),\n COALESCE(batch_upload_items.ttl_offset + ?, existing.ttl, ?),\n ?\n FROM batch_uploads\n LEFT JOIN batch_upload_items\n ON\n batch_upload_items.batch = batch_uploads.batch AND\n batch_upload_items.userid = batch_uploads.userid\n LEFT OUTER JOIN bso AS existing\n ON\n existing.userid = batch_uploads.userid AND\n existing.collection = batch_uploads.collection AND\n existing.id = batch_upload_items.id\n WHERE\n batch_uploads.batch = ? AND\n batch_uploads.userid = ?\n / [queryName=APPLY_BATCH_INSERT] /"] [parameters: (1550085553, 2100000000, 1550085553090L, 1550085553091L, 1)] (Background on this error at: http://sqlalche.me/e/e3q8) Traceback (most recent call last): File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/mozsvc/tweens.py", line 26, in catch_backend_errors_tween return handler(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/tweens.py", line 21, in excview_tween response = handler(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/router.py", line 163, in handle_request response = view_callable(context, request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/config/views.py", line 596, in call return view(context, request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/config/views.py", line 329, in attr_view return view(context, request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/config/views.py", line 305, in predicate_wrapper return view(context, request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/config/views.py", line 245, in secured_view return view(context, request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/config/views.py", line 355, in rendered_view result = view(context, request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/pyramid/config/views.py", line 501, in _requestonly_view response = view(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/cornice/service.py", line 514, in wrapper response = view(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/util.py", line 54, in wrapper return decorator_func(target_func, args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/decorators.py", line 40, in convert_storage_errors return viewfunc(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/util.py", line 54, in wrapper return decorator_func(target_func, *args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/decorators.py", line 71, in sleep_and_retry_on_conflict return viewfunc(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/util.py", line 54, in wrapper return decorator_func(target_func, args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/decorators.py", line 193, in with_collection_lock return viewfunc(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/util.py", line 54, in wrapper return decorator_func(target_func, *args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/decorators.py", line 164, in check_precondition_headers return viewfunc(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/util.py", line 54, in wrapper return decorator_func(target_func, args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/decorators.py", line 102, in check_storage_quota return viewfunc(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/init.py", line 346, in post_collection return post_collection_batch(request) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/views/init.py", line 418, in post_collection_batch ts = storage.apply_batch(userid, collection, batch) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/mozsvc/metrics.py", line 183, in timed_func return func(*args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/storage/sql/init.py", line 108, in with_session_wrapper return func(self, session, args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/storage/sql/init.py", line 554, in apply_batch session.query("APPLY_BATCH_INSERT", params) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/storage/sql/init.py", line 80, in convert_db_errors_wrapper return func(*args, kwds) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/storage/sql/init.py", line 1043, in query return self.connection.query(query, params) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/storage/sql/dbconnect.py", line 748, in query res = self.execute(query, params, annotations) File "/opt/mozilla-firefox-sync-server/local/lib/python2.7/site-packages/syncstorage/storage/sql/dbconnect.py", line 545, in report_backend_errors_wrapper raise BackendError(str(exc)) BackendError: BackendError

(sqlite3.OperationalError) no such column: batch_upload_items.userid [SQL: u"\n INSERT OR REPLACE INTO bso\n (userid, collection, id, sortindex, payload,\n payload_size, ttl, modified)\n SELECT\n batch_uploads.userid,\n batch_uploads.collection,\n batch_upload_items.id,\n COALESCE(batch_upload_items.sortindex, existing.sortindex),\n COALESCE(batch_upload_items.payload, existing.payload, ''),\n COALESCE(batch_upload_items.payload_size, existing.payload_size, 0),\n COALESCE(batch_upload_items.ttl_offset + ?, existing.ttl, ?),\n ?\n FROM batch_uploads\n LEFT JOIN batch_upload_items\n ON\n batch_upload_items.batch = batch_uploads.batch AND\n batch_upload_items.userid = batch_uploads.userid\n LEFT OUTER JOIN bso AS existing\n ON\n existing.userid = batch_uploads.userid AND\n existing.collection = batch_uploads.collection AND\n existing.id = batch_upload_items.id\n WHERE\n batch_uploads.batch = ? AND\n batch_uploads.userid = ?\n / [queryName=APPLY_BATCH_INSERT] /"] [parameters: (1550085553, 2100000000, 1550085553090L, 1550085553091L, 1)] (Background on this error at: http://sqlalche.me/e/e3q8)

user: {'uid': 1}

[/code]