Skip to content

Instantly share code, notes, and snippets.

/cat.log Secret

Created April 3, 2017 03:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/82d2de9458370bc2d78595f65a24ce4f to your computer and use it in GitHub Desktop.
Save anonymous/82d2de9458370bc2d78595f65a24ce4f to your computer and use it in GitHub Desktop.
Device : ZTE ZTE A2017U (P996A01_N)
Android : 7.0 (20170128.052618, A2017UV1.1.0B15)
Memory : 27M (29.03% free, 512M max)
Memclass: 384
OS Host : ztesuper23
App : Signal 4.1.0
--------- beginning of system
04-02 20:57:24.610 6543 16396 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:57:36.640 6543 6569 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:57:38.160 6543 6569 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:57:46.710 6543 6568 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:57:50.100 6543 6568 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:58:05.380 6543 6571 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:58:19.440 6543 6569 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:58:22.500 6543 6570 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:58:27.500 6543 6567 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:58:28.880 6543 6543 I Activity: ----destroy = ConversationActivity
04-02 20:58:29.180 6543 17608 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:59:12.550 6543 6543 I Activity: ----destroy = ConversationActivity
04-02 20:59:16.310 6543 6567 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:59:18.740 6543 6567 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:59:23.850 6543 6569 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 20:59:24.230 6543 6567 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:00:07.710 6543 6568 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:00:20.900 6543 6568 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:02:19.840 6543 19875 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:03:03.280 6543 19875 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:03:04.660 6543 6543 I Activity: ----destroy = ConversationActivity
04-02 21:03:05.010 6543 6543 I Activity: ----destroy = ConversationListActivity
04-02 21:03:06.140 6543 6571 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:03:07.080 20223 20253 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:03:07.240 20223 20223 I Activity: ----destroy = DummyActivity
04-02 21:03:07.860 20223 20323 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:03:17.100 20223 20223 I Activity: ----destroy = ConversationActivity
04-02 21:03:46.600 20223 20223 I Activity: ----destroy = LogSubmitActivity
04-02 21:03:50.340 20223 20247 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:03:50.360 20223 20223 I Activity: ----destroy = ApplicationPreferencesActivity
--------- beginning of main
04-02 21:03:52.700 20223 20223 W KeyboardAwareLinearLayout: onKeyboardOpen(998)
04-02 21:03:52.710 20223 20223 W CameraView: skipping layout due to zero-width/height preview size
04-02 21:03:55.500 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:55.500 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:55.720 20223 20325 D OpenGLRenderer: endAllActiveAnimators on 0xd6772c80 (RippleDrawable) with handle 0xd6519270
04-02 21:03:56.670 20223 20223 W ConversationActivity: isManual Selection: false
04-02 21:03:56.670 20223 20223 W ConversationActivity: forceSms: false
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: Error type: TOO_LONG. The string supplied is too long to be a phone number.
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at com.google.i18n.phonenumbers.PhoneNumberUtil.parseHelper(PhoneNumberUtil.java:3056)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at com.google.i18n.phonenumbers.PhoneNumberUtil.parse(PhoneNumberUtil.java:2847)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at com.google.i18n.phonenumbers.PhoneNumberUtil.parse(PhoneNumberUtil.java:2837)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at org.whispersystems.signalservice.api.util.PhoneNumberFormatter.formatNumber(PhoneNumberFormatter.java:97)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at org.thoughtcrime.securesms.util.Util.canonicalizeNumber(Util.java:179)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at org.thoughtcrime.securesms.database.MmsDatabase.insertMessageOutbox(MmsDatabase.java:914)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at org.thoughtcrime.securesms.sms.MessageSender.send(MessageSender.java:105)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at org.thoughtcrime.securesms.ConversationActivity$27.doInBackground(ConversationActivity.java:1513)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at org.thoughtcrime.securesms.ConversationActivity$27.doInBackground(ConversationActivity.java:1510)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at android.os.AsyncTask$2.call(AsyncTask.java:304)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at java.util.concurrent.FutureTask.run(FutureTask.java:237)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:243)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)
04-02 21:03:56.680 20223 20323 W PhoneNumberFormatter: at java.lang.Thread.run(Thread.java:761)
04-02 21:03:56.680 20223 20323 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3af0f31
04-02 21:03:56.680 20223 20323 W EarlyReceiptCache: Checking early receipts (1491181436678, +*************555746324): null
04-02 21:03:56.690 20223 20323 W AttachmentDatabase: insertParts(0)
04-02 21:03:56.710 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:56.710 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:56.710 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:56.710 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:56.710 20223 20371 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:03:56.720 20223 20323 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:03:56.720 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:03:56.750 20223 20223 W ConversationAdapter: Inflate time: 15
04-02 21:03:56.870 20223 20223 W ConversationAdapter: Bind time: 118
04-02 21:03:56.900 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:56.900 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:03:56.900 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@227197c
04-02 21:03:56.900 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@651d205
04-02 21:03:56.930 20223 20233 I art : Background partial concurrent mark sweep GC freed 49368(2MB) AllocSpace objects, 4(488KB) LOS objects, 39% free, 18MB/30MB, paused 3.272ms total 105.177ms
04-02 21:03:57.070 20223 20239 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:57.070 20223 20239 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:57.070 20223 20239 W SignalServiceMessageSender: No attachments present...
04-02 21:03:57.080 20223 20239 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:03:57.340 20223 20223 W ConversationAdapter: Bind time: 2
04-02 21:03:57.860 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:03:57.860 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:03:57.890 20223 20239 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:03:57.910 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:03:57.910 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:03:57.920 20223 20250 W SignalServiceEnvelope: Our MAC: df 83 27 14 2c dc 46 e6 4b 9c
04-02 21:03:57.920 20223 20250 W SignalServiceEnvelope: Thr MAC: df 83 27 14 2c dc 46 e6 4b 9c
04-02 21:03:57.920 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:03:57.920 20223 20250 W PushReceivedJob: Received receipt: (XXXXX, 1491181436678)
04-02 21:03:57.930 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:57.930 20223 20250 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@e600a26
04-02 21:03:57.930 20223 20250 W EarlyReceiptCache: Early receipt: 1491181436678,+*********35
04-02 21:03:57.930 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:57.950 20223 20250 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:03:57.970 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:03:57.970 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:03:57.970 20223 20374 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:03:57.990 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:03:58.060 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:03:58.060 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:03:58.060 20223 20250 W SignalServiceEnvelope: Our MAC: 23 6c 7c 96 de 6a c9 27 28 00
04-02 21:03:58.060 20223 20250 W SignalServiceEnvelope: Thr MAC: 23 6c 7c 96 de 6a c9 27 28 00
04-02 21:03:58.060 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:03:58.060 20223 20250 W PushReceivedJob: Received receipt: (XXXXX, 1491181436678)
04-02 21:03:58.060 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:58.060 20223 20250 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@e600a26
04-02 21:03:58.060 20223 20250 W EarlyReceiptCache: Early receipt: 1491181436678,+*********35
04-02 21:03:58.070 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:03:58.110 20223 20250 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:03:58.140 20223 20223 W ConversationAdapter: Bind time: 134
04-02 21:03:58.150 20223 20223 W ConversationAdapter: Bind time: 2
04-02 21:03:58.160 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:03:58.160 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:03:58.170 20223 20410 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:03:58.190 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:03:58.360 20223 20223 W ConversationAdapter: Bind time: 150
04-02 21:03:58.360 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:03:58.660 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:03:58.660 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:03:58.660 20223 20239 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:00.090 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:00.090 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:00.090 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:00.090 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:00.090 20223 20250 W SignalServiceEnvelope: Our MAC: 79 0e c1 4d a2 b6 9f 01 bc 29
04-02 21:04:00.090 20223 20250 W SignalServiceEnvelope: Thr MAC: 79 0e c1 4d a2 b6 9f 01 bc 29
04-02 21:04:00.100 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********64
04-02 21:04:00.100 20223 20250 W PushReceivedJob: Received receipt: (XXXXX, 1491181436678)
04-02 21:04:00.120 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:00.120 20223 20250 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@e600a26
04-02 21:04:00.120 20223 20250 W EarlyReceiptCache: Early receipt: 1491181436678,+*********64
04-02 21:04:00.120 20223 20239 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:00.140 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:00.150 20223 20420 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:00.160 20223 20250 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:00.170 20223 20324 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:00.180 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:00.190 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:00.190 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:00.340 20223 20223 W ConversationAdapter: Bind time: 141
04-02 21:04:00.370 20223 20374 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:00.390 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:00.530 20223 20223 W ConversationAdapter: Bind time: 130
04-02 21:04:01.330 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:01.330 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:02.290 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:02.290 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:02.840 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:02.840 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:02.840 20223 20250 W SignalServiceEnvelope: Our MAC: 6f 99 4c b7 c2 11 45 26 0e 28
04-02 21:04:02.840 20223 20250 W SignalServiceEnvelope: Thr MAC: 6f 99 4c b7 c2 11 45 26 0e 28
04-02 21:04:02.840 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:02.870 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:02.870 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:02.970 20223 20240 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:03.030 20223 20240 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:03.060 20223 20410 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:03.070 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:03.090 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:03.110 20223 20323 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:03.110 20223 20240 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:03.220 20223 20223 W ConversationAdapter: Bind time: 127
04-02 21:04:03.260 20223 20324 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:03.280 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:03.290 20223 20376 W WebSocketConnection: Sending keep alive...
04-02 21:04:03.290 20223 20223 W ConversationAdapter: Bind time: 8
04-02 21:04:03.390 20223 20223 W ConversationAdapter: Bind time: 100
04-02 21:04:03.430 20223 20238 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:04.180 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:04.180 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:04.180 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:04.180 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:04.180 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:04.180 20223 20250 W SignalServiceEnvelope: Our MAC: 47 25 89 8d 7d 79 9b df cf c0
04-02 21:04:04.180 20223 20250 W SignalServiceEnvelope: Thr MAC: 47 25 89 8d 7d 79 9b df cf c0
04-02 21:04:04.190 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:04.190 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:04.210 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:04.210 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:04.330 20223 20239 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:04.400 20223 20239 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:04.430 20223 20371 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:04.460 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:04.470 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:04.480 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:04.500 20223 20239 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:04.500 20223 20323 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:04.620 20223 20223 W ConversationAdapter: Bind time: 137
04-02 21:04:04.650 20223 20374 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:04.660 20223 20410 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:04.660 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:04.680 20223 20223 W ConversationAdapter: Bind time: 8
04-02 21:04:04.680 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:04.770 20223 20223 W ConversationAdapter: Bind time: 86
04-02 21:04:04.850 20223 20239 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:04.920 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:04.920 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:05.820 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:05.820 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:05.970 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:05.970 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.010 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.010 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.130 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.130 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.160 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.160 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.200 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.200 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.400 20223 20223 W ConversationActivity: isManual Selection: false
04-02 21:04:06.400 20223 20223 W ConversationActivity: forceSms: false
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: Error type: TOO_LONG. The string supplied is too long to be a phone number.
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at com.google.i18n.phonenumbers.PhoneNumberUtil.parseHelper(PhoneNumberUtil.java:3056)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at com.google.i18n.phonenumbers.PhoneNumberUtil.parse(PhoneNumberUtil.java:2847)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at com.google.i18n.phonenumbers.PhoneNumberUtil.parse(PhoneNumberUtil.java:2837)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at org.whispersystems.signalservice.api.util.PhoneNumberFormatter.formatNumber(PhoneNumberFormatter.java:97)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at org.thoughtcrime.securesms.util.Util.canonicalizeNumber(Util.java:179)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at org.thoughtcrime.securesms.database.MmsDatabase.insertMessageOutbox(MmsDatabase.java:914)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at org.thoughtcrime.securesms.sms.MessageSender.send(MessageSender.java:105)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at org.thoughtcrime.securesms.ConversationActivity$27.doInBackground(ConversationActivity.java:1513)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at org.thoughtcrime.securesms.ConversationActivity$27.doInBackground(ConversationActivity.java:1510)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at android.os.AsyncTask$2.call(AsyncTask.java:304)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at java.util.concurrent.FutureTask.run(FutureTask.java:237)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:243)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)
04-02 21:04:06.420 20223 20247 W PhoneNumberFormatter: at java.lang.Thread.run(Thread.java:761)
04-02 21:04:06.420 20223 20247 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3af0f31
04-02 21:04:06.420 20223 20247 W EarlyReceiptCache: Checking early receipts (1491181446412, +*************555746324): null
04-02 21:04:06.420 20223 20247 W AttachmentDatabase: insertParts(0)
04-02 21:04:06.440 20223 20247 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:06.460 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.460 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.460 20223 20420 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:06.460 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.460 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.480 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:06.510 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:06.520 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:06.520 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:06.630 20223 20223 W ConversationAdapter: Bind time: 109
04-02 21:04:06.660 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.660 20223 20223 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
04-02 21:04:06.770 20223 20241 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:06.770 20223 20241 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:06.770 20223 20241 W SignalServiceMessageSender: No attachments present...
04-02 21:04:06.780 20223 20241 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:07.150 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:07.150 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:07.170 20223 20241 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:07.670 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:07.670 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:07.670 20223 20250 W SignalServiceEnvelope: Our MAC: a3 fd c2 1e 54 5f 53 a0 90 a2
04-02 21:04:07.670 20223 20250 W SignalServiceEnvelope: Thr MAC: a3 fd c2 1e 54 5f 53 a0 90 a2
04-02 21:04:07.670 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:07.670 20223 20250 W PushReceivedJob: Received receipt: (XXXXX, 1491181446412)
04-02 21:04:07.680 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:07.680 20223 20250 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@e600a26
04-02 21:04:07.680 20223 20250 W EarlyReceiptCache: Early receipt: 1491181446412,+*********35
04-02 21:04:07.690 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:07.710 20223 20250 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:07.730 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:07.730 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:07.740 20223 20324 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:07.750 20223 20223 W KeyboardAwareLinearLayout: onKeyboardClose()
04-02 21:04:07.760 20223 20223 W CameraView: skipping layout due to zero-width/height preview size
04-02 21:04:07.780 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:07.780 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:07.790 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:07.790 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:07.900 20223 20223 W ConversationAdapter: Bind time: 108
04-02 21:04:07.970 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:07.970 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:07.970 20223 20250 W SignalServiceEnvelope: Our MAC: c3 57 85 ff c6 46 24 ca 0e bb
04-02 21:04:07.970 20223 20250 W SignalServiceEnvelope: Thr MAC: c3 57 85 ff c6 46 24 ca 0e bb
04-02 21:04:07.980 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:07.990 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:07.990 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:08.000 20223 20241 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:08.010 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:08.020 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:08.030 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:08.030 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:08.030 20223 20250 W SignalServiceEnvelope: Our MAC: 4c 03 06 c8 43 a8 fa 9b fa 7e
04-02 21:04:08.030 20223 20250 W SignalServiceEnvelope: Thr MAC: 4c 03 06 c8 43 a8 fa 9b fa 7e
04-02 21:04:08.030 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:08.030 20223 20250 W PushReceivedJob: Received receipt: (XXXXX, 1491181446412)
04-02 21:04:08.040 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:08.040 20223 20250 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@e600a26
04-02 21:04:08.040 20223 20250 W EarlyReceiptCache: Early receipt: 1491181446412,+*********35
04-02 21:04:08.040 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:08.050 20223 20250 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:08.070 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:08.070 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:08.070 20223 20371 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:08.090 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:08.110 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.110 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.110 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.140 20223 20242 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:08.200 20223 20242 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:08.250 20223 20223 W ConversationAdapter: Bind time: 136
04-02 21:04:08.260 20223 20242 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:08.280 20223 20374 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:08.290 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:08.330 20223 20223 W ConversationAdapter: Bind time: 23
04-02 21:04:08.330 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.340 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.340 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:08.450 20223 20223 W ConversationAdapter: Bind time: 112
04-02 21:04:08.480 20223 20410 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:08.490 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:08.500 20223 20223 W ConversationAdapter: Bind time: 2
04-02 21:04:08.500 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:08.510 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.510 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:08.640 20223 20240 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:08.650 20223 20223 W ConversationAdapter: Bind time: 137
04-02 21:04:09.010 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:09.010 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:09.010 20223 20250 W SignalServiceEnvelope: Our MAC: 09 8f a8 e8 0e c1 59 9b ff c3
04-02 21:04:09.010 20223 20250 W SignalServiceEnvelope: Thr MAC: 09 8f a8 e8 0e c1 59 9b ff c3
04-02 21:04:09.010 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********64
04-02 21:04:09.020 20223 20250 W PushReceivedJob: Received receipt: (XXXXX, 1491181446412)
04-02 21:04:09.020 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:09.020 20223 20250 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@e600a26
04-02 21:04:09.020 20223 20250 W EarlyReceiptCache: Early receipt: 1491181446412,+*********64
04-02 21:04:09.030 20223 20250 W PhoneNumberFormatter: Got local CC: CA
04-02 21:04:09.040 20223 20250 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:09.070 20223 20223 W ConversationAdapter: Bind time: 3
04-02 21:04:09.070 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:09.070 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:09.080 20223 20420 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:09.110 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:09.110 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.110 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.120 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.120 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.190 20223 20223 W ConversationAdapter: Bind time: 71
04-02 21:04:09.510 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:09.510 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:09.510 20223 20250 W SignalServiceEnvelope: Our MAC: b6 cc b2 17 fe 8f ef 70 10 63
04-02 21:04:09.510 20223 20250 W SignalServiceEnvelope: Thr MAC: b6 cc b2 17 fe 8f ef 70 10 63
04-02 21:04:09.510 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:09.540 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:09.540 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:09.610 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:09.610 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:09.610 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:09.610 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:09.640 20223 20241 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:09.640 20223 20238 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:09.680 20223 20324 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:09.710 20223 20238 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:09.720 20223 20371 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:09.750 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:09.760 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.770 20223 20238 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:09.770 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.770 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.770 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.780 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.850 20223 20253 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:09.890 20223 20223 W ConversationAdapter: Bind time: 112
04-02 21:04:09.900 20223 20410 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:09.910 20223 20324 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:09.920 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:09.940 20223 20223 W ConversationAdapter: Bind time: 14
04-02 21:04:09.950 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.950 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:09.950 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:09.950 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:10.030 20223 20223 W ConversationAdapter: Bind time: 75
04-02 21:04:10.060 20223 20238 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:11.250 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:11.250 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:12.480 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:12.480 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:12.480 20223 20250 W SignalServiceEnvelope: Our MAC: 67 2c 9c 6f 84 00 76 91 53 f2
04-02 21:04:12.480 20223 20250 W SignalServiceEnvelope: Thr MAC: 67 2c 9c 6f 84 00 76 91 53 f2
04-02 21:04:12.480 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:12.500 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:12.500 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:12.590 20223 20241 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:12.660 20223 20241 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:12.670 20223 20371 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:12.690 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:12.710 20223 20241 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:12.720 20223 20223 W ConversationAdapter: Inflate time: 23
04-02 21:04:12.720 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.730 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.730 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.730 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.730 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.740 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:12.740 20223 20323 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:12.860 20223 20223 W ConversationAdapter: Bind time: 119
04-02 21:04:12.870 20223 20374 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:12.880 20223 20410 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:12.890 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:12.910 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.920 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:12.920 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:12.920 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:12.920 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:12.920 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:13.000 20223 20223 W ConversationAdapter: Bind time: 78
04-02 21:04:13.170 20223 20240 W SignalServiceMessageSender: Transmitting over pipe...
04-02 21:04:14.310 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:14.310 20223 20326 W WebSocketConnection: Message Type: 2
04-02 21:04:19.360 20223 20223 W ConversationActivity: onBackPressed()
04-02 21:04:19.380 20223 20223 W PassphraseRequiredActionBarActivity: onPause()
04-02 21:04:19.430 20223 20223 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_STOP_EVENT
04-02 21:04:19.430 20223 20223 W KeyCachingService: Decrementing activity count...
04-02 21:04:19.430 20223 20223 W MessageRetrievalService: Active Count: 0
04-02 21:04:19.450 20223 20223 W PassphraseRequiredActionBarActivity: onResume()
04-02 21:04:19.480 20223 20253 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:19.540 20223 20223 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_START_EVENT
04-02 21:04:19.540 20223 20223 W KeyCachingService: Incrementing activity count...
04-02 21:04:19.540 20223 20223 W MessageRetrievalService: Active Count: 1
04-02 21:04:19.690 20223 20223 W IInputConnectionWrapper: finishComposingText on inactive InputConnection
04-02 21:04:19.950 20223 20326 W WebSocketConnection: WSC onMessage()
04-02 21:04:19.950 20223 20326 W WebSocketConnection: Message Type: 1
04-02 21:04:19.960 20223 20250 W SignalServiceEnvelope: Our MAC: d7 77 53 6e 14 af 09 07 c1 41
04-02 21:04:19.960 20223 20250 W SignalServiceEnvelope: Thr MAC: d7 77 53 6e 14 af 09 07 c1 41
04-02 21:04:19.960 20223 20250 W MessageRetrievalService: Retrieved envelope! +*********35
04-02 21:04:19.980 20223 20250 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
04-02 21:04:19.980 20223 20250 W MessageRetrievalService: Reading message...
04-02 21:04:20.140 20223 20239 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:20.160 20223 20239 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 0 AND notified = 0) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (read = 0 AND notified = 0) ORDER BY date_received ASC)
04-02 21:04:20.170 20223 20374 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 500)
04-02 21:04:20.170 20223 20239 W NotificationState: Added thread: 20
04-02 21:04:20.180 20223 20223 W ConversationFragment: onLoadFinished
04-02 21:04:20.180 20223 20239 W NotificationState: getAndroidAutoHeardIntent Added thread: 20
04-02 21:04:20.200 20223 20223 W ConversationAdapter: Bind time: 0
04-02 21:04:20.200 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:20.210 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:20.210 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:20.210 20223 20223 W ConversationAdapter: Bind time: 1
04-02 21:04:20.240 20223 20239 E ActivityThread: Failed to find provider info for com.teslacoilsw.notifier
04-02 21:04:20.330 20223 20223 W ConversationAdapter: Bind time: 115
04-02 21:04:24.050 20223 20223 W PassphraseRequiredActionBarActivity: onPause()
04-02 21:04:24.110 20223 20223 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_STOP_EVENT
04-02 21:04:24.110 20223 20223 W KeyCachingService: Decrementing activity count...
04-02 21:04:24.110 20223 20223 W MessageRetrievalService: Active Count: 0
04-02 21:04:24.110 20223 20223 W PassphraseRequiredActionBarActivity: onCreate(null)
04-02 21:04:24.120 20223 20223 W ExperienceUpgradeActivity: getExperienceUpgrade(245)
04-02 21:04:24.120 20223 20223 W PassphraseRequiredActionBarActivity: routeApplicationState(), state: 0
04-02 21:04:24.120 20223 20223 W PassphraseRequiredActionBarActivity: initializeClearKeyReceiver()
04-02 21:04:24.130 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@d85b536
04-02 21:04:24.130 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@ce8cc37
04-02 21:04:24.160 20223 20223 W PassphraseRequiredActionBarActivity: onResume()
04-02 21:04:24.170 20223 20223 W asset : addOverlayPath: packagePath: /data/resource-cache/theme/default_theme_05/com.android.mms/, idmapPath Path: /data/resource-cache/theme/default_theme_05/com.android.mms/idmap, resApkPath /data/resource-cache/theme/default_theme_05/com.android.mms/resources.apk
04-02 21:04:24.210 20223 20223 W EventBus: Subscriber to unregister was not registered before: class org.thoughtcrime.securesms.ConversationActivity
04-02 21:04:24.210 20223 20223 W PassphraseRequiredActionBarActivity: onDestroy()
04-02 21:04:24.210 20223 20247 W MmsSmsDatabase: Executing query: SELECT _id, unique_row_id, body, type, thread_id, address, address_device_id, subject, date_sent, date_received, m_type, msg_box, status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, network_failures, subscription_id, expires_in, expire_started, notified, transport_type, attachment_id, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM (SELECT DISTINCT date_sent AS date_sent, date AS date_received, _id, 'SMS::' || _id || '::' || date_sent AS unique_row_id, NULL AS attachment_id, body, read, thread_id, type, address, address_device_id, subject, NULL AS m_type, NULL AS msg_box, status, NULL AS part_count, NULL AS ct_l, NULL AS tr_id, NULL AS m_size, NULL AS exp, NULL AS st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 20) UNION ALL SELECT DISTINCT date AS date_sent, date_received AS date_received, mms._id AS _id, 'MMS::' || mms._id || '::' || date AS unique_row_id, part._id AS attachment_id, body, read, thread_id, NULL AS type, address, address_device_id, NULL AS subject, m_type, msg_box, NULL AS status, part_count, ct_l, tr_id, m_size, exp, st, delivery_receipt_count, mismatched_identities, subscription_id, expires_in, expire_started, notified, network_failures, 'mms' AS transport_type, unique_id, mid, data_size, _data, thumbnail, ct, cl, digest, cd, name, pending_push FROM mms LEFT OUTER JOIN part ON part._id = (SELECT part._id FROM part WHERE part.mid = mms._id LIMIT 1) WHERE (thread_id = 20) ORDER BY date_received DESC LIMIT 1)
04-02 21:04:24.210 20223 20223 I Activity: ----destroy = ConversationActivity
04-02 21:04:24.290 20223 20223 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_START_EVENT
04-02 21:04:24.290 20223 20223 W KeyCachingService: Incrementing activity count...
04-02 21:04:24.300 20223 20223 W MessageRetrievalService: Active Count: 1
04-02 21:04:24.380 20223 20325 D OpenGLRenderer: endAllActiveAnimators on 0xcf567e00 (MenuPopupWindow$MenuDropDownListView) with handle 0xd2575cd0
04-02 21:04:28.350 20223 20223 W PassphraseRequiredActionBarActivity: onPause()
04-02 21:04:28.390 20223 20223 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_STOP_EVENT
04-02 21:04:28.400 20223 20223 W KeyCachingService: Decrementing activity count...
04-02 21:04:28.400 20223 20223 W MessageRetrievalService: Active Count: 0
04-02 21:04:28.420 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@4642b78
04-02 21:04:28.420 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@ab54251
04-02 21:04:28.440 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@6922453
04-02 21:04:28.440 20223 20223 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@e7cf190
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment