Split multi-inserted messages into chunks, because an insert query generated by prepareQueueMessageList may exceed the limit of packet size defined by MySQL, when one transaction activate many, many methods. The max size is heuristic, though.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@28426 20353a03-c40f-0410-a6d1-a30d3c3de9de

* Remove links to cancel or invoke activities from manageActivities. It was too dangerous and requires too much work to fix.
* Fix display of args column. Use html_quote to display activity_kw, agrs & kw columns.
* Display all activities (processing SQLQueue activities were hidden).
* Add uid column.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@27474 20353a03-c40f-0410-a6d1-a30d3c3de9de

Do not notify if an active process finishes. This never worked before r27329 and it is now redundant with alarm notification.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@27332 20353a03-c40f-0410-a6d1-a30d3c3de9de

Fix ActiveProcess.hasActivity. On active processes, hasActivity tests active_process_uid instead of path:
* hasActivity must handle the case when no document is provided (bug #1142)
* Fix initialisation of active_process_uid property on Message objects.
Add unit test.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@27329 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25525 20353a03-c40f-0410-a6d1-a30d3c3de9de

Move _validate_* methods from SQLDict and SQLQueue to SQLBase, and fix checking of parameters (cf r24586).

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25481 20353a03-c40f-0410-a6d1-a30d3c3de9de

Implement ActiveProcess.hasActivity . It was present, but required data was never present in the table. Now that SQL{Dict|Queue}.hasActivity don't use "**kw" any more, it causes errors.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25274 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25270 20353a03-c40f-0410-a6d1-a30d3c3de9de

Make all dtml tests use expr="...", so that tested values don't use acquisition. (Nice catch, Nicolas !)
Update callers to cope with those new limitations.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25266 20353a03-c40f-0410-a6d1-a30d3c3de9de

Fix parameter name. Fixes a bug in which a message could be validated even if its date was set in the future.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25256 20353a03-c40f-0410-a6d1-a30d3c3de9de

Rename "limit" parameter to ZSQLMethods into "count", as it is a special parameter name (interpreted outside of ZSQLMethod).


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25253 20353a03-c40f-0410-a6d1-a30d3c3de9de

Fix error log condition: length must be exactly 2 AND type must be either tuple or list (a string of more than 2 chars was enough to avoid the error message).
Fix a typo in error message.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24586 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24099 20353a03-c40f-0410-a6d1-a30d3c3de9de

Store exception information on message in the case where commit fails, removing a possible cause for error messages with no error text.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24077 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@22741 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@22648 20353a03-c40f-0410-a6d1-a30d3c3de9de

Only validate new messages; All other states are subsequent to a validation (regular of by user's choice by modifying sql tables).
This fixes impossibility to invoke by hand validated messages not being executed when they have a serialization_tage set.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@22647 20353a03-c40f-0410-a6d1-a30d3c3de9de

Factorise code used to generate an unique identifier for messages (used to avoid inserting duplicate messages in the same transaction).


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@21754 20353a03-c40f-0410-a6d1-a30d3c3de9de

Mark messages as not executable when either their path or the method to call on it cannot be retrieved.
Make messages marked as not excutable immediately fail with VALIDATE_ERROR_STATE state.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@20311 20353a03-c40f-0410-a6d1-a30d3c3de9de

When SQL{Dict|Queue}_delMessage gets a lock error, retry. Do so infinitely, otherwise uid list would be lost and manual intervention would be required.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@20306 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19431 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19405 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19389 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19196 20353a03-c40f-0410-a6d1-a30d3c3de9de

Message tag should not be a part of the message unicity key. This change avoids counting objects multiple times for messages which are identical except for tag.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19195 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19193 20353a03-c40f-0410-a6d1-a30d3c3de9de

Instead of deleting duplicate messages, reserve them, and delete them when the "original" message has succeeded.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19192 20353a03-c40f-0410-a6d1-a30d3c3de9de

Store exception information in native format inside message. Factorises sys.exc_info calls and exception rendering code.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19169 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19095 20353a03-c40f-0410-a6d1-a30d3c3de9de

Lower log priority from PANIC to ERROR for message status handling definitive errors (reserve PANIC priority to permanent data inconsistency).
When a PANIC level error happens, re-raise after logging instead of simply returning.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19090 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19089 20353a03-c40f-0410-a6d1-a30d3c3de9de

Oops, second part of commit 19087: there are 2 places to fix in SQLDict, oposed to just 1 in SQLQueue.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19088 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19087 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19022 20353a03-c40f-0410-a6d1-a30d3c3de9de

Upgrade LOG criticalness to PANIC level when the raising code causes messages to be left with processing=1.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19015 20353a03-c40f-0410-a6d1-a30d3c3de9de

Call SQLDict_rollback/SQLQueue_rollback before makeMessageListAvailable. Similar fix is already applied to activity failure error path, but not to activity commit/abort error path.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18999 20353a03-c40f-0410-a6d1-a30d3c3de9de

Call notifyUser after doing activity state cleanup. This makes it less problematic if it raises (activities are already in a clean state).


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18985 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18927 20353a03-c40f-0410-a6d1-a30d3c3de9de

Override finishQueueMessage and finishDeleteMessage to do nothing in SQLQueue and SQLDict. Otherwise, messages are accumulated in RAM infinitely, due to RAMDict and RAMQueue.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18755 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18568 20353a03-c40f-0410-a6d1-a30d3c3de9de