Recieving sqlite related errors, but dialect used is postgres #17305
Labels
pending-approval
Bug reports that have not been verified yet, or feature requests that have not been accepted yet
type: bug
Issue Creation Checklist
Bug Description
When connecting to, or querying database I am getting the error 'SQLITE_BUSY: database is locked' within an object that is consoled out in NodeJS, which includes database credentials. This happens with each transaction.
Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a, pg_namespace s WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'Specifications' AND s.oid = t.relnamespace AND s.nspname = 'blog' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname; {
plain: false,
raw: true,
logging: [Function: error],
timestamps: true,
validate: {},
freezeTableName: false,
underscored: false,
paranoid: false,
rejectOnEmpty: false,
whereCollection: null,
schema: 'blog',
schemaDelimiter: '',
defaultScope: {},
scopes: {},
indexes: [],
whereMergeStrategy: 'overwrite',
name: { plural: 'Specifications', singular: 'Specification' },
omitNull: false,
sequelize: <ref *1> Sequelize {
options: {
dialect: 'postgres',
dialectModule: null,
dialectModulePath: null,
host: 'localhost',
protocol: 'tcp',
define: {},
query: {},
sync: {},
timezone: '+00:00',
standardConformingStrings: true,
logging: [Function: error],
omitNull: false,
native: false,
replication: false,
ssl: undefined,
pool: [Object],
quoteIdentifiers: true,
hooks: {},
retry: [Object],
transactionType: 'DEFERRED',
isolationLevel: null,
databaseVersion: '16.2.0',
typeValidation: false,
benchmark: false,
minifyAliases: false,
logQueryParameters: false,
attributeBehavior: 'throw',
schema: 'blog'
},
config: {
database: 'ringworks',
username: 'OOPS!',
password: 'OOPS!',
host: 'localhost',
port: 5432,
pool: [Object],
protocol: 'tcp',
native: false,
ssl: undefined,
replication: false,
dialectModule: null,
dialectModulePath: null,
keepDefaultTimezone: undefined,
dialectOptions: undefined
},
dialect: PostgresDialect {
sequelize: [Circular *1],
connectionManager: [ConnectionManager],
queryGenerator: [PostgresQueryGenerator],
queryInterface: [PostgresQueryInterface]
},
queryInterface: PostgresQueryInterface {
sequelize: [Circular *1],
queryGenerator: [PostgresQueryGenerator]
},
models: { Graphics_Cards: Graphics_Cards, Specifications: Specifications },
modelManager: ModelManager { models: [Array], sequelize: [Circular *1] },
connectionManager: ConnectionManager {
sequelize: [Circular *1],
config: [Object],
dialect: [PostgresDialect],
versionPromise: null,
dialectName: 'postgres',
pool: [Pool],
lib: [PG],
nameOidMap: [Object],
enumOids: [Object],
oidParserMap: [Map]
}
},
hooks: true,
dialect: 'postgres',
dialectModule: null,
dialectModulePath: null,
host: 'localhost',
protocol: 'tcp',
define: {},
query: {},
sync: {},
timezone: '+00:00',
standardConformingStrings: true,
native: false,
replication: false,
ssl: undefined,
pool: { max: 10, min: 0, acquire: 30000, idle: 10000 },
quoteIdentifiers: true,
retry: { max: 5, match: [ 'SQLITE_BUSY: database is locked' ] },
transactionType: 'DEFERRED',
isolationLevel: null,
databaseVersion: 0,
typeValidation: false,
benchmark: false,
minifyAliases: false,
logQueryParameters: false,
attributeBehavior: 'throw',
force: false,
type: 'SHOWINDEXES'
}
Database and tables created successfully.
Reproducible Example
Here is the link to the SSCCE for this issue:
Would you be willing to resolve this issue by submitting a Pull Request?
Indicate your interest in the resolution of this issue by adding the 👍 reaction. Comments such as "+1" will be removed.
The text was updated successfully, but these errors were encountered: