Skip to content

Instantly share code, notes, and snippets.

@deutrino
Created September 28, 2017 04:39
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 deutrino/ece7e35b4408140e5b5301b92d7f01fd to your computer and use it in GitHub Desktop.
Save deutrino/ece7e35b4408140e5b5301b92d7f01fd to your computer and use it in GitHub Desktop.
iOS Signal problem log - android side
Device : motorola XT1575 (Moto X Pure Edition)
Android : 7.1.2 (be7d1fe92b, lineage_clark-userdebug 7.1.2 NJH47F be7d1fe92b)
Memory : 26M (2.28% free, 768M max)
Memclass: 288
OS Host : phenom.zifnab.net
App : Signal 4.10.12
--------- beginning of main
09-27 21:00:36.890 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 10 lines
09-27 21:00:36.932 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 13 lines
09-27 21:00:37.638 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 24 lines
09-27 21:01:21.100 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 16 lines
09-27 21:01:38.046 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 12 lines
09-27 21:01:43.076 15495 22657 I chatty : uid=10176(org.thoughtcrime.securesms) pool-5-thread-1 expire 6 lines
09-27 21:02:09.707 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 13 lines
09-27 21:02:41.754 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 16 lines
09-27 21:04:04.465 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 10 lines
09-27 21:05:18.928 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 10 lines
09-27 21:06:56.647 15495 16718 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 2 lines
09-27 21:06:56.702 15495 23267 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:06:56.716 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 107 lines
09-27 21:06:56.824 15495 23268 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:06:56.838 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 21 lines
09-27 21:06:57.181 15495 16719 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 2 lines
09-27 21:06:57.245 15495 23282 I chatty : uid=10176(org.thoughtcrime.securesms) expire 4 lines
09-27 21:06:57.295 15495 16711 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:06:57.311 15495 23273 I chatty : uid=10176(org.thoughtcrime.securesms) expire 13 lines
09-27 21:07:01.702 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 7 lines
09-27 21:07:01.713 15495 16715 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:07:02.614 15495 16683 I chatty : uid=10176(org.thoughtcrime.securesms) RenderThread expire 2 lines
09-27 21:07:52.318 15495 23287 I chatty : uid=10176(org.thoughtcrime.securesms) expire 2 lines
09-27 21:08:18.398 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 43 lines
09-27 21:08:18.518 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 5 lines
09-27 21:08:18.990 15495 23401 I chatty : uid=10176(org.thoughtcrime.securesms) expire 5 lines
09-27 21:08:23.557 15495 16679 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:08:23.570 15495 23410 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:08:23.632 15495 23400 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:08:32.596 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 62 lines
09-27 21:08:46.125 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 4 lines
09-27 21:08:53.882 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 45 lines
09-27 21:08:54.854 15495 23409 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:08:54.966 15495 16719 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:08:54.967 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 11 lines
09-27 21:08:55.103 15495 23401 I chatty : uid=10176(org.thoughtcrime.securesms) expire 14 lines
09-27 21:08:55.261 15495 16711 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:08:55.295 15495 16679 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:09:04.879 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 13 lines
09-27 21:09:05.359 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 5 lines
09-27 21:09:05.375 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 20 lines
09-27 21:09:13.994 15495 23404 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:09:52.706 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 4 lines
09-27 21:09:53.343 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 6 lines
09-27 21:09:55.225 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 4 lines
09-27 21:10:03.677 15495 23578 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:10:03.724 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 59 lines
09-27 21:10:03.848 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 10 lines
09-27 21:10:04.281 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 11 lines
09-27 21:10:06.209 15495 16718 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 5 lines
09-27 21:10:06.216 15495 23588 I chatty : uid=10176(org.thoughtcrime.securesms) expire 4 lines
09-27 21:10:06.282 15495 23579 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:10:06.663 15495 16683 I chatty : uid=10176(org.thoughtcrime.securesms) RenderThread expire 1 line
09-27 21:10:16.159 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 48 lines
09-27 21:10:18.706 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 4 lines
09-27 21:10:18.727 15495 16711 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 5 lines
09-27 21:10:18.728 15495 22657 I chatty : uid=10176(org.thoughtcrime.securesms) pool-5-thread-1 expire 5 lines
09-27 21:10:18.852 15495 16679 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 5 lines
09-27 21:10:21.228 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 14 lines
09-27 21:10:21.365 15495 16715 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 4 lines
09-27 21:10:36.487 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 8 lines
09-27 21:10:38.908 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 44 lines
09-27 21:10:57.756 15495 15506 I chatty : uid=10176(org.thoughtcrime.securesms) HeapTaskDaemon expire 1 line
09-27 21:10:59.285 15495 23585 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:11:00.682 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 18 lines
09-27 21:11:11.322 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 33 lines
09-27 21:11:12.828 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 8 lines
09-27 21:11:12.876 15495 16719 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 4 lines
09-27 21:11:12.962 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 10 lines
09-27 21:11:27.431 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 106 lines
09-27 21:11:30.761 15495 23587 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:11:30.832 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 29 lines
09-27 21:11:31.219 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 14 lines
09-27 21:11:31.220 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 29 lines
09-27 21:11:35.403 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 1 line
09-27 21:11:48.394 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 2 lines
09-27 21:11:48.449 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 18 lines
09-27 21:11:54.381 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 6 lines
09-27 21:12:00.453 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 2 lines
09-27 21:12:03.453 15495 23821 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:12:03.459 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 54 lines
09-27 21:12:04.800 15495 16718 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:12:04.805 15495 23578 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:12:04.866 15495 23822 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:12:05.206 15495 16683 I chatty : uid=10176(org.thoughtcrime.securesms) RenderThread expire 1 line
09-27 21:12:13.983 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 20 lines
09-27 21:12:26.000 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 38 lines
09-27 21:12:36.807 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 10 lines
09-27 21:12:48.360 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 3 lines
09-27 21:12:48.984 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 26 lines
09-27 21:13:00.071 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 28 lines
09-27 21:13:10.230 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 28 lines
09-27 21:13:20.483 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 68 lines
09-27 21:13:30.984 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 82 lines
09-27 21:13:41.280 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 22 lines
09-27 21:13:44.324 15495 23585 I chatty : uid=10176(org.thoughtcrime.securesms) expire 1 line
09-27 21:13:44.418 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 2 lines
09-27 21:13:45.859 15495 23821 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:13:45.952 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 2 lines
09-27 21:13:45.972 15495 16679 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:13:45.999 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 5 lines
09-27 21:13:46.000 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 35 lines
09-27 21:13:46.096 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 6 lines
09-27 21:13:46.262 15495 16715 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:13:46.300 15495 16718 I chatty : uid=10176(org.thoughtcrime.securesms) ModernAsyncTask expire 1 line
09-27 21:13:48.370 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 4 lines
09-27 21:14:16.137 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 10 lines
09-27 21:14:39.327 15495 23585 I chatty : uid=10176(org.thoughtcrime.securesms) expire 2 lines
09-27 21:14:48.424 15495 15534 I chatty : uid=10176(org.thoughtcrime.securesms) Thread-2 expire 6 lines
09-27 21:14:48.548 15495 23580 I chatty : uid=10176(org.thoughtcrime.securesms) expire 2 lines
09-27 21:14:54.751 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 10 lines
09-27 21:15:53.664 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 2 lines
09-27 21:18:01.017 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 6 lines
09-27 21:18:01.063 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 15 lines
09-27 21:18:01.886 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 4 lines
09-27 21:18:26.816 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 15 lines
09-27 21:18:57.775 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 11 lines
09-27 21:18:58.538 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 7 lines
09-27 21:18:58.634 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 6 lines
09-27 21:19:41.060 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 4 lines
09-27 21:19:41.112 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 8 lines
09-27 21:19:41.693 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 13 lines
09-27 21:19:41.709 15495 22657 I chatty : uid=10176(org.thoughtcrime.securesms) pool-5-thread-1 expire 8 lines
09-27 21:19:50.381 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 6 lines
09-27 21:20:02.106 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 7 lines
09-27 21:20:08.194 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 3 lines
09-27 21:20:08.255 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 9 lines
09-27 21:20:09.796 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 7 lines
09-27 21:20:10.344 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 7 lines
09-27 21:20:10.550 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 2 lines
09-27 21:20:10.563 15495 22657 I chatty : uid=10176(org.thoughtcrime.securesms) pool-5-thread-1 expire 2 lines
09-27 21:20:10.583 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 1 line
09-27 21:20:10.600 15495 22657 I chatty : uid=10176(org.thoughtcrime.securesms) pool-5-thread-1 expire 6 lines
09-27 21:20:16.171 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 6 lines
09-27 21:20:16.214 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 13 lines
09-27 21:20:20.147 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 11 lines
09-27 21:20:20.725 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 17 lines
09-27 21:21:33.547 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 6 lines
09-27 21:22:24.708 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 4 lines
09-27 21:23:06.534 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 17 lines
09-27 21:23:07.172 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 18 lines
09-27 21:23:07.557 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 7 lines
09-27 21:23:08.132 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 15 lines
09-27 21:23:16.114 15495 15516 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-4 expire 4 lines
09-27 21:24:06.704 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 8 lines
09-27 21:24:14.734 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 6 lines
09-27 21:24:15.270 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 7 lines
09-27 21:24:56.094 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 4 lines
09-27 21:24:56.785 15495 22657 I chatty : uid=10176(org.thoughtcrime.securesms) pool-5-thread-1 expire 8 lines
09-27 21:25:26.970 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 10 lines
09-27 21:25:27.023 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 15 lines
09-27 21:25:27.665 15495 15514 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-2 expire 17 lines
09-27 21:25:40.038 15495 15512 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-0 expire 12 lines
09-27 21:25:40.131 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 10 lines
09-27 21:26:18.033 15495 15515 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-3 expire 7 lines
09-27 21:27:21.977 15495 15518 I chatty : uid=10176(org.thoughtcrime.securesms) pool-2-thread-1 expire 8 lines
09-27 21:28:07.282 15495 15513 I chatty : uid=10176(org.thoughtcrime.securesms) JobConsumer-1 expire 27 lines
09-27 21:28:07.936 15495 15495 I chatty : uid=10176(org.thoughtcrime.securesms) expire 2 lines
09-27 21:28:08.692 15495 15513 W EarlyReceiptCache: Early receipt: 1506570578483,+*********05
09-27 21:28:08.693 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:08.694 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506570578483
09-27 21:28:08.827 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:08.827 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:09.318 15495 15514 W PushReceivedJob: Received receipt: (XXXXX, 1506570581679)
09-27 21:28:09.366 15495 15514 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:09.408 15495 15514 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:09.409 15495 15514 W EarlyReceiptCache: Early receipt: 1506570581679,+*********05
09-27 21:28:09.410 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:09.410 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506570581679
09-27 21:28:09.535 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:09.536 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:09.605 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:09.963 15495 15513 W PushReceivedJob: Received receipt: (XXXXX, 1506570605773)
09-27 21:28:10.002 15495 15513 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:10.039 15495 15513 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:10.039 15495 15513 W EarlyReceiptCache: Early receipt: 1506570605773,+*********05
09-27 21:28:10.040 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:10.040 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506570605773
09-27 21:28:10.176 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:10.177 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:10.648 15495 15512 W PushReceivedJob: Received receipt: (XXXXX, 1506570942437)
09-27 21:28:10.677 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:10.692 15495 15512 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:10.719 15495 15512 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:10.720 15495 15512 W EarlyReceiptCache: Early receipt: 1506570942437,+*********05
09-27 21:28:10.720 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:10.720 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506570942437
09-27 21:28:10.850 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:10.850 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:11.105 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:11.303 15495 15512 W PushReceivedJob: Received receipt: (XXXXX, 1506571196956)
09-27 21:28:11.348 15495 15512 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:11.389 15495 15512 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:11.389 15495 15512 W EarlyReceiptCache: Early receipt: 1506571196956,+*********05
09-27 21:28:11.391 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:11.391 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506571196956
09-27 21:28:11.517 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:11.517 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:11.824 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:11.968 15495 15512 W PushReceivedJob: Received receipt: (XXXXX, 1506571621611)
09-27 21:28:11.995 15495 15512 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:12.030 15495 15512 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:12.031 15495 15512 W EarlyReceiptCache: Early receipt: 1506571621611,+*********05
09-27 21:28:12.032 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:12.032 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506571621611
09-27 21:28:12.144 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:12.145 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:12.737 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:12.738 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:13.202 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:13.254 15495 15514 W PushReceivedJob: Received receipt: (XXXXX, 1506572309120)
09-27 21:28:13.276 15495 15514 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:13.279 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:13.301 15495 15514 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:13.301 15495 15514 W EarlyReceiptCache: Early receipt: 1506572309120,+*********05
09-27 21:28:13.301 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:13.301 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572309120
09-27 21:28:13.444 15495 15514 W PushReceivedJob: Received receipt: (XXXXX, 1506572334857)
09-27 21:28:13.481 15495 15514 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:13.503 15495 15514 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:13.503 15495 15514 W EarlyReceiptCache: Early receipt: 1506572334857,+*********05
09-27 21:28:13.503 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:13.503 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572334857
09-27 21:28:13.650 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:13.651 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:13.982 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:14.109 15495 15513 W PushReceivedJob: Received receipt: (XXXXX, 1506572397012)
09-27 21:28:14.148 15495 15513 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:14.184 15495 15513 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:14.184 15495 15513 W EarlyReceiptCache: Early receipt: 1506572397012,+*********05
09-27 21:28:14.185 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:14.185 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572397012
09-27 21:28:14.211 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:14.323 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:14.323 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:14.775 15495 15513 W PushReceivedJob: Received receipt: (XXXXX, 1506572404545)
09-27 21:28:14.823 15495 15513 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:14.869 15495 15513 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:14.869 15495 15513 W EarlyReceiptCache: Early receipt: 1506572404545,+*********05
09-27 21:28:14.870 15495 15513 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:14.870 15495 15513 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572404545
09-27 21:28:15.015 15495 15512 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:15.016 15495 15512 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:15.461 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:15.462 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:15.533 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:15.898 15495 15514 W PushReceivedJob: Received receipt: (XXXXX, 1506572411925)
09-27 21:28:15.945 15495 15514 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:15.986 15495 15514 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:15.987 15495 15514 W EarlyReceiptCache: Early receipt: 1506572411925,+*********05
09-27 21:28:15.987 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:15.987 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572411925
09-27 21:28:16.137 15495 15515 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:16.137 15495 15515 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:16.386 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:16.597 15495 15515 W PushReceivedJob: Received receipt: (XXXXX, 1506572590849)
09-27 21:28:16.641 15495 15515 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:16.676 15495 15515 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:16.677 15495 15515 W EarlyReceiptCache: Early receipt: 1506572590849,+*********05
09-27 21:28:16.678 15495 15515 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:16.678 15495 15515 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572590849
09-27 21:28:16.822 15495 15516 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:16.822 15495 15516 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:17.269 15495 15516 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:17.269 15495 15516 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:17.360 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:28:17.687 15495 15516 W PushReceivedJob: Received receipt: (XXXXX, 1506572773391)
09-27 21:28:17.734 15495 15516 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:28:17.775 15495 15516 W EarlyReceiptCache: org.thoughtcrime.securesms.database.EarlyReceiptCache@3064b84
09-27 21:28:17.775 15495 15516 W EarlyReceiptCache: Early receipt: 1506572773391,+*********05
09-27 21:28:17.776 15495 15516 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:17.776 15495 15516 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506572773391
09-27 21:28:17.926 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:28:17.926 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:28:31.552 15495 15518 W MessageDatabase: Deleting: 3092
09-27 21:28:31.606 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:29:55.563 15495 15518 W MessageDatabase: Deleting: 3093
09-27 21:29:55.687 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:29:55.701 15495 15518 W MessageDatabase: Deleting: 3094
09-27 21:29:55.712 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:30:06.817 15495 15518 W MessageDatabase: Deleting: 3095
09-27 21:30:06.924 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:30:35.984 15495 15495 W GcmBroadcastReceiver: GCM message...
09-27 21:30:36.025 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:30:36.025 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/
09-27 21:30:36.545 15495 15514 W PushServiceSocket: Push service URL: https://textsecure-service.whispersystems.org
09-27 21:30:36.545 15495 15514 W PushServiceSocket: Opening URL: https://textsecure-service.whispersystems.org/v1/messages/+*********05/1506573035155
09-27 21:30:36.639 15495 15515 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:30:36.658 15495 15515 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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)
09-27 21:30:36.672 15495 15515 W NotificationState: Added thread: 2
09-27 21:30:36.678 15495 15515 W NotificationState: getAndroidAutoHeardIntent Added thread: 2
09-27 21:31:17.779 15495 15518 W MessageDatabase: Deleting: 3096
09-27 21:31:17.816 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:31:17.845 15495 15518 W MessageDatabase: Deleting: 3097
09-27 21:31:17.867 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:31:23.794 15495 15518 W MessageDatabase: Deleting: 3098
09-27 21:31:23.834 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:31:35.344 15495 15518 W MessageDatabase: Deleting: 3099
09-27 21:31:35.380 15495 15518 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 2) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 2) ORDER BY date_received DESC LIMIT 1)
09-27 21:32:03.798 15495 25058 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 file_name, NULL AS _data, NULL AS thumbnail, NULL AS ct, NULL AS cl, NULL AS digest, NULL AS fast_preflight_id, NULL AS voice_note, NULL AS cd, NULL AS name, NULL AS pending_push FROM sms WHERE (thread_id = 12) 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, file_name, _data, thumbnail, ct, cl, digest, fast_preflight_id, voice_note, 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 = 12) ORDER BY date_received DESC LIMIT 1)
09-27 21:32:03.805 15495 15495 W PassphraseRequiredActionBarActivity: onDestroy()
09-27 21:32:03.851 15495 15495 W PassphraseRequiredActionBarActivity: onResume()
09-27 21:32:03.929 15495 15495 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_START_EVENT
09-27 21:32:03.929 15495 15495 W KeyCachingService: Incrementing activity count...
09-27 21:32:03.930 15495 15495 W MessageRetrievalService: Active Count: 1
09-27 21:32:03.933 15495 15534 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
09-27 21:32:03.937 15495 15534 W MessageRetrievalService: Making websocket connection....
09-27 21:32:03.937 15495 15534 W WebSocketConnection: WSC connect()...
09-27 21:32:03.954 15495 15534 W MessageRetrievalService: Network requirement: true, active activities: 1, push pending: 0, gcm disabled: false
09-27 21:32:03.955 15495 15534 W MessageRetrievalService: Reading message...
09-27 21:32:04.513 15495 25060 W WebSocketConnection: onConnected()
09-27 21:32:04.515 15495 25060 W WebSocketConnection: WSC onMessage()
09-27 21:32:04.515 15495 25060 W WebSocketConnection: Message Type: 1
09-27 21:32:05.703 15495 15495 W art : Before Android 4.1, method int android.support.v7.widget.ListViewCompat.lookForSelectablePosition(int, boolean) would have incorrectly overridden the package-private method in android.widget.ListView
09-27 21:32:08.395 15495 15495 W PassphraseRequiredActionBarActivity: onPause()
09-27 21:32:08.415 15495 15495 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_STOP_EVENT
09-27 21:32:08.416 15495 15495 W KeyCachingService: Decrementing activity count...
09-27 21:32:08.416 15495 15495 W MessageRetrievalService: Active Count: 0
09-27 21:32:08.425 15495 15495 W PassphraseRequiredActionBarActivity: onCreate(null)
09-27 21:32:08.428 15495 15495 W ExperienceUpgradeActivity: getExperienceUpgrade(286)
09-27 21:32:08.428 15495 15495 W PassphraseRequiredActionBarActivity: routeApplicationState(), state: 0
09-27 21:32:08.430 15495 15495 W PassphraseRequiredActionBarActivity: initializeClearKeyReceiver()
09-27 21:32:08.492 15495 15495 W PassphraseRequiredActionBarActivity: onResume()
09-27 21:32:08.639 15495 15495 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_START_EVENT
09-27 21:32:08.639 15495 15495 W KeyCachingService: Incrementing activity count...
09-27 21:32:08.640 15495 15495 W MessageRetrievalService: Active Count: 1
09-27 21:32:08.753 15495 16683 D OpenGLRenderer: endAllActiveAnimators on 0xa176fc80 (MenuPopupWindow$MenuDropDownListView) with handle 0xa23c4880
09-27 21:32:08.762 15495 25067 W org.thoughtcrime.securesms.components.emoji.parsing.EmojiPageBitmap: loading page emoji/Objects.png
09-27 21:32:08.839 15495 25067 W org.thoughtcrime.securesms.components.emoji.parsing.EmojiPageBitmap: onPageLoaded(emoji/Objects.png)
09-27 21:32:12.391 15495 15495 W PassphraseRequiredActionBarActivity: onPause()
09-27 21:32:12.411 15495 15495 W KeyCachingService: onStartCommand, org.thoughtcrime.securesms.service.action.ACTIVITY_STOP_EVENT
09-27 21:32:12.411 15495 15495 W KeyCachingService: Decrementing activity count...
09-27 21:32:12.412 15495 15495 W MessageRetrievalService: Active Count: 0
09-27 21:32:12.651 15495 16683 D OpenGLRenderer: endAllActiveAnimators on 0xa2448700 (ListView) with handle 0xaae7e760
09-27 21:32:12.657 15495 15495 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
09-27 21:32:12.657 15495 15495 E SpannableStringBuilder: SPAN_EXCLUSIVE_EXCLUSIVE spans cannot have a zero length
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment