[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#913940: marked as done ([snapshot@debian.org: WebApp Error: <class 'psycopg2.DataError'>: value "2261434398" is out of range for type integer CONTEXT: PL/Perl function "stat"])



Your message dated Sat, 17 Nov 2018 10:16:47 +0000
with message-id <5befea8fcbc7a_3642af9ab8050dc217a3@godard.mail>
and subject line Bug #913940 in snapshot.debian.org fixed
has caused the Debian Bug report #913940,
regarding [snapshot@debian.org: WebApp Error: <class 'psycopg2.DataError'>: value "2261434398" is out of range for type integer CONTEXT:  PL/Perl function "stat"]
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
913940: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=913940
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message ---
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/

--- End Message ---
--- Begin Message ---
Hello,

Bug #913940 in snapshot.debian.org reported by you has been fixed in the Git repository.
You can see the commit message below, and you can check the diff of the fix at:

https://salsa.debian.org/snapshot-team/snapshot/commit/9ec466deee5131f7f2a4874627388629b98bd54f

------------------------------------------------------------------------
set stat_result.size to bigint.  closes: #913940

------------------------------------------------------------------------

(this message was generated automatically)
-- 
Greetings

https://bugs.debian.org/913940

--- End Message ---

Reply to: