From owner-freebsd-gecko@freebsd.org Thu Aug 17 14:26:05 2017 Return-Path: Delivered-To: freebsd-gecko@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 74FC3DE46B2 for ; Thu, 17 Aug 2017 14:26:05 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 5BE5F7414B for ; Thu, 17 Aug 2017 14:26:05 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: by mailman.ysv.freebsd.org (Postfix) id 581E2DE46B1; Thu, 17 Aug 2017 14:26:05 +0000 (UTC) Delivered-To: gecko@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 57716DE46B0 for ; Thu, 17 Aug 2017 14:26:05 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 3B4CD7414A for ; Thu, 17 Aug 2017 14:26:05 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id v7HEQ5jE074519 for ; Thu, 17 Aug 2017 14:26:05 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: gecko@FreeBSD.org Subject: [Bug 221525] www/firefox: Upgrade to firefox 55 makes all my bookmarks disappear Date: Thu, 17 Aug 2017 14:26:05 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: bacon4000@gmail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: gecko@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-gecko@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Gecko Rendering Engine issues List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Aug 2017 14:26:05 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D221525 --- Comment #4 from Jason Bacon --- So, the problem is actually isolated to firefox 54. If I back up my bookma= rks from 54 (json or html), the backup file is incomplete. Restoring into 54 f= rom 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 --=20 You are receiving this mail because: You are the assignee for the bug.=