12-06 15:27:42 jdbc[3]: exception
org.h2.jdbc.JdbcSQLException: The object is already closed [90007-176]
12-06 15:27:42 jdbc[3]: exception
org.h2.jdbc.JdbcSQLException: The object is already closed [90007-176]
12-06 15:27:42 jdbc[3]: exception
org.h2.jdbc.JdbcSQLException: The object is already closed [90007-176]
2017-01-04 12:53:59 jdbc[6]: exception
org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "PRODUCT_DIGITAL"; SQL statement:
select digitalpro0_.PRODUCT_DIGITAL_ID as PRODUCT_1_44_0_, product1_.PRODUCT_ID as PRODUCT_1_39_1_, merchantst2_.MERCHANT_ID as MERCHANT1_25_2_, digitalpro0_.PRODUCT_ID as PRODUCT_3_44_0_, digitalpro0_.FILE_NAME as FILE_NAM2_44_0_, product1_.DATE_CREATED as DATE_CRE2_39_1_, product1_.DATE_MODIFIED as DATE_MOD3_39_1_, product1_.UPDT_ID as UPDT_ID4_39_1_, product1_.AVAILABLE as AVAILABL5_39_1_, product1_.DATE_AVAILABLE as DATE_AVA6_39_1_, product1_.MANUFACTURER_ID as MANUFAC21_39_1_, product1_.MERCHANT_ID as MERCHAN22_39_1_, product1_.PREORDER as PREORDER7_39_1_, product1_.PRODUCT_HEIGHT as PRODUCT_8_39_1_, product1_.PRODUCT_FREE as PRODUCT_9_39_1_, product1_.PRODUCT_LENGTH as PRODUCT10_39_1_, product1_.QUANTITY_ORDERED as QUANTIT11_39_1_, product1_.REVIEW_AVG as REVIEW_12_39_1_, product1_.REVIEW_COUNT as REVIEW_13_39_1_, product1_.PRODUCT_SHIP as PRODUCT14_39_1_, product1_.PRODUCT_VIRTUAL as PRODUCT15_39_1_, product1_.PRODUCT_WEIGHT as PRODUCT16_39_1_, product1_.PRODUCT_WIDTH as PRODUCT17_39_1_, product1_.REF_SKU as REF_SKU18_39_1_, product1_.SKU as SKU19_39_1_, product1_.SORT_ORDER as SORT_OR20_39_1_, product1_.TAX_CLASS_ID as TAX_CLA23_39_1_, product1_.PRODUCT_TYPE_ID as PRODUCT24_39_1_, merchantst2_.STORE_CODE as STORE_CO2_25_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_25_2_, merchantst2_.COUNTRY_ID as COUNTRY20_25_2_, merchantst2_.CURRENCY_ID as CURRENC21_25_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_25_2_, merchantst2_.LANGUAGE_ID as LANGUAG22_25_2_, merchantst2_.DOMAIN_NAME as DOMAIN_N5_25_2_, merchantst2_.IN_BUSINESS_SINCE as IN_BUSIN6_25_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE_7_25_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_25_2_, merchantst2_.STORE_EMAIL as STORE_EM9_25_2_, merchantst2_.STORE_LOGO as STORE_L10_25_2_, merchantst2_.STORE_TEMPLATE as STORE_T11_25_2_, merchantst2_.STORE_ADDRESS as STORE_A12_25_2_, merchantst2_.STORE_CITY as STORE_C13_25_2_, merchantst2_.STORE_NAME as STORE_N14_25_2_, merchantst2_.STORE_PHONE as STORE_P15_25_2_, merchantst2_.STORE_POSTAL_CODE as STORE_P16_25_2_, merchantst2_.STORE_STATE_PROV as STORE_S17_25_2_, merchantst2_.USE_CACHE as USE_CAC18_25_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_25_2_, merchantst2_.ZONE_ID as ZONE_ID23_25_2_ from SALESMANAGER.PRODUCT_DIGITAL digitalpro0_ inner join SALESMANAGER.PRODUCT product1_ on digitalpro0_.PRODUCT_ID=product1_.PRODUCT_ID inner join SALESMANAGER.MERCHANT_STORE merchantst2_ on product1_.MERCHANT_ID=merchantst2_.MERCHANT_ID where digitalpro0_.PRODUCT_DIGITAL_ID=? [50200-191]
01-09 14:52:36 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]
01-09 14:53:35 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]
01-09 14:54:00 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]
01-09 14:55:11 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]
01-09 14:57:24 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]
01-09 14:59:34 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]
01-09 15:00:20 database: ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE SALESMANAGER.CATEGORY ADD CONSTRAINT SALESMANAGER.FK_B5718WL9WILWJ9K8JE1K2JEO FOREIGN KEY(MERCHANT_ID) INDEX SALESMANAGER.UK_3MQ9I6QMGQUVOIESLX39PEJ6X_INDEX_3 REFERENCES SALESMANAGER.MERCHANT_STORE(MERCHANT_ID) NOCHECK [23505-176]