Re: [Audacity-devel] Debug: SqliteSampleBlock::GetBlob - SQLITE error no more rows available

[Steve F. <ste...@gm...>]

"no more rows available" comes from "SQLITE_PRIVATE const char
*sqlite3ErrStr(int rc){"

    case SQLITE_DONE: {
      zErr = "no more rows available";
      break;
    }

According to the SQLite docs:

" The SQLITE_DONE result code indicates that an operation has completed.
The SQLITE_DONE result code is most commonly seen as a return value from
sqlite3_step() indicating that the SQL statement has run to completion. But
SQLITE_DONE can also be returned by other multi-step interfaces such as
sqlite3_backup_step()."


"Audacity failed to read from a file in %s." comes from:
"TranslatableString FileException::ErrorMessage() const"

      case Cause::Read:
         format = XO("Audacity failed to read from a file in %s.");
         break;

I've no idea how to trace it back from there. (Seems like a major downside
to having error messages detached from where the error actually  occurs).

Steve

On Tue, 13 Oct 2020 at 15:10, Arturo 'Buanzo' Busleiman <
bu...@bu...> wrote:

> Maximum Number Of Rows In A Table
>
> The theoretical maximum number of rows in a table is 264
> (18446744073709551616 or about 1.8e+19). This limit is unreachable since
> the maximum database size of 281 terabytes will be reached first. A 281
> terabytes database can hold no more than approximately 2e+13 rows, and then
> only if there are no indices and if each row contains very little data.
>
> Yep, it shouldn't happen. So it probably is related to what you noticed
> "Audacity failed to read from a file in /var/tmp/audacity-steve/"
>
> On Tue, Oct 13, 2020 at 8:53 AM Steve Fiddle <ste...@gm...>
> wrote:
>
>> Debug: SqliteSampleBlock::GetBlob - SQLITE error no more rows available
>>
>> I'm guessing that this should not happen?
>>
>> Is that the cause of the error message:
>> "Audacity failed to read from a file in /var/tmp/audacity-steve/."
>>
>> This error is repeatable when using a macro that works in 2.4.2.
>> Here's a simplified version of the Macro (note that this should be run
>> with default preferences)
>>
>> --- start ---
>> SelectAll:
>> Cut:
>> Select:End="100" Mode="Set" RelativeTo="ProjectStart" Start="10"
>> Paste:
>> ExportMp3:
>>
>> --- end ---
>>
>> Steve
>> _______________________________________________
>> audacity-devel mailing list
>> aud...@li...
>> https://lists.sourceforge.net/lists/listinfo/audacity-devel
>>
> _______________________________________________
> audacity-devel mailing list
> aud...@li...
> https://lists.sourceforge.net/lists/listinfo/audacity-devel
>