Details for the issue

This semi-relates to an issue raised in #1585. Upon further testing, a reproducible set of steps was identified.

When importing data into a table, if an imported record fails a constraint check (eg, primary key violation, eg, importing record #1 again) DB4S throws up a 'invalid file format' error, then a further 'the system is busy - do you want to cancel?' dialog. If the user presses No, DB4S locks up*.

*DB4S didn't come out of the 'not responding state'

Tried the alpha, nightly, and the recent 'special build' for #1575.
See screencast: https://screencast-o-matic.com/watch/cF60IJYAsP

If record #1 is removed from the table and the import retried, then DB4S reports the same error, but this time on record #2. This confirms something. Not sure what. But something.

What did you do?

Imported records from a CSV file, which was from an exported table. The import was into the same table, so records were known to violate the primary key.

What did you expect to see?

The records known to violate the primary key would be ignored.

What did you see instead?

DB4S got kicked in the nuts, fell down on its knees and didn't get back up again.

Useful extra information

Please see the below screencast:
https://screencast-o-matic.com/watch/cF60IJYAsP

Note clicking Yes or No both locks up DB4S. So you're stuffed either way. 😆

The info below often helps, please fill it out if you're able to. :)

What operating system are you using?

• Windows: ( version: 10_ )
• Linux: ( distro: ___ )
• Mac OS: ( version: ___ )
• Other: ___

What is your DB4S version?

• 3.11.0-alpha*
• 3.10.1
• Other: ___

Did you also

• Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
• Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20