Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
TIA
--
Jord Tanner <jo**@indygecko .com>
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
8  1535 
On Wed, 21 Apr 2004, Jord Tanner wrote:
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
On Wed, 21 Apr 2004, Jord Tanner wrote:
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
We are exploring the possibility of hardware problems, and have found
some issues with the LSILogic Megaraid driver running in 64bit (this is
a dual Opteron running Gentoo AMD64).
Thanks for the feedback. I'm just covering all the bases.
Jord Tanner
On Wed, 2004-04-21 at 12:59, scott.marlowe wrote: On Wed, 21 Apr 2004, Jord Tanner wrote:
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
Jord Tanner <jo**@indygecko .com>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
We are exploring the possibility of hardware problems, and have found
some issues with the LSILogic Megaraid driver running in 64bit (this is
a dual Opteron running Gentoo AMD64).
Thanks for the feedback. I'm just covering all the bases.
Jord Tanner
On Wed, 2004-04-21 at 12:59, scott.marlowe wrote: On Wed, 21 Apr 2004, Jord Tanner wrote:
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
Jord Tanner <jo**@indygecko .com>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
Are you running the megaraid 2 driver or the older 1.18 series? Just
wondering.
On Wed, 21 Apr 2004, Jord Tanner wrote:
We are exploring the possibility of hardware problems, and have found
some issues with the LSILogic Megaraid driver running in 64bit (this is
a dual Opteron running Gentoo AMD64).
Thanks for the feedback. I'm just covering all the bases.
Jord Tanner
On Wed, 2004-04-21 at 12:59, scott.marlowe wrote: On Wed, 21 Apr 2004, Jord Tanner wrote:
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Are you running the megaraid 2 driver or the older 1.18 series? Just
wondering.
On Wed, 21 Apr 2004, Jord Tanner wrote:
We are exploring the possibility of hardware problems, and have found
some issues with the LSILogic Megaraid driver running in 64bit (this is
a dual Opteron running Gentoo AMD64).
Thanks for the feedback. I'm just covering all the bases.
Jord Tanner
On Wed, 2004-04-21 at 12:59, scott.marlowe wrote: On Wed, 21 Apr 2004, Jord Tanner wrote:
Greetings,
Does anyone know what the effect of sending an INT signal (kill -2) to
each of:
- pg backend
- psql running an insert or select into
- Perl script with DBI connection to pg, running insert or
select into
- vacuumdb
I'm getting some database corruption, and I'm wondering if the use of
'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Wed, 2004-04-21 at 15:19, scott.marlowe wrote: Are you running the megaraid 2 driver or the older 1.18 series? Just
wondering.
We started with the megaraid driver distributed with 2.6.3, which is
megaraid v2.00.3. With that driver we weren't able to insert more than 5
million row before corruption appeared. After upgrading to megaraid
v2.20.B2 and 2.6.5 things ran much better, but we are still able to get
the occational DB corruption, though we now have one table with 27
million rows which is working correctly, however, another smaller table
is still problematic. We were running XFS on LVM2 on linux RAID0 on
megaraid RAID1. I switched to JFS, and we are continuing to test.
I'm fairly confident that the problem is the bleeding edge 64bit compile
we are running, and not an underlying hardware problem, but I have to
look at everything.
On Wed, 21 Apr 2004, Jord Tanner wrote:
We are exploring the possibility of hardware problems, and have found
some issues with the LSILogic Megaraid driver running in 64bit (this is
a dual Opteron running Gentoo AMD64).
Thanks for the feedback. I'm just covering all the bases.
Jord Tanner
On Wed, 2004-04-21 at 12:59, scott.marlowe wrote: On Wed, 21 Apr 2004, Jord Tanner wrote:
>
> Greetings,
>
> Does anyone know what the effect of sending an INT signal (kill -2) to
> each of:
> - pg backend
> - psql running an insert or select into
> - Perl script with DBI connection to pg, running insert or
> select into
> - vacuumdb
>
> I'm getting some database corruption, and I'm wondering if the use of
> 'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
Jord Tanner <jo**@indygecko .com>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
On Wed, 2004-04-21 at 15:19, scott.marlowe wrote: Are you running the megaraid 2 driver or the older 1.18 series? Just
wondering.
We started with the megaraid driver distributed with 2.6.3, which is
megaraid v2.00.3. With that driver we weren't able to insert more than 5
million row before corruption appeared. After upgrading to megaraid
v2.20.B2 and 2.6.5 things ran much better, but we are still able to get
the occational DB corruption, though we now have one table with 27
million rows which is working correctly, however, another smaller table
is still problematic. We were running XFS on LVM2 on linux RAID0 on
megaraid RAID1. I switched to JFS, and we are continuing to test.
I'm fairly confident that the problem is the bleeding edge 64bit compile
we are running, and not an underlying hardware problem, but I have to
look at everything.
On Wed, 21 Apr 2004, Jord Tanner wrote:
We are exploring the possibility of hardware problems, and have found
some issues with the LSILogic Megaraid driver running in 64bit (this is
a dual Opteron running Gentoo AMD64).
Thanks for the feedback. I'm just covering all the bases.
Jord Tanner
On Wed, 2004-04-21 at 12:59, scott.marlowe wrote: On Wed, 21 Apr 2004, Jord Tanner wrote:
>
> Greetings,
>
> Does anyone know what the effect of sending an INT signal (kill -2) to
> each of:
> - pg backend
> - psql running an insert or select into
> - Perl script with DBI connection to pg, running insert or
> select into
> - vacuumdb
>
> I'm getting some database corruption, and I'm wondering if the use of
> 'kill -2' could be the cause.
No, kill -2 should not cause corruption.
About once a month we get someone on the lists getting corruption. almost
every time it's either a bad hard drive, memory, or system/cpu/mobo
causing it. Have you tested your memory (memtest86) or drives (badblocks
on linux) to make sure they aren't the cause of your problem? Just
because a server is new doesn't mean it's free of all flaws.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
Jord Tanner <jo**@indygecko .com>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bob Swerdlow |
last post by:
My application starts up a number of processes for various purposes using:
self.popen = popen2.Popen3("/usr/local/bin/python -O "myscript.py")
and then shuts them down when appropriate with
os.kill(self.popen.pid, signal.SIGTERM)
Everything works fine on MacOSX. However, I'm doing a port to Solaris (so I
can run it on my web site) and find that the child processes are not
stopping! Solaris is creating TWO new processes: one for the SHELL...
|
by: Alex Hunsley |
last post by:
I'm running a monitoring script under linux written in python. It's nohup'ed so
that I can log out and it will continue running happily and so on, but
sometimes I need to kill the script before editing the source and relaunching it.
Question is, what's the nicest way to kill the python process under linux? Is a
simple 'kill ' the nicest way to do it, or is there a different
signal I should send it?
ta
alex
|
by: Vilmar Brazão de Oliveira |
last post by:
HI people,
what is wrong in the code bellow to kill iexplore.exe process after
processing my page??
'»»Before comes routines to access data base and to send email.
Set objWshell = Server.CreateObject("WScript.Shell")
objWshell.Run "%COMSPEC% /C kill iexplore.exe", 0, TRUE
VILMAR
BRAZIL
|
by: Fred |
last post by:
There is a setting in INIT.ORA that has the unintended side-effect of
making sure the ALTER SYSTEM KILL SESSION command has immediate affect.
Without this setting, I've seen some instances where the session reports
as being KILLED in V$SESSION but is not physically removed until the
instance is bounced. Does anyone remember this value offhand?
|
by: Micky |
last post by:
Can any one give me some pointers on how to kill a running procedure
in DB2? I have a long running procedure called from a Java routine and
after I kill the Java routine, the procedure keeps running and the
only way to kill this procedure is to restart the DB2 instance.
Any pointers would be helpful.
_Micky
| | |
by: Alexander N. Spitzer |
last post by:
I am trying to write a program that will fork a process, and execute the
given task... the catch is that if it runs too long, I want to clean it up.
this seemed pretty straight forward with a single executable being run
from the fork. The problem I am having now is that if I call a shell
scripts, then lets say calls "xterm &", after the timeout has occurred,
I kill the shell script, but the xterm is still running... I cannot seem
to kill...
|
by: WATYF |
last post by:
This is my problem... I have some code that starts a Process and
returns it to a variable... (prcBat)
At any time while that process is running... I want to be able to Kill
it by pressing a command button in the application.
So the code goes something like this:
psiBat = New ProcessStartInfo(arrRun.Item(0)(1))
psiBat.WindowStyle = ProcessWindowStyle.Hidden
|
by: elrondrules |
last post by:
Hi
Am new to python and need your help!!
this is my code snip.
within my python script I have the following commands..
<snip>
import os
|
by: Richard Rossel |
last post by:
Hi Fellows,
I have a problem with process termination. I have a python code that
apache runs through a django interface.
The code is very simple, first, it creates a process with the
subprocess.Popen call, and afterwards, (using a web request) the
python code uses the PID of the previously created process(stored in a
db) and kills it with an os.kill call using the SIGKILL signal.
The creation of the process is ok, apache calls the...
|
by: spectrumdt |
last post by:
Hello.
I am running Fedora Linux and KDE, using the Konsole command line.
When coding Python, I regularly make a bug causing my program to not
terminate. But how do I kill the non-terminating Python interpreter
without killing the entire Konsole?
The default way of killing the current process on the command line is
Ctrl+C, but that doesn't work with Python. Neither do the "terminate
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
