티스토리

괴발개발

검색하기

블로그 홈

괴발개발

developer-minji.tistory.com/m

MJ.Lee 님의 블로그입니다.

구독자: 0

방명록 방문하기

주요 글 목록

TestCode 실행 시 liquibase에서 Table "DATABASECHANGELOG" already exists; SQL statement 에러 문제 Test Code를 돌릴 때 liquibase에서 아래와 같이 'DATABASECHANGELOG" already exists; SQL statement' 라는 에러가 났다. liquibase로 changelog 중 schema.xml을 만들 때 DATABASECHANGELOG라는 테이블을 포함하지 않았고, 생성된 schema.xml에도 create하는 부분이 없는데 DATABASECHANGELOG 생성을 시도하고 있었다. 원인 DATABASECHANGELOG는 liquibaes에서 사용하고 있는 테이블이고, 없으면 liquibase에서 자동으로 생성한다. liquibase에서 DATABASECHANGELOG 테이블을 만들 때, 테이블이 있는 지 없는 지 조사한다. 조사할 때 이미 존재했던 DATAB.. 공감수 0 댓글수 2 2024. 1. 26.
liquibase에서 changelog 중 data.xml 생성할 때, GC overhead limit exceeded 에러 문제 liquibase로 changelog 중 data.xml을 생성하려고 했는데, 빈 data.xml이 생성되었다. 로그를 확인하니, data.xml 생성 도중 아래와 같이 GC overhead limit exceeded 에러가 발생했다. 실행한 liquibase 쉘 스크립트는 아래와 같다. INCLUDE_OBJTECTS는 data.xml 파일을 만들 때 포함할 테이블 목록이 있고, 테이블 양이 33개 정도 되었다. JDBC_DRIVER_HOME=${HOME}/.m2/repository/mysql/mysql-connector-java JDBC_DRIVER_VERSION=8.0.12 CLASSPATH=${JDBC_DRIVER_HOME}/${JDBC_DRIVER_VERSION}/mysql-connector.. 공감수 0 댓글수 0 2024. 1. 26.
Test 코드에서 h2 database로 MySql 쿼리 실행 시 row_number에서 syntax 에러 문제 MySql 조회 Query에 row_number를 사용하는 필드를 추가하고, Test Code를 돌렸는데, 아래와 같은 에러가 났다. Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement JOOQ로 작성한 쿼리와 실행된 SQL 쿼리는 대략 아래와 같았다. JOOQ Field groupSeqField = DSL.rowNumber() .over(partitionBy(tProduct.GROUP_CD) .orderBy(tProduct.ID.asc())) .as("groupSeq"); dslContext.select( tProduct.ID, groupSeqField ) .from(tProduct) .fetchInto(Product.cl.. 공감수 0 댓글수 0 2024. 1. 25.
#155 International Commerce 2 Key Word hazard: a source of danger; chance, risk When it comes to investments, research shows that women are more likely to weigh up potential hazards than their male counterparts. weigh up: 가늠하다. 따지다 intuitive: readily learned or understood As we enter new markets, it is more important than ever to make our products intuitive, so that people across cultures find them natural to use. backlash: .. 공감수 0 댓글수 0 2024. 1. 15.
#154 International Commerce 1 Key Word window of opportunity: a brief time period in which an opportunity exists This year’s low-interest rate offered a window of opportunity to get easy credit and fund expansion. task force: a group of people working together to do a particular job, esp. to solve a problem The president’s task force was assigned to study the effect of higher tax rates on income mobility and federal revenue... 공감수 0 댓글수 0 2024. 1. 10.
Jenkins나 Spring Boot에서 Test 시, liquibase 외래키 참조 에러 문제 Test 코드를 돌리거나, Jenkins에서 Test를 실행할 때 data.xml 관련해서 아래와 같은 에러가 났다. product 테이블에 product_code컬럼에 '상품 코드' 값을 넣으려고 하는데, '상품 코드' 값이 product_code 테이블에 존재하지 않는다는 의미다. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/linecorp/ladb/oacms/sd/sync/config/LiquibaseConfiguration.class]: Invocation of init meth.. 공감수 0 댓글수 0 2024. 1. 10.
Jenkins에서 Failed to read schema document 'http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd' liquibase 에러 문제 generateChangelog를 돌려서 새로운 data.xml과 schema.xml을 생성해 적용하였다. Jenkins에서 Build 돌 때, 아래와 같이 liquibase 관련하여 Failed to read schema document 'http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd' 에러가 났다. 원인 liquibase의 xsd 파일로, data.xml과 schema.xml의 문법이 맞는지 검증한다. https://forum.liquibase.org/t/different-versions-of-dbchangelog-xsd-in-project/7775 로컬에 설치된 liquibase 4.25 버전으로 data.xml, sch.. 공감수 0 댓글수 0 2024. 1. 9.
liquibase의 changelog인 schema.xml과 data.xml을 생성해주는 ShellScript 만들기 liquibase changelog인 schema.xml과 data.xml을 생성하기 위해 아래와 같이 Shell Script를 만들 수 있다. Shell Script 만들기 liquibase로 schema.xml을 만드는 명령어는 아래와 같다. JDBC_DRIVER_HOME=${HOME}/.m2/repository/mysql/mysql-connector-java JDBC_DRIVER_VERSION=8.0.12 CLASSPATH=${JDBC_DRIVER_HOME}/${JDBC_DRIVER_VERSION}/mysql-connector-java-${JDBC_DRIVER_VERSION}.jar DRIVER=com.mysql.cj.jdbc.Driver URL="jdbc:mysql://database 호스트명:2.. 공감수 0 댓글수 0 2024. 1. 9.
#153 Strategic Analysis 2 Key Word hone: make more effective, intense, or sharp/accurate Our interviewing techniques have been honed in order to help us pick exactly the right candidate. out-of-touch: lacking knowledge or information concerning current events and developments We never want to be out-of-touch with the market, but we also want to be ahead of the curve. demise: (기업, 기관, 사상의) 종말 epitomize: 완벽한 보기이다. 전형적으로 보여.. 공감수 0 댓글수 0 2024. 1. 9.
터미널에서 liquibase 실행 시, zsh: command not found: liquibase 에러 문제 liquibase 명령어를 터미널에서 실행하려는데 zsh: command not found: liquibase 에러가 났다. liquibase를 설치하지 않아서 생긴 문제였다. 해결 아래 사이트에서 liquibase CLI를 MAC용으로 다운받아 설치해준다. https://www.liquibase.com/download?_ga=2.106278084.610293300.1704768692-1776201919.1704768691 Download Liquibase | Liquibase.com --> --> Join the millions of developers using Liquibase to version, track, and deploy database changes faster and safer. .. 공감수 0 댓글수 0 2024. 1. 9.
시스템 설계 청사진 완벽 가이드 공감수 0 댓글수 0 2024. 1. 9.
#152 Strategic Analysis 1 Key Word go around in circles: keep doing or talking about the same thing without achieving anything I need some more data to work on; otherwise, I am just going around in circles. childhood friend: 소꿉친구 kick-off meeting: gathering of interested parties to discuss a plan or strategy before launching a program or project. 회사 혹은 단체의 첫 공식적인 회의 The kick-off meeting involved both strengthening team t.. 공감수 0 댓글수 0 2024. 1. 8.
#151 Strategic Planning 2 Key Word savvy: having or showing perception, comprehension, or shrewdness especially in practical matters (실용적인) 지식, 상식, 요령, 실력있는 shrewdness: 약삭빠른 She has a lot of marketing savvy. pre-emptive: taking initiative; doing something first 선수치는, 선제의 The Treasury decided to raise interest rates as a pre-emptive measure against inflation. Treasury: 재무부, 금고 interest rates: 금리 downside: negative aspect;.. 공감수 0 댓글수 0 2024. 1. 4.
#150 Strategic Planning 1 Key Word drill down on the data: a capability that takes the user from a more general view of the data to a more specific one First, we need to collect data from our customers. Then to assess its value, we need to drill down on the data to find future sales opportunities. scale-up operations: expand in terms of market access, income, number of employees, etc To reach more customers and create a .. 공감수 0 댓글수 0 2024. 1. 4.
#149 Risk Management 2 Key Word fallout: the unpleasant results or effects of an action or event The fallout from the banking crisis has been global. avert: ward off; turn away or aside; blunt. 방지하다. 피하다. (위험, 말썽) 상황을 피하기 위해 구체적인 행동을 취하며 피하다 We tried to avert our thoughts from our massive financial problems. aftermath: something that results or follows from an event, especially one of a disastrous or unfortunate natur.. 공감수 0 댓글수 0 2024. 1. 4.
#148 Risk Management 1 Key Word winnow out: separate the useful or important people or things from the rest of a group. 옥석을 가려내다 To make a wise choice, it is best to start broad and winnow out the inferior options. anemic demand: low point in the sales of a particular product; signs of poor demand; 부족한 수요 A weak economy is characterized by anemic demand, among other factors. anemic: 빈혈의 I'm animic. 나 빈혈있어요. trade emba.. 공감수 0 댓글수 0 2023. 12. 27.
#147 Monitoring & Feedback 2 Key Word exude: (of a person) display (an emotion or quality) strongly and openly She exudes friendship and goodwill. gravitas: seriousness and importance of manner, causing feelings of respect and trust in others The new leader has an air of gravitas that commands respect. pitfall: an unexpected danger or difficulty He took financial advice on how to avoid the pitfalls of setting up your own bu.. 공감수 0 댓글수 0 2023. 12. 22.
#146 Monitoring & Feedback 1 Key Word common ground: an area of shared interests or opinions held by two or more people or groups. 공통점 When debating contentious issues, it is best to establish some common ground. contentious: 논쟁을 초래할 feed off the energy: gain strength, energy, or support from something. 긍정적인 에너지 뿐만 아니라 부정적인 에너지를 얻었을 때도 사용됨. People feed off the positive energy you give them. cut to the chase: get to the poin.. 공감수 0 댓글수 0 2023. 12. 21.
#145 Production Management 2 Key Word emulate: copy someone’s behavior or try to be like someone else because you admire or respect that person. 모방하다 unveil: reveal (그림, 동상 등을 처음으로 공개하기 위해) 덮개를 벗기다, (새로운 계획, 상품 등을) 발표하다. from time to time: 가끔, 이따금 We should not only emulate the best practices and products but unveil our own ideas from time to time. hobbled: be impeded or set at a disadvantage; constrained. 다리를 절뚝거리다. 방해하다. .. 공감수 0 댓글수 0 2023. 12. 18.
#144 Production Management 1 Key Word lean manufacturing: a methodology that focuses on minimizing waste within manufacturing systems while simultaneously maximizing productivity lean: 군살 없는 In the super-competitive future, lean manufacturing will make more sense and be more indispensable than ever. make more sense: it well be better to you than any other strategies. indispensable: 없어서는 안 될, 필수적인 sweep the globe: quickly sp.. 공감수 0 댓글수 0 2023. 12. 15.
#143 Budgeting 2 Key Word frugal: careful in spending money. 긍정적인 의미로 절약하는 Because our company is frugal, we have to recycle all paper and plastic items. tight-fisted: not willing to spend or give much money; miserly. 부정적인 의미로 인색한 The company’s tight- fisted owner will not raise the workers’ salaries. leverage: power, effectiveness; a resource that allows one to enact or perform; to use to advantage. 이익을 위해 이용하다.. 공감수 0 댓글수 0 2023. 12. 15.
#142 Budgeting 1 Key Word time and cost overruns: cost overruns is a cost that is more than the amount budgeted, while time overruns occur when projects or tasks is not completed by the time the project plan specifies overrun: (예정된 금액, 시간을) 초과하다 The longer an IT project is supposed to take, the more likely it is to encounter time and cost overruns. debt ceiling: the maximum amount that a government can borrow To.. 공감수 0 댓글수 0 2023. 12. 15.
#141 Stress Management 2 Key Word downtime: free time; personal time away from the office; a short break I cannot wait to have some quality downtime this weekend. clutter: a messy collection of things lying around. 잡동사니, 어수선함. (너무 많은 것을 어수선하게) 채우다. The basement work area is filled with creative clutter. Dialouge There are three types of conflict that can exist within an organization—the good, the bad, and the ugly. Good.. 공감수 0 댓글수 0 2023. 12. 15.
#140 Stress Management 1 Key Word clean slate: a person’s record that shows no evidence of any problems, or broken rules; a clean record. 청렴결백. 깨끗한 과거사. 어떤 기록도 없음 The newly elected president promised that with a clean slate he could start off fresh and not be limited by the previous administration. stride in technology: significant progress in technology The future envisioned in sci-fi novels and movies depends on consi.. 공감수 0 댓글수 0 2023. 12. 15.
Virus 공감수 0 댓글수 0 2023. 12. 12.
Oracle 실행 계획 보기. 개발 DB와 운영 DB의 쿼리 속도가 차이나는 이유 문제 동일한 쿼리를 개발 DB와 운영 DB에 실행했는데, 쿼리의 실행 속도가 개발은 10초, 운영은 0.1초 나왔다. 원인을 찾기 위해 개발 DB와 운영 DB에서 실행계획을 살펴보기로 했다. 원인 개발 DB에서 Data Grip으로 실행 계획 보기 개발 DB는 Data Grip이라는 DB프로그램을 사용하는데, 마우스 오른쪽을 클릭하고, Explain Plan이나 Explain Plan (Raw)를 클릭하면 콘솔창에 실행계획이 출력된다. 아래는 Explain Plan (Raw)를 선택했을 때 콘솔창에 나온 결과이다. 모자이크 된 부분은 사용한 인덱스 키가 나온다. Operation에 Index Fast Full Scan과 Rows가 2449, 2668로 나온 것을 보아 개발 DB에서는 Full Scan이 .. 공감수 0 댓글수 0 2023. 12. 11.
#139 Leadership & Management Style 2 Key Word audacious: showing an unusual willingness to take risks 대담한 I think that we should make some audacious moves to reverse this downward spiral. gutsy: having or showing courage, determination and spirit That was a very gutsy decision. shrewd: able to judge a situation accurately and turn it to your own advantage. 빨리 상황 판단하여 자기 잇속을 챙김. 부정적으로 쓰임. Jack is a shrewd and realistic businessman. .. 공감수 0 댓글수 0 2023. 12. 1.
#138 Leadership & Management Style 1 Key Word buy out: buy a part of a company or building from someone else so that you own all of it. (타입·권리 등을) 매수하다. To become an even bigger company, we decided to buy out our rival by purchasing all their public stock. front office: the divisions of a business or organization that deals with customers or the public, such as the sales or marketing divisions. (사업체의) 경영 본부[대고객 부서] As a salesman, I.. 공감수 0 댓글수 0 2023. 11. 23.
#137 Time Management 2 Key Word consolidate: bring together or unite things that were separate Our offices had been spread among three buildings, and then we consolidated into one new high-rise. contingency: something that might happen in the future Most large businesses have cash reserves as a contingency for bad debts. tardy: occurring, arriving, acting, or done after the scheduled, expected, or usual time; late. Ou.. 공감수 0 댓글수 0 2023. 11. 23.
#136 Time Management 1 Key Word spot: 발견하다 Whenever I spot repetitive and iterative tasks, I set up an automated process. crunch time: a point at which something difficult must be done Crunch time is often called do-or-die time; the job must get done contingency plan: a plan that is made for dealing with an emergency, or with something that might possibly happen and cause problems in the future. 위기상황에 대처하기 위해 미리 준비하는 .. 공감수 0 댓글수 0 2023. 11. 20.

문의안내

티스토리
로그인
고객센터

티스토리는 카카오에서 사랑을 담아 만듭니다.