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 |
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 > > |
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 >> >> |
Free forum by Nabble | Edit this page |