Project:
View Revisions: Issue #50549 | [ Back to Issue ] | ||
Summary | 0050549: Cycles in entities that represents data as a tree can lead to transaction that does not finish, 100% use of CPU | ||
Revision | 2022-10-25 09:36 by AugustoMauch | ||
Steps To Reproduce | - Force a cycle in the hierarchy of any Openbravo entity, i.e. this will create a cycle in the product characteristic tree of the White Valley sampledata client (electronics category will be its own parent): update ad_treenode set parent_id = '3ECCEC0B766E4A25A697187A58B15B71' where node_id = '3ECCEC0B766E4A25A697187A58B15B71'; - After that, open the Product Characteristic window under that client, change to the tree grid view and filter by entering a 'c' - Nothing will be displayed in the grid filter and a transaction will remain open in the database. You can check it by checking pg_stat_activity and kill it by invoking "select pg_terminate_backend(pid)", being the pid the pid of the stuck transaction - Fix the category data by executing: update ad_treenode set parent_id = '5AAC980A56404867815CCF2B52804080' where node_id = '3ECCEC0B766E4A25A697187A58B15B71'; |
||
Revision | 2022-10-25 09:34 by AugustoMauch | ||
Steps To Reproduce | - Force a cycle in the hierarchy of any Openbravo entity, i.e. this will create a cycle in the product characteristic tree of the White Valley sampledata client (electronics category will be its own parent): update ad_treenode set parent_id = '3ECCEC0B766E4A25A697187A58B15B71' where node_id = '3ECCEC0B766E4A25A697187A58B15B71'; - After that, open the Product Characteristic window under that client, change to the tree grid view and filter by entering a 'c' - Nothing will be displayed in the grid filter and a transaction will remain open in the database. You can check it by checking pg_stat_activity and kill it by invoking "select pg_terminate_backend(pid)", being the pid the pid of the stuck transaction |
||
Revision | 2022-10-17 11:16 by AugustoMauch | ||
Steps To Reproduce | TO BE DONE |
Copyright © 2000 - 2009 MantisBT Group |