Opened 13 months ago

Closed 4 months ago

#25970 closed defect (user disappeared)

Can not start nyx in a Raspberry pi 3

Reported by: cypherpunks Owned by: atagar
Priority: Immediate Milestone:
Component: Core Tor/Nyx Version:
Severity: Normal Keywords: nyx,
Cc: Actual Points:
Parent ID: Points:
Reviewer: Sponsor:

Description

Dear friend I am a newbie and sorry to disturb you, but I really do not know why this is happening?

When I try to start nyx I receive an error about sqlite3 database.

Enclosed some pictures.

<a href="https://ibb.co/fjgOBx"><img src="https://preview.ibb.co/hYRZJc/Captura_de_tela_2018_04_29_23_56_29_nyx_erro_01.png" alt="Captura_de_tela_2018_04_29_23_56_29_nyx_erro_01" border="0"></a>
<a href="https://ibb.co/iKtQPH"><img src="https://preview.ibb.co/m1wejH/Captura_de_tela_2018_04_29_23_56_29_nyx_erro_02.png" alt="Captura_de_tela_2018_04_29_23_56_29_nyx_erro_02" border="0"></a>
<a href="https://ibb.co/mwNVrx"><img src="https://preview.ibb.co/buWOBx/Captura_de_tela_2018_04_29_23_56_29_nyx_erro_03.png" alt="Captura_de_tela_2018_04_29_23_56_29_nyx_erro_03" border="0"></a><br /><a target='_blank' href='https://deleteacc.com/g'>delete your account</a><br />

Child Tickets

Attachments (3)

Captura de tela_2018-04-29_23-56-29-nyx-erro-01.png (163.2 KB) - added by cypherpunks 13 months ago.
Captura de tela_2018-04-29_23-56-29-nyx-erro-02.png (161.2 KB) - added by cypherpunks 13 months ago.
Captura de tela_2018-04-29_23-56-29-nyx-erro-03.png (159.0 KB) - added by cypherpunks 13 months ago.

Download all attachments as: .zip

Change History (10)

comment:1 Changed 13 months ago by cypherpunks

Sorry I did not I could put the photos here.

comment:2 Changed 13 months ago by atagar

Hi cypherpunks, thanks for reporting this! New one to me. Quick search seems to indicate that this is sqlite corruption. Fortunately we just use it for caching. If you delete '~/.nyx/cache.sqlite' does nyx work?

comment:3 Changed 13 months ago by teor

Milestone: Tor: 0.2.9.x-final
Version: Tor: 0.2.9.14

comment:4 Changed 13 months ago by cypherpunks

Dear Tor Friend Atagar

Thanks for your help, now it is working, the problem started when sqlite.database was with more than 999 connections or something like this I can not remember! I am new at tor just start 3 days ago, it is possible in some way to measure the size of my sqlite.database so I could erase it time to time? Or this is really a bug, not a big one but a minor! Anyway I respectfully thankfully again, have a nice day! :)

Enclosed the correction file showing nyx working again, for how long a do not know yet.

<a href="https://ibb.co/hdqLrx"><img src="https://preview.ibb.co/c8nddc/Captura_de_tela_2018_04_30_09_02_28_atagar_correction_del_cache_sqlite_database.png" alt="Captura_de_tela_2018_04_30_09_02_28_atagar_correction_del_cache_sqlite_database" border="0"></a>

comment:5 Changed 13 months ago by atagar

Thanks cypherpunks! This is definitely a bug on my end. My rough understanding from a little searching is that this arises if Nyx terminates uncleanly while it's writing to it. Per chance did you issue a kill command, ctrl+c, or restart your Raspberry Pi while running Nyx?

Regardless, I should fix this on Nyx's side. Maybe there's an integrity check I can do to wipe it ourselves if the database gets into this state. Juggling other things so it'll probably be a few weeks before I can get to this.

On a side note if this arises again would you mind emailing me the broken sqlite database? I could use it to reproduce the issue on my end. Please feel free to pass on this if there's anything sensitive or you feel at all uncomfortable sending it. :)

comment:6 in reply to:  5 Changed 13 months ago by cypherpunks

Sure I could send it.

EDIT by different cypherpunk: The cypherpunks account can no longer open new tickets or comment on existing ones. Please fix :'(

Replying to atagar:

Thanks cypherpunks! This is definitely a bug on my end. My rough understanding from a little searching is that this arises if Nyx terminates uncleanly while it's writing to it. Per chance did you issue a kill command, ctrl+c, or restart your Raspberry Pi while running Nyx?

Regardless, I should fix this on Nyx's side. Maybe there's an integrity check I can do to wipe it ourselves if the database gets into this state. Juggling other things so it'll probably be a few weeks before I can get to this.

On a side note if this arises again would you mind emailing me the broken sqlite database? I could use it to reproduce the issue on my end. Please feel free to pass on this if there's anything sensitive or you feel at all uncomfortable sending it. :)

EDIT by just different cypherpunk:

i also experience this trouble in raspbian.

Last edited 7 months ago by cypherpunks (previous) (diff)

comment:7 Changed 4 months ago by atagar

Resolution: user disappeared
Status: newclosed

Hi all, gonna resolve this. If anyone manages to repro this please let me know! I'd be delighted to fix this, but doing so requires a copy of a corrupted sqlite database.

Note: See TracTickets for help on using tickets.