API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 18th, 2018
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.70 KB | None | 0 0
raw download clone embed print report
  1. "2018-06-18T17:01:33.535Z","Executing (790a6366-cf3d-4216-97a2-a89c82ab5c63): SELECT `id`, `type`, `createdAt`, `updatedAt`, `beginAt`, `endAt`, `note`, `productId`, `deviceId`, `errorId` FROM `StopHistory` AS `StopHistory` WHERE `StopHistory`.`deviceId` = 32 AND ((`StopHistory`.`beginAt` < '2018-06-18 16:54:32.199' AND `StopHistory`.`endAt` > '2018-06-18 16:54:32.199') OR (`StopHistory`.`endAt` IS NULL AND `StopHistory`.`beginAt` < '2018-06-18 16:54:32.199')) LIMIT 1;"
  2. "2018-06-18T17:01:33.529Z","Executing (790a6366-cf3d-4216-97a2-a89c82ab5c63): SELECT `Session`.`id`, `Session`.`productId`, `Session`.`deviceId`, `Session`.`itemsTotal`, `Session`.`scraps`, `Session`.`createdAt`, `Session`.`beginAt`, `Session`.`endAt`, `Session`.`updatedAt`, `Session`.`lastData`, `Session`.`active`, `Session`.`totalTime`, `Session`.`inputSensorPieces`, `Product`.`id` AS `Product.id`, `Product`.`name` AS `Product.name`, `Product`.`code` AS `Product.code`, `Product`.`companyId` AS `Product.companyId`, `Product`.`categoryId` AS `Product.categoryId`, `Product`.`createdAt` AS `Product.createdAt`, `Product`.`updatedAt` AS `Product.updatedAt`, `Product`.`resumeProductionProductsThreshold` AS `Product.resumeProductionProductsThreshold`, `Product`.`stopProductsThreshold` AS `Product.stopProductsThreshold`, `Product`.`idealPiecesPerMinutesSpeed` AS `Product.idealPiecesPerMinutesSpeed` FROM `Sessions` AS `Session` LEFT OUTER JOIN `Products` AS `Product` ON `Session`.`productId` = `Product`.`id` WHERE `Session`.`deviceId` = 32 AND ((`Session`.`beginAt` < '2018-06-18 16:54:32.199' AND `Session`.`endAt` > '2018-06-18 16:54:32.199') OR (`Session`.`endAt` IS NULL AND `Session`.`beginAt` < '2018-06-18 16:54:32.199')) LIMIT 1;"
  3. "2018-06-18T17:01:33.482Z","Executing (790a6366-cf3d-4216-97a2-a89c82ab5c63): SELECT `id`, `serial`, `location`, `createdAt`, `updatedAt`, `address`, `categoryId`, `state`, `place`, `label`, `companyId`, `productionState`, `errorId`, `productId`, `errorDate`, `productionLineId`, `stopProductsThreshold`, `resumeProductionProductsThreshold`, `oeeTarget`, `syncing`, `toSyncFrom`, `unipiId` FROM `Devices` AS `Device` WHERE `Device`.`id` = 32 FOR UPDATE;"
  4. "2018-06-18T17:01:33.461Z","Executing (790a6366-cf3d-4216-97a2-a89c82ab5c63): SET autocommit = 1;"
  5. "2018-06-18T17:01:33.442Z","Executing (790a6366-cf3d-4216-97a2-a89c82ab5c63): SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;"
  6. "2018-06-18T17:01:33.432Z","Executing (790a6366-cf3d-4216-97a2-a89c82ab5c63): START TRANSACTION;"
  7.  
  8.  
  9.  
  10. "2018-06-18T17:01:33.557Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): UPDATE `StopHistory` SET `endAt`='2018-06-18 17:00:35.222',`updatedAt`='2018-06-18 17:01:33.000' WHERE `endAt` IS NULL AND `deviceId` = 33"
  11. "2018-06-18T17:01:33.552Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): UPDATE `Devices` SET `state`=2,`errorDate`=NULL,`errorId`=NULL,`updatedAt`='2018-06-18 17:01:33' WHERE `id` = 33"
  12. "2018-06-18T17:01:33.097Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): INSERT INTO `StopHistory` (`id`,`type`,`createdAt`,`updatedAt`,`beginAt`,`productId`,`deviceId`) VALUES (DEFAULT,3,'2018-06-18 17:01:33.000','2018-06-18 17:01:33.000','2018-06-18 16:54:42.273',NULL,33);"
  13. "2018-06-18T17:01:33.084Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SELECT `id`, `type`, `createdAt`, `updatedAt`, `beginAt`, `endAt`, `note`, `productId`, `deviceId`, `errorId` FROM `StopHistory` AS `StopHistory` WHERE `StopHistory`.`deviceId` = 33 AND `StopHistory`.`endAt` IS NULL LIMIT 1;"
  14. "2018-06-18T17:01:33.058Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): UPDATE `Devices` SET `state`=1,`errorDate`='2018-06-18 16:55:17',`updatedAt`='2018-06-18 17:01:33' WHERE `id` = 33"
  15. "2018-06-18T17:01:32.971Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): DELETE FROM `StopHistory` WHERE `deviceId` = 33 AND `beginAt` >= '2018-06-18 16:54:42'"
  16. "2018-06-18T17:01:32.946Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SELECT `id`, `deviceId`, `beginAt`, `endAt`, `createdAt`, `updatedAt` FROM `DeviceProductionSchedules` AS `DeviceProductionSchedule` WHERE `DeviceProductionSchedule`.`deviceId` = 33;"
  17. "2018-06-18T17:01:32.700Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SELECT `id`, `type`, `createdAt`, `updatedAt`, `beginAt`, `endAt`, `note`, `productId`, `deviceId`, `errorId` FROM `StopHistory` AS `StopHistory` WHERE `StopHistory`.`deviceId` = 33 AND ((`StopHistory`.`beginAt` < '2018-06-18 16:54:42.273' AND `StopHistory`.`endAt` > '2018-06-18 16:54:42.273') OR (`StopHistory`.`endAt` IS NULL AND `StopHistory`.`beginAt` < '2018-06-18 16:54:42.273')) LIMIT 1;"
  18. "2018-06-18T17:01:32.690Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SELECT `Session`.`id`, `Session`.`productId`, `Session`.`deviceId`, `Session`.`itemsTotal`, `Session`.`scraps`, `Session`.`createdAt`, `Session`.`beginAt`, `Session`.`endAt`, `Session`.`updatedAt`, `Session`.`lastData`, `Session`.`active`, `Session`.`totalTime`, `Session`.`inputSensorPieces`, `Product`.`id` AS `Product.id`, `Product`.`name` AS `Product.name`, `Product`.`code` AS `Product.code`, `Product`.`companyId` AS `Product.companyId`, `Product`.`categoryId` AS `Product.categoryId`, `Product`.`createdAt` AS `Product.createdAt`, `Product`.`updatedAt` AS `Product.updatedAt`, `Product`.`resumeProductionProductsThreshold` AS `Product.resumeProductionProductsThreshold`, `Product`.`stopProductsThreshold` AS `Product.stopProductsThreshold`, `Product`.`idealPiecesPerMinutesSpeed` AS `Product.idealPiecesPerMinutesSpeed` FROM `Sessions` AS `Session` LEFT OUTER JOIN `Products` AS `Product` ON `Session`.`productId` = `Product`.`id` WHERE `Session`.`deviceId` = 33 AND ((`Session`.`beginAt` < '2018-06-18 16:54:42.273' AND `Session`.`endAt` > '2018-06-18 16:54:42.273') OR (`Session`.`endAt` IS NULL AND `Session`.`beginAt` < '2018-06-18 16:54:42.273')) LIMIT 1;"
  19. "2018-06-18T17:01:32.679Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SELECT `id`, `serial`, `location`, `createdAt`, `updatedAt`, `address`, `categoryId`, `state`, `place`, `label`, `companyId`, `productionState`, `errorId`, `productId`, `errorDate`, `productionLineId`, `stopProductsThreshold`, `resumeProductionProductsThreshold`, `oeeTarget`, `syncing`, `toSyncFrom`, `unipiId` FROM `Devices` AS `Device` WHERE `Device`.`id` = 33 FOR UPDATE;"
  20. "2018-06-18T17:01:32.664Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SET autocommit = 1;"
  21. "2018-06-18T17:01:32.659Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;"
  22. "2018-06-18T17:01:32.649Z","Executing (4fe70452-f7d4-4276-aa2c-bb0c92f4cba0): START TRANSACTION;"
  23.  
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33. LATEST DETECTED DEADLOCK
  34. ------------------------
  35. 2018-06-18 17:01:33 2b138be7e700
  36. *** (1) TRANSACTION:
  37. TRANSACTION 103866153, ACTIVE 0 sec fetching rows
  38. mysql tables in use 1, locked 1
  39. LOCK WAIT 16 lock struct(s), heap size 376, 33 row lock(s)
  40. MySQL thread id 59279, OS thread handle 0x2b137c241700, query id 20213026 172.31.2.181 techmass Sending data
  41. SELECT `id`, `type`, `createdAt`, `updatedAt`, `beginAt`, `endAt`, `note`, `productId`, `deviceId`, `errorId` FROM `StopHistory` AS `StopHistory` WHERE `StopHistory`.`deviceId` = 32 AND ((`StopHistory`.`beginAt` < '2018-06-18 16:54:32.199' AND `StopHistory`.`endAt` > '2018-06-18 16:54:32.199') OR (`StopHistory`.`endAt` IS NULL AND `StopHistory`.`beginAt` < '2018-06-18 16:54:32.199')) LIMIT 1
  42. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  43. RECORD LOCKS space id 641 page no 1059 n bits 2 index `endAt` of table `techmass`.`StopHistory` trx id 103866153 lock mode S waiting
  44. Record lock, heap no 2 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  45.  0: SQL NULL;
  46.  1: len=4; bufptr=0x2b134db7c07e; hex= 8001c28e; asc     ;;
  47.  
  48. *** (2) TRANSACTION:
  49. TRANSACTION 103866128, ACTIVE 1 sec starting index read
  50. mysql tables in use 3, locked 3
  51. LOCK WAIT 29 lock struct(s), heap size 376, 1607 row lock(s), undo log entries 3
  52. MySQL thread id 59276, OS thread handle 0x2b137b790700, query id 20213028 172.31.2.181 techmass Searching rows for update
  53. UPDATE `StopHistory` SET `endAt`='2018-06-18 17:00:35.222',`updatedAt`='2018-06-18 17:01:33.000' WHERE `endAt` IS NULL AND `deviceId` = 33
  54. *** (2) HOLDS THE LOCK(S):
  55. RECORD LOCKS space id 641 page no 1059 n bits 2 index `endAt` of table `techmass`.`StopHistory` trx id 103866128 lock_mode X locks rec but not gap
  56. Record lock, heap no 2 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  57.  0: SQL NULL;
  58.  1: len=4; bufptr=0x2b134db7c07e; hex= 8001c28e; asc     ;;
  59.  
  60. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  61. RECORD LOCKS space id 641 page no 1059 n bits 469 index `endAt` of table `techmass`.`StopHistory` trx id 103866128 lock_mode X waiting
  62. Record lock, heap no 469 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  63.  0: SQL NULL;
  64.  1: len=4; bufptr=0x2b134db7df81; hex= 8000bda5; asc     ;;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!