반응형

504 Gateway Timeout 서버 에러 응답 코드는 서버가
게이트웨이(gateway) 혹은 프록시(proxy)의 역할을 하는 동안 시간 안에 업스트림 서버(upstream server)로부터 요청을 마치기 위해 필요한 응답를 받지 못 했음
https://blog.lael.be/post/9251 - 설정좋음

Access to fetch at 'http://qt2-kic.channel.lgtvcommon.com/api/region/Global/status/S/update' from origin 'http://localhost:3000' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled.
https://stackoverflow.com/questions/22665232/what-can-cause-chrome-to-give-an-neterr-failed-on-cached-content-against-a-ser
https://developer.mozilla.org/ko/docs/Web/HTTP/CORS

2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> POST /api/region/Global/status/S/update
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> host: dev.channel.lgtvcommon.com
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> accept: /
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> accept-encoding: gzip, deflate, br
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> accept-language: ko-KR,ko;q=0.9,en-US;q=0.8,en;q=0.7
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiIxIiwiaWF0IjoxNjEwNDk4NjA5LCJleHAiOjE2MTExMDM0MDl9.qqaJFk0-hysF8bMA1VxiWDB_f8d6rF_3N_lWHnJ3N8Z0D6ha7og994FoMf4r8N6bv4wGX-gKjPNlmfMAxpqiEQ
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> content-type: application/json
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> origin: https://dev.channel.lgtvcommon.com
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> referer: https://dev.channel.lgtvcommon.com/HOME-APP/tab
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> sec-fetch-dest: empty
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> sec-fetch-mode: cors
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> sec-fetch-site: same-origin
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> x-forwarded-for: 27.122.242.72
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> x-forwarded-port: 443
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> x-forwarded-proto: https
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> content-length: 0
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|> connection: keep-alive
2021-01-13 01:05:20.507 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|>
2021-01-13 01:05:20.512 [http-nio-8180-exec-10] INFO c.l.c.c.a.HomeAppAdminController - #updateAllByRegionAndStatus|currentUser=com.lge.cdp.security.UserPrincipal@20
2021-01-13 01:05:20.512 [http-nio-8180-exec-10] INFO c.l.c.c.a.HomeAppAdminController - #updateAllByRegionAndStatus|currentUser=com.lge.cdp.security.UserPrincipal@20
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< 200 OK
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Origin
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Access-Control-Request-Method
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Access-Control-Request-Headers
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Origin
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Access-Control-Request-Method
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Access-Control-Request-Headers
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Origin
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Access-Control-Request-Method
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Vary: Access-Control-Request-Headers
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< Access-Control-Allow-Origin: *
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|<
2021-01-13 01:07:07.461 [http-nio-8180-exec-10] INFO c.l.c.f.LoggingFilter - 10.150.35.221|< {"result":"ok"}

2021-01-12 07:40:02.502 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> POST /api/region/Global/status/S/update
2021-01-12 07:40:02.502 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> host: qt2-kic.channel.lgtvcommon.com
2021-01-12 07:40:02.502 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> accept: /
2021-01-12 07:40:02.502 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> accept-encoding: gzip, deflate
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> accept-language: ko-KR,ko;q=0.9,en-US;q=0.8,en;q=0.7
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiIxIiwiaWF0IjoxNjEwNDM2OTg3LCJleHAiOjE2MTEwNDE3ODd9.LCAurM4nLxlHQI0dqtPFlh2H-r8cRSuxN1ytpFsntr9CwInUfHqjCXW-J15GFwHpfaXJyr0F0O8ECHzMdSEnRw
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> content-type: application/json
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> origin: http://localhost:3000
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> referer: http://localhost:3000/
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> x-forwarded-for: 27.122.242.72
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> x-forwarded-port: 80
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> x-forwarded-proto: http
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> content-length: 0
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|> connection: keep-alive
2021-01-12 07:40:02.503 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|>
2021-01-12 07:40:02.507 [http-nio-8180-exec-9] INFO c.l.c.c.a.HomeAppAdminController - #updateAllByRegionAndStatus|currentUser=com.lge.cdp.security.UserPrincipal@20
2021-01-12 07:41:48.838 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< 200 OK
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Origin
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Access-Control-Request-Method
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Access-Control-Request-Headers
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Origin
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Access-Control-Request-Method
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Access-Control-Request-Headers
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Origin
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Access-Control-Request-Method
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Vary: Access-Control-Request-Headers
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< Access-Control-Allow-Origin: *
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|<
2021-01-12 07:41:48.839 [http-nio-8180-exec-9] INFO c.l.c.f.LoggingFilter - 10.150.32.229|< {"result":"ok"}

반응형
반응형

frontend server build 확인방법

  • npm run build (빌드결과물 생성됨)
  • npm install -g serve (serve 설치)
  • serve -s build (bash에서 실행해야함, 윈도우 터미널에서는 동작안함, 완료되면 localhost:5000에서 확인가능)

빌드완료되면 다음위치에 다음과 같은 결과물이 떨어짐
File sizes after gzip: 485.41 KB
build\static\js\2.f302d4b6.chunk.js 62.8 KB (-50 B)
build\static\js\main.42c20a87.chunk.js 53.73 KB
build\static\js\3.60c20971.chunk.js 39.12 KB
build\static\js\5.3a36e225.chunk.js 6.39 KB
build\static\js\4.f1151a7d.chunk.js 1.16 KB
build\static\js\runtime~main.39277503.js 283 B
build\static\css\main.3655cd5e.chunk.css

jss1 - max-whith:520px고정문제로 인해 로그인 첫화면 사이즈 작아짐, 원인은?

"@babel/runtime-corejs3": {
    "version": "7.9.6",
    "resolved": "https://registry.npmjs.org/@babel/runtime-corejs3/-/runtime-corejs3-7.9.6.tgz",
    "integrity": "sha512-6toWAfaALQjt3KMZQc6fABqZwUDDuWzz+cAfPhqyEnzxvdWOAkjwPNxgF8xlmo7OWLsSjaKjsskpKHRLaMArOA==",
    "dev": true, --->  이게원인인듯 
    "requires": {
        "core-js-pure": "^3.0.0",
        "regenerator-runtime": "^0.13.4"
    },
    "dependencies": {
        "regenerator-runtime": {
            "version": "0.13.5",
            "resolved": "https://registry.npmjs.org/regenerator-runtime/-/regenerator-runtime-0.13.5.tgz",
            "integrity": "sha512-ZS5w8CpKFinUzOwW3c83oPeVXoNsrLsaCoLtJvAClH135j/R77RuymhiSErhm2lKcwSCIpmvIWSbDkIfAqKQlA==",
            "dev": true --->  이게원인인듯 
        }
    }
},
반응형
반응형

mySQL Numeric Type 

최신 버젼 mysql에서는 bigint(20)으로 안나오고 bigint로 나온다

타입에 따라 자릿수는 정해지기 때문에 ()숫자는 의미가 없다고 한다

TINYINT(?)

SMALLINT(6)

MEDIUMINT(?)

INT(11)

BIGINT(20?)

 

반응형
반응형

 

content<padding<border<margin<position

box-sizing

  • content-box
  • border-box

height, maxHeight, lineHeight

display

  • block
  • inline
  • inline-block
  • none

position

  • static
  • relative
  • absolute
  • fixed

z-index

  •  

!important - overriding 하더라도 이 속성이 적용되도록, 중요하니까

----------------------------------------
level3 menu 들여쓰기 적용 
#snb .MuiList-root > li > ul > li > a {
  padding-left: 25->50px;
----------------------------------------
gnb statistics 메뉴 6개로 늘어날시 잘리는 문제
#header.is_active:after {
  height: 200->235px;

