[Erp5-dev] Problems with upgrading site from old revision

[Łukasz K. Nowak]

Hello,

I'm trying to do classic upgrade od very old (r10526) site.
Site is running on mdv2006.0, x86.

That's what I have done:
* upgraded to newest version of products from rpms
* upgraded to r14753 of products: CMFActivity, CMFCategory, ERP5,
ERP5Catalog, ERP5Form, ERP5OOo, ERP5Security, ERP5Subversion,
ERP5SyncML, ERP5Type, TimerService, ZMySQLDDA, ZSQLCatalog
* installed python-memcached
* added cache tool, as instructed in r11019
http://www.erp5.org/UpgradeNote
* installed erp5_mysql_innodb_catalog
* followed instructions from
http://thread.gmane.org/gmane.comp.python.zope.erp5.devel/800 (BTW -
wouldn't it be good to have it in UpgradeNote) to switch to new catalog.

Problems:
2007-06-11T10:53:47 PROBLEM(100) Cache.__call__ Factory
erp5_content_long not found, method <function _getColumnMap at
0xf0d9b8b4> executed without cache

And very, very many similar logs with same erp5_content_long (less with
erp5_ui_long) factory - I wasn't able to find any comments about this on
wiki or mailing lists - is there missing part of upgrade path?

While trying to recataloging site:

