Vscode.db can't be downloaded

Whenever I try to download an app using pacman, I get this:

sudo pacman -S vlc                                                                                   ✔ 
[sudo] password for calvino: 
warning: database file for 'vscode' does not exist (use '-Sy' to download)
:: Some packages should be upgraded first...
error: failed to prepare transaction (could not find database)

error: failed to prepare transaction (could not find database)

And here’s my neofetch:

██████████████████  ████████   calvino@calvin-dx4860 
██████████████████  ████████   --------------------- 
██████████████████  ████████   OS: Manjaro Linux x86_64 
██████████████████  ████████   Host: DX4860 
████████            ████████   Kernel: 6.1.22-1-MANJARO 
████████  ████████  ████████   Uptime: 40 mins 
████████  ████████  ████████   Packages: 1367 (pacman), 20 (flatpak) 
████████  ████████  ████████   Shell: bash 5.1.16 
████████  ████████  ████████   Resolution: 1920x1080 
████████  ████████  ████████   DE: Plasma 5.27.3 
████████  ████████  ████████   WM: KWin 
████████  ████████  ████████   Theme: [Plasma], Breeze [GTK2/3] 
████████  ████████  ████████   Icons: [Plasma], breeze [GTK2/3] 
████████  ████████  ████████   Terminal: konsole 
                               CPU: Intel i5-2300 (4) @ 3.100GHz 
                               GPU: Intel 2nd Generation Core Processor Family 
                               Memory: 4803MiB / 15911MiB 


Can someone help with this?


Always be fully synced before installing packages.

Arch Wiki - Partial upgrades are unsupported

You are even being warned.

So … just get in the habit of passing the full sync/upgrade command when installing:

sudo pacman -Syu vlc

Given your current state … you may want to sort mirrors first:

sudo pacman-mirrors -f

are you sure about that?

sudo pacman -Syu vlc                                                                                 ✔ 
[sudo] password for calvino: 
:: Synchronizing package databases...
 core is up to date
 extra is up to date
 community is up to date
 multilib is up to date
 vscode.db failed to download
error: failed retrieving file 'vscode.db' from packages.microsoft.com : The requested URL returned error: 404
error: failed to synchronize all databases (failed to retrieve some files)

Your problem had multiple parts.
The first part was your mirror status, lack of database, etc. that part is fixed now.

This is a different problem.
You seem to have manually added a third party repository.
This is of course unsupported.
I cannot comment on whether it is functioning properly or not.
(you will find your entry somewhere in /etc/pacman.conf or in directory /etc/pacman.conf.d/)

You asked a different question in your original post text than you did in the title. :wink:


thats also what chatgpt said

I wouldnt rely on that if I were you.

1 Like

true, makes sense

what would that entry be under, i know how to use nano and stuff not tutorial pls

nvm i got it

You added it in the first place didnt you?
I already pointed out where such edits would normally be made:

If you need step-by-step … then please provide the link created from:

cat /etc/pacman.conf | curl -F 'file=@-' https://0x0.st

no i got it it works now thxx, ill tell u if anything goes wrong

Resync/update after the edits and your output should be more clean:

sudo pacman -Syu

I realize there is another problem.

The communty repo no longer exists.
Given your recent operations you probably know how to handle this.
But it would have also been provided via a pacnew file … so this indicates you may have been ignoring those for some time.
To print your pacnews:

pacdiff -o

For an easy gui to handle them see package manjaro-pacnew-checker

ok thx!! now i can update my system

Great. But one more thing. See my edit/PS above. :point_up:

already saw it, thanks!! :smiley:

ok i have 891 updates to do :skull:

That … that probably means some good sections of the file system has been augmented from its packaged status.
If they were untended for years I might think there would be a few dozen … but hundreds? …
Thats more likely an outcome of running a downloaded install script that overwrites large numbers of drivers libraries or something.

yeah, i moved from across the USA lol

no i mean packages

oh. packages. not pacnews. gotchya. :sweat_smile:
Take note of the bottom as well. ex:

Total Download Size:    2.78 MiB
Total Installed Size:  10.71 MiB
Net Upgrade Size:       0.02 MiB

A lot of the apparent download size is not strictly ‘addition’.
Some upgrades its even a net negative.

There is the package cache though. Which is kept for easy downgrading.
You can, for example, sweep it to only keep the 2 most recent versions:

paccache -rvk2

And/or to remove all cache of any packages no longer installed:

paccache -rvuk0

A bigger clean operation can be used too, which is also helpful to remove unused repositories:

sudo pacman -Scc

(take care to not remove your whole cache unless you want to)

alr thx!!

@calvingamez Welcome to the forum! :wave:

Sorry, what language is that? It’s definitely not English. Please use words, not invented abbreviations.

This is a support forum, not a social network or instant messenger. Note that I have merged your successive replies and fixed your formatting–this time.

Please review the following:

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.