You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Enrique Ruibal A." <er...@prodigy.net.mx> on 2008/02/27 03:07:13 UTC
Error Message from log upon Startup (latest trunk)
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 ]
org.ofbiz.service.job.PersistedServiceJob@1172c5[11306] -- 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
Re: Error Message from log upon Startup (latest trunk)
Posted by David E Jones <jo...@hotwaxmedia.com>.
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 ]
>> org.ofbiz.service.job.PersistedServiceJob@1172c5[11306] -- 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
>>
>>
Re: Error Message from log upon Startup (latest trunk)
Posted by "Enrique Ruibal A." <er...@prodigy.net.mx>.
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 ]
> org.ofbiz.service.job.PersistedServiceJob@1172c5[11306] -- 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
>
>