Background Image

FORUM

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

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

봉보로봉봉
조회 수 415 추천 수 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 50
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4458
1374 사용하던 view 가 갑자기 사라지는 현상 1 coolkkm 2017.11.13 162
1373 사이트 관리지 접속 시 오류 2 늘푸른거북이 2009.08.19 8757
1372 상위버전에서 백업받은 파일을 하위버전에서 복원하는 방법? 1 보요 2012.12.14 9201
1371 새로 설치한 서버 2대 (9.1) 모두 DB 생성이 안됩니다. 1 file reerror 2013.03.26 9380
1370 생성 스크립트에 대한 트리거 순서에 대하여 질문 드립니다. 5 제로미 2021.05.17 204
1369 생성된 db에 사용자와 스키마 추가하는 법(큐브리드매니저, csql 인터프리터 사용x) 9 도우너19 2022.02.15 430
1368 샤드 관련 문의 드립니다. 1 레오나르도 2020.12.28 99
1367 샤딩 관련 질문드립니다 5 secret 익명 2015.01.13 9
1366 서버 2003에서 큐브리드 실행 조건 4 file 추후격살 2013.07.29 7117
1365 서버 IP 변경후 브로커 작동 불능 5 secret 닉네임 없어유 2017.07.26 9
1364 서버 JVM path 관련 문의 2 secret 아코 2015.06.06 11
1363 서버 로그 관련하여 문의 드립니다. 1 CUCUCUCU 2018.10.23 250
1362 서버 메모리 교체 및 ha 상 데이터 삭제 절차 1 레피엘 2023.04.20 113
1361 서버 속도가 과도하게 느리네요 1 푸훗 2012.05.10 8705
1360 서버 연결중 연결 대기 시간이 초과하였습니다. 1 남자 2013.12.25 13931
1359 서버 재기동후 접속불가 1 joke7 2018.12.11 1199
1358 서버 조회 문제 (쿼리 rock) 2 file a4033 2018.04.10 658
1357 서버가 다운되는 이유가 뭘까요? 1 시나브로 2020.03.06 486
1356 서버내 cubrid_statdump_0000.dmp 파일 생성 문제 3 NOS 2020.06.16 355
1355 서버다운 문의 4 secret chocob 2014.11.24 13
Board Pagination Prev 1 ... 127 128 129 130 131 132 133 134 135 136 ... 200 Next
/ 200

Contact Cubrid

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

Site Map