This is a multi-part message in MIME format.
------_=_NextPart_001_01C8B20D.ACEF228F
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Guillaume,
=20
Well I could shortly describe what's happen on these machines ;
=20
On May 7 2008 at 23:25 an operator performed :
_a configuration change ;
_add a new user on a table named MVNO;
Customer told us that for "new user" operator add comma "," symbol.
This is something new for their provisioning procedure (it's seems they =
never test it )thus as soon as they propagate this updated DB over =
machines of live net these started to discard all the requests and no =
more user was able to work or work properly .
=20
Now they asking us what's happen so this is the reason why I'm writing =
here .
=20
Unfortunately I tried to verify the backup db but the one interesting =
for us is empty :
=20
ls -l 200805*
-rw-r--r-- 1 root root 842840 mag 1 04:03 =
20080501-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 842840 mag 2 04:03 =
20080502-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 842840 mag 3 04:03 =
20080503-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 842840 mag 4 04:03 =
20080504-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 842540 mag 5 04:03 =
20080505-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 842613 mag 6 04:03 =
20080506-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 842613 mag 7 04:03 =
20080507-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 0 mag 8 04:03 =
20080508-0403-cfg_xxxxxxx.sql
-rw-r--r-- 1 root root 843960 mag 9 04:03 =
20080509-0403-cfg_xxxxxxx.sql
=20
=20
I'll try to find it but but even if I can't provide this back-up for =
company policies reason , could I ask you some feed-back to get =
suggestion to look for on this back-up file?
=20
Many thanx anyway for your help
=20
Best Regards
=20
Alessandro.
=20
=20
-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume@[EMAIL PROTECTED]
venerd=EC 9 maggio 2008 19:05
To: MARIOTTI, Alessandro (Alessandro)
Cc: pgsql-admin@[EMAIL PROTECTED]
Re: [ADMIN] debug issue on postgresql
=20
MARIOTTI, Alessandro (Alessandro) a =E9crit :
> I'm writing you to get some information regarding the possibility to =
get=20
> some information a db corruption got yesterday morning in a live =
platform .
>=20
> We realized DB Inconsistence and corruption and we tried to restore=20
> immediately the DB , via a back-up procedure, to restore services for=20
> customer.
>=20
> Now we need to investigate on DB what it was the route cause for db=20
> corruption.
>=20
=20
Do you have a backup of the corrupted database ? If you don't, it will=20
be extremely hard to tell you anything interesting.
=20
And you need to tell us what kind of issue you have, which release you=20
use, etc.
=20
> Unfortunately we don't have any experience with postgres db because =
the=20
> platform had improved by a colleague that left company and no one got=20
> the op****tunity to learn something .....
>=20
> Some do***entation to start with postgres will be appreciate .
>=20
=20
http://www.postgresql.org/docs/
and then choose the manual related to=20
your PostgreSQL release.
=20
Regards.
=20
=20
--=20
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
------_=_NextPart_001_01C8B20D.ACEF228F
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
@[EMAIL PROTECTED]
Section1
{size:612.0pt 792.0pt;
margin:72.0pt 77.95pt 72.0pt 77.95pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Guillaume,<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Well I could shortly describe what's happen on these machines =
;<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>On May 7 2008 at 23:25 an operator performed =
:<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>_a configuration change ;<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>_add a new user on a table named =
MVNO;<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Customer told us that for =A0“new user” operator add =
comma “,”
symbol.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>This is something new for their provisioning procedure =
(it’s
seems they never test it )thus as soon as they propagate this updated DB =
over machines
of live net these started to discard all the requests and no more user =
was able
to work or work properly .<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Now they asking us what’s happen so this is the reason why =
I’m
writing here .<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Unfortunately I tried to verify the backup db but the one =
interesting
for us is empty :<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>ls -l=A0 200805*<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842840 mag=A0 1 04:03
20080501-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842840 mag=A0 2 04:03
20080502-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842840 mag=A0 3 04:03
20080503-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842840 mag=A0 4 04:03
20080504-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842540 mag=A0 5 04:03
20080505-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842613 mag=A0 6 04:03
20080506-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
842613 mag=A0 7 04:03
20080507-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><b><font size=3D2 face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-weight:bold'>-rw-r--r--=A0=A0=A0 1 =
root=A0=A0=A0=A0
root=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0 mag=A0 8 04:03 =
20080508-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></b></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-rw-r--r--=A0=A0=A0 1 root=A0=A0=A0=A0 root=A0=A0=A0=A0=A0=A0 =
843960 mag=A0 9 04:03
20080509-0403-cfg_xxxxxxx.sql<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>I‘ll try to find it but but even if I can’t provide =
this
back-up for company policies reason , could I ask you some feed-back to =
get suggestion
to look for on this back-up file?<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Many thanx anyway for your help<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Best Regards<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Alessandro.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>=A0=A0<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-----Original Message-----<br>
From: Guillaume Lelarge [mailto:guillaume@[EMAIL PROTECTED]
<br>
Sent: venerd=EC 9 maggio 2008 19:05<br>
To: MARIOTTI, Alessandro (Alessandro)<br>
Cc: <st1:PersonName =
w:st=3D"on">pgsql-admin@[EMAIL PROTECTED]
><br>
Subject: Re: [ADMIN] debug issue on postgresql</span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>MARIOTTI, Alessandro (Alessandro) a =E9crit =
:<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> I’m writing you to get some information regarding the
possibility to get <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> some information a db corruption got yesterday morning in a =
live
platform .<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> We realized DB Inconsistence and corruption and we tried to
restore <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> immediately the DB , via a back-up procedure, to restore =
services
for <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> customer.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> Now we need to investigate on DB what it was the route =
cause for
db <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> corruption.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Do you have a backup of the corrupted database ? If you don't, =
it will <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>be extremely hard to tell you anything =
interesting.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>And you need to tell us what kind of issue you have, which =
release you <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>use, etc.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> Unfortunately we don’t have any experience with =
postgres db
because the <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> platform had improved by a colleague that left company and =
no one
got <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> the op****tunity to learn something =
…..<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> Some do***entation to start with postgres will be =
appreciate .<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>http://www.postgresql.org/docs/
and then choose the manual =
related to <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>your PostgreSQL release.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Regards.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-- <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Guillaume.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>=A0 http://www.postgresqlfr.org<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>=A0 http://dalibo.com<o:p></o:p></span></font></p>
</div>
</body>
</html>
------_=_NextPart_001_01C8B20D.ACEF228F--
|
