Advertisement
Guest User

Untitled

a guest
Sep 19th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.46 KB | None | 0 0
  1. 19.09.2016 4:29:33 <INFO> Execution Progress.Initializing properties: 1%
  2. 19.09.2016 4:29:34 <INFO> Using sybase driver for url jdbc:sybase:Tds:db3.billing.novotelecom.ru:4100/v083?CHARSET=koi8
  3. 19.09.2016 4:29:34 <INFO> Execution Progress.Initialized connection id=v083, JdbcConnection{com.sybase.jdbc3.jdbc.SybConnection}, Dialect{Adaptive Server Enterprise Adaptive Server Enterprise/12.5.4/EBF 13739 ESD#1/P/Linux Intel/Enterprise Linux/ase1254/2015/32-bit/OPT/Mon Aug 7 22:57:44 2006}, properties {}: 3%
  4. 19.09.2016 4:29:35 <INFO> Using postgresql driver for url jdbc:postgresql://eva:5432/jira_arhiv
  5. 19.09.2016 4:29:35 <INFO> Execution Progress.Initialized connection id=eva, JdbcConnection{org.postgresql.jdbc3.Jdbc3Connection}, Dialect{PostgreSQL 9.3.6}, properties {flushBeforeQuery=true, statement.batchSize=100}: 5%
  6. 19.09.2016 4:29:35 <INFO> Execution Progress./etl/query[1] prepared: 6%
  7. 19.09.2016 4:29:35 <INFO> Execution Progress./etl/query[3] prepared: 7%
  8. 19.09.2016 4:29:35 <INFO> Execution Progress./etl/script[3] prepared: 10%
  9. 19.09.2016 4:29:35 <INFO> Registered JMX mbean: scriptella:type=etl,url="file:/opt/projects/dwh_load/v083/load_v083_after_tarificator.etl.xml"
  10. 19.09.2016 4:29:35 <INFO> Execution Progress./etl/script[1] executed: 23%
  11. 19.09.2016 4:29:59 <INFO> Execution Progress./etl/query[1] executed: 36%
  12. 19.09.2016 4:41:32 <INFO> Executed statement select
  13. SE.SE_ID as se_id,
  14. SE.LC_Num as lc_num,
  15. SE.SVC_ID, SE.LOGIN, SE.DELETED, SE.se1c_id,
  16. SE.parent_SE_ID as parent_se_id,
  17. SE.TC_ID as tc_id,
  18. SE.created, SE.removed, SE.activated, SE.canceled,
  19. SE.set_SE_ID as set_se_id,
  20. LC.CONTRACT_IDENT as lc_contract_ident,
  21. LC.SHORT_NAME as lc_short_name,
  22. LC.COMPANY as lc_company,
  23. address_kladr.VALUE as pr_address_kladr_tmp,
  24. case
  25. when SE.SVC_ID in (20,81)
  26. then (select sp.VALUE from SE_PROPS sp
  27. join NTK_PORT np on np.SE_ID = sp.SE_ID
  28. join NTK_SE_RESOURCE res on res.RESOURCE_ID = np.port_id and res.RES_TYPE_ID = 2
  29. where sp.NAME = 'ADDRESS_KLADR'
  30. and res.SE_ID = SE.SE_ID
  31. )
  32. when SE.SVC_ID in (503,666,667,514,518)
  33. then (select sp.VALUE from SE_PROPS sp
  34. join NTK_PORT np on np.SE_ID = sp.SE_ID
  35. join NTK_SE_RESOURCE res on res.RESOURCE_ID = np.port_id and res.RES_TYPE_ID = 2
  36. where sp.NAME = 'ADDRESS_KLADR'
  37. and res.SE_ID = SE.parent_SE_ID
  38. )
  39. when SE.SVC_ID = 3
  40. then (select sp.VALUE from SE_PROPS sp
  41. join NTK_PORT np on np.SE_ID = sp.SE_ID
  42. join NTK_SE_RESOURCE res on res.RESOURCE_ID = np.port_id and res.RES_TYPE_ID = 2
  43. join NTK_REGISTRY reg on reg.gw_id = res.SE_ID
  44. where sp.NAME = 'ADDRESS_KLADR'
  45. and reg.SE_ID = SE.SE_ID
  46. )
  47. else (select sp.VALUE from SE_PROPS sp
  48. where sp.SE_ID = SE.SE_ID
  49. and sp.NAME = 'ADDRESS_KLADR'
  50. )
  51. end as pr_address_kladr,
  52. block_state.VALUE as pr_block_state,
  53. block_state_updated.VALUE as pr_block_state_updated,
  54. cost_all.VALUE as pr_cost_all,
  55. cost_first.VALUE as pr_cost_first,
  56. cost_period.VALUE as pr_cost_period,
  57. oper_id.VALUE as pr_oper_id,
  58. sost.VALUE as pr_sost,
  59. cost_sum.VALUE as acc_cost_sum
  60. from SE
  61. left join SE_PROPS address_kladr on SE.SE_ID = address_kladr.SE_ID and address_kladr.NAME = 'ADDRESS_KLADR'
  62. left join SE_PROPS block_state on SE.SE_ID = block_state.SE_ID and block_state.NAME = 'BLOCK_STATE'
  63. left join SE_PROPS block_state_updated on SE.SE_ID = block_state_updated.SE_ID and block_state_updated.NAME = 'BLOCK_STATE_UPDATED'
  64. left join SE_PROPS cost_all on SE.SE_ID = cost_all.SE_ID and cost_all.NAME = 'COST_ALL'
  65. left join SE_PROPS cost_first on SE.SE_ID = cost_first.SE_ID and cost_first.NAME = 'COST_FIRST'
  66. left join SE_PROPS cost_period on SE.SE_ID = cost_period.SE_ID and cost_period.NAME = 'COST_PERIOD'
  67. left join SE_PROPS oper_id on SE.SE_ID = oper_id.SE_ID and oper_id.NAME = 'OPER_ID'
  68. left join SE_PROPS sost on SE.SE_ID = sost.SE_ID and sost.NAME = 'SOST'
  69. left join SE_ACCUM cost_sum on SE.SE_ID = cost_sum.SE_ID and cost_sum.NAME = 'COST_SUM'
  70. left join LC on SE.LC_Num = LC.LC_Num
  71. where SE.removed >= '2012-12-31 17:00:00' or SE.removed is null. SQL Warnings:
  72. * java.sql.SQLWarning: Character set conversion is not available between client character set 'koi8' and server character set 'iso_1'.
  73.  
  74. * java.sql.SQLWarning: No conversions will be done.
  75.  
  76. 19.09.2016 4:41:32 <INFO> Execution Progress./etl/query[2] executed: 49%
  77. 19.09.2016 4:41:32 <INFO> Execution Progress./etl/query[3] executed: 62%
  78. 19.09.2016 4:41:32 <INFO> Execution Progress./etl/script[2] executed: 75%
  79. 19.09.2016 4:41:32 <INFO> Execution Progress./etl/script[3] executed: 95%
  80. 19.09.2016 4:41:32 <INFO> Execution Progress.Complete
  81. 19.09.2016 7:12:38 <INFO> Execution statistics:
  82. Executed 3 queries, 4 scripts, 1332064 statements
  83. /etl/script[1]: Element successfully executed (2 statements). Working time 14 milliseconds. Avg throughput: 138,98 statements/sec.
  84. /etl/query[1]: Element successfully executed. Working time 24604 milliseconds.
  85. /etl/query[2]: Element successfully executed (1 statement). Working time 10564 milliseconds. Avg throughput: 0,09 statements/sec.
  86. /etl/query[2]/script[1]: Element successfully executed 1332059 times (1332059 statements). Working time 681759 milliseconds. Avg throughput: 1953,85 statements/sec.
  87. /etl/query[3]: Element successfully executed. Working time 18 milliseconds.
  88. /etl/script[2]: Element successfully executed (1 statement). Working time 1 milliseconds. Avg throughput: 666,38 statements/sec.
  89. /etl/script[3]: Element successfully executed (1 statement). Working time 0 milliseconds. Avg throughput: 6392,96 statements/sec.
  90. Total working time: 2 hours 43 minutes 4,25 seconds
  91. 19.09.2016 7:12:38 <INFO> Successfully executed ETL file /opt/projects/dwh_load/v083/load_v083_after_tarificator.etl.xml
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement