| 854 | ` |
| 855 | }) |
| 856 | const complete = (sequence: number, attempts: number) => { |
| 857 | elementIds.delete(sequence) |
| 858 | return sql` |
| 859 | UPDATE ${tableNameSql} |
| 860 | SET acquired_at = NULL, acquired_by = NULL, updated_at = ${sqlNow}, completed = ${sqlTrue}, attempts = ${attempts} |
| 861 | WHERE sequence = ${sequence} |
| 862 | AND acquired_by = ${workerIdSql} |
| 863 | `.pipe( |
| 864 | Effect.retry({ |
| 865 | times: 5, |
| 866 | schedule: Schedule.exponential(100, 1.5) |
| 867 | }), |
| 868 | Effect.orDie |
| 869 | ) |
| 870 | } |
| 871 | const retry = (sequence: number, attempts: number, cause: Cause.Cause<any>) => { |
| 872 | elementIds.delete(sequence) |
| 873 | return sql` |