커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
3-12 dbprac.py를 실행 후 mongoDB의 Collection을 확인했으나 아무런 데이터가 생성되지 않습니다.
undefined주차
북마크
김*식
댓글
4
추천
0
조회수
27
조회수
27
답변 완료

* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.


dbprac.py를 실행 후 강의 영상처럼 mongoDB의 Collection을 확인했으나 아무런 데이터가 생성되지 않았습니다.

터미널에는 에러 메시지가 출력되는 듯합니다.

스파르타 즉문즉답



스파르타 즉문즉답스파르타 즉문즉답





작성한 코드 및 에러 메세지


작성한 코드

from pymongo import MongoClient
client = MongoClient('mongodb+srv://sparta:test@cluster0.rlowhky.mongodb.net/?retryWrites=true&w=majority')
db = client.dbsparta


doc = {
    'name':'영수',
    'age':24
}
db.users.insert_one(doc)


실행 시 터미널 에러 메세지

Traceback (most recent call last):
  File "c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py", line 9, in <module>
    db.users.insert_one(doc)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Users\PSY\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 644e6e3b20b87d09ba52f134, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>]>


PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
  File "c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py", line 9, in <module>
    db.users.insert_one(doc)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Users\PSY\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] 
certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 644e6f01a52565ec522591fc, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>]>


PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
  File "c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py", line 9, in <module>
    db.users.insert_one(doc)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Users\PSY\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verifyfy failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAIL] ED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERCATIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124), Timeout: 30s, Topology Description: <TyDopologyDescription id: 644e6f8c85bc1b768022fbc3, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-wvzvflf-shard-00-00.rlowodhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFIC_FATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00mo-01.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: RI
CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-hkshard-00-02.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017E_: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>]>


PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$ c:/Users/PSY/Desktop/sparta/pythonprac/venv/Scripts/python.exe c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py
Traceback (most recent call last):
  File "c:/Users/PSY/Desktop/sparta/pythonprac/dbprac.py", line 9, in <module>
    db.users.insert_one(doc)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 628, in insert_one
    self._insert_one(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Users\PSY\AppData\Local\Programs\Python\Python38\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 538, in _check_implicit_session_support       
    self._check_session_support()
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "C:\Users\PSY\Desktop\sparta\pythonprac\venv\lib\site-packages\pymongo\topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124),ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124), Timeout: 30s, Topology Description: <TopologyDescription id: 644e6fb480a22832bfac508d, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-00.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-01.rlowhky.mongodb.net:27017: [SSL: 
CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>, <ServerDescription ('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-wvzvflf-shard-00-02.rlowhky.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1124)')>]>


PSY@DESKTOP-REFT2HS MINGW64 ~/Desktop/sparta/pythonprac
$

오류 발생 시, 작성한 코드 전체와 에러 메시지를 첨부해 주세요.

Tip 1) </> 아이콘을 눌러 코드박스를 만들어 보세요.

Tip 2) Ctrl+A(맥의 경우 Command+A) 단축키로 코드를 한 번에 선택할 수 있어요!




취소
 공유
취소
댓글 0
댓글 알림
나의얼굴