Getting the Yellow Sync triangle on PC today

Page 2 of 3 (43 items) < Previous 1 2 3 Next >
This post has 42 Replies | 3 Followers

Posts 3148
LogosEmployee
Thomas Ball | Forum Activity | Replied: Fri, Jul 18 2014 8:35 AM

Hi Ward, 

I'm going to email you about this.

 

Posts 1202
Ward Walker | Forum Activity | Replied: Tue, Jul 22 2014 7:59 PM

Tommy Ball:

Hi Ward, 

I'm going to email you about this.

RGR

Posts 3148
LogosEmployee
Thomas Ball | Forum Activity | Replied: Thu, Jul 24 2014 9:17 AM

Ward Walker:

Tommy Ball:

Hi Ward, 

I'm going to email you about this.

RGR

I have no idea what that means. Did you not receive my email? 

Sorry, Ward. Dylan clarified to me what "RGR" meant. You'd think I would have picked up on that considering how comfortable I am with the military alphabet. 

 

Posts 1202
Ward Walker | Forum Activity | Replied: Sun, Jul 27 2014 7:02 AM

Big Smile

Tommy, I did get your email and intend to call--I just don't yet know when I will be able, since I can't do this during my work hours and by the time I get home there isn't very much time before Logos Tech Support probably goes home for the day.

I'm going to have to get this fixed though, because I've noticed that my highlights have been disappearing after I apply them and while Logos tries to synch.  I think it is only the "Highlighter Pens" palette that is having this problem, but am not sure...it is just that I'll look back after highlighting for a while and much of what I did will sometimes have partially disappeared.

 Perhaps I can call this coming Friday AM for a short time.

Ward

Posts 3148
LogosEmployee
Thomas Ball | Forum Activity | Replied: Mon, Jul 28 2014 2:44 PM

Ward Walker:
isn't very much time before Logos Tech Support probably goes home for the day.

We're open from 6am-6pm PDT Mon-Sat in case you thought the hours were more restrictive. 

 

Posts 5
Eric Reed | Forum Activity | Replied: Mon, Jul 28 2014 8:14 PM

I have actually encountered the same sync issue with Logos 5.2 SR3 (5.2.0.0091) on my Mac running OSX 10.9.4

hmmmmm.

Posts 24851
Forum MVP
Dave Hooton | Forum Activity | Replied: Mon, Jul 28 2014 9:17 PM

Eric Reed:
I have actually encountered the same sync issue with Logos 5.2 SR3 (5.2.0.0091) on my Mac running OSX 10.9.4

Please update to the latest version (5.2a SR-7) using this link.

Dave
===

Windows & Android

Posts 7983
LogosEmployee

This sync error looks like it's caused by a timeout while trying to upload several extremely large Notes documents. We're seeing whether we can adjust some timeouts on the server to allow you more time to upload.

However, that's only a short-term workaround; we recommend that you try to split your highlights across multiple, smaller documents.

Long-term, we plan to overhaul notes sync so it's not as affected by the size of individual Notes documents; I don't have an estimate for when that would be deployed, though.

Posts 1887
Donnie Hale | Forum Activity | Replied: Tue, Jul 29 2014 7:07 PM

Bradley Grainger (Logos):
we plan to overhaul notes sync

Oh no! Sync v3???!!! Say it ain't so. ;)

Posts 1202
Ward Walker | Forum Activity | Replied: Wed, Jul 30 2014 5:09 AM

Bradley Grainger (Logos):

This sync error looks like it's caused by a timeout while trying to upload several extremely large Notes documents. We're seeing whether we can adjust some timeouts on the server to allow you more time to upload.

However, that's only a short-term workaround; we recommend that you try to split your highlights across multiple, smaller documents.

Long-term, we plan to overhaul notes sync so it's not as affected by the size of individual Notes documents; I don't have an estimate for when that would be deployed, though.

Bradley, Thanks...I suppose we now know the maximum size a note file can currently safely get  Ick!

I'm willing to split my note files up, but I need programmatic assistance--it took every day for years to create this problem; I can't get out of it manually.

I propose a maintenance tool that lets me do something like this:

In <resource>, in <these sections>, move all <styleSleep>/<<palleteSleep> to <note file>[creating it or appending it, as appropriate], verify, then remove the items that were moved from the original source

In practice, I'd probably start by putting all ESV OT highlights into one new Note file, then going book by book in the ESV NT since my highlight density is so much higher there.

I don't tend to use the highlight re-direction feature because it is a bit unwieldy for me; I don't think to turn it off if I am in a different resource, and I move between resources pretty quickly.  I prefer to fix the problem on the back end.

Posts 5
Eric Reed | Forum Activity | Replied: Wed, Jul 30 2014 5:46 AM

Thank you, Dave. I will try this today after work.

Blessings,

eric

Posts 5
Eric Reed | Forum Activity | Replied: Wed, Jul 30 2014 2:30 PM

Dave,

That fixed the sync issue/triangle! Thanks.

Now I am trying to find my purchases from June 24...

Posts 1202
Ward Walker | Forum Activity | Replied: Sun, Aug 17 2014 4:47 PM

An update for Logos Forum users (especially power users / frequent highlighters / Inductive-style users):

Mike Bryant and Bradley Grainger got me back in action by extending the time-out that the Logos servers enforce when syncing user documents.  This was just a stop gap measure; it lets me operate as I am, but I can't grow some of my Notes files any further, so it currently requires me to redirect new highlights to new notes files, and to manually move my legacy highlights out of two large files into smaller files--at least until I get to a more supported file size.

When I exceeded Logos' design limits, I had amassed 208,000 highlights.  Two Notes files had reached their cap of 80,000 highlights and began to create erratic behaviour when I tried to create new highlights (the highlights "wouldn't stick" or older highlights would disappear after a sync attempt, etc).  I'd long ago exceeded my own ability to figure out how long the Notes files were (I used to attempt to print them and count the print job pages, but after a while that didn't work anymore).  

If you want to see if you might be nearing this same problem, perhaps the easiest way is to surf to where Logos keeps Notes (for me, that is at: C:\Users\Ward\AppData\Local\Logos5\Documents\mkshavqx.3vt\Documents\Notes ), and then to look at file sizes.  My 80,000 highlight notes files are 110,085KB (I think...I may not be reading the SQLite file headers right).

Posts 27556
Forum MVP
JT (alabama24) | Forum Activity | Replied: Sun, Aug 17 2014 6:31 PM

Thanks for the update Ward. Yes

OSX & iOS | Logs |  Install

Posts 14
Rich Thirsk | Forum Activity | Replied: Sat, Jan 23 2016 12:18 PM

Hi Ward. Thank you for all the great descriptions and analysis of your problem with large notes files. I suspect I have the same problem on one of my PCs (a Microsoft Pro tablet). I think I have more highlights and a larger Notes db file than you do. Did you ever get Logos support to help you reliably move highlights from one (large) note file to other(s)? If not, have you figured out how to do this yourself in a reasonable way?  Thx.

Seeking the Truth,

Rich

Posts 14
Rich Thirsk | Forum Activity | Replied: Tue, Feb 9 2016 11:37 PM

Bradley, thank you for the explanation of the likely cause of this problem. Would you be so kind as to review the following plan and offer any hints or suggestions for solving my problem?

