Skip to content

Instantly share code, notes, and snippets.

/cat.log Secret

Created January 10, 2017 21:04
Show Gist options
  • Save anonymous/db9f8f1b1d66b37596c54dbfb1f8a680 to your computer and use it in GitHub Desktop.
Save anonymous/db9f8f1b1d66b37596c54dbfb1f8a680 to your computer and use it in GitHub Desktop.
Device : asus ASUS_Z00ED (WW_Phone)
Android : 6.0.1 (WW_Phone-13.10.7.1-20160514, MMB29P.WW_Phone-13.10.7.1-20160514)
Memory : 9M (0.57% free, 128M max)
Memclass: 128
OS Host : mcrd1-36
App : Silence 0.14.6
--------- beginning of system
01-10 21:01:19.490 31821 31821 W ViewRootImpl: Dropping event due to root view being removed: MotionEvent { action=ACTION_MOVE, actionButton=0, id[0]=0, x[0]=552.23303, y[0]=804.1405, toolType[0]=TOOL_TYPE_FINGER, buttonState=0, metaState=0, flags=0x0, edgeFlags=0x0, pointerCount=1, historySize=0, eventTime=107706667, downTime=107706657, deviceId=8, source=0x1002 }
--------- beginning of main
01-10 21:53:48.595 4216 4230 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-1 expire 3 lines
01-10 21:53:48.631 4216 5892 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:08.562 4216 4216 I chatty : uid=10022(org.smssecure.smssecure) expire 12 lines
01-10 21:54:24.410 4216 4239 I chatty : uid=10022(org.smssecure.smssecure) AsyncTask #1 expire 1 line
01-10 21:54:28.611 4216 4243 I chatty : uid=10022(org.smssecure.smssecure) AsyncTask #2 expire 1 line
01-10 21:54:50.710 4216 4234 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-4 expire 3 lines
01-10 21:54:50.742 4216 4238 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:50.846 4216 4230 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-1 expire 3 lines
01-10 21:54:50.880 4216 4282 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:51.012 4216 4233 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-3 expire 3 lines
01-10 21:54:51.064 4216 4288 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:51.171 4216 4230 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-1 expire 3 lines
01-10 21:54:51.218 4216 5892 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:51.349 4216 4233 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-3 expire 3 lines
01-10 21:54:51.388 4216 5894 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:51.497 4216 4230 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-1 expire 3 lines
01-10 21:54:51.536 4216 4238 I chatty : uid=10022(org.smssecure.smssecure) ModernAsyncTask expire 1 line
01-10 21:54:58.330 4216 4216 I chatty : uid=10022(org.smssecure.smssecure) expire 5 lines
01-10 21:55:04.676 4216 4233 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-3 expire 4 lines
01-10 21:55:04.732 4216 4230 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-1 expire 2 lines
01-10 21:55:04.819 4216 4234 I chatty : uid=10022(org.smssecure.smssecure) JobConsumer-4 expire 1 line
01-10 21:55:04.837 4216 4234 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 21:55:04.865 4216 4234 W NotificationState: Added thread: 10
01-10 21:55:04.865 4216 4234 W NotificationState: Pending array off intent length: 1
01-10 21:57:48.274 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 21:57:48.275 4216 4282 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 21:57:48.360 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 21:57:48.360 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 21:57:48.373 4216 4285 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 21:57:48.667 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 21:57:48.688 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 21:57:48.688 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 21:57:50.807 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 21:57:50.913 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 21:57:50.913 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 21:57:50.922 4216 4283 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 21:57:55.147 4216 4216 W KeyboardAwareLinearLayout: onKeyboardOpen(576)
01-10 21:58:12.488 4216 4216 W ConversationActivity: isManual Selection: false
01-10 21:58:12.488 4216 4216 W ConversationActivity: forcePlaintext: false
01-10 21:58:12.535 4216 4239 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 21:58:12.560 4216 4229 W ThreadDatabase: Trimming thread: 10 to: 500
01-10 21:58:12.561 4216 4229 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC)
01-10 21:58:12.575 4216 4288 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 21:58:12.584 4216 4228 W MessageDatabase: Updating ID: 277 to base type: 22
01-10 21:58:12.632 4216 4228 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 21:58:12.682 4216 4232 W SmsSendJob: Sending message: 277
01-10 21:58:12.683 4216 4232 W SmsTransportDetails: Padding message body out to: 63
01-10 21:58:12.701 4216 4232 W SmsTransportDetails: Encoded Message Length: 152
01-10 21:58:12.718 4216 4232 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Complete fragment size: 158
01-10 21:58:12.719 4216 4232 W SmsTransport: Secure divide into message parts: 1
01-10 21:58:12.735 4216 5892 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 21:58:12.740 4216 4232 D SmsManager: Asus Phone Team will handle this by itself isSmsSimPickActivityNeeded = false
01-10 21:58:13.093 4216 4232 W SmsSentJob: Got SMS callback: org.smssecure.smssecure.SendReceiveService.SENT_SMS_ACTION , -1
01-10 21:58:13.099 4216 4232 W MessageDatabase: Updating ID: 277 to base type: 23
01-10 21:58:13.116 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 21:58:13.141 4216 5894 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 21:58:42.533 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 21:58:42.561 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 21:58:42.561 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 21:58:42.681 4216 4216 W IInputConnectionWrapper: beginBatchEdit on inactive InputConnection
01-10 21:58:42.681 4216 4216 W IInputConnectionWrapper: endBatchEdit on inactive InputConnection
01-10 21:58:42.684 4216 4216 W IInputConnectionWrapper: beginBatchEdit on inactive InputConnection
01-10 21:58:42.684 4216 4216 W IInputConnectionWrapper: endBatchEdit on inactive InputConnection
01-10 21:59:11.401 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 21:59:11.446 4216 4216 W KeyboardAwareLinearLayout: onKeyboardClose()
01-10 21:59:11.481 4216 4281 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 21:59:11.534 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 21:59:11.534 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 21:59:11.799 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 21:59:11.816 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 21:59:11.816 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 21:59:13.948 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 21:59:14.071 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 21:59:14.071 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 21:59:14.086 4216 4283 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 21:59:14.108 4216 4216 W IInputConnectionWrapper: beginBatchEdit on inactive InputConnection
01-10 21:59:14.119 4216 4216 W IInputConnectionWrapper: endBatchEdit on inactive InputConnection
01-10 21:59:46.354 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 21:59:46.389 4216 4216 W IInputConnectionWrapper: beginBatchEdit on inactive InputConnection
01-10 21:59:46.389 4216 4216 W IInputConnectionWrapper: endBatchEdit on inactive InputConnection
01-10 21:59:46.389 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 21:59:46.389 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:00:27.197 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:27.215 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:27.260 4216 4230 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:00:27.261 4216 4230 W MultipartSmsMessageHandler: Processing single part message...
01-10 22:00:27.293 4216 4230 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:00:27.313 4216 4230 W SmsDecryptJob: manualOverride: false
01-10 22:00:27.314 4216 4233 W ThreadDatabase: Trimming thread: 10 to: 500
01-10 22:00:27.315 4216 4233 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC)
01-10 22:00:27.384 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:00:27.408 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 22:00:27.423 4216 4232 W NotificationState: Added thread: 10
01-10 22:00:27.423 4216 4232 W NotificationState: Pending array off intent length: 1
01-10 22:00:46.355 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:46.369 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:46.414 4216 4232 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:00:46.414 4216 4232 W MultipartSmsMessageHandler: Processing multipart message...
01-10 22:00:46.414 4216 4232 W MultipartSmsMessageHandler: Multipart Count: 3
01-10 22:00:46.414 4216 4232 W MultipartSmsMessageHandler: Multipart ID: 3
01-10 22:00:46.414 4216 4232 W MultipartSmsMessageHandler: Multipart Key: +**********53
01-10 22:00:46.414 4216 4232 W MultipartSmsMessageHandler: Found multipart container: null
01-10 22:00:46.414 4216 4232 W MultipartSmsMessageHandler: Constructing new container...
01-10 22:00:46.415 4216 4232 W MultipartSmsMessageHandler: Filled buffer at index: 0
01-10 22:00:49.649 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:49.664 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:49.705 4216 4232 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:00:49.705 4216 4232 W MultipartSmsMessageHandler: Processing multipart message...
01-10 22:00:49.705 4216 4232 W MultipartSmsMessageHandler: Multipart Count: 3
01-10 22:00:49.705 4216 4232 W MultipartSmsMessageHandler: Multipart ID: 3
01-10 22:00:49.705 4216 4232 W MultipartSmsMessageHandler: Multipart Key: +**********53
01-10 22:00:49.706 4216 4232 W MultipartSmsMessageHandler: Found multipart container: [Size: 3, Initialized: 1484082046414, Exipired: false, Complete: false]
01-10 22:00:49.706 4216 4232 W MultipartSmsMessageHandler: Filled buffer at index: 1
01-10 22:00:54.053 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:54.074 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:00:54.119 4216 4230 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:00:54.119 4216 4230 W MultipartSmsMessageHandler: Processing multipart message...
01-10 22:00:54.119 4216 4230 W MultipartSmsMessageHandler: Multipart Count: 3
01-10 22:00:54.119 4216 4230 W MultipartSmsMessageHandler: Multipart ID: 3
01-10 22:00:54.119 4216 4230 W MultipartSmsMessageHandler: Multipart Key: +**********53
01-10 22:00:54.119 4216 4230 W MultipartSmsMessageHandler: Found multipart container: [Size: 3, Initialized: 1484082046414, Exipired: false, Complete: false]
01-10 22:00:54.119 4216 4230 W MultipartSmsMessageHandler: Filled buffer at index: 2
01-10 22:00:54.152 4216 4230 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:00:54.170 4216 4230 W SmsDecryptJob: manualOverride: false
01-10 22:00:54.171 4216 4233 W ThreadDatabase: Trimming thread: 10 to: 500
01-10 22:00:54.171 4216 4233 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC)
01-10 22:00:54.226 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:00:54.246 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 22:00:54.270 4216 4232 W NotificationState: Added thread: 10
01-10 22:00:54.270 4216 4232 W NotificationState: Pending array off intent length: 1
01-10 22:00:54.625 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 22:00:54.630 4216 4238 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 22:00:54.765 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 22:00:54.765 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 22:00:54.776 4216 4243 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 22:00:55.041 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 22:00:55.066 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 22:00:55.066 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:00:57.419 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 22:00:57.509 4216 4285 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 22:00:57.659 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 22:00:57.659 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 22:00:57.686 4216 4216 W IInputConnectionWrapper: beginBatchEdit on inactive InputConnection
01-10 22:00:57.690 4216 4216 W IInputConnectionWrapper: endBatchEdit on inactive InputConnection
01-10 22:01:04.354 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:01:04.376 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:01:04.424 4216 4229 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Processing multipart message...
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Multipart Count: 3
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Multipart ID: 4
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Multipart Key: +**********54
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Found multipart container: null
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Constructing new container...
01-10 22:01:04.424 4216 4229 W MultipartSmsMessageHandler: Filled buffer at index: 0
01-10 22:01:07.481 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:01:07.507 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:01:07.580 4216 4230 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:01:07.580 4216 4230 W MultipartSmsMessageHandler: Processing multipart message...
01-10 22:01:07.580 4216 4230 W MultipartSmsMessageHandler: Multipart Count: 3
01-10 22:01:07.581 4216 4230 W MultipartSmsMessageHandler: Multipart ID: 4
01-10 22:01:07.581 4216 4230 W MultipartSmsMessageHandler: Multipart Key: +**********54
01-10 22:01:07.587 4216 4230 W MultipartSmsMessageHandler: Found multipart container: [Size: 3, Initialized: 1484082064424, Exipired: false, Complete: false]
01-10 22:01:07.588 4216 4230 W MultipartSmsMessageHandler: Filled buffer at index: 1
01-10 22:01:11.966 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:01:11.983 4216 4216 W SMSListener: Got SMS broadcast...
01-10 22:01:12.022 4216 4229 W org.smssecure.smssecure.sms.MultipartSmsTransportMessage: Decoded message with version: 3
01-10 22:01:12.022 4216 4229 W MultipartSmsMessageHandler: Processing multipart message...
01-10 22:01:12.022 4216 4229 W MultipartSmsMessageHandler: Multipart Count: 3
01-10 22:01:12.023 4216 4229 W MultipartSmsMessageHandler: Multipart ID: 4
01-10 22:01:12.023 4216 4229 W MultipartSmsMessageHandler: Multipart Key: +**********54
01-10 22:01:12.023 4216 4229 W MultipartSmsMessageHandler: Found multipart container: [Size: 3, Initialized: 1484082064424, Exipired: false, Complete: false]
01-10 22:01:12.023 4216 4229 W MultipartSmsMessageHandler: Filled buffer at index: 2
01-10 22:01:12.058 4216 4229 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:01:12.075 4216 4229 W SmsDecryptJob: manualOverride: false
01-10 22:01:12.076 4216 4232 W ThreadDatabase: Trimming thread: 10 to: 500
01-10 22:01:12.076 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC)
01-10 22:01:12.077 4216 4282 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 22:01:12.157 4216 4232 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:01:12.309 4216 4288 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 500)
01-10 22:01:37.883 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 22:01:37.949 4216 4216 W IInputConnectionWrapper: beginBatchEdit on inactive InputConnection
01-10 22:01:37.949 4216 4216 W IInputConnectionWrapper: endBatchEdit on inactive InputConnection
01-10 22:01:37.949 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 22:01:37.949 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:04:34.057 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 22:04:34.129 4216 4239 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 22:04:34.254 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 22:04:34.254 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 22:04:34.425 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 22:04:34.430 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 22:04:34.431 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:04:36.486 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 22:04:36.633 4216 4281 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (read = 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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) ORDER BY date_received ASC)
01-10 22:04:36.777 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 22:04:36.777 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 22:04:40.128 4216 4216 W ConversationActivity: onBackPressed()
01-10 22:04:40.132 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 22:04:40.139 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 22:04:40.139 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:04:40.140 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 22:04:40.256 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 22:04:40.256 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 22:04:40.594 4216 4216 W PassphraseRequiredActionBarActivity: onDestroy()
01-10 22:04:40.598 4216 4283 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, date_delivery_received, mismatched_identities, network_failures, subscription_id, transport_type, attachment_id, unique_id, mid, data_size, _data, ct, cl, 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, date_delivery_received, mismatched_identities, subscription_id, NULL AS network_failures, 'sms' AS transport_type, NULL AS unique_id, NULL AS mid, NULL AS data_size, NULL AS _data, NULL AS ct, NULL AS cl, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 10) 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, date_delivery_received, mismatched_identities, subscription_id, network_failures, 'mms' AS transport_type, unique_id, NULL AS mid, data_size, NULL AS _data, ct, cl, 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 = 10) ORDER BY date_received DESC LIMIT 1)
01-10 22:04:41.368 4216 4216 W art : Before Android 4.1, method int android.support.v7.internal.widget.ListViewCompat.lookForSelectablePosition(int, boolean) would have incorrectly overridden the package-private method in android.widget.ListView
01-10 22:04:42.647 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 22:04:42.659 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 22:04:42.659 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:04:42.664 4216 4216 W PassphraseRequiredActionBarActivity: onCreate(null)
01-10 22:04:42.667 4216 4216 W PassphraseRequiredActionBarActivity: routeApplicationState(), state: 0
01-10 22:04:42.668 4216 4216 V Monotype: SetAppTypeFace- try to flip, app = org.smssecure.smssecure
01-10 22:04:42.670 4216 4216 V Monotype: Typeface getFontPathFlipFont - systemFont = default#default
01-10 22:04:42.677 4216 4216 W PassphraseRequiredActionBarActivity: initializeClearKeyReceiver()
01-10 22:04:42.679 4216 4216 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@b87c147
01-10 22:04:42.679 4216 4216 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@99b1d74
01-10 22:04:42.710 4216 4216 W PassphraseRequiredActionBarActivity: onResume()
01-10 22:04:42.827 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_START_EVENT
01-10 22:04:42.827 4216 4216 W KeyCachingService: Incrementing activity count...
01-10 22:04:42.994 4216 4240 D OpenGLRenderer: endAllStagingAnimators on 0xabe31770 (ListPopupWindow$DropDownListView) with handle 0xaba09ca0
01-10 22:04:48.550 4216 4216 W PassphraseRequiredActionBarActivity: onPause()
01-10 22:04:48.562 4216 4216 W KeyCachingService: onStartCommand, org.smssecure.smssecure.service.action.ACTIVITY_STOP_EVENT
01-10 22:04:48.562 4216 4216 W KeyCachingService: Decrementing activity count...
01-10 22:04:48.566 4216 4216 V Monotype: SetAppTypeFace- try to flip, app = org.smssecure.smssecure
01-10 22:04:48.566 4216 4216 V Monotype: Typeface getFontPathFlipFont - systemFont = default#default
01-10 22:04:48.579 4216 4216 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@f077cef
01-10 22:04:48.579 4216 4216 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@e1b33fc
01-10 22:04:48.590 4216 4216 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@9cf50a6
01-10 22:04:48.590 4216 4216 V BoostFramework: BoostFramework() : mPerf = com.qualcomm.qti.Performance@e3c1ae7
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment