André Knappstein
2013-01-09 13:49:43 UTC
In case somebody's just reading by and has a clue, don't hold back :-)
For the first time since working with Firebird I'm probably about
losing data.
Here's what I did to successfully break my precious:
- shutdown -f while 1 one user who told he's not working was in fact
still working with the database
- starting a backup which was expected to run some 7 minutes
- terminated the process after some 30 minutes (no CPU usage of
gBak.exe for more than 20 minutes)
Now an ODBC connection test works fine.
Connecting via Jiri's .net provider times out (CPU 50% for 2++ minutes)
Connecting via IBExpert times out (CPU 50% for 2++ minutes)
gfix -v -n C:\Current.fdb
results in "unavailable database" (user&pw supplied...)
gfix -v -n localhost:C:\Current.fdb
results in a new child process fb_inet_server.exe at 50% for a short
time (~2 seconds), a new blank line in the command window.
gbak -b -v C:\Current.fdb C:\Current.fbk
results in "unavailable database"
gbak -b -v localhost:C:\Current.fdb C:\Current.fbk
a new process gbak.exe with constantly 0%, a new file "C:\Current.fbk"
with 0 bytes, a new child process fb_inet_server.exe at 50% for a
loooooong time, some update to the database, because c:\current.fdb
gets a new file-timestamp.
ouput says:
"readied database... "
"creating file ... "
"starting transaction"
nothing more happens.
How would I best go about trying to fix this?
I have a good backup which is 4 hours old. There are worse things in
the world than having to revert back to that, but if possible I'd try
to restore this one.
FB 1.5 Classic Server on W2K3
TIA André
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
For the first time since working with Firebird I'm probably about
losing data.
Here's what I did to successfully break my precious:
- shutdown -f while 1 one user who told he's not working was in fact
still working with the database
- starting a backup which was expected to run some 7 minutes
- terminated the process after some 30 minutes (no CPU usage of
gBak.exe for more than 20 minutes)
Now an ODBC connection test works fine.
Connecting via Jiri's .net provider times out (CPU 50% for 2++ minutes)
Connecting via IBExpert times out (CPU 50% for 2++ minutes)
From 6 databases on that server, only 1 is making trouble.
I made a file copy of the offending file to C:\Current.fdb.gfix -v -n C:\Current.fdb
results in "unavailable database" (user&pw supplied...)
gfix -v -n localhost:C:\Current.fdb
results in a new child process fb_inet_server.exe at 50% for a short
time (~2 seconds), a new blank line in the command window.
gbak -b -v C:\Current.fdb C:\Current.fbk
results in "unavailable database"
gbak -b -v localhost:C:\Current.fdb C:\Current.fbk
a new process gbak.exe with constantly 0%, a new file "C:\Current.fbk"
with 0 bytes, a new child process fb_inet_server.exe at 50% for a
loooooong time, some update to the database, because c:\current.fdb
gets a new file-timestamp.
ouput says:
"readied database... "
"creating file ... "
"starting transaction"
nothing more happens.
How would I best go about trying to fix this?
I have a good backup which is 4 hours old. There are worse things in
the world than having to revert back to that, but if possible I'd try
to restore this one.
FB 1.5 Classic Server on W2K3
TIA André
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/