.sub_menu {
  height: 200->235px;
----------------------------------------
level2 level3 menu 사이 간격좁히기
#snb .MuiList-root>li>ul { #snb .MuiList-root>li>ul {
  padding: 15px 0->5px 0 15px 0;
}
----------------------------------------
material table 위 add버튼 right으로 이동하기
.btn_set_wrap.tbl_top1, .btn_set_wrap.tbl_top2{
left:0px; -> right:0px;
다음 2줄 추가 
.tbl_wrap > .tbl_top1 + .MuiPaper-root > .MuiToolbar-root .MuiTextField-root + div{width:120px;}
.tbl_wrap > .tbl_top2 + .MuiPaper-root > .MuiToolbar-root .MuiTextField-root + div{width:230px;} 
----------------------------------------
materialTable row backgroundColor 흰색고정
#root .MuiTable-root tbody td,
.pop_wrap .MuiTable-root tbody td {
  background: #ffffff;
----------------------------------------
??? material Table 내외부 버튼길이 문제 
.MuiButton-root.btn_size_tbl {
  width: 95px; -> 테이블 row별 버튼 %로 고치면 block으로 보여짐...

.btn_set_wrap_tbl {
  width: 100%;
  display: flex;
}
----------------------------------------
<TextField label="Select File" -> <TextField placeholder="Select File"


STATISTICS > Summary 등 메뉴에서 테이블 버튼위치 틀어지는 부분은 수정했습니다. 버튼눌렀을때 나오는 부분은 확인결과 정상적으로 나와서 따로 작업하지 않았습니다.

테이블 컬럼 고정의 경우 제가 설명드렸던 부분을 다 이해하지 못하신거 같습니다.

고정시켜주는 부분의 width값은 처음 테이블 생성시에 정해지는데 필터에서 선택하여 값을 변경시켜줄때 처음생성됐던 width값이 변경되어지지 않고 있습니다. 예를 들어 처음 생성된 width값이 1400이고 고정시킬 width값이 200이라면 1400에서부터 200만큼 들어간 위치를 고정시키게 됩니다. 근데 처음생성된 width값이 1400인데 변경된 테이블 안에 생성된 내용의 width값이 1600이라면 1400부터 1600까지의 영역은 안보이게 됩니다. 그리고 고정된영역도 1600에서 200만큼의 영역이 아닌 1400에서 200만큼의 영역이 보여지게 됩니다. 이부분은 수정이 어려운것으로 보여지기때문에 테이블 전체를 다시 그려달라고 요청드렸습니다.

반응형
반응형

alter table cdp.tb_rc_service_base modify biz_area varchar(500) NOT NULL;

실행시 Error Code: 1138. Invalid use of NULL value 발생.

not null column에 이미 null이 들어가있어 문제됨, null이 되지 않도록 update하거나

alter table cdp.tb_rc_service_base modify biz_area varchar(500) NOT NULL default ''; 수행하면됨 

반응형

'db' 카테고리의 다른 글

mysql remote 접속허용  (0) 2022.04.14
mysql numeric type  (0) 2020.11.05
mysql workbench timeout 설정 (Lost connection to MySQL server during query)  (0) 2020.05.25
mysql lock  (0) 2020.05.25
mysql data migration  (0) 2020.05.21
반응형

Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600으로 늘임

반응형

'db' 카테고리의 다른 글

mysql numeric type  (0) 2020.11.05
mysql error - Invalid use of NULL value (이미 null들어간 column not null로 만들때 에러)  (0) 2020.05.25
mysql lock  (0) 2020.05.25
mysql data migration  (0) 2020.05.21
oracle VS mysql  (0) 2020.02.26
반응형

Error Code: 1205. Lock wait timeout exceeded 에러발생시

구글링해보니 보통 다음 2가지 해결책 제시됨

    1. lock timeout 시간을 늘려주라

workbench 기본 read time-out은 30초였는데 늘여도 소용없었음

 

    1. LOCK 테이블에 lock이 존재하는지 확인해보라

use information_schema;
select * from information_schema.INNODB_LOCKS;
select * from information_schema.INNODB_LOCK_WAITS;
select * from information_schema.INNODB_TRX; -- 오랜 시간 동안 Commit 되지 않은 transaction
show full processlist; -- 로 어떤 IP에서 접속했는지 등 정보확인
kill 423911;-- 의심(?)되는 것을 킬

 

참고) https://www.popit.kr/mysql-lock-%EC%83%81%ED%99%A9-%EB%AC%B8%EC%A0%9C-%ED%95%B4%EA%B2%B0/

반응형
반응형

? shell로 접근하려면 10060port사용해야 하는지?

Can't connect to MySQL server on 'rds-an2-richcdp-qa2-mysql.cjbyfjmv7vdu.ap-northeast-2.rds.amazonaws.com' (10060) when trying to connect


EXPORT

$mysqldump -uroot -p wordpess > dump160724.sql

(workbench통해 실행할 때 명령어) mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmpr46kpq.cnf" --user=cdp_mgr --host=rds-an2-richcdp-qa2-mysql.cjbyfjmv7vdu.ap-northeast-2.rds.amazonaws.com --protocol=tcp --port=3310 --default-character-set=utf8 --skip-triggers --skip-column-statistics "richcdp_kic_qa2" "tb_rc_user"

 

IMPORT

$mysqladmin -uroot -p create wordpress

$mysql -uroot -p wordpress < dump160724.sql

반응형

'db' 카테고리의 다른 글

mysql workbench timeout 설정 (Lost connection to MySQL server during query)  (0) 2020.05.25
mysql lock  (0) 2020.05.25
oracle VS mysql  (0) 2020.02.26
mysql query tip  (0) 2020.01.31
H2 DB 사용방법  (0) 2019.10.30
반응형

mainpage = <Redirect to="/dashboard" />;

mainpage=<meta http-equiv="refresh" content="0; url=/signin"/>;

window.location.href = '/signin';

mainpage = <Route path="/" component={Signin} />; re-render OK, not refresh

history.push('/PROGRAM/programlist');re-render ?, not refresh

 

import { Route, Redirect } from 'react-router-dom';

반응형

'js' 카테고리의 다른 글

CORS(Cross-Origin Resource Sharing)  (0) 2022.06.10
react-scripts build  (0) 2020.12.17
ES6(2015) - import/export  (0) 2020.03.24
eslint, prettier  (0) 2020.03.18
javascript timezone  (0) 2020.03.15
반응형

WAS

  • mvn spring-boot:run -Dspring-boot.run.profiles=local -> bash shell(git bash in Windows)에서만 작동하는듯
  • ./mvnw spring-boot:run -Dspring.profiles.active=local
  • SPRING_PROFILES_ACTIVE=local ./mvnw
  • 이게 안되면 mvn spring-boot:run으로 빌드후 배너만 나오고 이후 반응없음 

Jar

  • java -jar -Dspring.profiles.active=local xxx.jar(jar file path)
반응형

'java, spring' 카테고리의 다른 글

Java Web Application  (0) 2021.03.02
tomcat  (0) 2021.03.02
java time - Instant, LocalDate  (0) 2020.03.16
Lombok  (0) 2020.02.14
Log4j  (0) 2020.02.13

+ Recent posts