Alternate Approcahes
An alternate approach to the problem could be by the use of transactions
which allow dirty read (Read uncommitted transaction data) exclusively for the
get_id method of the sequence. This would however have the same disadvantage
and a higher cost.
An even better approach would be to ensure that there are no long running
transactions in the programs you write.
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/746620
Title:
serialized transaction architecture flaw PLEASE COLLABORATE
Status in OpenERP Server:
New
Bug description:
OpenERP is classified as an Enterprise class software package. Meaning
that more than one person, at least 2 should be able to use the system
simultaneously. Like packers shipping products, taking orders,
reserving products. I find that in fact, it is not possible for
creation of stock moves simultaneously.
Say I am importing orders from a shop. It is creating stock moves because
the order is paid.
At the same time I am shipping products which is normal for an ERP system.
I might also import orders from a separate shop say a POS system.
It is not possible!
[2011-03-31 13:10:47,657][midwestsupplies] WARNING:stock.location:Failed
attempt to reserve 1.0 x product 1669, li
kely due to another transaction already in progress. Next attempt is likely
to work. Detailed error available at D
EBUG level.
OperationalError: could not obtain lock on row in relation "ir_sequence"
Two different errors.
I can only perform one action at a time!
What happens is that any time the program calls for a stock_move it will lock
the stock_move table so no other process can access it which means that you
cant do hardly anything unless its done individually. Now say with a MS system,
or any Enterprise system would be able to handle many simultaneous actions but
this program has a serious architecture flaw to not be able to support this.
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
