Dbi autocommit sqlite

First, please forgive me. I am as new as can be with R. I'm sure my code is awful, but for the most part, it's getting the job I need to get done... well, done..
I'm selecting a bunch of data from an SQLITE database using DBI, like this

res <- dbSendQuery(con, "SELECT * FROM D_S00_00_000_2024_4_16_23_31_25 ORDER BY UID") res <- dbSendQuery(con, sqlQuery) data = fetch(res) 

I'm then taking it through a for loop and plotting a bunch of data, like this

for (chan in 1:32) { x = data[,5] y = data[,38 + chan] fullfile = paste("C:\Outputs\Channel_", chan, ".pdf", sep = "") chantitle = paste("Channel ", chan, sep = "") pdf(file = fullfile, width = 16.5, height = 10.5) plot(x, y, main = chantitle, col = 2) dev.off() } 

All works great. Only thing is that my data has some outliers in it that I need to remove. I know what they are, and they can be safely ignored, but they're polluting the plots something terrible. I could use ylim = c(val, val) in my plot line, but that's not really what I want. that forces the y limits to those values, and I really want them to auto-scale to the [data - outliers].
What I'd like to do is actually remove the outliers from the dataset inside of the for loop. pseudo code would be something like

x = data[,5] where [,38] < 100.5 y = data[,38 + chan] where [,38] < 100.5 

Can anyone tell me how to accomplish that? I want to remove all x and y rows where y is greater than 100.5
​
Thanks very much for any help!

I am experienced with SQL Server and typically use Microsoft SQL Server Management Studio to work with SQL Server. Today, I started using SQLite for the furst time, from within the R statistical computing environment, using the R DBI package.
From within R, I created a SQLite database with one table that has ~68 million rows and 10 columns, and I saved this database to disk. The file size of the db on disk is ~ 10.2 gb.
Q. For creating and testing complex queries on this table and database, what SQLite interface(s) should I know about and try out?

I am trying to learn if there is a way to "simulate" an SQL connection within R that lets me test Netezza SQL.
I know how to do this with an "SQLite" connection - here, I am making a temporary connection "on the spot":

library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "iris", iris) DBI::dbGetQuery(con, "select a.* from (select *, row_number() over (order by `Petal.Length`) as rnum from iris) a limit 5;") 

But is it possible to make such an "on the spot" connection with a Netezza SQL connection? In other words - could I try replacing the SQL code in this question with NETEZZA specific SQL functions (e.g. TO_CHAR)?
Thanks!
Note: If this does not work - is there some other way to create datasets and test NETEZZA SQL queries on them in some simulated/test environment?

Does anyone know if there are any websites to try Netezza SQL queries at home (e.g. create a sample table and try some queries)? I looked at websites like DB FIDDLE and SQL FIDDLE but none of these seem to support Netezza SQL.
I would have used an alternative, but I wanted to try some queries involving Netezza specific functions such as TO_CHAR().
Does anyone know about this?
Thanks!
Note: Using R Programming language, I know how to simulate other types of SQL connections - for example:

library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "iris", iris) DBI::dbGetQuery(con, "select a.* from (select *, row_number() over (order by `Petal.Length`) as rnum from iris) a limit 5;") 

STATUS: Solved
INFO: Original post has been explained after "LAST EDIT" section.
LAST EDIT: This folder was a copied folder. I should have changed the folder names in the imported parts. Unfortunately I forgot them. After I changed those parts there was sqlite path problem between the flask app and the script. Because the flask app runs on WSL, the script runs on cmd. So I fixed importing errors and ran everything with cmd. The application is working right now. This is an embarrassing mistake but title of the post is very obvious, next time a developer might use this information.
Final folder tree:

. ├── main_app │ ├── dashboard/ │ ├── home/ │ ├── database.py │ ├── __init__.py │ ├── models.py │ ├── run.py ├── test.db 

run.py:

from main_app import app from main_app.database import init_db with app.app_context(): init_db() if __name__ == '__main__': app.run(debug=True) 

__init__.py. By the way I don't understand why we put "teardown_appcontext" part.

from flask import Flask from main_app.database import db_session app=Flask(__name__) from main_app.home.routes import home from main_app.dashboard.routes import dashboard app.register_blueprint(home,url_prefix='/') app.register_blueprint(dashboard,url_prefix='/dashboard') @app.teardown_appcontext def shutdown_session(exception=None): db_session.remove() 

database.py

from sqlalchemy.orm import declarative_base from sqlalchemy.orm import scoped_session,sessionmaker from sqlalchemy import Column, Integer, String, create_engine engine=create_engine('sqlite:///C:\\folder\\main_app\\test.db',echo=True,future=True) db_session=scoped_session(sessionmaker(autocommit=False,autoflush=False,bind=engine)) Base=declarative_base() Base.query = db_session.query_property() def init_db(): import main_app.models #CREATE DATABASE TABLE FOR THE FIRST TIME Base.metadata.create_all(engine) 

script.py under dashboard folder. I created a bat file for invoking this. I will use it with Windows Scheduler later.

from main_app import app from main_app.database import engine,db_session def script(): #do something db_session.close() db_session.remove() script() 

ORIGINAL POST:
Dear Flask developers,
I was trying to use a script with my flask app but having app_context() errors then I decided to go with declarative approach.
I used link below as source:
https://flask.palletsprojects.com/en/1.1.x/patterns/sqlalchemy/#declarative
This is my folder structure:

. ├── main_app │ ├── dashboard │ ├── home │ ├── database.py │ ├── __init__.py │ ├── models.py │ ├── run.py ├── test.db 

run.py:

#run.py from main_app import app from main_app.database import init_db init_db() if __name__ == '__main__': app.run(debug=True) 

./main_app/__init__.py

from flask import Flask from main_app.database import db_session app=Flask(__name__) from main_app.home.routes import home from main_app.dashboard.routes import dashboard app.register_blueprint(home,url_prefix='/') app.register_blueprint(dashboard,url_prefix='/dashboard') @app.teardown_appcontext def shutdown_session(exception=None): db_session.remove() 

This is inside the script.py:

#!python3 #script.py from main_app.database import db_session 

then imported the functions inside 'db_operations' and models

#script.py from main_app.dashboard.db_operations import dbfunc from main_app.models import User def script(): dbfunc(db_session) ... script() 

But I'm still having this error:

This typically means that you attempted to use functionality that needed the current application. To solve this, set up an application context with app.app_context(). See the documentation for more information. 

Could you please explain why am I still having this issue?
EDIT 1:
There is also this warning:

sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 140600948639296 and this is thread id 140600999774016. Exception closing connection  

EDIT 2:
I'm no longer taking the warning in EDIT 1. Also the flask app makes a query in order to list users in a template but there is another script that I manually activate and that script also queries that same table. Whenever I run that script with cmd I got app_context() error.

For this example lets pretend that Django doesn't support SQLite, but it can be anything from in-memory databases to search engines. Anyway let's say I have something like this:

import sqlite3 class DataBase: def __init__(self, db): self.conn = sqlite3.connect(db) self.c = self.conn.cursor() self.c.execute("""CREATE TABLE IF NOT EXISTS customers ( customer_id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT, password TEXT, )""") def insert_customer(self, fn, ln, pw): self.c.execute("""INSERT INTO customers (first_name, last_name, password) VALUES (?, ?, ?)""", (fn, ln, pw)) self.conn.commit() ... other methods ... def close_connection(self): self.conn.close() dbi = DataBase("user_data.db") 

where would I put this code to make sure that everything will work if I want to use that dbi instance in my views, or what would be an appropriate place since it should run upon import anyway?

Hi everyone! I have a problem creating an executable using the sqlite library (and also using cb-dbi).
(I use Debian 11 and sbcl 2.1.1)
This is the code:
(ql:quickload :sqlite)
(in-package :sqlite)
(defvar *db* (sqlite:connect "/home/claudio/temp/test.db"))
(defun main ()
(sqlite:execute-single *db* "select filename from info"))
When I eval the "main" function within sbcl, it works as expected, but if I create an executable with:
(sb-ext:save-lisp-and-die #P"exe1" :toplevel #'main :executable t)
when I run it, I get this error:
Memory fault at 0x55d3ff39dcd8 (pc=0x7f38988affff, fp=(nil), sp=0x7f3898bffc50) tid 58662
The integrity of this image is possibly compromised.
Continuing with fingers crossed.
debugger invoked on a SB-SYS:MEMORY-FAULT-ERROR in thread
#:
Unhandled memory fault at #x55D3FF39DCD8.
Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.
restarts (invokable by number or by possibly-abbreviated name):
0: [ABORT] Exit from the current thread.
(SB-SYS:MEMORY-FAULT-ERROR # #.(SB-SYS:INT-SAP #X55D3FF39DCD8))
Does anybody know why?
Thankyou very much!

Has anyone ever tried to create/define CTE's (SQL) in R?
For example - suppose you have this table:

 library(dplyr) library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "iris", iris) 

Suppose I wanted to define two CTE's:

# does not work WITH CTE_1 AS ( DBI::dbGetQuery(con, "SELECT * FROM iris WHERE (Species = 'setosa') ORDER BY RANDOM();") ) WITH CTE_2 AS ( DBI::dbGetQuery(con, "SELECT * FROM iris WHERE (Species = 'versicolor') ORDER BY RANDOM();") ) 

Then, I would want to call these CTE's

 DBI::dbGetQuery(con, "SELECT count(*) from CTE_1 as A, Select count(*) from CTE_2 as B") 

But this obviously does not work - does anyone know how to fix this?
Thanks!

Pretend I have this table on a server:

library(dplyr) library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") iris$id = 1:nrow(iris) dbWriteTable(con, "iris", iris) 

I want to select some some random rows from this dataset - suppose I create an R variable that contains the random rows that I want to select:

rows_to_select = sample.int(10, 5, replace = TRUE) [1] 1 1 8 8 7 

I then tried to select these rows from my table - but this "rows_to_select" variable is not being recognized for some reason:

DBI::dbGetQuery(con, "select a.* from (select *, row_number() over (order by id) as rnum from iris)a where a.rnum in (rows_to_select) limit 100;") Error: no such column: rows_to_select 

This code works fine if I manually specify which rows I want (e.g. I want the first row, and the fifth row selected twice):

#works - but does not return the 5th row twice DBI::dbGetQuery(con, "select a.* from (select *, row_number() over (order by id) as rnum from iris)a where a.rnum in (1,5,5) limit 100;") 

• Does anyone know how to fix this?

Thank you!

I want to sample a file WITH REPLACEMENT on a server using SQL with R:
Pretend that this file in the file I am trying to sample:

library(dplyr) library(DBI) con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "iris", iris) 

I want to sample with replacement 30 rows where species = setosa and 30 rows where species = virginica. I used the following code to do this:

rbind(DBI::dbGetQuery(con, "SELECT * FROM iris WHERE (`Species` = 'setosa') ORDER BY RANDOM() LIMIT 30;"), DBI::dbGetQuery(con, "SELECT * FROM iris WHERE (`Species` = 'virginica') ORDER BY RANDOM() LIMIT 30;")) 

However at this point, I am not sure if the random sampling being performed is WITH REPLACEMENT or WITHOUT REPLACEMENT.

• Can someone please help me determine if the random sampling being performed is WITH REPLACEMENT or WITHOUT REPLACEMENT - and if it is being done WITHOUT REPLACEMENT, how can I change this so that its done WITH REPLACEMENT?

Thank you!

We just upgraded one of our database servers from Oracle 12.2.0.1 to 19.15.0 and one our perl programs is behaving differently. We are running with RedHat 8.4 using Perl v5.26.3 and the latest DBD::Oracle (1.83)and DBI (1.643) from cpan.
Under 19c, a forked child hangs on exit if the parent has (or had) an oracle connection where the connection handle is a global (declared with 'our'). This does not happen if the connection handle is a local (declared with 'my'). When running against a 12c database, with DBD::Oracle using 12c libraries, the child process exits normally regardless of how the variable is 'declared'.
Note also that this issue does not happen if the child exec's another program.
The block of code below exhibits the issue in our environment. This is just a simplification. The real code uses packages and so the connection handle needs to be a global.
Any help appreciated.
​

use strict; use warnings; use DBI; # If $dbh declared with my, this works witn 19c # otherwise, exit in child below never returns our $dbh = DBI->connect('dbi:Oracle:ORCL', 'scott', 'tiger', { RaiseError => 1, AutoCommit => 0, PrintError => 0, InactiveDestroy => 1 }); print "Connected to db\n"; $dbh->disconnect; #undef $dbh; # This fixes issue my $pid; $pid = fork; if( $pid == 0 ) { print "This is child process\n"; print "Child process exiting now\n"; exit 0; # Never returns if $dbh is a global } print "This is parent process and child ID is $pid\n"; print "Parent Waiting on child\n"; my $chldPid = wait; print "Parent done. Child pid $chldPid has completed\n"; exit 0; 

I'm currently learning flask and every tutorial I've gone through uses db.
Example:

class User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) 

I noticed in flask-security-too's example code they dont add db. to every column and I'm assuming this is because they are passing in Base rather than db.Model
Example:

class User(Base): id = Column(db.Integer, primary_key=True) username = Column(String(80), unique=True, nullable=True) 

I was wondering if someone could explain the difference in layman terms as I'm struggling to understand it. I would have assumed it would be better not to have to constantly write db. in front of each column but the official sqlalchemy documentation has it with the db. and that's how everyone is teaching it.
Example code from flask-security-too:
database.py

from sqlalchemy import create_engine from sqlalchemy.orm import scoped_session, sessionmaker from sqlalchemy.ext.declarative import declarative_base engine = create_engine('sqlite:////tmp/test.db') db_session = scoped_session(sessionmaker(autocommit=False, autoflush=False, bind=engine)) Base = declarative_base() Base.query = db_session.query_property() def init_db(): # import all modules here that might define models so that # they will be registered properly on the metadata. Otherwise # you will have to import them first before calling init_db() import models Base.metadata.create_all(bind=engine) 

models.py

from database import Base from flask_security import UserMixin, RoleMixin from sqlalchemy import create_engine from sqlalchemy.orm import relationship, backref from sqlalchemy import Boolean, DateTime, Column, Integer, \ String, ForeignKey class RolesUsers(Base): __tablename__ = 'roles_users' id = Column(Integer(), primary_key=True) user_id = Column('user_id', Integer(), ForeignKey('user.id')) role_id = Column('role_id', Integer(), ForeignKey('role.id')) class Role(Base, RoleMixin): __tablename__ = 'role' id = Column(Integer(), primary_key=True) name = Column(String(80), unique=True) description = Column(String(255)) class User(Base, UserMixin): __tablename__ = 'user' id = Column(Integer, primary_key=True) email = Column(String(255), unique=True) username = Column(String(255), unique=True, nullable=True) password = Column(String(255), nullable=False) last_login_at = Column(DateTime()) current_login_at = Column(DateTime()) last_login_ip = Column(String(100)) current_login_ip = Column(String(100)) login_count = Column(Integer) active = Column(Boolean()) fs_uniquifier = Column(String(255), unique=True, nullable=False) confirmed_at = Column(DateTime()) roles = relationship('Role', secondary='roles_users', backref=backref('users', lazy='dynamic')) 

Hi,
Hope someone can help with sqlalchemy.
I've a flask application where I used standard sqlite lib and now I would like to change to sqlalchemy for better code reading and future improvements. I can't change the schema as the app is already used by some people and I don't want that an update can cause issues.
I've some datetime column that are considered as integers by sqlalchemy and when I run a query I get the error below:
Couldn't parse datetime string '1564598187' - value is not a string.
I'm using declarative sqlalchemy with database module below and models.
database.py

 engine = create_engine('sqlite:///my_database.sqlite3', convert_unicode=True) db_session = scoped_session(sessionmaker(autocommit=False, autoflush=False, bind=engine)) Base = declarative_base() Base.query = db_session.query_property() def init_db(): from models import Shares Base.metadata.create_all(bind=engine) 

models.py

class Clients(Base): __tablename__ = 'clients' id = Column(Integer, primary_key=True) name = Column(Text, nullable=False) lastseen = Column(DateTime) joindate = Column(DateTime) @event.listens_for(Table, "column_reflect") def setup_epoch(inspector, table, column_info): if isinstance(column_info['type'], types.DateTime): column_info['type'] = MyEpochType() 

On models I've a few class with my database schema and then flask app where I import db_session, init_db and models.
As I said I can't change schema replacing datetime fields with TEXT. I tried to dig a bit about the problem and I found this can be fixed using decorators and event listener.
I tried to apply this gist adding class and listener but it's totally ignored https://gist.github.com/zzzeek/7470863
I'm new to sqlalchemy so I really can't understand what's wrong and how to use listener with declarative model.
Thanks

I've tried this in two different main ways...

1. By using pure pyodbc, and
2. by using sqlalchemy as recommend by warnings from my other libraries: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy

​

def insert_commissions_to_db(commissions_df, testing=False): # engine = sqlalchemy.create_engine(SQL_SERVER_ALCHEMY_CONNECT_STRING) # if testing: # commissions_df.to_sql( # name="[dbo].[CommissionsDev]", con=engine, index=False, if_exists="append" # ) # else: # commissions_df.to_sql("[dbo].[Commissions]", engine) with pyodbc.connect(SQL_SERVER_PYODBC_CONNECT_STRING) as conn: conn.autocommit = False try: if testing: data = commissions_df.to_sql("[dbo].[CommissionsDev]", con=conn, if_exists="append") else: data = commissions_df.to_sql("[dbo].[Commissions]", con=conn, if_exists="append") except pyodbc.DatabaseError as e: logger.error(f"Failed insert commission: {e}".replace("\n", " ")) conn.rollback() raise except Exception as e: logger.error(f"Failed insert commission: {e}".replace("\n", " ")) conn.rollback() raise logger.info("Inserted all commission rows") 

The first path, pyodbc, is the uncommented section. When I try it this way, I get this error:
pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master WHERE type='table' AND name=?;': ('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'sqlite_master'. (208) (SQLExecDirectW); [42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (8180)")
​
I think this may be because pandas isn't designed to work with pyodbc, and I need the second path, using sqlalchemy... but I get this nearly meaningless error using the commented code seen above:
sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: A non-recoverable error occurred during a database lookup.\r\n (11003) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (11003)')
(Background on this error at: https://sqlalche.me/e/14/e3q8)
​
My connection string looks like this:
​
mssql+pyodbc://userdba:HIDDENPASSWORD@our-data.database.windows.net:1433/DB?driver=ODBC+Driver+17+for+SQL+Server&Trusted_Connection=yes
​
I'm at a loss here, all help is appreciated!

I wrote the following code in test_db.py:

from fastapi.testclient import TestClient from main import app from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from app.server.database import get_db, Base SQLALCHEMY_DATABASE_URL = "sqlite:///./test.db" engine = create_engine( SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thred": False} ) TestingSessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) Base.metadata.create_all(bind=engine) def override_get_db(): try: db = TestingSessionLocal() yield db finally: db.close() app.dependecy_overrides[get_db] = override_get_db client = TestClient(app) 

following the official testing documentaion
​
And then went ahead and wrote tests.py:

from ...test_db import client #example test def test_create_faq(): response = client.post( "/api/faq/add", json={ "question": "This is a test", "answer": "This is an answer to a test" }, assert response.status_code == 200, response.text data = response.json() assert data["question"] == "This is a test" assert "id" in data faq_id = data["id"] response = client.get(f"/api/faq/detail/{faq_id}") assert response.status_code == 200, response.text data = response.json() assert data["answer"] == "This is an answer to a test" assert data["id"] == faq_id ) 

for each individual module.
​
Is this the correct way of doing this??
​
Also, while running pytest, I am getting the following traceback:

ERROR collecting test_db.py ____________________________________________
test_db.py:15: in
Base.metadata.create_all(bind=engine)
fastapi-env\lib\site-packages\sqlalchemy\sql\schema.py:4785: in create_all
bind._run_ddl_visitor(
fastapi-env\lib\site-packages\sqlalchemy\engine\base.py:3116: in _run_ddl_visitor
with self.begin() as conn:
fastapi-env\lib\site-packages\sqlalchemy\engine\base.py:3032: in begin
conn = self.connect(close_with_result=close_with_result)
fastapi-env\lib\site-packages\sqlalchemy\engine\base.py:3204: in connect
return self._connection_cls(self, close_with_result=close_with_result)
fastapi-env\lib\site-packages\sqlalchemy\engine\base.py:96: in __init__
else engine.raw_connection()
fastapi-env\lib\site-packages\sqlalchemy\engine\base.py:3283: in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
fastapi-env\lib\site-packages\sqlalchemy\engine\base.py:3250: in _wrap_pool_connect
return fn()
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:310: in connect
return _ConnectionFairy._checkout(self)
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:868: in _checkout
fairy = _ConnectionRecord.checkout(pool)
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:476: in checkout
rec = pool._do_get()
fastapi-env\lib\site-packages\sqlalchemy\pool\impl.py:256: in _do_get
return self._create_connection()
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:256: in _create_connection
return _ConnectionRecord(self)
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:371: in __init__
self.__connect()
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:666: in __connect
pool.logger.debug("Error on connect(): %s", e)
fastapi-env\lib\site-packages\sqlalchemy\util\langhelpers.py:70: in __exit__
compat.raise_(
fastapi-env\lib\site-packages\sqlalchemy\util\compat.py:207: in raise_
raise exception
fastapi-env\lib\site-packages\sqlalchemy\pool\base.py:661: in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
fastapi-env\lib\site-packages\sqlalchemy\engine\create.py:590: in connect
return dialect.connect(*cargs, **cparams)
fastapi-env\lib\site-packages\sqlalchemy\engine\default.py:597: in connect
return self.dbapi.connect(*cargs, **cparams)
E TypeError: 'check_same_thred' is an invalid keyword argument for this function
============================================= short test summary info ==============================================
ERROR test_db.py - TypeError: 'check_same_thred' is an invalid keyword argument for this function

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Interrupted: 1 error during collection !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

So, there is something wrong with Base.metadata.create_all(bind=engine).
Base is just declared using: Base = declarative_base() in the project's DB file.
​
Pardon me for the long post, but I need help with this! Can someone please point out what's happening here?
​
Thank You for your time...

TL;DR at the bottom. Also, this got way longer than I intended and I may be wrong in some way or another, but I'm happy to learn, so if you bring criticism, just make it constructive and I'll be happy to hear it.
​
After getting your feet wet developing discord bots you will surely come to a point where you want to store information that must be preserved between restarts.
Suppose you're working with reminders. And you need to store the last time a user was sent her notification. You can use a dictionary, like in this example:

reminders = {} # after a notification is sent reminders[user_id] = datetime.utcnow() 

This of course will work but the information will be lost if the bot restarts. You need a database.
Anything that can be used to store information is a database, a text file, JSON file, a notebook, hell even color-coded lego blocks. What you actually need is a database management system (DBMS). DBMS work in a way that minimizes the risk of data corruption. Examples of these systems are SQLite, MySQL, PostgreSQL, Mongo, Firebase, etc.
Whatever you choose you will need to know its query language, and this is precisely what's so imposing when trying to use a database. But don't despair. There are multiple friendly ways to build database-driven complex bots without having to be an expert in their specific query language.
One such tool is `sqlitedict`, a python package that lets you interact with an SQLite database using a simple dictionary interface. Start by installing the lib with `pip install sqlitedict`, import it, and instantiate your database.

from sqlitedict import SqliteDict as DB db = DB('db.sqlite', tablename='reminders', autocommit=True) 

SQL databases are constructed with different tables. Each table has a number of rows and columns, not too dissimilar to excel (tables would be each sheet and the database would be the whole file).
the `db` object will allow you to interact with the table `reminders`. `autocommit` tells the database that it should write changes to the database as soon as their made to the object.
Now let's see how to store information in the database

# after you send the reminder db[user_id] = datetime.utcnow() 

That's really it. Even if you restart your bot, you will have that information available.
Now, how do you extract information from the database?
Let's say you want to send the reminder every 5 minutes.

if (not db.get(user_id) # the user has never been notified before or db[user_id] + timedelta(minutes=5) <= datetime.utcnow() # enough time has passed ): # send reminder db[user_id] = datetime.utcnow() # update database entry. 

As you see it's very straight forward and you don't need to know any SQL at all.
The most important thing to consider using this library is that the database has no way of knowing what happens to the objects in RAM, so always remember to "redefine" values to the database after you change something. For example:

my_list = [] db['my_list'] = my_list my_list.append(1) print(my_list) # [1] print(db['my_list']) # [] 

To store the "final" form of the list, you need to redeclare it in the database.

db['my_list'] = my_list print(db['my_list']) # [1] 

The library uses cpickle, a pickle implementation written in c, that allows you to store objects in the database, so you don't have to deal with encoding and decoding things yourself.
With this, you can finally stop using that ugly json file you're so afraid to leave behind.
Is this the best way to have a database? *certainly not*, but it's a good start.
Next time we will look into ORMs/ODMs, the most pythonic way (IMHO) to interact with SQL and NoSQL DBMS.
TL;DR: `sqlitedict` is a python package that gives you a persistent dictionary using an sqlite database.

I'm hosting shiny apps on an ubuntu (20.04) server. But having issues with one in particular. The app uses an SQLite database file stored with the app itself. So the application sits in /srv/shiny-servemyApp and the database file (db_main.DB) is at /srv/shiny-servemyApp/Data.
When I try to run the app it errors;
Error : Could not connect to database: unable to open database file
I have tried referencing the path to the database file in a few ways;
"myApp/Data/db_main.DB"
"Data/db_main.DB"
"/Data/db_main.DB"
"~Data/db_main.DB"
Being relatively new to shiny server I thought perhaps the problem was with relative paths but this hasn't helped.
The connection uses RSQLite and is written as;
conn <- DBI::dbConnect(RSQLite::SQLite(), "myApp/Data/db_main.DB")
I checked the permissions on the database file from the terminal and its set to -rwxrwxrwx.
I might be missing something really obvious but due to the nature of the multitude of versions and issues I couldn't find anything to help me further at this point (not that I understood at least). Any pointers in the right direction or any obvious issues with the packages I'm using or SQLite alternatives (if that's the issue) would be greatly appreciated.
​
Thanks

import csv from cs50 import SQL open("shows3.db", "w").close() db = SQL("Sqlite:///shows3.db") genress = set() db.execute("CREATE TABLE shows (id INTEGER, title TEXT, PRIMARY KEY (id))") db.execute("CREATE TABLE genres (id INTEGER, genre TEXT, PRIMARY KEY (id))") db.execute("CREATE TABLE shows_genres (shows_id INTEGER, genre_id INTEGER, FOREIGN KEY(shows_id, genres_id) REFERENCES(shows(id), genres(id))") with open("Favorite TV Shows - Form Responses 1.csv", "r") as file: reader = csv.DictReader(file) for row in reader: titl = row["title"].strip().upper() for genr in row["genres"].split(", "): genress.add(genr) for genr in genress: db.execute("INSERT INTO genres (genre) VALUES(?)", genr) # db.execute("INSERT INTO shows_genres (show_id, genre_id) VALUES(?, ?),(SELECT id FROM shows where title = row["title"].strip().upper()),(SELECT id FROM genres where genre = genre)") with open("Favorite TV Shows - Form Responses 1.csv", "r") as file: reader = csv.DictReader(file) for row in reader: titl = row["title"].strip().upper() id = db.execute("SELECT id FROM shows where title = ?", titl) for genr in row["genres"].split(", "): c = db.execute("SELECT id FROM genres where genre = ?", genr) db.execute("INSERT INTO shows_genres (show_id, genre_id) VALUES(?, ?)",id,c) 

 $ python favorites2.py Traceback (most recent call last): File "/home/ubuntu/favorites2.py", line 5, in  db = SQL("Sqlite:///shows2.db") File "/uslocal/lib/python3.9/site-packages/cs50/sql.py", line 58, in __init__ self._engine = sqlalchemy.create_engine(url, **kwargs).execution_options(autocommit=False) File "", line 2, in create_engine File "/uslocal/lib/python3.9/site-packages/sqlalchemy/util/deprecations.py", line 298, in warned return fn(*args, **kwargs) File "/uslocal/lib/python3.9/site-packages/sqlalchemy/engine/create.py", line 522, in create_engine entrypoint = u._get_entrypoint() File "/uslocal/lib/python3.9/site-packages/sqlalchemy/engine/url.py", line 653, in _get_entrypoint cls = registry.load(name) File "/uslocal/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load raise exc.NoSuchModuleError( sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:Sqlite 

I am using VM Manager for work (and gaming) and I have several VMs installed for different development. Today I updated Manjaro with the latest updates and since then VM fails to start. Not the VMs, but the the Manager itself. When I try to start it, the icon appears in the application bar for few seconds, not password prompt, and then disappears.
I checked journal and what I am getting is this error:
Jun 08 21:08:06 amd-manjaro kwin_x11[2162]: qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 50247, resource id: 52429033, major code: 18 (ChangeProperty), minor code: 0
Jun 08 21:08:06 amd-manjaro systemd[2008]: Started Virtual Machine Manager.
Jun 08 21:08:06 amd-manjaro systemd[2008]: app-virt\x2dmanager-fb0d751b2d884ba19249277dbc9490d0.scope: Succeeded.
Jun 08 21:08:06 amd-manjaro kwin_x11[2162]: qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 50266, resource id: 52429034, major code: 18 (ChangeProperty), minor code: 0
​
inxi:

System: Kernel: 5.12.8-1-MANJARO x86_64 bits: 64 compiler: gcc v: 11.1.0 parameters: BOOT_IMAGE=/boot/vmlinuz-5.12-x86_64 root=UUID=23e0fe0b-c944-4865-9ab1-de7c75b3c57c ro quiet apparmor=1 security=apparmor udev.log_priority=3 amd_iommu=on iommu=pt hugepages=16384 vfio-pci.ids=1002:73bf,1002:ab28,1002:73a6,1002:73a4,8086:1539 video=efifb:off systemd.unified_cgroup_hierarchy=1 gfxpayload=console gfxpayload=auto Desktop: KDE Plasma 5.21.4 tk: Qt 5.15.2 info: latte-dock wm: kwin_x11 vt: 1 dm: SDDM Distro: Manjaro Linux base: Arch Linux Machine: Type: Desktop System: Gigabyte product: X570 AORUS MASTER v: -CF serial:  Mobo: Gigabyte model: X570 AORUS MASTER v: x.x serial:  UEFI: American Megatrends LLC. v: F33a date: 01/22/2021 Battery: Device-1: hidpp_battery_0 model: Logitech G305 Lightspeed Wireless Gaming Mouse serial:  charge: 100% (should be ignored) rechargeable: yes status: Discharging Memory: RAM: total: 62.75 GiB used: 39 GiB (62.2%) RAM Report: permissions: Unable to run dmidecode. Root privileges required. CPU: Info: 12-Core model: AMD Ryzen 9 5900X bits: 64 type: MT MCP arch: Zen 3 family: 19 (25) model-id: 21 (33) stepping: 0 microcode: A201009 cache: L2: 6 MiB bogomips: 177654 Speed: 3598 MHz min/max: 2200/3700 MHz boost: enabled Core speeds (MHz): 1: 3598 2: 2873 3: 2884 4: 2871 5: 3600 6: 2880 7: 2296 8: 2333 9: 2543 10: 2211 11: 2433 12: 2880 13: 2866 14: 2203 15: 2639 16: 2785 17: 2859 18: 2876 19: 2877 20: 2880 21: 2522 22: 2511 23: 2934 24: 2595 Flags: 3dnowprefetch abm adx aes aperfmperf apic arat avic avx avx2 bmi1 bmi2 bpext cat_l3 cdp_l3 clflush clflushopt clwb clzero cmov cmp_legacy constant_tsc cpb cpuid cqm cqm_llc cqm_mbm_local cqm_mbm_total cqm_occup_llc cr8_legacy cx16 cx8 de decodeassists erms extapic extd_apicid f16c flushbyasid fma fpu fsgsbase fsrm fxsr fxsr_opt ht hw_pstate ibpb ibrs ibs invpcid irperf lahf_lm lbrv lm mba mca mce misalignsse mmx mmxext monitor movbe msr mtrr mwaitx nonstop_tsc nopl npt nrip_save nx ospke osvw overflow_recov pae pat pausefilter pclmulqdq pdpe1gb perfctr_core perfctr_llc perfctr_nb pfthreshold pge pku pni popcnt pse pse36 rdpid rdpru rdrand rdseed rdt_a rdtscp rep_good sep sha_ni skinit smap smca smep ssbd sse sse2 sse4_1 sse4_2 sse4a ssse3 stibp succor svm svm_lock syscall tce topoext tsc tsc_scale umip v_vmsave_vmload vaes vgif vmcb_clean vme vmmcall vpclmulqdq wbnoinvd wdt xgetbv1 xsave xsavec xsaveerptr xsaveopt xsaves Vulnerabilities: Type: itlb_multihit status: Not affected Type: l1tf status: Not affected Type: mds status: Not affected Type: meltdown status: Not affected Type: spec_store_bypass mitigation: Speculative Store Bypass disabled via prctl and seccomp Type: spectre_v1 mitigation: usercopy/swapgs barriers and __user pointer sanitization Type: spectre_v2 mitigation: Full AMD retpoline, IBPB: conditional, IBRS_FW, STIBP: always-on, RSB filling Type: srbds status: Not affected Type: tsx_async_abort status: Not affected Graphics: Device-1: AMD Navi 21 [Radeon RX 6800/6800 XT / 6900 XT] driver: vfio-pci v: 0.2 alternate: amdgpu bus-ID: 0e:00.0 chip-ID: 1002:73bf class-ID: 0300 Device-2: AMD Navi 14 [Radeon RX 5500/5500M / Pro 5500M] vendor: Tul driver: amdgpu v: kernel bus-ID: 11:00.0 chip-ID: 1002:7340 class-ID: 0300 Device-3: Logitech HD Pro Webcam C920 type: USB driver: snd-usb-audio,uvcvideo bus-ID: 5-4.1:4 chip-ID: 046d:082d class-ID: 0102 serial:  Display: x11 server: X.Org 1.20.11 compositor: kwin_x11 driver: loaded: amdgpu,ati unloaded: modesetting,radeon alternate: fbdev,vesa display-ID: :0 screens: 1 Screen-1: 0 s-res: 3760x1920 s-dpi: 96 s-size: 994x508mm (39.1x20.0") s-diag: 1116mm (43.9") Monitor-1: HDMI-A-0 res: 2560x1440 hz: 60 dpi: 109 size: 597x336mm (23.5x13.2") diag: 685mm (27") Monitor-2: DVI-D-0 res: 1200x1920 hz: 60 OpenGL: renderer: Radeon RX 5500 XT (NAVI14 DRM 3.40.0 5.12.8-1-MANJARO LLVM 11.1.0) v: 4.6 Mesa 21.1.2 direct render: Yes Audio: Device-1: AMD driver: vfio-pci v: 0.2 alternate: snd_hda_intel bus-ID: 0e:00.1 chip-ID: 1002:ab28 class-ID: 0403 Device-2: AMD Navi 10 HDMI Audio vendor: Tul driver: snd_hda_intel v: kernel bus-ID: 11:00.1 chip-ID: 1002:ab38 class-ID: 0403 Device-3: AMD Starship/Matisse HD Audio vendor: Gigabyte driver: snd_hda_intel v: kernel bus-ID: 13:00.4 chip-ID: 1022:1487 class-ID: 0403 Device-4: Creative Sound BlasterX G6 type: USB driver: hid-generic,snd-usb-audio,usbhid bus-ID: 1-3:3 chip-ID: 041e:3256 class-ID: 0300 serial:  Device-5: Logitech HD Pro Webcam C920 type: USB driver: snd-usb-audio,uvcvideo bus-ID: 5-4.1:4 chip-ID: 046d:082d class-ID: 0102 serial:  Sound Server-1: ALSA v: k5.12.8-1-MANJARO running: yes Sound Server-2: JACK v: 0.125.0 running: no Sound Server-3: PulseAudio v: 14.2 running: yes Sound Server-4: PipeWire v: 0.3.28 running: yes Network: Device-1: Intel Wi-Fi 6 AX200 driver: iwlwifi v: kernel bus-ID: 06:00.0 chip-ID: 8086:2723 class-ID: 0280 IF: wlp6s0 state: down mac:  Device-2: Intel I211 Gigabit Network vendor: Gigabyte driver: vfio-pci v: 0.2 modules: igb port: d000 bus-ID: 07:00.0 chip-ID: 8086:1539 class-ID: 0200 Device-3: Realtek RTL8125 2.5GbE vendor: Gigabyte driver: r8169 v: kernel port: c000 bus-ID: 08:00.0 chip-ID: 10ec:8125 class-ID: 0200 IF: enp8s0 state: up speed: 1000 Mbps duplex: full mac:  IP v4:  type: dynamic noprefixroute scope: global broadcast:  IP v6:  type: noprefixroute scope: link IF-ID-1: virbr0 state: down mac:  IP v4:  scope: global broadcast:  WAN IP:  Bluetooth: Device-1: Intel AX200 Bluetooth type: USB driver: btusb v: 0.8 bus-ID: 3-5:6 chip-ID: 8087:0029 class-ID: e001 Report: rfkill ID: hci0 rfk-id: 1 state: up address: see --recommends Logical: Message: No logical block device data found. RAID: Supported mdraid levels: raid1 Device-1: md127 maj-min: 9:127 type: mdraid level: mirror status: active size: 3.64 TiB Info: report: 2/2 UU blocks: 3906884608 chunk-size: N/A super-blocks: 1.2 Components: Online: 0: sda1 maj-min: 8:1 size: 3.64 TiB 1: sdb1 maj-min: 8:17 size: 3.64 TiB Drives: Local Storage: total: raw: 9.57 TiB usable: 5.93 TiB used: 1.38 TiB (23.3%) SMART Message: Unable to run smartctl. Root privileges required. ID-1: /dev/nvme0n1 maj-min: 259:0 vendor: Samsung model: SSD 970 EVO 500GB size: 465.76 GiB block-size: physical: 512 B logical: 512 B speed: 31.6 Gb/s lanes: 4 rotation: SSD serial:  rev: 2B2QEXE7 scheme: GPT ID-2: /dev/nvme1n1 maj-min: 259:6 vendor: Seagate model: XPG GAMMIX S50 Lite size: 953.87 GiB block-size: physical: 512 B logical: 512 B speed: 63.2 Gb/s lanes: 4 rotation: SSD serial:  rev: 82A7T9PA scheme: GPT ID-3: /dev/nvme2n1 maj-min: 259:1 vendor: Samsung model: SSD 970 EVO 250GB size: 232.89 GiB block-size: physical: 512 B logical: 512 B speed: 31.6 Gb/s lanes: 4 rotation: SSD serial:  rev: 2B2QEXE7 scheme: GPT ID-4: /dev/sda maj-min: 8:0 vendor: Toshiba model: HDWE140 size: 3.64 TiB block-size: physical: 4096 B logical: 512 B speed: 6.0 Gb/s rotation: 7200 rpm serial:  rev: FP1R scheme: GPT ID-5: /dev/sdb maj-min: 8:16 vendor: Toshiba model: HDWE140 size: 3.64 TiB block-size: physical: 4096 B logical: 512 B speed: 6.0 Gb/s rotation: 7200 rpm serial:  rev: FP1R scheme: GPT ID-6: /dev/sdc maj-min: 8:32 vendor: Samsung model: SSD 840 EVO 250GB size: 232.89 GiB block-size: physical: 512 B logical: 512 B speed: 6.0 Gb/s rotation: SSD serial:  rev: DB6Q scheme: GPT ID-7: /dev/sdd maj-min: 8:48 vendor: Samsung model: SSD 850 EVO 500GB size: 465.76 GiB block-size: physical: 512 B logical: 512 B speed: 6.0 Gb/s rotation: SSD serial:  rev: 2B6Q scheme: GPT Message: No optical or floppy data found. Partition: ID-1: / raw-size: 432.76 GiB size: 424.96 GiB (98.20%) used: 56.64 GiB (13.3%) fs: ext4 dev: /dev/nvme0n1p2 maj-min: 259:3 label: N/A uuid: 23e0fe0b-c944-4865-9ab1-de7c75b3c57c ID-2: /boot/efi raw-size: 1024 MiB size: 1022 MiB (99.80%) used: 312 KiB (0.0%) fs: vfat dev: /dev/nvme0n1p3 maj-min: 259:4 label: N/A uuid: 93E7-B14B ID-3: /home//Data raw-size: 3.64 TiB size: 3.58 TiB (98.40%) used: 1.11 TiB (31.0%) fs: ext4 dev: /dev/md127p1 maj-min: 259:9 label: Mirror-Data uuid: 6d1d9f0e-297a-4e04-9f0c-5b112e55cc52 ID-4: /home//Desktop raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Desktop label: N/A uuid: N/A ID-5: /home//Documents raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Documents label: N/A uuid: N/A ID-6: /home//Downloads raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Downloads label: N/A uuid: N/A ID-7: /home//Family raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Family label: N/A uuid: N/A ID-8: /home//Games raw-size: 232.88 GiB size: 228.17 GiB (97.98%) used: 6.3 GiB (2.8%) fs: ext4 dev: /dev/nvme2n1p2 maj-min: 259:5 label: Games uuid: 4f0d4fe8-1ac7-464d-8fc3-184c5a85b320 ID-9: /home//Multimedia raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Multimedia label: N/A uuid: N/A ID-10: /home//Pictures raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Pics label: N/A uuid: N/A ID-11: /home//Public raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Public label: N/A uuid: N/A ID-12: /home//Torrents raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Download label: N/A uuid: N/A ID-13: /home//Videos raw-size: N/A size: 4.96 TiB used: 2.63 TiB (53.0%) fs: cifs dev: /dev/Video label: N/A uuid: N/A ID-14: /home//VirtualMachines raw-size: 365.76 GiB size: 358.95 GiB (98.14%) used: 160.02 GiB (44.6%) fs: ext4 dev: /dev/sdd2 maj-min: 8:50 label: VirtualMachines uuid: 5137490c-6ebe-46b0-9801-91a949fdb7c1 ID-15: /run/timeshift/backup raw-size: 100 GiB size: 100 GiB (100.00%) used: 59.5 GiB (59.5%) fs: btrfs dev: /dev/sdd1 maj-min: 8:49 label: Timeshift uuid: 54577f50-a5fe-4f0d-bf5b-81c530421b73 Swap: Kernel: swappiness: 60 (default) cache-pressure: 100 (default) ID-1: swap-1 type: partition size: 32 GiB used: 1024 KiB (0.0%) priority: -2 dev: /dev/nvme0n1p1 maj-min: 259:2 label: N/A uuid: d69b52fd-11a0-4280-a101-c1617f865ac7 Unmounted: ID-1: /dev/nvme1n1p1 maj-min: 259:7 size: 16 MiB fs:  label: N/A uuid: N/A ID-2: /dev/nvme1n1p2 maj-min: 259:8 size: 953.85 GiB fs: ntfs label: Games uuid: BE28BF4928BEFF87 ID-3: /dev/sdc1 maj-min: 8:33 size: 499 MiB fs: ntfs label: Recovery uuid: 6CAA2DB1AA2D78AA ID-4: /dev/sdc2 maj-min: 8:34 size: 100 MiB fs: vfat label: N/A uuid: AE2E-0C80 ID-5: /dev/sdc3 maj-min: 8:35 size: 16 MiB fs:  label: N/A uuid: N/A ID-6: /dev/sdc4 maj-min: 8:36 size: 232.28 GiB fs: ntfs label: Win10x64 uuid: C4F42EDBF42ED00A USB: Hub-1: 1-0:1 info: Full speed (or root) Hub ports: 6 rev: 2.0 speed: 480 Mb/s chip-ID: 1d6b:0002 class-ID: 0900 Device-1: 1-1:2 info: Integrated Express IT8297 RGB LED Controller type: Keyboard driver: hid-generic,usbhid interfaces: 1 rev: 2.0 speed: 12 Mb/s power: 100mA chip-ID: 048d:8297 class-ID: 0301 Device-2: 1-3:3 info: Creative Sound BlasterX G6 type: Audio,HID driver: hid-generic,snd-usb-audio,usbhid interfaces: 5 rev: 2.0 speed: 480 Mb/s power: 500mA chip-ID: 041e:3256 class-ID: 0300 serial:  Hub-2: 1-6:4 info: Genesys Logic Hub ports: 4 rev: 2.0 speed: 480 Mb/s power: 100mA chip-ID: 05e3:0608 class-ID: 0900 Hub-3: 2-0:1 info: Full speed (or root) Hub ports: 4 rev: 3.1 speed: 10 Gb/s chip-ID: 1d6b:0003 class-ID: 0900 Hub-4: 3-0:1 info: Full speed (or root) Hub ports: 6 rev: 2.0 speed: 480 Mb/s chip-ID: 1d6b:0002 class-ID: 0900 Device-1: 3-1:2 info: ASUSTek ROG CHAKRAM type: HID,Mouse driver: hid-generic,usbhid interfaces: 4 rev: 2.0 speed: 12 Mb/s power: 500mA chip-ID: 0b05:18e3 class-ID: 0300 Device-2: 3-2:3 info: ASUSTek ROG CHAKRAM type: HID,Mouse,Keyboard driver: hid-generic,usbhid interfaces: 4 rev: 2.0 speed: 12 Mb/s power: 100mA chip-ID: 0b05:18e5 class-ID: 0300 Device-3: 3-3:4 info: Saitek PLC PS2700 Rumble Pad type: HID driver: hid-generic,usbhid interfaces: 1 rev: 2.0 speed: 12 Mb/s power: 200mA chip-ID: 06a3:f620 class-ID: 0300 Device-4: 3-4:5 info: ThrustMaster T.Flight Stick X type: HID driver: hid-generic,usbhid interfaces: 1 rev: 1.1 speed: 12 Mb/s power: 80mA chip-ID: 044f:b106 class-ID: 0300 Device-5: 3-5:6 info: Intel AX200 Bluetooth type: Bluetooth driver: btusb interfaces: 2 rev: 2.0 speed: 12 Mb/s power: 100mA chip-ID: 8087:0029 class-ID: e001 Hub-5: 3-6:7 info: Genesys Logic Hub ports: 4 rev: 2.0 speed: 480 Mb/s power: 100mA chip-ID: 05e3:0608 class-ID: 0900 Device-1: 3-6.1:8 info: Logitech USB Receiver type: Keyboard,Mouse,HID driver: logitech-djreceiver,usbhid interfaces: 3 rev: 2.0 speed: 12 Mb/s power: 98mA chip-ID: 046d:c53f class-ID: 0300 Device-2: 3-6.4:9 info: SHARKOON Keyboard type: Keyboard,HID driver: hid-generic,usbhid interfaces: 3 rev: 1.1 speed: 12 Mb/s power: 100mA chip-ID: 1ea7:0907 class-ID: 0300 serial:  Hub-6: 4-0:1 info: Full speed (or root) Hub ports: 4 rev: 3.1 speed: 10 Gb/s chip-ID: 1d6b:0003 class-ID: 0900 Hub-7: 5-0:1 info: Full speed (or root) Hub ports: 4 rev: 2.0 speed: 480 Mb/s chip-ID: 1d6b:0002 class-ID: 0900 Hub-8: 5-3:2 info: VIA Labs USB2.0 Hub ports: 4 rev: 2.1 speed: 480 Mb/s chip-ID: 2109:2815 class-ID: 0900 Hub-9: 5-4:3 info: Hitachi ports: 3 rev: 2.1 speed: 480 Mb/s chip-ID: 045b:0209 class-ID: 0900 Device-1: 5-4.1:4 info: Logitech HD Pro Webcam C920 type: Video,Audio driver: snd-usb-audio,uvcvideo interfaces: 4 rev: 2.0 speed: 480 Mb/s power: 500mA chip-ID: 046d:082d class-ID: 0102 serial:  Device-2: 5-4.3:5 info: EIZO EIZO USB HID Monitor type: HID driver: hid-generic,usbhid interfaces: 1 rev: 1.1 speed: 12 Mb/s chip-ID: 056d:4008 class-ID: 0300 Hub-10: 6-0:1 info: Full speed (or root) Hub ports: 4 rev: 3.1 speed: 10 Gb/s chip-ID: 1d6b:0003 class-ID: 0900 Hub-11: 6-3:2 info: VIA Labs USB3.0 Hub ports: 4 rev: 3.2 speed: 5 Gb/s chip-ID: 2109:0815 class-ID: 0900 Hub-12: 6-4:3 info: Hitachi ports: 3 rev: 3.0 speed: 5 Gb/s chip-ID: 045b:0210 class-ID: 0900 Sensors: System Temperatures: cpu: 46.8 C mobo: 16.8 C gpu: amdgpu temp: 57.0 C mem: 0.0 C Fan Speeds (RPM): N/A gpu: amdgpu fan: 0 Info: Processes: 513 Uptime: 4h 17m wakeups: 7 Init: systemd v: 247 tool: systemctl Compilers: gcc: 11.1.0 Packages: 1443 pacman: 1436 lib: 412 flatpak: 7 Shell: Bash v: 5.1.8 running-in: konsole inxi: 3.3.04 

update log:

[2021-06-08T08:59:24+0100] [ALPM] upgraded yakuake (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded wpebackend-fdo (1.9.91-1 -> 1.9.92-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded vulkan-radeon (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:24+0100] [ALPM] upgraded vulkan-intel (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:24+0100] [ALPM] upgraded vlc (3.0.13-2 -> 3.0.14-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded tpm2-tss (3.0.3-1 -> 3.1.0-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded sudo (1.9.6.p1-1 -> 1.9.7-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded spectacle (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded snapd (2.50-1 -> 2.51-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded sddm-breath2-theme (1.0.11-1 -> 1.0.13-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded sddm (0.19.0-5.0 -> 0.19.0-6) [2021-06-08T08:59:24+0100] [ALPM] upgraded qemu (6.0.0-2 -> 6.0.0-3) [2021-06-08T08:59:24+0100] [ALPM] upgraded virglrenderer (0.8.2-1 -> 0.9.1-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded python-pyqt5-sip (12.8.1-3 -> 12.9.0-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded python-numpy (1.20.2-1 -> 1.20.3-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded print-manager (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded powertop (2.13-1 -> 2.14-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded plasma5-themes-breath2 (1.0.11-1 -> 1.0.13-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-parse-yapp (1.21-3 -> 1.21-4) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-mailtools (2.21-4 -> 2.21-5) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-image-exiftool (12.25-1 -> 12.26-2) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-file-mimeinfo (0.30-1 -> 0.30-2) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-file-desktopentry (0.22-7 -> 0.22-8) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-file-basedir (0.08-5 -> 0.08-6) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-ipc-system-simple (1.30-2 -> 1.30-3) [2021-06-08T08:59:24+0100] [ALPM] upgraded perl-error (0.17029-2 -> 0.17029-3) [2021-06-08T08:59:24+0100] [ALPM] upgraded partitionmanager (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded okular (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:24+0100] [ALPM] upgraded mpd (0.22.6-4 -> 0.22.8-1) [2021-06-08T08:59:23+0100] [ALPM] upgraded mhwd-nvidia (460.80-1 -> 465.31-1) [2021-06-08T08:59:23+0100] [ALPM] upgraded mesa-vdpau (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:23+0100] [ALPM] upgraded manjaro-settings-manager-knotifier (0.5.6-13 -> 0.5.6-14) [2021-06-08T08:59:23+0100] [ALPM] upgraded manjaro-settings-manager-kcm (0.5.6-13 -> 0.5.6-14) [2021-06-08T08:59:23+0100] [ALPM] upgraded manjaro-settings-manager (0.5.6-13 -> 0.5.6-14) [2021-06-08T08:59:23+0100] [ALPM] upgraded manjaro-release (21.0.5-1 -> 21.0.6-1) [2021-06-08T08:59:23+0100] [ALPM] upgraded linux512 (5.12.2-1 -> 5.12.8-1) [2021-06-08T08:59:23+0100] [ALPM] upgraded linux511 (5.11.19-1 -> 5.11.22-2) [2021-06-08T08:59:22+0100] [ALPM] upgraded linux-firmware (20210511.r1922.7685cf4-1 -> 20210518.r1928.f846292-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libvirt-python (1:7.1.0-1 -> 1:7.3.0-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libva-mesa-driver (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:22+0100] [ALPM] upgraded libslirp (4.4.0-1 -> 4.5.0-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libqmi (1.28.2-1 -> 1.28.4-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libndp (1.7-2 -> 1.8-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libktorrent (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libksane (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libimagequant (2.15.0-1 -> 2.15.1-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded libcpuid (0.5.1.r1.gccd0ec8-1 -> 0.5.1.r2.g0f1ad69-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-vulkan-radeon (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-vulkan-intel (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-nss (3.64-1 -> 3.66-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-sqlite (3.35.4-1 -> 3.35.5-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-nspr (4.30-1 -> 4.31-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-mesa-vdpau (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-mesa (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libva-mesa-driver (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-librsvg (2.50.5-1 -> 2:2.50.6-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libtiff (4.2.0-1 -> 4.3.0-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-pango (1:1.48.4-1 -> 1:1.48.5-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libx11 (1.7.0-1 -> 1.7.1-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libepoxy (1.5.7-1 -> 1.5.8-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libelf (0.183-3 -> 0.184-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libdrm (2.4.105-1 -> 2.4.106-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-libcap (2.49-1 -> 2.50-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-glib2 (2.68.1-1 -> 2.68.2-1) [2021-06-08T08:59:22+0100] [ALPM] upgraded lib32-gcc-libs (10.2.0-6 -> 11.1.0-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded lib32-expat (2.3.0-2 -> 2.4.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded lib32-curl (7.76.1-1 -> 7.77.0-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded lib32-libidn2 (2.3.0-1 -> 2.3.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded lib32-glibc (2.33-4 -> 2.33-5) [2021-06-08T08:59:21+0100] [ALPM] upgraded latte-dock (0.9.11-1 -> 0.9.12-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kwalletmanager (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded ksystemlog (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kpmcore (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded konversation (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded konsole (21.04.0-2 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kimageformats (5.82.0-1 -> 5.82.0-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded kimageannotator (0.4.2-1 -> 0.5.0-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded khelpcenter (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kget (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded libqalculate (3.18.0-2 -> 3.19.0-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kfind (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded keditbookmarks (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kdenetwork-filesharing (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kdegraphics-thumbnailers (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded libkexiv2 (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kdeconnect (21.04.0-1 -> 21.04.1-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded pulseaudio-qt (1.2-2 -> 1.3-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kcolorpicker (0.1.5-1 -> 0.1.6-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kcalc (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kate (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded ktexteditor (5.82.0-1 -> 5.82.0-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded kamera (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kaccounts-providers (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded k3b (1:21.04.0-1 -> 1:21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded libkcddb (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded hwinfo (21.73-1 -> 21.74-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-xml-writer (0.625-6 -> 0.625-7) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-xml-parser (2.46-2 -> 2.46-3) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-libwww (6.54-1 -> 6.54-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-www-robotrules (6.02-8 -> 6.02-9) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-try-tiny (0.30-5 -> 0.30-6) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-net-http (6.21-1 -> 6.21-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-http-negotiate (6.01-8 -> 6.01-9) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-http-daemon (6.06-2 -> 6.06-3) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-http-cookies (6.10-1 -> 6.10-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-html-parser (3.76-1 -> 3.76-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-http-message (6.29-1 -> 6.32-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-uri (5.09-1 -> 5.09-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-lwp-mediatypes (6.02-8 -> 6.02-9) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-io-html (1.004-1 -> 1.004-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-html-tagset (3.20-10 -> 3.20-11) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-file-listing (6.14-1 -> 6.14-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-http-date (6.05-3 -> 6.05-4) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-timedate (2.33-2 -> 2.33-3) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-encode-locale (1.05-7 -> 1.05-8) [2021-06-08T08:59:21+0100] [ALPM] upgraded hplip (1:3.21.2-1 -> 1:3.21.4-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded python-setuptools (1:56.1.0-1 -> 1:56.2.0-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-xml-libxml (2.0207-1 -> 2.0207-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-alien-libxml2 (0.17-1 -> 0.17-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-alien-build (2.38-1 -> 2.40-3) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-path-tiny (0.118-1 -> 0.118-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-file-which (1.24-1 -> 1.24-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-ffi-checklib (0.27-2 -> 0.28-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-capture-tiny (0.48-4 -> 0.48-5) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-dbi (1.643-2 -> 1.643-3) [2021-06-08T08:59:21+0100] [ALPM] upgraded perl-clone (0.45-2 -> 0.45-3) [2021-06-08T08:59:21+0100] [ALPM] upgraded net-snmp (5.9-3 -> 5.9.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded gwenview (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded kaccounts-integration (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded signon-kwallet-extension (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded libkdcraw (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded libkipi (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:21+0100] [ALPM] upgraded gtkmm3 (3.24.4-1 -> 3.24.5-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded pangomm (2.46.0-1 -> 2.46.1-2) [2021-06-08T08:59:21+0100] [ALPM] upgraded gst-plugins-bad (1.18.4-6 -> 1.18.4-7) [2021-06-08T08:59:21+0100] [ALPM] upgraded imagemagick (7.0.11.12-1 -> 7.0.11.13-3) [2021-06-08T08:59:20+0100] [ALPM] upgraded gupnp (1.2.4-1 -> 1.2.6-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded libcaca (0.99.beta19-4 -> 0.99.beta19-5) [2021-06-08T08:59:20+0100] [ALPM] upgraded zxing-cpp (1.1.1-1 -> 1.2.0-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded svt-hevc (1.5.0-1 -> 1.5.1-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded gst-plugins-bad-libs (1.18.4-6 -> 1.18.4-7) [2021-06-08T08:59:20+0100] [ALPM] upgraded gimp (2.10.24-3 -> 2.10.24-4) [2021-06-08T08:59:20+0100] [ALPM] upgraded graphviz (2.47.1-1 -> 2.47.2-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded libidn (1.36-1 -> 1.37-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded gegl (0.4.30-2 -> 0.4.30-3) [2021-06-08T08:59:20+0100] [ALPM] upgraded suitesparse (5.9.0-1 -> 5.10.1-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded gcc (10.2.0-6 -> 11.1.0-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded freeimage (3.18.0-8 -> 3.18.0-9) [2021-06-08T08:59:20+0100] [ALPM] upgraded foomatic-db (3:20210222-1 -> 3:20210528-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded flatpak (1.10.2-1 -> 1.11.1-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded pipewire (1:0.3.28-0 -> 1:0.3.28-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded pacman (5.2.2-5 -> 5.2.2-6) [2021-06-08T08:59:20+0100] [ALPM] upgraded python-urllib3 (1.26.4-1 -> 1.26.5-1) [2021-06-08T08:59:20+0100] [ALPM] upgraded xdg-dbus-proxy (0.1.2-2 -> 0.1.2-3) [2021-06-08T08:59:20+0100] [ALPM] upgraded firefox (89.0-0.1 -> 89.0-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded filelight (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded ffmpegthumbs (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded electron11 (11.4.6-1 -> 11.4.7-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded downgrade (9.0.0-2 -> 10.0.0-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded dotnet-sdk (5.0.5.sdk202-1 -> 5.0.6.sdk203-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded dotnet-runtime (5.0.5.sdk202-1 -> 5.0.6.sdk203-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded dotnet-host (5.0.5.sdk202-1 -> 5.0.6.sdk203-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded dolphin-plugins (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:19+0100] [ALPM] upgraded dolphin (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded kio-extras (21.04.0-2 -> 21.04.1-2) [2021-06-08T08:59:18+0100] [ALPM] upgraded djvulibre (3.5.28-2 -> 3.5.28-3) [2021-06-08T08:59:18+0100] [ALPM] upgraded dhclient (4.4.2-2 -> 4.4.2.P1-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded darktable (2:3.4.1-3 -> 2:3.4.1-4) [2021-06-08T08:59:18+0100] [ALPM] upgraded gmic (2.9.7-3 -> 2.9.7-4) [2021-06-08T08:59:18+0100] [ALPM] upgraded perl (5.32.1-1 -> 5.34.0-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded opencv (4.5.2-3 -> 4.5.2-4) [2021-06-08T08:59:18+0100] [ALPM] upgraded graphicsmagick (1.3.36-2 -> 1.3.36-3) [2021-06-08T08:59:18+0100] [ALPM] upgraded openexr (3.0.1-2 -> 3.0.3-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded imath (3.0.1-1 -> 3.0.3-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded code (1.55.2-1 -> 1.56.2-2) [2021-06-08T08:59:18+0100] [ALPM] upgraded electron (12.0.7-1 -> 12.0.9-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded gsettings-desktop-schemas (40.0-2 -> 40.0-3) [2021-06-08T08:59:18+0100] [ALPM] upgraded libepoxy (1.5.7-1 -> 1.5.8-1) [2021-06-08T08:59:18+0100] [ALPM] upgraded ceph-libs (15.2.10-1 -> 15.2.12-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded cairomm (1.12.2-4 -> 1.14.3-2) [2021-06-08T08:59:17+0100] [ALPM] upgraded breath2-wallpaper (1.0.11-1 -> 1.0.13-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded breath2-icon-themes (1.0.11-1 -> 1.0.13-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded binutils (2.36.1-2 -> 2.36.1-3) [2021-06-08T08:59:17+0100] [ALPM] upgraded elfutils (0.183-3 -> 0.184-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded baloo-widgets (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded svt-av1 (0.8.6-3 -> 0.8.7-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded libmfx (20.5.1-1 -> 21.1.3-2) [2021-06-08T08:59:17+0100] [ALPM] upgraded librsvg (2:2.50.5-1 -> 2:2.50.6-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded dav1d (0.8.2-1 -> 0.9.0-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded atkmm (2.28.1-1 -> 2.28.2-2) [2021-06-08T08:59:17+0100] [ALPM] upgraded glibmm (2.66.0-1 -> 2.66.1-2) [2021-06-08T08:59:17+0100] [ALPM] upgraded libsigc++ (2.10.6-1 -> 2.10.7-2) [2021-06-08T08:59:17+0100] [ALPM] upgraded aspnet-targeting-pack (5.0.5.sdk202-1 -> 5.0.6.sdk203-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded dotnet-targeting-pack (5.0.5.sdk202-1 -> 5.0.6.sdk203-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded netstandard-targeting-pack (5.0.5.sdk202-1 -> 5.0.6.sdk203-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded ark (21.04.0-1 -> 21.04.1-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded nss (3.64-1 -> 3.66-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded nspr (4.30-1 -> 4.31-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded btrfs-progs (5.12-2 -> 5.12.1-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded qt5-wayland (5.15.2+kde+r19-1 -> 5.15.2+kde+r23-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded pango (1:1.48.4-1 -> 1:1.48.5-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded libtool (2.4.6+42+gb88cebd5-15 -> 2.4.6+42+gb88cebd5-16) [2021-06-08T08:59:17+0100] [ALPM] upgraded qt5-declarative (5.15.2+kde+r24-1 -> 5.15.2+kde+r26-1) [2021-06-08T08:59:17+0100] [ALPM] upgraded qt5-base (5.15.2+kde+r192-1 -> 5.15.2+kde+r196-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libproxy (0.4.17-1 -> 0.4.17-2) [2021-06-08T08:59:16+0100] [ALPM] upgraded libinput (1.17.2-2 -> 1.17.3-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libnl (3.5.0-2 -> 3.5.0-3) [2021-06-08T08:59:16+0100] [ALPM] upgraded file (5.40-3 -> 5.40-5) [2021-06-08T08:59:16+0100] [ALPM] upgraded pcre2 (10.36-1 -> 10.37-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded kmod (28-1 -> 29-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded cryptsetup (2.3.5-4 -> 2.3.6-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded glib2 (2.68.1-1 -> 2.68.2-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded mesa (21.0.3-3 -> 21.1.2-0) [2021-06-08T08:59:16+0100] [ALPM] upgraded libxfixes (5.0.3-4 -> 6.0.0-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libx11 (1.7.0-4 -> 1.7.1-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libdrm (2.4.105-1 -> 2.4.106-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libelf (0.183-3 -> 0.184-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded curl (7.76.1-1 -> 7.77.0-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded ca-certificates-mozilla (3.64-1 -> 3.66-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libtasn1 (4.16.0-1 -> 4.17.0-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libcap (2.49-1 -> 2.50-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded zstd (1.4.9-1 -> 1.5.0-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded lz4 (1:1.9.3-1 -> 1:1.9.3-2) [2021-06-08T08:59:16+0100] [ALPM] upgraded libidn2 (2.3.0-1 -> 2.3.1-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded apparmor (3.0.1-1 -> 3.0.1-3) [2021-06-08T08:59:16+0100] [ALPM] upgraded python (3.9.5-1 -> 3.9.5-3) [2021-06-08T08:59:16+0100] [ALPM] upgraded libtirpc (1.3.1-1 -> 1.3.2-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded libldap (2.4.58-2 -> 2.4.58-3) [2021-06-08T08:59:16+0100] [ALPM] upgraded bash (5.1.008-1 -> 5.1.008-3) [2021-06-08T08:59:16+0100] [ALPM] upgraded gcc-libs (10.2.0-6 -> 11.1.0-1) [2021-06-08T08:59:16+0100] [ALPM] upgraded bashrc-manjaro (5.1.008-1 -> 5.1.008-3) [2021-06-08T08:59:16+0100] [ALPM] upgraded expat (2.3.0-1 -> 2.4.1-1) [2021-06-08T08:59:14+0100] [ALPM] upgraded glibc (2.33-4 -> 2.33-5) [2021-06-08T08:59:14+0100] [ALPM] upgraded linux-api-headers (5.10.13-1 -> 5.12.3-1) [2021-06-08T08:59:14+0100] [ALPM] upgraded amd-ucode (20210511.r1922.7685cf4-1 -> 20210518.r1928.f846292-1) [2021-06-08T08:59:14+0100] [ALPM] upgraded alsa-card-profiles (1:0.3.28-0 -> 1:0.3.28-1) [2021-06-08T08:57:12+0100] [ALPM] upgraded manjaro-system (20210412-1 -> 20210523-1) 

Anyway to make it work, preferably without initiating Timeshift…?