Bookmark folders are still present, but empty. All bookmarks disappear from the bookmark toolbar and menu. The only way I've found to restore them is downgrading to 54 *and* restoring ~/.mozilla from backup.
Bookmarks are stored in ~/.mozilla/firefox/<profile>/places.sqlite. Is sqlite3 binary able to read moz_bookmarks table there? Did you downgrade sqlite3 package after building firefox package against it? Have you modified any of sqlite3 port options?
How do I verify that it can read the table? I did not downgrade sqlite and I would not know how to modify sqlite port options. Note: When I start firefox 55, it copies places.sqlite to places.sqlite.corrupt and replaces it with a much smaller one: -rw-r----- 1 bacon bacon 20971520 Aug 15 15:44 places.sqlite.backup -rw-r--r-- 1 bacon bacon 20971520 Aug 15 15:37 places.sqlite.corrupt -rw-r----- 1 bacon bacon 5242880 Aug 15 15:51 places.sqlite55 The allegedly corrupt file works fine with firefox 54, though.
Does https://bugzilla.mozilla.org/show_bug.cgi?id=1388584 look related? If so update to 55.0.2 (see ports r448030). Otherwise, try to reproduce on a clean profile from FF54 then file a bug upstream and CC me.
So, the problem is actually isolated to firefox 54. If I back up my bookmarks from 54 (json or html), the backup file is incomplete. Restoring into 54 from that file produces the same symptoms. I also read up on sqlite and tried a manual dump and restore: FreeBSD imacbsd.acadix bacon ~ 310: sqlite3 places.sqlite.backup .dump > bookmarks.dump FreeBSD imacbsd.acadix bacon ~ 311: sqlite3 places.sqlite < bookmarks.dump Error: near line 55247: UNIQUE constraint failed: moz_hosts.host Error: near line 55286: UNIQUE constraint failed: moz_hosts.host Error: near line 55294: UNIQUE constraint failed: moz_hosts.host Error: near line 55296: UNIQUE constraint failed: moz_hosts.host Error: near line 55300: UNIQUE constraint failed: moz_hosts.host Error: near line 55301: UNIQUE constraint failed: moz_hosts.host Error: near line 55302: UNIQUE constraint failed: moz_hosts.host Error: near line 55309: UNIQUE constraint failed: moz_hosts.host Error: near line 55310: UNIQUE constraint failed: moz_hosts.host Error: near line 55313: UNIQUE constraint failed: moz_hosts.host Error: near line 55321: UNIQUE constraint failed: moz_hosts.host Error: near line 55322: UNIQUE constraint failed: moz_hosts.host Error: near line 55324: UNIQUE constraint failed: moz_hosts.host Error: near line 55351: UNIQUE constraint failed: moz_hosts.host Error: near line 55352: UNIQUE constraint failed: moz_hosts.host Error: near line 55354: UNIQUE constraint failed: moz_hosts.host Error: near line 55355: UNIQUE constraint failed: moz_hosts.host Error: near line 55356: UNIQUE constraint failed: moz_hosts.host Error: near line 55357: UNIQUE constraint failed: moz_hosts.host Error: near line 55358: UNIQUE constraint failed: moz_hosts.host Error: near line 55360: UNIQUE constraint failed: moz_hosts.host Error: near line 55363: UNIQUE constraint failed: moz_hosts.host Error: near line 55364: UNIQUE constraint failed: moz_hosts.host Error: near line 55369: UNIQUE constraint failed: moz_hosts.host Error: near line 55370: UNIQUE constraint failed: moz_hosts.host Error: near line 55372: UNIQUE constraint failed: moz_hosts.host Error: near line 55373: UNIQUE constraint failed: moz_hosts.host Error: near line 55374: UNIQUE constraint failed: moz_hosts.host Error: near line 55375: UNIQUE constraint failed: moz_hosts.host Error: near line 55377: UNIQUE constraint failed: moz_hosts.host Error: near line 55378: UNIQUE constraint failed: moz_hosts.host Error: near line 55379: UNIQUE constraint failed: moz_hosts.host Error: near line 55384: UNIQUE constraint failed: moz_hosts.host Error: near line 55385: UNIQUE constraint failed: moz_hosts.host Error: near line 55388: UNIQUE constraint failed: moz_hosts.host Error: near line 55394: UNIQUE constraint failed: moz_hosts.host Error: near line 55395: UNIQUE constraint failed: moz_hosts.host Error: near line 55401: UNIQUE constraint failed: moz_hosts.host Error: near line 55407: UNIQUE constraint failed: moz_hosts.host Error: near line 55410: UNIQUE constraint failed: moz_hosts.host Error: near line 55413: UNIQUE constraint failed: moz_hosts.host Error: near line 55415: UNIQUE constraint failed: moz_hosts.host Error: near line 55416: UNIQUE constraint failed: moz_hosts.host Error: near line 55419: UNIQUE constraint failed: moz_hosts.host Error: near line 55423: UNIQUE constraint failed: moz_hosts.host Error: near line 55427: UNIQUE constraint failed: moz_hosts.host Error: near line 55435: UNIQUE constraint failed: moz_hosts.host Error: near line 55436: UNIQUE constraint failed: moz_hosts.host Error: near line 55441: UNIQUE constraint failed: moz_hosts.host Error: near line 55443: UNIQUE constraint failed: moz_hosts.host Error: near line 55444: UNIQUE constraint failed: moz_hosts.host Error: near line 55446: UNIQUE constraint failed: moz_hosts.host Error: near line 55456: UNIQUE constraint failed: moz_hosts.host Error: near line 55457: UNIQUE constraint failed: moz_hosts.host Error: near line 55460: UNIQUE constraint failed: moz_hosts.host Error: near line 55462: UNIQUE constraint failed: moz_hosts.host Error: near line 55464: UNIQUE constraint failed: moz_hosts.host Error: near line 55466: UNIQUE constraint failed: moz_hosts.host Error: near line 55468: UNIQUE constraint failed: moz_hosts.host Error: near line 55470: UNIQUE constraint failed: moz_hosts.host Error: near line 55472: UNIQUE constraint failed: moz_hosts.host Error: near line 55484: UNIQUE constraint failed: moz_hosts.host Error: near line 55490: UNIQUE constraint failed: moz_hosts.host Error: near line 55492: UNIQUE constraint failed: moz_hosts.host Error: near line 55493: UNIQUE constraint failed: moz_hosts.host Error: near line 55496: UNIQUE constraint failed: moz_hosts.host Error: near line 55509: UNIQUE constraint failed: moz_hosts.host Error: near line 55512: UNIQUE constraint failed: moz_hosts.host Error: near line 55519: UNIQUE constraint failed: moz_hosts.host Error: near line 55523: UNIQUE constraint failed: moz_hosts.host Error: near line 55524: UNIQUE constraint failed: moz_hosts.host Error: near line 55550: UNIQUE constraint failed: moz_hosts.host Error: near line 55561: UNIQUE constraint failed: moz_hosts.host Error: near line 55562: UNIQUE constraint failed: moz_hosts.host Error: near line 55565: UNIQUE constraint failed: moz_hosts.host Error: near line 55574: UNIQUE constraint failed: moz_hosts.host Error: near line 55579: UNIQUE constraint failed: moz_hosts.host Error: near line 55581: UNIQUE constraint failed: moz_hosts.host Error: near line 55587: UNIQUE constraint failed: moz_hosts.host Error: near line 55589: UNIQUE constraint failed: moz_hosts.host Error: near line 55602: UNIQUE constraint failed: moz_hosts.host Error: near line 55613: UNIQUE constraint failed: moz_hosts.host Error: near line 55614: UNIQUE constraint failed: moz_hosts.host Error: near line 55615: UNIQUE constraint failed: moz_hosts.host Error: near line 55643: UNIQUE constraint failed: moz_hosts.host Error: near line 55655: UNIQUE constraint failed: moz_hosts.host FreeBSD imacbsd.acadix bacon ~ 312: ls -l places.sqlite* -rw-r----- 1 bacon bacon 0 Aug 17 09:23 places.sqlite -rw-r----- 1 bacon bacon 20971520 Aug 15 15:44 places.sqlite.backup -rw-r--r-- 1 bacon bacon 20971520 Aug 15 15:37 places.sqlite.corrupt -rw-r----- 1 bacon bacon 5242880 Aug 15 15:51 places.sqlite55
This can be closed as far as I'm concerned. The problem was not identified, but I wiped my profile and started over, restoring my bookmarks manually into 55.0.2.
Not a downstream issue then.