linux - Locked sqlite IN THE WHOLE SYSTEM -


i got big problem in system. how, entire sqlite sistem become locked. not talking single database, talking every database in system.

ladb08@newcastle:~$ touch new.sqlite3 ladb08@newcastle:~$ sqlite3 new.sqlite3  sqlite version 3.7.3 enter ".help" instructions enter sql statements terminated ";" sqlite> .tables error: database locked sqlite>

even firefox cant open because of same problem. got no idea of why happened. server debian server, , used team develop site rails. centralize stuff in external git repo work own user, , own copy of stuff.

another test:

ladb08@newcastle:~/agendador/db$ lsof test.sqlite3  ladb08@newcastle:~/agendador/db$ fuser test.sqlite3  ladb08@newcastle:~/agendador/db$ strace -e fcntl sqlite3 test.sqlite3 .tables fcntl(3, f_getfd) = 0 fcntl(3, f_setfd, fd_cloexec) = 0 fcntl(4, f_getfd) = 0x1 (flags fd_cloexec) fcntl(3, f_setlk, {type=f_rdlck, whence=seek_set, start=1073741824, len=1}) = -1 enolck (no locks available) error: database locked

no 1 using database. , same occurs empty new ones.

===========================================================================

more info:

root@newcastle:~# cd /home/ladb08/agendador/db/             root@newcastle:/home/ladb08/agendador/db# sqlite3 test.sqlite3 sqlite version 3.7.3 enter ".help" instructions enter sql statements terminated ";" sqlite> .tables error: database locked sqlite> .exit

the problem, usual.

root@newcastle:~# cd /root            root@newcastle:~# cp /home/ladb08/agendador/db/test.sqlite3 ./ root@newcastle:~# sqlite3 test.sqlite3 sqlite version 3.7.3 enter ".help" instructions enter sql statements terminated ";" sqlite> .tables agendamentos              prefeituras               tipo_atendimentos       bloqueios                 profissionais             tipo_situacoes          cidadaos                  schema_migrations         tmibges                 escalas                   tcbos                     tufibges                orgaos                    tconselhos              orgaos_tipo_atendimentos  tipo_acoes

outside nfs partition, no problem same file.

root@newcastle:~# mount (...) rootfs on / type rootfs (rw) urquell.home2:/home2/home-newcastle on /home type nfs (rw,v3,addr=10.17.116.3) fusectl on /sys/fs/fuse/connections type fusectl (rw)

the error code enolck returned when kernel runs out of memory locks (unlikely in case) or when locking operation on remote file system nfs failed.

apparently, file server configured not support file locking.
(whether idea is debatable.)


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more