1833399 - Imported Saved Form History data is no longer working after the station is left idle

Status: NEW

(Firefox :: Migration, defect, P3)

Description

[Alexandru Trif, Desktop QA [:atrif]]

Attachment: Screenshot from 2023-05-16 16-23-22.png

Found in

• 114.0b4

Affected versions

• 115.0a1 (2023-05-16)
• 114.0b4

Tested platforms

• Affected platforms: Ubuntu 20.05, Windows 10x64 (reproduced one time), and macOS 12 (reproduced one time)
• Unaffected platforms: none

Preconditions

• have some Saved Form History data inside Chrome on https://fill.dev/form/identity-simple
• inside Settings > Privacy > Screen Lock set the options as in the attached screenshot

Steps to reproduce

1. Open Firefox and import Saved Form History data.
2. Open https://fill.dev/form/identity-simple and check that the form history is imported.
3. Leave PC/Laptop Idle for like ~5+ minutes.
4. Wake up the operating system and check if the Saved Form History data form still works on https://fill.dev/form/identity-simple.

Expected result

• The Saved Form History Data is working.

Actual result

• There are no Saved Form History data available.

Regression range

• I will search for one ASAP. Most likely not a regression and was introduced when the Import Saved Form History was implemented (bug 1827425).

Additional notes

• We could reproduce this once on a Windows and a macOS 12 machine, but the issue seems to be intermittent on those operating systems. This reproduces every time on Ubuntu 20 and Ubuntu 22 by following the above steps. Maybe something else is triggering this behavior on Windows or macOS.
• S3 because we don’t know how often this issue reproduces on Windows or macOS and form history can be imported again.
• Only imported form history is deleted, form history saved inside Firefox after the import is performed is kept after following the above steps.
• This is reproduced with legacy migration and the new migration windows (both variants).
• I could not reproduce the issue on Ubuntu if I set the Blank Screen Delay to 1 minute so I think that a certain amount of time needs to be passed in order for the issue to be reproduced.

Comment 1

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

:atrif, if you think that's a regression, could you try to find a regression range using for example mozregression?

Comment 2

[Alexandru Trif, Desktop QA [:atrif]]

It seems that this issue was also reproduced for me on Windows 11 station after the PC was left idle for more than 10 minutes (turning off the screen is set to 3 minutes and putting the device to sleep is 10 minutes). Also when I wake up from sleep on the MacBook (macOS12) the same issue seems to be present there as well with Firefox 114.0b7. The MacBook was left idle for one day with the lid closed.
Importing form the history again on the same Firefox profile after the issue was reproduced and repeating steps will no longer erase the form history data.

Comment 3

[Giorgia Nichita, Release Desktop QA]

I managed to reproduced this issue on Firefox 114.0b7 with my Ubuntu 22 operating system configured to stay active WITHOUT going idle. I've noticed that when I import data with the new migration window on a new profile and leave my computer untouched for 10-15 minutes, the Form History data does not function. if I import the data from the history again on the same Firefox profile after encountering this issue and repeat the steps, the form history data is no longer cleared.

Comment 4

[Alexandru Trif, Desktop QA [:atrif]]

Attachment: Screenshot_5.png

I looked at this today on Windows 10x64 with Firefox 114.0b9 by looking at the database data inside the profile directory > formhistory.sqlite. After importing Form History the imported data is correctly displayed inside the moz_formhistory table. After the issue is reproduced the imported data is no longer displayed inside the moz_formhistory, and the table is empty. I had lots of data from multiple web pages. I also searched other tables and they are empty.
I just left the PC idle for some time with the DB browser closed and reopened the DB browser again to check the data inside the moz_formhistory table.

One more thing that I've noticed is that the imported form history from another browser has firstUsed and lastUsed time stamps in milliseconds, and the ones saved inside Firefox have them saved in microseconds. I imported the form history on a new profile and changed the timestamps for firstUsed and lastUsed for imported data in microseconds (copied from one made on Firefox) and the data remained after the issue is reproduced, so maybe this may be the cause.

Attached a screenshot as well. If more information is needed please let me know. Thank you!

Comment 5

[Alexandru Trif, Desktop QA [:atrif]]

Reproduced with Firefox 114.0a1 (2023-05-03) when the Import Saved Form History was implemented (bug 1827425) on Windows 11x64. Not a regression.