Skip to content

Instantly share code, notes, and snippets.

View dyangrev's full-sized avatar

Daiyi Yang dyangrev

3 followers · 0 following
View GitHub Profile
@dyangrev
dyangrev / gist:29193ec6abeffca85d43
Created March 4, 2015 21:14
150304 12:19:16
*** (1) TRANSACTION:
TRANSACTION 95B6, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2
MySQL thread id 587, OS thread handle 0x7fa5fdc76700, query id 5596 localhost 127.0.0.1 root Updating
UPDATE GuestStay SET updated_at = '2015-03-04 20:19:16', average_room_rate = '0', es_version = 2 WHERE id = 3434580
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 37 page no 13025 n bits 88 index `PRIMARY` of table `inguest`.`GuestStay` trx id 95B6 lock_mode X locks rec but not gap waiting
Record lock, heap no 16 PHYSICAL RECORD: n_fields 80; compact format; info bits 0
@dyangrev
dyangrev / gist:64d3297decb28bb943f5
Created March 6, 2015 22:39
mysql> select * from GuestStayInfo where value like '%[{%' order by created_at desc limit 1;
+--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | guest_stay_id | user_id | action_type | created_by | created_at | attribute_name | value |
+--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 888393 | 4446304 | NULL | add | NULL | 2015-03-06 22:35:16 | notes | {"v
@dyangrev
dyangrev / gist:0afcab9f757d532c4ddb
Created March 10, 2015 23:08
{"property":"BHH","bookingDate":"2015-02-23T12:14:09.000+0000","checkinDate":"2015-02-24T00:00:00.000+0000","stayLength":{"stayLength":1,"stayLengthUnits":"DAY"},"guestNotes":[{"type":"RESERVATION","text":"Negotiated rate plan name: ABC Corporate SVC","comment":"Negotiated rate plan name: ABC Corporate SVC","time":"2015-02-23T12:14:09.000+0000","mfcommentDate":"2015-02-23T12:14:09.000+0000"}],"profiles":[{"profileId":"1908939","profileType":"GUEST","phoneNumbers":[{"phoneNumber":"2072463207","phoneNumberType":"HOME"}],"firstName":"Andrewmr","lastName":"Davies","gender":"UNKNOWN","emailOptOut":"false","mailOptOut":"false"},{"profileId":"74283","profileType":"TRAVEL","postalAddresses":[{"addressType":"HOME","address1":"26 Old Bailey","city":"London","country":"GB","zipCode":"EC4M 7HS"},{"addressType":"BUSINESS","address1":"26 Old Bailey","city":"London","country":"US","state":"GB","zipCode":"EC4M 7HS"},{"addressType":"HOME","address1":"C\/0 Beazley Group Plc","address2":"Plantation Place South","city":"London",
@dyangrev
dyangrev / gist:290ac21218a376aa5291
Created March 10, 2015 23:14
mysql> select max(created_at) from PMSImportRecord where content like "%checkinDate\":\"____-__-__T__:__:__.000+00%";
+---------------------+
| max(created_at) |
+---------------------+
| 2015-02-23 20:42:35 |
+---------------------+
1 row in set (6.64 sec)
mysql> select max(created_at) from PMSImportRecord where content like "%checkoutDate\":\"____-__-__T__:__:__.000+00%";
+---------------------+
@dyangrev
dyangrev / gist:2179b8c637443fbfec8e
Created October 8, 2015 23:15
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766617
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766529
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766530
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766531
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766532
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766536
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766534
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766537
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766538
php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766535
@dyangrev
dyangrev / gist:3b7cc55c499623589dade214a1c2b5ee
Created May 10, 2016 19:54
TCPDUMP from memcached
19:47:58.894010 IP inguest-app-04.test.rpc.revinate.net.27549 > inguest-memcached-01.test.rpc.revinate.net.11211: Flags [S], seq 1837843347, win 28200, options [mss 1410,sackOK,TS val 1230524289 ecr 0,nop,wscale 7], length 0
19:47:58.894083 IP inguest-memcached-01.test.rpc.revinate.net.11211 > inguest-app-04.test.rpc.revinate.net.27549: Flags [S.], seq 742036930, ack 1837843348, win 27960, options [mss 1410,sackOK,TS val 2354472040 ecr 1230524289,nop,wscale 7], length 0
19:47:58.894680 IP inguest-app-04.test.rpc.revinate.net.27549 > inguest-memcached-01.test.rpc.revinate.net.11211: Flags [.], ack 1, win 221, options [nop,nop,TS val 1230524289 ecr 2354472040], length 0
19:47:58.916268 IP inguest-app-04.test.rpc.revinate.net.27550 > inguest-memcached-01.test.rpc.revinate.net.11211: Flags [S], seq 4126209094, win 28200, options [mss 1410,sackOK,TS val 1230524295 ecr 0,nop,wscale 7], length 0
19:47:58.916295 IP inguest-memcached-01.test.rpc.revinate.net.11211 > inguest-app-04.test.rpc.revin
@dyangrev
dyangrev / gist:e46e0bc0b472dd8dfb71a4fc087d8a1d
Created July 28, 2016 19:04
"messageReply": "{\"summary\":{\"successCount\":500,\"errorCount\":0,\"totalCount\":500},\"errors\":[],\"warnings\":[{\"field\":\"$.[0].roomNumber\",\"message\":\"is recommended\"},{\"field\":\"$.[0].profiles[0].emailAddresses\",\"message\":\"is recommended and should have at least one\"},{\"field\":\"$.[1].roomNumber\",\"message\":\"is recommended\"},{\"field\":\"$.[1].profiles[0].emailAddresses\",\"message\":\"is recommended and should have at least one\"},{\"field\":\"$.[2].profiles[0].emailAddresses\",\"message\":\"is recommended and should have at least one\"},{\"field\":\"$.[3].roomNumber\",\"message\":\"is recommended\"},{\"field\":\"$.[3].profiles[0].emailAddresses\",\"message\":\"is recommended and should have at least one\"},{\"field\":\"$.[4].profiles[0].emailAddresses\",\"message\":\"is recommended and should have at least one\"},{\"field\":\"$.[5].roomNumber\",\"message\":\"is recommended\"},{\"field\":\"$.[6].profiles[0].emailAddresses\",\"message\":\"is recommended and should have at least
@dyangrev
dyangrev / gist:0ecd0c55f2fc067a4fbf5e651fa0bbb8
Created September 10, 2016 00:05
Conflicting pairs
+--------------------+---------------------+----------------------+--------------------+-------------------------+------------------------+-----------------------+------------------------+---------------------------+-----------------+
| profile_id|normalized_first_name|normalized_middle_name|normalized_last_name|normalized_postal_address|normalized_email_address|normalized_phone_number|normalized_date_of_birth|normalized_primary_language|normalized_gender|
+--------------------+---------------------+----------------------+--------------------+-------------------------+------------------------+-----------------------+------------------------+---------------------------+-----------------+
|b03a1341-4931-11e...| caroline| null| stern| parkstrasse 9 kre...| null| +1784727510| null| null| U|
|8f50aff5-492b-11e...| caroline| null| stal
@dyangrev
dyangrev / gist:3ac5b5a5a22ebb53bdf0b2ea7c4cc89b
Created September 10, 2016 00:43
Conflict
score: 0.625
+------------------------------------+---------------------+----------------------+--------------------+------------------------------+------------------------+-----------------------+------------------------+---------------------------+-----------------+
|profile_id |normalized_first_name|normalized_middle_name|normalized_last_name|normalized_postal_address |normalized_email_address|normalized_phone_number|normalized_date_of_birth|normalized_primary_language|normalized_gender|
+------------------------------------+---------------------+----------------------+--------------------+------------------------------+------------------------+-----------------------+------------------------+---------------------------+-----------------+
|b03a1341-4931-11e6-87de-adec83c41e61|caroline |null |stern |parkstrasse 9 krefeld de 47829|null |+1784727510 |null |null |U
@dyangrev
dyangrev / conflicts for DAVINC
Created September 21, 2016 22:21
+-------------+---------------------+----------------------+--------------------+---------------------------------------+-------------------------------+-----------------------+------------------------+---------------------------+-----------------+
|profile_id |normalized_first_name|normalized_middle_name|normalized_last_name|normalized_postal_address |normalized_email_address |normalized_phone_number|normalized_date_of_birth|normalized_primary_language|normalized_gender|
+-------------+---------------------+----------------------+--------------------+---------------------------------------+-------------------------------+-----------------------+------------------------+---------------------------+-----------------+
|1194000909707|gabriela de |null |jesus |3320 redwood grove pearland tx us 77581|lexa7086@gmail.com |+17139229872 |null |null |null |
|1365799604463|gabriela de