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 the deployment occurs, the following error occurs: DBError(Execute(Database(PgDatabaseError { severity: Error, code: "42P05", message: "prepared statement \"sqlx_s_1\" already exists",
I believe this is being fixed "disable_statement_logging"
use crate::settings::Settings;
use db_core::prelude::*;
pub type BoxDB = Box<dyn MCDatabase>;
pub mod pg {
use super::*;
use db_sqlx_postgres::{ConnectionOptions, Fresh};
use sqlx::postgres::PgPoolOptions;
pub async fn get_data(settings: Option<Settings>) -> BoxDB {
let settings = settings.unwrap_or_else(|| Settings::new().unwrap());
let pool = settings.database.pool;
let pool_options = PgPoolOptions::new().max_connections(pool);
let connection_options = ConnectionOptions::Fresh(Fresh {
pool_options,
url: settings.database.url.clone(),
disable_logging: !settings.debug,
});
let db = connection_options.connect().await.unwrap();
db.migrate().await.unwrap();
Box::new(db)
}
}
However, I don't understand how to enable it. Judging by the source code, you need to change the debug = true setting for this. But it didn't work for me.
The text was updated successfully, but these errors were encountered:
I believe this is being fixed "disable_statement_logging"
Can you please explain how you arrived at this solution?
you need to change the debug = true setting for this. But it didn't work for me.
Setting debug = true in the configuration file instructs the database driver to increase verbosity while logging. I don't know if it will have any effect on the database itself.
Searching on the internet yielded results related to database drivers, which leads me to believe that this is a problem with the database driver we are using. We are not using the latest version, so I'll update it and see if it helps.
When the deployment occurs, the following error occurs:
DBError(Execute(Database(PgDatabaseError { severity: Error, code: "42P05", message: "prepared statement \"sqlx_s_1\" already exists",
I believe this is being fixed "disable_statement_logging"
However, I don't understand how to enable it. Judging by the source code, you need to change the debug = true setting for this. But it didn't work for me.
The text was updated successfully, but these errors were encountered: