Widget UI stops updating in the middle of counterProvider changes

[jegrasso19]

I'm using a progress indicator and counterProvider to track the loading progress of data into a Drift SQLite database in my app. The counterProvider is used to show the percentage of data loaded. Half way through the loading process, the UI stops showing any progress. I've confirmed the counterProvider is updating correctly to the end using ref.listen so I can't figure out what's stopping the UI from showing completion to 100%. I have 40 steps to load my data so the counter increments by 2.5 for each step. The database typically loads in less than 4 seconds. Is there a limit to how quickly the provider can respond? It stops once the data is actually getting added to the database which is at step 20. Am I approaching this the wrong way?

I get the same results whether I'm using the iOS simulator or the Android simulator. I'm using a MacBook M4 Max, so I don't think it's a horsepower issue but it always stops once I start my batch insert of data into the database.

Here is my counterProvider:

import 'package:riverpod_annotation/riverpod_annotation.dart';

part 'counter_provider.g.dart';

@riverpod
class Counter extends _$Counter {
  final _initialValue = 0.0;

  @override
  FutureOr<double> build() async {
    ref.onDispose(() {
      print('[counterProvider] disposed');
    });
    return _initialValue;
  }

  Future<void> increment() async {
    state = const AsyncLoading();

    state = await AsyncValue.guard(() async {
      if (state.value! >= 100) {
        return 100;
      } else {
        return state.value! + 2.5;
      }
    });
  }
}

Here is my progress indicator widget, which gets called during the loading phase of my .when call:

import 'dart:io';

import 'package:flutter/cupertino.dart';
import 'package:flutter/material.dart';
import 'package:flutter_riverpod/flutter_riverpod.dart';
import 'package:product_plus/providers/counter_provider.dart';

class ProgressIndicatorWheel extends ConsumerWidget {
  const ProgressIndicatorWheel({
    super.key,
  });

  @override
  Widget build(BuildContext context, WidgetRef ref) {
    final counter = ref.watch(counterProvider);

    ref.listen(counterProvider, (prev, next) {
      if (next is AsyncError) {
        ScaffoldMessenger.of(context).showSnackBar(
          const SnackBar(
            content: Text('Counter Not working')
          )
        );
      } else {
        print('Previous = $prev; Next = $next');
      }
    });

    return Column(
      mainAxisAlignment: MainAxisAlignment.center,
      children: <Widget>[
        Text(
          'Data Loading',
          style: Theme.of(context).textTheme.titleMedium!.copyWith(
            fontWeight: FontWeight.bold,
          ),
        ),
        const SizedBox(height: 10),
        Platform.isIOS || Platform.isMacOS
        ? const CupertinoActivityIndicator(
          radius: 15.0,
          color: CupertinoColors.activeGreen,
        )
        : CircularProgressIndicator(
          backgroundColor: Colors.grey,
          color: Colors.green,
          strokeWidth: 5,
          value: counter.value! / 100,
        ),
        const SizedBox(height: 10),
        Text(
          'Percent Complete: ${counter.value!}%',
          style: Theme.of(context).textTheme.titleMedium!.copyWith(
            fontWeight: FontWeight.bold,
          ),
        ),
      ],
    );
  }
}

Here is a screenshot of my data loading. It always stops at 47.5%.

[rrousselGit]

I doubt Riverpod bits are the issue here
My guess is that whatever calls "increment" stops doing so at some point.