API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 5 14.84 KB | None | 0 0
raw download clone embed print report
  1. [19:35:35] [com.supportwizard.db.SQLText_PostgreSQL] [WARN] - resetting sequence: select setval('inbound_mu_inboundmuid_seq', greatest(1,max(inboundmuid) + 1), false) from inbound_mu
  2. [19:35:35] [com.supportwizard.db.SQLText_PostgreSQL] [WARN] - resetting sequence: select setval('unify_communications_company0980_rid_seq', greatest(1,max(rid) + 1), false) from unify_communications_company0980
  3. [19:35:35] [com.supportwizard.db.SQLText_PostgreSQL] [WARN] - resetting sequence: select setval('sw_9994sw2229ticketlinks1117558697855server7_link_id_seq', greatest(1,max(link_id) + 1), false) from sw_9994sw2229ticketlinks1117558697855server7
  4. [19:35:35] [com.supportwizard.db.SQLText_PostgreSQL] [WARN] - resetting sequence: select setval('sw_9979f_contacts_105__dao3_sw_rowid_seq', greatest(1,max(sw_rowid) + 1), false) from sw_9979f_contacts_105__dao3
  5. [19:35:35] [com.supportwizard.importer.XMLImporter] [ERROR] - Rolling back import due to Failed to create fk+helper index
  6. com.supportwizard.importer.XMLImporterException: Failed to create fk+helper index
  7.         at com.supportwizard.importer.ImportParserMetaState.createForeignKeysByOrder(ImportParserMetaState.java:618)
  8.         at com.supportwizard.importer.ImportParserMetaState.createForeignKeys(ImportParserMetaState.java:530)
  9.         at com.supportwizard.importer.ImportParserMetaState.postImport(ImportParserMetaState.java:367)
  10.         at com.supportwizard.importer.ImportParser.postImport(ImportParser.java:262)
  11.         at com.supportwizard.importer.XMLImporter.commitImport(XMLImporter.java:482)
  12.         at com.supportwizard.importer.XMLImporter.com$supportwizard$importer$XMLImporter$doImport$aop(XMLImporter.java:171)
  13.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java)
  14.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:113)
  15.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:98)
  16.         at com.supportwizard.importer.Importer.main(Importer.java:96)
  17. Caused by: com.supportwizard.db.SW_SQLException: error.sql.general.defaultmessage
  18.         at com.supportwizard.db.SQLText_PostgreSQL.getRelatedException(SQLText_PostgreSQL.java:711)
  19.         at com.supportwizard.db.SQLText.getRelatedException(SQLText.java:495)
  20.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:849)
  21.         at com.supportwizard.importer.ImportParserMetaState.createForeignKeysByOrder(ImportParserMetaState.java:599)
  22.         ... 9 more
  23. Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
  24.   Detail: Process 3476 waits for AccessExclusiveLock on relation 192743 of database 16392; blocked by process 5968.
  25. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  26.   Hint: See server log for query details.
  27.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  28.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  29.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  30.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  31.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  32.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  33.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:834)
  34.         ... 10 more
  35. [19:35:35] [com.supportwizard.importer.ImportParserMetaState] [INFO] - disabling foreign keys...
  36. [19:35:39] [com.supportwizard.utils.ExceptionUtils] [WARN] - >>>------------> GOT SQLException. : 40P01:0:ERROR: deadlock detected
  37.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  38. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  39.   Hint: See server log for query details.
  40. [19:35:39] [com.supportwizard.db.SQLText_PostgreSQL] [ERROR] - <<<>>> Failed to execute (recoverable=false, try=0, autocommit=false) sql: alter table sw_15848ftx_lead2  DISABLE TRIGGER ALL
  41. org.postgresql.util.PSQLException: ERROR: deadlock detected
  42.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  43. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  44.   Hint: See server log for query details.
  45.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  46.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  47.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  48.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  49.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  50.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
  51.         at com.supportwizard.db.SQLText_PostgreSQL.tryNTimes(SQLText_PostgreSQL.java:862)
  52.         at com.supportwizard.db.SQLText_PostgreSQL.getSwitchIntegrityChecksText(SQLText_PostgreSQL.java:832)
  53.         at com.supportwizard.db.SQLText.getDDL(SQLText.java:244)
  54.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:776)
  55.         at com.supportwizard.importer.ImportParserMetaState.disableFK(ImportParserMetaState.java:1142)
  56.         at com.supportwizard.importer.ImportParserMetaState.failedImport(ImportParserMetaState.java:814)
  57.         at com.supportwizard.importer.ImportParser.failedImport(ImportParser.java:332)
  58.         at com.supportwizard.importer.XMLImporter.rollbackImport(XMLImporter.java:494)
  59.         at com.supportwizard.importer.XMLImporter.com$supportwizard$importer$XMLImporter$doImport$aop(XMLImporter.java:175)
  60.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java)
  61.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:113)
  62.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:98)
  63.         at com.supportwizard.importer.Importer.main(Importer.java:96)
  64. [19:35:39] [com.supportwizard.importer.ImportParserMetaState] [ERROR] - failed to disable foreign keys:cannot alter constraints ERROR: deadlock detected
  65.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  66. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  67.   Hint: See server log for query details.
  68. com.supportwizard.db.SW_SQLException: cannot alter constraints ERROR: deadlock detected
  69.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  70. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  71.   Hint: See server log for query details.
  72.         at com.supportwizard.db.SQLText_PostgreSQL.getSwitchIntegrityChecksText(SQLText_PostgreSQL.java:834)
  73.         at com.supportwizard.db.SQLText.getDDL(SQLText.java:244)
  74.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:776)
  75.         at com.supportwizard.importer.ImportParserMetaState.disableFK(ImportParserMetaState.java:1142)
  76.         at com.supportwizard.importer.ImportParserMetaState.failedImport(ImportParserMetaState.java:814)
  77.         at com.supportwizard.importer.ImportParser.failedImport(ImportParser.java:332)
  78.         at com.supportwizard.importer.XMLImporter.rollbackImport(XMLImporter.java:494)
  79.         at com.supportwizard.importer.XMLImporter.com$supportwizard$importer$XMLImporter$doImport$aop(XMLImporter.java:175)
  80.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java)
  81.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:113)
  82.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:98)
  83.         at com.supportwizard.importer.Importer.main(Importer.java:96)
  84. Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
  85.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  86. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  87.   Hint: See server log for query details.
  88.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  89.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  90.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  91.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  92.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  93.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
  94.         at com.supportwizard.db.SQLText_PostgreSQL.tryNTimes(SQLText_PostgreSQL.java:862)
  95.         at com.supportwizard.db.SQLText_PostgreSQL.getSwitchIntegrityChecksText(SQLText_PostgreSQL.java:832)
  96.         ... 11 more
  97. [19:35:39] [com.supportwizard.importer.XMLImporter] [ERROR] - Failed to process failedImport callbacks
  98. com.supportwizard.importer.XMLImporterException: Failed to disable foreign keys
  99.         at com.supportwizard.importer.ImportParserMetaState.disableFK(ImportParserMetaState.java:1150)
  100.         at com.supportwizard.importer.ImportParserMetaState.failedImport(ImportParserMetaState.java:814)
  101.         at com.supportwizard.importer.ImportParser.failedImport(ImportParser.java:332)
  102.         at com.supportwizard.importer.XMLImporter.rollbackImport(XMLImporter.java:494)
  103.         at com.supportwizard.importer.XMLImporter.com$supportwizard$importer$XMLImporter$doImport$aop(XMLImporter.java:175)
  104.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java)
  105.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:113)
  106.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:98)
  107.         at com.supportwizard.importer.Importer.main(Importer.java:96)
  108. Caused by: com.supportwizard.db.SW_SQLException: cannot alter constraints ERROR: deadlock detected
  109.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  110. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  111.   Hint: See server log for query details.
  112.         at com.supportwizard.db.SQLText_PostgreSQL.getSwitchIntegrityChecksText(SQLText_PostgreSQL.java:834)
  113.         at com.supportwizard.db.SQLText.getDDL(SQLText.java:244)
  114.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:776)
  115.         at com.supportwizard.importer.ImportParserMetaState.disableFK(ImportParserMetaState.java:1142)
  116.         ... 8 more
  117. Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
  118.   Detail: Process 3476 waits for AccessExclusiveLock on relation 205068 of database 16392; blocked by process 5968.
  119. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  120.   Hint: See server log for query details.
  121.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  122.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  123.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  124.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  125.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  126.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
  127.         at com.supportwizard.db.SQLText_PostgreSQL.tryNTimes(SQLText_PostgreSQL.java:862)
  128.         at com.supportwizard.db.SQLText_PostgreSQL.getSwitchIntegrityChecksText(SQLText_PostgreSQL.java:832)
  129.         ... 11 more
  130. [19:35:39] [com.supportwizard.importer.DatabaseManager] [INFO] - rolling back transaction
  131. [19:35:40] [com.supportwizard.importer.DatabaseManager] [INFO] - using transaction isolation level=2
  132. [19:35:40] [com.supportwizard.importer.ImportParser] [INFO] - project=3 has updated status=4
  133. [19:35:40] [com.supportwizard.importer.DatabaseManager] [INFO] - committing transaction
  134. [19:35:41] [com.supportwizard.importer.Importer] [ERROR] - Unknown error: Failed to create fk+helper index
  135. com.supportwizard.importer.XMLImporterException: Failed to create fk+helper index
  136.         at com.supportwizard.importer.ImportParserMetaState.createForeignKeysByOrder(ImportParserMetaState.java:618)
  137.         at com.supportwizard.importer.ImportParserMetaState.createForeignKeys(ImportParserMetaState.java:530)
  138.         at com.supportwizard.importer.ImportParserMetaState.postImport(ImportParserMetaState.java:367)
  139.         at com.supportwizard.importer.ImportParser.postImport(ImportParser.java:262)
  140.         at com.supportwizard.importer.XMLImporter.commitImport(XMLImporter.java:482)
  141.         at com.supportwizard.importer.XMLImporter.com$supportwizard$importer$XMLImporter$doImport$aop(XMLImporter.java:171)
  142.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java)
  143.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:113)
  144.         at com.supportwizard.importer.XMLImporter.doImport(XMLImporter.java:98)
  145.         at com.supportwizard.importer.Importer.main(Importer.java:96)
  146. Caused by: com.supportwizard.db.SW_SQLException: error.sql.general.defaultmessage
  147.         at com.supportwizard.db.SQLText_PostgreSQL.getRelatedException(SQLText_PostgreSQL.java:711)
  148.         at com.supportwizard.db.SQLText.getRelatedException(SQLText.java:495)
  149.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:849)
  150.         at com.supportwizard.importer.ImportParserMetaState.createForeignKeysByOrder(ImportParserMetaState.java:599)
  151.         ... 9 more
  152. Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
  153.   Detail: Process 3476 waits for AccessExclusiveLock on relation 192743 of database 16392; blocked by process 5968.
  154. Process 5968 waits for AccessShareLock on relation 192929 of database 16392; blocked by process 3476.
  155.   Hint: See server log for query details.
  156.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  157.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  158.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  159.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  160.         at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  161.         at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
  162.         at com.supportwizard.db.SWInternal_SQL.sqlDDL(SWInternal_SQL.java:834)
  163.         ... 10 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!