Thu Dec 13 09:35:58 PST 2018 TRACE: Last 39 packets received from server, from oldest->newest: Client com.mysql.jdbc.Buffer@2e817b38--------------------> Server Packet payload: 6b 03 00 00 03 2f 2a 20 k . . . . / * . 6d 79 73 71 6c 2d 63 6f m y s q l - c o 6e 6e 65 63 74 6f 72 2d n n e c t o r - 6a 61 76 61 2d 35 2e 31 j a v a - 5 . 1 2e 33 39 20 28 20 52 65 . 3 9 . ( . R e 76 69 73 69 6f 6e 3a 20 v i s i o n : . 33 32 38 39 61 33 35 37 3 2 8 9 a 3 5 7 61 66 36 64 30 39 65 63 a f 6 d 0 9 e c 63 31 61 31 30 66 64 33 c 1 a 1 0 f d 3 63 32 36 65 39 35 31 38 c 2 6 e 9 5 1 8 33 65 35 37 39 30 61 64 3 e 5 7 9 0 a d 20 29 20 2a 2f 53 45 4c . ) . * / S E L 45 43 54 20 20 40 40 73 E C T . . @ @ s 65 73 73 69 6f 6e 2e 61 e s s i o n . a 75 74 6f 5f 69 6e 63 72 u t o _ i n c r 65 6d 65 6e 74 5f 69 6e e m e n t _ i n 63 72 65 6d 65 6e 74 20 c r e m e n t . 41 53 20 61 75 74 6f 5f A S . a u t o _ 69 6e 63 72 65 6d 65 6e i n c r e m e n 74 5f 69 6e 63 72 65 6d t _ i n c r e m 65 6e 74 2c 20 40 40 63 e n t , . @ @ c 68 61 72 61 63 74 65 72 h a r a c t e r 5f 73 65 74 5f 63 6c 69 _ s e t _ c l i 65 6e 74 20 41 53 20 63 e n t . A S . c 68 61 72 61 63 74 65 72 h a r a c t e r 5f 73 65 74 5f 63 6c 69 _ s e t _ c l i 65 6e 74 2c 20 40 40 63 e n t , . @ @ c 68 61 72 61 63 74 65 72 h a r a c t e r 5f 73 65 74 5f 63 6f 6e _ s e t _ c o n 6e 65 63 74 69 6f 6e 20 n e c t i o n . 41 53 20 63 68 61 72 61 A S . c h a r a 63 74 65 72 5f 73 65 74 c t e r _ s e t 5f 63 6f 6e 6e 65 63 74 _ c o n n e c t 69 6f 6e 2c 20 40 40 63 i o n , . @ @ c 68 61 72 61 63 74 65 72 h a r a c t e r 5f 73 65 74 5f 72 65 73 _ s e t _ r e s 75 6c 74 73 20 41 53 20 u l t s . A S . 63 68 61 72 61 63 74 65 c h a r a c t e 72 5f 73 65 74 5f 72 65 r _ s e t _ r e 73 75 6c 74 73 2c 20 40 s u l t s , . @ 40 63 68 61 72 61 63 74 @ c h a r a c t 65 72 5f 73 65 74 5f 73 e r _ s e t _ s 65 72 76 65 72 20 41 53 e r v e r . A S 20 63 68 61 72 61 63 74 . c h a r a c t 65 72 5f 73 65 74 5f 73 e r _ s e t _ s 65 72 76 65 72 2c 20 40 e r v e r , . @ 40 69 6e 69 74 5f 63 6f @ i n i t _ c o 6e 6e 65 63 74 20 41 53 n n e c t . A S 20 69 6e 69 74 5f 63 6f . i n i t _ c o 6e 6e 65 63 74 2c 20 40 n n e c t , . @ 40 69 6e 74 65 72 61 63 @ i n t e r a c 74 69 76 65 5f 74 69 6d t i v e _ t i m 65 6f 75 74 20 41 53 20 e o u t . A S . 69 6e 74 65 72 61 63 74 i n t e r a c t 69 76 65 5f 74 69 6d 65 i v e _ t i m e 6f 75 74 2c 20 40 40 6c o u t , . @ @ l 69 63 65 6e 73 65 20 41 i c e n s e . A 53 20 6c 69 63 65 6e 73 S . l i c e n s 65 2c 20 40 40 6c 6f 77 e , . @ @ l o w 65 72 5f 63 61 73 65 5f e r _ c a s e _ 74 61 62 6c 65 5f 6e 61 t a b l e _ n a 6d 65 73 20 41 53 20 6c m e s . A S . l 6f 77 65 72 5f 63 61 73 o w e r _ c a s 65 5f 74 61 62 6c 65 5f e _ t a b l e _ 6e 61 6d 65 73 2c 20 40 n a m e s , . @ 40 6d 61 78 5f 61 6c 6c @ m a x _ a l l 6f 77 65 64 5f 70 61 63 o w e d _ p a c 6b 65 74 20 41 53 20 6d k e t . A S . m 61 78 5f 61 6c 6c 6f 77 a x _ a l l o w 65 64 5f 70 61 63 6b 65 e d _ p a c k e 74 2c 20 40 40 6e 65 74 t , . @ @ n e t 5f 62 75 66 66 65 72 5f _ b u f f e r _ 6c 65 6e 67 74 68 20 41 l e n g t h . A 53 20 6e 65 74 5f 62 75 S . n e t _ b u 66 66 65 72 5f 6c 65 6e f f e r _ l e n 67 74 68 2c 20 40 40 6e g t h , . @ @ n 65 74 5f 77 72 69 74 65 e t _ w r i t e 5f 74 69 6d 65 6f 75 74 _ t i m e o u t 20 41 53 20 6e 65 74 5f . A S . n e t _ 77 72 69 74 65 5f 74 69 w r i t e _ t i 6d 65 6f 75 74 2c 20 40 m e o u t , . @ 40 71 75 65 72 79 5f 63 @ q u e r y _ c 61 63 68 65 5f 73 69 7a a c h e _ s i z 65 20 41 53 20 71 75 65 e . A S . q u e 72 79 5f 63 61 63 68 65 r y _ c a c h e 5f 73 69 7a 65 2c 20 40 _ s i z e , . @ 40 71 75 65 72 79 5f 63 @ q u e r y _ c 61 63 68 65 5f 74 79 70 a c h e _ t y p 65 20 41 53 20 71 75 65 e . A S . q u e 72 79 5f 63 61 63 68 65 r y _ c a c h e 5f 74 79 70 65 2c 20 40 _ t y p e , . @ 40 73 71 6c 5f 6d 6f 64 @ s q l _ m o d 65 20 41 53 20 73 71 6c e . A S . s q l 5f 6d 6f 64 65 2c 20 40 _ m o d e , . @ 40 73 79 73 74 65 6d 5f @ s y s t e m _ 74 69 6d 65 5f 7a 6f 6e t i m e _ z o n 65 20 41 53 20 73 79 73 e . A S . s y s 74 65 6d 5f 74 69 6d 65 t e m _ t i m e 5f 7a 6f 6e 65 2c 20 40 _ z o n e , . @ 40 74 69 6d 65 5f 7a 6f @ t i m e _ z o 6e 65 20 41 53 20 74 69 n e . A S . t i 6d 65 5f 7a 6f 6e 65 2c m e _ z o n e , 20 40 40 74 78 5f 69 73 . @ @ t x _ i s 6f 6c 61 74 69 6f 6e 20 o l a t i o n . 41 53 20 74 78 5f 69 73 A S . t x _ i s 6f 6c 61 74 69 6f 6e 2c o l a t i o n , 20 40 40 77 61 69 74 5f . @ @ w a i t _ 74 69 6d 65 6f 75 74 20 t i m e o u t . 41 53 20 77 61 69 74 5f A S . w a i t _ 74 69 6d 65 6f 75 74 00 t i m e o u t . 00 00 00 00 . . . . Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 01 . Server (new) com.mysql.jdbc.Buffer@1a6c5a9e --------------------> Client Packet payload: 2e 00 00 02 03 64 65 66 . . . . . d e f 00 00 00 18 61 75 74 6f . . . . a u t o 5f 69 6e 63 72 65 6d 65 _ i n c r e m e 6e 74 5f 69 6e 63 72 65 n t _ i n c r e 6d 65 6e 74 00 0c 3f 00 m e n t . . ? . 15 00 00 00 08 a0 . . . . . . Server (new) com.mysql.jdbc.Buffer@254989ff --------------------> Client Packet payload: 2a 00 00 03 03 64 65 66 * . . . . d e f 00 00 00 14 63 68 61 72 . . . . c h a r 61 63 74 65 72 5f 73 65 a c t e r _ s e 74 5f 63 6c 69 65 6e 74 t _ c l i e n t 00 0c 21 00 0c 00 00 00 . . ! . . . . . fd 00 . . Server (new) com.mysql.jdbc.Buffer@5d099f62 --------------------> Client Packet payload: 2e 00 00 04 03 64 65 66 . . . . . d e f 00 00 00 18 63 68 61 72 . . . . c h a r 61 63 74 65 72 5f 73 65 a c t e r _ s e 74 5f 63 6f 6e 6e 65 63 t _ c o n n e c 74 69 6f 6e 00 0c 21 00 t i o n . . ! . 0c 00 00 00 fd 00 . . . . . . Server (new) com.mysql.jdbc.Buffer@37f8bb67 --------------------> Client Packet payload: 2b 00 00 05 03 64 65 66 + . . . . d e f 00 00 00 15 63 68 61 72 . . . . c h a r 61 63 74 65 72 5f 73 65 a c t e r _ s e 74 5f 72 65 73 75 6c 74 t _ r e s u l t 73 00 0c 21 00 0c 00 00 s . . ! . . . . 00 fd 00 . . . Server (new) com.mysql.jdbc.Buffer@49c2faae --------------------> Client Packet payload: 2a 00 00 06 03 64 65 66 * . . . . d e f 00 00 00 14 63 68 61 72 . . . . c h a r 61 63 74 65 72 5f 73 65 a c t e r _ s e 74 5f 73 65 72 76 65 72 t _ s e r v e r 00 0c 21 00 15 00 00 00 . . ! . . . . . fd 00 . . Server (new) com.mysql.jdbc.Buffer@20ad9418 --------------------> Client Packet payload: 22 00 00 07 03 64 65 66 " . . . . d e f 00 00 00 0c 69 6e 69 74 . . . . i n i t 5f 63 6f 6e 6e 65 63 74 _ c o n n e c t 00 0c 21 00 00 00 00 00 . . ! . . . . . fd 00 . . Server (new) com.mysql.jdbc.Buffer@31cefde0 --------------------> Client Packet payload: 29 00 00 08 03 64 65 66 ) . . . . d e f 00 00 00 13 69 6e 74 65 . . . . i n t e 72 61 63 74 69 76 65 5f r a c t i v e _ 74 69 6d 65 6f 75 74 00 t i m e o u t . 0c 3f 00 15 00 00 00 08 . ? . . . . . . a0 . Server (new) com.mysql.jdbc.Buffer@439f5b3d --------------------> Client Packet payload: 1d 00 00 09 03 64 65 66 . . . . . d e f 00 00 00 07 6c 69 63 65 . . . . l i c e 6e 73 65 00 0c 21 00 09 n s e . . ! . . 00 00 00 fd 00 . . . . . Server (new) com.mysql.jdbc.Buffer@1d56ce6a --------------------> Client Packet payload: 2c 00 00 0a 03 64 65 66 , . . . . d e f 00 00 00 16 6c 6f 77 65 . . . . l o w e 72 5f 63 61 73 65 5f 74 r _ c a s e _ t 61 62 6c 65 5f 6e 61 6d a b l e _ n a m 65 73 00 0c 3f 00 15 00 e s . . ? . . . 00 00 08 a0 . . . . Server (new) com.mysql.jdbc.Buffer@5197848c --------------------> Client Packet payload: 28 00 00 0b 03 64 65 66 ( . . . . d e f 00 00 00 12 6d 61 78 5f . . . . m a x _ 61 6c 6c 6f 77 65 64 5f a l l o w e d _ 70 61 63 6b 65 74 00 0c p a c k e t . . 3f 00 15 00 00 00 08 a0 ? . . . . . . . Server (new) com.mysql.jdbc.Buffer@17f052a3 --------------------> Client Packet payload: 27 00 00 0c 03 64 65 66 ' . . . . d e f 00 00 00 11 6e 65 74 5f . . . . n e t _ 62 75 66 66 65 72 5f 6c b u f f e r _ l 65 6e 67 74 68 00 0c 3f e n g t h . . ? 00 15 00 00 00 08 a0 . . . . . . . Server (new) com.mysql.jdbc.Buffer@2e0fa5d3 --------------------> Client Packet payload: 27 00 00 0d 03 64 65 66 ' . . . . d e f 00 00 00 11 6e 65 74 5f . . . . n e t _ 77 72 69 74 65 5f 74 69 w r i t e _ t i 6d 65 6f 75 74 00 0c 3f m e o u t . . ? 00 15 00 00 00 08 a0 . . . . . . . Server (new) com.mysql.jdbc.Buffer@5010be6 --------------------> Client Packet payload: 26 00 00 0e 03 64 65 66 & . . . . d e f 00 00 00 10 71 75 65 72 . . . . q u e r 79 5f 63 61 63 68 65 5f y _ c a c h e _ 73 69 7a 65 00 0c 3f 00 s i z e . . ? . 15 00 00 00 08 a0 . . . . . . Server (new) com.mysql.jdbc.Buffer@685f4c2e --------------------> Client Packet payload: 26 00 00 0f 03 64 65 66 & . . . . d e f 00 00 00 10 71 75 65 72 . . . . q u e r 79 5f 63 61 63 68 65 5f y _ c a c h e _ 74 79 70 65 00 0c 21 00 t y p e . . ! . 06 00 00 00 fd 00 . . . . . . Server (new) com.mysql.jdbc.Buffer@7daf6ecc --------------------> Client Packet payload: 1e 00 00 10 03 64 65 66 . . . . . d e f 00 00 00 08 73 71 6c 5f . . . . s q l _ 6d 6f 64 65 00 0c 21 00 m o d e . . ! . 42 00 00 00 fd 00 B . . . . . Server (new) com.mysql.jdbc.Buffer@2e5d6d97 --------------------> Client Packet payload: 26 00 00 11 03 64 65 66 & . . . . d e f 00 00 00 10 73 79 73 74 . . . . s y s t 65 6d 5f 74 69 6d 65 5f e m _ t i m e _ 7a 6f 6e 65 00 0c 21 00 z o n e . . ! . 09 00 00 00 fd 00 . . . . . . Server (new) com.mysql.jdbc.Buffer@238e0d81 --------------------> Client Packet payload: 1f 00 00 12 03 64 65 66 . . . . . d e f 00 00 00 09 74 69 6d 65 . . . . t i m e 5f 7a 6f 6e 65 00 0c 21 _ z o n e . . ! 00 12 00 00 00 fd 00 . . . . . . . Server (new) com.mysql.jdbc.Buffer@31221be2 --------------------> Client Packet payload: 22 00 00 13 03 64 65 66 " . . . . d e f 00 00 00 0c 74 78 5f 69 . . . . t x _ i 73 6f 6c 61 74 69 6f 6e s o l a t i o n 00 0c 21 00 2d 00 00 00 . . ! . - . . . fd 00 . . Server (new) com.mysql.jdbc.Buffer@377dca04 --------------------> Client Packet payload: 22 00 00 14 03 64 65 66 " . . . . d e f 00 00 00 0c 77 61 69 74 . . . . w a i t 5f 74 69 6d 65 6f 75 74 _ t i m e o u t 00 0c 3f 00 15 00 00 00 . . ? . . . . . 08 a0 . . Client com.mysql.jdbc.Buffer@2e817b38--------------------> Server Packet payload: 12 00 00 00 03 53 45 54 . . . . . S E T 20 4e 41 4d 45 53 20 75 . N A M E S . u 74 66 38 6d 62 34 72 2d t f 8 m b 4 r - 6a 61 76 j a v Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 07 00 00 01 00 00 00 . . . . . . . Client com.mysql.jdbc.Buffer@2e817b38--------------------> Server Packet payload: 21 00 00 00 03 53 45 54 ! . . . . S E T 20 63 68 61 72 61 63 74 . c h a r a c t 65 72 5f 73 65 74 5f 72 e r _ s e t _ r 65 73 75 6c 74 73 20 3d e s u l t s . = 20 4e 55 4c 4c 20 52 65 . N U L L . R e 76 69 v i Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 07 00 00 01 00 00 00 . . . . . . . Client com.mysql.jdbc.Buffer@2e817b38--------------------> Server Packet payload: 11 00 00 00 03 53 45 54 . . . . . S E T 20 61 75 74 6f 63 6f 6d . a u t o c o m 6d 69 74 3d 31 74 5f 72 m i t = 1 t _ r 65 73 e s Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 07 00 00 01 00 00 00 . . . . . . . Client com.mysql.jdbc.Buffer@2e817b38--------------------> Server Packet payload: 3a 00 00 00 03 53 45 54 : . . . . S E T 20 73 71 6c 5f 6d 6f 64 . s q l _ m o d 65 3d 27 4e 4f 5f 45 4e e = ' N O _ E N 47 49 4e 45 5f 53 55 42 G I N E _ S U B 53 54 49 54 55 54 49 4f S T I T U T I O 4e 2c 53 54 52 49 43 54 N , S T R I C T 5f 54 52 41 4e 53 5f 54 _ T R A N S _ T 41 42 4c 45 53 27 65 63 A B L E S ' e c 63 31 61 c 1 a Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 07 00 00 01 00 00 00 . . . . . . . Client com.mysql.jdbc.Buffer@2e817b38--------------------> Server Packet payload: 0e 00 00 00 03 53 48 4f . . . . . S H O 57 20 57 41 52 4e 49 4e W . W A R N I N 47 53 27 4e 4f 5f 45 G S ' N O _ E Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 01 . Server (new) com.mysql.jdbc.Buffer@46fbb2c1 --------------------> Client Packet payload: 1b 00 00 02 03 64 65 66 . . . . . d e f 00 00 00 05 4c 65 76 65 . . . . L e v e 6c 00 0c 21 00 15 00 00 l . . ! . . . . 00 fd 01 . . . Server (new) com.mysql.jdbc.Buffer@1698c449 --------------------> Client Packet payload: 1a 00 00 03 03 64 65 66 . . . . . d e f 00 00 00 04 43 6f 64 65 . . . . C o d e 00 0c 3f 00 04 00 00 00 . . ? . . . . . 03 a1 . . Server (new) com.mysql.jdbc.Buffer@5ef04b5 --------------------> Client Packet payload: 1d 00 00 04 03 64 65 66 . . . . . d e f 00 00 00 07 4d 65 73 73 . . . . M e s s 61 67 65 00 0c 21 00 00 a g e . . ! . . 06 00 00 fd 01 . . . . . Client com.mysql.jdbc.Buffer@5a2e4553--------------------> Server Packet payload: 88 00 00 00 03 73 45 4c . . . . . s E L 45 43 54 20 0a 20 20 60 E C T . . . . ` 62 72 6f 77 73 65 72 5f b r o w s e r _ 76 65 72 73 69 6f 6e 5f v e r s i o n _ 6e 65 77 60 2e 60 69 64 n e w ` . ` i d 60 2c 20 0a 20 20 60 62 ` , . . . . ` b 72 6f 77 73 65 72 5f 76 r o w s e r _ v 65 72 73 69 6f 6e 5f 6e e r s i o n _ n 65 77 60 2e 60 62 72 6f e w ` . ` b r o 77 73 65 72 60 2c 20 0a w s e r ` , . . 20 20 60 62 72 6f 77 73 . . ` b r o w s 65 72 5f 76 65 72 73 69 e r _ v e r s i 6f 6e 5f 6e 65 77 60 2e o n _ n e w ` . 60 76 65 72 73 69 6f 6e ` v e r s i o n 60 0a 46 52 4f 4d 20 60 ` . F R O M . ` 62 72 6f 77 73 65 72 5f b r o w s e r _ 76 65 72 73 69 6f 6e 5f v e r s i o n _ 6e 65 77 60 00 00 00 00 n e w ` . . . . 00 . Server (re-used) com.mysql.jdbc.Buffer@c4437c4 --------------------> Client Packet payload: 01 . Server (new) com.mysql.jdbc.Buffer@28c97a5 --------------------> Client Packet payload: 4b 00 00 02 03 64 65 66 K . . . . d e f 0b 77 6f 77 5f 73 74 61 . w o w _ s t a 67 69 6e 67 13 62 72 6f g i n g . b r o 77 73 65 72 5f 76 65 72 w s e r _ v e r 73 69 6f 6e 5f 6e 65 77 s i o n _ n e w 13 62 72 6f 77 73 65 72 . b r o w s e r 5f 76 65 72 73 69 6f 6e _ v e r s i o n 5f 6e 65 77 02 69 64 02 _ n e w . i d . 69 64 0c 3f 00 0b 00 00 i d . ? . . . . 00 03 03 . . . Server (new) com.mysql.jdbc.Buffer@6659c656 --------------------> Client Packet payload: 55 00 00 03 03 64 65 66 U . . . . d e f 0b 77 6f 77 5f 73 74 61 . w o w _ s t a 67 69 6e 67 13 62 72 6f g i n g . b r o 77 73 65 72 5f 76 65 72 w s e r _ v e r 73 69 6f 6e 5f 6e 65 77 s i o n _ n e w 13 62 72 6f 77 73 65 72 . b r o w s e r 5f 76 65 72 73 69 6f 6e _ v e r s i o n 5f 6e 65 77 07 62 72 6f _ n e w . b r o 77 73 65 72 07 62 72 6f w s e r . b r o 77 73 65 72 0c 08 00 10 w s e r . . . . 00 00 00 fe 09 . . . . . Server (new) com.mysql.jdbc.Buffer@6d5380c2 --------------------> Client Packet payload: 55 00 00 04 03 64 65 66 U . . . . d e f 0b 77 6f 77 5f 73 74 61 . w o w _ s t a 67 69 6e 67 13 62 72 6f g i n g . b r o 77 73 65 72 5f 76 65 72 w s e r _ v e r 73 69 6f 6e 5f 6e 65 77 s i o n _ n e w 13 62 72 6f 77 73 65 72 . b r o w s e r 5f 76 65 72 73 69 6f 6e _ v e r s i o n 5f 6e 65 77 07 76 65 72 _ n e w . v e r 73 69 6f 6e 07 76 65 72 s i o n . v e r 73 69 6f 6e 0c 3f 00 0b s i o n . ? . . 00 00 00 03 01 . . . . .