I believe I have this same issue with Logos 6 on my tablet that I use most for highlighting. It appears that I have about 150,000+ highlights in several 'Notes' documents (but about 145,000 of these are in one 'Notes' document which is named per the "palette-specific note file" for my custom palette). I have analyzed the notes.db file a bit and wonder if the solution to fix my problem should go something like this:

  1. ensure Logos 6 is not running;
  2. using a SQLite browser, identify the extremely large 'Notes doc' (call it "A"), (which appears to be referenced in NotesDocumentId field in rows of the Notes (SQLite) table);
  3. start Logos 6 in 'local mode' by holding the [Ctrl] key down when launching it (to prevent syncing with the Logos server);
  4. using Logos 6, create another 'Notes doc' (call it "B"), to (eventually) take a big chunk of the notes from the large 'Notes doc' "A";
  5. exit Logos 6 app;
  6. using a SQLite browser, find the DocumentId value for the new 'Notes doc' "B" (from the NotesDocuments table);
  7. move one 'highlight' to "B" by:
    1. replacing the value for the NotesDocumentId field in the Notes table from the value for "A" to the value for "B";
    2. modifying any other Notes table fields as required (e.g., IsSubmitted? -- what is it and how is it used?);
    3. re-start Logos 6 in 'local mode';
    4. using Logos 6, open Notes doc "B" and confirm that it now contains the 'highlight' we were trying to move from Notes doc "A";
    5. if the "highlight" from "A" was successfully moved to "B", then:
      1. exit Logos 6;
      2. repeat steps 7.1 - 7.4 for about 20% of the rows for Notes doc "A"; // hoping that this will shrink Notes file enough to 'fix' things;
    6. if the "highlight" from "A" was not successfully moved to "B", then re-evaluate, modify the procedure as necessary & try again;
  8. after the highlights are successfully moved:
    1. invoke Logos 6 in 'local mode';
    2. using Logos 6, set the Notes file for this custom palette to be "B" (so all future highlighting notes will go into "B");
    3. exit Logos 6 and re-launch in 'normal mode' (to cause syncing with the Logos server)

Hopefully, these changes will be sync-ed to the Logos server and the highlighting will once again be functional! (This is where I'm a bit in the dark as to what fields need to be set to what values in order for these changes to be detected by the Logos server and synced there and subsequently to my other devices.)

[Also, is there a way to link this into a Logos 6 forum? I posted here because the problem seems to occur for both Logos 5 & Logos 6 and this thread already has the context for the problem.]

Seeking the Truth,

Rich

Posts 14
Rich Thirsk | Forum Activity | Replied: Tue, Feb 9 2016 11:41 PM

Bradley, has the "overhaul notes sync" you described been implemented? ETA? See my proposed solution to "split highlights across multiple, smaller documents" at the end of this thread.  Thanks.

Seeking the Truth,

Rich

Posts 14
Rich Thirsk | Forum Activity | Replied: Tue, Feb 9 2016 11:46 PM

Rich Thirsk:

... wonder if the solution to fix my problem should go something like this:

  1. ensure Logos 6 is not running;

Before starting this procedure, I should have inserted a step to create a backup of the Notes.db file, in case something goes wrong and I need to restore it.

Seeking the Truth,

Rich

Posts 7983
LogosEmployee

Firstly, "no user-serviceable components inside", "modifying the database voids your warranty", etc. Secondly, I don't actually know how to safely move a note between documents, so this is only a guess. (I took a quick look through the code but didn't find it.) Thirdly, Notes sync is one of the more complicated sync systems, so there's a lot that could go wrong. Fourthly, are you sure you have the same issue? You didn't post log files, so we can't confirm.

I think steps 7.1 and 7.2 should be:

update Notes set NotesDocumentId = @NewNotesDocumentId, IsSubmitted = 0, Modified = @Modified, Revision = @Revision where Id = @Id;
update NotesDocuments set ModifiedDate = @Modified, SyncState = 1 where Id in (@OldNotesDocumentId, @NewNotesDocumentId);

@Modified = "now" in ISO-8601 format
@Revision = a unique new GUID
@Id = the ID of the note to move
@OldNotesDocumentId = the ID of the document you're moving it from
@NewNotesDocumentId = the ID of the document you're moving it to

In step 7.5.2, I really have no idea how many notes would need to be moved, nor how many new document you'd need to move them into.

Posts 1202
Ward Walker | Forum Activity | Replied: Wed, Feb 10 2016 8:48 AM

Bradley, thank you for the response and the warnings.  Will Logos ever publish a tool to help us break up our old Notes files into smaller ones (i.e., splitting a pallete-specific note file into Notes files that are associated with specific resources)?   While the desktop works for me these days, the mobile apps just can't handle my notes files and work very erratically WRT showing/syncing highlights.

Page 2 of 3 (43 items) < Previous 1 2 3 Next > | RSS