Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
5.5.37-galera
-
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 |
|