Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Server    [ Add a report in this area ]  
Report #:  106371   Status: Closed
Interbase crash updating metadata, database totally corrupted
Project:  InterBase Build #:  10.0.4.590
Version:    10.0 Submitted By:   Jesus Garcia
Report Type:  Crash / Data loss / Total failure Date Reported:  6/13/2012 12:23:25 AM
Severity:    Critical / Show Stopper Last Updated: 4/1/2014 9:44:05 PM
Platform:    Windows 95/98/NT 4.0 on Intel Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : XE3 Update4
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
COINTEC04 (Server)      Tue Jun 05 08:57:23 2012
            Server: version 10.0.4.590 (32-bit), ibconfig settings...
                           SWEEP_QUANTUM to 250, USER_QUANTUM to 1000,
                           SWEEP_YIELD_TIME to 1 ms, and MAX_THREADS to 1000000
                           SQL_COMPILER_RECURSION to 2000


COINTEC04 (Client)       Tue Jun 05 08:57:24 2012
            Guardian starting: C:\Embarcadero\InterBase\bin\ibserver.exe


COINTEC04 (Server)      Tue Jun 05 21:36:13 2012
            Database: T:\GESTLABBD\GESTLAB.GLDB
            database file appears corrupt ()
            wrong page type
            page 96 is of wrong type (expected 5, found -103)

COINTEC04 (Server)      Tue Jun 05 21:36:13 2012
            Metadata scan (1) for relation CTRL_CALIDAD failed

COINTEC04 (Server)      Tue Jun 05 21:36:13 2012
            Database: T:\GESTLABBD\GESTLAB.GLDB
            database file appears corrupt ()
            wrong page type
            page 96 is of wrong type (expected 5, found -103)

COINTEC04 (Server)      Tue Jun 05 21:36:13 2012
            process_packet() servicing opcode=63
            Access violation.
                        The code attempted to access a virtual
                        address without privilege to do so.
            This exception will cause the InterBase server
            to terminate abnormally.

COINTEC04 (Client)       Tue Jun 05 21:36:13 2012
            REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
            Uncommitted work may have been lost

COINTEC04 (Client)       Tue Jun 05 21:36:14 2012
            C:\Embarcadero\InterBase\bin\ibserver.exe: terminated abnormally (-1)


COINTEC04 (Server)      Tue Jun 05 21:36:15 2012
            Server: version 10.0.4.590 (32-bit), ibconfig settings...
                           SWEEP_QUANTUM to 250, USER_QUANTUM to 1000,
                           SWEEP_YIELD_TIME to 1 ms, and MAX_THREADS to 1000000
                           SQL_COMPILER_RECURSION to 2000


COINTEC04 (Client)       Tue Jun 05 21:36:16 2012
            Guardian starting: C:\Embarcadero\InterBase\bin\ibserver.exe

Un saludo
Steps to Reproduce:
While updating metadata to one database for testing interbase has crashed. After that the database is unusable. We have tested it with the latest build.

With Interbase 2009, no crash and no failure, applying the same scripts.

I hope this errors are solved in the latest build, but still there.-


Note:

One interesting thing, We applied to the database a set of 200 scripts. The process, load an script, connect to database, execute and disconnect the database, and then execute the next script, etc.. We had the error in script 100, for example.

After that we executed the sbatch of scripts again, but this time we executed 90 scripts, wait some seconds, and executed the other ones. This time no error has raised.
Workarounds
None
Attachment
None
Comments

Tomohiro Takahashi at 6/13/2012 7:46:38 PM -
Could you please contact technical support service?
http://support.embarcadero.com/

Jesus Garcia at 6/14/2012 12:17:32 AM -
Thank you for your response as allways, i don't need technical support, what need technical support is Interbase XE. I do not use Interbase XE and i don't know if i will use it, because, from my point of view, is the version less stable i have never work with.

If the development team needs that I help them to solve the problem, then contact me, else the bug is there and is the worse bug one database server can have, because after that, the database is unusable, i have to put it in the trash.

Jesus Garcia at 6/14/2012 12:20:43 AM -
We have repeated the test, with the same result, but now Ibterbase creates a page type 99. The error raises this time when compiling a trigger for one table called LISTA_TRABAJO_VINCULO:

COINTEC04 (Server)      Wed Jun 13 09:04:54 2012
            Server: version 10.0.4.590 (32-bit), ibconfig settings...
                           SWEEP_QUANTUM to 250, USER_QUANTUM to 1000,
                           SWEEP_YIELD_TIME to 1 ms, and MAX_THREADS to 1000000
                           SQL_COMPILER_RECURSION to 2000


COINTEC04 (Client)       Wed Jun 13 09:04:54 2012
            Guardian starting: C:\Embarcadero\InterBase\bin\ibserver.exe


COINTEC04 (Server)      Wed Jun 13 19:17:37 2012
            Database: T:\GESTLABBD\GESTLAB.GLDB
            database file appears corrupt ()
            wrong page type
            page 303 is of wrong type (expected 5, found 99)

COINTEC04 (Server)      Wed Jun 13 19:17:37 2012
            Metadata scan (1) for relation LISTA_TRABAJO_VINCULO failed

COINTEC04 (Server)      Wed Jun 13 19:17:37 2012
            Database: T:\GESTLABBD\GESTLAB.GLDB
            database file appears corrupt ()
            wrong page type
            page 303 is of wrong type (expected 5, found 99)

COINTEC04 (Server)      Wed Jun 13 19:17:37 2012
            process_packet() servicing opcode=63
            Access violation.
                        The code attempted to access a virtual
                        address without privilege to do so.
            This exception will cause the InterBase server
            to terminate abnormally.

COINTEC04 (Server)      Wed Jun 13 19:17:37 2012
            garbage_collector
            Access violation.
                        The code attempted to access a virtual
                        address without privilege to do so.
            This exception will cause the InterBase server
            to terminate abnormally.

COINTEC04 (Client)       Wed Jun 13 19:17:37 2012
            REMOTE INTERFACE/gds__detach: Unsuccessful detach from database.
            Uncommitted work may have been lost

COINTEC04 (Client)       Wed Jun 13 19:17:38 2012
            C:\Embarcadero\InterBase\bin\ibserver.exe: terminated abnormally (-1)


COINTEC04 (Server)      Wed Jun 13 19:17:41 2012
            Server: version 10.0.4.590 (32-bit), ibconfig settings...
                           SWEEP_QUANTUM to 250, USER_QUANTUM to 1000,
                           SWEEP_YIELD_TIME to 1 ms, and MAX_THREADS to 1000000
                           SQL_COMPILER_RECURSION to 2000


COINTEC04 (Client)       Wed Jun 13 19:17:41 2012
            Guardian starting: C:\Embarcadero\InterBase\bin\ibserver.exe

Sriram Balasubramanian at 6/30/2012 11:18:39 AM -
Jesus,

Thank you for the report. Yes, we are interested in solving this soon once we are able to reproduce. I will contact you offline for the database and scripts.

Tomohiro Takahashi at 6/30/2012 6:41:05 PM -
This report was opened.
But, Internal Tracking Number field is still blank.

Server Response from: ETNACODE01