mysql协议学习(四)--ERR报文

╰半夏微凉° 2022-08-03 12:51 170阅读 0赞

##### Payload #####

<table style="font-size:14px; border-collapse:collapse; margin-top:10px; margin-bottom:10px; color:rgb(0,0,0); font-family:Helvetica,Arial,sans-serif"> 
 <thead style="background-color:inherit"> 
  <tr style="background-color:inherit"> 
   <th style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px"> Type</th> 
   <th style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px"> Name</th> 
   <th style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px"> Description</th> 
  </tr> 
 </thead> 
 <tbody style="background-color:inherit"> 
  <tr style="background-color:inherit"> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <a href="http://dev.mysql.com/doc/internals/en/describing-packets.html#type-1" style="background-color:inherit; color:rgb(1,90,132); font-size:13.3000001907349px" rel="nofollow"><span style="background-color:inherit; font-family:'Courier New',Courier,fixed,monospace; font-size:12.6349992752075px">int&lt;1&gt;</span></a></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <span style="background-color:inherit; font-size:13.3000001907349px"><strong><code style="font-family:'Courier New',Courier,fixed,monospace; font-style:normal; color:rgb(14,64,117); font-size:12.6349992752075px; font-weight:normal">header</code></strong></span></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <code style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(2,103,137); font-size:12.6349992752075px; font-weight:bold">[ff]</code>&nbsp;header of the ERR packet</td> 
  </tr> 
  <tr style="background-color:inherit"> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <a href="http://dev.mysql.com/doc/internals/en/describing-packets.html#type-2" style="background-color:inherit; color:rgb(1,90,132); font-size:13.3000001907349px" rel="nofollow"><span style="background-color:inherit; font-family:'Courier New',Courier,fixed,monospace; font-size:12.6349992752075px">int&lt;2&gt;</span></a></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <span style="background-color:inherit; font-size:13.3000001907349px"><strong><code style="font-family:'Courier New',Courier,fixed,monospace; font-style:normal; color:rgb(14,64,117); font-size:12.6349992752075px; font-weight:normal">error_code</code></strong></span></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> error-code</td> 
  </tr> 
  <tr style="background-color:inherit"> 
   <td colspan="3" style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <code style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(14,64,117); font-size:12.6349992752075px">if capabilities &amp;&nbsp;<a href="http://dev.mysql.com/doc/internals/en/capability-flags.html#flag-CLIENT_PROTOCOL_41" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">CLIENT_PROTOCOL_41</a>&nbsp;{ </code></td> 
  </tr> 
  <tr style="background-color:inherit"> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <code style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(14,64,117); font-size:12.6349992752075px">&nbsp;&nbsp;<a href="http://dev.mysql.com/doc/internals/en/describing-packets.html#type-string.fix_len" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">string[1]</a></code></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <span style="background-color:inherit; font-size:13.3000001907349px"><strong><code style="font-family:'Courier New',Courier,fixed,monospace; font-style:normal; color:rgb(14,64,117); font-size:12.6349992752075px; font-weight:normal">sql_state_marker</code></strong></span></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <code style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(2,103,137); font-size:12.6349992752075px; font-weight:bold">#</code>&nbsp;marker of the SQL State</td> 
  </tr> 
  <tr style="background-color:inherit"> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <code style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(14,64,117); font-size:12.6349992752075px">&nbsp;&nbsp;<a href="http://dev.mysql.com/doc/internals/en/describing-packets.html#type-string.fix_len" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">string[5]</a></code></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <span style="background-color:inherit; font-size:13.3000001907349px"><strong><code style="font-family:'Courier New',Courier,fixed,monospace; font-style:normal; color:rgb(14,64,117); font-size:12.6349992752075px; font-weight:normal">sql_state</code></strong></span></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> SQL State</td> 
  </tr> 
  <tr style="background-color:inherit"> 
   <td colspan="3" style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <code style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(14,64,117); font-size:12.6349992752075px">}</code></td> 
  </tr> 
  <tr style="background-color:inherit"> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <a href="http://dev.mysql.com/doc/internals/en/describing-packets.html#type-string.EOF" style="background-color:inherit; color:rgb(1,90,132); font-size:13.3000001907349px" rel="nofollow"><span style="background-color:inherit; font-family:'Courier New',Courier,fixed,monospace; font-size:12.6349992752075px">string&lt;EOF&gt;</span></a></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <span style="background-color:inherit; font-size:13.3000001907349px"><strong><code style="font-family:'Courier New',Courier,fixed,monospace; font-style:normal; color:rgb(14,64,117); font-size:12.6349992752075px; font-weight:normal">error_message</code></strong></span></td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> human readable error message</td> 
  </tr> 
 </tbody> 
</table>

当发送的命令出现错误的情况下，mysql server会返回ERR报文给mysql client

eg：

<table style="font-size:14px; border-collapse:collapse; margin-top:10px; margin-bottom:10px; color:rgb(0,0,0); font-family:Helvetica,Arial,sans-serif"> 
 <tbody style="background-color:inherit"> 
  <tr style="background-color:inherit"> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px"> <pre style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(161,82,15); font-size:12.6349992752075px; background-color:white"><a title="Protocol::Packet" href="http://dev.mysql.com/doc/internals/en/mysql-packet.html#packet-Protocol::Packet" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">17 00 00 01</a><a href="http://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html#cs-packet-err-header" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">ff</a><a href="http://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html#cs-packet-err-error-code" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">48 04</a><a href="http://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html#cs-packet-err-sqlstate-marker" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">23</a><a href="http://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html#cs-packet-err-sqlstate" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">48 59 30 30 30</a><a href="http://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html#cs-packet-err-message" style="background-color:inherit; color:rgb(1,90,132); font-size:12.6349992752075px" rel="nofollow">4e 6f 20
74 61 62 6c 65 73 20 75    73 65 64</a></pre> </td> 
   <td style="word-break:break-all; border:1px solid rgb(153,153,153); padding:5px 16px 5px 12px; min-height:25px; min-width:25px; height:25px; background-color:inherit; font-size:13.3000001907349px; width:172px"> <pre style="font-family:'Courier New',Courier,fixed,monospace; color:rgb(161,82,15); font-size:12.6349992752075px; background-color:white">.....H.#HY000No tables used</pre> </td> 
  </tr> 
 </tbody> 
</table>

packet data len = 24（0x17 0x00 0x00）

packet sequence\_id = 1 （0x01）

err packet 分析：

header = 0xff

error\_code = （0x48 0x04）

sql\_state\_marker = 0x23 （应该是"\#"这个字符串的byte值）

sql\_state = （0x48 0x59 0x30 0x30 0x30）

error\_message = 剩余的所有字节