USB stick detaches itself few seconds after inserting. What caused it and how to fix it?

ID from lsusb: "Silicon Motion, Inc. - Taiwan (formerly Feiya Technology Corp.) Flash Drive". It appears in lsusb for a brief moment but not after it detaches itself.

dmesg:

[1631945.747782] usb-storage 1-2.4.4:1.0: USB Mass Storage device detected
[1631945.748241] scsi host7: usb-storage 1-2.4.4:1.0
[1631947.121728] scsi 7:0:0:0: Direct-Access                                    PQ: 0 ANSI: 6
[1631947.122336] sd 7:0:0:0: Attached scsi generic sg5 type 0
[1631947.122344] sd 7:0:0:0: Embedded Enclosure Device
[1631947.123021] sd 7:0:0:0: Wrong diagnostic page; asked for 1 got 0
[1631947.123030] sd 7:0:0:0: Failed to get diagnostic page 0x1
[1631947.123036] sd 7:0:0:0: Failed to bind enclosure -19
[1631947.123982] sd 7:0:0:0: [sdd] 61440000 512-byte logical blocks: (31.5 GB/29.3 GiB)
[1631947.124794] sd 7:0:0:0: [sdd] Write Protect is off
[1631947.124801] sd 7:0:0:0: [sdd] Mode Sense: 43 00 00 00
[1631947.125553] sd 7:0:0:0: [sdd] Write cache: enabled, read cache: enabled, doesn't support DPO or FUA
[1631947.250374] sd 7:0:0:0: [sdd] Attached SCSI removable disk
[1631979.192107] usb 1-2.4.4: reset high-speed USB device number 7 using xhci_hcd
[1631984.303880] usb 1-2.4.4: device descriptor read/64, error -110
[1631999.919849] usb 1-2.4.4: device descriptor read/64, error -110
[1632000.115911] usb 1-2.4.4: reset high-speed USB device number 7 using xhci_hcd
[1632000.203905] usb 1-2.4.4: device descriptor read/64, error -71
[1632000.399971] usb 1-2.4.4: device descriptor read/64, error -71
[1632000.591924] usb 1-2.4.4: reset high-speed USB device number 7 using xhci_hcd
[1632000.592040] usb 1-2.4.4: Device not responding to setup address.
[1632000.799945] usb 1-2.4.4: Device not responding to setup address.
[1632001.007827] usb 1-2.4.4: device not accepting address 7, error -71
[1632001.087835] usb 1-2.4.4: reset high-speed USB device number 7 using xhci_hcd
[1632001.087986] usb 1-2.4.4: Device not responding to setup address.
[1632001.299920] usb 1-2.4.4: Device not responding to setup address.
[1632001.507835] usb 1-2.4.4: device not accepting address 7, error -71
[1632001.509987] sd 7:0:0:0: [sdd] tag#0 FAILED Result: hostbyte=DID_TIME_OUT driverbyte=DRIVER_OK cmd_age=54s
[1632001.510000] sd 7:0:0:0: [sdd] tag#0 CDB: Read(10) 28 00 03 a9 7e f8 00 00 08 00
[1632001.510004] blk_update_request: I/O error, dev sdd, sector 61439736 op 0x0:(READ) flags 0x80700 phys_seg 1 prio class 0
[1632001.512590] usb 1-2.4.4: USB disconnect, device number 7
[1632001.527992] blk_update_request: I/O error, dev sdd, sector 61439736 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
[1632001.528012] Buffer I/O error on dev sdd, logical block 7679967, async page read
[1632001.647910] usb 1-2.4.4: new high-speed USB device number 8 using xhci_hcd
[1632001.731899] usb 1-2.4.4: device descriptor read/64, error -71
[1632001.920012] usb 1-2.4.4: device descriptor read/64, error -71
[1632002.111913] usb 1-2.4.4: new high-speed USB device number 9 using xhci_hcd
[1632002.191886] usb 1-2.4.4: device descriptor read/64, error -71
[1632002.383947] usb 1-2.4.4: device descriptor read/64, error -71
[1632002.492567] usb 1-2.4-port4: attempt power cycle
[1632003.103859] usb 1-2.4.4: new high-speed USB device number 10 using xhci_hcd
[1632003.103973] usb 1-2.4.4: Device not responding to setup address.
[1632003.312027] usb 1-2.4.4: Device not responding to setup address.
[1632003.523864] usb 1-2.4.4: device not accepting address 10, error -71
[1632003.607848] usb 1-2.4.4: new high-speed USB device number 11 using xhci_hcd
[1632003.607992] usb 1-2.4.4: Device not responding to setup address.
[1632003.816284] usb 1-2.4.4: Device not responding to setup address.
[1632004.023909] usb 1-2.4.4: device not accepting address 11, error -71
[1632004.024849] usb 1-2.4-port4: unable to enumerate USB device

On Windows, I get a "USB device not recognized" error. A different computer also doesn't recognize it. There is clearly something wrong with that flash drive.

The flash drive is a hybrid (USB-A and USB-OTG) flash drive. A smartphone I tested it with doesn't recognize it either.

Does anyone have an idea what caused this and how to make the USB stick work again?

And has anyone had similar experiences or is this an isolated occurance?