[Zope] Strange ZSQL error in ZMI
Schmidt, Allen J.
aschmidt@nvcc.edu
Wed, 18 Dec 2002 07:32:17 -0500
Why, yes...as a matter of fact...we did just up to 2.6.0. When we did, =
we
saw the QSurvey stuff in Products, did not think anyone was using it =
and
left if out of the new Products folder when we moved everything over.
So how do we resolve this? I would really appreciate anything you can
offer...
Thanks
Allen
-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Jim
Washington
Sent: Tuesday, December 17, 2002 11:47 PM
To: Allen Schmidt
Cc: zope@zope.org
Subject: Re: [Zope] Strange ZSQL error in ZMI
Hmm. I recognize my pretty-old ZClass Product, QSurvey, near the=20
beginning of the traceback. What version of Zope are you using? =
There=20
have been problems with some ZClass products, including that one, on=20
upgrade to Zope-2.6.0. As a shot in the dark, have you by chance=20
recently upgraded?
-- Jim Washington
Allen Schmidt wrote:
>We just started getting this in ZSQL methods when clicking on the =
Advanced
>Tab in the ZMI.
>
>
>
>Zope has encountered an error while publishing this resource.
>
>Error Type: Could not load oid =1D3=C1, pickled data in traceback info =
may
>contain clues
>Error Value: None
>
>
>
>
><p>Traceback (innermost last):
><ul>
>
><li> Module ZPublisher.Publish, line 98, in publish</li>
>
><li> Module ZPublisher.mapply, line 88, in mapply</li>
>
><li> Module ZPublisher.Publish, line 39, in call_object</li>
>
><li> Module Shared.DC.Scripts.Bindings, line 252, in __call__</li>
>
><li> Module Shared.DC.Scripts.Bindings, line 283, in =
_bindAndExec</li>
>
><li> Module App.special_dtml, line 174, in _exec</li>
>
><li> Module Shared.DC.ZRDB.DA, line 476, in
manage_product_zclass_info</li>
>
><li> Module ZODB.Connection, line 533, in setstate</li>
>
><li> Module ZODB.Connection, line 192, in _persistent_load<br />
>__traceback_info__: =1D3=C1</li>
>
><li> Module ZODB.Connection, line 131, in __getitem__<br />
>__traceback_info__: ('\x00\x00\x00\x00\x00\x1d3\xc1',
>'(cExtensionClass\nExtensionClass\nq\x01(U\nQPageClassq\x02(cZClasses.Z=
Clas
s
>\nPersistentClass\nq\x03cZClasses.ObjectManager\nObjectManager\nq\x04cO=
FS.S
i
>mpleItem\nSimpleItem\nq\x05tq\x06}q\x07(U\n_p_changedq\x08K\x01U\x14isP=
rinc
i
>piaFolderishq\tU\x01YU\x11default_next_pageq\nU\x00U\x06_p_oidq\x0bU\x0=
8\x0
0
>\x00\x00\x00\x00\x00/\xcbq\x0cU\tmeta_typeq\rU\x05QPageq\x0eU\ndtmldocs=
eqq\
x
>0f(U\x08\x00\x00\x00\x00\x00\x1d5.q\x10(U\x0fZClasses.Methodq\x11U\x03M=
Wpq\
x
>12tq\x13tq\x14QU\x0epropertysheetsq\x15U\x08\x00\x00\x00\x00\x00\x1d5/q=
\x16
Q
>U\nindex_htmlq\x17(U\x08\x00\x00\x00\x00\x00\x1d50q\x18(h\x11U\x03MWpq\=
x19t
q
>\x1atq\x1bQU\x08pagelistq\x1c(U\x08\x00\x00\x00\x00\x00\x1d51q\x1d(h\x1=
1U\x
0
>3MWpq\x1etq\x1ftq QU\x12__ac_permissions__q!)U\x07__doc__q"U\x0ePage
>organizerq#U\x0ecountableitemsq$(U\x08\x00\x00\x00\x00\x00\x1d52q%(h\x1=
1U\x
0
>3MWpq&tq\'tq(QU\rdtmldocseqoldq)(U\x08\x00\x00\x00\x00\x00\x1d5-q*(=
h\x1
1
>U\x03MWpq+tq,tq-QU\x04iconq.U\x00U\t_p_serialq/U\x08\x03Cv\xaa\xf5\xe7\=
xf3\
x
>99q0U\x14_v_manage_path_rolesq1U\x12QSurvey/QPageClassq2U\rMessageDialo=
gq3(
U
>\x08\x00\x00\x00\x00\x00\x1d53q4(h\x11U\x03MWpq5tq6tq7QU\x12manage_chan=
geOr
d
>erq8(U\x08\x00\x00\x00\x00\x00\x1d54q9(h\x11U\x03MWpq:tq;tq<QU\x05DE=
BUGq
=3D
>(U\x08\x00\x00\x00\x00\x00\x1d55q>(h\x11U\x03MWpq?tq@tqAQU\nmeta_typ=
esqB
(
>}qC(U\npermissionqDU\x11Add
>TextQuestionsqEU\x04nameqFU\x0cTextQuestionqGU\x07productqHU\x07QSurvey=
qIU\
x
>06actionqJU3manage_addProduct/QSurvey/TextQuestionClass_factoryqKu}qL(h=
DU\x
1
>bAdd
>MultipleChoiceQuestionsqMhFU\x16MultipleChoiceQuestionqNhHhIhJU=3Dmanag=
e_addP
r
>oduct/QSurvey/MultipleChoiceQuestionClass_factoryqOu}qP(U\nvisibilityqQ=
U\x0
6
>GlobalqRU\ninterfacesqS]qT(cInterface.iclass\nInterface\nqUoqV}qW(U\x11=
_Int
e
>rface__attrsqX}qY(U\nwl_getLockqZ(cInterface.Method\nMethod\nq[o}q\\(U\=
x07_
_
>doc__q]U6 Returns the locktoken identified by the locktokenuri
>q^U\x08optionalq_}q`U\x08requiredqa(U\tlocktokenqbtqcU\x08__name__qdU\n=
wl_g
e
>tLockqeU\tinterfaceqfU\x12WriteLockInterfaceqgU\x07varargsqhNU\x06kwarg=
sqiN
U
>\npositionalqj(hbtqkubU\rwl_lockValuesql(h[o}qm(h]U_ Returns a =
sequence of
>locks. if \'killinvalids\' is true,\n invalid locks will be
>deletedqnh_}qoU\x0ckillinvalidsqpK\x00sha)hdU\rwl_lockValuesqqhfhghhNhi=
Nhj(
h
>ptqrubU\rwl_lockTokensqs(h[o}qt(h]Ue Returns a sequence of lock =
tokens. if
>\'killinvalids\' is true,\n invalid locks will be
>deletedquh_}qvhpK\x00sha)hdU\rwl_lockTokensqwhfhghhNhiNhj(hptqxubU\nwl_=
hasL
o
>ckqy(h[o}qz(h]UU Returns true if the lock identified by the token is
>attached\n to the object.
>q{h_}q|hpK\x00sha(U\x05tokenq}tq~hdU\nwl_hasLockq\x7fhfhghhNhiNhj(h}hpt=
q\x8
0
>ubU\x0bwl_isLockedq\x81(h[o}q\x82(h]Uh Returns true if \'self\' is =
locked
at
>all. If invalid locks\n still exist, they should be
>deleted.q\x83h_}q\x84ha)hdU\x0bwl_isLockedq\x85hfhghhNhiNhj)ubU\nwl_set=
Lock
q
>\x86(h[o}q\x87(h]U\xef Store the LockItem, \'lock\'. The locktoken =
will be
>used to fetch\n and delete the lock. If the lock exists, this
MUST\n
>overwrite it if all of the values except for the \'timeout\' on the\n
>old and new lock are the same.
>q\x88h_}q\x89ha(hbU\x04lockq\x8atq\x8bhdU\nwl_setLockq\x8chfhghhNhiNhj(=
hbh\
x
>8atq\x8dubU\rwl_clearLocksq\x8e(h[o}q\x8f(h]Uc Deletes ALL DAV locks =
on the
>object - should only be called\n by lock management machinery.
>q\x90h_}q\x91ha)hdU\rwl_clearLocksq\x92hfhghhNhiNhj)ubU\x0cwl_lockItems=
q\x9
3
>(h[o}q\x94(h]U\xa1 Returns (key, value) pairs of locktoken, lock.\n\n
>if \'killinvalids\' is true, invalid locks (locks whose timeout\n
has
>been exceeded) will be
>deletedq\x95h_}q\x96hpK\x00sha)hdU\x0cwl_lockItemsq\x97hfhghhNhiNhj(hpt=
q\x9
8
>ubU\nwl_delLockq\x99(h[o}q\x9a(h]U6 Deletes the locktoken identified =
by the
>locktokenuri
>q\x9bh_}q\x9cha(hbtq\x9dhdU\nwl_delLockq\x9ehfhghhNhiNhj(hbtq\x9fubuh]T=
\xd6
\
>x03\x00\x00 This represents the basic protocol needed to support =
the
>write lock\n machinery.\n\n It must be able to answer the
>questions:\n\n o Is the object locked?\n\n o Is the lock owned =
by
>the current user?\n\n o What lock tokens are associated with the
current
>object?\n\n o What is their state (how long until they\'re =
supposed to
>time out?,\n what is their depth? what type are they?\n\n =
And it
>must be able to do the following:\n\n o Grant a write lock on the
object
>to a specified user.\n\n - *If lock depth is infinite, this must =
also
>grant locks on **all**\n subobjects, or fail altogether*\n\n =
o
>Revoke a lock on the object.\n\n - *If lock depth is infinite, =
this
>must also revoke locks on all\n subobjects*\n\n **All =
methods in
>the WriteLock interface that deal with checking valid\n locks MUST =
check
>the timeout values on the lockitem (ie, by calling\n
>\'lockitem.isValid()\'), and DELETE the lock if it is no longer =
valid**\n\n
>q\xa0U\t__bases__q\xa1((hUoq\xa2}q\xa3(hX}q\xa4h]U\x00h\xa1)hdU\tInterf=
aceq
\
>xa5ubtq\xa6hdhgubaU\x06actionq\xa7U"manage_addProduct/OFSP/documentAddq=
\xa8
U
>\npermissionq\xa9U Add Documents, Images, and
>Filesq\xaaU\x04nameq\xabU\rDTML
>Documentq\xacU\x07productq\xadU\x04OFSPq\xaeU\x08instanceq\xafcOFS.DTML=
Docu
m
>ent\nDTMLDocument\nq\xb0u}q\xb1(hQhRhS]q\xb2hVah\xa7U\x1fmanage_addProd=
uct/
O
>FSP/imageAddq\xb3h\xa9h\xaah\xabU\x05Imageq\xb4h\xadh\xaeh\xafcOFS.Imag=
e\nI
m
>age\nq\xb5u}q\xb6(hQhRhS]q\xb7hVah\xa7U+manage_addProduct/PythonScripts=
/pyS
c
>riptAddq\xb8h\xa9U\x12Add Python Scriptsq\xb9h\xabU\x0fScript
>(Python)q\xbah\xadU\rPythonScriptsq\xbbh\xafcProducts.PythonScripts.Pyt=
honS
c
>ript\nPythonScript\nq\xbcutq\xbdU\x0corder_manageq\xbe(U\x08\x00\x00\x0=
0\x0
0
>\x00\x1d5;q\xbf(h\x11U\x03MWpq\xc0tq\xc1tq\xc2QU\x16copy_of_countableit=
emsq
\
>xc3(U\x08\x00\x00\x00\x00\x00\x1d56q\xc4(h\x11U\x03MWpq\xc5tq\xc6tq\xc7=
QU\x
0
>fbranch_questionq\xc8U\x00U\nsubmittextq\xc9U\x19Continue to next
>questionq\xcaU\x0emanage_optionsq\xcb(}q\xcc(U\x05labelq\xcdU\x08Conten=
tsq\
x
>ceU\x06actionq\xcfU\x0bmanage_mainq\xd0u}q\xd1(h\xcdU\x04Viewq\xd2h\xcf=
U\ni
n
>dex_htmlq\xd3u}q\xd4(U\x05labelq\xd5U\nTransitionq\xd6U\x06actionq\xd7U=
\x11
t
>ransition_manageq\xd8u}q\xd9(h\xd5U\x11Sub-item_Sequenceq\xdah\xd7U\x0c=
orde
r
>_manageq\xdbu}q\xdc(U\x05labelq\xddU\x0bButton_Textq\xdeU\x06actionq\xd=
fU%p
r
>opertysheets/text_for_button/manageq\xe0u}q\xe1(U\x05labelq\xe2U\x04fre=
qq\x
e
>3U\x06actionq\xe4U\x0bfrequenciesq\xe5utq\xe6U\x0bfrequenciesq\xe7(U\x0=
8\x0
0
>\x00\x00\x00\x00\x1d58q\xe8(h\x11U\x03MWpq\xe9tq\xeatq\xebQU\x13copy_of=
_fre
q
>uenciesq\xec(U\x08\x00\x00\x00\x00\x00\x1d57q\xed(h\x11U\x03MWpq\xeetq\=
xeft
q
>\xf0QU\x11transition_manageq\xf1(U\x08\x00\x00\x00\x00\x00\x1d59q\xf2(h=
\x11
U
>\x03MWpq\xf3tq\xf4tq\xf5QU\x17manage_changeTransitionq\xf6(U\x08\x00\x0=
0\x0
0
>\x00\x00\x1d5:q\xf7(h\x11U\x03MWpq\xf8tq\xf9tq\xfaQU\n__module__q\xfbU\=
x19*
E
>LIY0U9FYpg1J7Ri7r2f5w=3D=3Dq\xfcutq\xfdt.N.')</li>
>
></ul>Could not load oid =1D3=C1, pickled data in traceback info =
may
>contain clues
></p>
>-->
>
>
>
>
>_______________________________________________
>Zope maillist - Zope@zope.org
>http://lists.zope.org/mailman/listinfo/zope
>** No cross posts or HTML encoding! **
>(Related lists -=20
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
> =20
>
_______________________________________________
Zope maillist - Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -=20
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )