Guest User

Untitled

a guest
Jun 15th, 2018
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.69 KB | None | 0 0
  1. sysbench --db-driver=mysql --mysql-user=root --mysql-password=example --mysql-host=example --mysql-db=takedown --range_size=100 --table_size=10000000 --tables=1 --threads=1 --events=0 --time=60 --rand-type=uniform /usr/share/sysbench/oltp_read_only.lua prepare
  2.  
  3. pt-online-schema-change --execute --alter "ADD COLUMN testingcolumn VARCHAR(250) DEFAULT 'this is a test record default value'" h=example.example.example,u=root,p=example,D=takedown,t=sbtest1
  4.  
  5. No slaves found. See --recursion-method if host d6c54372-f867-4d9a-92d9-546bde3b7918 has slaves.
  6. Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
  7. Operation, tries, wait:
  8. analyze_table, 10, 1
  9. copy_rows, 10, 0.25
  10. create_triggers, 10, 1
  11. drop_triggers, 10, 1
  12. swap_tables, 10, 1
  13. update_foreign_keys, 10, 1
  14. Altering `takedown`.`sbtest1`...
  15. Creating new table...
  16. Created new table takedown._sbtest1_new OK.
  17. Altering new table...
  18. Altered `takedown`.`_sbtest1_new` OK.
  19. 2018-06-14T11:51:50 Creating triggers...
  20. 2018-06-14T11:51:50 Created triggers OK.
  21. 2018-06-14T11:51:50 Copying approximately 10000062 rows...
  22. Copying `takedown`.`sbtest1`: 5% 08:32 remain
  23. Copying `takedown`.`sbtest1`: 8% 10:18 remain
  24. Copying `takedown`.`sbtest1`: 12% 10:52 remain
  25. Copying `takedown`.`sbtest1`: 15% 10:41 remain
  26. Copying `takedown`.`sbtest1`: 19% 10:13 remain
  27. Copying `takedown`.`sbtest1`: 22% 10:05 remain
  28. Copying `takedown`.`sbtest1`: 26% 09:30 remain
  29. Copying `takedown`.`sbtest1`: 33% 08:07 remain
  30. Copying `takedown`.`sbtest1`: 39% 06:51 remain
  31. Copying `takedown`.`sbtest1`: 46% 05:51 remain
  32. Copying `takedown`.`sbtest1`: 52% 04:57 remain
  33. Copying `takedown`.`sbtest1`: 59% 04:05 remain
  34. Copying `takedown`.`sbtest1`: 66% 03:17 remain
  35. Copying `takedown`.`sbtest1`: 73% 02:31 remain
  36. Copying `takedown`.`sbtest1`: 80% 01:51 remain
  37. Copying `takedown`.`sbtest1`: 86% 01:14 remain
  38. Copying `takedown`.`sbtest1`: 93% 00:38 remain
  39. Copying `takedown`.`sbtest1`: 99% 00:03 remain
  40. 2018-06-14T12:00:53 Copied rows OK.
  41. 2018-06-14T12:00:53 Swapping tables...
  42. 2018-06-14T12:00:53 Swapped original and new tables OK.
  43. 2018-06-14T12:00:53 Dropping old table...
  44. 2018-06-14T12:00:53 Dropped old table `takedown`.`_sbtest1_old` OK.
  45. 2018-06-14T12:00:53 Dropping triggers...
  46. 2018-06-14T12:00:53 Dropped triggers OK.
  47. Successfully altered `takedown`.`sbtest1`.
  48.  
  49. E, [2018-06-14T11:46:47.913467 #23669] ERROR -- : Error occurred for cluster example-example: Deadlock found when trying to get lock; try restarting transaction
  50. E, [2018-06-14T11:52:48.814928 #23669] ERROR -- : Error occurred for cluster example-example: Deadlock found when trying to get lock; try restarting transaction
  51. E, [2018-06-14T11:53:48.970790 #23669] ERROR -- : Error occurred for cluster example-example: Deadlock found when trying to get lock; try restarting transaction
  52.  
  53. (none)> show variables like '%vers%';
  54. +---------------------------+---------------------------+
  55. | Variable_name | Value |
  56. +---------------------------+---------------------------+
  57. | innodb_version | 5.6.36-82.1 |
  58. | protocol_version | 10 |
  59. | slave_type_conversions | |
  60. | thread_pool_oversubscribe | 3 |
  61. | version | 10.1.26-MariaDB |
  62. | version_comment | Source distribution |
  63. | version_compile_machine | x86_64 |
  64. | version_compile_os | Linux |
  65. | version_malloc_library | system |
  66. | version_ssl_library | OpenSSL 1.0.1f 6 Jan 2014 |
  67. | wsrep_patch_version | wsrep_25.19 |
  68. +---------------------------+---------------------------+
  69. 11 rows in set
  70. Time: 0.007s
Add Comment
Please, Sign In to add comment