큐브리드 마이그레이션 툴 이용중 계속 문제가 발생합니다

by wjdrmstn posted Aug 04, 2022


* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.

OS
LINUX
CUBRID Ver.
CUBRID 10.2
CUBRID TOOL Ver.
CUBRID Migration Toolkit 11.0
응용 환경(API)
 


* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.

 

에러 내용 및 재현 방법 재현 가능한 Source와 SQL
관련 테이블(인덱스, 키정보 포함) 정보 CUBRID 홈 디렉토리 아래 log 디렉토리 압축


-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
현재 큐브리드 마이그레이션 툴을 이용하여 csv 데이터를 집어넣고 있는데 계속 오류가 발생하고 있습니다

발생하는 오류는 다양하게 발생 중인데 그 오류가 어떻게 발생하는지 어떻게 처리하면 되는지 도무지 모르겠습니다.

 

현재 발생하는 오류는 아래와 같습니다

 

1.Cannot connect to a broker

ERROR 2022-08-04 09:04:35 com.cubrid.cubridmigration.ui.database.SchemaFetcherWithProgress$1.run(Unknown Source)
java.lang.RuntimeException: cubrid.jdbc.driver.CUBRIDException: Cannot connect to a broker[CAS INFO-10.175.72.162:33000,0],[SESSION-0],[URL-jdbc:cubrid:10.175.72.162:33000:pubc:pubcuser:********:?charset=UTF-8].
at com.cubrid.cubridmigration.core.dbmetadata.JDBCDBSchemaFetcherFacade.fetchSchema(Unknown Source)
at com.cubrid.cubridmigration.ui.database.SchemaFetcherWithProgress$1.run(Unknown Source)
Caused by: cubrid.jdbc.driver.CUBRIDException: Cannot connect to a broker[CAS INFO-10.175.72.162:33000,0],[SESSION-0],[URL-jdbc:cubrid:10.175.72.162:33000:pubc:pubcuser:********:?charset=UTF-8].
at java.io.DataInputStream.readInt(Unknown Source)
at cubrid.jdbc.jci.UTimedDataInputStream.readInt(UTimedDataInputStream.java:80)
at cubrid.jdbc.jci.UTimedDataInputStream.readInt(UTimedDataInputStream.java:92)
at cubrid.jdbc.net.BrokerHandler.connectBroker(BrokerHandler.java:67)
at cubrid.jdbc.jci.UConnection.reconnectWorker(UConnection.java:1932)
at cubrid.jdbc.jci.UConnection.reconnect(UConnection.java:2043)
at cubrid.jdbc.jci.UConnection.checkReconnect(UConnection.java:2226)
at cubrid.jdbc.jci.UConnection.tryConnect(UConnection.java:363)
at cubrid.jdbc.driver.CUBRIDDriver.connect(CUBRIDDriver.java:220)
at com.cubrid.cubridmigration.cubrid.CUBRIDDatabase$CubridConnHelper.createConnection(Unknown Source)
at com.cubrid.cubridmigration.core.connection.ConnParameters.createConnection(Unknown Source)

 

 

2.java.lang.IndexOutOfBoundsException: Index: 10, Size: 10
ERROR 2022-08-03 17:12:16 com.cubrid.cubridmigration.core.engine.MigrationEventHandler$EventHandlerRunnable.run(Unknown Source)
java.lang.IndexOutOfBoundsException: Index: 10, Size: 10
at java.util.ArrayList.rangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.imp.CSVImportTask.batchExecute(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.imp.CSVImportTask.execute(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.imp.CSVImportTask.executeImport(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.ImportDataTaskDecorator.executeImport(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.ImportTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

 

 

3.Request timed out
ERROR 2022-08-03 10:34:02 com.cubrid.cubridmigration.core.engine.MigrationEventHandler$EventHandlerRunnable.run(Unknown Source)
com.cubrid.cubridmigration.core.engine.exception.JDBCConnectErrorException: cubrid.jdbc.driver.CUBRIDException: Request timed out[CAS INFO-10.175.72.162:33000,0],[SESSION-0],[URL-jdbc:cubrid:10.175.72.162:33000:pubc:pubcuser:********:?charset=UTF-8].
at com.cubrid.cubridmigration.core.engine.JDBCConManager.getTargetConnection(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.imp.CSVImportTask.batchExecute(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.imp.CSVImportTask.execute(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.imp.CSVImportTask.executeImport(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.ImportDataTaskDecorator.executeImport(Unknown Source)
at com.cubrid.cubridmigration.core.engine.task.ImportTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

 

 

분명 큐브리드 브로커나 DB도 잘 돌고 있다가 저렇게 오류가 나면서 마이그레이션이 중단이 됩니다