๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
์ด์Šˆ๐Ÿ…/ํ•ด๊ฒฐ์™„๋ฃŒ

pymysql.err.InterfaceErrorpymysql.err.InterfaceError: (0, '')

by @ENFJ 2022. 3. 23.

์˜ค๋ฅ˜์ฝ”๋“œ

pymysql.err.InterfaceError

pymysql.err.InterfaceError: (0, '')


ํ•ด๊ฒฐ ๋ฒ•

conn.close()  ์ฝ”๋“œ๋ฅผ ์ฐพ์•„์„œ, ์ด๋ถ€๋ถ„์— ( ) ๋ฅผ ํ•œ๋ฒˆ๋” ํ•ด์ค€๋‹ค.

 

interfacerror ์˜ ์›์ธ์€ ๋ฌธ์„ ๋‹ซ์ง€ ์•Š์•„์„œ ๋ฐœ์ƒํ•˜๋Š” ์—๋Ÿฌ์ด๊ธฐ๋„ ํ•œ๋‹ค๊ณ  ํ•จ.

๊ทธ๋ž˜์„œ, connection leak ๋ผ๊ณ  ๋ถ€๋ฅธ๋‹ค.

 

๊ทธ๋ ‡๋‹ค๋ฉด connection leak  ๋Œ€์‘ ๋ฐฉ์•ˆ์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋ฉด ์˜ˆ์™ธ ์ฒ˜๋ฆฌ์—์„œ ๊ฐ•์ œ๋กœ ๋‹ซ๋„๋ก

(conn.close())๋ฅผ ํ•ด์ฃผ๋ฉด ๋œ๋‹ค๊ณ  ํ•จ.

 

 

 

 


 

์ถœ์ฒ˜

https://hiwony.tistory.com/entry/Dev-log-python-pymysqlerrInterfaceError-0

http://pythonstudy.xyz/python/article/202-MySQL-%EC%BF%BC%EB%A6%AC