[Zope-dev] Zope-2.7.3, Ape-1.0+ (from cvs) and mysql 4.0.20 raises UnpicklingError

2004-11-18 Thread jcc
Hi all,

I have spent over two days testing the Ape product, and all the time I
become the error UnpicklingError,  unpickling stack underflow .

Here are my results:

- Using a filesystem database works fine.
- Since mysql creates the tables as myisam (non-transactional) per
default after some failed tests I tweaked the code, so that the tables
are created as InnoDB.
- I have tried a fresh installed zope.
- I have put some LOG statements into the code and here is the log:

--
2004-11-18T18:00:58 INFO(0) ZODB conflict error at
/sql/manage_addProduct/OFSP/addDTMLMethod (1 conflicts since startup at
2004-11-18T17:59:31)
--
2004-11-18T18:00:59 INFO(0) apelib.zodb3.connection.setstate p = (dp1
S'class_name' p2 S'OFS.Folder.Folder' p3 sS'mapper_name' p4 S'folder' p5
s.(dp6 S'modtime' p7 L1100797193L sS'items' p8 (lp9 sS'id' p10 S'sql'
p11 sS'security' p12 (lp13 (S'executable-owner' S'' S''
S'acl_users/jcoruna' tp14 a(S'local-role' S'Owner' S'' S'jcoruna' tp15
asS'remainder' p16 Sarray('c') p17 sS'properties' p18 (lp19 (S'title'
p20 S'string' p21 S'' tp22 as.
--
2004-11-18T18:00:59 INFO(0) zodb3.serializers.RemainingState.deserialize
state = array('c')
--
2004-11-18T18:00:59 ERROR(200) ZODB Couldn't load state for '5'
Traceback (most recent call last):
  File
/usr/lib/zope/lib/python/Products/Ape/lib/apelib/zodb3/connection.py,
line 360, in setstate
event = osio.deserialize(oid, obj, classification, state)
  File /usr/lib/zope/lib/python/Products/Ape/lib/apelib/core/io.py,
line 160, in deserialize
mapper.serializer.deserialize(event, state)
  File
/usr/lib/zope/lib/python/Products/Ape/lib/apelib/core/serializers.py,
line 121, in deserialize
s.deserialize(event, state)
  File
/usr/lib/zope/lib/python/Products/Ape/lib/apelib/zodb3/serializers.py,
line 293, in deserialize
s = u.load()
UnpicklingError: unpickling stack underflow


I think that the problem is that ape tries to unpickle the string
array('c') and fails.

Any clues?

Sorry for the long post, but I think it's worth the length.


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )


RE: [Zope-dev] Zope-2.7.3, Ape-1.0+ (from cvs) and mysql 4.0.20 raises UnpicklingError

2004-11-18 Thread jcc
I think this is not hte problem since Ape creates the database tables
and its columns from scratch. You only must create the database. Anyway,
after inspecting the tables I show a lot of blob columns.

-Mensaje original-
De: Andy Dustman [mailto:[EMAIL PROTECTED] 
Enviado el: jueves, 18 de noviembre de 2004 18:33
Para: [EMAIL PROTECTED]
Asunto: Re: [Zope-dev] Zope-2.7.3, Ape-1.0+ (from cvs) and mysql 4.0.20
raises UnpicklingError


What column type are you using in MySQL? I would expect that you need
BLOB, but I have no experience with APE.


On Thu, 18 Nov 2004 18:23:27 +0100, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 Hi all,
 
 I have spent over two days testing the Ape product, and all the time I

 become the error UnpicklingError,  unpickling stack underflow .
 
 Here are my results:
 
 - Using a filesystem database works fine.
 - Since mysql creates the tables as myisam (non-transactional) per 
 default after some failed tests I tweaked the code, so that the tables

 are created as InnoDB.
 - I have tried a fresh installed zope.
 - I have put some LOG statements into the code and here is the log:
 
 --
 2004-11-18T18:00:58 INFO(0) ZODB conflict error at 
 /sql/manage_addProduct/OFSP/addDTMLMethod (1 conflicts since startup 
 at
 2004-11-18T17:59:31)
 --
 2004-11-18T18:00:59 INFO(0) apelib.zodb3.connection.setstate p = (dp1
 S'class_name' p2 S'OFS.Folder.Folder' p3 sS'mapper_name' p4 S'folder'
p5
 s.(dp6 S'modtime' p7 L1100797193L sS'items' p8 (lp9 sS'id' p10 S'sql'
 p11 sS'security' p12 (lp13 (S'executable-owner' S'' S''
 S'acl_users/jcoruna' tp14 a(S'local-role' S'Owner' S'' S'jcoruna' tp15
 asS'remainder' p16 Sarray('c') p17 sS'properties' p18 (lp19
(S'title'
 p20 S'string' p21 S'' tp22 as.
 --
 2004-11-18T18:00:59 INFO(0)
zodb3.serializers.RemainingState.deserialize
 state = array('c')
 --
 2004-11-18T18:00:59 ERROR(200) ZODB Couldn't load state for '5'
 Traceback (most recent call last):
   File

/usr/lib/zope/lib/python/Products/Ape/lib/apelib/zodb3/connection.py,
 line 360, in setstate
 event = osio.deserialize(oid, obj, classification, state)
   File /usr/lib/zope/lib/python/Products/Ape/lib/apelib/core/io.py,
 line 160, in deserialize
 mapper.serializer.deserialize(event, state)
   File

/usr/lib/zope/lib/python/Products/Ape/lib/apelib/core/serializers.py,
 line 121, in deserialize
 s.deserialize(event, state)
   File

/usr/lib/zope/lib/python/Products/Ape/lib/apelib/zodb3/serializers.py,
 line 293, in deserialize
 s = u.load()
 UnpicklingError: unpickling stack underflow
 
 
 I think that the problem is that ape tries to unpickle the string 
 array('c') and fails.
 
 Any clues?
 
 Sorry for the long post, but I think it's worth the length.
 
 ___
 Zope-Dev maillist  -  [EMAIL PROTECTED] 
 http://mail.zope.org/mailman/listinfo/zope-dev
 **  No cross posts or HTML encoding!  **
 (Related lists -  http://mail.zope.org/mailman/listinfo/zope-announce
  http://mail.zope.org/mailman/listinfo/zope )
 


-- 
Computer interfaces should never be made of meat.

Using GMail? Setting Reply-to address to  disables this annoying
feature.

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )