[Bug] Immediate app crash upon start after updating to v4.3.0 and v4.3.1

[muchqs]

Checklist (Your issue will be automatically closed if you delete this part)

• I make sure that there are no existing issues - open or closed - which I could contribute my information to.
• I understand that issues with limited impact, such as those occurring on specific devices or under specific network conditions, will not be fixed.
• I am able to reproduce the bug with the latest version given here: CLICK THIS LINK.
• I have attached the error report in the issue.

Describe the bug
App crashes immediately on start. Started happening immediately after updating to v4.3.0 and then the latest v4.3.1. Never happened on v4.2.4.

Frequency
100%

Steps to reproduce the bug
Try to start app, app crashes.

Device (e.g. Pixel 9 Pro)
Lenovo Yoga 11 tablet

Error report

Exception

• User Action: ui error
• Request: ACRA report
• Content Country: CA
• Content Language: en-CA
• App Language: en_CA
• Service: none
• Version: 4.3.1
• OS: Linux Android 12 - 31

Crash log

android.database.sqlite.SQLiteConstraintException: UNIQUE constraint failed: streams.service_id, streams.url (code 2067 SQLITE_CONSTRAINT_UNIQUE)
	at android.database.sqlite.SQLiteConnection.nativeExecuteForChangedRowCount(Native Method)
	at android.database.sqlite.SQLiteConnection.executeForChangedRowCount(SQLiteConnection.java:892)
	at android.database.sqlite.SQLiteSession.executeForChangedRowCount(SQLiteSession.java:756)
	at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:67)
	at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1921)
	at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1842)
	at androidx.sqlite.db.framework.FrameworkSQLiteDatabase.execSQL(FrameworkSQLiteDatabase.java:265)
	at org.schabi.newpipe.database.Migrations$9.migrate(Migrations.java:379)
	at androidx.room.RoomOpenHelper.onUpgrade(RoomOpenHelper.java:99)
	at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper$OpenHelper.onUpgrade(FrameworkSQLiteOpenHelper.java:183)
	at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:416)
	at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:316)
	at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper$OpenHelper.getWritableSupportDatabase(FrameworkSQLiteOpenHelper.java:151)
	at androidx.sqlite.db.framework.FrameworkSQLiteOpenHelper.getWritableDatabase(FrameworkSQLiteOpenHelper.java:112)
	at androidx.room.RoomDatabase.inTransaction(RoomDatabase.java:706)
	at androidx.room.RoomDatabase.assertNotSuspendingTransaction(RoomDatabase.java:483)
	at androidx.room.RoomDatabase.query(RoomDatabase.java:526)
	at androidx.room.util.DBUtil.query(DBUtil.java:86)
	at org.schabi.newpipe.database.stream.dao.StreamDAO_Impl$11.call(StreamDAO_Impl.java:749)
	at org.schabi.newpipe.database.stream.dao.StreamDAO_Impl$11.call(StreamDAO_Impl.java:746)
	at io.reactivex.rxjava3.internal.operators.maybe.MaybeFromCallable.subscribeActual(MaybeFromCallable.java:47)
	at io.reactivex.rxjava3.core.Maybe.subscribe(Maybe.java:5330)
	at io.reactivex.rxjava3.internal.operators.flowable.FlowableFlatMapMaybe$FlatMapMaybeSubscriber.onNext(FlowableFlatMapMaybe.java:131)
	at io.reactivex.rxjava3.internal.operators.flowable.FlowableObserveOn$ObserveOnSubscriber.runAsync(FlowableObserveOn.java:402)
	at io.reactivex.rxjava3.internal.operators.flowable.FlowableObserveOn$BaseObserveOnSubscriber.run(FlowableObserveOn.java:176)
	at io.reactivex.rxjava3.internal.schedulers.ExecutorScheduler$ExecutorWorker$BooleanRunnable.run(ExecutorScheduler.java:322)
	at io.reactivex.rxjava3.internal.schedulers.ExecutorScheduler$ExecutorWorker.runEager(ExecutorScheduler.java:287)
	at io.reactivex.rxjava3.internal.schedulers.ExecutorScheduler$ExecutorWorker.run(ExecutorScheduler.java:248)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:644)
	at java.lang.Thread.run(Thread.java:1012)

---

Additional context

[InfinityLoop1308]

Can't reproduce it so I have to assume that is a device specific issue.
If you need the data you can send me the backup and I can help you fix it.

[muchqs]

I would like to backup my data, like saved playlists etc. But how do I back them up when I can't even open the app? Can I copy out the saved data somehow via file manager? Thanks.

[InfinityLoop1308]

https://send.dogy.cloud/download/f80e73c7df215715/#K1AjQEIBZl4Ls8i0Rx_vCg

use the patched apk -> backup -> reinstall the origin release

[muchqs]

Thank you! Just followed your instructions and got my data back.
How come the patched one doesn't crash on start :O