Fatal error: Unable to start database server

[Former Member]

Hello all,

I'm having trouble to start a server.

The following error is occurring:

Fatal error:  A disk read from file "/xxxxx.db" failed with error code: (5)
Fatal error:  Internal error.
DBSPAWN ERROR:  -80
Unable to start database server

Fatal error: A disk read from file "xxxxx.db" failed with error code: (5) Fatal error: Internal error.
Server failed to start

Could anyone help?

Thanks!

[Gisung]

Hi,

Are there any "out of space" errors in os log such as syslog?

You can get the diagnostic information using "-iqstart" switch when starting IQ as follows.

[xxx.cfg]

...

-iqstart 4

You can see the details.

SyBooks Online

--------------------------------------------------------------------------------------------------------------------------------

-iqstart iqsrv16 Server Option

Provides startup diagnostics for dbspaces.

Syntax

-iqstart N

Remarks

The input parameter N is a number value that represents an integer bit mask. You may combine values to provide more than one feature. Output generated before the IQ message file is generated goes to the console. The -z startup switch provides additional startup and connection information.

The allowed values are as follows:

N=1—returns basic information about the file names from

SYSIQFILES

that are used when opening the dbspace. It then displays the fully qualified names used. You can use this option to create a record of the files in use by the database in the IQ message file.

N=4—returns full diagnostic information, including all rows of

SYSIQFILE

, the subset of file names selected if the database is a multiplex database, the fully resolved file names, each individual dbspace file header block, the database_identity, the commit_identity, each checkpoint log entry, and each transaction log entry.

--------------------------------------------------------------------------------------------------------------------------------

Best Regards,

Gi-Sung Jang

[Former Member]

Thank you Gi-Sung by the tips.

[tayeb_hadjou]

Hello,

This is most likely hardware issue (disk corruption, disk access problem etc).

Make sure all dbspaces are safe and accessible.

Check with system admin. Examine Operating system errolog.

Regards,

[Former Member]

It is recommended perform the restore database, in this case?

[tayeb_hadjou]

Yes, if the hardware is no longer an issue.

If dbfile file system or raw are still corrupt, then restoring to same location will not fix completely the issue.

[Former Member]

Thank you Tayeb.

The disk was corrupted.