Re: [Audacity-devel] Internal Error DBConnection

[Jack L. <xxj...@gm...>]

It looks like it's using the system version which does have dbpage
table support compiled in.

-- ========== Configuring sqlite ==========
-- Checking for module 'sqlite3 >= 3.32.0'
--   Found sqlite3 , version 3.34.1
-- Using 'sqlite' system library

usr/ports/databases/sqlite3 # make showconfig
===> The following configuration options are available for sqlite3-3.34.1,1:
    ARMOR=off: Detect misuse of the API
    DBPAGE=on: Enable DBPAGE Virtual Table
    DBSTAT=on: Enable DBSTAT Virtual Table
    DIRECT_READ=on: File is read directly from disk
    DQS=on: Double-quoted String Literals
    EXTENSION=on: Allow loadable extensions
    FTS3_TOKEN=on: Enable two-args version fts3_tokenizer
    FTS4=on: Enable FTS3/4 (Full Text Search) module
    FTS5=on: Enable version 5 full-text search engine
    LIKENOTBLOB=off: LIKE does not match blobs
    MEMMAN=off: Allow it to release unused memory
    METADATA=on: Enable column metadata
    NORMALIZE=off: Enable normalized sql function
    NULL_TRIM=off: Omits NULL columns at the ends of rows
    RBU=off: Enable the resumable bulk update
    SECURE_DELETE=on: Overwrite deleted information with zeros
    SORT_REF=off: To use references in the sorter
    STMT=off: Prepared statement scan status
    STSHELL=on: Statically link libsqlite3 into shell
    TCL=off: Enable tcl extension and sqlite_analyzer
    THREADS=on: Threading support
    TRUSTED_SCHEMA=off: SQL functions & virtual tables are considered unsafe
    UNKNOWN_SQL=off: Suppress unknown function errors
    UNLOCK_NOTIFY=on: Enable notification on unlocking
    URI=on: Enable use the URI filename
    URI_AUTHORITY=off: Allow convert URL into a UNC
====> Optional extensions
    JSON1=off: Enable the JSON1 extension
    SESSION=off: Enable the session extension
====> Optional functions
    OFFSET=off: Enable sqlite_offset() returning record's file offset
    SER1=off: Enable the sqlite3_[de]serialize() interface
    SOUNDEX=off: Enable the soundex() SQL function
====> Unicode support
    ICU=off: Unicode support via ICU
    UNICODE61=on: Unicode Version 6.1 tokenizer
====> Index type for range queries
    RTREE=on: Enable R*Tree module
    RTREE_INT=off: Store 32-bit sig int (no float) coordinates
    GEOPOLY=off: Uses the GeoJSON notation (RFC-7946)
====> Where to store temporary file: you have to select exactly one of them
    TS0=off: Always use temporary file
    TS1=off: File by default, change allowed PRAGMA
    TS2=off: Memory by default, change allowed PRAGMA
    TS3=on: Always use memory
====> Which query planner to use, stability or ...: you can only
select none or one of them
    STAT3=off: Collect histogram data from leftmost column
    STAT4=off: Collect histogram data from all columns
====> Command line editing library: you can only select none or one of them
    READLINE=off: Command line editing via libreadline
    LIBEDIT=off: Command line editing via libedit

On Sat, Mar 27, 2021 at 9:11 PM Leland <ll...@ho...> wrote:
>
> Are you using FreeBSD's sqlite3 package or the one we supply?  We require the sqlite "dbpage table" support be compiled in.  This is controlled with the SQLITE_ENABLE_DBPAGE_VTAB sqlite3 compile define.
>
> > -----Original Message-----
> > From: Jack L. <xxj...@gm...>
> > Sent: Saturday, March 27, 2021 10:28 PM
> > To: Audacity-Devel list <aud...@li...>
> > Subject: [Audacity-devel] Internal Error DBConnection
> >
> > I was using the latest audacity 3.0.0 with all the patches on FreeBSD and just
> > came across an "Internal Error". I ctrl+o and opened file1,
> > ctrl+o another file 2, closed file 1, following message appears:
> >
> > 20:21:04: Debug: Cached a statement for 3
> > 20:21:36: Debug: Cached a statement for 1
> > 20:21:54: Debug: Cached a statement for 6
> > 20:21:54: Debug: prepare error no such table: sqlite_dbpage
> >
> > and then internal error in screenshot. After closing all the dialogs, it was
> > working normally again.
>
>
>
> _______________________________________________
> audacity-devel mailing list
> aud...@li...
> https://lists.sourceforge.net/lists/listinfo/audacity-devel