LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 09-11-2022, 04:05 PM   #1
allennet
Member
 
Registered: Feb 2022
Posts: 41

Rep: Reputation: 2
slpkg fail, sqlalchemy.exc.OperationalError


slpkg

Traceback (most recent call last):
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
return fn()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 320, in connect
return _ConnectionFairy._checkout(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 884, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 486, in checkout
rec = pool._do_get()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get
return self._create_connection()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 266, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 381, in __init__
self.__connect()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 678, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 673, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/usr/sbin/slpkg", line 5, in <module>
from slpkg.main import main
File "/usr/lib64/python3.9/site-packages/slpkg/main.py", line 8, in <module>
from slpkg.checks import Check
File "/usr/lib64/python3.9/site-packages/slpkg/checks.py", line 8, in <module>
from slpkg.queries import SBoQueries
File "/usr/lib64/python3.9/site-packages/slpkg/queries.py", line 9, in <module>
from slpkg.models.models import SBoTable
File "/usr/lib64/python3.9/site-packages/slpkg/models/models.py", line 53, in <module>
Base.metadata.create_all(engine)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/schema.py", line 4917, in create_all
bind._run_ddl_visitor(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3227, in _run_ddl_visitor
with self.begin() as conn:
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3143, in begin
conn = self.connect(close_with_result=close_with_result)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3315, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3394, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3364, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2198, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 3361, in _wrap_pool_connect
return fn()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 320, in connect
return _ConnectionFairy._checkout(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 884, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 486, in checkout
rec = pool._do_get()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get
return self._create_connection()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 266, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 381, in __init__
self.__connect()
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 678, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/usr/lib64/python3.9/site-packages/sqlalchemy/pool/base.py", line 673, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
(Background on this error at: https://sqlalche.me/e/14/e3q8)

any idea?

also i want to remove this program and:

-slackpkg remove slpkg-

Looking for slpkg in package list. Please wait... DONE

The file(s) slpkg can't be removed - package not installed

Last edited by allennet; 09-11-2022 at 04:12 PM.
 
Old 09-11-2022, 04:20 PM   #2
Tonus
Senior Member
 
Registered: Jan 2007
Location: Paris, France
Distribution: Slackware-15.0
Posts: 1,407
Blog Entries: 3

Rep: Reputation: 514Reputation: 514Reputation: 514Reputation: 514Reputation: 514Reputation: 514
How did you install it ?

If it is present in /var/lib/pkgtool/packages just use
Code:
removepkg /var/lib/pkgtool/packages/slpkg*.t?z
 
Old 09-11-2022, 04:22 PM   #3
allennet
Member
 
Registered: Feb 2022
Posts: 41

Original Poster
Rep: Reputation: 2
sbopkg -i slpkg

Quote:
Originally Posted by Tonus View Post
How did you install it ?

If it is present in /var/lib/pkgtool/packages just use
Code:
removepkg /var/lib/pkgtool/packages/slpkg*.t?z
by sbopkg -i slpkg


-removepkg /var/lib/pkgtool/packages/slpkg*.t?z-

-No such package: slpkg*.t?z. Can't remove-
 
Old 09-11-2022, 04:25 PM   #4
allennet
Member
 
Registered: Feb 2022
Posts: 41

Original Poster
Rep: Reputation: 2
Quote:
Originally Posted by Tonus View Post
How did you install it ?

If it is present in /var/lib/pkgtool/packages just use
Code:
removepkg /var/lib/pkgtool/packages/slpkg*.t?z



ok i did with:

removepkg slpkg

deleting... (...)

-WARNING: Unique directory /etc/slpkg/ contains new files-

My need is to install packages in slackware. To solve dependencies, slpkg does it?.
 
Old 09-11-2022, 04:45 PM   #5
Tonus
Senior Member
 
Registered: Jan 2007
Location: Paris, France
Distribution: Slackware-15.0
Posts: 1,407
Blog Entries: 3

Rep: Reputation: 514Reputation: 514Reputation: 514Reputation: 514Reputation: 514Reputation: 514
Did you build the queue first ?
Code:
sqg -p slpkg
Then sbopkg will ask if you want to build the package or the queue.
Several packages in that queue might have to be considered : might have deps and need a queue.

Anyway, last slackpkgplus dev branch has dep resolution, see the forum post in here.
Other third-party tools might as well.
 
1 members found this post helpful.
Old 09-11-2022, 04:47 PM   #6
Tonus
Senior Member
 
Registered: Jan 2007
Location: Paris, France
Distribution: Slackware-15.0
Posts: 1,407
Blog Entries: 3

Rep: Reputation: 514Reputation: 514Reputation: 514Reputation: 514Reputation: 514Reputation: 514
Quote:
Originally Posted by allennet View Post
My need is to install packages in slackware. To solve dependencies, slpkg does it?.
Are you sure you really want to use Slackware ?
 
Old 09-11-2022, 06:12 PM   #7
fourtysixandtwo
Member
 
Registered: Jun 2021
Location: Alberta
Distribution: Slackware...mostly
Posts: 323

Rep: Reputation: 216Reputation: 216Reputation: 216
Looks to be an issue with version 4.1.4 that Dimitris pushed last week. Have you reached out to him about it?

The update to SQLAlchemy does not look to be the cause. I just tested it with both versions and get the same error you do.

You could downgrade to slpkg 4.1.3 in the meantime.
 
2 members found this post helpful.
Old 09-11-2022, 06:51 PM   #8
allennet
Member
 
Registered: Feb 2022
Posts: 41

Original Poster
Rep: Reputation: 2
slpkg

Quote:
Originally Posted by Tonus View Post
Did you build the queue first ?
Code:
sqg -p slpkg
Then sbopkg will ask if you want to build the package or the queue.
Several packages in that queue might have to be considered : might have deps and need a queue.

Anyway, last slackpkgplus dev branch has dep resolution, see the forum post in here.
Other third-party tools might as well.
Mr. Tonus,

this does the trick | sqg -p | Thanks a lot, it works for the rest of the programs.

I quit to slpkg, im using slackware 15.0. By some reason (in my case), that program only works on current.

im fine now with sbopkg.

It seems slpkg has some issues with sql and python. (ON 15.0 stable...)

sbopkg with sqg -p fix my dependencies
 
Old 09-11-2022, 06:55 PM   #9
allennet
Member
 
Registered: Feb 2022
Posts: 41

Original Poster
Rep: Reputation: 2
slpkg

Quote:
Originally Posted by fourtysixandtwo View Post
Looks to be an issue with version 4.1.4 that Dimitris pushed last week. Have you reached out to him about it?

The update to SQLAlchemy does not look to be the cause. I just tested it with both versions and get the same error you do.

You could downgrade to slpkg 4.1.3 in the meantime.
THATS THE REASON, AT LAST. ok

Thanks a lot
 
Old 09-11-2022, 07:00 PM   #10
allennet
Member
 
Registered: Feb 2022
Posts: 41

Original Poster
Rep: Reputation: 2
slpkg

Quote:
Originally Posted by fourtysixandtwo View Post
Looks to be an issue with version 4.1.4 that Dimitris pushed last week. Have you reached out to him about it?

The update to SQLAlchemy does not look to be the cause. I just tested it with both versions and get the same error you do.

You could downgrade to slpkg 4.1.3 in the meantime.

Can you give me something about how to downgrade to 4.1.3 slpkg?, please.

Any link or instruction?.

Thanks
 
Old 09-11-2022, 07:23 PM   #11
fourtysixandtwo
Member
 
Registered: Jun 2021
Location: Alberta
Distribution: Slackware...mostly
Posts: 323

Rep: Reputation: 216Reputation: 216Reputation: 216
Quote:
Originally Posted by allennet View Post
Can you give me something about how to downgrade to 4.1.3 slpkg?, please.

Any link or instruction?.

Thanks
Unless you clean up the build location (default is /tmp) the old package should still be there and you can just "upgradepkg /tmp/slpkg-4.1.3-x86_64-1_SBo.tgz"
 
Old 09-11-2022, 07:31 PM   #12
allennet
Member
 
Registered: Feb 2022
Posts: 41

Original Poster
Rep: Reputation: 2
slpkg

Quote:
Originally Posted by fourtysixandtwo View Post
Unless you clean up the build location (default is /tmp) the old package should still be there and you can just "upgradepkg /tmp/slpkg-4.1.3-x86_64-1_SBo.tgz"
working version here:


https://sourceforge.net/projects/slpkg/

Thanks a lot.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: How to fix common pitfalls with the Python ORM tool SQLAlchemy LXer Syndicated Linux News 0 09-12-2019 03:36 PM
LXer: SQLAlchemy LXer Syndicated Linux News 0 04-12-2013 02:11 AM
Yum fails with sqlite3.OperationalError hemanshurpatel Linux - Software 1 02-23-2010 05:15 AM
we're seeking someone who has skills on sqlalchemy and turbogears JaDa General 0 09-21-2006 01:49 PM
linux scripting help needed read from file line by line exc commands each line read atokad Programming 4 12-26-2003 10:24 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 04:48 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration