search

AlexCovizzi / vscode-sqlite

VSCode extension to explore and query SQLite databases.
Apache License 2.0
199 stars 23 forks source link

Can't open database anymore on any project #71

Closed vanny96 closed 5 years ago

vanny96 commented 5 years ago

It always stops me with an error saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received."

When I go to see the VSCode "output" window it says "Unable to find a valid SQLite command. Fallback binary is not valid."

It worked fine before, what happened?

AlexCovizzi commented 5 years ago

Hi @vanny96, what OS are you using?

vanny96 commented 5 years ago

I'm using Lubuntu, I've got a pretty old pc so I had to choose a lightweight OS but as I said the extension worked fine until today

AlexCovizzi commented 5 years ago

Sorry for the late reply, are you still having this problem?

eckenroed commented 5 years ago

I'm having the same issue. I am currently developing in an Amazon AWS Workspace with Amazon Linux (Based off CentOS). No matter what I do I get an error trying to open SQLite databases in my project. I've even brought over some files I know work in the command line that are still having issues in the VS Code plugin. Any help would be great.

AlexCovizzi commented 5 years ago

Can you do this:

  1. In the settings set: "sqlite.logLevel": "DEBUG"
  2. Open command palette > SQLite: Open Database > show table
  3. Open command palette > SQLite: Show output
  4. Copy and paste the output here.
eckenroed commented 5 years ago

So When I select a database is when the error window shows up. I did set the log level to Debug. But here is the only thing that was output. 

[6:18:48 PM][vscode-sqlite][INFO] Activating extension vscode-sqlite v0.7.0...
[6:18:48 PM][vscode-sqlite][INFO] Extension activated.

ScreenShot_SQLite_VSCode

Here is a screen shot of exactly the error I am seeing. I know the DB is fine because I can open it in several SQLite clients as well as through the CLI.

AlexCovizzi commented 5 years ago

I'll preface this by saying that I have zero experience with CentOS, so I'll write what is going on behind the scenes and maybe you can help me figure out what could be the problem.

That message pops up if any of this commands fails:

.open '<database path>'\n
select 1 from sqlite_master;\n
.print <random string used to separate the output of each command>\n

The first command is to open the database, the second command is to make sure that the file is actually a sqlite database, the third command is a sort of separator (the random string is an 8 character string that uses the characters [a-zA-Z0-9]).

The database is fine, so maybe the problem is when executing the command .print?

eckenroed commented 5 years ago

I’ll play around some more. I’ll also test it on my Windows and Mac environments with the same SQLite file if I can determine it’s an OS issue then I know where to start. I’ll post an update in a few days.

On Wed, Jun 12, 2019 at 09:03 AlexCovizzi notifications@github.com wrote:

I'll preface this by saying that I have zero experience with CentOS, so I'll write what is going on behind the scenes and maybe you can help me figure out what could be the problem.

That message pops up if any of this commands fails:

.open ''\n select 1 from sqlite_master;\n .print \n

The first command is to open the database, the second command is to make sure that the file is actually a sqlite database, the third command is a sort of separator (the random string is an 8 character string that uses the characters [a-zA-Z0-9]).

The database is fine, so maybe the problem is when executing the command .print?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AlexCovizzi/vscode-sqlite/issues/71?email_source=notifications&email_token=AAKGAF36265HDUACLCO557TP2EF3NA5CNFSM4HOND7QKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODXQXL4A#issuecomment-501315056, or mute the thread https://github.com/notifications/unsubscribe-auth/AAKGAF73DXTDFMOTHK5DRE3P2EF3NANCNFSM4HOND7QA .

-- Cheers,

Ben Eckenroed Software Developer 385-219-0007 beneckenroed@gmail.com

adalisan commented 5 years ago

I just want to add that I have the same problem on Centos7. A database that I can access with the sqlite3 client can't be opened.

adalisan commented 5 years ago

If it helps, here's the stack trace when I enable dev tools

