Sometimes all the applications using sqlite do not work correctly

linux-nfs.vger.kernel.org archive mirror
 help / color / mirror / Atom feed

* 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 a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).