Usually with Postgres you'll want a nightly cron job setup to do a
vacuum.
-David
On Feb 26, 2008, at 7:29 PM, Enrique Ruibal A. wrote:
mmm..I googled on this error, they suggested to run VACCUM ANALYZE
on the troubled tables and Yes, errors 'disappeared'...but could
somebody explain WHY? furthermore is there a way TO PREVENT these
errors?
-Enrique
Enrique Ruibal A. wrote:
Hello,
I am getting this error mesage form log (ofbiz) upon
startup..anybody has a clue?
P.S.
Environment: Win+PostgreSQL 8.25
Version: Trunk
2008-02-26 18:40:19,857 (default-invoker-Thread-7)
[ AbstractEngine.java:73 :INFO ] Loaded Service Locations :
[main-rmi=rmi://localhost:1099/RMIDispatcher, main-http=http://localhost:8080/webtools/control/httpService
, entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-
http=http://localhost:8080/webtools/control/httpService, rita-
rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test=http://localhost:8080/webtools/control/httpService
]
2008-02-26 18:40:19,857 (default-invoker-Thread-9)
[PersistedServiceJob.java:138:INFO ]
[EMAIL PROTECTED] -- Next
runtime: -1
2008-02-26 18:40:20,029 (main) [ ConfigXMLReader.java:564:INFO ]
ConfigMap Created: (4) records in 0.172s
2008-02-26 18:40:20,029 (main) [ ConfigXMLReader.java:564:INFO ]
ConfigMap Created: (4) records in 0.563s
2008-02-26 18:40:20,372 (main) [ ConfigXMLReader.java:564:INFO ]
ConfigMap Created: (4) records in 0.078s
2008-02-26 18:40:20,372 (main) [ ConfigXMLReader.java:564:INFO ]
ConfigMap Created: (4) records in 0.343s
2008-02-26 18:40:20,497 (default-invoker-Thread-7)
[ GenericDelegator.java:1424:ERROR]
---- exception report
----------------------------------------------------------
Failure in findOne operation for entity [OrderHeader]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT ORDER_TYPE_ID, ORDER_NAME,
EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, ENTRY_DATE,
VISIT_ID, STATUS_ID, CREATED_BY, FIRST_ATTEMPT_ORDER_ID,
CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID,
ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID,
TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID,
NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE,
REMAINING_SUB_TOTAL, GRAND_TOTAL, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
public.ORDER_HEADER WHERE ORDER_ID=? (ERROR: could not open
relation 1663/46769/47427: Invalid argument). Rolling back
transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT
ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID,
ORDER_DATE, ENTRY_DATE, VISIT_ID, STATUS_ID, CREATED_BY,
FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID,
BILLING_ACCOUNT_ID, ORIGIN_FACILITY_ID, WEB_SITE_ID,
PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ID,
AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE,
IS_RUSH_ORDER, INTERNAL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP FROM public.ORDER_HEADER WHERE ORDER_ID=? (ERROR:
could not open relation 1663/46769/47427: Invalid argument)
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT ORDER_TYPE_ID, ORDER_NAME,
EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, ENTRY_DATE,
VISIT_ID, STATUS_ID, CREATED_BY, FIRST_ATTEMPT_ORDER_ID,
CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID,
ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID,
TRANSACTION_ID, AUTO_ORDER_SHOPPING_LIST_ID,
NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE,
REMAINING_SUB_TOTAL, GRAND_TOTAL, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM
public.ORDER_HEADER WHERE ORDER_ID=? (ERROR: could not open
relation 1663/46769/47427: Invalid argument)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:
400)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:516)
org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:485)
org
.ofbiz
.entity
.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:
80)
org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1402)
org
.ofbiz
.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:1470)
org
.ofbiz.entity.GenericDelegator.getRelatedOne(GenericDelegator.java:
241