/export/u10/VSCode-l…kbench.main.js:2379 Failed to open database: Database failed to open: '/nfs/mercury-11/<...removed...>'
onDidNotificationChange | @ | /export/u10/VSCode-l…kbench.main.js:2379
-- | -- | --
  | _register.model.onDidNotificationChange.e | @ | /export/u10/VSCode-l…kbench.main.js:2379
  | fire | @ | /export/u10/VSCode-l…orkbench.main.js:77
  | notify | @ | /export/u10/VSCode-l…kbench.main.js:2435
  | notify | @ | /export/u10/VSCode-l…kbench.main.js:3660
  | r | @ | /export/u10/VSCode-l…kbench.main.js:3249
  | _showMessage | @ | /export/u10/VSCode-l…kbench.main.js:3249
  | $showMessage | @ | /export/u10/VSCode-l…kbench.main.js:3249
  | _doInvokeHandler | @ | /export/u10/VSCode-l…kbench.main.js:3293
  | _invokeHandler | @ | /export/u10/VSCode-l…kbench.main.js:3293
  | _receiveRequest | @ | /export/u10/VSCode-l…kbench.main.js:3292
  | _receiveOneMessage | @ | /export/u10/VSCode-l…kbench.main.js:3290
  | _protocol.onMessage.e | @ | /export/u10/VSCode-l…kbench.main.js:3289
  | fire | @ | /export/u10/VSCode-l…orkbench.main.js:77
  | a | @ | /export/u10/VSCode-l…rkbench.main.js:322
  | e | @ | /export/u10/VSCode-l…rkbench.main.js:322
  | fire | @ | /export/u10/VSCode-l…orkbench.main.js:77
  | _receiveMessage | @ | /export/u10/VSCode-l…rkbench.main.js:331
  | S._socketDisposables.push._socketReader.onMessage.e | @ | /export/u10/VSCode-l…rkbench.main.js:328
  | fire | @ | /export/u10/VSCode-l…orkbench.main.js:77
  | acceptChunk | @ | /export/u10/VSCode-l…rkbench.main.js:325
  | _register._socket.onData.e | @ | /export/u10/VSCode-l…rkbench.main.js:324
  | t | @ | /export/u10/VSCode-l…rkbench.main.js:333
  | emit | @ | events.js:182
  | addChunk | @ | _stream_readable.js:279
  | readableAddChunk | @ | _stream_readable.js:264
  | Readable.push | @ | _stream_readable.js:219
  | onread
AlexCovizzi commented 5 years ago

Should be fixed in version 0.7.1 There were a couple of problems: It failed to recognize if the SQLite binaries were not supported (it's needed at least version 3.9), and on CentOS the binaries provided throw an error when started, but work fine after that. I fixed the first problem and added a workaround for the second. If there are other errors feel free to reopen this issue.

lucasnike commented 4 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

IceHower commented 4 years ago

Yeah man, I have the same issue.. and the problem is that I need to check a seed I created with knex

IceHower commented 4 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

Man, try this command in terminal sudo apt install sqlite, it solved the same problem for me

lucasnike commented 4 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

Man, try this command in terminal sudo apt install sqlite, it solved the same problem for me

Thank you it really solved my problems, se ya. Até mais cara.

wvvinicius commented 4 years ago

Hello devs, the problem is solved with the command taught above. Tks, :)

cesarvspr commented 4 years ago

So tem br fazendo a NLW aqui kkkkkkkkkkkkkkkkkkkkkkk Valeu gurizada, funcionou aqui kkkkkkkk

lcsdiniz commented 4 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

Man, try this command in terminal sudo apt install sqlite, it solved the same problem for me

Thanks man and good coding during the Next Level Week

IceHower commented 4 years ago

So tem br fazendo a NLW aqui kkkkkkkkkkkkkkkkkkkkkkk Valeu gurizada, funcionou aqui kkkkkkkk

KKK é nois

IceHower commented 4 years ago

Se você tiver usando o Ubuntu sudo apt-get install sqlite

kedma commented 4 years ago

Ok. Mas e para abrir o banco no vs? Dsculpe apaguei*

IceHower commented 4 years ago

Ok. Mas e para abrir o banco no vs? Dsculpe apaguei*

Então, ao instalar a extensão deve funcionar corretamente

kedma commented 4 years ago

Ok. Mas e para abrir o banco no vs? Dsculpe apaguei*

Então, ao instalar a extensão deve funcionar corretamente

Está dando esse erro... Failed to open database: Database failed to open: SQLite process failed to start: The argument 'file' cannot be empty. Received ''

IceHower commented 4 years ago

Então, você usa qual sistema operacional.. esse comando é no ubuntu 20.04 ao executar no terminal ele vai instalar e ao reiniciar o vs code deve abrir sem problemas.. é o msm erro que estava acontecendo comigo

kedma commented 4 years ago

Ok. Mas e para abrir o banco no vs? Dsculpe apaguei*

Então, ao instalar a extensão deve funcionar corretamente

Está dando esse erro... Failed to open database: Database failed to open: SQLite process failed to start: The argument 'file' cannot be empty. Received ''

Então, você usa qual sistema operacional.. esse comando é no ubuntu 20.04 ao executar no terminal ele vai instalar e ao reiniciar o vs code deve abrir sem problemas.. é o msm erro que estava acontecendo comigo

Beleza deu certo aqui, reiniciei e deu certo! E vamos que vamos no NLW Também estou usando o ubuntu 20.04. Obrigada.

junieldantas commented 4 years ago

Se você tiver usando o Ubuntu sudo apt-get install sqlite

Obrigado @IceHower

NLW =)

W3ND31 commented 4 years ago

Guys, u don't need this. If u enabled "sqlite.logLevel":"DEBUG" on VsCode JSON Settings, look for the file like "/home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

Go to terminal and type "chmod +x /home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

And the issue is resolved without installing anything else.

I think that this will happen only on unix SO's.

sebaxtian commented 4 years ago

Hi, I had the same problem, but my solution was to add execution permissions on this: chmod +x ~/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64

I have Ubuntu Linux

Thanks @W3ND31

jonasmateus commented 4 years ago

Thanks @sebaxtian and @W3ND31 ! I used this above command and a solved the same problem. I don't know why the Linux Mint especially even admin's permissions is denied some actions from the VsCode. In fact, if I'm the admin than I could work normally on my files, changing and creating them.

wellingtoncid commented 4 years ago

Thanks for the help! Still working on #NLW2.

tadeubdev commented 4 years ago

Thanks for your help! #NLW2

dbtrnl commented 4 years ago

Guys, u don't need this. If u enabled "sqlite.logLevel":"DEBUG" on VsCode JSON Settings, look for the file like "/home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

Go to terminal and type "chmod +x /home/wendel/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64"

And the issue is resolved without installing anything else.

I think that this will happen only on unix SO's.

Worked for me on Ubuntu 20.04 But the extension complained of a missing libtinfo5 library, so i had to install it with apt.

t-basilio commented 4 years ago

Hi, I had the same problem, but my solution was to add execution permissions on this: chmod +x ~/.vscode/extensions/alexcvzz.vscode-sqlite-0.8.2/bin/sqlite-v3.26.0-linux-x64

I have Ubuntu Linux

Thanks @W3ND31

I tried it on my terminal but, as it didn't work, so I installed thought apt

LucasCaputo commented 4 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

Man, try this command in terminal sudo apt install sqlite, it solved the same problem for me

Deu certo! obrigado

barcelos3 commented 4 years ago

Top dando permissão na extesão do VSCODE funcionou aqui no meu linux / Mint

Drslx commented 4 years ago

Então, tem br fazendo a NLW aqui kkkkkkkkkkkkkkkkkkkkkkkk Valeu gurizada, funcionou aqui kkkkkkkk

Eu também estou aqui terminando o projeto NLW e não abriu sql, mas la mesmo na extensão falava para dar um apt install sqlite3, mas eu uso DB Browser for SQLite ou Beekeper Studio.

matheuscarv69 commented 3 years ago

Show, estava pensando que era um problema de compatibilidade do sqlite com o WSL2, mas resolveu dando executando o comando sudo apt install sqlite

