API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 12th, 2017
163
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.79 KB | None | 0 0
raw download clone embed print report
  1. 2017-08-12 15:07:23,313 INFO [STDOUT] (org.springframework.scheduling.quartz.SchedulerFactoryBean#1aa49e9a_Worker-1) 15:07:23,312 ERROR [TransactionInterceptor:342] Application exception overridden by rollback exception
  2. com.liferay.portal.kernel.dao.orm.ORMException: could not execute query
  3. at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:41)
  4. at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:103)
  5. at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:88)
  6. at com.liferay.portlet.journal.service.persistence.JournalArticleFinderImpl.findByExpirationDate(JournalArticleFinderImpl.java:288)
  7. at com.liferay.portlet.journal.service.impl.JournalArticleLocalServiceImpl.checkArticles(JournalArticleLocalServiceImpl.java:483)
  8. at sun.reflect.GeneratedMethodAccessor542.invoke(Unknown Source)
  9. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  10. at java.lang.reflect.Method.invoke(Method.java:597)
  11. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
  12. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
  13. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
  14. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
  15. at com.liferay.portal.mirage.aop.JournalArticleLocalServiceAdvice.doInvoke(JournalArticleLocalServiceAdvice.java:133)
  16. at com.liferay.portal.mirage.aop.BaseMirageAdvice.invoke(BaseMirageAdvice.java:47)
  17. at sun.reflect.GeneratedMethodAccessor541.invoke(Unknown Source)
  18. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  19. at java.lang.reflect.Method.invoke(Method.java:597)
  20. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
  21. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
  22. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
  23. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  24. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
  25. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  26. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  27. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  28. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  29. at com.sun.proxy.$Proxy403.checkArticles(Unknown Source)
  30. at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.checkArticles(JournalArticleLocalServiceUtil.java:262)
  31. at com.liferay.portlet.journal.job.CheckArticleJob.execute(CheckArticleJob.java:49)
  32. at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
  33. at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
  34. at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
  35. 2017-08-12 15:07:23,313 INFO [STDOUT] (org.springframework.scheduling.quartz.SchedulerFactoryBean#1aa49e9a_Worker-1) 15:07:23,313 ERROR [CheckArticleJob:52]
  36. org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
  37. at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:677)
  38. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:823)
  39. at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:800)
  40. at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:339)
  41. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  42. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  43. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  44. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  45. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  46. at com.sun.proxy.$Proxy403.checkArticles(Unknown Source)
  47. at com.liferay.portlet.journal.service.JournalArticleLocalServiceUtil.checkArticles(JournalArticleLocalServiceUtil.java:262)
  48. at com.liferay.portlet.journal.job.CheckArticleJob.execute(CheckArticleJob.java:49)
  49. at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
  50. at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
  51. at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
  52. Caused by: org.hibernate.TransactionException: JDBC rollback failed
  53. at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:204)
  54. at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:674)
  55. ... 14 more
  56. Caused by: org.postgresql.util.PSQLException: This connection has been closed.
  57. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:786)
  58. at org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:793)
  59. at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
  60. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  61. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  62. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  63. at java.lang.reflect.Method.invoke(Method.java:597)
  64. at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:364)
  65. at com.sun.proxy.$Proxy261.rollback(Unknown Source)
  66. at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)
  67. at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
  68. ... 15 more
  69.  
  70. # - Connection Settings -
  71.  
  72. #listen_addresses = 'localhost' # what IP address(es) to listen on;
  73. # comma-separated list of addresses;
  74. # defaults to 'localhost'; use '*' for all
  75. # (change requires restart)
  76. #port = 5432 # (change requires restart)
  77. max_connections = 1500 # (change requires restart)
  78. # Note: Increasing max_connections costs ~400 bytes of shared memory per
  79. # connection slot, plus lock space (see max_locks_per_transaction).
  80. #superuser_reserved_connections = 3 # (change requires restart)
  81. #unix_socket_directories = '/tmp' # comma-separated list of directories
  82. # (change requires restart)
  83. #unix_socket_group = '' # (change requires restart)
  84. #unix_socket_permissions = 0777 # begin with 0 to use octal notation
  85. # (change requires restart)
  86. #bonjour = off # advertise server via Bonjour
  87. # (change requires restart)
  88. #bonjour_name = '' # defaults to the computer name
  89. # (change requires restart)
  90.  
  91. # - Security and Authentication -
  92.  
  93. authentication_timeout = 5min # 1s-600s
  94. #ssl = off # (change requires restart)
  95. #ssl_ciphers = 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH' # allowed SSL ciphers
  96. # (change requires restart)
  97. #ssl_renegotiation_limit = 512MB # amount of data between renegotiations
  98. #ssl_cert_file = 'server.crt' # (change requires restart)
  99. #ssl_key_file = 'server.key' # (change requires restart)
  100. #ssl_ca_file = '' # (change requires restart)
  101. #ssl_crl_file = '' # (change requires restart)
  102. #password_encryption = on
  103. #db_user_namespace = off
  104.  
  105. # Kerberos and GSSAPI
  106. #krb_server_keyfile = ''
  107. #krb_srvname = 'postgres' # (Kerberos only)
  108. #krb_caseins_users = off
  109.  
  110. # - TCP Keepalives -
  111. # see "man 7 tcp" for details
  112.  
  113. #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
  114. # 0 selects the system default
  115. #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
  116. # 0 selects the system default
  117. #tcp_keepalives_count = 0 # TCP_KEEPCNT;
  118. # 0 selects the system default
  119.  
  120.  
  121. #------------------------------------------------------------------------------
  122. # RESOURCE USAGE (except WAL)
  123. #------------------------------------------------------------------------------
  124.  
  125. # - Memory -
  126.  
  127. shared_buffers = 8GB # min 128kB
  128. # (change requires restart)
  129. #temp_buffers = 8MB # min 800kB
  130. #max_prepared_transactions = 0 # zero disables the feature
  131. # (change requires restart)
  132. # Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
  133. # per transaction slot, plus lock space (see max_locks_per_transaction).
  134. # It is not advisable to set max_prepared_transactions nonzero unless you
  135. # actively intend to use prepared transactions.
  136. #work_mem = 1MB # min 64kB
  137. #maintenance_work_mem = 16MB # min 1MB
  138. #max_stack_depth = 2MB # min 100kB
  139.  
  140. # - Disk -
  141.  
  142. #temp_file_limit = -1 # limits per-session temp file space
  143. # in kB, or -1 for no limit
  144.  
  145. # - Kernel Resource Usage -
  146.  
  147. #max_files_per_process = 1000 # min 25
  148. # (change requires restart)
  149. #shared_preload_libraries = '' # (change requires restart)
  150.  
  151. # - Cost-Based Vacuum Delay -
  152.  
  153. #vacuum_cost_delay = 0 # 0-100 milliseconds
  154. #vacuum_cost_page_hit = 1 # 0-10000 credits
  155. #vacuum_cost_page_miss = 10 # 0-10000 credits
  156. #vacuum_cost_page_dirty = 20 # 0-10000 credits
  157. #vacuum_cost_limit = 200 # 1-10000 credits
  158.  
  159. # - Background Writer -
  160.  
  161. #bgwriter_delay = 200ms # 10-10000ms between rounds
  162. #bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
  163. #bgwriter_lru_multiplier = 2.0 # 0-10.0 multipler on buffers scanned/round
  164.  
  165. # - Asynchronous Behavior -
  166.  
  167. #effective_io_concurrency = 1 # 1-1000; 0 disables prefetching
  168.  
  169.  
  170. #------------------------------------------------------------------------------
  171. # WRITE AHEAD LOG
  172. #------------------------------------------------------------------------------
  173.  
  174. # - Settings -
  175.  
  176. #wal_level = minimal # minimal, archive, or hot_standby
  177. # (change requires restart)
  178. #fsync = on # turns forced synchronization on or off
  179. #synchronous_commit = on # synchronization level;
  180. # off, local, remote_write, or on
  181. #wal_sync_method = fsync # the default is the first option
  182. # supported by the operating system:
  183. # open_datasync
  184. # fdatasync (default on Linux)
  185. # fsync
  186. # fsync_writethrough
  187. # open_sync
  188. #full_page_writes = on # recover from partial page writes
  189. #wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers
  190. # (change requires restart)
  191. #wal_writer_delay = 200ms # 1-10000 milliseconds
  192.  
  193. #commit_delay = 0 # range 0-100000, in microseconds
  194. #commit_siblings = 5 # range 1-1000
  195.  
  196. # - Checkpoints -
  197.  
  198. #checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
  199. #checkpoint_timeout = 5min # range 30s-1h
  200. #checkpoint_completion_target = 0.5 # checkpoint target duration, 0.0 - 1.0
  201. #checkpoint_warning = 30s # 0 disables
  202.  
  203. # - Archiving -
  204.  
  205. #archive_mode = off # allows archiving to be done
  206. # (change requires restart)
  207. #archive_command = '' # command to use to archive a logfile segment
  208. # placeholders: %p = path of file to archive
  209. # %f = file name only
  210. # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
  211. #archive_timeout = 0 # force a logfile segment switch after this
  212. # number of seconds; 0 disables
  213.  
  214.  
  215.  
  216. #------------------------------------------------------------------------------
  217. # ERROR REPORTING AND LOGGING
  218. #------------------------------------------------------------------------------
  219.  
  220. # - Where to Log -
  221.  
  222. log_destination = stderr # Valid values are combinations of
  223. # stderr, csvlog, syslog, and eventlog,
  224. # depending on platform. csvlog
  225. # requires logging_collector to be on.
  226.  
  227. # This is used when logging to stderr:
  228. logging_collector = on # Enable capturing of stderr and csvlog
  229. # into log files. Required to be on for
  230. # csvlogs.
  231. # (change requires restart)
  232.  
  233. # These are only used if logging_collector is on:
  234. log_directory = pg_log # directory where log files are written,
  235. # can be absolute or relative to PGDATA
  236. log_filename = 'postgresql-%a.log' # log file name pattern,
  237. # can include strftime() escapes
  238. #log_file_mode = 0600 # creation mode for log files,
  239. # begin with 0 to use octal notation
  240. log_truncate_on_rotation = on # If on, an existing log file with the
  241. # same name as the new log file will be
  242. # truncated rather than appended to.
  243. # But such truncation only occurs on
  244. # time-driven rotation, not on restarts
  245. # or size-driven rotation. Default is
  246. # off, meaning append to existing files
  247. # in all cases.
  248. log_rotation_age = 1d # Automatic rotation of logfiles will
  249. # happen after that time. 0 disables.
  250. log_rotation_size = 0 # Automatic rotation of logfiles will
  251. # happen after that much log output.
  252. # 0 disables.
  253.  
  254. # These are relevant when logging to syslog:
  255. #syslog_facility = 'LOCAL0'
  256. #syslog_ident = 'postgres'
  257.  
  258. # This is only relevant when logging to eventlog (win32):
  259. #event_source = 'PostgreSQL'
  260.  
  261.  
  262.  
  263.  
  264. # - What to Log -
  265.  
  266. #debug_print_parse = off
  267. #debug_print_rewritten = off
  268. #debug_print_plan = off
  269. #debug_pretty_print = on
  270. #log_checkpoints = off
  271. #log_connections = off
  272. #log_disconnections = off
  273. #log_duration = off
  274. #log_error_verbosity = default # terse, default, or verbose messages
  275. #log_hostname = off
  276. log_line_prefix = '----------------- %m --------------------------------------------------------n %a %u@%d %p n %r n %e' # special values:
  277. # %a = application name
  278. # %u = user name
  279. # %d = database name
  280. # %r = remote host and port
  281. # %h = remote host
  282. # %p = process ID
  283. # %t = timestamp without milliseconds
  284. # %m = timestamp with milliseconds
  285. # %i = command tag
  286. # %e = SQL state
  287. # %c = session ID
  288. # %l = session line number
  289. # %s = session start timestamp
  290. # %v = virtual transaction ID
  291. # %x = transaction ID (0 if none)
  292. # %q = stop here in non-session
  293. # processes
  294. # %% = '%'
  295. # e.g. '<%u%%%d> '
  296. #log_lock_waits = off # log lock waits >= deadlock_timeout
  297. log_statement = 'all' # none, ddl, mod, all
  298. #log_temp_files = -1 # log temporary files equal or larger
  299. # than the specified size in kilobytes;
  300. # -1 disables, 0 logs all temp files
  301. log_timezone = 'Asia/Aden'
  302.  
  303.  
  304. #------------------------------------------------------------------------------
  305. # RUNTIME STATISTICS
  306. #------------------------------------------------------------------------------
  307.  
  308. # - Query/Index Statistics Collector -
  309.  
  310. #track_activities = on
  311. #track_counts = on
  312. #track_io_timing = off
  313. #track_functions = none # none, pl, all
  314. #track_activity_query_size = 1024 # (change requires restart)
  315. #update_process_title = on
  316. #stats_temp_directory = 'pg_stat_tmp'
  317.  
  318.  
  319. # - Statistics Monitoring -
  320.  
  321. #log_parser_stats = off
  322. #log_planner_stats = off
  323. #log_executor_stats = off
  324. #log_statement_stats = off
  325.  
  326.  
  327.  
  328.  
  329. #------------------------------------------------------------------------------
  330. # CLIENT CONNECTION DEFAULTS
  331. #------------------------------------------------------------------------------
  332.  
  333. # - Statement Behavior -
  334.  
  335. #search_path = '"$user",public' # schema names
  336. #default_tablespace = '' # a tablespace name, '' uses the default
  337. #temp_tablespaces = '' # a list of tablespace names, '' uses
  338. # only default tablespace
  339. #check_function_bodies = on
  340. #default_transaction_isolation = 'read committed'
  341. #default_transaction_read_only = off
  342. #default_transaction_deferrable = off
  343. #session_replication_role = 'origin'
  344. #statement_timeout = 0 # in milliseconds, 0 is disabled
  345. #lock_timeout = 0 # in milliseconds, 0 is disabled
  346. #vacuum_freeze_min_age = 50000000
  347. #vacuum_freeze_table_age = 150000000
  348. #vacuum_multixact_freeze_min_age = 5000000
  349. #vacuum_multixact_freeze_table_age = 150000000
  350. #bytea_output = 'hex' # hex, escape
  351. #xmlbinary = 'base64'
  352. #xmloption = 'content'
  353.  
  354. # - Locale and Formatting -
  355.  
  356. datestyle = 'iso, mdy'
  357. #intervalstyle = 'postgres'
  358. timezone = 'Asia/Aden'
  359. #timezone_abbreviations = 'Default' # Select the set of available time zone
  360. # abbreviations. Currently, there are
  361. # Default
  362. # Australia (historical usage)
  363. # India
  364. # You can create your own file in
  365. # share/timezonesets/.
  366. #extra_float_digits = 0 # min -15, max 3
  367. #client_encoding = sql_ascii # actually, defaults to database
  368. # encoding
  369.  
  370. # These settings are initialized by initdb, but they can be changed.
  371. lc_messages = C # locale for system error message
  372. # strings
  373. lc_monetary = C # locale for monetary formatting
  374. lc_numeric = C # locale for number formatting
  375. lc_time = C # locale for time formatting
  376.  
  377. # default configuration for text search
  378. default_text_search_config = 'pg_catalog.english'
  379.  
  380. # - Other Defaults -
  381.  
  382. #dynamic_library_path = '$libdir'
  383. #local_preload_libraries = ''
  384.  
  385.  
  386. #------------------------------------------------------------------------------
  387. # LOCK MANAGEMENT
  388. #------------------------------------------------------------------------------
  389.  
  390. #deadlock_timeout = 1s
  391. #max_locks_per_transaction = 64 # min 10
  392. # (change requires restart)
  393. # Note: Each lock table slot uses ~270 bytes of shared memory, and there are
  394. # max_locks_per_transaction * (max_connections + max_prepared_transactions)
  395. # lock table slots.
  396. #max_pred_locks_per_transaction = 64 # min 10
  397. # (change requires restart)
  398.  
  399.  
  400. #------------------------------------------------------------------------------
  401. # CUSTOMIZED OPTIONS
  402. #------------------------------------------------------------------------------
  403.  
  404. # Add settings for extensions here
  405. maintenance_work_mem = 1GB
  406. temp_buffers = 32MB
  407. work_mem = 64MB
  408. checkpoint_segments = 32
  409. max_wal_senders = 5
  410. wal_keep_segments = 32
  411. wal_level = hot_standby
  412. data_directory = '/var/lib/pgsql/9.3/data'
  413. listen_addresses = '*'
  414. #log_min_duration_statement = 2min
  415. log_min_duration_statement = 120000
  416. port = 5432
  417. effective_cache_size = 16GB
  418. #synchronous_standby_names = '' # standby servers that provide sync rep
  419. # comma-separated list of application_name
  420. # from standby(s); '*' = all
  421.  
  422. #
  423. # PostgreSQL
  424. #
  425. jdbc.default.driverClassName=org.postgresql.Driver
  426. jdbc.default.url=jdbc:postgresql://192.168.2.3:5432/portal
  427. jdbc.default.username=postgres
  428. jdbc.default.password=postgres
  429.  
  430. javascript.barebone.enabled=true
  431.  
  432. javascript.fast.load=false
  433.  
  434. javascript.log.enabled=false
  435.  
  436. 00000LOG: execute S_7: BEGIN
  437. ----------------- 2017-08-11 21:26:29.818 +03 --------------------------------------------------------
  438. [unknown] pstgres@portal 5671
  439. 10.255.0.2(53718)
  440. 00000LOG: execute S_1/C_27: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME FROM QUARTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME < $2 AND (NEXT_FIRE_TIME >= $3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
  441. ----------------- 2017-08-11 21:26:29.818 +03 --------------------------------------------------------
  442. [unknown] pstgres@portal 5671
  443. 10.255.0.2(53718)
  444. 00000DETAIL: parameters: $1 = 'WAITING', $2 = '1502476248072', $3 = '1502476158072'
  445. ----------------- 2017-08-11 21:26:29.819 +03 --------------------------------------------------------
  446. [unknown] pstgres@portal 5671
  447. 10.255.0.2(53718)
  448. 00000LOG: execute S_3: COMMIT
  449. ----------------- 2017-08-11 21:26:54.564 +03 --------------------------------------------------------
  450. psql postgres@postgres 5923
  451. [local]
  452. 00000LOG: statement: SELECT 1
  453. ----------------- 2017-08-11 21:26:55.630 +03 --------------------------------------------------------
  454. [unknown] pstgres@portal 5671
  455. 10.255.0.2(53718)
  456. 00000LOG: execute S_7: BEGIN
  457. ----------------- 2017-08-11 21:26:55.630 +03 --------------------------------------------------------
  458. [unknown] pstgres@portal 5671
  459. 10.255.0.2(53718)
  460. 00000LOG: execute S_1/C_28: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME FROM QUARTZ_TRIGGERS WHERE TRIGGER_STATE = $1 AND NEXT_FIRE_TIME < $2 AND (NEXT_FIRE_TIME >= $3) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC
  461. ----------------- 2017-08-11 21:26:55.630 +03 --------------------------------------------------------
  462. [unknown] pstgres@portal 5671
  463. 10.255.0.2(53718)
  464. 00000DETAIL: parameters: $1 = 'WAITING', $2 = '1502476273884', $3 = '1502476183884'
  465. ----------------- 2017-08-11 21:26:55.631 +03 --------------------------------------------------------
  466. [unknown] pstgres@portal 5671
  467. 10.255.0.2(53718)
  468. 00000LOG: execute S_3: COMMIT
  469. ----------------- 2017-08-11 21:27:24.510 +03 --------------------------------------------------------
  470. [unknown] pstgres@portal 5671
  471. 10.255.0.2(53718)
  472. 00000LOG: execute S_7: BEGIN
  473. ----------------- 2017-08-11 21:27:24.511 +03 --------------------------------------------------------
  474. [unknown] pstgres@portal 5671
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!