Background Image

FORUM

  1. Home
  2. FORUM
  3. Q&A
2017.08.02 02:00

트랜잭션 관련하여 질문드립니다.

봉보로봉봉
조회 수 414 추천 수 0 댓글 6
?

단축키

Prev이전 문서

Next다음 문서

가 크게 작게 위로 아래로 댓글로 가기 인쇄

* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
OS
 Linux 64bit centOS 6.5
CUBRID Ver.
  9.2.21.0005
CUBRID TOOL Ver.
  10.1.0.002
응용 환경(API)
  php

* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
에러 내용 및 재현 방법 재현 가능한 Source와 SQL
관련 테이블(인덱스, 키정보 포함) 정보 CUBRID 홈 디렉토리 아래 log 디렉토리 압축


-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
저희가 테스트 서버와 운영서버를 돌리고 있는데요

system parameter 확인결과 별반 차이를 찾아보지 못 했습니다.

그래서 문의 드립니다.


경우는 이렇습니다.


1. 트랜잭션을 사용하여 A라는 테이블에 insert 하였습니다. 그리고 sleep을 걸어 트랜잭션 걸리는 시간을 인위적으로 늘려


2. 트랜잭션이 걸린 상태에서 A라는 테이블에 update를 하였습니다.


테스트 서버의 경우에는 

1번 행동이 완료된 후에 update를 동시에 완료하였고


운영서버의 경우에는

1번 행동과는 무관하게 update를 먼저 완료하였습니다.


왜 이런 현상이 있는 지 확인이 가능한지요...


지금 운영서버에서 LOCK걸린 테이블에 update 혹은 insert 과정에서 LOCK에러가 계속 발생하여

연동문제가 계속적으로 발생하고 있습니다.


성수기라 데이터가 급증하고 있는데 이와같은 현상이 점점 늘어나고 있는 해결책이 보이지 않네요


답변 부탁드립니다.





위로 아래로 댓글로 가기 인쇄
에디터 선택하기
?
Comments '6'
  • ?
    정훈 2017.08.03 01:15

    안녕하세요

    운영서버와 개발서버의 cubrid.conf 파일을 비교해서 파라미터 값을 확인해보면 좋을 것 같습니다.


    추가적으로 운영 서버에서 LOCK이 발생했을 때의 트랜잭션에 대한 것을 확인해보면 좋습니다.

    $> cubrid lockdb [db_name]
    유틸리티로 확인하여 LOCK 종류와 잠금 상태를 확인해주세요.


    댓글
  • ?
    봉보로봉봉 2017.08.03 02:33

    *** Lock Table Dump ***
     Lock Escalation at = 100000, Run Deadlock interval =  1.00

    Transaction (index  0, (unknown), (unknown)@(unknown)|-1)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  1, applylogdb, DBA@db02|44028)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_UNACTIVE_COMMITTED
    Timeout_period : Infinite wait

    Transaction (index  2, broker2_cub_cas_1, DBA@db01|62090)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  3, copylogdb, DBA@db01|36351)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  4, broker2_cub_cas_2, DBA@db01|62716)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  5, broker2_cub_cas_4, DBA@db01|62093)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  6, broker2_cub_cas_6, DBA@db01|62095)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  7, broker2_cub_cas_7, DBA@db01|62096)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  8, broker2_cub_cas_8, DBA@db01|62097)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index  9, broker2_cub_cas_9, DBA@db01|62098)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 10, broker2_cub_cas_3, DBA@db01|62092)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 11, broker2_cub_cas_5, DBA@db01|62094)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 12, broker2_cub_cas_11, DBA@db01|62100)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 13, broker2_cub_cas_10, DBA@db01|62099)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 14, broker2_cub_cas_15, DBA@db01|62104)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 15, broker2_cub_cas_13, DBA@db01|62102)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 16, broker2_cub_cas_12, DBA@db01|62101)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 17, broker2_cub_cas_14, DBA@db01|62103)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 18, broker2_cub_cas_16, DBA@db01|62105)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 19, broker2_cub_cas_17, DBA@db01|62106)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 20, broker2_cub_cas_18, DBA@db01|62107)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 21, broker2_cub_cas_19, DBA@db01|62108)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 22, broker2_cub_cas_20, DBA@db01|62109)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 23, broker2_cub_cas_21, DBA@db01|62110)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 24, broker2_cub_cas_2, DBA@db02|496)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 25, broker2_cub_cas_3, DBA@db02|19880)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 26, broker2_cub_cas_25, DBA@db02|9075)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 27, broker2_cub_cas_7, DBA@db02|51989)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 28, broker2_cub_cas_22, DBA@db01|62111)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 29, broker2_cub_cas_23, DBA@db01|62112)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 30, broker2_cub_cas_25, DBA@db01|62114)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 31, broker2_cub_cas_24, DBA@db01|62113)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 32, broker2_cub_cas_26, DBA@db01|62115)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 33, broker2_cub_cas_27, DBA@db01|62116)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 34, broker2_cub_cas_28, DBA@db01|62117)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 35, broker2_cub_cas_29, DBA@db01|62118)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 36, broker2_cub_cas_15, DBA@db02|9109)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 37, broker2_cub_cas_1, DBA@db02|498)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 38, broker2_cub_cas_13, DBA@db02|969)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 39, broker2_cub_cas_14, DBA@db02|9120)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 40, broker2_cub_cas_16, DBA@db02|991)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 41, broker2_cub_cas_17, DBA@db02|9105)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 42, broker2_cub_cas_22, DBA@db02|9083)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 43, broker2_cub_cas_33, DBA@db02|1014)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 44, broker2_cub_cas_26, DBA@db02|460)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 45, broker2_cub_cas_35, DBA@db02|473)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 46, broker2_cub_cas_30, DBA@db01|62119)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 47, broker2_cub_cas_80, DBA@db02|477)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 48, broker2_cub_cas_117, DBA@db02|488)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 49, broker2_cub_cas_119, DBA@db02|497)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 50, broker2_cub_cas_121, DBA@db02|501)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 51, broker2_cub_cas_122, DBA@db02|519)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 52, broker2_cub_cas_123, DBA@db02|528)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 53, broker2_cub_cas_124, DBA@db02|532)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 54, broker2_cub_cas_125, DBA@db02|542)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 55, broker2_cub_cas_127, DBA@db02|550)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 56, broker2_cub_cas_126, DBA@db02|546)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 57, broker2_cub_cas_130, DBA@db02|567)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 58, broker2_cub_cas_128, DBA@db02|559)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 59, broker2_cub_cas_129, DBA@db02|563)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 60, broker2_cub_cas_131, DBA@db02|577)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 61, broker2_cub_cas_133, DBA@db02|585)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 62, broker2_cub_cas_132, DBA@db02|581)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 63, broker2_cub_cas_134, DBA@db02|596)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 64, broker2_cub_cas_135, DBA@db02|601)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 65, broker2_cub_cas_136, DBA@db02|609)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 66, broker2_cub_cas_137, DBA@db02|613)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 67, broker2_cub_cas_138, DBA@db02|622)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 68, broker2_cub_cas_140, DBA@db02|63399)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 69, broker2_cub_cas_141, DBA@db02|63432)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 70, broker2_cub_cas_139, DBA@db02|63391)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 71, broker2_cub_cas_142, DBA@db02|330)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 72, broker2_cub_cas_145, DBA@db02|63455)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 73, broker2_cub_cas_143, DBA@db02|63441)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 74, broker2_cub_cas_144, DBA@db02|63450)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 75, broker2_cub_cas_146, DBA@db02|63468)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 76, broker2_cub_cas_147, DBA@db02|63469)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 77, broker2_cub_cas_31, DBA@db01|62120)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 78, broker2_cub_cas_32, DBA@db01|62121)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 79, broker2_cub_cas_10, DBA@db02|8364)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 80, broker2_cub_cas_5, DBA@db02|18218)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 81, broker2_cub_cas_33, DBA@db01|62122)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 82, broker2_cub_cas_148, DBA@db02|63478)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 83, broker2_cub_cas_149, DBA@db02|63481)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 84, broker2_cub_cas_150, DBA@db02|63523)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 85, broker2_cub_cas_151, DBA@db02|65504)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 86, broker2_cub_cas_152, DBA@db02|65495)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 87, broker2_cub_cas_153, DBA@db02|65490)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 88, broker2_cub_cas_154, DBA@db02|65478)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 89, broker2_cub_cas_159, DBA@db02|65464)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 90, broker2_cub_cas_157, DBA@db02|65474)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 91, broker2_cub_cas_155, DBA@db02|63545)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 92, broker2_cub_cas_156, DBA@db02|63561)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 93, broker2_cub_cas_160, DBA@db02|65460)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 94, broker2_cub_cas_4, DBA@db02|48141)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 95, broker2_cub_cas_158, DBA@db02|63571)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 96, broker2_cub_cas_161, DBA@db02|65452)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 97, broker2_cub_cas_27, DBA@db02|9070)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 98, broker2_cub_cas_162, DBA@db02|63614)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 99, broker2_cub_cas_8, DBA@db02|42506)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 100, broker2_cub_cas_34, DBA@db01|62123)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 101, broker2_cub_cas_35, DBA@db01|62124)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 102, broker2_cub_cas_36, DBA@db01|62125)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 103, broker2_cub_cas_37, DBA@db01|62126)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 104, broker2_cub_cas_38, DBA@db01|62127)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 105, broker2_cub_cas_39, DBA@db01|62128)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 106, broker2_cub_cas_40, DBA@db01|62129)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 107, broker2_cub_cas_45, DBA@db01|62134)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 108, broker2_cub_cas_46, DBA@db01|62135)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 109, broker2_cub_cas_42, DBA@db01|62131)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 110, broker2_cub_cas_41, DBA@db01|62130)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 111, broker2_cub_cas_43, DBA@db01|62132)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 112, broker2_cub_cas_48, DBA@db01|62137)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 113, broker2_cub_cas_50, DBA@db01|62139)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 114, broker2_cub_cas_47, DBA@db01|62136)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 115, broker2_cub_cas_49, DBA@db01|62138)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 116, broker2_cub_cas_44, DBA@db01|62133)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 117, broker2_cub_cas_20, DBA@db02|9087)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 118, broker2_cub_cas_19, DBA@db02|9096)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 119, broker2_cub_cas_12, DBA@db02|16003)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 120, broker2_cub_cas_11, DBA@db02|3318)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 121, broker2_cub_cas_9, DBA@db02|64762)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 122, broker2_cub_cas_6, DBA@db02|63161)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 123, broker2_cub_cas_42, DBA@db02|8877)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 124, broker2_cub_cas_43, DBA@db02|8872)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 125, broker2_cub_cas_44, DBA@db02|8863)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 126, broker2_cub_cas_45, DBA@db02|8859)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 127, broker2_cub_cas_46, DBA@db02|8850)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 128, broker2_cub_cas_50, DBA@db02|8759)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 129, lockdb, DBA@db02|36811)
    Isolation READ COMMITTED CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : No wait

    Transaction (index 157, broker2_cub_cas_18, DBA@db02|40260)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 160, broker2_cub_cas_21, DBA@db02|40277)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 161, broker2_cub_cas_23, DBA@db02|40278)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 162, broker2_cub_cas_24, DBA@db02|40279)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 165, broker2_cub_cas_28, DBA@db02|40282)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 166, broker2_cub_cas_29, DBA@db02|40283)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 167, broker2_cub_cas_30, DBA@db02|40295)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 168, broker2_cub_cas_31, DBA@db02|40296)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 169, broker2_cub_cas_32, DBA@db02|40297)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 170, broker2_cub_cas_34, DBA@db02|40315)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 171, broker2_cub_cas_36, DBA@db02|40317)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 172, broker2_cub_cas_37, DBA@db02|40318)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 173, broker2_cub_cas_38, DBA@db02|40319)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 174, broker2_cub_cas_39, DBA@db02|40320)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 175, broker2_cub_cas_40, DBA@db02|40321)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 176, broker2_cub_cas_41, DBA@db02|40322)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 182, broker2_cub_cas_47, DBA@db02|40330)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 183, broker2_cub_cas_48, DBA@db02|40332)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 184, broker2_cub_cas_49, DBA@db02|40333)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 186, broker2_cub_cas_51, DBA@db02|40335)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 187, broker2_cub_cas_52, DBA@db02|40336)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 188, broker2_cub_cas_53, DBA@db02|40337)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 189, broker2_cub_cas_54, DBA@db02|40338)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Transaction (index 190, broker2_cub_cas_55, DBA@db02|40340)
    Isolation REPEATABLE CLASSES AND READ UNCOMMITTED INSTANCES
    State TRAN_ACTIVE
    Timeout_period : Infinite wait

    Object Lock Table:
            Current number of objects which are locked    = 2
            Maximum number of objects which can be locked = 10000


    위가 확인 내용입니다.

    이걸로 무엇을 확인할 수 있는지요..

    cubrid.conf는 설치할때 초기값이라고 보면 되요

    db이름이나 브로커 정보만 수정하고 다른건 ... 당시에는 손댈줄도 몰랐으니..ㅡㅡ..
    댓글
  • ?
    정훈 2017.08.03 03:23

    현재는 lock 존재하지 않는 것으로 보입니다. lock 발생 시에 확인해주세요. 
    (참고 : http://www.cubrid.com/zbxe/3540951)

    댓글
  • ?
    봉보로봉봉 2017.08.03 07:31

    그러면 LOCK 걸릴때까지 실시간으로 체크해야되는건가요?


    영업시간 9시부터 18시까지 20건 정보 발생하는 것을 체크해서 LOCK걸리는 3~4초의 시간을 캐치하라는 말씀인가요?


    이게 가능한지 모르겠네요..ㅡㅡ.. 해결불가라는 얘기인가요?


    그리고 링크는 홈으로 가는데..ㅡㅡ..

    댓글
  • ?
    정훈 2017.08.03 19:57

    큐브리드 cd $CUBRID/log/server 에 ~.event 라는 파일로 어떤 LOCK이 발생했는지 확인할 수 있습니다. 

    어떤 종류의 lock 인지, 해당 트랜잭션은 무엇인지를 확인해야 명확하게 해결할 수 있습니다.

    다음 메뉴얼을 참조해 주세요.

    (시스템 설정 - http://www.cubrid.org/manual/ko/9.3.0/admin/config.html#lock-parameters )

    (트랜잭션과 잠금 - http://www.cubrid.org/manual/ko/9.3.0/sql/transaction.html#id1 )

    댓글
  • ?
    봉보로봉봉 2017.08.04 01:55
    파라미터 이름타입기본값최소값최대값
    deadlock_detection_interval_in_secsfloat1.00.1 
    isolation_levelint316
    lock_escalationint100,0005 
    lock_timeoutmsec-1(무제한)0(대기안함)INT_MAX
    rollback_on_lock_escalationboolno 

     

    위 내용 값은 전부 기본값인것을 확인하였습니다.




    해당 파일에 Log 입니다.



    08/03/17 00:30:51.228 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(42674)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 00:30:51.433 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:   IX_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 00:30:51.546 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(38810)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 02:17:56.079 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 02:17:56.194 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 05:53:43.381 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 05:53:44.282 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(38810)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 05:53:49.205 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(35785)

      lock:   IS_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:    X_LOCK (oid=0|34988|1, table=ci_session)

      sql: ***EMPTY***


    08/03/17 08:21:28.335 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(49347)

      lock:   NS_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:   NX_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    08/03/17 09:20:47.995 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NS_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(29702)

      lock:   NX_LOCK (oid=-5952|16228|-15333, table=ha_issue, index=i_ha_issue_de_no)

      sql: ***EMPTY***


    08/03/17 09:45:58.849 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_7(33135)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 09:46:09.889 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(29702)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 09:46:12.163 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(29702)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 09:46:53.845 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(64725)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 10:06:14.417 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_9(4130)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '32000007461775'

      bind: 'D32765-32000011245222'

      bind: '3'

      bind: '1501722370'


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 10:45:19.712 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_5(27945)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 11:01:46.340 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_6(34580)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2470279

      bind: '5021096776270290'

      bind: '3'

      bind: '1501725701'


    blocker:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 11:30:12.196 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_7(33135)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 11:30:12.797 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_6(34580)

      lock:   NS_LOCK (oid=-9992|310|-16127, table=ha_use, index=i_ha_use_us_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-9992|310|-16127, table=ha_use, index=i_ha_use_us_cond)

      sql: ***EMPTY***


    08/03/17 11:35:14.872 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2470614

      bind: '5022140776270555'

      bind: '3'

      bind: '1501727714'


    blocker:

      client: DBA@db02|broker1_cub_cas_1(34214)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 11:42:46.253 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(52593)

      lock:   NX_LOCK (oid=-17062|19561|-32199, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:4  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ) or ([ha_use].[us_no]= ?:3 ))

      bind: 8770350.00000000

      bind: 8770351.00000000

      bind: 8770352.00000000

      bind: 8770353.00000000

      bind: 2471406


    blocker:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NS_LOCK (oid=-17062|19561|-32199, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 12:21:10.552 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(31043)

      lock:   NX_LOCK (oid=-17062|19575|-32250, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:1  where [ha_use].[us_no]= ?:0 

      bind: 8771902

      bind: 2471782


    blocker:

      client: DBA@db02|broker1_cub_cas_4(38810)

      lock:   NS_LOCK (oid=-17062|19575|-32250, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 12:33:22.490 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(34214)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 13:24:54.521 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_3(44580)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 13:35:04.239 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(44580)

      lock:   NX_LOCK (oid=-17062|19599|-32187, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:3  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ))

      bind: 8774719.00000000

      bind: 8774720.00000000

      bind: 8774721.00000000

      bind: 2472483


    blocker:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NS_LOCK (oid=-17062|19599|-32187, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 13:45:16.118 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NS_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(45320)

      lock:   NX_LOCK (oid=-22172|310|16644, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 13:45:16.419 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NX_LOCK (oid=-17062|19613|-32235, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:4  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ) or ([ha_use].[us_no]= ?:3 ))

      bind: 8775125.00000000

      bind: 8775126.00000000

      bind: 8775127.00000000

      bind: 8775128.00000000

      bind: 2472571


    blocker:

      client: DBA@db02|broker1_cub_cas_1(45320)

      lock:   NS_LOCK (oid=-17062|19613|-32235, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 13:57:07.130 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NX_LOCK (oid=-17062|19617|-32156, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:2  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ))

      bind: 8775663.00000000

      bind: 8775664.00000000

      bind: 2472696


    blocker:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NS_LOCK (oid=-17062|19617|-32156, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 14:26:21.755 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(44736)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_1(45320)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 14:45:01.186 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(47719)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 14:45:02.593 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 15:00:25.739 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2472684

      bind: '5022140776272761'

      bind: '3'

      bind: '1501740025'


    blocker:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 15:00:27.160 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NX_LOCK (oid=-17062|19652|-32232, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:4  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ) or ([ha_use].[us_no]= ?:3 ))

      bind: 8778449.00000000

      bind: 8778450.00000000

      bind: 8778451.00000000

      bind: 8778452.00000000

      bind: 2473254


    blocker:

      client: DBA@db02|broker1_cub_cas_3(44580)

      lock:   NS_LOCK (oid=-17062|19652|-32232, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 15:20:41.166 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(47719)

      lock:    U_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: 'BEFE49-22000008944305'

      bind: '3'

      bind: '1501741240'


    blocker:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:    U_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: 'BEFE49-22000008944305'

      bind: '3'

      bind: '1501741240'


      client: DBA@db02|broker1_cub_cas_10(59578)

      lock: NULL_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: '008451-22000008944307'

      bind: '3'

      bind: '1501741241'


      client: DBA@db02|broker1_cub_cas_6(50548)

      lock: NULL_LOCK (oid=31|17358|4, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: '008451-22000008944307'

      bind: '3'

      bind: '1501741241'


    08/03/17 15:20:41.575 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '22000006234627'

      bind: 'BEFE49-22000008944305'

      bind: '3'

      bind: '1501741240'


    blocker:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_11(27980)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '5000006241440'

      bind: '5A4D1F-5000008929089'

      bind: '3'

      bind: '1501741241'


    08/03/17 15:21:47.089 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_13(65041)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2446200

      bind: '5021096776988184'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_14(9387)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_9(4130)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '19000006084155'

      bind: '70FF8A-19000008834382'

      bind: '3'

      bind: '1501741306'


      client: DBA@db02|broker1_cub_cas_1(51100)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_15(883)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.191 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_9(4130)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '19000006084155'

      bind: '70FF8A-19000008834382'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_14(9387)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_1(51100)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_15(883)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.192 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.300 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_14(9387)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_12(33353)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '19000006084155'

      bind: '70FF8A-19000008834382'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:21:47.300 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_8(47719)

      lock:    U_LOCK (oid=31|27851|51, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    blocker:

      client: DBA@db02|broker1_cub_cas_15(883)

      lock:    U_LOCK (oid=31|27851|51, table=ha_issue)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[is_cp_no]= ?:0  and [ha_issue].[is_pin]= ?:1 

      bind: '11000007148767'

      bind: '427F30-11000010590185'

      bind: '3'

      bind: '1501741306'


    08/03/17 15:43:57.597 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(55097)

      lock:   NX_LOCK (oid=-17062|19664|-32174, table=ha_use, index=pk)

      sql: update [ha_use] [ha_use] set [ha_use].[py_no]= ?:3  where (([ha_use].[us_no]= ?:0 ) or ([ha_use].[us_no]= ?:1 ) or ([ha_use].[us_no]= ?:2 ))

      bind: 8779883.00000000

      bind: 8779884.00000000

      bind: 8779885.00000000

      bind: 2473550


    blocker:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NS_LOCK (oid=-17062|19664|-32174, table=ha_use, index=pk)

      sql: ***EMPTY***


    08/03/17 16:01:05.884 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_1(51100)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2379459

      bind: '5022094776970344'

      bind: '3'

      bind: '1501743664'


    blocker:

      client: DBA@db02|broker1_cub_cas_7(51278)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


      client: DBA@db02|broker1_cub_cas_3(55097)

      lock: NULL_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2085373

      bind: '5022094776349447'

      bind: '3'

      bind: '1501743665'


    08/03/17 16:01:06.184 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_3(55097)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2085373

      bind: '5022094776349447'

      bind: '3'

      bind: '1501743665'


    blocker:

      client: DBA@db02|broker1_cub_cas_7(51278)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 16:13:32.876 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_5(37296)

      lock:   NS_LOCK (oid=-22172|310|16641, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_4(44603)

      lock:   NX_LOCK (oid=-22172|310|16641, table=ha_use, index=i_ha_use_pa_cp_code)

      sql: ***EMPTY***


    08/03/17 16:35:18.202 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: update [ha_issue] [ha_issue] set [ha_issue].[is_cond]= ?:2 , [ha_issue].[is_refund_date]= ?:3  where [ha_issue].[py_no]= ?:0  and [ha_issue].[is_barcode]= ?:1 

      bind: 2468007

      bind: '5021096776277555'

      bind: '3'

      bind: '1501745716'


    blocker:

      client: DBA@db02|broker1_cub_cas_4(58260)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    08/03/17 16:35:19.839 - LOCK_TIMEOUT

    waiter:

      client: DBA@db02|broker1_cub_cas_2(51208)

      lock:   NS_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    blocker:

      client: DBA@db02|broker1_cub_cas_4(58260)

      lock:   NX_LOCK (oid=-19902|100|-31743, table=ha_issue, index=i_ha_issue_is_cond)

      sql: ***EMPTY***


    댓글
List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 CUBRID 사용자를 위한 DBeaver 도구 출시 안내 admin 2024.04.23 31
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4457
3733 큐브리드 방화벽 관련해서 질문있습니다. 2 사블 2022.11.08 169
3732 큐브리드 매니저 -> 데이터베이스 복구 오류 문제 문의 3 file propolisCandy 2022.11.07 52
3731 큐부리드 함수 문의 2 file ozro 2022.11.07 115
3730 ADO.NET 에서 connection pool 사용 가능한가요? 1 시나브로 2022.11.04 33
3729 oracle_style_empty_string 설정 클라이언트 단에서 조회 2 hjeong 2022.11.04 54
3728 HA 이중화 구성 시에 master, slave 관련하여 질문 드립니다. 1 k1n9 2022.11.02 166
3727 ubuntu:20.04 cubrid 설치 문의 1 file green_auth 2022.11.01 89
3726 큐브리드에서 테이블 용량, 로우사이즈 검색방법 1 차솨 2022.10.28 543
3725 타 큐브리드 db에 insert 하려면.. 1 백수인 2022.10.28 116
3724 큐브리드 디렉토리 용량 문의 1 file 김상원 2022.10.28 74
3723 SQLGate 데이터 내보내기 오류 1 써늬니 2022.10.25 167
3722 스키마 내려받기 문의 3 ozro 2022.10.24 68
3721 저장프로시저 샘플 테스트 에러 Invalid call: it can not return ResultSet. 5 흔색늑대 2022.10.21 125
3720 쿼리 실행 성공 여부가 일정하지 않습니다. 2 ozro 2022.10.21 80
3719 같은 함수를 하나의 쿼리에서 두번 호출하면 에러발생 4 ozro 2022.10.21 78
3718 java 저장 함수를 생성하여 254자가 넘는 INPUT을 주었을 경우 OUTPUT이 NULL로 리턴되는 현상 발생 3 두목원슝 2022.10.21 82
3717 호스트 연결이 무한 로딩도네요 1 file 큐브리드사용자 2022.10.20 119
3716 HA환경 문의드립니다. 4 file 하얀미스 2022.10.19 96
3715 큐브리드 createStatement 질문드려요 2 차솨 2022.10.19 85
3714 cubrid_ha.conf 셋팅중 질문입니다. 2 하얀미스 2022.10.18 67
Board Pagination Prev 1 ... 9 10 11 12 13 14 15 16 17 18 ... 200 Next
/ 200

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com
Contact Sales

Site Map