Obrigado pessoal.

tiagosatur commented 3 years ago

Also NLW 5 haha

gofordeepu commented 3 years ago

if you are using ubuntu and the error shows then first install sqlite3 using sudo apt install sqlite3 and then try it will surely work

JahanzebNawaz commented 3 years ago

In my case, I'm using Ubuntu 20.04 I tried installing sudo apt install sqlite3 but it didn't worked. i changed my extension settings.

,

gofordeepu commented 3 years ago

https://gofordeepu.medium.com/how-to-open-sqlite3-database-in-vscode-in-ubuntu-efa6c0ea0228 go to this link i have written a article with images it will surely help you.

messiasGeovani commented 3 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

Man, try this command in terminal sudo apt install sqlite, it solved the same problem for me

Worked for me on Ubuntu 20.04 too!

surya-pratap-2181 commented 3 years ago

I'm using Ubuntu 20.04 LTS and I have the same probleme, but in my case the extension never worked, so the first time I installed and tried to open my database file Vs Code showed me a pop-up saying: "Failed to open database: Database failed to open: SQLite process failed to start. The argument 'file' cannot be empty. Received.", however I'm sure that my database file has no problem, so probably the issue is in the extension in some linux distros.

Man, try this command in terminal sudo apt install sqlite, it solved the same problem for me

Thanks man this will do the trick

lacek commented 3 years ago

Just run into the same problem. My vscode is connected to a Linux server via "Remote -SSH" extension. Sadly the server runs old Ubuntu 14.04 and the latest sqlite3 available from apt is version 3.8, which is incompatible.

My workaround is to use conda:

  1. created a conda environment and install sqlite3 (version >= 3.9)
  2. in vscode remote settings, change the "sqlite.sqlite3" setting to the sqlite3 executable in the conda environment
  3. reload vscode
hugomcm commented 2 years ago

Like @dbtrnl mentioned, installing "libtinfo5" works for me on MX Linux 19.4 (Debian 10 buster).

The binary provided with the extension needs the linked library "libtinfo5" to be installed on Linux. binary path: /home/$USER/.vscode/extensions/alexcvzz.vscode-sqlite-0.13.0/bin/sqlite-v3.26.0-linux-x64

With a "sudo apt install libtinfo5" the problem is solved, but IMHO the dependencies should be included into the binary to solve these kind of annoying bugs.

yunusa-sanusi commented 2 years ago

In my case, I'm using Ubuntu 20.04 I tried installing sudo apt install sqlite3 but it didn't worked. i changed my extension settings.

  • Open Settings in VS Code,
  • Search for SQLITE.
  • Change Sqlite Log Level to DEBUG.
  • and try it worked.
  • "sqlite.logLevel":"DEBUG" on VsCode JSON Settings

Thank you. This solved the issue for me.

PCRinus commented 2 years ago

In my case, I'm using Ubuntu 20.04 I tried installing sudo apt install sqlite3 but it didn't worked. i changed my extension settings.

* Open Settings in VS Code,

* Search for SQLITE.

* Change Sqlite Log Level to DEBUG.

* and try it worked.

* "sqlite.logLevel":"DEBUG" on VsCode JSON Settings

,

Thanks. I'm running Ubuntu 20.04 in WSL, an this worked for me

fvaldezc commented 2 years ago

https://github.com/AlexCovizzi/vscode-sqlite/issues/71#issuecomment-1034823139

Thanks!!!, It worked for me as well. I only will add that Settings is found under File > Preferences > Settings

jesorian commented 2 years ago

In my case, I'm using Ubuntu 20.04 I tried installing sudo apt install sqlite3 but it didn't worked. i changed my extension settings.

  • Open Settings in VS Code,
  • Search for SQLITE.
  • Change Sqlite Log Level to DEBUG.
  • and try it worked.
  • "sqlite.logLevel":"DEBUG" on VsCode JSON Settings

,

This one works the best of all the solution. Thanks mate!

vinibenso commented 2 years ago

sudo apt install sqlite

thank you this resolve for me.