Traceback (most recent call last):
File "/var/lib/zope/Products/CMFActivity/ActivityTool.py", line 740,
in invokeGroup
result = method(expanded_object_list, **m.kw)
File "/var/lib/zope/Products/ZSQLCatalog/ZSQLCatalog.py", line 713, in
catalogObjectList
catalog.catalogObjectList(wrapped_object_list,**kw)
File "/var/lib/zope/Products/ZSQLCatalog/SQLCatalog.py", line 1405, in
catalogObjectList
def catalogObjectList(self, object_list, method_id_list=None,
TypeError: catalogObjectList() got an unexpected keyword argument
'priority'


I'm not able to upgrade to newer erp5_core or do anything more with
site, any try of installation of any BT ends up with:
2007-06-11T10:53:28 ERROR(200) ActivityBuffer exception during
tpc_prepare
Traceback (most recent call last):
File "/var/lib/zope/Products/CMFActivity/ActivityBuffer.py", line 165,
in tpc_prepare
activity.prepareQueueMessageList(self._activity_tool, message_list)
File "/var/lib/zope/Products/CMFActivity/Activity/SQLDict.py", line
95, in prepareQueueMessageList
uid_list =
activity_tool.getPortalObject().portal_ids.generateNewLengthIdList(id_group='portal_activity', id_count=len(r
egistered_message_list))
File "/var/lib/zope/Products/ERP5/Tool/IdTool.py", line 206, in
generateNewLengthIdList
result = query(id_group=id_group, id_count=id_count,
default=default)
File
"/usr/lib/zope/./build/build-base/python-2.4/build-lib/Shared/DC/ZRDB/DA.py", line 454, in __call__
File "/usr/lib/zope/lib/python/Products/ZMySQLDA/db.py", line 331, in
query
db.query(qs)
OperationalError: (1205, 'Lock wait timeout exceeded; try restarting
transaction')

And right now I'm stopped. Shall I choose narrower gap of revisions?

Thanks for any tips,
Luke

[Ivan Tyagov]

Post by Łukasz K. Nowak
2007-06-11T10:53:47 PROBLEM(100) Cache.__call__ Factory
erp5_content_long not found, method <function _getColumnMap at
0xf0d9b8b4> executed without cache
And very, very many similar logs with same erp5_content_long (less with
erp5_ui_long) factory - I wasn't able to find any comments about this on
wiki or mailing lists - is there missing part of upgrade path?

You can get rid of this messages quickly if you upgrade erp5_core which
will create needed Cache Factories under portal_caches and restart Zope
so changes are picked up. Currently your instance is running without
them because they aren't created (i.e no Cache is used, site is slow).

Ivan

[Łukasz K. Nowak]

Hello,

Post by Ivan Tyagov

Post by Łukasz K. Nowak
2007-06-11T10:53:47 PROBLEM(100) Cache.__call__ Factory
erp5_content_long not found, method <function _getColumnMap at
0xf0d9b8b4> executed without cache
And very, very many similar logs with same erp5_content_long (less with
erp5_ui_long) factory - I wasn't able to find any comments about this on
wiki or mailing lists - is there missing part of upgrade path?

You can get rid of this messages quickly if you upgrade erp5_core which
will create needed Cache Factories under portal_caches and restart Zope
so changes are picked up. Currently your instance is running without
them because they aren't created (i.e no Cache is used, site is slow).

Thanks! That resolved it (well - upgrading erp5_core was quite hard in
that situation, but succeed after all).

Bye,
Luke

[Łukasz K. Nowak]

Hello,

Post by Łukasz K. Nowak
I'm trying to do classic upgrade od very old (r10526) site.
Site is running on mdv2006.0, x86.
* upgraded to newest version of products from rpms
* upgraded to r14753 of products: CMFActivity, CMFCategory, ERP5,
ERP5Catalog, ERP5Form, ERP5OOo, ERP5Security, ERP5Subversion,
ERP5SyncML, ERP5Type, TimerService, ZMySQLDDA, ZSQLCatalog
* installed python-memcached
* added cache tool, as instructed in r11019
http://www.erp5.org/UpgradeNote
* installed erp5_mysql_innodb_catalog
* followed instructions from
http://thread.gmane.org/gmane.comp.python.zope.erp5.devel/800 (BTW -
wouldn't it be good to have it in UpgradeNote) to switch to new catalog.

(...)

Post by Łukasz K. Nowak
File "/var/lib/zope/Products/CMFActivity/ActivityTool.py", line 740,
in invokeGroup
result = method(expanded_object_list, **m.kw)
File "/var/lib/zope/Products/ZSQLCatalog/ZSQLCatalog.py", line 713, in
catalogObjectList
catalog.catalogObjectList(wrapped_object_list,**kw)
File "/var/lib/zope/Products/ZSQLCatalog/SQLCatalog.py", line 1405, in
catalogObjectList
def catalogObjectList(self, object_list, method_id_list=None,
TypeError: catalogObjectList() got an unexpected keyword argument
'priority'

Resolved by upgrading erp5_core *before* reindex.

Post by Łukasz K. Nowak
I'm not able to upgrade to newer erp5_core or do anything more with
2007-06-11T10:53:28 ERROR(200) ActivityBuffer exception during
tpc_prepare
File "/var/lib/zope/Products/CMFActivity/ActivityBuffer.py", line 165,
in tpc_prepare
activity.prepareQueueMessageList(self._activity_tool, message_list)
File "/var/lib/zope/Products/CMFActivity/Activity/SQLDict.py", line
95, in prepareQueueMessageList
uid_list =
activity_tool.getPortalObject().portal_ids.generateNewLengthIdList(id_group='portal_activity', id_count=len(r
egistered_message_list))
File "/var/lib/zope/Products/ERP5/Tool/IdTool.py", line 206, in
generateNewLengthIdList
result = query(id_group=id_group, id_count=id_count,
default=default)
File
"/usr/lib/zope/./build/build-base/python-2.4/build-lib/Shared/DC/ZRDB/DA.py", line 454, in __call__
File "/usr/lib/zope/lib/python/Products/ZMySQLDA/db.py", line 331, in
query
db.query(qs)
OperationalError: (1205, 'Lock wait timeout exceeded; try restarting
transaction')

Resolved: After 5 times lock haven't timeouted.

Two more problems with solution:
* attribute error on Base_getFieldDescription

Create dummy Base_getFieldDescription in custom, with *args,**kwargs
which returns '' and upgrade erp5_xhtml, then remove it

* selections do not works (eg. you are not able to select BT to
download, etc) - upgrade erp5_xhtml by upload and install.

Well, for now all is working fine :)

Thanks,
Luke