1578509 - URL does not update correctly when modified in address bar

Status: RESOLVED INCOMPLETE

(Firefox :: Address Bar, defect, P5)

Description

[kdaker]

Attachment: firefox-bug.mov

User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:69.0) Gecko/20100101 Firefox/69.0

Steps to reproduce:

• navigate to a website, for example: "https://github.com/nodejs/node"
• modify the url by deleting 'node' and typing 'Release'
• hit enter

Actual results:

the delete updates work, but the new typed words do not.
In this case firefox navigates to "https://github.com/nodejs"

Expected results:

it should navigate to "https://github.com/nodejs/Release"

Comment 1

[BugBot [:suhaib / :marco/ :calixte]]

Bugbug thinks this bug should belong to this component, but please revert this change in case of error.

Comment 2

[Drew Willcoxon :adw]

Something is really going wrong because as you're typing "Release", the first result in the popup should be echoing what you're typing. Are there any errors in the browser console when this happens? Does this happen with any other URLs? Could you please try reproducing the problem in safe mode? https://support.mozilla.org/en-US/kb/troubleshoot-firefox-issues-using-safe-mode

Comment 3

[Drew Willcoxon :adw]

One other thing: Please go to about:support, click the "Verify Integrity" button in the "Places Database" section, and paste the output here in the bug.

Comment 4

[kdaker]

This happens with any URL.

I tried in safe made and was able to reproduce. Here is the output of the integrity check, looks like there is an issue.

Task: checkIntegrity

• Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed

Task: invalidateCaches

• The task queue was cleared by an error in another task.

Task: checkCoherence

• The task queue was cleared by an error in another task.

Task: expire

• The task queue was cleared by an error in another task.

Task: originFrecencyStats

• The task queue was cleared by an error in another task.

Task: vacuum

• The task queue was cleared by an error in another task.

Task: stats

• The task queue was cleared by an error in another task.

Task: _refreshUI

• The task queue was cleared by an error in another task.

Comment 5

[kdaker]

> Task: checkIntegrity
- Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed
> Task: invalidateCaches
- The task queue was cleared by an error in another task.
> Task: checkCoherence
- The task queue was cleared by an error in another task.
> Task: expire
- The task queue was cleared by an error in another task.
> Task: originFrecencyStats
- The task queue was cleared by an error in another task.
> Task: vacuum
- The task queue was cleared by an error in another task.
> Task: stats
- The task queue was cleared by an error in another task.
> Task: _refreshUI
- The task queue was cleared by an error in another task.

Comment 6

[kdaker]

how can I fix the corrupted database?

Comment 7

[kdaker]

Also, sorry forgot to answer one of your questions: no there are no errors in the console when this happens.

Comment 8

[Drew Willcoxon :adw]

(In reply to kdaker from comment #6)

how can I fix the corrupted database?

I'm not actually sure. Marco? I looked around but there doesn't seem to be a simple, user-friendly way to do it, at least not without losing history. Does refreshing Firefox do it?

Comment 9

[Marco Bonardo [:mak] (Away Apr 25 - May 5)]

The integrity check in about:support already does all it can to try to fix a corrupt database. This kind of corruption may be related to many causes (disk or memory problems, unstable overclock, bogus filesystems, unexpected manual editing, unknown bugs in Sqlite) so we can't do much about them.
If you don't mind losing history you can just close Firefox, rename places.sqlite freom the profile folder to places.sqlite.old and on starting up we'll generate a new one and reimport bookmarks.
Otherwise, there is a manual procedure explained here https://developer.mozilla.org/en-US/docs/Mozilla/Tech/Places/places.sqlite_Database_Troubleshooting that is not much different from what the automated system tries to do.

Unfortunately there's no silver bullet to fix a database that is seen by sqlite as "malformed", apart from rebuilding it, losing some data.

Comment 10

[Drew Willcoxon :adw]

I'm not sure it's useful to keep this open since it doesn't seem actionable. Thanks for filing it, and please let us know if you can come up with steps to reproduce it.

Comment 11

[kdaker]

Ah my apologies I should have closed this. This was a database issue and was resolved following Marco’s steps.