FORUM

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_secs	float	1.0	0.1
isolation_level	int	3	1	6
lock_escalation	int	100,000	5
lock_timeout	msec	-1(무제한)	0(대기안함)	INT_MAX
rollback_on_lock_escalation	bool	no

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

해당 파일에 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	51
공지	SQLGate for CUBRID 영구 무료 라이선스 제공	admin	2020.04.09	4458
3993	db에 저장되어 있는 CLOB 데이터의 위치가 어디로 저장되는지 확인하는 방법이 있을까요? 1	자바천재	2024.04.25	18
3992	큐브리드 서비스 시작이 안됩니다. 1	황남빵	2024.04.24	25
3991	큐브리드 JDBC 드라이버 XA문의 및 큐브리드 분산트랜잭션(XA) 지원 문의 1	몽키스패너	2024.04.24	24
3990	group_concat 변수 리턴 관련... 1	썬더기	2024.04.22	23
3989	기 DB에서 테이블 정보만 가져와서 다른 DB에 생성 1	바다소금	2024.04.22	18
3988	큐브리드 매니저 속도 문의 1	연동테스트용	2024.04.22	15
3987	cubrid count 속 2	kanin	2024.04.19	29
3986	cubrid 10.1 데이터 덮어쓰기 질문입니다. 4	ysk96	2024.04.18	60
3985	ACTION 명령어? 예약어? 1	투투투투기기	2024.04.17	20
3984	sql 구문 사용시 데이터 타입 decimal일 경우 1	투투투투기기	2024.04.11	30
3983	Regexp_count 4	SEO	2024.04.09	66
3982	큐브리드 메모리 오류 관련 질문 2	뚜벅뚜벅	2024.04.09	67
3981	큐브리드 실행이 안되는 이슈 1	최현욱	2024.04.09	42
3980	unloaddb & loaddb 관련 질문이 있습니다. 1	543534512	2024.04.06	46
3979	mac m1 다운로드 오류 1	혜주냉면	2024.04.05	42
3978	list 함수로 만든 sequence type을 varchar로 변환 문의 1	플레이어블	2024.04.04	36
3977	DECODE, CASE WHEN 사용법 문의 2	핑크팬더	2024.04.03	55
3976	schema 파일 loaddb - 스키마 정보 중복오류 문의 4	daay	2024.03.21	91
3975	object to string 4	네오랜덤	2024.03.20	69

Contact Cubrid

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

Contact Sales

FORUM

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

단축키

단축키

Contact Cubrid

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

Site Map