2015-06-16T16:17:02.932+0800 I NETWORK [conn292927] end connection 10.0.2.102:34905 (205 connections now open) 2015-06-16T16:17:02.932+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:34930 #292929 (206 connections now open) 2015-06-16T16:17:02.999+0800 I ACCESS [conn292929] Successfully authenticated as principal __system on local 2015-06-16T16:17:09.673+0800 I NETWORK [conn292928] end connection 10.0.2.103:37711 (205 connections now open) 2015-06-16T16:17:09.674+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37731 #292930 (206 connections now open) 2015-06-16T16:17:09.712+0800 I ACCESS [conn292930] Successfully authenticated as principal __system on local 2015-06-16T16:17:20.051+0800 I ACCESS [conn143368] Successfully authenticated as principal xudalei on admin 2015-06-16T16:17:33.012+0800 I NETWORK [conn292929] end connection 10.0.2.102:34930 (205 connections now open) 2015-06-16T16:17:33.013+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:34951 #292931 (206 connections now open) 2015-06-16T16:17:33.049+0800 I ACCESS [conn292931] Successfully authenticated as principal __system on local 2015-06-16T16:17:39.720+0800 I NETWORK [conn292930] end connection 10.0.2.103:37731 (205 connections now open) 2015-06-16T16:17:39.721+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37743 #292932 (206 connections now open) 2015-06-16T16:17:39.756+0800 I ACCESS [conn292932] Successfully authenticated as principal __system on local 2015-06-16T16:17:49.682+0800 I WRITE [conn287856] insert ISH_Fact.FactPortalLoginLog query: { _id: ObjectId('557fdbaca310a27a4f58d17f'), pageid: "success", url: "https://tportal.windfindtech.com/success", os: "Android 4.4 KitKat", type: "Smartphone", op: "telecom", buv: "14df7800dc6-c1ea7753-7e8c-4a07-bedd-97ef8848a9bf", un: "13917525672", site: "i-shanghai", et: new Date(1434442668996) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 687ms 2015-06-16T16:17:49.682+0800 I WRITE [conn291195] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada3107f520555835d'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721bcf-a376f4d4-0845-441f-8cf3-4089f1ee9e8d", et: new Date(1434442669010) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 663ms 2015-06-16T16:17:49.682+0800 I WRITE [conn291196] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada3107f520555836e'), issuc: false, tc: 0, cause: "请输入正确的手机号!", buv: "14dfb721cfe-d4f100e5-e7b7-4f70-b71f-095eb1eb120c", et: new Date(1434442669312) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 365ms 2015-06-16T16:17:49.682+0800 I WRITE [conn286567] update ISH.DimUser_YuYuan query: { username: "13611736356", devices.mac: "B0:9F:BA:7E:6D:1C" } update: { $set: { devices.$.lastloginduration: 7211, lut: new Date(1434442669260) } } nscanned:1 nscannedObjects:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 420ms 2015-06-16T16:17:49.682+0800 I WRITE [conn291091] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada310a27a4f58d182'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721c74-2558cd3c-fd3a-47b7-b375-a44d21bc23e9", et: new Date(1434442669176) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 489ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287849] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada3107f5205558361'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721c27-a73ce8d8-57a1-4bbb-8db9-ac853dfe7a01", et: new Date(1434442669109) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 582ms 2015-06-16T16:17:49.682+0800 I COMMAND [conn291196] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f520555836e'), issuc: false, tc: 0, cause: "请输入正确的手机号!", buv: "14dfb721cfe-d4f100e5-e7b7-4f70-b71f-095eb1eb120c", et: new Date(1434442669312) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 365ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287853] insert ISH_Fact.FactPortalLoginLog query: { _id: ObjectId('557fdbada310a27a4f58d187'), pageid: "login", url: "https://uportal.windfindtech.com/login", os: "Android 4.1.x Jelly Bean", type: "Smartphone", op: "unicom", buv: "14dfabd5a6b-f9c4bdb5-0630-41ca-b308-ed454d50f188", un: "13311671985", et: new Date(1434442669219) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 461ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287759] update ISH.DimUser query: { _id: ObjectId('553462e4a310fb8ddf67aae1') } update: { $set: { ldt: "Android:23134d9ce05c49b047e180e51ce2836cd13ad3e2", lut: new Date(1434442669406) } } nscanned:1 nscannedObjects:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 275ms 2015-06-16T16:17:49.683+0800 I WRITE [conn287714] insert ISH_Fact.FactPortalADPresent query: { _id: ObjectId('557fdbada3107f5205558368'), spotid: "new_ishmobile_rotate_B03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14d7a043093-d9bbb62a-c74e-4783-827a-1914eed064bb", un: "15921238331", site: "i-shanghai", et: new Date(1434442669245) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 435ms 2015-06-16T16:17:49.682+0800 I WRITE [conn291029] update ISH.DimUser query: { _id: ObjectId('54b1fe55a310aa04f7afce53') } update: { $set: { llt: new Date(1434442669117), lut: new Date(1434442669102) } } nscanned:1 nscannedObjects:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 579ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287853] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d187'), pageid: "login", url: "https://uportal.windfindtech.com/login", os: "Android 4.1.x Jelly Bean", type: "Smartphone", op: "unicom", buv: "14dfabd5a6b-f9c4bdb5-0630-41ca-b308-ed454d50f188", un: "13311671985", et: new Date(1434442669219) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 462ms 2015-06-16T16:17:49.682+0800 I WRITE [conn291299] insert ISH_Fact.FactPortalLoginLog query: { _id: ObjectId('557fdbada310a27a4f58d18c'), pageid: "success", url: "https://tportal.windfindtech.com/success", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14cf90e5e0f-d1a1ccf2-d61b-46f9-9489-4be81fddf75f", un: "15821532332", site: "i-shanghai", et: new Date(1434442669354) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 323ms 2015-06-16T16:17:49.682+0800 I WRITE [conn292268] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada310a27a4f58d181'), issuc: false, tc: 5, cause: "请输入正确的手机号!", buv: "14dfb721c74-9075098f-2c6e-4963-9fd5-666609db4e3b", et: new Date(1434442669193) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 498ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287638] update ISH.DimUser query: { username: "13052050688", devices.mac: "8C:BE:BE:70:8A:9D" } update: { $set: { devices.$.lastloginstatus: 0, devices.$.lastlogintime: new Date(1434442669042), devices.$.lastloginlocation: "Unknown", lut: new Date(1434442669042) } } nscanned:1 nscannedObjects:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 639ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287788] insert ISH_Fact.FactPortalADPresent query: { _id: ObjectId('557fdbada310a27a4f58d180'), spotid: "new_ishmobile_rotate_B03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.4 KitKat", type: "Smartphone", op: "telecom", buv: "14df7800dc6-c1ea7753-7e8c-4a07-bedd-97ef8848a9bf", un: "13917525672", site: "i-shanghai", et: new Date(1434442669015) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 668ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn291299] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d18c'), pageid: "success", url: "https://tportal.windfindtech.com/success", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14cf90e5e0f-d1a1ccf2-d61b-46f9-9489-4be81fddf75f", un: "15821532332", site: "i-shanghai", et: new Date(1434442669354) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 324ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287863] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada310a27a4f58d18f'), issuc: false, tc: 0, cause: "请输入正确的手机号!", buv: "14dfb721d68-6a60f8b4-bc1c-4416-a988-a0e09316c501", et: new Date(1434442669434) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 249ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287789] insert ISH_Fact.FactAppLoginLog query: { _id: ObjectId('557fdbada310a27a4f58d186'), userid: "542f4c2ca3104a5b24240cf7", username: "18221039262", passauthtime: 889, locationinfo: { height: 0.0, precision: 0.0, gps: [ 0.0, 0.0 ] }, ispass: true, ssid: [ { SSID: "MERCURY_9F46", rssi: -79 }, { SSID: "i-Shanghai", rssi: -53 }, { SSID: "CMCC-21", rssi: -80 }, { SSID: "and-Business", rssi: -67 }, { SSID: "wanqin1122", rssi: -77 }, { SSID: "yama", rssi: -72 }, { SSID: "AndroidAP", rssi: -75 }, { SSID: "dandun1", rssi: -75 }, { SSID: "3F-Crestron", rssi: -90 }, { SSID: "siemens_63185", rssi: -70 }, { SSID: "i-Shangwang", rssi: -74 }, { SSID: "ChinaNet", rssi: -51 }, { SSID: "zlk", rssi: -81 }, { SSID: "aWiFi", rssi: -52 }, { SSID: "CMCC", rssi: -71 }, { SSID: "air-freewifi", rssi: -54 }, { SSID: "ChinaNet-DHu5", rssi: -82 }, { SSID: "CMCC-WEB", rssi: -69 }, { SSID: "5j-home", rssi: -91 } ], uuid: "0cb1fb87-847d-3065-95b7-fbde2b151909", os: "Android", type: "Mobile", version: "9", eventtime: new Date(1434442574475), rdurl: "https://wlan.ct10000.com/?basetype=3&nasPortId=lag-1:1660.1814&UserInputURL=http://i-Shanghai.windfindtech.com/ping&nasIp=124.74.56.160", rdd: "356", eventt: 5, site: "default", ct: new Date(1434442669219) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 462ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287654] insert ISH_Fact.FactAppLoginLog query: { _id: ObjectId('557fdbada310a27a4f58d18d'), userid: "54aea9b1a310aa04f73ff010", username: "15821953625", passauthtime: 127, locationinfo: { height: 0.0, precision: 43.0, gps: [ 31.17915153503418, 121.4240264892578 ] }, ispass: true, uuid: "284c15ce-e11e-36a9-8452-a84e802ce607", os: "Android", type: "Mobile", version: "9", eventtime: new Date(1434442569063), eventt: 6, ct: new Date(1434442669361) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 321ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287863] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d18f'), issuc: false, tc: 0, cause: "请输入正确的手机号!", buv: "14dfb721d68-6a60f8b4-bc1c-4416-a988-a0e09316c501", et: new Date(1434442669434) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 250ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287788] command ISH_Fact.$cmd command: insert { insert: "FactPortalADPresent", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d180'), spotid: "new_ishmobile_rotate_B03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.4 KitKat", type: "Smartphone", op: "telecom", buv: "14df7800dc6-c1ea7753-7e8c-4a07-bedd-97ef8848a9bf", un: "13917525672", site: "i-shanghai", et: new Date(1434442669015) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 670ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287856] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginLog", ordered: true, documents: [ { _id: ObjectId('557fdbaca310a27a4f58d17f'), pageid: "success", url: "https://tportal.windfindtech.com/success", os: "Android 4.4 KitKat", type: "Smartphone", op: "telecom", buv: "14df7800dc6-c1ea7753-7e8c-4a07-bedd-97ef8848a9bf", un: "13917525672", site: "i-shanghai", et: new Date(1434442668996) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 688ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287850] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada3107f520555836b'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721ce5-8ab809d9-e0bd-4015-8bc0-907df6b15a76", et: new Date(1434442669286) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 379ms 2015-06-16T16:17:49.683+0800 I WRITE [conn291302] insert ISH_Fact.FactPortalADPresent query: { _id: ObjectId('557fdbada310a27a4f58d188'), spotid: "new_ishmobile_rotate_A03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.1.x Jelly Bean", type: "Smartphone", op: "unicom", buv: "14dfabd5a6b-f9c4bdb5-0630-41ca-b308-ed454d50f188", un: "13311671985", et: new Date(1434442669243) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 431ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn286567] command ISH.$cmd command: update { update: "DimUser_YuYuan", ordered: true, updates: [ { q: { username: "13611736356", devices.mac: "B0:9F:BA:7E:6D:1C" }, u: { $set: { devices.$.lastloginduration: 7211, lut: new Date(1434442669260) } }, upsert: true } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:95 locks:{ Global: { acquireCount: { w: 4 } }, Database: { acquireCount: { w: 4 } }, Collection: { acquireCount: { w: 3 } }, oplog: { acquireCount: { w: 1 } } } 421ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287765] insert ISH_Fact.FactPortalADPresent query: { _id: ObjectId('557fdbada3107f5205558371'), spotid: "new_ishmobile_rotate_B03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14cf90e5e0f-d1a1ccf2-d61b-46f9-9489-4be81fddf75f", un: "15821532332", site: "i-shanghai", et: new Date(1434442669401) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 278ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287849] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f5205558361'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721c27-a73ce8d8-57a1-4bbb-8db9-ac853dfe7a01", et: new Date(1434442669109) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 582ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287858] insert ISH_Fact.FactPortalLoginClickLog query: { _id: ObjectId('557fdbada3107f520555836a'), issuc: false, tc: 0, cause: "请输入正确的手机号!", buv: "14dfb721cd4-4dc07e2f-ee3e-487b-9e87-2114f6eb3db1", et: new Date(1434442669271) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 387ms 2015-06-16T16:17:49.684+0800 I COMMAND [conn291302] command ISH_Fact.$cmd command: insert { insert: "FactPortalADPresent", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d188'), spotid: "new_ishmobile_rotate_A03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.1.x Jelly Bean", type: "Smartphone", op: "unicom", buv: "14dfabd5a6b-f9c4bdb5-0630-41ca-b308-ed454d50f188", un: "13311671985", et: new Date(1434442669243) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 432ms 2015-06-16T16:17:49.682+0800 I WRITE [conn287707] update ISH.DimUser query: { username: "13761277777", devices.mac: "A8:8E:24:4C:CE:6E" } update: { $set: { devices.$.lastloginstatus: 1, devices.$.lastlogintime: new Date(1434442669127), devices.$.lastloginlocation: "Unknown", lut: new Date(1434442669127) } } nscanned:1 nscannedObjects:1 nMatched:1 nModified:1 keyUpdates:0 writeConflicts:0 numYields:1 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 553ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287759] command ISH.$cmd command: update { update: "DimUser", ordered: true, updates: [ { q: { _id: ObjectId('553462e4a310fb8ddf67aae1') }, u: { $set: { ldt: "Android:23134d9ce05c49b047e180e51ce2836cd13ad3e2", lut: new Date(1434442669406) } }, upsert: true } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:95 locks:{ Global: { acquireCount: { w: 4 } }, Database: { acquireCount: { w: 4 } }, Collection: { acquireCount: { w: 3 } }, oplog: { acquireCount: { w: 1 } } } 276ms 2015-06-16T16:17:49.684+0800 I COMMAND [conn287765] command ISH_Fact.$cmd command: insert { insert: "FactPortalADPresent", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f5205558371'), spotid: "new_ishmobile_rotate_B03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14cf90e5e0f-d1a1ccf2-d61b-46f9-9489-4be81fddf75f", un: "15821532332", site: "i-shanghai", et: new Date(1434442669401) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 280ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287714] command ISH_Fact.$cmd command: insert { insert: "FactPortalADPresent", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f5205558368'), spotid: "new_ishmobile_rotate_B03", batchid: "9aa09df5-4929-8bfc-13af-556fbe1dd41c", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14d7a043093-d9bbb62a-c74e-4783-827a-1914eed064bb", un: "15921238331", site: "i-shanghai", et: new Date(1434442669245) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 436ms 2015-06-16T16:17:49.684+0800 I COMMAND [conn287858] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f520555836a'), issuc: false, tc: 0, cause: "请输入正确的手机号!", buv: "14dfb721cd4-4dc07e2f-ee3e-487b-9e87-2114f6eb3db1", et: new Date(1434442669271) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 389ms 2015-06-16T16:17:49.682+0800 I COMMAND [conn291195] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f520555835d'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721bcf-a376f4d4-0845-441f-8cf3-4089f1ee9e8d", et: new Date(1434442669010) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 663ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287638] command ISH.$cmd command: update { update: "DimUser", ordered: true, updates: [ { q: { username: "13052050688", devices.mac: "8C:BE:BE:70:8A:9D" }, u: { $set: { devices.$.lastloginstatus: 0, devices.$.lastlogintime: new Date(1434442669042), devices.$.lastloginlocation: "Unknown", lut: new Date(1434442669042) } }, upsert: true } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:95 locks:{ Global: { acquireCount: { w: 4 } }, Database: { acquireCount: { w: 4 } }, Collection: { acquireCount: { w: 3 } }, oplog: { acquireCount: { w: 1 } } } 640ms 2015-06-16T16:17:49.683+0800 I WRITE [conn287855] insert ISH_Fact.FactPortalLoginLog query: { _id: ObjectId('557fdbada3107f5205558369'), pageid: "success", url: "https://tportal.windfindtech.com/success", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14d7a043093-d9bbb62a-c74e-4783-827a-1914eed064bb", un: "15921238331", site: "i-shanghai", et: new Date(1434442669250) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 435ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn287654] command ISH_Fact.$cmd command: insert { insert: "FactAppLoginLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d18d'), userid: "54aea9b1a310aa04f73ff010", username: "15821953625", passauthtime: 127, locationinfo: { height: 0.0, precision: 43.0, gps: [ 31.17915153503418, 121.4240264892578 ] }, ispass: true, uuid: "284c15ce-e11e-36a9-8452-a84e802ce607", os: "Android", type: "Mobile", version: "9", eventtime: new Date(1434442569063), eventt: 6, ct: new Date(1434442669361) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 322ms 2015-06-16T16:17:49.684+0800 I COMMAND [conn287789] command ISH_Fact.$cmd command: insert { insert: "FactAppLoginLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d186'), userid: "542f4c2ca3104a5b24240cf7", username: "18221039262", passauthtime: 889, locationinfo: { height: 0.0, precision: 0.0, gps: [ 0.0, 0.0 ] }, ispass: true, ssid: [ { SSID: "MERCURY_9F46", rssi: -79 }, { SSID: "i-Shanghai", rssi: -53 }, { SSID: "CMCC-21", rssi: -80 }, { SSID: "and-Business", rssi: -67 }, { SSID: "wanqin1122", rssi: -77 }, { SSID: "yama", rssi: -72 }, { SSID: "AndroidAP", rssi: -75 }, { SSID: "dandun1", rssi: -75 }, { SSID: "3F-Crestron", rssi: -90 }, { SSID: "siemens_63185", rssi: -70 }, { SSID: "i-Shangwang", rssi: -74 }, { SSID: "ChinaNet", rssi: -51 }, { SSID: "zlk", rssi: -81 }, { SSID: "aWiFi", rssi: -52 }, { SSID: "CMCC", rssi: -71 }, { SSID: "air-freewifi", rssi: -54 }, { SSID: "ChinaNet-DHu5", rssi: -82 }, { SSID: "CMCC-WEB", rssi: -69 }, { SSID: "5j-home", rssi: -91 } ], uuid: "0cb1fb87-847d-3065-95b7-fbde2b151909", os: "Android", type: "Mobile", version: "9", eventtime: new Date(1434442574475), rdurl: "https://wlan.ct10000.com/?basetype=3&nasPortId=lag-1:1660.1814&UserInputURL=http://i-Shanghai.windfindtech.com/ping&nasIp=124.74.56.160", rdd: "356", eventt: 5, site: "default", ct: new Date(1434442669219) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 464ms 2015-06-16T16:17:49.684+0800 I COMMAND [conn287850] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f520555836b'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721ce5-8ab809d9-e0bd-4015-8bc0-907df6b15a76", et: new Date(1434442669286) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 380ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn291029] command ISH.$cmd command: update { update: "DimUser", ordered: true, updates: [ { q: { _id: ObjectId('54b1fe55a310aa04f7afce53') }, u: { $set: { llt: new Date(1434442669117), lut: new Date(1434442669102) } }, upsert: true } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:95 locks:{ Global: { acquireCount: { w: 4 } }, Database: { acquireCount: { w: 4 } }, Collection: { acquireCount: { w: 3 } }, oplog: { acquireCount: { w: 1 } } } 579ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn291091] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d182'), issuc: false, tc: 1, cause: "请输入正确的手机号!", buv: "14dfb721c74-2558cd3c-fd3a-47b7-b375-a44d21bc23e9", et: new Date(1434442669176) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 490ms 2015-06-16T16:17:49.683+0800 I COMMAND [conn292268] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginClickLog", ordered: true, documents: [ { _id: ObjectId('557fdbada310a27a4f58d181'), issuc: false, tc: 5, cause: "请输入正确的手机号!", buv: "14dfb721c74-9075098f-2c6e-4963-9fd5-666609db4e3b", et: new Date(1434442669193) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 499ms 2015-06-16T16:17:49.684+0800 I COMMAND [conn287707] command ISH.$cmd command: update { update: "DimUser", ordered: true, updates: [ { q: { username: "13761277777", devices.mac: "A8:8E:24:4C:CE:6E" }, u: { $set: { devices.$.lastloginstatus: 1, devices.$.lastlogintime: new Date(1434442669127), devices.$.lastloginlocation: "Unknown", lut: new Date(1434442669127) } }, upsert: true } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:95 locks:{ Global: { acquireCount: { w: 4 } }, Database: { acquireCount: { w: 4 } }, Collection: { acquireCount: { w: 3 } }, oplog: { acquireCount: { w: 1 } } } 555ms 2015-06-16T16:17:49.685+0800 I COMMAND [conn287855] command ISH_Fact.$cmd command: insert { insert: "FactPortalLoginLog", ordered: true, documents: [ { _id: ObjectId('557fdbada3107f5205558369'), pageid: "success", url: "https://tportal.windfindtech.com/success", os: "Android 4.2 Jelly Bean", type: "Smartphone", op: "telecom", buv: "14d7a043093-d9bbb62a-c74e-4783-827a-1914eed064bb", un: "15921238331", site: "i-shanghai", et: new Date(1434442669250) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 437ms 2015-06-16T16:17:54.948+0800 I QUERY [conn287713] query ISH.DimUser query: { username: "13012886293" } planSummary: IXSCAN { username: 1.0 } ntoskip:0 nscanned:1 nscannedObjects:1 keyUpdates:0 writeConflicts:0 numYields:0 nreturned:1 reslen:765 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 286ms 2015-06-16T16:18:03.060+0800 I NETWORK [conn292931] end connection 10.0.2.102:34951 (205 connections now open) 2015-06-16T16:18:03.060+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:34968 #292933 (206 connections now open) 2015-06-16T16:18:03.099+0800 I ACCESS [conn292933] Successfully authenticated as principal __system on local 2015-06-16T16:18:09.769+0800 I NETWORK [conn292932] end connection 10.0.2.103:37743 (205 connections now open) 2015-06-16T16:18:09.769+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37752 #292934 (206 connections now open) 2015-06-16T16:18:09.806+0800 I ACCESS [conn292934] Successfully authenticated as principal __system on local 2015-06-16T16:18:15.888+0800 I ACCESS [conn143368] Successfully authenticated as principal xudalei on admin 2015-06-16T16:18:33.109+0800 I NETWORK [conn292933] end connection 10.0.2.102:34968 (205 connections now open) 2015-06-16T16:18:33.109+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:34994 #292935 (206 connections now open) 2015-06-16T16:18:33.146+0800 I ACCESS [conn292935] Successfully authenticated as principal __system on local 2015-06-16T16:18:39.819+0800 I NETWORK [conn292934] end connection 10.0.2.103:37752 (205 connections now open) 2015-06-16T16:18:39.819+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37772 #292936 (206 connections now open) 2015-06-16T16:18:39.854+0800 I ACCESS [conn292936] Successfully authenticated as principal __system on local 2015-06-16T16:19:03.155+0800 I NETWORK [conn292935] end connection 10.0.2.102:34994 (205 connections now open) 2015-06-16T16:19:03.155+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:35020 #292937 (206 connections now open) 2015-06-16T16:19:03.191+0800 I ACCESS [conn292937] Successfully authenticated as principal __system on local 2015-06-16T16:19:09.864+0800 I NETWORK [conn292936] end connection 10.0.2.103:37772 (205 connections now open) 2015-06-16T16:19:09.865+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37781 #292938 (206 connections now open) 2015-06-16T16:19:09.900+0800 I ACCESS [conn292938] Successfully authenticated as principal __system on local 2015-06-16T16:19:10.057+0800 I ACCESS [conn143368] Successfully authenticated as principal xudalei on admin 2015-06-16T16:19:33.196+0800 I NETWORK [conn292937] end connection 10.0.2.102:35020 (205 connections now open) 2015-06-16T16:19:33.197+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:35035 #292939 (206 connections now open) 2015-06-16T16:19:33.236+0800 I ACCESS [conn292939] Successfully authenticated as principal __system on local 2015-06-16T16:19:39.909+0800 I NETWORK [conn292938] end connection 10.0.2.103:37781 (205 connections now open) 2015-06-16T16:19:39.910+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37792 #292940 (206 connections now open) 2015-06-16T16:19:39.945+0800 I ACCESS [conn292940] Successfully authenticated as principal __system on local 2015-06-16T16:20:03.246+0800 I NETWORK [conn292939] end connection 10.0.2.102:35035 (205 connections now open) 2015-06-16T16:20:03.246+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:35061 #292941 (206 connections now open) 2015-06-16T16:20:03.281+0800 I ACCESS [conn292941] Successfully authenticated as principal __system on local 2015-06-16T16:20:05.056+0800 I ACCESS [conn143362] Successfully authenticated as principal xudalei on admin 2015-06-16T16:20:09.960+0800 I NETWORK [conn292940] end connection 10.0.2.103:37792 (205 connections now open) 2015-06-16T16:20:09.961+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37811 #292942 (206 connections now open) 2015-06-16T16:20:09.996+0800 I ACCESS [conn292942] Successfully authenticated as principal __system on local 2015-06-16T16:20:33.292+0800 I NETWORK [conn292941] end connection 10.0.2.102:35061 (205 connections now open) 2015-06-16T16:20:33.292+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:35082 #292943 (206 connections now open) 2015-06-16T16:20:33.327+0800 I ACCESS [conn292943] Successfully authenticated as principal __system on local 2015-06-16T16:20:40.020+0800 I NETWORK [conn292942] end connection 10.0.2.103:37811 (205 connections now open) 2015-06-16T16:20:40.020+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37821 #292944 (206 connections now open) 2015-06-16T16:20:40.056+0800 I ACCESS [conn292944] Successfully authenticated as principal __system on local 2015-06-16T16:20:46.640+0800 I QUERY [conn287638] query ISH.DimUser query: { username: "15001999108" } planSummary: IXSCAN { username: 1.0 } ntoskip:0 nscanned:1 nscannedObjects:1 keyUpdates:0 writeConflicts:0 numYields:0 nreturned:1 reslen:609 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 433ms 2015-06-16T16:21:00.043+0800 I ACCESS [conn143368] Successfully authenticated as principal xudalei on admin 2015-06-16T16:21:03.337+0800 I NETWORK [conn292943] end connection 10.0.2.102:35082 (205 connections now open) 2015-06-16T16:21:03.337+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:35100 #292945 (206 connections now open) 2015-06-16T16:21:03.353+0800 I ACCESS [conn292945] Successfully authenticated as principal __system on local 2015-06-16T16:21:04.298+0800 I NETWORK [conn292738] end connection 192.168.1.180:49189 (205 connections now open) 2015-06-16T16:21:10.064+0800 I NETWORK [conn292944] end connection 10.0.2.103:37821 (204 connections now open) 2015-06-16T16:21:10.064+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.103:37830 #292946 (205 connections now open) 2015-06-16T16:21:10.103+0800 I ACCESS [conn292946] Successfully authenticated as principal __system on local 2015-06-16T16:21:16.496+0800 I QUERY [conn287684] query ISH.DimUser query: { username: "13564576136" } planSummary: IXSCAN { username: 1.0 } ntoskip:0 nscanned:1 nscannedObjects:1 keyUpdates:0 writeConflicts:0 numYields:0 nreturned:1 reslen:273 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 681ms 2015-06-16T16:21:17.811+0800 I WRITE [conn287850] insert ISH_Fact.FactSession query: { _id: ObjectId('557fdc7da3107f520555c9ce'), userid: "550033eca310e95501f4557e", begintime: new Date(1434442877514), expirationtime: new Date(1435047677514), uuid: "b14e3599-357a-3dba-a81b-ddaa830875e1", version: "8", platform: "Android", ct: new Date(1434442877517), lut: new Date(1434442877517) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { w: 2 } }, Database: { acquireCount: { w: 2 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 294ms 2015-06-16T16:21:17.812+0800 I COMMAND [conn287850] command ISH_Fact.$cmd command: insert { insert: "FactSession", ordered: true, documents: [ { _id: ObjectId('557fdc7da3107f520555c9ce'), userid: "550033eca310e95501f4557e", begintime: new Date(1434442877514), expirationtime: new Date(1435047677514), uuid: "b14e3599-357a-3dba-a81b-ddaa830875e1", version: "8", platform: "Android", ct: new Date(1434442877517), lut: new Date(1434442877517) } ] } keyUpdates:0 writeConflicts:0 numYields:0 reslen:80 locks:{ Global: { acquireCount: { w: 3 } }, Database: { acquireCount: { w: 3 } }, Collection: { acquireCount: { w: 2 } }, oplog: { acquireCount: { w: 1 } } } 295ms 2015-06-16T16:21:33.361+0800 I NETWORK [conn292945] end connection 10.0.2.102:35100 (204 connections now open) 2015-06-16T16:21:33.361+0800 I NETWORK [initandlisten] connection accepted from 10.0.2.102:35126 #292947 (205 connections now open) 2015-06-16T16:21:33.381+0800 I ACCESS [conn292947] Successfully authenticated as principal __system on local