Details

      Description

      The exception during restoring big DB on DB2 :

      27.04.2012 14:52:50 *ERROR* [JobRepositoryRestore repository] JobRepositoryRestore: Can not restore workspace "backup in repository "repository". (JobRepositoryRestore.java, line 237) 
      javax.jcr.RepositoryException: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
      	at org.exoplatform.services.jcr.impl.core.SysViewWorkspaceInitializer.initWorkspace(SysViewWorkspaceInitializer.java:529)
      	at org.exoplatform.services.jcr.impl.core.RepositoryImpl.createWorkspace(RepositoryImpl.java:299)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.fullRestoreOverInitializer(BackupManagerImpl.java:931)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.restoreOverInitializer(BackupManagerImpl.java:686)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.restore(BackupManagerImpl.java:1286)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restoreRepository(JobRepositoryRestore.java:216)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobExistingRepositoryRestore.restoreRepository(JobExistingRepositoryRestore.java:111)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restore(JobRepositoryRestore.java:140)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.run(JobRepositoryRestore.java:385)
      Caused by: org.exoplatform.services.jcr.impl.backup.BackupException: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restore(DBRestore.java:192)
      	at org.exoplatform.services.jcr.impl.backup.ComplexDataRestore.restore(ComplexDataRestore.java:66)
      	at org.exoplatform.services.jcr.ext.backup.impl.rdbms.RdbmsWorkspaceInitializer.doRestore(RdbmsWorkspaceInitializer.java:139)
      	at org.exoplatform.services.jcr.impl.core.SysViewWorkspaceInitializer.initWorkspace(SysViewWorkspaceInitializer.java:525)
      	... 8 more
      Caused by: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
      	at com.ibm.db2.jcc.am.dd.a(dd.java:404)
      	at com.ibm.db2.jcc.am.o.a(o.java:365)
      	at com.ibm.db2.jcc.am.cn.a(cn.java:4280)
      	at com.ibm.db2.jcc.am.cn.c(cn.java:4063)
      	at com.ibm.db2.jcc.am.cn.executeBatch(cn.java:2425)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restoreTable(DBRestore.java:512)
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restore(DBRestore.java:183)
      	... 11 more
      org.exoplatform.services.jcr.impl.backup.BackupException: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restore(DBRestore.java:192)
      	at org.exoplatform.services.jcr.impl.backup.ComplexDataRestore.restore(ComplexDataRestore.java:66)
      	at org.exoplatform.services.jcr.ext.backup.impl.rdbms.RdbmsWorkspaceInitializer.doRestore(RdbmsWorkspaceInitializer.java:139)
      	at org.exoplatform.services.jcr.impl.core.SysViewWorkspaceInitializer.initWorkspace(SysViewWorkspaceInitializer.java:525)
      	at org.exoplatform.services.jcr.impl.core.RepositoryImpl.createWorkspace(RepositoryImpl.java:299)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.fullRestoreOverInitializer(BackupManagerImpl.java:931)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.restoreOverInitializer(BackupManagerImpl.java:686)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.restore(BackupManagerImpl.java:1286)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restoreRepository(JobRepositoryRestore.java:216)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobExistingRepositoryRestore.restoreRepository(JobExistingRepositoryRestore.java:111)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restore(JobRepositoryRestore.java:140)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.run(JobRepositoryRestore.java:385)
      Caused by: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
      	at com.ibm.db2.jcc.am.dd.a(dd.java:404)
      	at com.ibm.db2.jcc.am.o.a(o.java:365)
      	at com.ibm.db2.jcc.am.cn.a(cn.java:4280)
      	at com.ibm.db2.jcc.am.cn.c(cn.java:4063)
      	at com.ibm.db2.jcc.am.cn.executeBatch(cn.java:2425)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restoreTable(DBRestore.java:512)
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restore(DBRestore.java:183)
      	... 11 more
      27.04.2012 14:52:50 *ERROR* [JobRepositoryRestore repository] JobRepositoryRestore: The restore was fail (JobRepositoryRestore.java, line 389) 
      org.exoplatform.services.jcr.ext.backup.RepositoryRestoreExeption: Repository repository was not restored
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restore(JobRepositoryRestore.java:150)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.run(JobRepositoryRestore.java:385)
      Caused by: org.exoplatform.services.jcr.ext.backup.RepositoryRestoreExeption: Repository repository was not restored
      	at org.exoplatform.services.jcr.ext.backup.impl.JobExistingRepositoryRestore.restoreRepository(JobExistingRepositoryRestore.java:115)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restore(JobRepositoryRestore.java:140)
      	... 1 more
      Caused by: org.exoplatform.services.jcr.ext.backup.RepositoryRestoreExeption: Can not restore workspace "backup in repository "repository".
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restoreRepository(JobRepositoryRestore.java:241)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobExistingRepositoryRestore.restoreRepository(JobExistingRepositoryRestore.java:111)
      	... 2 more
      Caused by: javax.jcr.RepositoryException: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
      	at org.exoplatform.services.jcr.impl.core.SysViewWorkspaceInitializer.initWorkspace(SysViewWorkspaceInitializer.java:529)
      	at org.exoplatform.services.jcr.impl.core.RepositoryImpl.createWorkspace(RepositoryImpl.java:299)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.fullRestoreOverInitializer(BackupManagerImpl.java:931)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.restoreOverInitializer(BackupManagerImpl.java:686)
      	at org.exoplatform.services.jcr.ext.backup.impl.BackupManagerImpl.restore(BackupManagerImpl.java:1286)
      	at org.exoplatform.services.jcr.ext.backup.impl.JobRepositoryRestore.restoreRepository(JobRepositoryRestore.java:216)
      	... 3 more
      Caused by: org.exoplatform.services.jcr.impl.backup.BackupException: SQL Exception: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null; Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-964, DRIVER=3.59.81; [jcc][103][10843][3.59.81] Non-recoverable chain-breaking exception occurred during batch processing.  The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restore(DBRestore.java:192)
      	at org.exoplatform.services.jcr.impl.backup.ComplexDataRestore.restore(ComplexDataRestore.java:66)
      	at org.exoplatform.services.jcr.ext.backup.impl.rdbms.RdbmsWorkspaceInitializer.doRestore(RdbmsWorkspaceInitializer.java:139)
      	at org.exoplatform.services.jcr.impl.core.SysViewWorkspaceInitializer.initWorkspace(SysViewWorkspaceInitializer.java:525)
      	... 8 more
      Caused by: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.59.81] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
      Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
      	at com.ibm.db2.jcc.am.dd.a(dd.java:404)
      	at com.ibm.db2.jcc.am.o.a(o.java:365)
      	at com.ibm.db2.jcc.am.cn.a(cn.java:4280)
      	at com.ibm.db2.jcc.am.cn.c(cn.java:4063)
      	at com.ibm.db2.jcc.am.cn.executeBatch(cn.java:2425)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restoreTable(DBRestore.java:512)
      	at org.exoplatform.services.jcr.impl.backup.rdbms.DBRestore.restore(DBRestore.java:183)
      	... 11 more
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                andrew.plotnikov Andrew Plotnikov
                Reporter:
                areshetnyak Alex Reshetnyak
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4 days
                  4d
                  Remaining:
                  Time Spent - 3 days Remaining Estimate - 1 day
                  1d
                  Logged:
                  Time Spent - 3 days Remaining Estimate - 1 day
                  3d