LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 10-16-2018, 10:05 PM   #1
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Rep: Reputation: 105Reputation: 105
sqlite data on NFS stop working after upgrade ??


Hya,

Set up
Debian testing, (buster amd64) bibus, using sqlite, database file on NFS dirve.

Situation
After dist-upgrade, bibus stopped working. It looks like that an error is locked database, according to sqlitebrowser.

Troubleshooting
This thread says some trouble with database file on NFS drive. I tried renaming and several tricks, without success. No other processes use same database file. lsof and fuser fails to detect any clue.
Whole system reboot and fsck did not solve situation.
I found that item #5 of this thread and this one say that some trouble with locking process.

I guess if I am on a right track, it is far beyond of whatever I can do. Log files say that many python files are updated, but neither nfs nor kernel related ones. (bibus is a python2 application.)

For the time being, I can move database file to local drive, although for data security reason, it is not feasible.

Question
Has anybody ever run into similar situation? Is there any other workaround?

Closing remark
Thank you in advance
 
Old 10-18-2018, 07:26 PM   #2
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
Hya

I also found that libreoffice files on nfs are also affected. App says that "Document file @#.od? is locked for editing by Unknown user"

There is no .lock file and so far all of od? files on nfs drive are affected. Once file is copied to local drive, it can be edited. I found bug #884284, but it does not look related.

I will update.

cheers

++ added
I recompiled kernel (4.18.10-rt5), but did not solve. System is up-to-date as of 19/Oct.
Following applications can edit files on nfs drive. - pycharm, vi, gimp

Last edited by kaz2100; 10-18-2018 at 11:05 PM. Reason: update info
 
Old 11-10-2018, 04:05 AM   #3
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
Hya

update: (nfs is v3)

Still in troubleshooting.
With some other nfs server, no trouble.
Kernel option about nfsv3 ACL protocol extension is NOT related.

Found error log!
/var/log says
server kernel: lockd: cannot monitor client <- this line shows up when libreoffice chokes

Related web pages: 78004 emanugrum 23373

Still I have not found solution yet.

cheers
 
Old 11-18-2018, 11:48 PM   #4
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
Hya

Update:

I am not sure whether this is related, but on NON working nfs server node,
Code:
# ps -ef | grep rpcbind
_rpc       389     1  0 17:02 ?        00:00:00 /sbin/rpcbind -f -w
The user '_rpc' is running rpcbind.

Neither re-configure nor re-install of rpcbind package works.

+++ added on edit
Probably, the info above is irrelevant. It is a new feature introduced recently.

cheers

Last edited by kaz2100; 11-19-2018 at 12:00 AM.
 
Old 11-19-2018, 03:46 AM   #5
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
Hya,

I guess my previous post (#4) is totally off track.

Now, I know that
/proc/sys/sunrpc is missing on nfs server. (rpcbind is running!)
/proc/sys/sunrpc exists on nfs client.
recent upgrade of rpcbind (0.2.3-0.6 -> 1.2.5-0.3) is NOT related.

Debugging info on client says that "lockd: server returns status 2"

Currently, I cannot go further, because I cannot set debug info on server. (This info does not help.)

With the working nfs server, it is possible to set debug info. For some obvious reason, no error (on both client and server).

cheers

++ added
CONFIG_SRNRPC_DEBUG needs to be on to get /proc/sys/sunrpc

However, still problem persists. Problematic log (/var/log/messages) is
Code:
kernel: lockd: NSM upcall RPC failed, status=-5

Last edited by kaz2100; 11-19-2018 at 07:44 PM. Reason: ++ added
 
Old 11-20-2018, 01:51 AM   #6
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
Hya

correction.

Probably recent upgrade of rpcbind IS related. (post #5 is incorrect)

When I posted #5, I only rebooted nfs host. (host was upgraded and rebooted. client was 0.2.3-0.6)
After reboot (or whatever reason), all nfs hosts (1.2.5-0.3) are dead, regardless of client version.

cheers

+ added
Same error happens with sqlite3.
Is this a bug?

Last edited by kaz2100; 11-20-2018 at 02:11 AM.
 
Old 02-20-2019, 08:35 PM   #7
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
Hya,

Update

Recent dist-upgrade (plus new kernel) did not solve this situation.

Found this thread., and followed post #1.
Code:
rpc.statd -Fd
on nfs host node works!! For some unknown reason, rpc.statd does not kick in.

I am not sure if this is same nature as bug #805167

Not solved, but one step ahead.

cheers

Last edited by kaz2100; 02-20-2019 at 08:35 PM. Reason: typo
 
Old 02-27-2019, 11:03 PM   #8
kaz2100
Senior Member
 
Registered: Apr 2005
Location: Penguin land, with apple, no gates
Distribution: SlackWare > Debian testing woody(32) sarge etch lenny squeeze(+64) wheezy jessie stretch buster
Posts: 1,675

Original Poster
Rep: Reputation: 105Reputation: 105
It looks like that some rule was overwritten on system upgrade.

Solution may be in this thread.

cheers
 
  


Reply

Tags
lock, nfs, python2, sqlite


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ssh stop working after upgrade to F27 (Solved) ov10fac Linux - Desktop 2 12-10-2017 11:46 AM
[SOLVED] sbotools stop working after last upgrade to -current pasquall Slackware 7 11-27-2015 07:18 PM
[SOLVED] Keyboard and mouse stop working in x after upgrade to current damgar Slackware 2 05-27-2012 12:07 PM
[SOLVED] fn-Keys (fn-F10 thru fn-F12) on notebook stop working after kernel upgrade JokeDude Linux - Kernel 25 05-27-2010 12:44 AM
touchpad stop working after kernel upgrade novice26 Slackware 3 04-11-2005 04:40 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 05:08 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration