MARIOTTI, Alessandro (Alessandro) a écrit :
Well I could shortly describe what's happen on these machines ;
On May 7 2008 at 23:25 an operator performed :
_a configuration change ;
_add a new user on a table named MVNO;
None of these could have caused a corruption.
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 .
Now they asking us what’s happen so this is the reason why I’m writing
here .
You'll need more info if you want to find out what happened.
Unfortunately I tried to verify the backup db but the one interesting
for us is empty :
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
You don't a SQL backup, these won't help you. You need a backup of the
database after the corruption.
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?
Nope. You didn't give us enough information to at least get started.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
