Skip to content

Instantly share code, notes, and snippets.

@ssharan27
Last active July 24, 2023 14:06
Show Gist options
  • Save ssharan27/01b534f6b160fa226874a092c2cf8f27 to your computer and use it in GitHub Desktop.
Save ssharan27/01b534f6b160fa226874a092c2cf8f27 to your computer and use it in GitHub Desktop.
debug logs for r2dbc mysql for correct response when converter removed
2023-07-21T14:58:09.674+05:30 INFO 36718 --- [ main] com.example.Main : Started Main in 1.993 seconds (process running for 2.191)
2023-07-21T14:58:09.675+05:30 DEBUG 36718 --- [ main] o.s.b.a.ApplicationAvailabilityBean : Application availability state LivenessState changed to CORRECT
2023-07-21T14:58:09.676+05:30 DEBUG 36718 --- [ main] o.s.b.a.ApplicationAvailabilityBean : Application availability state ReadinessState changed to ACCEPTING_TRAFFIC
2023-07-21T14:58:23.852+05:30 INFO 36718 --- [nio-9090-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring DispatcherServlet 'dispatcherServlet'
2023-07-21T14:58:23.852+05:30 INFO 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
2023-07-21T14:58:23.852+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Detected StandardServletMultipartResolver
2023-07-21T14:58:23.852+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Detected AcceptHeaderLocaleResolver
2023-07-21T14:58:23.852+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Detected FixedThemeResolver
2023-07-21T14:58:23.852+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Detected org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator@28055ced
2023-07-21T14:58:23.853+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Detected org.springframework.web.servlet.support.SessionFlashMapManager@407dba2
2023-07-21T14:58:23.853+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : enableLoggingRequestDetails='false': request parameters and headers will be masked to prevent unsafe logging of potentially sensitive data
2023-07-21T14:58:23.853+05:30 INFO 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 1 ms
2023-07-21T14:58:23.856+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : GET "/articles", parameters={}
2023-07-21T14:58:23.865+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.w.s.f.support.RouterFunctionMapping : Mapped to com.example.router.TestRouter$$Lambda$1000/0x000000080143ddc0@15b9e82b
2023-07-21T14:58:23.886+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.w.c.request.async.WebAsyncManager : Started async request
2023-07-21T14:58:23.894+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.r2dbc.core.DefaultDatabaseClient : Executing SQL statement [SELECT articles.* FROM articles WHERE articles.views > ?]
2023-07-21T14:58:23.894+05:30 DEBUG 36718 --- [nio-9090-exec-1] io.asyncer.r2dbc.mysql.MySqlConnection : Create a parametrized statement provided by text query
2023-07-21T14:58:23.897+05:30 DEBUG 36718 --- [nio-9090-exec-1] io.asyncer.r2dbc.mysql.QUERY : Executing format query: SELECT articles.* FROM articles WHERE articles.views > ?
2023-07-21T14:58:23.897+05:30 DEBUG 36718 --- [nio-9090-exec-1] i.a.r.mysql.client.ReactorNettyClient : Request: PreparedTextQueryMessage{sql=REDACTED}
2023-07-21T14:58:23.897+05:30 DEBUG 36718 --- [nio-9090-exec-1] o.s.web.servlet.DispatcherServlet : Exiting but response remains open for further handling
2023-07-21T14:58:23.901+05:30 TRACE 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : [id: 0xe615d25f, L:/127.0.0.1:33778 - R:localhost/127.0.0.1:3306] WRITE: 99B
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 17 03 03 00 5e 3b ec 4e 78 00 a5 18 7c 06 2c 3b |....^;.Nx...|.,;|
|00000010| 11 38 c0 b7 38 01 1c 36 b1 6c 63 47 54 bc 94 c4 |.8..8..6.lcGT...|
|00000020| e5 1e 8c b7 9b 52 6c 83 ce 7d c2 78 f2 a1 60 1a |.....Rl..}.x..`.|
|00000030| f2 dd 1a 75 7d 8b ab 42 aa 18 99 32 45 ae 5d 8d |...u}..B...2E.].|
|00000040| ae a6 f6 2b 49 99 3e 09 e1 96 ed 4a 0d f1 85 79 |...+I.>....J...y|
|00000050| 30 ad 97 0d 7d e8 e2 0a d5 82 59 9d c8 fb 98 38 |0...}.....Y....8|
|00000060| 9e 02 d8 |... |
+--------+-------------------------------------------------+----------------+
2023-07-21T14:58:23.901+05:30 TRACE 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : [id: 0xe615d25f, L:/127.0.0.1:33778 - R:localhost/127.0.0.1:3306] FLUSH
2023-07-21T14:58:23.901+05:30 TRACE 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : [id: 0xe615d25f, L:/127.0.0.1:33778 - R:localhost/127.0.0.1:3306] WRITE: 0B
2023-07-21T14:58:23.901+05:30 TRACE 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : [id: 0xe615d25f, L:/127.0.0.1:33778 - R:localhost/127.0.0.1:3306] FLUSH
2023-07-21T14:58:23.902+05:30 TRACE 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : [id: 0xe615d25f, L:/127.0.0.1:33778 - R:localhost/127.0.0.1:3306] READ: 378B
+-------------------------------------------------+
| 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+--------+-------------------------------------------------+----------------+
|00000000| 17 03 03 01 75 47 b7 5c 01 21 b6 87 b0 ba 74 a3 |....uG.\.!....t.|
|00000010| c2 7d 04 01 8d fc 81 53 02 cf 86 a2 7c ad d9 bf |.}.....S....|...|
|00000020| 4e 9f 21 c9 ec 42 80 e8 66 e5 dc a2 d1 3e 18 03 |N.!..B..f....>..|
|00000030| 83 aa 0d c8 24 c9 4f e7 73 95 58 1b a7 8b 8f 3e |....$.O.s.X....>|
|00000040| 3e 87 9b 2c e0 aa 50 ff 11 51 ab 7a fc 29 da 92 |>..,..P..Q.z.)..|
|00000050| 42 ce 91 a1 ff 40 89 56 d0 88 12 a9 35 08 25 d6 |B....@.V....5.%.|
|00000060| a8 a4 38 4a c1 f6 d4 cf 31 7d 2b 9f 5a fc 68 e2 |..8J....1}+.Z.h.|
|00000070| 51 4c e0 b6 6c 38 26 3c a2 6d a5 02 de b9 6a ac |QL..l8&<.m....j.|
|00000080| 9d ce d0 02 a9 bb 37 6d df 23 70 c6 d0 82 11 a2 |......7m.#p.....|
|00000090| 64 1b c7 33 52 07 f0 fc 87 5c 74 49 a9 48 d2 89 |d..3R....\tI.H..|
|000000a0| f0 cd f8 aa 51 0a 6f 90 8a 84 25 5a 13 73 55 bf |....Q.o...%Z.sU.|
|000000b0| 60 09 41 5f 42 4c d6 b0 f8 ee af 52 b5 d8 d9 49 |`.A_BL.....R...I|
|000000c0| 0a 30 bf c0 44 1c dd d3 1f bf a1 55 38 0b 95 fd |.0..D......U8...|
|000000d0| ae 5d 52 24 34 0e 52 ba 16 36 ec c2 ee d8 71 36 |.]R$4.R..6....q6|
|000000e0| 84 e7 a6 d1 8f dc c7 4f 77 25 92 5e df d8 bf 0b |.......Ow%.^....|
|000000f0| cd 81 71 35 31 4f 6c 08 e4 d8 c8 c7 42 5e fc 56 |..q51Ol.....B^.V|
|00000100| c4 58 28 99 15 ee 77 99 ed 31 57 3f 8a 7c a8 88 |.X(...w..1W?.|..|
|00000110| f1 35 f0 ce 2d 74 a6 9f ff 61 c2 b0 2a 6b 10 f1 |.5..-t...a..*k..|
|00000120| 7c f7 7a e2 ad 9d 42 dc da 6d 0a e2 d5 b7 dc 07 ||.z...B..m......|
|00000130| 2f d8 70 c5 b8 0a fb 76 49 3f 1b f6 a9 9c 3e 35 |/.p....vI?....>5|
|00000140| b8 32 f0 81 7b c6 af ec b2 b3 11 a5 8f d8 86 ae |.2..{...........|
|00000150| c9 e4 7f f3 ca 43 e5 af 04 f2 7d 7f 5c 66 2c e4 |.....C....}.\f,.|
|00000160| 42 3c 6a de c5 a7 0e 15 f4 c1 10 89 2d ea a2 f1 |B<j.........-...|
|00000170| b5 02 e9 19 23 f5 50 96 ba 6b |....#.P..k |
+--------+-------------------------------------------------+----------------+
2023-07-21T14:58:23.902+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec : Decode context change to DecodeContext-Result
2023-07-21T14:58:23.902+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] i.a.r.m.m.server.MetadataDecodeContext : Respond a metadata bundle by filled-up
2023-07-21T14:58:23.902+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : Response: SyntheticMetadataMessage{completed=false, messages=[DefinitionMetadataMessage{database='test', table='articles' (origin:'articles'), column='id' (origin:'id'), collationId=63, size=20, type=8, definition=ColumnDefinition<0x1, 0x3f>, decimals=0}, DefinitionMetadataMessage{database='test', table='articles' (origin:'articles'), column='name' (origin:'name'), collationId=45, size=1020, type=253, definition=ColumnDefinition<0x0, 0x2d>, decimals=0}, ...more 3 messages], eof=null}
2023-07-21T14:58:23.902+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : Response: RowMessage(encoded)
2023-07-21T14:58:23.911+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.MessageDuplexCodec : Decode context change to DecodeContext-Command
2023-07-21T14:58:23.911+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : Response: OkMessage{affectedRows=0, lastInsertId=0, serverStatuses=2, information=''}
2023-07-21T14:58:23.931+05:30 DEBUG 36718 --- [tor-tcp-epoll-2] o.s.w.c.request.async.WebAsyncManager : Async result set, dispatch to /articles
2023-07-21T14:58:23.932+05:30 TRACE 36718 --- [tor-tcp-epoll-2] i.a.r.mysql.client.ReactorNettyClient : [id: 0xe615d25f, L:/127.0.0.1:33778 - R:localhost/127.0.0.1:3306] READ COMPLETE
2023-07-21T14:58:23.934+05:30 DEBUG 36718 --- [nio-9090-exec-2] o.s.web.servlet.DispatcherServlet : "ASYNC" dispatch for GET "/articles", parameters={}
2023-07-21T14:58:23.935+05:30 DEBUG 36718 --- [nio-9090-exec-2] o.s.w.s.f.s.HandlerFunctionAdapter : Resume with async result []
2023-07-21T14:58:23.936+05:30 DEBUG 36718 --- [nio-9090-exec-2] o.s.web.servlet.DispatcherServlet : Exiting from "ASYNC" dispatch, status 200
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment