SqliteException(6922): disk I/O error Occurs During Amplify Storage File Upload in Flutter App

[bjmcallister]

Description

I'm experiencing a SqliteException(6922): disk I/O error when attempting to upload a video file using Amplify.Storage.uploadFile in my Flutter application. This error arises specifically during an INSERT operation into the transfer_records table within the SQLite database. The issue prevents successful uploads and disrupts the user experience.

Steps to Reproduce
Ensure the Flutter environment is correctly set up with all necessary dependencies.
Amplify is properly configured for storage in the Flutter app.

Code Execution
Trigger the upload process, which involves generating a UUID, checking file existence, creating an AWSFile instance, and invoking Amplify.Storage.uploadFile.

Error Trigger
During the execution of the uploadFile method, the app attempts to insert a new record into the transfer_records table.
The SqliteException(6922): disk I/O error is thrown at this point.
Expected Behavior
The video file should upload successfully to AWS Amplify Storage, and a corresponding record should be inserted into the transfer_records SQLite table without any errors.

Actual Behavior
An exception is thrown during the upload process, preventing the insertion of a new record into the transfer_records table and halting the upload operation.

SqliteException(6922): while executing statement, disk I/O error, disk I/O error (code 6922) Causing statement: INSERT INTO "transfer_records" ("upload_id", "object_key", "created_at") VALUES (?, ?, ?), parameters: IGn7zlX4vYK00bsxjMlTdd.UMaskDNIG21RylQ9ac6vA0vP4HBK8f71puCH0.PakERK7pymwvWbLEOkvLcuoPkkcqH2OUKwq987TmPDLewhbPDSvFrjwJRw2VseCzN6YMzZSdQp3JJeq1zVGJ9ZUi_FoTYurhFNFaEdbUvrTRx8-, videos/46c572e2-70d4-41de-b612-a5a82e952cce.mp4, 2024-10-18T11:40:47.705803 Reloaded 1 of 3917 libraries in 1,212ms (compile: 169 ms, reload: 501 ms, reassemble: 498 ms).

final uuid = Uuid();
final String keyName = uuid.v4();

final file = File(pendingUpload.path);
if (!await file.exists()) {
  throw Exception(
      'File does not exist at path: ${pendingUpload.path}');
}

// Create an AWSFile instance after confirming the file exists
final awsFile = AWSFile.fromPath(pendingUpload.path);

// Use a dynamic storage path to avoid conflicts
final result = Amplify.Storage.uploadFile(
  localFile: awsFile,
  path: StoragePath.fromString('videos/$keyName.mp4'),
  options: const StorageUploadFileOptions(
    metadata: {
      'project': 'salesmail',
    },
  ),
).result;

await result;

Categories

• Analytics
• API (REST)
• API (GraphQL)
• Auth
• Authenticator
• DataStore
• Notifications (Push)
• Storage

Steps to Reproduce

Ensure the Flutter environment is correctly set up with all necessary dependencies.
Amplify is properly configured for storage in the Flutter app.

Screenshots

No response

Platforms

• iOS
• Android
• Web
• macOS
• Windows
• Linux

Flutter Version

3.24.3

Amplify Flutter Version

2.1.0 & 2.4.0

Deployment Method

Amplify Gen 2

Schema

No response

[bjmcallister]

14d4a010-ad43-4764-b439-686a0bc13885.MOV

e56b6984-0c2f-45f3-8382-dd45be287a82.MOV

Two videos. The longer one does not work while the shorter one does.

[NikaHsn]

Sorry that you are facing this issue. We will look into this and get back to you when we have updates.