You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
[x ] No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in resolving my issue.
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:
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: