[Erp5-dev] copy or cut & paste - SQLCatalog problems

[Łukasz Nowak]

Hello,

While doing copy or cut & paste on objects in Zope (eg. Container and
Container Line type in Sale Packing List) I have WARNING from
SQLCatalog, generated by line:

LOG('SQLCatalog', WARNING,
'uid of %r changed from %r to %r as old one is assigned
to %s in catalog !!! This can be fatal. You should reindex the whole
site immediately.' % (object, uid, object.uid, catalog_path))

(about 1570 line of ZSQLCatalog/SQLCatalog.py)

And then I have to reindex whole site.

How can I fix it? What would be real problem? Is that problem
unit-tested somewhere?

Regards,
Luke

[Jean-Paul Smets]

Post by Łukasz Nowak
Hello,
While doing copy or cut & paste on objects in Zope (eg. Container and
Container Line type in Sale Packing List) I have WARNING from
LOG('SQLCatalog', WARNING,
'uid of %r changed from %r to %r as old one is assigned
to %s in catalog !!! This can be fatal. You should reindex the whole
site immediately.' % (object, uid, object.uid, catalog_path))
(about 1570 line of ZSQLCatalog/SQLCatalog.py)
And then I have to reindex whole site.
How can I fix it? What would be real problem? Is that problem
unit-tested somewhere?

Please provide a bit more information: what is the type of object
(class, portal type).

JPS.

Post by Łukasz Nowak
Regards,
Luke

[Pelletier Vincent]

Post by Jean-Paul Smets
Please provide a bit more information: what is the type of object
(class, portal type).

...and wether the path in the displayed log was a valid path something like
"deleted" or "reserved".

[Łukasz Nowak]

On 2007-09-21, 10:54:53

Post by Jean-Paul Smets

Post by Łukasz Nowak
Hello,
While doing copy or cut & paste on objects in Zope (eg. Container
and Container Line type in Sale Packing List) I have WARNING from
LOG('SQLCatalog', WARNING,
'uid of %r changed from %r to %r as old one is
assigned to %s in catalog !!! This can be fatal. You should reindex
the whole site immediately.' % (object, uid, object.uid,
catalog_path))
(about 1570 line of ZSQLCatalog/SQLCatalog.py)
And then I have to reindex whole site.
How can I fix it? What would be real problem? Is that problem
unit-tested somewhere?

Please provide a bit more information: what is the type of object
(class, portal type).

Container and Container Line moved in same/different Sale Packing Lists.

Sale Invoice Transaction Line moved from one to another Sale Invoice
Transaction.

Image and File moved from one to another Product or Component (this is
our extension).

Example logs (we've got many of them):

uid of <AccountingTransactionLine at /erp5/accounting_module/493/25>
changed from 164086L to 164080L as old one is assigned to deleted in
catalog !!! This can be fatal. You should reindex the whole site
immediately.

uid of <Container at /erp5/sale_packing_list_module/148/51/66> changed
from 162559L to 162489L as old one is assigned to deleted in
catalog !!! This can be fatal. You should reindex the whole site
immediately.

uid of <Image at /erp5/component_module/226/8> changed from 104411L to
104711L as o ld one is assigned to /erp5/component_module/225/7 in
catalog !!! This can be fatal. You should reindex the whole site
immediately.

uid of <File at /erp5/component_module/225/7> changed from 104710L
(property) to 10 4411 (catalog, by path) !!! This can be fatal. You
should reindex the whole site immediately.

Luke

[Łukasz Nowak]

Hello,

On 2007-09-21, 10:31:37

Post by Łukasz Nowak
Hello,
While doing copy or cut & paste on objects in Zope (eg. Container and
Container Line type in Sale Packing List) I have WARNING from
LOG('SQLCatalog', WARNING,
'uid of %r changed from %r to %r as old one is
assigned to %s in catalog !!! This can be fatal. You should reindex
the whole site immediately.' % (object, uid, object.uid,
catalog_path))
(about 1570 line of ZSQLCatalog/SQLCatalog.py)
And then I have to reindex whole site.
How can I fix it? What would be real problem? Is that problem
unit-tested somewhere?

I'd like to know, if this report is enough informative and confirmed.
On our installation those problems are repeating more and more (as users
are using ERP5 more...) and I really do not know if it is so bad
problem, that I shall invest in Prozac ;)...or just be calm.

If any more information, reproduction recipes or anything else is
needed I'd like to help.

Regards,
Luke