Paconky: displays repo and AUR pkg info in conky

JoeHartley · 2020-09-26 13:26:45

Reviving an old thread to report a new issue.

Recently paconky stopped working for me, and running from the command line gives me this:

[jh@xtc .conky]$ ~/.conky/paconky ~/.cache/trizen
Traceback (most recent call last):
  File "/home/jh/.conky/paconky", line 312, in <module>
    main(sys.argv[1], sys.argv[2:])
  File "/home/jh/.conky/paconky", line 284, in main
    aur = AUR.AurRpc()
  File "/usr/lib/python3.8/site-packages/AUR/RPC.py", line 363, in __init__
    mdb.db_initialize()
  File "/usr/lib/python3.8/site-packages/MemoizeDB.py", line 196, in db_initialize
    self.db_clean()
  File "/usr/lib/python3.8/site-packages/MemoizeDB.py", line 428, in db_clean
    deleted = c.execute(query, (arg,)).rowcount
sqlite3.DatabaseError: database disk image is malformed

I had a power supply issue (now fixed) that caused a hard stop of my system a couple of times, which is likely to have corrupted a file somewhere.

Trizen and pacman both work fine, and I've re-installed python3-aur to no effect.

Does anyone know which DB is malformed, and how it could be fixed? Thanks for any and all tips.

d_fajardo · 2020-09-26 15:01:30

Thanks for pointing this out as I wasn't aware. I wasn't getting the desired output with paconky neither.
I rebuilt one by one the dependencies and rebuilding python3-memoizedb fixed the issue for me.
See if that fixes the issue for you as well.

Last edited by d_fajardo (2020-09-26 15:02:09)

JoeHartley · 2020-09-29 15:45:05

d_fajardo wrote:

Thanks for pointing this out as I wasn't aware. I wasn't getting the desired output with paconky neither.
I rebuilt one by one the dependencies and rebuilding python3-memoizedb fixed the issue for me.
See if that fixes the issue for you as well.

I tried rebuilding python3-memoized as well as python3-aur, but same error.

However, for a reason I still can't fathom, I tried running the script with sudo... and it worked! So clearly it's a permission issue, now to find what the block is.

For now, I've added my paconky to sudoers and changed my paconky line to this:

${execpi 3600 sudo /home/jh/.conky/paconky /home/jh/.cache/trizen 2>/dev/null }

Now it works. I'll look deeper in my copious free time.

Joe

d_fajardo · 2020-09-29 16:15:50

${execpi 3600 sudo /home/jh/.conky/paconky /home/jh/.cache/trizen 2>/dev/null }

paconky is a python script.
What do you get when you run python /home/jh/.conky/paconky /home/jh/.cache/trizen 2>/dev/null?

Xyne · 2020-10-18 17:03:53

The databases are in $XDG_CACHE_HOME/AUR (~/.cache/AUR by default). They only serve to temporarily cache search queries to speed up repeated queries within a short interval. You can remove those file and even that directory and let the script recreate them. If the issue persists, please check the permissions of the files in that directory and report them here.

Arch Linux

#226 2020-09-26 13:26:45

Re: Paconky: displays repo and AUR pkg info in conky

#227 2020-09-26 15:01:30

Re: Paconky: displays repo and AUR pkg info in conky

#228 2020-09-29 15:45:05

Re: Paconky: displays repo and AUR pkg info in conky

#229 2020-09-29 16:15:50

Re: Paconky: displays repo and AUR pkg info in conky

#230 2020-10-18 17:03:53

Re: Paconky: displays repo and AUR pkg info in conky

Board footer