Details
-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 5.5.37-galera
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
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 |
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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 ============================
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.
We had one like that with the State column:
MDEV-4723I will need to repeat the exercise with the Info column to see if I can reproduce it same way.