Bug#913940: [snapshot@debian.org: WebApp Error: <class 'psycopg2.DataError'>: value "2261434398" is out of range for type integer CONTEXT: PL/Perl function "stat"]
Package: snapshot.debian.org
clang and others break snapshot downloads
snapshot=> select * from file order by size desc limit 10;
file_id | name | size | hash | node_id
----------+----------------------------------------------+------------+------------------------------------------+----------
47972832 | clang-6.0-dbgsym_6.0~svn315736-1_ppc64.deb | 2735272324 | 366c616719d9327343ed00ffe4b1d28f9f52acde | 48942215
47864226 | clang-6.0-dbgsym_6.0~svn315736-1_sparc64.deb | 2679047982 | 0985cb1b00355ee6a3cb92a8753bd660e88fc4bc | 48823248
47467501 | clang-6.0-dbgsym_6.0~svn311834-1_s390x.deb | 2379629570 | 241dd8f2acd6681aefd0d0a84ecc002809e0e7d3 | 48387679
47412766 | clang-6.0-dbgsym_6.0~svn311834-1_ppc64.deb | 2353666260 | a7f6772e570cca06bd133154d4cc9c9cee6ba1da | 48331803
47380007 | clang-6.0-dbgsym_6.0~svn311834-1_sparc64.deb | 2301717660 | ce3202834f4c6679c37a06dd6d3422787ecfe321 | 48298542
47679102 | clang-5.0-dbgsym_5.0-3_ppc64.deb | 2297872226 | dd6f41077ae726019782388a49a508952eb4db12 | 48618071
47858234 | clang-5.0-dbgsym_5.0-4_ppc64.deb | 2297835950 | 00d347e9c6f70631ab24e6d25f0819e9537e6ec9 | 48816277
47380088 | clang-5.0-dbgsym_5.0-2_sparc64.deb | 2296150770 | 6667a8792d32127bd83c9da2172a88171ea85027 | 48298623
52509723 | unidic-mecab_2.3.0+dfsg.orig.tar.gz | 2261434398 | 1388d81a2f080db848865974be169f2744729dbb | 53922863
47864232 | clang-5.0-dbgsym_5.0-4_sparc64.deb | 2246397816 | 9bcddf1023a73f009e4e4357a83dec30e879ee78 | 48823254
----- Forwarded message from snapshot@debian.org -----
From: snapshot@debian.org
Subject: WebApp Error: <class 'psycopg2.DataError'>: value "2261434398" is out of range for type integer CONTEXT: PL/Perl function "stat"
To: snapshot@debian.org
Date: Sat, 17 Nov 2018 01:07:24 -0000
X-Spam-Status: No, score=-0.9 required=5.0 tests=BAYES_00,HTML_MESSAGE, MISSING_MID autolearn=no autolearn_force=no version=3.4.2
X-Original-To: peter@palfrader.org
URL: http://snapshot.debian.org/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0%2Bdfsg.orig.tar.gz
File '/usr/lib/python2.7/dist-packages/weberror/errormiddleware.py', line 171 in __call__
app_iter = self.application(environ, sr_checker)
File '/usr/lib/python2.7/dist-packages/beaker/middleware.py', line 73 in __call__
return self.app(environ, start_response)
File '/usr/lib/python2.7/dist-packages/beaker/middleware.py', line 156 in __call__
return self.wrap_app(environ, session_start_response)
File '/usr/lib/python2.7/dist-packages/routes/middleware.py', line 141 in __call__
response = self.app(environ, start_response)
File '/usr/lib/python2.7/dist-packages/pylons/wsgiapp.py', line 103 in __call__
response = self.dispatch(controller, environ, start_response)
File '/usr/lib/python2.7/dist-packages/pylons/wsgiapp.py', line 313 in dispatch
return controller(environ, start_response)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/base.py', line 15 in __call__
return WSGIController.__call__(self, environ, start_response)
File '/usr/lib/python2.7/dist-packages/pylons/controllers/core.py', line 214 in __call__
response = self._dispatch_call()
File '/usr/lib/python2.7/dist-packages/pylons/controllers/core.py', line 164 in _dispatch_call
response = self._inspect_call(func)
File '/usr/lib/python2.7/dist-packages/pylons/controllers/core.py', line 107 in _inspect_call
result = self._perform_call(func, args)
File '/usr/lib/python2.7/dist-packages/pylons/controllers/core.py', line 57 in _perform_call
return func(**args)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/controllers/archive.py', line 260 in dir
stat = app_globals.shm.mirrorruns_stat(self._db(), run['mirrorrun_id'], '/'+url)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/model/snapshotmodel.py', line 240 in mirrorruns_stat
'path': path } )
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 74 in query_one
return self.wrap(self._query_one, *args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 43 in wrap
return call(*args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 62 in _query_one
all = self.query(*args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 72 in query
return self.wrap(self._query, *args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 43 in wrap
return call(*args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 57 in _query
c = self.execute(*args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 70 in execute
return self.wrap(self._execute, *args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 43 in wrap
return call(*args, **kw)
File '/srv/snapshot.debian.org/web-app/lib/python2.7/site-packages/snapshot/lib/dbinstance.py', line 54 in _execute
c.execute(*args, **kw)
File '/usr/lib/python2.7/dist-packages/psycopg2/extras.py', line 120 in execute
return super(DictCursor, self).execute(query, vars)
DataError: value "2261434398" is out of range for type integer
CONTEXT: PL/Perl function "stat"
CGI Variables
-------------
CONTEXT_DOCUMENT_ROOT: '/var/www/html'
DOCUMENT_ROOT: '/var/www/html'
GATEWAY_INTERFACE: 'CGI/1.1'
GIT_PROJECT_ROOT: '/srv/snapshot.debian.org/all-git'
HTTP_ACCEPT: '*/*'
HTTP_ACCEPT_ENCODING: 'gzip'
HTTP_HOST: 'snapshot.debian.org'
HTTP_USER_AGENT: 'jigdo-lite/0.7.3 (GNU Wget 1.19.4, \xc3\xb6ssze\xc3\xa1ll\xc3\xadtva linux-gnu rendszeren.; )'
HTTP_X_FORWARDED_FOR: '51.15.43.205'
HTTP_X_VARNISH: '2133940'
PATH_INFO: '/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz'
PATH_TRANSLATED: '/srv/snapshot.debian.org/bin/snapshot.wsgi/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz'
REMOTE_ADDR: '127.0.0.1'
REMOTE_PORT: '44476'
REQUEST_METHOD: 'GET'
REQUEST_SCHEME: 'http'
REQUEST_URI: '/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz'
SCRIPT_FILENAME: '/srv/snapshot.debian.org/bin/snapshot.wsgi'
SCRIPT_URI: 'http://snapshot.debian.org/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz'
SCRIPT_URL: '/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz'
SERVER_ADDR: '127.0.0.1'
SERVER_ADMIN: 'team@snapshot.debian.org'
SERVER_NAME: 'snapshot.debian.org'
SERVER_PORT: '80'
SERVER_PROTOCOL: 'HTTP/1.1'
SERVER_SIGNATURE: '<address>Apache Server at snapshot.debian.org Port 80</address>\n'
SERVER_SOFTWARE: 'Apache'
WSGI Variables
--------------
apache.version: (2, 4, 25)
application: <beaker.middleware.CacheMiddleware object at 0x7f87e499ce90>
beaker.cache: <beaker.cache.CacheManager object at 0x7f87e499ced0>
beaker.get_session: <bound method SessionMiddleware._get_session of <beaker.middleware.SessionMiddleware object at 0x7f87e499ce50>>
beaker.session: {'_accessed_time': 1542416844.806576, '_creation_time': 1542416844.806576}
mod_wsgi.application_group: 'snapshot.debian.org|'
mod_wsgi.callable_object: 'application'
mod_wsgi.daemon_connects: '1'
mod_wsgi.daemon_restarts: '0'
mod_wsgi.daemon_start: '1542416844779222'
mod_wsgi.enable_sendfile: '0'
mod_wsgi.handler_script: ''
mod_wsgi.ignore_activity: '0'
mod_wsgi.listener_host: '0.0.0.0'
mod_wsgi.listener_port: '80'
mod_wsgi.path_info: '/archive/debian/20181030T081520Z/pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz'
mod_wsgi.process_group: 'snapshot.debian.org'
mod_wsgi.queue_start: '1542416844779110'
mod_wsgi.request_handler: 'wsgi-script'
mod_wsgi.request_id: 'w+0g6EHxbfo'
mod_wsgi.request_start: '1542416844778947'
mod_wsgi.script_name: ''
mod_wsgi.script_reloading: '1'
mod_wsgi.script_start: '1542416844779252'
mod_wsgi.thread_id: 2
mod_wsgi.thread_requests: 754L
mod_wsgi.total_requests: 2761L
mod_wsgi.version: (4, 5, 11)
paste.registry: <paste.registry.Registry object at 0x7f87e48b6cd0>
paste.throw_errors: True
pylons.action_method: <bound method ArchiveController.dir of <snapshot.controllers.archive.ArchiveController object at 0x7f87e48b65d0>>
pylons.controller: <snapshot.controllers.archive.ArchiveController object at 0x7f87e48b65d0>
pylons.environ_config: {'session': 'beaker.session', 'cache': 'beaker.cache'}
pylons.log_debug: False
pylons.pylons: <pylons.util.PylonsContext object at 0x7f87e48b6c90>
pylons.routes_dict: {'date': u'20181030T081520Z', 'url': u'pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz', 'controller': u'archive', 'archive': u'debian', 'action': u'dir'}
routes.route: <routes.route.Route object at 0x7f87e499c790>
routes.url: <routes.util.URLGenerator object at 0x7f87e48b6890>
wsgi process: 'Multi process AND threads (?)'
wsgi.file_wrapper: <type 'mod_wsgi.FileWrapper'>
wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7f87e48b6890>, {'date': u'20181030T081520Z', 'url': u'pool/main/u/unidic-mecab/unidic-mecab_2.3.0+dfsg.orig.tar.gz', 'controller': u'archive', 'archive': u'debian', 'action': u'dir'})
----- End forwarded message -----
--
| .''`. ** Debian **
Peter Palfrader | : :' : The universal
https://www.palfrader.org/ | `. `' Operating System
| `- https://www.debian.org/
Reply to: