Using ubuntu with apt repository from ceph.
Ok that helped me figure out that it's .mgr not mgr.
# ceph -v
ceph version 17.2.3 (dff484dfc9e19a9819f375586300b3b79d80034d) quincy
(stable)
# export CEPH_CONF='/etc/ceph/ceph.conf'
# export CEPH_KEYRING='/etc/ceph/ceph.client.admin.keyring'
# export CEPH_ARGS='--log_to_file true --log-file
ceph-sqlite.log --debug_cephsqlite 20 --debug_ms 1'
# sqlite3
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> .load libcephsqlite.so
sqlite> .open file:///.mgr:devicehealth/main.db?vfs=ceph
sqlite> .tables
Segmentation fault (core dumped)
# dpkg -l | grep ceph | grep sqlite
ii libsqlite3-mod-ceph 17.2.3-1focal
amd64 SQLite3 VFS for Ceph
Attached ceph-sqlite.log
On Mon, Aug 15, 2022 at 11:10 PM Patrick Donnelly <pdonnell@xxxxxxxxxx>
wrote:
> 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
