Re: Quincy: Corrupted devicehealth sqlite3 database from MGR crashing bug

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Daniel,

On Mon, Aug 15, 2022 at 10:38 AM Daniel Williams <danielwoz@xxxxxxxxx> wrote:
>
> My managers are crashing reading the sqlite database for deviceheatlth:
> .mgr:devicehealth/main.db-journal
> debug     -2> 2022-08-15T11:14:09.184+0000 7fa5721b7700  5 cephsqlite:
> Read: (client.53284882) [.mgr:devicehealth/main.db-journal] 0x5601da0c0008
> 4129788~65536
> debug     -1> 2022-08-15T11:14:09.184+0000 7fa5721b7700  5 client.53284882:
> SimpleRADOSStriper: read: main.db-journal: 4129788~65536
> debug      0> 2022-08-15T11:14:09.200+0000 7fa664aca700 -1 *** Caught
> signal (Segmentation fault) **
>
> I upgraded to 17.2.3 but it seems like I'll need to do a sqlite recovery on
> the database, since the devicehealth module is now non-optional.
>
> I tried:
> sqlite3 -cmd '.load libcephsqlite.so' '.open
> file:///mgr:devicehealth/main.db?vfs=ceph'
> but that didn't work
> Error: unable to open database ".open
> file:///mgr:devicehealth/main.db?vfs=ceph": unable to open database file
>
> Any suggestions?

Are you on Ubuntu or CentOS?

You can try to figure out where things are going wrong loading the database via:

env CEPH_ARGS='--log_to_file true --log-file foo.log
--debug_cephsqlite 20 --debug_ms 1'  sqlite3 ...

-- 
Patrick Donnelly, Ph.D.
He / Him / His
Principal Software Engineer
Red Hat, Inc.
GPG: 19F28A586F808C2402351B93C3301A3E258DD79D

_______________________________________________
ceph-users mailing list -- ceph-users@xxxxxxx
To unsubscribe send an email to ceph-users-leave@xxxxxxx



[Index of Archives]     [Information on CEPH]     [Linux Filesystem Development]     [Ceph Development]     [Ceph Large]     [Ceph Dev]     [Linux USB Development]     [Video for Linux]     [Linux Audio Users]     [Yosemite News]     [Linux Kernel]     [Linux SCSI]     [xfs]


  Powered by Linux