Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0011925 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 06. Material requirement planning (MRP) | major | have not tried | 2010-01-11 09:26 | 2011-09-15 23:00 | |||
Reporter | joan | View Status | public | |||||
Assigned To | jonalegriaesarte | |||||||
Priority | normal | Resolution | invalid | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.5.0_14-b03 | |||
OS Version | Debian Etch | Database version | 8.3 | Ant version | 1.6.5 | |||
Product Version | 2.50MP9 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0011925: MRP Purchases really slow | |||||||
Description | Hi, I have a problem with mrp, the manufacturing plan in ob2.50 mp9 is really fast (around 20 minutes) but the purchasing plan takes so long (more than 30 hours) having the processor to 100% all the time, I guess it get stucked at some point or anything. I use ob.250 MP9 now and when i've used ob.2.50 mp3 it worked better (in 5h), Is there any change that could lead to this problem? Maybe is a special case, but is really anyoing. How can i help to debug this? | |||||||
Steps To Reproduce | set an mrp Launch a manufacturing plan Launch a purchase plan | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0023312) joan (reporter) 2010-01-11 13:48 |
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ PPID COMMAND 3347 postgres 16 0 347m 299m 265m D 0 29.3 8:29.50 3275 postgres It got stucked but seams to be locked by himself! If i exec this SELECT l2.transactionid, pn.nspname, pc.relname AS tablename, pl.pid, pl.mode, pl.granted, pl.virtualtransaction FROM pg_catalog.pg_locks pl, pg_catalog.pg_class pc, pg_catalog.pg_namespace pn, pg_catalog.pg_locks l2 WHERE pl.relation = pc.oid AND pc.relnamespace=pn.oid AND nspname !~ '^pg_t(emp_[0-9]+|oast)$' and l2.locktype='transactionid' and l2.mode='ExclusiveLock' and l2.virtualtransaction=pl.virtualtransaction ORDER BY pid,nspname,tablename It shows this transactionid nspname tablename pid mode granted virtualtransaction 26527414 public ad_client 3347 RowShareLock VERDADERO 273750 26536613 public ad_client 3347 RowShareLock VERDADERO 273750 26527413 public ad_client 3347 RowShareLock VERDADERO 273750 26536613 public ad_client_key 3347 AccessShareLock VERDADERO 273750 26527414 public ad_client_key 3347 AccessShareLock VERDADERO 273750 26527413 public ad_client_key 3347 AccessShareLock VERDADERO 273750 26527413 public ad_client_name 3347 AccessShareLock VERDADERO 273750 26527414 public ad_client_name 3347 AccessShareLock VERDADERO 273750 26536613 public ad_client_name 3347 AccessShareLock VERDADERO 273750 26536613 public ad_clientinfo 3347 AccessShareLock VERDADERO 273750 26527413 public ad_clientinfo 3347 AccessShareLock VERDADERO 273750 26527414 public ad_clientinfo 3347 AccessShareLock VERDADERO 273750 26527413 public ad_org 3347 RowShareLock VERDADERO 273750 26527414 public ad_org 3347 RowShareLock VERDADERO 273750 26536613 public ad_org 3347 RowShareLock VERDADERO 273750 26536613 public ad_org_key 3347 AccessShareLock VERDADERO 273750 26527413 public ad_org_key 3347 AccessShareLock VERDADERO 273750 26527414 public ad_org_key 3347 AccessShareLock VERDADERO 273750 26527413 public ad_org_value 3347 AccessShareLock VERDADERO 273750 26527414 public ad_org_value 3347 AccessShareLock VERDADERO 273750 26536613 public ad_org_value 3347 AccessShareLock VERDADERO 273750 26527413 public ad_pinstance 3347 AccessShareLock VERDADERO 273750 26527414 public ad_pinstance 3347 AccessShareLock VERDADERO 273750 26536613 public ad_pinstance 3347 RowExclusiveLock VERDADERO 273750 26527413 public ad_pinstance 3347 RowExclusiveLock VERDADERO 273750 26527414 public ad_pinstance 3347 RowExclusiveLock VERDADERO 273750 26536613 public ad_pinstance 3347 AccessShareLock VERDADERO 273750 26527413 public ad_pinstance_key 3347 AccessShareLock VERDADERO 273750 26536613 public ad_pinstance_key 3347 AccessShareLock VERDADERO 273750 26527414 public ad_pinstance_key 3347 AccessShareLock VERDADERO 273750 26527413 public ad_pinstance_para 3347 AccessShareLock VERDADERO 273750 26536613 public ad_pinstance_para 3347 AccessShareLock VERDADERO 273750 26527414 public ad_pinstance_para 3347 AccessShareLock VERDADERO 273750 26527414 public ad_pinstance_para_key 3347 AccessShareLock VERDADERO 273750 26536613 public ad_pinstance_para_key 3347 AccessShareLock VERDADERO 273750 26527413 public ad_pinstance_para_key 3347 AccessShareLock VERDADERO 273750 26536613 public ad_pinstance_record 3347 AccessShareLock VERDADERO 273750 26527414 public ad_pinstance_record 3347 AccessShareLock VERDADERO 273750 26527413 public ad_pinstance_record 3347 AccessShareLock VERDADERO 273750 26527414 public ad_session_status 3347 AccessShareLock VERDADERO 273750 26536613 public ad_session_status 3347 AccessShareLock VERDADERO 273750 26527413 public ad_session_status 3347 AccessShareLock VERDADERO 273750 26527414 public ad_treenode 3347 AccessShareLock VERDADERO 273750 26527413 public ad_treenode 3347 AccessShareLock VERDADERO 273750 26536613 public ad_treenode 3347 AccessShareLock VERDADERO 273750 26536613 public adpinstancepara_adpinstance_un 3347 AccessShareLock VERDADERO 273750 26527414 public adpinstancepara_adpinstance_un 3347 AccessShareLock VERDADERO 273750 26527413 public adpinstancepara_adpinstance_un 3347 AccessShareLock VERDADERO 273750 26527414 public adtreenode_adtreeid_nodeid_un 3347 AccessShareLock VERDADERO 273750 26527413 public adtreenode_adtreeid_nodeid_un 3347 AccessShareLock VERDADERO 273750 26536613 public adtreenode_adtreeid_nodeid_un 3347 AccessShareLock VERDADERO 273750 26527413 public c_bpartner 3347 AccessShareLock VERDADERO 273750 26527414 public c_bpartner 3347 AccessShareLock VERDADERO 273750 26527413 public c_bpartner 3347 RowShareLock VERDADERO 273750 26536613 public c_bpartner 3347 RowShareLock VERDADERO 273750 26536613 public c_bpartner 3347 AccessShareLock VERDADERO 273750 26527414 public c_bpartner 3347 RowShareLock VERDADERO 273750 26527413 public c_bpartner_key 3347 AccessShareLock VERDADERO 273750 26527414 public c_bpartner_key 3347 AccessShareLock VERDADERO 273750 26536613 public c_bpartner_key 3347 AccessShareLock VERDADERO 273750 26536613 public c_bpartner_name 3347 AccessShareLock VERDADERO 273750 26527414 public c_bpartner_name 3347 AccessShareLock VERDADERO 273750 26527413 public c_bpartner_name 3347 AccessShareLock VERDADERO 273750 26527413 public c_bpartner_value 3347 AccessShareLock VERDADERO 273750 26536613 public c_bpartner_value 3347 AccessShareLock VERDADERO 273750 26527414 public c_bpartner_value 3347 AccessShareLock VERDADERO 273750 26536613 public c_order 3347 AccessShareLock VERDADERO 273750 26527414 public c_order 3347 AccessShareLock VERDADERO 273750 26527413 public c_order 3347 AccessShareLock VERDADERO 273750 26527413 public c_order_bpartner 3347 AccessShareLock VERDADERO 273750 26536613 public c_order_bpartner 3347 AccessShareLock VERDADERO 273750 26527414 public c_order_bpartner 3347 AccessShareLock VERDADERO 273750 26536613 public c_order_client_org_date_docno 3347 AccessShareLock VERDADERO 273750 26527414 public c_order_client_org_date_docno 3347 AccessShareLock VERDADERO 273750 26527413 public c_order_client_org_date_docno 3347 AccessShareLock VERDADERO 273750 26536613 public c_order_docno 3347 AccessShareLock VERDADERO 273750 26527414 public c_order_docno 3347 AccessShareLock VERDADERO 273750 26527413 public c_order_docno 3347 AccessShareLock VERDADERO 273750 26527413 public c_order_key 3347 AccessShareLock VERDADERO 273750 26536613 public c_order_key 3347 AccessShareLock VERDADERO 273750 26527414 public c_order_key 3347 AccessShareLock VERDADERO 273750 26527413 public c_order_updated 3347 AccessShareLock VERDADERO 273750 26536613 public c_order_updated 3347 AccessShareLock VERDADERO 273750 26527414 public c_order_updated 3347 AccessShareLock VERDADERO 273750 26527413 public c_orderline 3347 AccessShareLock VERDADERO 273750 26536613 public c_orderline 3347 RowShareLock VERDADERO 273750 26527413 public c_orderline 3347 RowShareLock VERDADERO 273750 26527414 public c_orderline 3347 RowShareLock VERDADERO 273750 26536613 public c_orderline 3347 AccessShareLock VERDADERO 273750 26527414 public c_orderline 3347 AccessShareLock VERDADERO 273750 26527413 public c_orderline_key 3347 AccessShareLock VERDADERO 273750 26536613 public c_orderline_key 3347 AccessShareLock VERDADERO 273750 26527414 public c_orderline_key 3347 AccessShareLock VERDADERO 273750 26536613 public c_orderline_order 3347 AccessShareLock VERDADERO 273750 26527414 public c_orderline_order 3347 AccessShareLock VERDADERO 273750 26527413 public c_orderline_order 3347 AccessShareLock VERDADERO 273750 26527414 public c_orderline_product 3347 AccessShareLock VERDADERO 273750 26536613 public c_orderline_product 3347 AccessShareLock VERDADERO 273750 26527413 public c_orderline_product 3347 AccessShareLock VERDADERO 273750 26536613 public m_matchpo 3347 AccessShareLock VERDADERO 273750 26527413 public m_matchpo 3347 AccessShareLock VERDADERO 273750 26527414 public m_matchpo 3347 AccessShareLock VERDADERO 273750 26536613 public m_matchpo_key 3347 AccessShareLock VERDADERO 273750 26527414 public m_matchpo_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_matchpo_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_matchpo_ship 3347 AccessShareLock VERDADERO 273750 26527414 public m_matchpo_ship 3347 AccessShareLock VERDADERO 273750 26536613 public m_matchpo_ship 3347 AccessShareLock VERDADERO 273750 26527414 public m_product 3347 RowShareLock VERDADERO 273750 26527414 public m_product 3347 AccessShareLock VERDADERO 273750 26527413 public m_product 3347 AccessShareLock VERDADERO 273750 26536613 public m_product 3347 AccessShareLock VERDADERO 273750 26527413 public m_product 3347 RowShareLock VERDADERO 273750 26536613 public m_product 3347 RowShareLock VERDADERO 273750 26527413 public m_product_bpartner 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_bpartner 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_bpartner 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_expensetype 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_expensetype 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_expensetype 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_key 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_name 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_name 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_name 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_org 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_org 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_org 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_org_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_org_key 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_org_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_po 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_po 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_po 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_po_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_po_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_po_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_po_vendorprodno 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_po_vendorprodno 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_po_vendorprodno 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_productcategory 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_productcategory 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_productcategory 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_resource 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_resource 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_resource 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_upc 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_upc 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_upc 3347 AccessShareLock VERDADERO 273750 26536613 public m_product_value 3347 AccessShareLock VERDADERO 273750 26527414 public m_product_value 3347 AccessShareLock VERDADERO 273750 26527413 public m_product_value 3347 AccessShareLock VERDADERO 273750 26536613 public m_requisition 3347 AccessShareLock VERDADERO 273750 26527413 public m_requisition 3347 AccessShareLock VERDADERO 273750 26527414 public m_requisition 3347 AccessShareLock VERDADERO 273750 26536613 public m_requisition_key 3347 AccessShareLock VERDADERO 273750 26527414 public m_requisition_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_requisition_key 3347 AccessShareLock VERDADERO 273750 26527414 public m_requisitionline 3347 AccessShareLock VERDADERO 273750 26536613 public m_requisitionline 3347 RowExclusiveLock VERDADERO 273750 26527413 public m_requisitionline 3347 RowExclusiveLock VERDADERO 273750 26527414 public m_requisitionline 3347 RowExclusiveLock VERDADERO 273750 26536613 public m_requisitionline 3347 RowShareLock VERDADERO 273750 26527413 public m_requisitionline 3347 RowShareLock VERDADERO 273750 26527414 public m_requisitionline 3347 RowShareLock VERDADERO 273750 26536613 public m_requisitionline 3347 AccessShareLock VERDADERO 273750 26527413 public m_requisitionline 3347 AccessShareLock VERDADERO 273750 26527414 public m_requisitionline_key 3347 RowExclusiveLock VERDADERO 273750 26527413 public m_requisitionline_key 3347 RowExclusiveLock VERDADERO 273750 26536613 public m_requisitionline_key 3347 RowExclusiveLock VERDADERO 273750 26527414 public m_requisitionline_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_requisitionline_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_requisitionline_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_storage_detail 3347 AccessShareLock VERDADERO 273750 26527413 public m_storage_detail 3347 AccessShareLock VERDADERO 273750 26527414 public m_storage_detail 3347 AccessShareLock VERDADERO 273750 26536613 public m_storage_detail_key 3347 AccessShareLock VERDADERO 273750 26527414 public m_storage_detail_key 3347 AccessShareLock VERDADERO 273750 26527413 public m_storage_detail_key 3347 AccessShareLock VERDADERO 273750 26536613 public m_storage_detail_un 3347 AccessShareLock VERDADERO 273750 26527413 public m_storage_detail_un 3347 AccessShareLock VERDADERO 273750 26527414 public m_storage_detail_un 3347 AccessShareLock VERDADERO 273750 26527414 public mproductpo_mproductid_cbpar_un 3347 AccessShareLock VERDADERO 273750 26527413 public mproductpo_mproductid_cbpar_un 3347 AccessShareLock VERDADERO 273750 26536613 public mproductpo_mproductid_cbpar_un 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_planningmethodline 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_planningmethodline 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_planningmethodline 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_planningmethodline_key 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_planningmethodline_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_planningmethodline_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purchase 3347 RowShareLock VERDADERO 273750 26536613 public mrp_run_purchase 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_run_purchase 3347 RowShareLock VERDADERO 273750 26527413 public mrp_run_purchase 3347 RowShareLock VERDADERO 273750 26527414 public mrp_run_purchase 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_run_purchase 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_run_purchase_key 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_run_purchase_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purchase_key 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_run_purchaseline 3347 RowExclusiveLock VERDADERO 273750 26527414 public mrp_run_purchaseline 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_run_purchaseline 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purchaseline 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_run_purchaseline 3347 RowExclusiveLock VERDADERO 273750 26536613 public mrp_run_purchaseline 3347 RowExclusiveLock VERDADERO 273750 26527413 public mrp_run_purchaseline_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purchaseline_key 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_run_purchaseline_key 3347 RowExclusiveLock VERDADERO 273750 26527413 public mrp_run_purchaseline_key 3347 RowExclusiveLock VERDADERO 273750 26536613 public mrp_run_purchaseline_key 3347 RowExclusiveLock VERDADERO 273750 26527414 public mrp_run_purchaseline_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purchline_purchase_id 3347 RowExclusiveLock VERDADERO 273750 26527413 public mrp_run_purchline_purchase_id 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purchline_purchase_id 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_run_purchline_purchase_id 3347 RowExclusiveLock VERDADERO 273750 26527413 public mrp_run_purchline_purchase_id 3347 RowExclusiveLock VERDADERO 273750 26527414 public mrp_run_purchline_purchase_id 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_run_purhcline_purch_prod 3347 RowExclusiveLock VERDADERO 273750 26527414 public mrp_run_purhcline_purch_prod 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_run_purhcline_purch_prod 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_run_purhcline_purch_prod 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_run_purhcline_purch_prod 3347 RowExclusiveLock VERDADERO 273750 26536613 public mrp_run_purhcline_purch_prod 3347 RowExclusiveLock VERDADERO 273750 26536613 public mrp_salesforecast 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_salesforecast 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_salesforecast 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_salesforecast_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_salesforecast_key 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_salesforecast_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_salesforecastline 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_salesforecastline 3347 AccessShareLock VERDADERO 273750 26527414 public mrp_salesforecastline 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_salesforecastline 3347 RowShareLock VERDADERO 273750 26527413 public mrp_salesforecastline 3347 RowShareLock VERDADERO 273750 26527414 public mrp_salesforecastline 3347 RowShareLock VERDADERO 273750 26527414 public mrp_salesforecastline_key 3347 AccessShareLock VERDADERO 273750 26527413 public mrp_salesforecastline_key 3347 AccessShareLock VERDADERO 273750 26536613 public mrp_salesforecastline_key 3347 AccessShareLock VERDADERO 273750 26527414 public orgproduct_un_productorg 3347 AccessShareLock VERDADERO 273750 26527413 public orgproduct_un_productorg 3347 AccessShareLock VERDADERO 273750 26536613 public orgproduct_un_productorg 3347 AccessShareLock VERDADERO 273750 As you can see it is interlocked by itself, and i dont know how to avoid this lock. |
(0023313) joan (reporter) 2010-01-11 13:52 |
If I do a gdb backtrace it shows: (gdb) bt #0 0x00002b33b7015352 in read () from /lib/libc.so.6 #1 0x00000000005a5d8a in FileRead () #2 0x00000000005b4c65 in mdread () #3 0x00000000005a28d5 in ShowBufferUsage () #4 0x0000000000462365 in heap_hot_search () #5 0x0000000000469c4b in _bt_doinsert () #6 0x000000000046ceb7 in btinsert () #7 0x0000000000660ce9 in FunctionCall6 () #8 0x0000000000467c2f in index_insert () #9 0x000000000052ba8e in ExecInsertIndexTuples () #10 0x00000000005230e4 in ExecutorRun () #11 0x000000000053bc14 in SPI_cursor_open () #12 0x000000000053bf00 in SPI_execute_plan () #13 0x00002b33c8f204d7 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #14 0x00002b33c8f21dd5 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #15 0x00002b33c8f230d3 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #16 0x00002b33c8f220ec in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #17 0x00002b33c8f230d3 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #18 0x00002b33c8f220ec in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #19 0x00002b33c8f22d50 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #20 0x00002b33c8f2211e in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #21 0x00002b33c8f22d50 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #22 0x00002b33c8f2211e in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #23 0x00002b33c8f23746 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #24 0x00002b33c8f21965 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #25 0x00002b33c8f232f6 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #26 0x00002b33c8f21965 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #27 0x00002b33c8f23746 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #28 0x00002b33c8f240bc in plpgsql_exec_function () from /usr/lib/postgresql/8.3/lib/plpgsql.so #29 0x00002b33c8f1afdd in plpgsql_call_handler () from /usr/lib/postgresql/8.3/lib/plpgsql.so #30 0x00000000005245bd in ExecMakeFunctionResult () #31 0x0000000000523df5 in ExecProject () #32 0x0000000000534f33 in ExecResult () #33 0x0000000000523845 in ExecProcNode () #34 0x000000000052293d in ExecutorRun () #35 0x000000000053bc14 in SPI_cursor_open () #36 0x000000000053bf00 in SPI_execute_plan () #37 0x00002b33c8f1f77a in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #38 0x00002b33c8f21979 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #39 0x00002b33c8f23746 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #40 0x00002b33c8f21965 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #41 0x00002b33c8f232f6 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #42 0x00002b33c8f21965 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #43 0x00002b33c8f23746 in plpgsql_subxact_cb () from /usr/lib/postgresql/8.3/lib/plpgsql.so #44 0x00002b33c8f240bc in plpgsql_exec_function () from /usr/lib/postgresql/8.3/lib/plpgsql.so #45 0x00002b33c8f1afdd in plpgsql_call_handler () from /usr/lib/postgresql/8.3/lib/plpgsql.so #46 0x00000000005280c1 in ExecMakeTableFunctionResult () #47 0x0000000000534a92 in ExecFunctionScan () #48 0x000000000052a15c in ExecScan () #49 0x00000000005238ad in ExecProcNode () #50 0x000000000052293d in ExecutorRun () #51 0x00000000005bbe16 in PostgresMain () #52 0x00000000005bce99 in PortalRun () #53 0x00000000005ba084 in PostgresMain () #54 0x000000000058e73b in ClosePostmasterPorts () #55 0x000000000058f46e in PostmasterMain () #56 0x0000000000546605 in main () Still i dont have a clue if the problem is mine or the mrp :( |
(0040983) psarobe (manager) 2011-09-15 23:00 |
Please use the forums thanks |
Issue History | |||
Date Modified | Username | Field | Change |
2010-01-11 09:26 | joan | New Issue | |
2010-01-11 09:26 | joan | Assigned To | => rafaroda |
2010-01-11 13:48 | joan | Note Added: 0023312 | |
2010-01-11 13:52 | joan | Note Added: 0023313 | |
2010-02-11 18:32 | rafaroda | Assigned To | rafaroda => alostale |
2010-02-13 22:01 | iciordia | Assigned To | alostale => adrianromero |
2010-02-14 14:47 | shuehner | Issue Monitored: shuehner | |
2011-06-03 11:00 | dalsasua | Assigned To | adrianromero => dalsasua |
2011-07-20 18:11 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
2011-09-15 23:00 | psarobe | Note Added: 0040983 | |
2011-09-15 23:00 | psarobe | Status | new => closed |
2011-09-15 23:00 | psarobe | Resolution | open => invalid |
Copyright © 2000 - 2009 MantisBT Group |