Error Message from log upon Startup (latest trunk)

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Error Message from log upon Startup (latest trunk)

Enrique Ruibal
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

Reply | Threaded
Open this post in threaded view
|

Re: Error Message from log upon Startup (latest trunk)

Enrique Ruibal
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
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Error Message from log upon Startup (latest trunk)

David E Jones

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
>>
>>