Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Thunderbird has a file called <a href="http://kb.mozillazine.org/Popstate.dat" rel="nofollow noreferrer">popstate.dat</a> that contains the UID, an timestamp (epoch), and a flag. The flag indicates the action that Thunderbird is to perform for the associated message.</p> <p>Evidently, Thunderbird does not actually work like I described above. I think Thunderbird does the following. It sends a POP3 <code>UIDL</code> command to get a list of the UID's stored on the POP server. It then compares this list to the UID's stored in <code>popstate.dat</code>. Any UID's that are not already in <code>popstate.dat</code> are new messages to be retrieved. The UIDL command previously returned the message number and the associated UID. Thunderbird must then do an POP3 <code>RETR</code> command using the message number associated with the UID's that it has not yet retrieved. Thunderbird must also look at the flag in <code>popstate.dat</code> and take any actions for the associated message. For example, the flag <code>d</code> tells Thunderbird to delete the associated message. The <code>f</code> flag means that Thunderbird has only a truncated part of the message and should retrieve the full message.</p> <p>At some point Thunderbird updates the <code>popstate.dat</code> with the new messages. I think this happens in a batch update to <code>popstate.dat</code> after all the actions have been completed. That is, if there are 10 new messages to retrieve, <code>popstate.dat</code> is not updated until all 10 messages have been retrieved.</p> <p>I think my problem resides on the server. Apparently our infrastructure upgraded to a new version of the POP server and new UIDs were assigned on the new version. My <code>popstate.dat</code> had all the old UIDs. The UIDL to the new POP server send a list of 5000+ UIDs that Thunderbird did not have listed in <code>popstate.dat</code>. So, Thunderbird proceeded to download all 5000+ messages. If the new POP server had retained the old UID's then Thunderbird would have seen that I already had retrieved most of the 5000+ messages and would have just downloaded the ones that I did not have. I think most people in my organization use Outlook and do not use POP3, and however the version update was done to the POP server did not cause a problem for those users. Seems like some extra care was needed to ensure the new server had the same UIDs as the old server. Live and learn!</p>
    singulars
    1. This table or related slice is empty.
    1. POWhere does Thunderbird store the UID of the last message downloaded via POP?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAlexey Ivanov
    1. USPauld
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhere does Thunderbird store the UID of the last message downloaded via POP?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload