You are not logged in.
I'm on sqlite 3.10.1-1. I can't upgrade any other packages because of the sqlite errors. How should I fix this?
error: failed to commit transaction (conflicting files)
sqlite: /usr/bin/showdb exists in filesystem
sqlite: /usr/bin/showjournal exists in filesystem
sqlite: /usr/bin/showstat4 exists in filesystem
sqlite: /usr/bin/showwal exists in filesystem
sqlite: /usr/bin/sqldiff exists in filesystem
sqlite: /usr/bin/sqlite3 exists in filesystem
sqlite: /usr/include/sqlite3.h exists in filesystem
sqlite: /usr/include/sqlite3ext.h exists in filesystem
sqlite: /usr/lib/libsqlite3.so exists in filesystem
sqlite: /usr/lib/libsqlite3.so.0 exists in filesystem
sqlite: /usr/lib/libsqlite3.so.0.8.6 exists in filesystem
sqlite: /usr/lib/pkgconfig/sqlite3.pc exists in filesystem
sqlite: /usr/share/licenses/sqlite/license.txt exists in filesystem
sqlite: /usr/share/man/man1/sqlite3.1.gz exists in filesystem
Last edited by zerophase (2016-01-23 01:50:10)
Offline
What does pacman -Qo /usr/bin/showdb say?
Sometimes I seem a bit harsh — don’t get offended too easily!
Offline
When posting configs, code or command output, please use [ code ] tags, not [ quote ] tags https://bbs.archlinux.org/help.php#bbcode
like this
It makes the code more readable and - in case of longer listings - more convenient to scroll through.
Offline
pacman -Qo /usr/bin/showdb shows:
error: No package owns /usr/bin/showdb
Offline
How about:
ls -l /var/lib/pacman/local/sqlite-*
cat /var/lib/pacman/local/sqlite-*/files
Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD
Making lemonade from lemons since 2015.
Offline
ls -l /var/lib/pacman/local/sqlite-* shows:
total 0
-rw-r--r-- 1 root root 0 Jan 17 11:33 desc
-rw-r--r-- 1 root root 0 Jan 17 11:33 files
-rw-r--r-- 1 root root 0 Jan 14 09:35 mtree
cat /var/lib/pacman/local/sqlite-*/files shows nothing.
Offline
From the ls output, it is apparent that all the files containing information about the sqlite package are empty (0 bytes in size). What this means is that you have a corrupted pacman database. What caused this corruption is a possible cause of concern -- it could mean that your filesystem is damaged, or your physical disk is failing, or it could mean that your system simply experienced an unexpected shutdown (e.g. power outage/hard reset). You should investigate this further, particularly if it isn't the latter explanation.
If the disk and filesystem are healthy, then the corruption may be limited to this single package. In this case you should (ideally) repair pacman's database by "reinstalling" the version you currently have installed, then try upgrading again. If you haven't cleared your pacman cache lately, you should be able to repair pacman's db with:
# pacman -U --dbonly /var/cache/pacman/pkg/sqlite-3.10.1-1-$(uname -m).pkg.tar.xz
If your cache has been cleared, you can acquire the relevant package from the ALA.
Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD
Making lemonade from lemons since 2015.
Offline
It's probably the latter explanation. I had to rsync -a my backup from the Arch live disk, after the computer just shut off after an update. I had one more of sudden shut down happen since then. I think it's that the uncore on my cpu is going bad. It freezes if I don't up the voltage on it at stock settings. I ran memtest for about 2 hours, and couldn't find any memory related errors.
Offline