Arch Linux

JoeHartley

Member

Registered: 2011-10-01

Posts: 23

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

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

Member

Registered: 2017-07-28

Posts: 1,229

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

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

Member

Registered: 2011-10-01

Posts: 23

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

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

Member

Registered: 2017-07-28

Posts: 1,229

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

${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

Moderator/TU

Registered: 2008-08-03

Posts: 6,644

Website

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

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.

---

My Arch Linux Stuff • Forum Etiquette • Community Ethos - Arch is not for everyone

d_fajardo

Member

Registered: 2017-07-28

Posts: 1,229

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

Reviving this old thread. After all the recent upgrades of pacman, pyalm, etc, paconky started throwing seg faults:

           PID: 2700534 (python)
           UID: 1000 (brightchip)
           GID: 1000 (brightchip)
        Signal: 11 (SEGV)
     Timestamp: Tue 2021-06-01 22:34:15 BST (10h ago)
  Command Line: python /home/brightchip/.conky/paconky /home/brightchip/.cache/pacman
    Executable: /usr/bin/python3.9
 Control Group: /user.slice/user-1000.slice/user@1000.service/app.slice/app-org.kde.konsole-a814608aab9f4d1998db86bc4b6e489a.scope
          Unit: user@1000.service
     User Unit: app-org.kde.konsole-a814608aab9f4d1998db86bc4b6e489a.scope
         Slice: user-1000.slice
     Owner UID: 1000 (brightchip)
       Boot ID: bac9048d15cb44e0a573f5cb8628df35
    Machine ID: 0fb949def1e1446aadf8ee07e15b3cc1
      Hostname: taichi-z270
       Storage: /var/lib/systemd/coredump/core.python.1000.bac9048d15cb44e0a573f5cb8628df35.2700534.1622583255000000.zst (present)
     Disk Size: 2.3M
       Message: Process 2700534 (python) of user 1000 dumped core.
                
                Stack trace of thread 2700534:
                #0  0x0000000000000000 n/a (n/a + 0x0)

GNU gdb (GDB) 10.2
Copyright (C) 2021 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-pc-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<https://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
    <http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from /usr/bin/python3.9...
(No debugging symbols found in /usr/bin/python3.9)

warning: core file may not match specified executable file.
[New LWP 2700534]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/usr/lib/libthread_db.so.1".
Core was generated by `python /home/brightchip/.conky/paconky /home/brightchip/.cache/pacman'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x0000000000000000 in ?? ()
(gdb) bt
#0  0x0000000000000000 in ?? ()
#1  0x00007efc8e94afd7 in ?? () from /usr/lib/python3.9/site-packages/pyalpm.cpython-39-x86_64-linux-gnu.so
#2  0x00007efc8fbbd321 in _PyObject_GenericSetAttrWithDict () from /usr/lib/libpython3.9.so.1.0
#3  0x00007efc8fbbccdd in PyObject_SetAttr () from /usr/lib/libpython3.9.so.1.0
#4  0x00007efc8fbc7d94 in _PyEval_EvalFrameDefault () from /usr/lib/libpython3.9.so.1.0
#5  0x00007efc8fbd7adb in _PyFunction_Vectorcall () from /usr/lib/libpython3.9.so.1.0
#6  0x00007efc8fbcbe67 in _PyEval_EvalFrameDefault () from /usr/lib/libpython3.9.so.1.0
#7  0x00007efc8fbc6219 in ?? () from /usr/lib/libpython3.9.so.1.0
#8  0x00007efc8fbd7cfe in _PyFunction_Vectorcall () from /usr/lib/libpython3.9.so.1.0
#9  0x00007efc8fbc7567 in _PyEval_EvalFrameDefault () from /usr/lib/libpython3.9.so.1.0
#10 0x00007efc8fbc6219 in ?? () from /usr/lib/libpython3.9.so.1.0
#11 0x00007efc8fbc5c01 in _PyEval_EvalCodeWithName () from /usr/lib/libpython3.9.so.1.0
#12 0x00007efc8fc7cd63 in PyEval_EvalCode () from /usr/lib/libpython3.9.so.1.0
#13 0x00007efc8fc8cb94 in ?? () from /usr/lib/libpython3.9.so.1.0
#14 0x00007efc8fc8883b in ?? () from /usr/lib/libpython3.9.so.1.0
#15 0x00007efc8fb3725e in ?? () from /usr/lib/libpython3.9.so.1.0
#16 0x00007efc8fb36644 in PyRun_SimpleFileExFlags () from /usr/lib/libpython3.9.so.1.0
#17 0x00007efc8fc9e695 in Py_RunMain () from /usr/lib/libpython3.9.so.1.0
#18 0x00007efc8fc6f349 in Py_BytesMain () from /usr/lib/libpython3.9.so.1.0
#19 0x00007efc8f8fbb25 in __libc_start_main () from /usr/lib/libc.so.6
#20 0x000056292168c04e in _st

@Xyne
Is this something I can fix or does Xyne need to update certain dependencies?
Any thoughts?

d_fajardo

Member

Registered: 2017-07-28

Posts: 1,229

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

Just to update it's working again after the latest pyalpm update.