MySQL の接続エラーと8.0.24

.Z42-ͷ઀ଓΤϥʔͱ .Z42-ϦϦʔεϊʔτͰΘ͍Θ͍ݴ͏ษڧձ 'SJ !NJUB

.Z42-ͷ઀ଓΤϥʔ w %#΁ͷ઀ଓ͕ԿΒ͔ͷݪҼͰ੾Εͯ͠·ͬͨέʔε w ୅දతͳΤϥʔϝοηʔδʣ   &3303 ): .Z42-TFSWFSIBTHPOFBXBZ  
&3303 ): -PTUDPOOFDUJPOUP.Z42-TFSWFSEVSJOHRVFSZ

ݪҼͷಛఆ͕೉͍͠ʜ w ొ৔ਓ෺͕ଟ͍ w /8εΠονɺ'8ɺϩʔυόϥϯαFUD w Τϥʔϝοηʔδ͕Θ͔Γʹ͍͘

Τϥʔϝοηʔδ w NZTRME͕མͪͨ w ʢԿͰ͠ΐ͏ʣ w XBJU@UJNFPVUͰλΠϜΞ΢τ w ʢԿͰ͠ΐ͏ʣ w
NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w ʢԿͰ͠ΐ͏ʣ

Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w
ʢԿͰ͠ΐ͏ʣ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w ʢԿͰ͠ΐ͏ʣ

&3303 ): .Z42-TFSWFSIBTHPOFBXBZ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w ʢԿͰ͠ΐ͏ʣ

&3303 ): .Z42-TFSWFSIBTHPOFBXBZ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ

ҟͳΔݪҼͳͷʹಉ͡Τϥʔ ϝοηʔδ͕ฦΔ

ҟͳΔݪҼͳͷʹಉ͡Τϥʔϝοηʔδ͕ฦΔ w +%#$ͳΜͰ΋͔ΜͰ΋ɺDPNNVOJDBUJPOMJOLGBJMVSF w ʢ$POOFDUPS+WFSTJPOͰ͸վળ͞Ε͍ͯΔ͔΋͠Ε·ͤΜʣ w ࢀߟʣ%JWFJOUP.Z42-&SSPS!ZPLV   IUUQTTQFBLFSEFDLDPNZPLVEJWFJOUPNZTRMFSSPSZBQDUPLZPCB[JZPO

ಉ͡ݪҼͰҟͳΔΤϥʔ͕ฦΔ w ͖ͬ͞ͱٯύλʔϯ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ $ for i in 1
2 3 4 5; do mysql -ur -h127.0.0.1 malw < ins600.dmp; don e ERROR 2006 (HY000) at line 1: MySQL server has gone awa y ERROR 2006 (HY000) at line 1: MySQL server has gone awa y ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' byte s ERROR 2006 (HY000) at line 1: MySQL server has gone awa y ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes

ิ଍ w αʔόαΠυͷΤϥʔϩάͱরΒ͠߹ΘͤΕ͹ɺൺֱత੾Γ෼͚͸ͭ͘ w XBJU@UJNFPVU w 5IFXBJU@UJNFPVUQFSJPEXBTFYDFFEFE UIFJEMFUJNFTJODFMBTUDPNNBOEXBTUPPMPOH w NBY@BMMPXFE@QBDLFU
w "CPSUFEDPOOFDUJPOUPECTCUFTUVTFSTZTCFIPTUMPDBMIPTU   (PUBQBDLFUCJHHFSUIBONBY@BMMPXFE@QBDLFUCZUFT

w XBJU@UJNFPVUͰ੾ΒΕͨ͜ͱ͕Θ͔Δ👏 w XBJU@UJNFPVU w ௕࣌ؒɺԿ΋ϦΫΤετ͠ͳ͍ͱɺαʔό͕ίωΫγϣϯΛ੾Δ ͷվળ mysql> select now()
; ERROR 4031 (HY000): The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior . No connection. Trying to reconnect.. . Connection id: 1 4 Current database: *** NONE ***

ΫϥΠΞϯτ΋ཁ w .Z42-DMJFOU .Z42-TFSWFS w ˠ&3303 ): 5IFDMJFOUXBTEJTDPOOFDUFECZUIFTFSWFSCFDBVTFPGJOBDUJWJUZ w .Z42-DMJFOU
.Z42-TFSWFS w ˠ&3303 ): -PTUDPOOFDUJPOUP.Z42-TFSWFSEVSJOHRVFSZ w .Z42-DMJFOU .Z42-TFSWFS w ˠ&3303 ): -PTUDPOOFDUJPOUP.Z42-TFSWFSEVSJOHRVFSZ

·ͱΊ w .Z42-ͰXBJU@UJNFPVUىҼͷ઀ଓΤϥʔ͔Ͳ͏͔   ൑ఆ͠΍͘͢ͳͬͨΑʂ

͓͠·͍

MySQL の接続エラーと8.0.24

MySQL の接続エラーと8.0.24

Satoshi MITANI

More Decks by Satoshi MITANI

Other Decks in Technology

Featured

Transcript

.Z42-ͷ઀ଓΤϥʔͱ .Z42-ϦϦʔεϊʔτͰΘ͍Θ͍ݴ͏ษڧձ 'SJ !NJUB

.Z42-ͷ઀ଓΤϥʔ w %#΁ͷ઀ଓ͕ԿΒ͔ͷݪҼͰ੾Εͯ͠·ͬͨέʔε w ୅දతͳΤϥʔϝοηʔδʣ   &3303 ): .Z42-TFSWFSIBTHPOFBXBZ

ݪҼͷಛఆ͕೉͍͠ʜ w ొ৔ਓ෺͕ଟ͍ w /8εΠονɺ'8ɺϩʔυόϥϯαFUD w Τϥʔϝοηʔδ͕Θ͔Γʹ͍͘

ݪҼͷಛఆ͕೉͍͠ʜ w ొ৔ਓ෺͕ଟ͍ w /8εΠονɺ'8ɺϩʔυόϥϯαFUD w Τϥʔϝοηʔδ͕Θ͔Γʹ͍͘

Τϥʔϝοηʔδ w NZTRME͕མͪͨ w ʢԿͰ͠ΐ͏ʣ w XBJU@UJNFPVUͰλΠϜΞ΢τ w ʢԿͰ͠ΐ͏ʣ w

Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w

Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w

Τϥʔϝοηʔδ w NZTRME͕མͪͨ w &3303 ): .Z42-TFSWFSIBTHPOFBXBZ w XBJU@UJNFPVUͰλΠϜΞ΢τ w

ҟͳΔݪҼͳͷʹಉ͡Τϥʔ ϝοηʔδ͕ฦΔ

ҟͳΔݪҼͳͷʹಉ͡Τϥʔϝοηʔδ͕ฦΔ w +%#$ͳΜͰ΋͔ΜͰ΋ɺDPNNVOJDBUJPOMJOLGBJMVSF w ʢ$POOFDUPS+WFSTJPOͰ͸վળ͞Ε͍ͯΔ͔΋͠Ε·ͤΜʣ w ࢀߟʣ%JWFJOUP.Z42-&SSPS!ZPLV   IUUQTTQFBLFSEFDLDPNZPLVEJWFJOUPNZTRMFSSPSZBQDUPLZPCB[JZPO

ಉ͡ݪҼͰҟͳΔΤϥʔ͕ฦΔ w ͖ͬ͞ͱٯύλʔϯ w NBY@BMMPXFE@QBDLFUͷ੍ݶ౸ୡ $ for i in 1

ิ଍ w αʔόαΠυͷΤϥʔϩάͱরΒ͠߹ΘͤΕ͹ɺൺֱత੾Γ෼͚͸ͭ͘ w XBJU@UJNFPVU w 5IFXBJU@UJNFPVUQFSJPEXBTFYDFFEFE UIFJEMFUJNFTJODFMBTUDPNNBOEXBTUPPMPOH w NBY@BMMPXFE@QBDLFU

.Z42-

w XBJU@UJNFPVUͰ੾ΒΕͨ͜ͱ͕Θ͔Δ👏 w XBJU@UJNFPVU w ௕࣌ؒɺԿ΋ϦΫΤετ͠ͳ͍ͱɺαʔό͕ίωΫγϣϯΛ੾Δ ͷվળ mysql> select now()

ΫϥΠΞϯτ΋ཁ w .Z42-DMJFOU .Z42-TFSWFS w ˠ&3303 ): 5IFDMJFOUXBTEJTDPOOFDUFECZUIFTFSWFSCFDBVTFPGJOBDUJWJUZ w .Z42-DMJFOU

·ͱΊ w .Z42-ͰXBJU@UJNFPVUىҼͷ઀ଓΤϥʔ͔Ͳ͏͔   ൑ఆ͠΍͘͢ͳͬͨΑʂ

͓͠·͍