* Sometimes all the applications using sqlite do not work correctly
@ 2016-04-06 23:09 YuGiOhJCJ Mailing-List
2016-04-07 18:14 ` J. Bruce Fields
0 siblings, 1 reply; 7+ messages in thread
From: YuGiOhJCJ Mailing-List @ 2016-04-06 23:09 UTC (permalink / raw)
To: linux-nfs
Hello,
I am using nfs-utils-1.2.8 and sqlite-3.7.17 on Slackware 14.1.
Sometimes, all the applications using sqlite do not work correctly.
These applications are:
* mozilla-firefox-44.0
* mumble-1.2.8
* xmoto-0.5.11
On mozilla-firefox, my bookmarks menu is empty.
On mumble, my favorite server list is empty.
On xmoto, the game could not run.
All these applications at the same time do not work and I need to restart the NFS server in order to be able to use these programs.
I don't know what could be the cause but I know that I have recently upgraded a lot of programs on my operating system (binutils-2.26, gcc-5.3.0, ...).
I am using NFS since many years (at least 4) and I have never get troubles with my applications using sqlite.
So, I am wondering what happens.
Should I rebuild nfs-utils?
Thank you.
Best regards.
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Sometimes all the applications using sqlite do not work correctly
2016-04-06 23:09 Sometimes all the applications using sqlite do not work correctly YuGiOhJCJ Mailing-List
@ 2016-04-07 18:14 ` J. Bruce Fields
2016-04-07 22:48 ` YuGiOhJCJ Mailing-List
0 siblings, 1 reply; 7+ messages in thread
From: J. Bruce Fields @ 2016-04-07 18:14 UTC (permalink / raw)
To: YuGiOhJCJ Mailing-List; +Cc: linux-nfs
On Thu, Apr 07, 2016 at 01:09:27AM +0200, YuGiOhJCJ Mailing-List wrote:
> Hello,
>
> I am using nfs-utils-1.2.8 and sqlite-3.7.17 on Slackware 14.1.
> Sometimes, all the applications using sqlite do not work correctly.
>
> These applications are:
> * mozilla-firefox-44.0
> * mumble-1.2.8
> * xmoto-0.5.11
>
> On mozilla-firefox, my bookmarks menu is empty.
> On mumble, my favorite server list is empty.
> On xmoto, the game could not run.
>
> All these applications at the same time do not work and I need to restart the NFS server in order to be able to use these programs.
So when the problem happens, restarting the server fixes the problem?
> I don't know what could be the cause but I know that I have recently upgraded a lot of programs on my operating system (binutils-2.26, gcc-5.3.0, ...).
It's probably the kernel version that's most important. So it might be
interesting to know what your kernel version was before and what it is
now.
Also: what's your NFS server? Was it upgraded at the same time, or was
only your client upgraded?
--b.
> I am using NFS since many years (at least 4) and I have never get troubles with my applications using sqlite.
>
> So, I am wondering what happens.
>
> Should I rebuild nfs-utils?
>
> Thank you.
> Best regards.
> --
> To unsubscribe from this list: send the line "unsubscribe linux-nfs" in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at http://vger.kernel.org/majordomo-info.html
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Sometimes all the applications using sqlite do not work correctly
2016-04-07 18:14 ` J. Bruce Fields
@ 2016-04-07 22:48 ` YuGiOhJCJ Mailing-List
2016-04-11 19:09 ` YuGiOhJCJ Mailing-List
0 siblings, 1 reply; 7+ messages in thread
From: YuGiOhJCJ Mailing-List @ 2016-04-07 22:48 UTC (permalink / raw)
To: J. Bruce Fields; +Cc: linux-nfs
> So when the problem happens, restarting the server fixes the problem?
Indeed, that's it.
> It's probably the kernel version that's most important. So it might be
> interesting to know what your kernel version was before and what it is
> now.
My Linux kernel was 3.18.20 before and is still 3.18.20 now.
I have not changed of kernel since the problem happens.
> Also: what's your NFS server? Was it upgraded at the same time, or was
> only your client upgraded?
I have not upgraded the server and not upgraded the client.
They are still the same: nfs-utils-1.2.8.
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Sometimes all the applications using sqlite do not work correctly
2016-04-07 22:48 ` YuGiOhJCJ Mailing-List
@ 2016-04-11 19:09 ` YuGiOhJCJ Mailing-List
2016-04-13 17:44 ` J. Bruce Fields
0 siblings, 1 reply; 7+ messages in thread
From: YuGiOhJCJ Mailing-List @ 2016-04-11 19:09 UTC (permalink / raw)
To: YuGiOhJCJ Mailing-List; +Cc: linux-nfs
On Fri, 8 Apr 2016 00:48:39 +0200
YuGiOhJCJ Mailing-List <yugiohjcj-mailinglist@laposte.net> wrote:
> > So when the problem happens, restarting the server fixes the problem?
>
> Indeed, that's it.
>
> > It's probably the kernel version that's most important. So it might be
> > interesting to know what your kernel version was before and what it is
> > now.
>
> My Linux kernel was 3.18.20 before and is still 3.18.20 now.
> I have not changed of kernel since the problem happens.
>
> > Also: what's your NFS server? Was it upgraded at the same time, or was
> > only your client upgraded?
>
> I have not upgraded the server and not upgraded the client.
> They are still the same: nfs-utils-1.2.8.
It happened again today.
Output on mumble:
$ mumble
CELT bitstream 8000000b from libcelt0.so.0.7.0
CELT bitstream 80000010 from libcelt0.so.0.11.0
Locale is "en_US" (System: "en_US")
TextToSpeech: Compiled without support for speech-dispatcher
SQL Query failed "CREATE TABLE IF NOT EXISTS `servers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT, `hostname` TEXT, `port` INTEGER DEFAULT 64738, `username` TEXT, `password` TEXT)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `comments` (`who` TEXT, `comment` BLOB, `seen` DATE)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `comments_comment` ON `comments`(`who`, `comment`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE INDEX IF NOT EXISTS `comments_seen` ON `comments`(`seen`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `blobs` (`hash` TEXT, `data` BLOB, `seen` DATE)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `blobs_hash` ON `blobs`(`hash`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE INDEX IF NOT EXISTS `blobs_seen` ON `blobs`(`seen`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `tokens` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `digest` BLOB, `token` TEXT)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE INDEX IF NOT EXISTS `tokens_host_port` ON `tokens`(`digest`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `shortcut` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `digest` BLOB, `shortcut` BLOB, `target` BLOB, `suppress` INTEGER)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE INDEX IF NOT EXISTS `shortcut_host_port` ON `shortcut`(`digest`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `udp` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `digest` BLOB)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `udp_host_port` ON `udp`(`digest`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `cert` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `hostname` TEXT, `port` INTEGER, `digest` TEXT)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `cert_host_port` ON `cert`(`hostname`,`port`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `friends` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT, `hash` TEXT)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `friends_name` ON `friends`(`name`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `friends_hash` ON `friends`(`hash`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `ignored` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `hash` TEXT)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `ignored_hash` ON `ignored`(`hash`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `muted` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `hash` TEXT)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `muted_hash` ON `muted`(`hash`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE TABLE IF NOT EXISTS `pingcache` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `hostname` TEXT, `port` INTEGER, `ping` INTEGER)"
-1 "database is locked Unable to execute statement"
SQL Query failed "CREATE UNIQUE INDEX IF NOT EXISTS `pingcache_host_port` ON `pingcache`(`hostname`,`port`)"
-1 "database is locked Unable to execute statement"
SQL Query failed "DELETE FROM `comments` WHERE `seen` < datetime('now', '-1 years')"
-1 "database is locked Unable to execute statement"
SQL Query failed "DELETE FROM `blobs` WHERE `seen` < datetime('now', '-1 months')"
-1 "database is locked Unable to execute statement"
SQL Query failed "VACUUM"
-1 "database is locked Unable to fetch row"
SQL Query failed "PRAGMA synchronous = OFF"
-1 "database is locked Unable to execute statement"
SQL Query failed "PRAGMA journal_mode = TRUNCATE"
-1 "database is locked Unable to execute statement"
Database SQLite: "3.7.17"
Overlay: Listening on "/home/yugiohjcj/.MumbleOverlayPipe"
GlobalShortcutX: /dev/input/event0: Speakup
GlobalShortcutX: /dev/input/event12: Eee PC WMI hotkeys
GlobalShortcutX: /dev/input/event13: Microsoft X-Box 360 pad
GlobalShortcutX: /dev/input/event14: Logitech USB Optical Mouse
GlobalShortcutX: /dev/input/event15: LITEON Technology USB Keyboard
GlobalShortcutX: /dev/input/event6: Power Button
GlobalShortcutX: /dev/input/event7: Power Button
AudioInput: 40000 bits/s, 48000 hz, 480 sample
ALSAAudioOutput: Initialized
ALSAAudioInput: Initing audiocapture default.
lock: No locks available
ALSAAudioInput: Actual buffer 48000 hz, 1 channel 3840 samples [480 per period]
AudioInput: Initialized mixer for 1 channel 48000 hz mic and 0 channel 48000 hz echo
warning: The VAD has been replaced by a hack pending a complete rewrite
lock: No locks available
ALSAAudioOutput: ALSA reports 32 output channels. Clamping to 2.
ALSAAudioOutput: Actual buffer 48000 hz, 2 channel 2881 samples [480 per period]
ALSAAudioOutput: Initializing 2 channel, 48000 hz mixer
AudioOutput: Initialized 2 channel 48000 hz mixer
SQL Query failed "SELECT `name`, `hostname`, `port`, `username`, `password`, `url` FROM `servers` ORDER BY `name`"
-1 "No query Unable to fetch row"
OSInfo: Failed to execute lsb_release
SQL Query failed "SELECT `hostname`, `port`, `ping` FROM `pingcache`"
-1 "No query Unable to fetch row"
SQL Query failed "DELETE FROM `servers`"
-1 "No query Unable to fetch row"
SQL Query failed "DELETE FROM `pingcache`"
-1 "No query Unable to fetch row"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
SQL Query failed "REPLACE INTO `pingcache` (`hostname`, `port`, `ping`) VALUES (?,?,?)"
-1 " Parameter count mismatch"
ALSAAudioInput: Releasing ALSA Mic.
ALSAAudioOutput: Destroyed
SQL Query failed "PRAGMA journal_mode = DELETE"
-1 "database is locked Unable to execute statement"
SQL Query failed "VACUUM"
-1 "database is locked Unable to fetch row"
Output on xmoto:
$ xmoto
fatal exception : xmDb: database is locked
No Output on firefox but I am unable to show bookmarks which means that there is a problem to access the sqlite database.
I have just restarted the NFS server like that:
$ bash /etc/rc.d/rc.nfsd restart
And the client works now perfectly again with applications using sqlite.
So I guess that there is a problem with the NFS server (not the client).
Is there something I could check like processes running on the server when the problem happens?
What information could be useful to understand what happens when I get the problem?
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Sometimes all the applications using sqlite do not work correctly
2016-04-11 19:09 ` YuGiOhJCJ Mailing-List
@ 2016-04-13 17:44 ` J. Bruce Fields
2016-04-14 4:14 ` YuGiOhJCJ Mailing-List
0 siblings, 1 reply; 7+ messages in thread
From: J. Bruce Fields @ 2016-04-13 17:44 UTC (permalink / raw)
To: YuGiOhJCJ Mailing-List; +Cc: linux-nfs
On Mon, Apr 11, 2016 at 09:09:39PM +0200, YuGiOhJCJ Mailing-List wrote:
> On Fri, 8 Apr 2016 00:48:39 +0200
> YuGiOhJCJ Mailing-List <yugiohjcj-mailinglist@laposte.net> wrote:
>
> > > So when the problem happens, restarting the server fixes the problem?
> >
> > Indeed, that's it.
> >
> > > It's probably the kernel version that's most important. So it might be
> > > interesting to know what your kernel version was before and what it is
> > > now.
> >
> > My Linux kernel was 3.18.20 before and is still 3.18.20 now.
> > I have not changed of kernel since the problem happens.
> >
> > > Also: what's your NFS server? Was it upgraded at the same time, or was
> > > only your client upgraded?
> >
> > I have not upgraded the server and not upgraded the client.
> > They are still the same: nfs-utils-1.2.8.
>
> It happened again today.
>
> Output on mumble:
> $ mumble
> CELT bitstream 8000000b from libcelt0.so.0.7.0
> CELT bitstream 80000010 from libcelt0.so.0.11.0
> Locale is "en_US" (System: "en_US")
> TextToSpeech: Compiled without support for speech-dispatcher
> SQL Query failed "CREATE TABLE IF NOT EXISTS `servers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT, `hostname` TEXT, `port` INTEGER DEFAULT 64738, `username` TEXT, `password` TEXT)"
...
> ALSAAudioInput: Releasing ALSA Mic.
> ALSAAudioOutput: Destroyed
> SQL Query failed "PRAGMA journal_mode = DELETE"
> -1 "database is locked Unable to execute statement"
> SQL Query failed "VACUUM"
> -1 "database is locked Unable to fetch row"
>
> Output on xmoto:
> $ xmoto
> fatal exception : xmDb: database is locked
>
> No Output on firefox but I am unable to show bookmarks which means that there is a problem to access the sqlite database.
>
> I have just restarted the NFS server like that:
> $ bash /etc/rc.d/rc.nfsd restart
>
> And the client works now perfectly again with applications using sqlite.
>
> So I guess that there is a problem with the NFS server (not the client).
> Is there something I could check like processes running on the server when the problem happens?
> What information could be useful to understand what happens when I get the problem?
Are there any warnings in the client or server's logs?
--b.
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Sometimes all the applications using sqlite do not work correctly
2016-04-13 17:44 ` J. Bruce Fields
@ 2016-04-14 4:14 ` YuGiOhJCJ Mailing-List
2016-04-14 12:47 ` J. Bruce Fields
0 siblings, 1 reply; 7+ messages in thread
From: YuGiOhJCJ Mailing-List @ 2016-04-14 4:14 UTC (permalink / raw)
To: J. Bruce Fields; +Cc: linux-nfs
On Wed, 13 Apr 2016 13:44:39 -0400
bfields@fieldses.org (J. Bruce Fields) wrote:
> On Mon, Apr 11, 2016 at 09:09:39PM +0200, YuGiOhJCJ Mailing-List wrote:
> > On Fri, 8 Apr 2016 00:48:39 +0200
> > YuGiOhJCJ Mailing-List <yugiohjcj-mailinglist@laposte.net> wrote:
> >
> > > > So when the problem happens, restarting the server fixes the problem?
> > >
> > > Indeed, that's it.
> > >
> > > > It's probably the kernel version that's most important. So it might be
> > > > interesting to know what your kernel version was before and what it is
> > > > now.
> > >
> > > My Linux kernel was 3.18.20 before and is still 3.18.20 now.
> > > I have not changed of kernel since the problem happens.
> > >
> > > > Also: what's your NFS server? Was it upgraded at the same time, or was
> > > > only your client upgraded?
> > >
> > > I have not upgraded the server and not upgraded the client.
> > > They are still the same: nfs-utils-1.2.8.
> >
> > It happened again today.
> >
> > Output on mumble:
> > $ mumble
> > CELT bitstream 8000000b from libcelt0.so.0.7.0
> > CELT bitstream 80000010 from libcelt0.so.0.11.0
> > Locale is "en_US" (System: "en_US")
> > TextToSpeech: Compiled without support for speech-dispatcher
> > SQL Query failed "CREATE TABLE IF NOT EXISTS `servers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT, `hostname` TEXT, `port` INTEGER DEFAULT 64738, `username` TEXT, `password` TEXT)"
> ...
> > ALSAAudioInput: Releasing ALSA Mic.
> > ALSAAudioOutput: Destroyed
> > SQL Query failed "PRAGMA journal_mode = DELETE"
> > -1 "database is locked Unable to execute statement"
> > SQL Query failed "VACUUM"
> > -1 "database is locked Unable to fetch row"
> >
> > Output on xmoto:
> > $ xmoto
> > fatal exception : xmDb: database is locked
> >
> > No Output on firefox but I am unable to show bookmarks which means that there is a problem to access the sqlite database.
> >
> > I have just restarted the NFS server like that:
> > $ bash /etc/rc.d/rc.nfsd restart
> >
> > And the client works now perfectly again with applications using sqlite.
> >
> > So I guess that there is a problem with the NFS server (not the client).
> > Is there something I could check like processes running on the server when the problem happens?
> > What information could be useful to understand what happens when I get the problem?
>
> Are there any warnings in the client or server's logs?
>
> --b.
I am not sure where all these logs are located.
I found the "/var/log/nfsd/" directory on the server but is is empty.
The script running the nfs server is here:
http://ftp.slackware.com/pub/slackware/slackware-14.1/source/n/nfs-utils/rc.nfsd
I see no options used for logs.
Reading the man of nfsd, I see these two options:
$ man nfsd
[...]
-d or --debug
enable logging of debugging messages
[...]
-s or --syslog
By default, rpc.nfsd logs error messages (and debug messages, if
enabled) to stderr. This option makes rpc.nfsd log these mes‐
sages to syslog instead. Note that errors encountered during
option processing will still be logged to stderr regardless of
this option.
[...]
I guess I should replace in the script this line:
/usr/sbin/rpc.nfsd 8
by this line:
/usr/sbin/rpc.nfsd -ds 8
in order to see logs from the server.
Is it correct?
About the client logs, I have no idea how to activate them.
Any idea?
I saw that my server root partition was full (usage: 100%).
I removed some useless files in the /tmp directory and now I am not full anymore (usage: 98%).
Does NFS need a write access on the server in order to work correctly?
In this case, that could be a reason of my problem.
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Sometimes all the applications using sqlite do not work correctly
2016-04-14 4:14 ` YuGiOhJCJ Mailing-List
@ 2016-04-14 12:47 ` J. Bruce Fields
0 siblings, 0 replies; 7+ messages in thread
From: J. Bruce Fields @ 2016-04-14 12:47 UTC (permalink / raw)
To: YuGiOhJCJ Mailing-List; +Cc: linux-nfs
On Thu, Apr 14, 2016 at 06:14:17AM +0200, YuGiOhJCJ Mailing-List wrote:
> On Wed, 13 Apr 2016 13:44:39 -0400
> bfields@fieldses.org (J. Bruce Fields) wrote:
>
> > On Mon, Apr 11, 2016 at 09:09:39PM +0200, YuGiOhJCJ Mailing-List wrote:
> > > On Fri, 8 Apr 2016 00:48:39 +0200
> > > YuGiOhJCJ Mailing-List <yugiohjcj-mailinglist@laposte.net> wrote:
> > >
> > > > > So when the problem happens, restarting the server fixes the problem?
> > > >
> > > > Indeed, that's it.
> > > >
> > > > > It's probably the kernel version that's most important. So it might be
> > > > > interesting to know what your kernel version was before and what it is
> > > > > now.
> > > >
> > > > My Linux kernel was 3.18.20 before and is still 3.18.20 now.
> > > > I have not changed of kernel since the problem happens.
> > > >
> > > > > Also: what's your NFS server? Was it upgraded at the same time, or was
> > > > > only your client upgraded?
> > > >
> > > > I have not upgraded the server and not upgraded the client.
> > > > They are still the same: nfs-utils-1.2.8.
> > >
> > > It happened again today.
> > >
> > > Output on mumble:
> > > $ mumble
> > > CELT bitstream 8000000b from libcelt0.so.0.7.0
> > > CELT bitstream 80000010 from libcelt0.so.0.11.0
> > > Locale is "en_US" (System: "en_US")
> > > TextToSpeech: Compiled without support for speech-dispatcher
> > > SQL Query failed "CREATE TABLE IF NOT EXISTS `servers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT, `hostname` TEXT, `port` INTEGER DEFAULT 64738, `username` TEXT, `password` TEXT)"
> > ...
> > > ALSAAudioInput: Releasing ALSA Mic.
> > > ALSAAudioOutput: Destroyed
> > > SQL Query failed "PRAGMA journal_mode = DELETE"
> > > -1 "database is locked Unable to execute statement"
> > > SQL Query failed "VACUUM"
> > > -1 "database is locked Unable to fetch row"
> > >
> > > Output on xmoto:
> > > $ xmoto
> > > fatal exception : xmDb: database is locked
> > >
> > > No Output on firefox but I am unable to show bookmarks which means that there is a problem to access the sqlite database.
> > >
> > > I have just restarted the NFS server like that:
> > > $ bash /etc/rc.d/rc.nfsd restart
> > >
> > > And the client works now perfectly again with applications using sqlite.
> > >
> > > So I guess that there is a problem with the NFS server (not the client).
> > > Is there something I could check like processes running on the server when the problem happens?
> > > What information could be useful to understand what happens when I get the problem?
> >
> > Are there any warnings in the client or server's logs?
> >
> > --b.
>
> I am not sure where all these logs are located.
The kernel logs are the most interesting. You can get them from
"dmesg", or they usually get dumped some place like /var/log/messages
depending on distro.
--b.
> I found the "/var/log/nfsd/" directory on the server but is is empty.
> The script running the nfs server is here:
> http://ftp.slackware.com/pub/slackware/slackware-14.1/source/n/nfs-utils/rc.nfsd
>
> I see no options used for logs.
>
> Reading the man of nfsd, I see these two options:
> $ man nfsd
> [...]
> -d or --debug
> enable logging of debugging messages
> [...]
> -s or --syslog
> By default, rpc.nfsd logs error messages (and debug messages, if
> enabled) to stderr. This option makes rpc.nfsd log these mes‐
> sages to syslog instead. Note that errors encountered during
> option processing will still be logged to stderr regardless of
> this option.
> [...]
>
> I guess I should replace in the script this line:
> /usr/sbin/rpc.nfsd 8
> by this line:
> /usr/sbin/rpc.nfsd -ds 8
> in order to see logs from the server.
>
> Is it correct?
>
> About the client logs, I have no idea how to activate them.
>
> Any idea?
>
> I saw that my server root partition was full (usage: 100%).
> I removed some useless files in the /tmp directory and now I am not full anymore (usage: 98%).
> Does NFS need a write access on the server in order to work correctly?
> In this case, that could be a reason of my problem.
^ permalink raw reply [flat|nested] 7+ messages in thread
end of thread, other threads:[~2016-04-14 12:47 UTC | newest]
Thread overview: 7+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2016-04-06 23:09 Sometimes all the applications using sqlite do not work correctly YuGiOhJCJ Mailing-List
2016-04-07 18:14 ` J. Bruce Fields
2016-04-07 22:48 ` YuGiOhJCJ Mailing-List
2016-04-11 19:09 ` YuGiOhJCJ Mailing-List
2016-04-13 17:44 ` J. Bruce Fields
2016-04-14 4:14 ` YuGiOhJCJ Mailing-List
2016-04-14 12:47 ` J. Bruce Fields
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.