jdbc is either postgresql-8.3-604.jdbc4.jar (jdbc4 for jdk1.6) or postgresql-8.3-604.jdbc3.jar (jdbc3 for jdk1.5).
On Sun, Feb 22, 2009 at 2:55 PM, Hansen Wang <[email protected]> wrote: > I can confirm that this is not caused by low memory. I have been monitoring > the memory and there are not such signs. I believe it is a combination of > the code and the database server I am running with. Does any body use this > combination (jdk1.5/1.6 + psql (PostgreSQL) 7.4.19 + redhat dedora > 2.6.9-42.0.3.EL)? I will try to change or upgrade the database. Thanks. > > > On Sun, Feb 22, 2009 at 1:03 PM, BJ Freeman <[email protected]> wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> from the logs you don't have a DB deadlock problem but the EEAS is >> failing. >> so the question is why is not the data being passed. >> the only other thing different is permissions. >> possibly not enough memory. >> >> Hansen Wang sent the following on 2/22/2009 11:24 AM: >> > The same configuration and data work fine in windows. Only difference is >> > that I have a newer version of postgreSQL (8.4) in windows. >> > >> > I tried to run it with 1.6 with jdbc4, still no difference that 1.5 with >> > jdbc3. >> > >> > I tried to make sendOrderCompleteNotification (invoked by eca of >> > changeOrderStatus to COMPLETED) run as syn. see some improvement that it >> > gets to the point of sending the email and creating communication event. >> > >> > I tried to remove sendOrderCompleteNotification from the above eca. it >> > works. >> > >> > So ther problem is between sendOrderCompletedNotification (after >> inserting >> > communication event) and the rest. Given my time constraints, I do not >> think >> > that I will be able to find and resolve the deadlock problem in java >> level >> > given the code is relative stable and many projects are using it. What I >> > would like to do is just want to get around it by either changing the >> server >> > env or re-arranging the executinon sequnce. Any advise is appreciated. >> > >> > >> > >> > On Sun, Feb 22, 2009 at 5:12 AM, BJ Freeman <[email protected]> >> wrote: >> > >> > not sure ofbiz 4.0 will run on 1.5. >> > would check the proper driver for PostgreSQL 7.4.19 are being used in >> ofbiz >> > looks like a loop after the first warning >> > [ServiceEcaCondition.java:127:WARN ] From Field (communicationEventId) >> is >> >>>> not found in context for createWorkEffort, defaulting to null. >> > >> > Hansen Wang sent the following on 2/22/2009 3:57 AM: >> >>>> I encountered the following deadlock when I tried to quick ship an >> entire >> >>>> order. >> >>>> >> >>>> The server environment are as bellows: >> >>>> >> >>>> psql (PostgreSQL) 7.4.19 >> >>>> 2.6.9-42.0.3.EL #1 Mon Sep 25 17:14:19 EDT 2006 i686 athlon i386 >> > GNU/Linux >> >>>> java version "1.5.0_06" >> >>>> ofbiz4.0 >> >>>> >> >>>> Please note that the order is the only order in the system. >> >>>> >> >>>> Attached bellow are db locks and ofbiz log. There may not be enough >> >>>> information to pinpoint the cause of the >> >>>> problem by examining the following logs. But please let me know if >> you >> > have >> >>>> seen similar problem like this >> >>>> before. >> >>>> >> >>>> >> >>>> 1. object locks sort by name. nothing suspecious from here. >> >>>> >> >>>> relname | relation | database | transaction | >> pid >> >>>> | mode | granted >> >>>> >> > >> -------------------------------+----------+----------+-------------+------+------------------+--------- >> >>>> contact_mech | 2644120 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> content | 2644156 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> data_resource | 2644335 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> entity_sync_remove | 2644501 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> entity_sync_remove | 2644501 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> facility | 2644547 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> facility | 2644547 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> facility_contact_mech_purpose | 2644563 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> inventory_item | 2644829 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> inventory_item | 2644829 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> item_issuance | 2644925 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> item_issuance | 2644925 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> item_issuance | 2644925 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> item_issuance_role | 2644929 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> item_issuance_role | 2644929 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> job_sandbox | 2644933 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> job_sandbox | 2644933 | 2643821 | | >> 9535 >> > | >> >>>> RowExclusiveLock | t >> >>>> note_data | 2644988 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_adjustment | 2645019 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_contact_mech | 2645051 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_header | 2645067 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_header | 2645067 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> order_header | 2645067 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> order_item | 2645079 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item | 2645079 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> order_item | 2645079 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> order_item_ship_group | 2645115 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item_ship_group_assoc | 2645119 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item_ship_grp_inv_res | 2645123 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item_ship_grp_inv_res | 2645123 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> order_role | 2645147 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_shipment | 2645151 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_status | 2645155 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_status | 2645155 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> party | 2645186 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> party | 2645186 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> party_contact_mech | 2645217 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> party_role | 2645293 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> party_role | 2645293 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> party_role | 2645293 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> pg_class | 1259 | 2643821 | | >> 9660 >> > | >> >>>> AccessShareLock | t >> >>>> pg_locks | 16759 | 2643821 | | >> 9660 >> > | >> >>>> AccessShareLock | t >> >>>> pk_user_login | 2646560 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> postal_address | 2645443 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> postal_address | 2645443 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> product | 2645483 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> product | 2645483 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> product_store | 2645789 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> return_item | 2646009 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> role_type | 2646041 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> role_type | 2646041 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> rtn_itm_byorditm | 2656311 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> runtime_data | 2646049 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> runtime_data | 2646049 | 2643821 | | >> 9535 >> > | >> >>>> RowShareLock | t >> >>>> runtime_data | 2646049 | 2643821 | | >> 9535 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment | 2646157 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment | 2646157 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> shipment | 2646157 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_item | 2646181 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_item | 2646181 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> shipment_item | 2646181 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_method_type | 2646193 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_method_type | 2646193 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> shipment_package | 2646197 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_route_segment | 2646220 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_route_segment | 2646220 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_status | 2646227 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_status | 2646227 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_type | 2646231 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_type | 2646231 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> status_item | 2646279 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> status_item | 2646279 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> status_valid_change | 2646287 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> telecom_number | 2646444 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> telecom_number | 2646444 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9535 >> > | >> >>>> RowShareLock | t >> >>>> user_login_security_group | 2646566 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort | 2646661 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort | 2646661 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> work_effort | 2646661 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_attribute | 2646688 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_content | 2646700 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_keyword | 2646740 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_keyword | 2646740 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_note | 2646744 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_party_assignment | 2646748 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_party_assignment | 2646748 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_status | 2646775 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_status | 2646775 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_type | 2646783 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_type | 2646783 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> >> >>>> >> >>>> 2. object locks sort pid. nothing suspecious from here. >> >>>> >> >>>> relname | relation | database | transaction | >> pid >> >>>> | mode | granted >> >>>> >> > >> -------------------------------+----------+----------+-------------+------+------------------+--------- >> >>>> contact_mech | 2644120 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> content | 2644156 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> data_resource | 2644335 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> entity_sync_remove | 2644501 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> entity_sync_remove | 2644501 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> facility | 2644547 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> facility | 2644547 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> facility_contact_mech_purpose | 2644563 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> inventory_item | 2644829 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> inventory_item | 2644829 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> item_issuance | 2644925 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> item_issuance | 2644925 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> item_issuance | 2644925 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> item_issuance_role | 2644929 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> item_issuance_role | 2644929 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> note_data | 2644988 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_adjustment | 2645019 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_contact_mech | 2645051 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_header | 2645067 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_header | 2645067 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> order_header | 2645067 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> order_item | 2645079 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item | 2645079 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> order_item | 2645079 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> order_item_ship_group | 2645115 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item_ship_group_assoc | 2645119 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item_ship_grp_inv_res | 2645123 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_item_ship_grp_inv_res | 2645123 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> order_role | 2645147 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_shipment | 2645151 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_status | 2645155 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> order_status | 2645155 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> party | 2645186 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> party | 2645186 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> party_contact_mech | 2645217 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> party_role | 2645293 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> party_role | 2645293 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> party_role | 2645293 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> postal_address | 2645443 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> postal_address | 2645443 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> product | 2645483 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> product | 2645483 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> product_store | 2645789 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> return_item | 2646009 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> role_type | 2646041 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> role_type | 2646041 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> rtn_itm_byorditm | 2656311 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment | 2646157 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment | 2646157 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> shipment | 2646157 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_item | 2646181 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_item | 2646181 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> shipment_item | 2646181 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_method_type | 2646193 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_method_type | 2646193 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> shipment_package | 2646197 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_route_segment | 2646220 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_route_segment | 2646220 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_status | 2646227 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_status | 2646227 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> shipment_type | 2646231 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> shipment_type | 2646231 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> status_item | 2646279 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> status_item | 2646279 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> status_valid_change | 2646287 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> telecom_number | 2646444 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> telecom_number | 2646444 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> user_login_security_group | 2646566 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort | 2646661 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort | 2646661 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> work_effort | 2646661 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_attribute | 2646688 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_content | 2646700 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_keyword | 2646740 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_keyword | 2646740 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_note | 2646744 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_party_assignment | 2646748 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_party_assignment | 2646748 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_status | 2646775 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_status | 2646775 | 2643821 | | >> 9483 >> > | >> >>>> RowExclusiveLock | t >> >>>> work_effort_type | 2646783 | 2643821 | | >> 9483 >> > | >> >>>> AccessShareLock | t >> >>>> work_effort_type | 2646783 | 2643821 | | >> 9483 >> > | >> >>>> RowShareLock | t >> >>>> job_sandbox | 2644933 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> job_sandbox | 2644933 | 2643821 | | >> 9535 >> > | >> >>>> RowExclusiveLock | t >> >>>> pk_user_login | 2646560 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> runtime_data | 2646049 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> runtime_data | 2646049 | 2643821 | | >> 9535 >> > | >> >>>> RowShareLock | t >> >>>> runtime_data | 2646049 | 2643821 | | >> 9535 >> > | >> >>>> RowExclusiveLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9535 >> > | >> >>>> AccessShareLock | t >> >>>> user_login | 2646558 | 2643821 | | >> 9535 >> > | >> >>>> RowShareLock | t >> >>>> pg_class | 1259 | 2643821 | | >> 9660 >> > | >> >>>> AccessShareLock | t >> >>>> pg_locks | 16759 | 2643821 | | >> 9660 >> > | >> >>>> AccessShareLock | t >> >>>> >> >>>> >> >>>> 3. transaction locks. transaxtion 923120 has two postgres process >> 9483 >> > and >> >>>> 9535. how did this happen? >> >>>> it seems caused by runAsyn using the same transaxtion context? >> >>>> >> >>>> relation | database | transaction | pid | mode | granted >> >>>> ----------+----------+-------------+------+---------------+--------- >> >>>> | | 923120 | 9483 | ExclusiveLock | t >> >>>> | | 923120 | 9535 | ShareLock | f >> >>>> | | 923136 | 9535 | ExclusiveLock | t >> >>>> | | 923210 | 9660 | ExclusiveLock | t >> >>>> >> >>>> 4. ofbiz logs. >> >>>> >> >>>> 2009-02-22 04:13:18,628 (http-0.0.0.0-8443-Processor4) [ >> >>>> ControlServlet.java:90 :INFO ] The character encoding of the request >> is: >> >>>> [null]. The character encoding we will use for the request and >> response >> > is: >> >>>> [UTF-8] >> >>>> 2009-02-22 04:13:18,629 (http-0.0.0.0-8443-Processor4) [ >> >>>> RequestHandler.java:236:INFO ] [Processing Request]: quickShipOrder >> >>>> sessionId=2C128ED9735B132A42285B1D4025C7B8.jvm1 >> >>>> 2009-02-22 04:13:18,776 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> [Shipment]; >> >>>> curSeqId=10040, maxSeqId=10050, bankSize=10 >> >>>> 2009-02-22 04:13:18,869 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> [WorkEffort]; >> >>>> curSeqId=10040, maxSeqId=10050, bankSize=10 >> >>>> 2009-02-22 04:13:18,881 (http-0.0.0.0-8443-Processor4) [ >> >>>> EntityEcaRule.java:111:INFO ] Running Entity ECA Service: >> >>>> indexWorkEffortKeywords, triggered by rule on Entity: WorkEffort >> >>>> 2009-02-22 04:13:19,387 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> quickAssignPartyToWorkEffort, triggered by rule on Service: >> > createWorkEffort >> >>>> 2009-02-22 04:13:19,399 (http-0.0.0.0-8443-Processor4) >> >>>> [ServiceEcaCondition.java:127:WARN ] From Field >> (communicationEventId) is >> >>>> not found in context for createWorkEffort, defaulting to null. >> >>>> 2009-02-22 04:13:19,400 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][communicationEventId][is-not-empty][null][][true][String][] >> >>>> 2009-02-22 04:13:19,423 (http-0.0.0.0-8443-Processor4) [ >> >>>> EntityEcaRule.java:111:INFO ] Running Entity ECA Service: >> >>>> indexWorkEffortKeywords, triggered by rule on Entity: WorkEffort >> >>>> 2009-02-22 04:13:19,454 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> quickAssignPartyToWorkEffort, triggered by rule on Service: >> > createWorkEffort >> >>>> 2009-02-22 04:13:19,458 (http-0.0.0.0-8443-Processor4) >> >>>> [ServiceEcaCondition.java:127:WARN ] From Field >> (communicationEventId) is >> >>>> not found in context for createWorkEffort, defaulting to null. >> >>>> 2009-02-22 04:13:19,459 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][communicationEventId][is-not-empty][null][][true][String][] >> >>>> 2009-02-22 04:13:19,468 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][SHIPMENT_SCHEDULED][true][String][] >> >>>> 2009-02-22 04:13:19,469 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> setShipmentSettingsFromFacilities, triggered by rule on Service: >> >>>> createShipment >> >>>> 2009-02-22 04:13:19,479 (http-0.0.0.0-8443-Processor4) [ >> >>>> FieldToResult.java:66 :WARN ] Field value not found with name >> >>>> lookedUpValue.shipmentTypeId in Map with name >> >>>> 2009-02-22 04:13:19,480 (http-0.0.0.0-8443-Processor4) [ >> >>>> FieldToResult.java:66 :WARN ] Field value not found with name >> >>>> lookedUpValue.destinationFacilityId in Map with name >> >>>> 2009-02-22 04:13:19,486 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][SHIPMENT_PACKED][true][String][] >> >>>> 2009-02-22 04:13:19,487 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_RECEIVED][true][String][] >> >>>> 2009-02-22 04:13:19,488 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_SHIPPED][true][String][] >> >>>> 2009-02-22 04:13:19,489 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_RECEIVED][true][String][] >> >>>> 2009-02-22 04:13:19,489 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_RECEIVED][true][String][] >> >>>> 2009-02-22 04:13:19,490 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][SHIPMENT_SCHEDULED][true][String][] >> >>>> 2009-02-22 04:13:19,491 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> >> > >> [null][][originFacilityId][not-equals][][oldOriginFacilityId][false][String][] >> >>>> 2009-02-22 04:13:19,492 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][destinationFacilityId][is-not-empty][null][][true][String][] >> >>>> 2009-02-22 04:13:19,492 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> >> > >> [null][][primaryOrderId][not-equals][][oldPrimaryOrderId][false][String][] >> >>>> 2009-02-22 04:13:19,493 (http-0.0.0.0-8443-Processor4) >> >>>> [ServiceEcaCondition.java:127:WARN ] From Field >> (destinationFacilityId) >> > is >> >>>> not found in context for createShipment, defaulting to null. >> >>>> 2009-02-22 04:13:19,494 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][destinationFacilityId][is-not-empty][null][][true][String][] >> >>>> 2009-02-22 04:13:19,495 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> setShipmentSettingsFromPrimaryOrder, triggered by rule on Service: >> >>>> createShipment >> >>>> 2009-02-22 04:13:19,611 (http-0.0.0.0-8443-Processor4) [ >> >>>> FieldToResult.java:66 :WARN ] Field value not found with name >> >>>> lookedUpValue.shipmentTypeId in Map with name >> >>>> 2009-02-22 04:13:19,624 (http-0.0.0.0-8443-Processor4) [ >> >>>> FieldToResult.java:66 :WARN ] Field value not found with name >> >>>> lookedUpValue.destinationFacilityId in Map with name >> >>>> 2009-02-22 04:13:19,629 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][SHIPMENT_PACKED][true][String][] >> >>>> 2009-02-22 04:13:19,630 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_RECEIVED][true][String][] >> >>>> 2009-02-22 04:13:19,631 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_SHIPPED][true][String][] >> >>>> 2009-02-22 04:13:19,632 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_RECEIVED][true][String][] >> >>>> 2009-02-22 04:13:19,632 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][PURCH_SHIP_RECEIVED][true][String][] >> >>>> 2009-02-22 04:13:19,633 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][SHIPMENT_SCHEDULED][true][String][] >> >>>> 2009-02-22 04:13:19,634 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> >> > >> [null][][originFacilityId][not-equals][][oldOriginFacilityId][false][String][] >> >>>> 2009-02-22 04:13:19,635 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][destinationFacilityId][is-not-empty][null][][true][String][] >> >>>> 2009-02-22 04:13:19,635 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> >> > >> [null][][primaryOrderId][not-equals][][oldPrimaryOrderId][false][String][] >> >>>> 2009-02-22 04:13:19,692 (http-0.0.0.0-8443-Processor4) [ >> >>>> Log.java:94 :INFO ] order item ship grp inv res info: >> >>>> [GenericEntity:OrderItemShipGrpInvRes][createdDatetime,2009-02-22 >> >>>> 00:50:40.581(java.sql.Timestamp)][createdStamp,2009-02-22 >> >>>> 00:50:40.581(java.sql.Timestamp)][createdTxStamp,2009-02-22 >> >>>> >> > >> 00:50:38.29(java.sql.Timestamp)][currentPromisedDate,null()][inventoryItemId,87976(java.lang.String)][lastUpdatedStamp,2009-02-22 >> >>>> 00:50:40.581(java.sql.Timestamp)][lastUpdatedTxStamp,2009-02-22 >> >>>> >> > >> 00:50:38.29(java.sql.Timestamp)][oldPickStartDate,null()][orderId,GM10000(java.lang.String)][orderItemSeqId,00001(java.lang.String)][promisedDatetime,2009-03-24 >> > >> 00:50:38.35(java.sql.Timestamp)][quantity,1.0(java.lang.Double)][quantityNotAvailable,null()][reserveOrderEnumId,INVRO_FIFO_REC(java.lang.String)][reservedDatetime,2009-02-22 >> >>>> >> 00:50:40.581(java.sql.Timestamp)][shipGroupSeqId,00001(java.lang.String)] >> >>>> 2009-02-22 04:13:19,705 (http-0.0.0.0-8443-Processor4) [ >> >>>> Calculate.java:342:INFO ] Field not found with field-name >> >>>> orderShipment.quantity, and map-name using a default of 0 >> >>>> 2009-02-22 04:13:19,720 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> checkCreateStockRequirementQoh, triggered by rule on Service: >> >>>> createItemIssuance >> >>>> 2009-02-22 04:13:19,812 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> > [ItemIssuance]; >> >>>> curSeqId=10040, maxSeqId=10050, bankSize=10 >> >>>> 2009-02-22 04:13:19,910 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> >>>> [EntitySyncRemove]; curSeqId=10050, maxSeqId=10060, bankSize=10 >> >>>> 2009-02-22 04:13:19,958 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> [OrderStatus]; >> >>>> curSeqId=10040, maxSeqId=10050, bankSize=10 >> >>>> 2009-02-22 04:13:19,978 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][ITEM_CANCELLED][true][String][] >> >>>> 2009-02-22 04:13:19,979 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> checkOrderItemStatus, triggered by rule on Service: >> changeOrderItemStatus >> >>>> 2009-02-22 04:13:19,994 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:112:INFO ] Got false for condition: >> >>>> [null][][statusId][equals][null][ORDER_CANCELLED][true][String][] >> >>>> 2009-02-22 04:13:19,995 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> > resetGrandTotal, >> >>>> triggered by rule on Service: changeOrderStatus >> >>>> 2009-02-22 04:13:20,004 (http-0.0.0.0-8443-Processor4) [ >> >>>> ServiceEcaRule.java:137:INFO ] Running Service ECA Service: >> >>>> sendOrderCompleteNotification, triggered by rule on Service: >> >>>> changeOrderStatus >> >>>> 2009-02-22 04:13:20,007 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> [RuntimeData]; >> >>>> curSeqId=10040, maxSeqId=10050, bankSize=10 >> >>>> 2009-02-22 04:13:20,054 (http-0.0.0.0-8443-Processor4) [ >> >>>> SequenceUtil.java:254:INFO ] Got bank of sequenced IDs for >> [JobSandbox]; >> >>>> curSeqId=10060, maxSeqId=10070, bankSize=10 >> >>>> >> >> >> >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.4.6 (MingW32) >> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org >> >> iD8DBQFJoa+mrP3NbaWWqE4RAtMtAJ9hB4MO5hzF6n1h41rqDrn2r098hgCgneDL >> oedZgdu4/dbAlcVlNIqLcOY= >> =ewJz >> -----END PGP SIGNATURE----- >> > >
