#325: Update sync fails if update title is too long
---------------------------------------+-----------------------
Reporter: tflink | Owner: tflink
Type: defect | Status: new
Priority: minor | Milestone: Fedora 18
Component: Blocker bug tracker page | Version: 1.0
Resolution: | Keywords:
Blocked By: | Blocking:
---------------------------------------+-----------------------
Comment (by tflink):
The exact TB seen in production during sync is:
{{{
Traceback (most recent call last):
File "sync_db.py", line 113, in <module>
update_sync.full_sync_updates(release)
File "/home/blockerbugs/fedora-
qa/blockerbugs/blockerbugs/util/update_sync.py", line 186, in
full_sync_updates
self.sync_bug_updates(release, bugs)
File "/home/blockerbugs/fedora-
qa/blockerbugs/blockerbugs/util/update_sync.py", line 176, in
sync_bug_updates
self.db.session.commit()
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/scoping.py", line 114, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/session.py", line 656, in commit
self.transaction.commit()
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/session.py", line 314, in commit
self._prepare_impl()
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/session.py", line 298, in _prepare_impl
self.session.flush()
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/session.py", line 1583, in flush
self._flush(objects)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/session.py", line 1654, in _flush
flush_context.execute()
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/unitofwork.py", line 331, in execute
rec.execute(self)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/unitofwork.py", line 475, in execute
uow
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/persistence.py", line 64, in save_obj
table, insert)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/orm/persistence.py", line 558, in
_emit_insert_statements
execute(statement, params)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/engine/base.py", line 1449, in execute
params)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/engine/base.py", line 1584, in
_execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/engine/base.py", line 1698, in _execute_context
context)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
context)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-
x86_64.egg/sqlalchemy/engine/default.py", line 331, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (DataError) value too long for type character
varying(1024)
'INSERT INTO update (title, url, karma, stable_karma, status, pending,
date_submitted, date_pushed_testing, date_pushed_stable, date_obsoleted,
release_id) VALUES (%(title)s, %(url)s, %(karma)s, %(stable_karma)s,
%(status)s, %(pending)s, %(date_submitted)s, %(date_pushed_testing)s,
%(date_pushed_stable)s, %(date_obsoleted)s, %(release_id)s) RETURNING
update.id' {'status': 'testing', 'stable_karma': 3, 'release_id': 1,
'title':
'plplot-5.9.9-12.svn12202.fc18,kalzium-4.9.4-2.fc18,why-2.31-4.fc18,unison213-2.13.16-20.fc18,unison227-2.27.57-19.fc18,unison240-2.40.102-2.fc18,llvm-3.1-12.fc18,cduce-0.5.5-3.fc18,why3-0.73-3.fc18,graphviz-2.28.0-24.fc18,frama-c-1.8-4.fc18,brltty-4.3-10.fc18,hivex-1.3.7-2.fc18
,virt-top-1.0.8-3.fc18,virt-
dmesg-0.3.0-6.fc18,whenjobs-0.7.3-4.fc18,coccinelle-1.0.0-0.rc14.6.fc18
,js-of-ocaml-1.2-2.fc18,ocaml-preludeml-0.1-0.22.20100314.fc18,ocaml-
gettext-0.3.4-8.fc18,ocaml-xmlrpc-light-0.6.1-11.fc18,ocaml-
pxp-1.2.3-5.fc18,ocaml-json-wheel-1.0.6-10.fc18,ocaml-sexplib-7.0.5-4.fc18
,ocaml-lwt-2.4.2-1.fc18,ocaml-reins-0.1a-14.fc18,ocaml-bin-
prot-2.0.9-3.fc18,ocaml-ocamlnet-3.5.1-4.fc18,ocaml-fileutils-0.4.4-4.fc18
,ocaml-pgocaml-1.6-2.fc18,ocaml-pa-do-0.8.15-1.fc18,ocaml-
perl4caml-0.9.5-23.fc18,ocaml-ounit-1.1.2-4.fc18,ocaml-ssl-0.4.6-5.fc18
,ocaml-pcre-7.0.2-2.fc18,ocaml-ulex-1.1-15.fc18,ocaml-
openin-20070524-16.fc18,ocaml-sqlite-1.6.3-3.fc18,ocaml-xml-
light-2.3-0.3.svn234.fc18,ocaml-zip-1.04-10.fc18,ocaml-type-
conv-3.0.5-3.fc18,ocaml-p3l-2.03-12.fc18,ocaml-react-0.9.4-1.fc18,ocaml-
res-3.2.0-10.fc18,ocaml-pa-monad-6.0-10.fc18,ocaml-postgresql-2.0.2-1.fc18
,ocaml-SDL-0.8.0-7.fc18,ocaml-csv-1.2.3-3.fc18,ocaml-
libvirt-0.6.1.2-6.fc18,ocaml-newt-0.9-14.fc18,ocaml-mysql-1.1.1-1.fc18
,ocaml-gsl-0.6.0-16.fc18,ocaml-lacaml-7.0.3-1.fc18,ocaml-json-
static-0.9.8-8.fc18,ocaml-curl-0.5.3-7.fc18,ocaml-cryptokit-1.6-3.fc18
,ocaml-curses-1.0.3-15.fc18,ocaml-deriving-0.1.1a-17.fc18,ocaml-
dbus-0.29-6.fc18,ocaml-expat-0.9.1-24.fc18,ocaml-facile-1.1-19.fc18,ocaml-
cil-1.4.0-6.fc18,ocaml-camomile-0.8.3-10.fc18,ocaml-extlib-1.5.3-2.fc18
,ocaml-camlimages-4.0.1-7.fc18,ocaml-calendar-2.03.2-2.fc18,ocaml-
cairo-1.2.0-0.8.git08b40192975.fc18,ocaml-bitstring-2.0.3-5.fc18,ocaml-
bisect-1.1-4.fc18,ocaml-augeas-0.5-3.fc18,ocaml-
ancient-0.9.0-10.fc18,zenon-0.7.1-3.fc18,ocaml-zarith-1.1-3.fc18,ocaml-
ocamlgraph-1.8.2-2.fc18,ocaml-mlgmpidl-1.2.1-0.2.20120830.fc18,ocaml-
menhir-20120123-5.fc18,gappalib-
coq-0.18.0-5.fc18,coq-8.4-3.fc18,apron-0.9.10-9.fc18,alt-ergo-0.', 'url':
'https://admin.fedoraproject.org/updates/plplot-5.9.9-12.svn12202.fc18,kalzium-4.9.4-2.fc18,why-2.31-4.fc18,unison213-2.13.16-20.fc18,unison227-2.27.57-19.fc18,unison240-2.40.102-2.fc18,llvm-3.1-12.fc18,cduce-0.5.5-3.fc18,why3-0.73-3.fc18,graphviz-2.28.0-24.fc18,frama-c-1.8-4.fc18,brltty-4.3-10.fc18,hivex-1.3.7-2.fc18
,virt-top-1.0.8-3.fc18,virt-
dmesg-0.3.0-6.fc18,whenjobs-0.7.3-4.fc18,coccinelle-1.0.0-0.rc14.6.fc18
,js-of-ocaml-1.2-2.fc18,ocaml-preludeml-0.1-0.22.20100314.fc18,ocaml-
gettext-0.3.4-8.fc18,ocaml-xmlrpc-light-0.6.1-11.fc18,ocaml-
pxp-1.2.3-5.fc18,ocaml-json-wheel-1.0.6-10.fc18,ocaml-sexplib-7.0.5-4.fc18
,ocaml-lwt-2.4.2-1.fc18,ocaml-reins-0.1a-14.fc18,ocaml-bin-
prot-2.0.9-3.fc18,ocaml-ocamlnet-3.5.1-4.fc18,ocaml-fileutils-0.4.4-4.fc18
,ocaml-pgocaml-1.6-2.fc18,ocaml-pa-do-0.8.15-1.fc18,ocaml-
perl4caml-0.9.5-23.fc18,ocaml-ounit-1.1.2-4.fc18,ocaml-ssl-0.4.6-5.fc18
,ocaml-pcre-7.0.2-2.fc18,ocaml-ulex-1.1-15.fc18,ocaml-
openin-20070524-16.fc18,ocaml-sqlite-1.6.3-3.fc18,ocaml-xml-
light-2.3-0.3.svn234.fc18,ocaml-zip-1.04-10.fc18,ocaml-type-
conv-3.0.5-3.fc18,ocaml-p3l-2.03-12.fc18,ocaml-react-0.9.4-1.fc18,ocaml-
res-3.2.0-10.fc18,ocaml-pa-monad-6.0-10.fc18,ocaml-postgresql-2.0.2-1.fc18
,ocaml-SDL-0.8.0-7.fc18,ocaml-csv-1.2.3-3.fc18,ocaml-
libvirt-0.6.1.2-6.fc18,ocaml-newt-0.9-14.fc18,ocaml-mysql-1.1.1-1.fc18
,ocaml-gsl-0.6.0-16.fc18,ocaml-lacaml-7.0.3-1.fc18,ocaml-json-
static-0.9.8-8.fc18,ocaml-curl-0.5.3-7.fc18,ocaml-cryptokit-1.6-3.fc18
,ocaml-curses-1.0.3-15.fc18,ocaml-deriving-0.1.1a-17.fc18,ocaml-
dbus-0.29-6.fc18,ocaml-expat-0.9.1-24.fc18,ocaml-facile-1.1-19.fc18,ocaml-
cil-1.4.0-6.fc18,ocaml-camomile-0.8.3-10.fc18,ocaml-extlib-1.5.3-2.fc18
,ocaml-camlimages-4.0.1-7.fc18,ocaml-calendar-2.03.2-2.fc18,ocaml-
cairo-1.2.0-0.8.git08b40192975.fc18,ocaml-bitstring-2.0.3-5.fc18,ocaml-
bisect-1.1-4.fc18,ocaml-augeas-0.5-3.fc18,ocaml-
ancient-0.9.0-10.fc18,zenon-0.7.1-3.fc18,ocaml-zarith-1.1-3.fc18,ocaml-
ocamlgraph-1.8.2-2.fc18,ocaml-mlgmpidl-1.2.1-0.2.20120830.fc18,ocaml-
menhir-20120123-5.fc18,gappalib-
coq-0.18.0-5.fc18,coq-8.4-3.fc18,apron-0.9.10-9.fc18,alt-ergo-0.',
'date_pushed_testing': datetime.datetime(2012, 12, 14, 6, 37, 20),
'date_submitted': datetime.datetime(2012, 12, 13, 17, 4, 57),
'date_obsoleted': None, 'karma': 1, 'date_pushed_stable': None, 'pending':
None}
}}}
--
Ticket URL: <https://fedorahosted.org/fedora-qa/ticket/325#comment:2>
Fedora QA <http://fedorahosted.org/fedora-qa>
Fedora Quality Assurance
--
test mailing list
test@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe:
https://admin.fedoraproject.org/mailman/listinfo/test
