API tools faq
paste
Advertisement
detorresrc

PGPOOL LOGS

detorresrc
Aug 16th, 2013
78
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 63.29 KB | None | 0 0
raw download clone embed print report
  1. 2013-08-16 22:21:48 DEBUG: pid 6357: key: pid_file_name
  2. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '/deo/pgpool_parallel/pgpool.pid' kind: 4
  3. 2013-08-16 22:21:48 DEBUG: pid 6357: key: logdir
  4. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '/deo/pgpool_parallel' kind: 4
  5. 2013-08-16 22:21:48 DEBUG: pid 6357: key: connection_cache
  6. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  7. 2013-08-16 22:21:48 DEBUG: pid 6357: key: reset_query_list
  8. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'ABORT; DISCARD ALL' kind: 4
  9. 2013-08-16 22:21:48 DEBUG: pid 6357: extract_string_tokens: token: ABORT
  10. 2013-08-16 22:21:48 DEBUG: pid 6357: extract_string_tokens: token: DISCARD ALL
  11. 2013-08-16 22:21:48 DEBUG: pid 6357: key: replication_mode
  12. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  13. 2013-08-16 22:21:48 DEBUG: pid 6357: key: replicate_select
  14. 2013-08-16 22:21:48 DEBUG: pid 6357: value: off kind: 1
  15. 2013-08-16 22:21:48 DEBUG: pid 6357: replicate_select: 0
  16. 2013-08-16 22:21:48 DEBUG: pid 6357: key: insert_lock
  17. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  18. 2013-08-16 22:21:48 DEBUG: pid 6357: key: lobj_lock_table
  19. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  20. 2013-08-16 22:21:48 DEBUG: pid 6357: key: replication_stop_on_mismatch
  21. 2013-08-16 22:21:48 DEBUG: pid 6357: value: off kind: 1
  22. 2013-08-16 22:21:48 DEBUG: pid 6357: replication_stop_on_mismatch: 0
  23. 2013-08-16 22:21:48 DEBUG: pid 6357: key: failover_if_affected_tuples_mismatch
  24. 2013-08-16 22:21:48 DEBUG: pid 6357: value: off kind: 1
  25. 2013-08-16 22:21:48 DEBUG: pid 6357: failover_if_affected_tuples_mismatch: 0
  26. 2013-08-16 22:21:48 DEBUG: pid 6357: key: load_balance_mode
  27. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  28. 2013-08-16 22:21:48 DEBUG: pid 6357: key: ignore_leading_white_space
  29. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  30. 2013-08-16 22:21:48 DEBUG: pid 6357: key: white_function_list
  31. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  32. 2013-08-16 22:21:48 DEBUG: pid 6357: key: black_function_list
  33. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'nextval,setval' kind: 4
  34. 2013-08-16 22:21:48 DEBUG: pid 6357: extract_string_tokens: token: nextval
  35. 2013-08-16 22:21:48 DEBUG: pid 6357: extract_string_tokens: token: setval
  36. 2013-08-16 22:21:48 DEBUG: pid 6357: add_to_patterns: regex pattern: ^nextval$
  37. 2013-08-16 22:21:48 DEBUG: pid 6357: add_to_patterns: regex pattern: ^setval$
  38. 2013-08-16 22:21:48 DEBUG: pid 6357: key: master_slave_mode
  39. 2013-08-16 22:21:48 DEBUG: pid 6357: value: off kind: 1
  40. 2013-08-16 22:21:48 DEBUG: pid 6357: key: master_slave_sub_mode
  41. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'slony' kind: 4
  42. 2013-08-16 22:21:48 DEBUG: pid 6357: key: sr_check_period
  43. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 0 kind: 2
  44. 2013-08-16 22:21:48 DEBUG: pid 6357: key: sr_check_user
  45. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'nobody' kind: 4
  46. 2013-08-16 22:21:48 DEBUG: pid 6357: key: sr_check_password
  47. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  48. 2013-08-16 22:21:48 DEBUG: pid 6357: key: delay_threshold
  49. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 0 kind: 2
  50. 2013-08-16 22:21:48 DEBUG: pid 6357: key: follow_master_command
  51. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  52. 2013-08-16 22:21:48 DEBUG: pid 6357: key: parallel_mode
  53. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  54. 2013-08-16 22:21:48 DEBUG: pid 6357: key: pgpool2_hostname
  55. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'worker01' kind: 4
  56. 2013-08-16 22:21:48 DEBUG: pid 6357: key: system_db_hostname
  57. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'localhost' kind: 4
  58. 2013-08-16 22:21:48 DEBUG: pid 6357: key: system_db_port
  59. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 5433 kind: 2
  60. 2013-08-16 22:21:48 DEBUG: pid 6357: key: system_db_dbname
  61. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'pgpool' kind: 4
  62. 2013-08-16 22:21:48 DEBUG: pid 6357: key: system_db_schema
  63. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'pgpool_catalog' kind: 4
  64. 2013-08-16 22:21:48 DEBUG: pid 6357: key: system_db_user
  65. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'postgres' kind: 4
  66. 2013-08-16 22:21:48 DEBUG: pid 6357: key: system_db_password
  67. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'p@55w0rd' kind: 4
  68. 2013-08-16 22:21:48 DEBUG: pid 6357: key: health_check_period
  69. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 30 kind: 2
  70. 2013-08-16 22:21:48 DEBUG: pid 6357: key: health_check_timeout
  71. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 20 kind: 2
  72. 2013-08-16 22:21:48 DEBUG: pid 6357: key: health_check_user
  73. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'postgres' kind: 4
  74. 2013-08-16 22:21:48 DEBUG: pid 6357: key: health_check_password
  75. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'p@55w0rd' kind: 4
  76. 2013-08-16 22:21:48 DEBUG: pid 6357: key: health_check_max_retries
  77. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 0 kind: 2
  78. 2013-08-16 22:21:48 DEBUG: pid 6357: key: health_check_retry_delay
  79. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 1 kind: 2
  80. 2013-08-16 22:21:48 DEBUG: pid 6357: key: failover_command
  81. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  82. 2013-08-16 22:21:48 DEBUG: pid 6357: key: failback_command
  83. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  84. 2013-08-16 22:21:48 DEBUG: pid 6357: key: fail_over_on_backend_error
  85. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  86. 2013-08-16 22:21:48 DEBUG: pid 6357: key: recovery_user
  87. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'nobody' kind: 4
  88. 2013-08-16 22:21:48 DEBUG: pid 6357: key: recovery_password
  89. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  90. 2013-08-16 22:21:48 DEBUG: pid 6357: key: recovery_1st_stage_command
  91. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  92. 2013-08-16 22:21:48 DEBUG: pid 6357: key: recovery_2nd_stage_command
  93. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  94. 2013-08-16 22:21:48 DEBUG: pid 6357: key: recovery_timeout
  95. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 90 kind: 2
  96. 2013-08-16 22:21:48 DEBUG: pid 6357: key: client_idle_limit_in_recovery
  97. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 0 kind: 2
  98. 2013-08-16 22:21:48 DEBUG: pid 6357: key: use_watchdog
  99. 2013-08-16 22:21:48 DEBUG: pid 6357: value: off kind: 1
  100. 2013-08-16 22:21:48 DEBUG: pid 6357: key: trusted_servers
  101. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  102. 2013-08-16 22:21:48 DEBUG: pid 6357: key: delegate_IP
  103. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  104. 2013-08-16 22:21:48 DEBUG: pid 6357: key: wd_hostname
  105. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  106. 2013-08-16 22:21:48 DEBUG: pid 6357: key: wd_port
  107. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 9000 kind: 2
  108. 2013-08-16 22:21:48 DEBUG: pid 6357: key: wd_interval
  109. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 10 kind: 2
  110. 2013-08-16 22:21:48 DEBUG: pid 6357: key: ping_path
  111. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '/bin' kind: 4
  112. 2013-08-16 22:21:48 DEBUG: pid 6357: key: ifconfig_path
  113. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '/sbin' kind: 4
  114. 2013-08-16 22:21:48 DEBUG: pid 6357: key: if_up_cmd
  115. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0' kind: 4
  116. 2013-08-16 22:21:48 DEBUG: pid 6357: key: if_down_cmd
  117. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'ifconfig eth0:0 down' kind: 4
  118. 2013-08-16 22:21:48 DEBUG: pid 6357: key: arping_path
  119. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '/usr/sbin' kind: 4
  120. 2013-08-16 22:21:48 DEBUG: pid 6357: key: arping_cmd
  121. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'arping -U $_IP_$ -w 1' kind: 4
  122. 2013-08-16 22:21:48 DEBUG: pid 6357: key: wd_life_point
  123. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 3 kind: 2
  124. 2013-08-16 22:21:48 DEBUG: pid 6357: key: wd_lifecheck_query
  125. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'SELECT 1' kind: 4
  126. 2013-08-16 22:21:48 DEBUG: pid 6357: key: relcache_expire
  127. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 0 kind: 2
  128. 2013-08-16 22:21:48 DEBUG: pid 6357: key: relcache_size
  129. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 256 kind: 2
  130. 2013-08-16 22:21:48 DEBUG: pid 6357: key: check_temp_table
  131. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  132. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memory_cache_enabled
  133. 2013-08-16 22:21:48 DEBUG: pid 6357: value: off kind: 1
  134. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_method
  135. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'shmem' kind: 4
  136. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_memcached_host
  137. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 'localhost' kind: 4
  138. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_memcached_port
  139. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 11211 kind: 2
  140. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_total_size
  141. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 67108864 kind: 2
  142. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_max_num_cache
  143. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 1000000 kind: 2
  144. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_expire
  145. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 0 kind: 2
  146. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_auto_cache_invalidation
  147. 2013-08-16 22:21:48 DEBUG: pid 6357: value: on kind: 1
  148. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_maxcache
  149. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 409600 kind: 2
  150. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_cache_block_size
  151. 2013-08-16 22:21:48 DEBUG: pid 6357: value: 1048576 kind: 2
  152. 2013-08-16 22:21:48 DEBUG: pid 6357: key: memqcache_oiddir
  153. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '/var/log/pgpool/oiddir' kind: 4
  154. 2013-08-16 22:21:48 DEBUG: pid 6357: key: white_memqcache_table_list
  155. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  156. 2013-08-16 22:21:48 DEBUG: pid 6357: key: black_memqcache_table_list
  157. 2013-08-16 22:21:48 DEBUG: pid 6357: value: '' kind: 4
  158. 2013-08-16 22:21:48 DEBUG: pid 6357: num_backends: 2 total_weight: 2.000000
  159. 2013-08-16 22:21:48 DEBUG: pid 6357: backend 0 weight: 1073741823.500000
  160. 2013-08-16 22:21:48 DEBUG: pid 6357: backend 0 flag: 0001
  161. 2013-08-16 22:21:48 DEBUG: pid 6357: backend 1 weight: 1073741823.500000
  162. 2013-08-16 22:21:48 DEBUG: pid 6357: backend 1 flag: 0001
  163. 2013-08-16 22:21:48 LOG: pid 6357: Backend status file /deo/pgpool_parallel/pgpool_status discarded
  164. 2013-08-16 22:21:48 DEBUG: pid 6359: I am 6359
  165. 2013-08-16 22:21:48 DEBUG: pid 6359: pool_initialize_private_backend_status: initialize backend status
  166. 2013-08-16 22:21:48 DEBUG: pid 6360: I am 6360
  167. 2013-08-16 22:21:48 DEBUG: pid 6361: I am 6361
  168. 2013-08-16 22:21:48 DEBUG: pid 6360: pool_initialize_private_backend_status: initialize backend status
  169. 2013-08-16 22:21:48 DEBUG: pid 6361: pool_initialize_private_backend_status: initialize backend status
  170. 2013-08-16 22:21:48 DEBUG: pid 6362: I am 6362
  171. 2013-08-16 22:21:48 DEBUG: pid 6363: I am 6363
  172. 2013-08-16 22:21:48 DEBUG: pid 6362: pool_initialize_private_backend_status: initialize backend status
  173. 2013-08-16 22:21:48 DEBUG: pid 6363: pool_initialize_private_backend_status: initialize backend status
  174. 2013-08-16 22:21:48 DEBUG: pid 6364: I am 6364
  175. 2013-08-16 22:21:48 DEBUG: pid 6364: pool_initialize_private_backend_status: initialize backend status
  176. 2013-08-16 22:21:48 DEBUG: pid 6365: I am 6365
  177. 2013-08-16 22:21:48 DEBUG: pid 6365: pool_initialize_private_backend_status: initialize backend status
  178. 2013-08-16 22:21:48 DEBUG: pid 6370: I am 6370
  179. 2013-08-16 22:21:48 DEBUG: pid 6370: pool_initialize_private_backend_status: initialize backend status
  180. 2013-08-16 22:21:48 DEBUG: pid 6376: I am 6376
  181. 2013-08-16 22:21:48 DEBUG: pid 6372: I am 6372
  182. 2013-08-16 22:21:48 DEBUG: pid 6376: pool_initialize_private_backend_status: initialize backend status
  183. 2013-08-16 22:21:48 DEBUG: pid 6372: pool_initialize_private_backend_status: initialize backend status
  184. 2013-08-16 22:21:48 DEBUG: pid 6374: I am 6374
  185. 2013-08-16 22:21:48 DEBUG: pid 6374: pool_initialize_private_backend_status: initialize backend status
  186. 2013-08-16 22:21:48 DEBUG: pid 6380: I am 6380
  187. 2013-08-16 22:21:48 DEBUG: pid 6380: pool_initialize_private_backend_status: initialize backend status
  188. 2013-08-16 22:21:48 DEBUG: pid 6366: I am 6366
  189. 2013-08-16 22:21:48 DEBUG: pid 6366: pool_initialize_private_backend_status: initialize backend status
  190. 2013-08-16 22:21:48 DEBUG: pid 6382: I am 6382
  191. 2013-08-16 22:21:48 DEBUG: pid 6382: pool_initialize_private_backend_status: initialize backend status
  192. 2013-08-16 22:21:48 LOG: pid 6357: pgpool-II successfully started. version 3.3.0 (tokakiboshi)
  193. 2013-08-16 22:21:48 DEBUG: pid 6378: I am 6378
  194. 2013-08-16 22:21:48 DEBUG: pid 6378: pool_initialize_private_backend_status: initialize backend status
  195. 2013-08-16 22:21:48 DEBUG: pid 6384: I am 6384
  196. 2013-08-16 22:21:48 DEBUG: pid 6357: find_primary_node: not in streaming replication mode
  197. 2013-08-16 22:21:48 DEBUG: pid 6384: pool_initialize_private_backend_status: initialize backend status
  198. 2013-08-16 22:21:48 DEBUG: pid 6357: starting health checking
  199. 2013-08-16 22:21:48 DEBUG: pid 6357: health check: clearing alarm
  200. 2013-08-16 22:21:48 DEBUG: pid 6357: health_check: 0 th DB node status: 1
  201. 2013-08-16 22:21:48 DEBUG: pid 6368: I am 6368
  202. 2013-08-16 22:21:48 DEBUG: pid 6368: pool_initialize_private_backend_status: initialize backend status
  203. 2013-08-16 22:21:48 DEBUG: pid 6397: I am 6397
  204. 2013-08-16 22:21:48 DEBUG: pid 6397: pool_initialize_private_backend_status: initialize backend status
  205. 2013-08-16 22:21:48 DEBUG: pid 6385: I am 6385
  206. 2013-08-16 22:21:48 DEBUG: pid 6385: pool_initialize_private_backend_status: initialize backend status
  207. 2013-08-16 22:21:48 DEBUG: pid 6400: I am 6400
  208. 2013-08-16 22:21:48 DEBUG: pid 6400: pool_initialize_private_backend_status: initialize backend status
  209. 2013-08-16 22:21:48 DEBUG: pid 6398: I am 6398
  210. 2013-08-16 22:21:48 DEBUG: pid 6398: pool_initialize_private_backend_status: initialize backend status
  211. 2013-08-16 22:21:48 DEBUG: pid 6395: I am 6395
  212. 2013-08-16 22:21:48 DEBUG: pid 6389: I am 6389
  213. 2013-08-16 22:21:48 DEBUG: pid 6395: pool_initialize_private_backend_status: initialize backend status
  214. 2013-08-16 22:21:48 DEBUG: pid 6389: pool_initialize_private_backend_status: initialize backend status
  215. 2013-08-16 22:21:48 DEBUG: pid 6394: I am 6394
  216. 2013-08-16 22:21:48 DEBUG: pid 6394: pool_initialize_private_backend_status: initialize backend status
  217. 2013-08-16 22:21:48 DEBUG: pid 6381: I am 6381
  218. 2013-08-16 22:21:48 DEBUG: pid 6381: pool_initialize_private_backend_status: initialize backend status
  219. 2013-08-16 22:21:48 DEBUG: pid 6396: I am 6396
  220. 2013-08-16 22:21:48 DEBUG: pid 6396: pool_initialize_private_backend_status: initialize backend status
  221. 2013-08-16 22:21:48 DEBUG: pid 6391: I am 6391
  222. 2013-08-16 22:21:48 DEBUG: pid 6360: s_do_auth: auth kind: 0
  223. 2013-08-16 22:21:48 DEBUG: pid 6391: pool_initialize_private_backend_status: initialize backend status
  224. 2013-08-16 22:21:48 DEBUG: pid 6360: s_do_auth: backend key data received
  225. 2013-08-16 22:21:48 DEBUG: pid 6360: s_do_auth: transaction state: I
  226. 2013-08-16 22:21:48 DEBUG: pid 6385: s_do_auth: auth kind: 0
  227. 2013-08-16 22:21:48 DEBUG: pid 6385: s_do_auth: backend key data received
  228. 2013-08-16 22:21:48 DEBUG: pid 6385: s_do_auth: transaction state: I
  229. 2013-08-16 22:21:48 DEBUG: pid 6370: s_do_auth: auth kind: 0
  230. 2013-08-16 22:21:48 DEBUG: pid 6370: s_do_auth: backend key data received
  231. 2013-08-16 22:21:48 DEBUG: pid 6370: s_do_auth: transaction state: I
  232. 2013-08-16 22:21:48 DEBUG: pid 6393: I am 6393
  233. 2013-08-16 22:21:48 DEBUG: pid 6393: pool_initialize_private_backend_status: initialize backend status
  234. 2013-08-16 22:21:48 DEBUG: pid 6388: I am 6388
  235. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: auth kind: 3
  236. 2013-08-16 22:21:48 DEBUG: pid 6383: I am 6383
  237. 2013-08-16 22:21:48 DEBUG: pid 6383: pool_initialize_private_backend_status: initialize backend status
  238. 2013-08-16 22:21:48 DEBUG: pid 6365: s_do_auth: auth kind: 0
  239. 2013-08-16 22:21:48 DEBUG: pid 6365: s_do_auth: backend key data received
  240. 2013-08-16 22:21:48 DEBUG: pid 6365: s_do_auth: transaction state: I
  241. 2013-08-16 22:21:48 DEBUG: pid 6386: I am 6386
  242. 2013-08-16 22:21:48 DEBUG: pid 6386: pool_initialize_private_backend_status: initialize backend status
  243. 2013-08-16 22:21:48 DEBUG: pid 6362: s_do_auth: auth kind: 0
  244. 2013-08-16 22:21:48 DEBUG: pid 6362: s_do_auth: backend key data received
  245. 2013-08-16 22:21:48 DEBUG: pid 6362: s_do_auth: transaction state: I
  246. 2013-08-16 22:21:48 DEBUG: pid 6359: s_do_auth: auth kind: 0
  247. 2013-08-16 22:21:48 DEBUG: pid 6361: s_do_auth: auth kind: 0
  248. 2013-08-16 22:21:48 DEBUG: pid 6361: s_do_auth: backend key data received
  249. 2013-08-16 22:21:48 DEBUG: pid 6361: s_do_auth: transaction state: I
  250. 2013-08-16 22:21:48 DEBUG: pid 6380: s_do_auth: auth kind: 0
  251. 2013-08-16 22:21:48 DEBUG: pid 6380: s_do_auth: backend key data received
  252. 2013-08-16 22:21:48 DEBUG: pid 6380: s_do_auth: transaction state: I
  253. 2013-08-16 22:21:48 DEBUG: pid 6359: s_do_auth: backend key data received
  254. 2013-08-16 22:21:48 DEBUG: pid 6359: s_do_auth: transaction state: I
  255. 2013-08-16 22:21:48 DEBUG: pid 6363: s_do_auth: auth kind: 0
  256. 2013-08-16 22:21:48 DEBUG: pid 6363: s_do_auth: backend key data received
  257. 2013-08-16 22:21:48 DEBUG: pid 6363: s_do_auth: transaction state: I
  258. 2013-08-16 22:21:48 DEBUG: pid 6388: pool_initialize_private_backend_status: initialize backend status
  259. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: auth kind: 0
  260. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: backend key data received
  261. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: transaction state: I
  262. 2013-08-16 22:21:48 DEBUG: pid 6357: health_check: 1 th DB node status: 1
  263. 2013-08-16 22:21:48 DEBUG: pid 6364: s_do_auth: auth kind: 0
  264. 2013-08-16 22:21:48 DEBUG: pid 6364: s_do_auth: backend key data received
  265. 2013-08-16 22:21:48 DEBUG: pid 6364: s_do_auth: transaction state: I
  266. 2013-08-16 22:21:48 DEBUG: pid 6372: s_do_auth: auth kind: 0
  267. 2013-08-16 22:21:48 DEBUG: pid 6372: s_do_auth: backend key data received
  268. 2013-08-16 22:21:48 DEBUG: pid 6372: s_do_auth: transaction state: I
  269. 2013-08-16 22:21:48 DEBUG: pid 6376: s_do_auth: auth kind: 0
  270. 2013-08-16 22:21:48 DEBUG: pid 6376: s_do_auth: backend key data received
  271. 2013-08-16 22:21:48 DEBUG: pid 6376: s_do_auth: transaction state: I
  272. 2013-08-16 22:21:48 DEBUG: pid 6381: s_do_auth: auth kind: 0
  273. 2013-08-16 22:21:48 DEBUG: pid 6381: s_do_auth: backend key data received
  274. 2013-08-16 22:21:48 DEBUG: pid 6381: s_do_auth: transaction state: I
  275. 2013-08-16 22:21:48 DEBUG: pid 6398: s_do_auth: auth kind: 0
  276. 2013-08-16 22:21:48 DEBUG: pid 6398: s_do_auth: backend key data received
  277. 2013-08-16 22:21:48 DEBUG: pid 6398: s_do_auth: transaction state: I
  278. 2013-08-16 22:21:48 DEBUG: pid 6366: s_do_auth: auth kind: 0
  279. 2013-08-16 22:21:48 DEBUG: pid 6366: s_do_auth: backend key data received
  280. 2013-08-16 22:21:48 DEBUG: pid 6366: s_do_auth: transaction state: I
  281. 2013-08-16 22:21:48 DEBUG: pid 6368: s_do_auth: auth kind: 0
  282. 2013-08-16 22:21:48 DEBUG: pid 6368: s_do_auth: backend key data received
  283. 2013-08-16 22:21:48 DEBUG: pid 6368: s_do_auth: transaction state: I
  284. 2013-08-16 22:21:48 DEBUG: pid 6374: s_do_auth: auth kind: 0
  285. 2013-08-16 22:21:48 DEBUG: pid 6374: s_do_auth: backend key data received
  286. 2013-08-16 22:21:48 DEBUG: pid 6374: s_do_auth: transaction state: I
  287. 2013-08-16 22:21:48 DEBUG: pid 6391: s_do_auth: auth kind: 0
  288. 2013-08-16 22:21:48 DEBUG: pid 6391: s_do_auth: backend key data received
  289. 2013-08-16 22:21:48 DEBUG: pid 6391: s_do_auth: transaction state: I
  290. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: auth kind: 3
  291. 2013-08-16 22:21:48 DEBUG: pid 6397: s_do_auth: auth kind: 0
  292. 2013-08-16 22:21:48 DEBUG: pid 6397: s_do_auth: backend key data received
  293. 2013-08-16 22:21:48 DEBUG: pid 6397: s_do_auth: transaction state: I
  294. 2013-08-16 22:21:48 DEBUG: pid 6384: s_do_auth: auth kind: 0
  295. 2013-08-16 22:21:48 DEBUG: pid 6384: s_do_auth: backend key data received
  296. 2013-08-16 22:21:48 DEBUG: pid 6384: s_do_auth: transaction state: I
  297. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: auth kind: 0
  298. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: backend key data received
  299. 2013-08-16 22:21:48 DEBUG: pid 6357: s_do_auth: transaction state: I
  300. 2013-08-16 22:21:48 DEBUG: pid 6386: s_do_auth: auth kind: 0
  301. 2013-08-16 22:21:48 DEBUG: pid 6357: health_check: SystemDB status: 2
  302. 2013-08-16 22:21:48 DEBUG: pid 6386: s_do_auth: backend key data received
  303. 2013-08-16 22:21:48 DEBUG: pid 6386: s_do_auth: transaction state: I
  304. 2013-08-16 22:21:48 DEBUG: pid 6389: s_do_auth: auth kind: 0
  305. 2013-08-16 22:21:48 DEBUG: pid 6389: s_do_auth: backend key data received
  306. 2013-08-16 22:21:48 DEBUG: pid 6389: s_do_auth: transaction state: I
  307. 2013-08-16 22:21:48 DEBUG: pid 6393: s_do_auth: auth kind: 0
  308. 2013-08-16 22:21:48 DEBUG: pid 6393: s_do_auth: backend key data received
  309. 2013-08-16 22:21:48 DEBUG: pid 6393: s_do_auth: transaction state: I
  310. 2013-08-16 22:21:48 DEBUG: pid 6388: s_do_auth: auth kind: 0
  311. 2013-08-16 22:21:48 DEBUG: pid 6388: s_do_auth: backend key data received
  312. 2013-08-16 22:21:48 DEBUG: pid 6388: s_do_auth: transaction state: I
  313. 2013-08-16 22:21:48 DEBUG: pid 6382: s_do_auth: auth kind: 0
  314. 2013-08-16 22:21:48 DEBUG: pid 6382: s_do_auth: backend key data received
  315. 2013-08-16 22:21:48 DEBUG: pid 6382: s_do_auth: transaction state: I
  316. 2013-08-16 22:21:48 DEBUG: pid 6394: s_do_auth: auth kind: 0
  317. 2013-08-16 22:21:48 DEBUG: pid 6394: s_do_auth: backend key data received
  318. 2013-08-16 22:21:48 DEBUG: pid 6394: s_do_auth: transaction state: I
  319. 2013-08-16 22:21:48 DEBUG: pid 6357: health check: clearing alarm
  320. 2013-08-16 22:21:48 DEBUG: pid 6357: health check: clearing alarm
  321. 2013-08-16 22:21:48 DEBUG: pid 6383: s_do_auth: auth kind: 0
  322. 2013-08-16 22:21:48 DEBUG: pid 6383: s_do_auth: backend key data received
  323. 2013-08-16 22:21:48 DEBUG: pid 6383: s_do_auth: transaction state: I
  324. 2013-08-16 22:21:48 DEBUG: pid 6378: s_do_auth: auth kind: 0
  325. 2013-08-16 22:21:48 DEBUG: pid 6378: s_do_auth: backend key data received
  326. 2013-08-16 22:21:48 DEBUG: pid 6378: s_do_auth: transaction state: I
  327. 2013-08-16 22:21:48 DEBUG: pid 6395: s_do_auth: auth kind: 0
  328. 2013-08-16 22:21:48 DEBUG: pid 6395: s_do_auth: backend key data received
  329. 2013-08-16 22:21:48 DEBUG: pid 6395: s_do_auth: transaction state: I
  330. 2013-08-16 22:21:48 DEBUG: pid 6396: s_do_auth: auth kind: 0
  331. 2013-08-16 22:21:48 DEBUG: pid 6396: s_do_auth: backend key data received
  332. 2013-08-16 22:21:48 DEBUG: pid 6396: s_do_auth: transaction state: I
  333. 2013-08-16 22:21:54 DEBUG: pid 6398: I am 6398 accept fd 8
  334. 2013-08-16 22:21:54 LOG: pid 6398: connection received: host=localhost port=54864
  335. 2013-08-16 22:21:54 DEBUG: pid 6398: Protocol Major: 1234 Minor: 5679 database: user:
  336. 2013-08-16 22:21:54 DEBUG: pid 6398: SSLRequest from client
  337. 2013-08-16 22:21:54 DEBUG: pid 6398: read_startup_packet: application_name: psql
  338. 2013-08-16 22:21:54 DEBUG: pid 6398: Protocol Major: 3 Minor: 0 database: pgpool_consolidator user: postgres
  339. 2013-08-16 22:21:54 DEBUG: pid 6398: new_connection: connecting 0 backend
  340. 2013-08-16 22:21:54 DEBUG: pid 6398: new_connection: connecting 1 backend
  341. 2013-08-16 22:21:54 DEBUG: pid 6398: pool_read_message_length: slot: 0 length: 8
  342. 2013-08-16 22:21:54 DEBUG: pid 6398: pool_read_message_length: slot: 1 length: 8
  343. 2013-08-16 22:21:54 DEBUG: pid 6398: pool_do_auth: auth kind:3
  344. 2013-08-16 22:21:54 DEBUG: pid 6398: trying clear text password authentication
  345. 2013-08-16 22:21:54 DEBUG: pid 6398: do_clear_text_password: failed to read password packet "p"
  346. 2013-08-16 22:21:54 DEBUG: pid 6398: do_clear_text_password failed in slot 0
  347. 2013-08-16 22:21:56 DEBUG: pid 6376: I am 6376 accept fd 8
  348. 2013-08-16 22:21:56 LOG: pid 6376: connection received: host=localhost port=54867
  349. 2013-08-16 22:21:56 DEBUG: pid 6376: Protocol Major: 1234 Minor: 5679 database: user:
  350. 2013-08-16 22:21:56 DEBUG: pid 6376: SSLRequest from client
  351. 2013-08-16 22:21:56 DEBUG: pid 6376: read_startup_packet: application_name: psql
  352. 2013-08-16 22:21:56 DEBUG: pid 6376: Protocol Major: 3 Minor: 0 database: pgpool_consolidator user: postgres
  353. 2013-08-16 22:21:56 DEBUG: pid 6376: new_connection: connecting 0 backend
  354. 2013-08-16 22:21:56 DEBUG: pid 6376: new_connection: connecting 1 backend
  355. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length: slot: 0 length: 8
  356. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length: slot: 1 length: 8
  357. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_do_auth: auth kind:3
  358. 2013-08-16 22:21:56 DEBUG: pid 6376: trying clear text password authentication
  359. 2013-08-16 22:21:56 DEBUG: pid 6376: trying clear text password authentication
  360. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 26
  361. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 26
  362. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: application_name value: psql
  363. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: application_name value: psql
  364. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 25
  365. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 25
  366. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: client_encoding value: UTF8
  367. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: client_encoding value: UTF8
  368. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 23
  369. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 23
  370. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: DateStyle value: ISO, MDY
  371. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: DateStyle value: ISO, MDY
  372. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 25
  373. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 25
  374. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: integer_datetimes value: on
  375. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: integer_datetimes value: on
  376. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 27
  377. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 27
  378. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: IntervalStyle value: postgres
  379. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: IntervalStyle value: postgres
  380. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 20
  381. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 20
  382. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: is_superuser value: on
  383. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: is_superuser value: on
  384. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 25
  385. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 25
  386. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: server_encoding value: UTF8
  387. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: server_encoding value: UTF8
  388. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 25
  389. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 25
  390. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: server_version value: 9.2.4
  391. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: server_version value: 9.2.4
  392. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 35
  393. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 35
  394. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: session_authorization value: postgres
  395. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: session_authorization value: postgres
  396. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 35
  397. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 35
  398. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: standard_conforming_strings value: on
  399. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: standard_conforming_strings value: on
  400. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 0 length: 25
  401. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length2: master slot: 1 length: 25
  402. 2013-08-16 22:21:56 DEBUG: pid 6376: 0 th backend: name: TimeZone value: Asia/Manila
  403. 2013-08-16 22:21:56 DEBUG: pid 6376: 1 th backend: name: TimeZone value: Asia/Manila
  404. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length: slot: 0 length: 12
  405. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length: slot: 1 length: 12
  406. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_do_auth: cp->info[i]:0x7fa7f587e000 pid:6359
  407. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_do_auth: cp->info[i]:0x7fa7f587e088 pid:24961
  408. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_send_auth_ok: send pid 24961 to frontend
  409. 2013-08-16 22:21:56 DEBUG: pid 6376: select_load_balancing_node: selected backend id is 1
  410. 2013-08-16 22:21:56 DEBUG: pid 6376: selected load balancing node: 1
  411. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_query_in_progress: done
  412. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_command_success: done
  413. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_writing_transaction: done
  414. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_failed_transaction: done
  415. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_transaction_isolation: done
  416. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_skip_reading_from_backends: done
  417. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_unset_ignore_till_sync: done
  418. 2013-08-16 22:21:56 DEBUG: pid 6376: read_kind_from_backend: kind: Z from 0 th backend
  419. 2013-08-16 22:21:56 DEBUG: pid 6376: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2
  420. 2013-08-16 22:21:56 DEBUG: pid 6376: read_kind_from_backend: kind: Z from 1 th backend
  421. 2013-08-16 22:21:56 DEBUG: pid 6376: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2
  422. 2013-08-16 22:21:56 DEBUG: pid 6376: ProcessBackendResponse: kind from backend: Z
  423. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length: slot: 0 length: 5
  424. 2013-08-16 22:21:56 DEBUG: pid 6376: pool_read_message_length: slot: 1 length: 5
  425. 2013-08-16 22:21:56 DEBUG: pid 6376: ReadyForQuery: transaction state:\00
  426. 2013-08-16 22:21:56 DEBUG: pid 6376: ReadyForQuery: transaction state:I
  427. 2013-08-16 22:21:56 DEBUG: pid 6376: ProcessBackendResponse: Ready For Query
  428. 2013-08-16 22:21:58 DEBUG: pid 6376: ProcessFrontendResponse: kind from frontend Q(51)
  429. 2013-08-16 22:21:58 DEBUG: pid 6376: pool_unset_doing_extended_query_message: done
  430. 2013-08-16 22:21:58 LOG: pid 6376: statement: SELECT "skuno","branchcode","vendorcode","deptcode","classcode","subclasscode",SUM("qtysold") qtysold,SUM( "qtysold"*"sellprice" ) gs,SUM( ("costprice"/"uomconvf")*"qtysold" ) AS gc
  431. FROM
  432. salesdtl_itemmaster
  433. WHERE
  434. "trxdate" BETWEEN '2011-08-01' AND '2011-08-31' AND "vendorcode" IN(17675, 40400) AND (( deptcode = 7 AND classcode = 10 ))
  435. GROUP BY "skuno","branchcode","vendorcode","deptcode","classcode","subclasscode";
  436. 2013-08-16 22:21:58 DEBUG: pid 6376: pool_set_query_in_progress: done
  437. 2013-08-16 22:21:58 DEBUG: pid 6376: initSelectStmt: ANALYZE now(0)
  438. 2013-08-16 22:21:58 DEBUG: pid 6376: inside build_range_info num= 1 current_select=0
  439. 2013-08-16 22:21:58 DEBUG: pid 6376: inside build_range_info dist 0
  440. 2013-08-16 22:21:58 DEBUG: pid 6376: inside build_virtual_info dist state=P salesdtl_itemmaster
  441. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=0,col=trxno,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  442. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=1,col=orno,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  443. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=2,col=trxdate,type=date,table=salesdtl_itemmaster,state=P,valid=-1
  444. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=3,col=dtltype,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  445. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=4,col=lineno,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  446. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=5,col=skuno,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  447. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=6,col=skudesc,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  448. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=7,col=qtysold,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  449. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=8,col=costprice,type=numeric(16,2),table=salesdtl_itemmaster,state=P,valid=-1
  450. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=9,col=sellprice,type=numeric(16,2),table=salesdtl_itemmaster,state=P,valid=-1
  451. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=10,col=orig_rep,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  452. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=11,col=retailprice,type=real,table=salesdtl_itemmaster,state=P,valid=-1
  453. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=12,col=vattype,type=character(2),table=salesdtl_itemmaster,state=P,valid=-1
  454. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=13,col=deptcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  455. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=14,col=classcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  456. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=15,col=subclasscode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  457. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=16,col=vendorcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  458. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=17,col=disccode,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  459. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=18,col=discperc,type=numeric(12,4),table=salesdtl_itemmaster,state=P,valid=-1
  460. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=19,col=eventcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  461. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=20,col=itemtype,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  462. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=21,col=upc,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  463. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=22,col=csa,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  464. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=23,col=branchcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  465. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=24,col=termcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  466. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=25,col=uomconvf,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  467. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=26,col=unit_cost_sales,type=numeric(16,2),table=salesdtl_itemmaster,state=P,valid=-1
  468. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=27,col=itm_deptcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  469. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=28,col=itm_classcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  470. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=29,col=itm_subclasscode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  471. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=30,col=itm_vendorcode,type=integer,table=salesdtl_itemmaster,state=P,valid=-1
  472. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=31,col=itm_prodlinecode,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  473. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=32,col=itm_merchgrpcode,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  474. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=33,col=itm_buyercode,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  475. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=34,col=itm_origin,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  476. 2013-08-16 22:21:58 DEBUG: pid 6376: append_virtual_table select=0, no=35,col=itm_format,type=character varying,table=salesdtl_itemmaster,state=P,valid=-1
  477. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(skuno) detect
  478. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef skuno now(0),last(-1) part(1) call_part(-1)
  479. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(branchcode) detect
  480. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef branchcode now(0),last(-1) part(1) call_part(-1)
  481. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(vendorcode) detect
  482. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef vendorcode now(0),last(-1) part(1) call_part(-1)
  483. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(deptcode) detect
  484. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef deptcode now(0),last(-1) part(1) call_part(-1)
  485. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(classcode) detect
  486. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef classcode now(0),last(-1) part(1) call_part(-1)
  487. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(subclasscode) detect
  488. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef subclasscode now(0),last(-1) part(1) call_part(-1)
  489. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(qtysold) detect
  490. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef qtysold now(0),last(-1) part(1) call_part(-1)
  491. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(qtysold) detect
  492. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef qtysold now(0),last(-1) part(1) call_part(-1)
  493. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(sellprice) detect
  494. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef sellprice now(0),last(-1) part(1) call_part(-1)
  495. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(costprice) detect
  496. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef costprice now(0),last(-1) part(1) call_part(-1)
  497. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(uomconvf) detect
  498. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef uomconvf now(0),last(-1) part(1) call_part(-1)
  499. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(qtysold) detect
  500. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef qtysold now(0),last(-1) part(1) call_part(-1)
  501. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(trxdate) detect
  502. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef trxdate now(0),last(-1) part(2) call_part(-1)
  503. 2013-08-16 22:21:58 DEBUG: pid 6376: GetInnerRef state = P now select(0), table_name=(salesdtl_itemmaster), col_name=(trxdate) detect
  504. 2013-08-16 22:21:58 DEBUG: pid 6376: return state is P
  505. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(trxdate) detect
  506. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef trxdate now(0),last(-1) part(2) call_part(-1)
  507. 2013-08-16 22:21:58 DEBUG: pid 6376: GetInnerRef state = P now select(0), table_name=(salesdtl_itemmaster), col_name=(trxdate) detect
  508. 2013-08-16 22:21:58 DEBUG: pid 6376: return state is P
  509. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(vendorcode) detect
  510. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef vendorcode now(0),last(-1) part(2) call_part(-1)
  511. 2013-08-16 22:21:58 DEBUG: pid 6376: GetInnerRef state = P now select(0), table_name=(salesdtl_itemmaster), col_name=(vendorcode) detect
  512. 2013-08-16 22:21:58 DEBUG: pid 6376: return state is P
  513. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(deptcode) detect
  514. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef deptcode now(0),last(-1) part(2) call_part(-1)
  515. 2013-08-16 22:21:58 DEBUG: pid 6376: GetInnerRef state = P now select(0), table_name=(salesdtl_itemmaster), col_name=(deptcode) detect
  516. 2013-08-16 22:21:58 DEBUG: pid 6376: return state is P
  517. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(classcode) detect
  518. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef classcode now(0),last(-1) part(2) call_part(-1)
  519. 2013-08-16 22:21:58 DEBUG: pid 6376: GetInnerRef state = P now select(0), table_name=(salesdtl_itemmaster), col_name=(classcode) detect
  520. 2013-08-16 22:21:58 DEBUG: pid 6376: return state is P
  521. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(skuno) detect
  522. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef skuno now(0),last(-1) part(3) call_part(-1)
  523. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(branchcode) detect
  524. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef branchcode now(0),last(-1) part(3) call_part(-1)
  525. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(vendorcode) detect
  526. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef vendorcode now(0),last(-1) part(3) call_part(-1)
  527. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(deptcode) detect
  528. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef deptcode now(0),last(-1) part(3) call_part(-1)
  529. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(classcode) detect
  530. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef classcode now(0),last(-1) part(3) call_part(-1)
  531. 2013-08-16 22:21:58 DEBUG: pid 6376: DetectValidColumn no = 0, col_name=(subclasscode) detect
  532. 2013-08-16 22:21:58 DEBUG: pid 6376: ChangeStatebyColumnRef subclasscode now(0),last(-1) part(3) call_part(-1)
  533. 2013-08-16 22:21:58 DEBUG: pid 6376: AnalyzeReturnRecord: current_select=0
  534. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=0
  535. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=skuno,type=character varying base=1
  536. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=1
  537. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=branchcode,type=integer base=2
  538. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=2
  539. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=vendorcode,type=integer base=3
  540. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=3
  541. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=deptcode,type=integer base=4
  542. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=4
  543. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=classcode,type=integer base=5
  544. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=5
  545. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=subclasscode,type=integer base=6
  546. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=6
  547. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=qtysold,type=text base=7
  548. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=7
  549. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=gs,type=text base=8
  550. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: base=8
  551. 2013-08-16 22:21:58 DEBUG: pid 6376: append_select_def_info: col=gc,type=text base=9
  552. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteSelectStmt select_no=0 state=PSPSSSSS
  553. 2013-08-16 22:21:58 DEBUG: pid 6376: analyze_debug :select no(0), last select(-1), last_part(-1), state(S)
  554. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteSelectStmt:START QueryRewrite
  555. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 3
  556. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: check(0) ret_num=0
  557. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: col ret_num=0 col_name=skuno
  558. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=0
  559. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 4
  560. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: check(0) ret_num=1
  561. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: col ret_num=0 col_name=branchcode
  562. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=1
  563. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 5
  564. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: check(0) ret_num=2
  565. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: col ret_num=0 col_name=vendorcode
  566. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=2
  567. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 6
  568. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: check(0) ret_num=3
  569. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: col ret_num=0 col_name=deptcode
  570. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=3
  571. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 7
  572. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: check(0) ret_num=4
  573. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: col ret_num=0 col_name=classcode
  574. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=4
  575. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 8
  576. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: check(0) ret_num=5
  577. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteResTarget: col ret_num=0 col_name=subclasscode
  578. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=5
  579. 2013-08-16 22:21:58 DEBUG: pid 6376: _FuncCall: aggregate no = 0
  580. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=6
  581. 2013-08-16 22:21:58 DEBUG: pid 6376: _FuncCall: aggregate no = 1
  582. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=7
  583. 2013-08-16 22:21:58 DEBUG: pid 6376: _FuncCall: aggregate no = 2
  584. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteList select=0,count=8
  585. 2013-08-16 22:21:58 DEBUG: pid 6376: writeSelectAggHeader select_no=0 state=0
  586. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 3
  587. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 4
  588. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 5
  589. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 6
  590. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 7
  591. 2013-08-16 22:21:58 DEBUG: pid 6376: _rewriteColumnRef: aggregate no = 8
  592. 2013-08-16 22:21:58 DEBUG: pid 6376: OneNode_do_command: Query: SELECT pool_g$3 AS skuno,pool_g$4 AS branchcode,pool_g$5 AS vendorcode,pool_g$6 AS deptcode,pool_g$7 AS classcode,pool_g$8 AS subclasscode,sum(pool_g$0) AS qtysold,sum(pool_g$1) AS gs,sum(pool_g$2) AS gc FROM dblink('host=worker01 dbname=pgpool_consolidator port=9990 user=postgres password=p@55w0rd','SELECT pool_parallel("SELECT sum(qtysold),sum( (qtysold*sellprice )),sum( ( (costprice/uomconvf )*qtysold )),skuno,branchcode,vendorcode,deptcode,classcode,subclasscode FROM salesdtl_itemmaster WHERE ( ( ( (trxdate>=''2011-08-01'' ) AND (trxdate<=''2011-08-31'' )) AND vendorcode IN (17675,40400)) AND ( (deptcode=7 ) AND (classcode=10 ))) GROUP BY skuno,branchcode,vendorcode,deptcode,classcode,subclasscode")',false) AS pool_t$0g (pool_g$0 numeric,pool_g$1 numeric,pool_g$2 numeric,pool_g$3 character varying,pool_g$4 integer,pool_g$5 integer,pool_g$6 integer,pool_g$7 integer,pool_g$8 integer) GROUP BY pool_g$3,pool_g$4,pool_g$5,pool_g$6,pool_g$7,pool_g$8
  593. 2013-08-16 22:21:58 DEBUG: pid 6398: I am 6398 accept fd 8
  594. 2013-08-16 22:21:58 LOG: pid 6398: connection received: host=localhost port=51949
  595. 2013-08-16 22:21:58 DEBUG: pid 6398: Protocol Major: 1234 Minor: 5679 database: user:
  596. 2013-08-16 22:21:58 DEBUG: pid 6398: SSLRequest from client
  597. 2013-08-16 22:21:58 DEBUG: pid 6398: Protocol Major: 3 Minor: 0 database: pgpool_consolidator user: postgres
  598. 2013-08-16 22:21:58 DEBUG: pid 6398: new_connection: connecting 0 backend
  599. 2013-08-16 22:21:58 DEBUG: pid 6398: new_connection: connecting 1 backend
  600. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 0 length: 8
  601. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 1 length: 8
  602. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_do_auth: auth kind:3
  603. 2013-08-16 22:21:58 DEBUG: pid 6398: trying clear text password authentication
  604. 2013-08-16 22:21:58 DEBUG: pid 6398: trying clear text password authentication
  605. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 22
  606. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 22
  607. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: application_name value:
  608. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: application_name value:
  609. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 25
  610. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 25
  611. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: client_encoding value: UTF8
  612. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: client_encoding value: UTF8
  613. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 23
  614. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 23
  615. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: DateStyle value: ISO, MDY
  616. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: DateStyle value: ISO, MDY
  617. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 25
  618. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 25
  619. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: integer_datetimes value: on
  620. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: integer_datetimes value: on
  621. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 27
  622. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 27
  623. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: IntervalStyle value: postgres
  624. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: IntervalStyle value: postgres
  625. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 20
  626. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 20
  627. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: is_superuser value: on
  628. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: is_superuser value: on
  629. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 25
  630. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 25
  631. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: server_encoding value: UTF8
  632. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: server_encoding value: UTF8
  633. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 25
  634. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 25
  635. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: server_version value: 9.2.4
  636. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: server_version value: 9.2.4
  637. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 35
  638. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 35
  639. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: session_authorization value: postgres
  640. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: session_authorization value: postgres
  641. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 35
  642. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 35
  643. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: standard_conforming_strings value: on
  644. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: standard_conforming_strings value: on
  645. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 0 length: 25
  646. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length2: master slot: 1 length: 25
  647. 2013-08-16 22:21:58 DEBUG: pid 6398: 0 th backend: name: TimeZone value: Asia/Manila
  648. 2013-08-16 22:21:58 DEBUG: pid 6398: 1 th backend: name: TimeZone value: Asia/Manila
  649. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 0 length: 12
  650. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 1 length: 12
  651. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_do_auth: cp->info[i]:0x7fa7f599f000 pid:6360
  652. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_do_auth: cp->info[i]:0x7fa7f599f088 pid:24962
  653. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_send_auth_ok: send pid 24962 to frontend
  654. 2013-08-16 22:21:58 DEBUG: pid 6398: select_load_balancing_node: selected backend id is 1
  655. 2013-08-16 22:21:58 DEBUG: pid 6398: selected load balancing node: 1
  656. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_query_in_progress: done
  657. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_command_success: done
  658. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_writing_transaction: done
  659. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_failed_transaction: done
  660. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_transaction_isolation: done
  661. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_skip_reading_from_backends: done
  662. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_ignore_till_sync: done
  663. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: Z from 0 th backend
  664. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2
  665. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: Z from 1 th backend
  666. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2
  667. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessBackendResponse: kind from backend: Z
  668. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 0 length: 5
  669. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 1 length: 5
  670. 2013-08-16 22:21:58 DEBUG: pid 6398: ReadyForQuery: transaction state:\00
  671. 2013-08-16 22:21:58 DEBUG: pid 6398: ReadyForQuery: transaction state:I
  672. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessBackendResponse: Ready For Query
  673. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessFrontendResponse: kind from frontend Q(51)
  674. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_doing_extended_query_message: done
  675. 2013-08-16 22:21:58 LOG: pid 6398: statement: set client_encoding to 'UTF8'
  676. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_set_query_in_progress: done
  677. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_rewrite_stmt: query rule 742
  678. 2013-08-16 22:21:58 LOG: pid 6398: DB node id: 0 backend pid: 6360 statement: BEGIN
  679. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: Query: BEGIN
  680. 2013-08-16 22:21:58 DEBUG: pid 6398: wait_for_query_response: waiting for backend 0 completing the query
  681. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: C
  682. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: C
  683. 2013-08-16 22:21:58 DEBUG: pid 6398: len:a000000
  684. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: Z
  685. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: transaction state: T
  686. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_writing_transaction: done
  687. 2013-08-16 22:21:58 LOG: pid 6398: DB node id: 1 backend pid: 24962 statement: BEGIN
  688. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: Query: BEGIN
  689. 2013-08-16 22:21:58 DEBUG: pid 6398: wait_for_query_response: waiting for backend 1 completing the query
  690. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: C
  691. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: C
  692. 2013-08-16 22:21:58 DEBUG: pid 6398: len:a000000
  693. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: Z
  694. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: transaction state: T
  695. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_writing_transaction: done
  696. 2013-08-16 22:21:58 LOG: pid 6398: DB node id: 0 backend pid: 6360 statement: set client_encoding to 'UTF8'
  697. 2013-08-16 22:21:58 DEBUG: pid 6398: wait_for_query_response: waiting for backend 0 completing the query
  698. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: S
  699. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: S
  700. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: S
  701. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: S
  702. 2013-08-16 22:21:58 LOG: pid 6398: DB node id: 1 backend pid: 24962 statement: set client_encoding to 'UTF8'
  703. 2013-08-16 22:21:58 DEBUG: pid 6398: wait_for_query_response: waiting for backend 1 completing the query
  704. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: S from 0 th backend
  705. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: parameter name: client_encoding value: UTF8
  706. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: C from 0 th backend
  707. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 0 th backend C NUM_BACKENDS: 2
  708. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: S from 1 th backend
  709. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: parameter name: client_encoding value: UTF8
  710. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: C from 1 th backend
  711. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 1 th backend C NUM_BACKENDS: 2
  712. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessBackendResponse: kind from backend: C
  713. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_set_command_success: done
  714. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: Z from 0 th backend
  715. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2
  716. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: Z from 1 th backend
  717. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 1 th backend Z NUM_BACKENDS: 2
  718. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessBackendResponse: kind from backend: Z
  719. 2013-08-16 22:21:58 LOG: pid 6398: DB node id: 1 backend pid: 24962 statement: COMMIT
  720. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: Query: COMMIT
  721. 2013-08-16 22:21:58 DEBUG: pid 6398: wait_for_query_response: waiting for backend 1 completing the query
  722. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: C
  723. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: C
  724. 2013-08-16 22:21:58 DEBUG: pid 6398: len:b000000
  725. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: Z
  726. 2013-08-16 22:21:58 LOG: pid 6398: DB node id: 0 backend pid: 6360 statement: COMMIT
  727. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: Query: COMMIT
  728. 2013-08-16 22:21:58 DEBUG: pid 6398: wait_for_query_response: waiting for backend 0 completing the query
  729. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: C
  730. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: C
  731. 2013-08-16 22:21:58 DEBUG: pid 6398: len:b000000
  732. 2013-08-16 22:21:58 DEBUG: pid 6398: do_command: kind: Z
  733. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 0 length: 5
  734. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_read_message_length: slot: 1 length: 5
  735. 2013-08-16 22:21:58 DEBUG: pid 6398: ReadyForQuery: transaction state:T
  736. 2013-08-16 22:21:58 DEBUG: pid 6398: ReadyForQuery: transaction state:I
  737. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_query_in_progress: done
  738. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_query_in_progress: done
  739. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessBackendResponse: Ready For Query
  740. 2013-08-16 22:21:58 DEBUG: pid 6398: ProcessFrontendResponse: kind from frontend Q(51)
  741. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_doing_extended_query_message: done
  742. 2013-08-16 22:21:58 LOG: pid 6398: statement: SELECT pool_parallel("SELECT sum(qtysold),sum( (qtysold*sellprice )),sum( ( (costprice/uomconvf )*qtysold )),skuno,branchcode,vendorcode,deptcode,classcode,subclasscode FROM salesdtl_itemmaster WHERE ( ( ( (trxdate>='2011-08-01' ) AND (trxdate<='2011-08-31' )) AND vendorcode IN (17675,40400)) AND ( (deptcode=7 ) AND (classcode=10 ))) GROUP BY skuno,branchcode,vendorcode,deptcode,classcode,subclasscode")
  743. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_set_query_in_progress: done
  744. 2013-08-16 22:21:58 DEBUG: pid 6398: can pool_parallel_exec SELECT sum(qtysold),sum( (qtysold*sellprice )),sum( ( (costprice/uomconvf )*qtysold )),skuno,branchcode,vendorcode,deptcode,classcode,subclasscode FROM salesdtl_itemmaster WHERE ( ( ( (trxdate>='2011-08-01' ) AND (trxdate<='2011-08-31' )) AND vendorcode IN (17675,40400)) AND ( (deptcode=7 ) AND (classcode=10 ))) GROUP BY skuno,branchcode,vendorcode,deptcode,classcode,subclasscode
  745. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_query: 0 th FD_SET: 9
  746. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_query: 1 th FD_SET: 10
  747. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_query: num_fds: 11
  748. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_one_backend: read kind from 0 th backend T
  749. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_exec: kind from backend: T
  750. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_exec: dummy from backend: C
  751. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_query: 1 th FD_SET: 10
  752. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_query: num_fds: 11
  753. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_one_backend: read kind from 1 th backend T
  754. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_exec: dummy kind from backend: T
  755. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_exec: kind from backend: D 114
  756. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_parallel_exec: kind from backend: C
  757. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_query_in_progress: done
  758. 2013-08-16 22:21:58 DEBUG: pid 6398: pool_unset_query_in_progress: done
  759. 2013-08-16 22:21:58 LOG: pid 6398: pool_process_query: discard Z packet from backend 1
  760. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: Z
  761. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: Z
  762. 2013-08-16 22:21:58 DEBUG: pid 6398: detect_error: kind: Z
  763. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: kind: Z from 0 th backend
  764. 2013-08-16 22:21:58 DEBUG: pid 6398: read_kind_from_backend: read kind from 0 th backend Z NUM_BACKENDS: 2
  765. 2013-08-16 22:22:18 DEBUG: pid 6357: starting health checking
  766. 2013-08-16 22:22:18 DEBUG: pid 6357: health check: clearing alarm
  767. 2013-08-16 22:22:18 DEBUG: pid 6357: health_check: 0 th DB node status: 2
  768. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: auth kind: 3
  769. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: auth kind: 0
  770. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: backend key data received
  771. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: transaction state: I
  772. 2013-08-16 22:22:18 DEBUG: pid 6357: health_check: 1 th DB node status: 2
  773. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: auth kind: 3
  774. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: auth kind: 0
  775. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: backend key data received
  776. 2013-08-16 22:22:18 DEBUG: pid 6357: s_do_auth: transaction state: I
  777. 2013-08-16 22:22:18 DEBUG: pid 6357: health_check: SystemDB status: 2
  778. 2013-08-16 22:22:18 DEBUG: pid 6357: health check: clearing alarm
  779. 2013-08-16 22:22:18 DEBUG: pid 6357: health check: clearing alarm
  780. 2013-08-16 22:22:48 DEBUG: pid 6357: starting health checking
  781. 2013-08-16 22:22:48 DEBUG: pid 6357: health check: clearing alarm
  782. 2013-08-16 22:22:48 DEBUG: pid 6357: health_check: 0 th DB node status: 2
  783. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: auth kind: 3
  784. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: auth kind: 0
  785. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: backend key data received
  786. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: transaction state: I
  787. 2013-08-16 22:22:48 DEBUG: pid 6357: health_check: 1 th DB node status: 2
  788. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: auth kind: 3
  789. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: auth kind: 0
  790. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: backend key data received
  791. 2013-08-16 22:22:48 DEBUG: pid 6357: s_do_auth: transaction state: I
  792. 2013-08-16 22:22:48 DEBUG: pid 6357: health_check: SystemDB status: 2
  793. 2013-08-16 22:22:48 DEBUG: pid 6357: health check: clearing alarm
  794. 2013-08-16 22:22:48 DEBUG: pid 6357: health check: clearing alarm
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!