[MDEV-6327] show processlist output corrupted on queries Created: 2014-06-11  Updated: 2019-01-22  Resolved: 2019-01-22

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 5.5.37-galera
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Daniel Black Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 1
Labels: galera, processlist
Environment:

rhel6 2.6.32-358.6.2.el6.x86_64


 Description   

This server was running for about a few months. It was a galera member that hasn't been read or written to directly for a long time since I did a few alter tables on large tables.

Sorry not much more I can describe about what causes this output and I don't have a way to replicate this.

| Id   | User          | Host                 | db   | Command     | Time   | State                                                                 | Info                                                                                                                          | Progress |
 
|    1 | system user   |                      | NULL | Sleep       | 486746 | wsrep aborter idle                                                    | NULL                                                                                                                          |    0.000 |
 
|    2 | system user   |                      | NULL | Sleep       |      5 | committed 212041579                                                   | (MASTER)*/UPDATE data_source_prices
 
>                                 SET
 
>                                         price = '7.1',
 
>                                         last_updated = NOW()
 
>                                 WHERE
 
>                           |    0.000 |
 
|    5 | system user   |                      | NULL | Sleep       |      4 | committed 212041602                                                   | 70000000',
 
>                                                 place_price_source = '29',
 
>                                                 apn_roll = '0',
 
>                                                 apn_upper_l                                           |    0.000 |
 
|    6 | system user   |                      | NULL | Sleep       |      5 | committed 212041598                                                   |                                                                                                                               |    0.000 |
 
|    7 | system user   |                      | NULL | Sleep       |      0 | committed 212041624                                                   | ce_source = '29',
 
>                                                 apn_roll = '0',
 
>                                                 apn_upper_limit = '0.00000000',
 
>                                                 update_user_id =                          |    0.000 |
 
|    8 | system user   |                      | NULL | Sleep       |      3 | committed 212041616                                                   | ~˜å}/8võ•ÿ¢Xè¶ãǶ½ÄÍ¢¿–S \'                                                                                              |    0.000 |
 
|    9 | system user   |                      | NULL | Sleep       |      5 | committed 212041582                                                   | ▒‘By†DslIw¨dP1ÞŸDíse¸B×+³þ^£}³~SÎÍ+6ô®¸‚gw¢¿–S \'                                                                  |    0.000 |
 
|   10 | system user   |                      | NULL | Sleep       |      4 | committed 212041604                                                   | 
>                                                                                                                                                       þþö
 
>                                                                                                                                                          þþ–þ                                                                                       |    0.000 |
 
|   11 | system user   |                      | NULL | Sleep       |      3 | committed 212041618                                                   | ŸÈuO£M                                                                                                                       |    0.000 |
 
|   12 | system user   |                      | NULL | Sleep       |      5 | committed 212041591                                                   | ice_source = '29',
 
>                                                 place_price = '8.90000000',
 
>                                                 place_price_sourc                                                  |    0.000 |
 
|   13 | system user   |                      | NULL | Sleep       |      1 | committed 212041621                                                   | 
>                                                 apn_upper_limit = '0.00000000',
 
>                                                 update_user_id = '-110',
 
>                                                 price_prefix = '',
 
>                                                                   |    0.000 |
 
> -´Ê·Ãòqà|.6Ø$1Š+hK‹aîš▒¹¿–S \'                                             |    0.000 | 212041614                                                   | àÉÆXˆH ‚DslIw¨Äô*©´ÅdZ™W
 
|   15 | system user   |                      | NULL | Sleep       |      5 | committed 212041590                                                   | €                                                                                                                             |    0.000 |
 
|   16 | system user   |                      | NULL | Sleep       |      5 | committed 212041587                                                   | °/ÝX%
 
>                                                                                                                                                            Ã%a~Šé@~fÍkÇ3DslIw¨Äô*©´…´Iœ¢<Òu
 
> 2T.)×oD]¼‰T?Z÷–¹¿–S \'                                               |    0.000 |
 
|   17 | system user   |                      | NULL | Sleep       |      4 | committed 212041612                                                   |                                                                                                                               |    0.000 |
 
|   18 | system user   |                      | NULL | Sleep       |      5 | committed 212041596                                                   | _updated = NOW()
 
>                                 WHERE
 
>                                         market_selection_details_id = '3347254' AND
 
>                                         bet_type = '1' AND
 
>                           |    0.000 |
 
|   19 | system user   |                      | NULL | Sleep       |      4 | committed 212041605                                                   |                                                                                                                               |    0.000 |
 
|   20 | system user   |                      | NULL | Sleep       |      4 | committed 212041603                                                   |                                                                                                                             |    0.000 |
 
|   21 | system user   |                      | NULL | Sleep       |      5 | committed 212041592                                                   | ASTER)*/UPDATE market_prices
 
>                                         SET
 
>                                                 win_price = '26.7',
 
>                                                 win_price_source = '2',
 
>                                                                           |    0.000 |
 
|   22 | system user   |                      | NULL | Sleep       |      5 | committed 212041586                                                   | W()
 
>                                         WHERE
 
>                                                 market_prices_id = '292855867'¢¿–S\'                                                                    |    0.000 |
 
|   23 | system user   |                      | NULL | Sleep       |      4 | committed 212041611                                                   |                                                                                                                               |    0.000 |
 
|   24 | system user   |                      | NULL | Sleep       |      5 | committed 212041597                                                   |                                                                                                                               |    0.000 |
 
|   25 | system user   |                      | NULL | Sleep       |      4 | committed 212041609                                                   | 00000',
 
>                                                 place_price_source = '29',
 
>                                                 apn_roll = '0',
 
>                                                 apn_upper_limit = '0.00000000',                          |    0.000 |
 
|   26 | system user   |                      | NULL | Sleep       |      5 | committed 212041583                                                   |                                                                                                                               |    0.000 |
 
|   27 | system user   |                      | NULL | Sleep       |      0 | committed 212041625                                                   | ÿÿÿÿÿÿÿÿ                                                                                                                      |    0.000 |
 
|   28 | system user   |                      | NULL | Sleep       |      4 | committed 212041615                                                   |                                                                                                                               |    0.000 |
 
|   29 | system user   |                      | NULL | Sleep       |      4 | committed 212041607                                                   |                                                                                                                               |    0.000 |
 
|   30 | system user   |                      | NULL | Sleep       |      5 | committed 212041578                                                   | _roll = '0',
 
>                                                 apn_upper_limit = '0.00000000',
 
>                                                 update_user_id = '-110',
 
>                                                 price_prefix                          |    0.000 |
 
|   31 | system user   |                      | NULL | Sleep       |      4 | committed 212041601                                                   | ì‚ãƒcç­Az—Õ,,
 
>                                                                                                                                                                                                                                                                                   |    0.000 |
 
|   32 | system user   |                      | NULL | Sleep       |      0 | committed 212041623                                                   | s_id = '292931809'¹¿–S\'                                                                                                     |    0.000 |
 
|   33 | system user   |                      | NULL | Sleep       |      4 | committed 212041608                                                   | rket_selection_details_id`,`bet_type`,`data_source_id`,`price`,`last_updated`) VALUES ('3346273', '1                          |    0.000 |
 
|   34 | system user   |                      | NULL | Sleep       |      1 | committed 212041620                                                   | ace_price = '9.1',
 
>                                                 place_price_source = '56',
 
>                                                 apn_roll = '0',
 
>                                                 apn_upper_limit = '0                          |    0.000 |
 
|   35 | system user   |                      | NULL | Sleep       |      1 | committed 212041622                                                   |                                                                                                                              |    0.000 |
 
|   36 | system user   |                      | NULL | Sleep       |      2 | committed 212041619                                                   | O£M                                                                                                                           |    0.000 |
 
|   37 | system user   |                      | NULL | Sleep       |      5 | committed 212041580                                                   | ype`,`data_source_id`,`price`,`last_updated`) VALUES ('3346885', '1', '9', '5.80', '2014-06-10 17:39                          |    0.000 |
 
|   38 | system user   |                      | NULL | Sleep       |      5 | committed 212041588                                                   | rices                                                                                                                         |    0.000 |
 
|   39 | system user   |                      | NULL | Sleep       |      5 | committed 212041593                                                   | ãƒcç­Az—ÕÜ+
 
>                                                                                                                                                                                                                                                                                   |    0.000 |
 
|   40 | system user   |                      | NULL | Sleep       |      4 | committed 212041600                                                   |                                                                                                                               |    0.000 |
 
|   41 | system user   |                      | NULL | Sleep       |      5 | committed 212041585                                                   | t_updated = NOW()
 
>                                         WHERE
 
>                                                 market_prices_id = '292931884'¹¿–S\'                                                      |    0.000 |
 
|   42 | system user   |                      | NULL | Sleep       |      4 | committed 212041610                                                   |                                  WHERE
 
>                                                 market_prices_id = '292931887'¹¿–S\'                                                                        |    0.000 |
 
|   43 | system user   |                      | NULL | Sleep       |      4 | committed 212041613                                                   |                                                                                                                               |    0.000 |
 
|   44 | system user   |                      | NULL | Sleep       |      3 | committed 212041617                                                   | 
>                                                                                                                                                       þþ–þ                                                                                                 |    0.000 |
 
|   45 | system user   |                      | NULL | Sleep       |      5 | committed 212041581                                                   | '24.70000000',
 
>                                                 win_price_source = '33',
 
>                                                 place_price = '10.7',
 
>                                                 pla                                           |    0.000 |
 
|   46 | system user   |                      | NULL | Sleep       |      5 | committed 212041599                                                   | et                                                                                                                            |    0.000 |
 
|   47 | system user   |                      | NULL | Sleep       |      5 | committed 212041589                                                   |                                                                                                                               |    0.000 |
 
|   48 | system user   |                      | NULL | Sleep       |      5 | committed 212041594                                                   | = NOW()
 
>                                         WHERE
 
>                                                 market_prices_id = '293275579'¹¿–S\'                                                                |    0.000 |
 
|   49 | system user   |                      | NULL | Sleep       |      5 | committed 212041595                                                   |  '3346270' AND
 
>                                         bet_type = '1' AND
 
>                                         data_source_id = '10'¢¿–S\'                                                      |    0.000 |
 
|   50 | system user   |                      | NULL | Sleep       |      5 | committed 212041584                                                   | þ                                                                                                                      |    0.000 |
 
|   51 | system user   |                      | NULL | Sleep       |      4 | committed 212041606                                                   |                                                                                                                        |    0.000 |
 
|   52 | percona-agent | 127.0.0.1:58133      | NULL | Sleep       |      0 |                                                                       | NULL                                                                                                                          |    0.000 |
 
| 9488 | repl          | 172.17.194.113:45511 | NULL | Binlog Dump |  21931 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL                                                                                                                          |    0.000 |
 
| 9933 | openquery     | localhost            | NULL | Query       |      0 | sleeping                                                              | show processlist                                                                                                              |    0.000 |



 Comments   
Comment by Elena Stepanova [ 2014-06-11 ]

We had one like that with the State column: MDEV-4723

I will need to repeat the exercise with the Info column to see if I can reproduce it same way.

Comment by Daniel Black [ 2014-06-18 ]

Actually it could be RBR on galera not populating the field. Both of these show up in a galera member that is read but not written to. The member being written to doesn't show these outputs.

From show engine innodb status;.

TRANSACTIONS
 
------------
 
Trx id counter 4DF5E460
 
Purge done for trx's n:o < 4DF5E446 undo n:o < 0
 
History list length 1906
 
LIST OF TRANSACTIONS FOR EACH SESSION:
 
---TRANSACTION 0, not started
 
MySQL thread id 3290287, OS thread handle 0x7fa240da7700, query id 319995658 localhost openquery sleeping
 
show engine innodb status
 
---TRANSACTION 4DF38F15, not started
 
MySQL thread id 3288886, OS thread handle 0x7fa240df0700, query id 319980530 172.16.194.38 wp_write sleeping
 
---TRANSACTION 4DF3175E, not started
 
MySQL thread id 3288913, OS thread handle 0x7f9d3fcb6700, query id 319981728 172.16.194.39 wp_write sleeping
 
---TRANSACTION 4DF28107, not started
 
MySQL thread id 3288911, OS thread handle 0x7f9cb90ff700, query id 319981728 172.16.194.39 wp_write sleeping
 
---TRANSACTION 4DF5BD5D, not started
 
MySQL thread id 3288909, OS thread handle 0x7f9dc6c6d700, query id 319985677 172.16.194.39 wp_write sleeping
 
---TRANSACTION 4DF24452, not started
 
MySQL thread id 3288885, OS thread handle 0x7fa240d15700, query id 319980530 172.16.194.38 wp_write sleeping
 
---TRANSACTION 4DF27ED6, not started
 
MySQL thread id 3288915, OS thread handle 0x7f9bd23b6700, query id 319981728 172.16.194.39 wp_write sleeping
 
---TRANSACTION 4DF2150C, not started
 
MySQL thread id 3288883, OS thread handle 0x7f9cb906d700, query id 319980530 172.16.194.38 wp_write sleeping
 
---TRANSACTION 4DF2853E, not started
 
MySQL thread id 3288884, OS thread handle 0x7fa240f14700, query id 319980530 172.16.194.38 wp_write sleeping
 
---TRANSACTION 4DEFD87A, not started
 
MySQL thread id 3288784, OS thread handle 0x7f9cfc86d700, query id 319981728 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DF25ABC, not started
 
MySQL thread id 3288783, OS thread handle 0x7f9fe20b6700, query id 319981728 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DEFD876, not started
 
MySQL thread id 3288782, OS thread handle 0x7fa0efcff700, query id 319981728 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DEFD872, not started
 
MySQL thread id 3288778, OS thread handle 0x7fa13306d700, query id 319981728 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DF31757, not started
 
MySQL thread id 3288781, OS thread handle 0x7fa0ac4ff700, query id 319981728 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DF5BD52, not started
 
MySQL thread id 3288780, OS thread handle 0x7f9bd83ff700, query id 319985611 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DF28135, not started
 
MySQL thread id 3288779, OS thread handle 0x7fa17686d700, query id 319981728 172.16.194.39 wpro sleeping
 
---TRANSACTION 4DEFB516, not started
 
MySQL thread id 3288761, OS thread handle 0x7fa02586d700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DEFB513, not started
 
MySQL thread id 3288760, OS thread handle 0x7f9c324b6700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DEFB512, not started
 
MySQL thread id 3288759, OS thread handle 0x7fa0efcb6700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DF38ECD, not started
 
MySQL thread id 3288756, OS thread handle 0x7f9e9106d700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DF21515, not started
 
MySQL thread id 3288758, OS thread handle 0x7fa1fd46d700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DF24459, not started
 
MySQL thread id 3288757, OS thread handle 0x7f9bd4b6d700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DF25E55, not started
 
MySQL thread id 3288755, OS thread handle 0x7f9cfc8ff700, query id 319980530 172.16.194.38 wpro sleeping
 
---TRANSACTION 4DF5E45E, not started
 
MySQL thread id 42, OS thread handle 0x7fa2842fe700, query id 319995657 committed 246660943
 
u�
 
---TRANSACTION 4DF5E45A, not started
 
MySQL thread id 44, OS thread handle 0x7fa28426c700, query id 319995655 committed 246660941
 
|�
 
---TRANSACTION 4DF5E456, not started
 
MySQL thread id 39, OS thread handle 0x7fa2843d9700, query id 319995652 committed 246660939
 
5��
 
---TRANSACTION 4DF5E42C, not started
 
MySQL thread id 29, OS thread handle 0x7fa294523700, query id 319995607 committed 246660918
 
 
 
---TRANSACTION 4DF5E408, not started
 
MySQL thread id 8, OS thread handle 0x7fa2999d8700, query id 319995589 committed 246660900
 
˛
 
---TRANSACTION 4DF5E424, not started
 
MySQL thread id 25, OS thread handle 0x7fa2945b5700, query id 319995603 committed 246660914
 
 
 
---TRANSACTION 4DF5E43C, not started
 
MySQL thread id 22, OS thread handle 0x7fa295d22700, query id 319995621 committed 246660926
 
ݒ�
 
---TRANSACTION 4DF5E45C, not started
 
MySQL thread id 7, OS thread handle 0x7fa3da4c9700, query id 319995656 committed 246660942
 
 
 
---TRANSACTION 4DF5E452, not started
 
MySQL thread id 20, OS thread handle 0x7fa295db4700, query id 319995646 committed 246660937
 
 
 
---TRANSACTION 4DF5E426, not started
 
MySQL thread id 35, OS thread handle 0x7fa293123700, query id 319995604 committed 246660915
 
 
 
---TRANSACTION 4DF5E400, not started
 
MySQL thread id 5, OS thread handle 0x7fa3da480700, query id 319995581 committed 246660896
 
���
 
---TRANSACTION 4DF5E42A, not started
 
MySQL thread id 37, OS thread handle 0x7fa293091700, query id 319995606 committed 246660917
 
�˛
 
---TRANSACTION 4DF5E44C, not started
 
MySQL thread id 28, OS thread handle 0x7fa2944da700, query id 319995637 committed 246660934
 
---TRANSACTION 4DF5E412, not started
 
MySQL thread id 47, OS thread handle 0x7fa284148700, query id 319995594 committed 246660905
 
 
 
---TRANSACTION 4DF5E450, not started
 
MySQL thread id 3, OS thread handle 0x7fa3da5a4700, query id 319995643 committed 246660936
 
 
 
---TRANSACTION 4DF5E43E, not started
 
MySQL thread id 17, OS thread handle 0x7fa295e8f700, query id 319995622 committed 246660927
 
w�
 
---TRANSACTION 4DF5E414, not started
 
MySQL thread id 11, OS thread handle 0x7fa2998b4700, query id 319995595 committed 246660906
 
�
 
---TRANSACTION 4DF5E454, not started
 
MySQL thread id 46, OS thread handle 0x7fa2841da700, query id 319995649 committed 246660938
 
 
 
---TRANSACTION 4DF5E416, not started
 
MySQL thread id 48, OS thread handle 0x7fa284191700, query id 319995596 committed 246660907
 
 
 
---TRANSACTION 4DF5E418, not started
 
MySQL thread id 16, OS thread handle 0x7fa295f21700, query id 319995597 committed 246660908
 
)��
 
---TRANSACTION 4DF5E406, not started
 
MySQL thread id 24, OS thread handle 0x7fa295c90700, query id 319995588 committed 246660899
 
 
 
---TRANSACTION 4DF5E430, not started
 
MySQL thread id 27, OS thread handle 0x7fa29456c700, query id 319995611 committed 246660920
 
 
 
---TRANSACTION 4DF5E438, not started
 
MySQL thread id 21, OS thread handle 0x7fa295d6b700, query id 319995619 committed 246660924
 
Ē�
 
---TRANSACTION 4DF5E40C, not started
 
MySQL thread id 41, OS thread handle 0x7fa284347700, query id 319995591 committed 246660902
 
�ț
 
---TRANSACTION 4DF5E420, not started
 
MySQL thread id 45, OS thread handle 0x7fa284223700, query id 319995601 committed 246660912
 
 
 
---TRANSACTION 4DF5E41E, not started
 
MySQL thread id 32, OS thread handle 0x7fa2931b5700, query id 319995600 committed 246660911
 
'��
 
---TRANSACTION 4DF5E43A, not started
 
MySQL thread id 12, OS thread handle 0x7fa299946700, query id 319995620 committed 246660925
 
s�
 
---TRANSACTION 4DF5E428, not started
 
MySQL thread id 18, OS thread handle 0x7fa295e46700, query id 319995605 committed 246660916
 
 
 
---TRANSACTION 4DF5E434, not started
 
MySQL thread id 14, OS thread handle 0x7fa295f6a700, query id 319995617 committed 246660922
 
 
 
---TRANSACTION 4DF5E444, not started
 
MySQL thread id 43, OS thread handle 0x7fa2842b5700, query id 319995625 committed 246660930
 
 
 
---TRANSACTION 4DF5E40E, not started
 
MySQL thread id 38, OS thread handle 0x7fa293048700, query id 319995592 committed 246660903
 
���
 
---TRANSACTION 4DF5E404, not started
 
MySQL thread id 33, OS thread handle 0x7fa2931fe700, query id 319995587 committed 246660898
 
��
 
---TRANSACTION 4DF5E41C, not started
 
MySQL thread id 36, OS thread handle 0x7fa2930da700, query id 319995599 committed 246660910
 
�ѣ
 
---TRANSACTION 4DF5E432, not started
 
MySQL thread id 34, OS thread handle 0x7fa29316c700, query id 319995614 committed 246660921
 
---TRANSACTION 4DF5E442, not started
 
MySQL thread id 31, OS thread handle 0x7fa294491700, query id 319995624 committed 246660929
 
�˛
 
---TRANSACTION 4DF5E44E, not started
 
MySQL thread id 30, OS thread handle 0x7fa294448700, query id 319995640 committed 246660935
 
 
 
---TRANSACTION 4DF5E40A, not started
 
MySQL thread id 26, OS thread handle 0x7fa2945fe700, query id 319995590 committed 246660901
 
---TRANSACTION 4DF5E44A, not started
 
MySQL thread id 49, OS thread handle 0x7fa2840ff700, query id 319995634 committed 246660933
 
 
 
---TRANSACTION 4DF5E440, not started
 
MySQL thread id 23, OS thread handle 0x7fa295cd9700, query id 319995623 committed 246660928
 
Ē�
 
---TRANSACTION 4DF5E422, not started
 
MySQL thread id 19, OS thread handle 0x7fa295dfd700, query id 319995602 committed 246660913
 
 
 
---TRANSACTION 4DF5E410, not started
 
MySQL thread id 15, OS thread handle 0x7fa295ed8700, query id 319995593 committed 246660904
 
 
 
---TRANSACTION 4DF5E41A, not started
 
MySQL thread id 13, OS thread handle 0x7fa29986b700, query id 319995598 committed 246660909
 
 
 
---TRANSACTION 4DF5E402, not started
 
MySQL thread id 6, OS thread handle 0x7fa3da512700, query id 319995584 committed 246660897
 
���
 
---TRANSACTION 4DF5E448, not started
 
MySQL thread id 4, OS thread handle 0x7fa3da55b700, query id 319995631 committed 246660932
 
Ē�
 
---TRANSACTION 4DF5E436, not started
 
MySQL thread id 9, OS thread handle 0x7fa29998f700, query id 319995618 committed 246660923
 
Dś
 
---TRANSACTION 4DF5E446, not started
 
MySQL thread id 10, OS thread handle 0x7fa2998fd700, query id 319995628 committed 246660931
 
�F�
 
---TRANSACTION 4DF5E42E, not started
 
MySQL thread id 2, OS thread handle 0x7fa295fb3700, query id 319995608 committed 246660919
 
讣
 
---TRANSACTION 4DF5E458, not started
 
MySQL thread id 40, OS thread handle 0x7fa284390700, query id 319995653 committed 246660940
 
 
 
----------------------------
 
END OF INNODB MONITOR OUTPUT
 
============================

Comment by Daniel Black [ 2014-06-18 ]

At Arjen's suggestion I did try binlog_annotate_row_events=ON but it didn't help.

It would provide something useful to put in the column however.

Comment by Elena Stepanova [ 2019-01-22 ]

I don't think we are going to make anything useful out of this.

Generated at Thu Feb 08 07:11:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.