restore of IQ Server on windows from tape crashes

[Former Member]

Hi,

I am trying to restore a backup from Tape on Windows platform, but the utility_db database on the IQ Server crashes.

How can I troubleshoot what is going wrong, and what is causing the IQ Serer to crash.

I am using IQ Server version 15.4 on Window 2008R

The only message I got is:

,-------------------------------------------------------------------------,

| Runtime Error!                                                          |

|  Program: C:\Sybase\IQ-15_4\Bin64\iqsrv15.exe                           |

| This application has requested the Runtime to terminate it in an        |

| unusual way.                                                            |

| Please contact the application's support team for more                  |

| information.                                                            |

|_________________________________________________________________________|

Regards Tomas

[Former Member]

Hi,

How do I connect to this "utility_db" after a startup?

It does not accept my connection:

C:\>start_iq -n utility_db -gp 32768 -c 512m -iqmc 1000 -iqmc 1000 -iqlm 1000 -qmt 500 -iqnumbrcpus 2

( I see that the port 2638 is assigned to the utility_db )

C:\>dbisql -nogui -c "UID=DBA;pwd=sql;eng=utility_db;dbn=utility_db" -port 2638
Could not connect to the database.
Unable to start specified database: Could not find or execute the
physical store DLL entry point.
SQLCODE=-82, ODBC 3 State="08001"


(Not Connected)> quit

[markmumy]

Try this start line.  I had typos in that one:

start_iq -n utility_db -gp 32768 -c 512m -iqmc 1000 -iqtc 1000 -iqlm 1000 -iqmt 500 -iqnumbercpus 2

Mark

[Former Member]

Hi;

I was able to find the stacktrace now.

Here is the first lines from that:

Any idea?

    **  Error from IQ connection:      **  Time of error:  2014-06-01 22:18:09    **  IQ Version:  Sybase IQ/15.4.0/111107/P/GA    **  OS info:  IQ built on: MS/Windows 2003,  Executed on: Windows/WIN-5PL4U60K048/WinNT/

6.1/Build 7601/Service Pack 1/x86 Family/level 6/Model 44/Stepping 2/4 CPU(s)    **  Command status when error occured:  COMMAND ACTIVE    **  Command text: 
restore database 'demo' FROM '\\\\.\\tape0'
Dump all thread stacks at hos_throw.cxx:313 for PID: 5552

    ***************** This is the STACKTRACE ***************

********************************
  * Generating all thread stacks *
********************************

===== Thread Number  2508 =====
pc: 0x00000000240DF6A6:  void __cdecl pcpstack(unsigned long,unsigned long,class db_log * __ptr64,class hos_fd * __ptr64,int) 00000001804ff590 f hos_stacktrace.o +0x116
pc: 0x00000000240E1577:  void __cdecl DumpAllThreads(char const * __ptr64,unsigned int,int,unsigned long,unsigned long) 0000000180501360 f hos_stacktrace.o +0x217
pc: 0x0000000023EB9F77:  void __cdecl hos_ABORT(char const * __ptr64,unsigned int,class hos_exception const & __ptr64,char * __ptr64,char * __ptr64) 00000001802d9cb0 f hos_abrt.o +0x2c7
pc: 0x00000000240D03B7:  void __cdecl ThrowAbort(class hos_exception const & __ptr64) 00000001804f0260 f hos_throw.o +0x157

...

[Former Member]

Hi;

I was able to find the stacktrace now.

Here is the first lines from that:

Any idea?

    **  Error from IQ connection:      **  Time of error:  2014-06-01 22:18:09    **  IQ Version:  Sybase IQ/15.4.0/111107/P/GA    **  OS info:  IQ built on: MS/Windows 2003,  Executed on: Windows/WIN-5PL4U60K048/WinNT/

6.1/Build 7601/Service Pack 1/x86 Family/level 6/Model 44/Stepping 2/4 CPU(s)    **  Command status when error occured:  COMMAND ACTIVE    **  Command text: 
restore database 'demo' FROM '\\\\.\\tape0'
Dump all thread stacks at hos_throw.cxx:313 for PID: 5552

    ***************** This is the STACKTRACE ***************

********************************
  * Generating all thread stacks *
********************************

===== Thread Number  2508 =====
pc: 0x00000000240DF6A6:  void __cdecl pcpstack(unsigned long,unsigned long,class db_log * __ptr64,class hos_fd * __ptr64,int) 00000001804ff590 f hos_stacktrace.o +0x116
pc: 0x00000000240E1577:  void __cdecl DumpAllThreads(char const * __ptr64,unsigned int,int,unsigned long,unsigned long) 0000000180501360 f hos_stacktrace.o +0x217
pc: 0x0000000023EB9F77:  void __cdecl hos_ABORT(char const * __ptr64,unsigned int,class hos_exception const & __ptr64,char * __ptr64,char * __ptr64) 00000001802d9cb0 f hos_abrt.o +0x2c7
pc: 0x00000000240D03B7:  void __cdecl ThrowAbort(class hos_exception const & __ptr64) 00000001804f0260 f hos_throw.o +0x157

...

[Former Member]

Hi Do we know that backup and restore using tape drives on Windows works and what environment and versions was used //Tomas

[c_baker]

Did you perform the backup to tape on the same machine?

What patch or ESD is your IQ 15.4?

Have you configured enough -iqmc and -iqtc?

Remember, the utility_db is not actually a database but a way to connect to an empty server.

The server must be able to access the tape and the associated directories where the database will be restored to. Make sure all paths exist, are writable and have sufficient space. -iqmc + -iqtc should be about 70% of server memory, if no other processes are on the box.

Make sure you have applied all necessary patches to windows. In particular any VC or .Net drivers required by the tape driver/.dlls. Is the tape supported by IQ?

Chris

[Former Member]

I have now increased the memory on the system to 10GB; but unfortunally the same symptom happends.

I haved used the iqmc 256 and also tried to increase iqtc to the same value, but the problem and symptom still exist.

Nothing exists in the log files from IQ Server.

Is there anyway to troubleshoot IQ Server restore function?

Backup is working without any crashes, it is just the restore.

If I try to backup and restore content from the operating system to this tape driver, it works fine.

I can also tried to debug the tape driver, and can see that restore is doing all this steps for the tapedevice:

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

open

IoControlCode = 2048036 (IOCTL_TAPE_GET_STATUS)

IoControlCode = 2048020 (IOCTL_TAPE_GET_DRIVE_PARAMS)

IoControlCode = 2048032 (IOCTL_TAPE_SET_MEDIA_PARAMS)

TAPE_SET_MEDIA_PARAMETERS->BlockSize=65536

IoControlCode = 2048028 (IOCTL_TAPE_GET_MEDIA_PARAMS)

read(0,65536) = "VOL1000001..."

read(0,65536) = "HDR1..."

read(0,65536) = "HDR2F0000000000..."

IoControlCode = 2048028 (IOCTL_TAPE_GET_MEDIA_PARAMS)

read(0,65536) = "iqdemo.db..."

read(0,65536) = "...." (maybee not readable)

read(0,65536) = "iqdemo.db"

read(0,65536) = "system"

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

(crash of the IQ Server utility_db; with runtime error)

Error! The connection to the database was closed by the server.

  Communication error

  SQLCODE=-85, ODBC 3 State="08S01"

  Line 1, column 1

  restore database 'demo' FROM '\\\\.\\Tape0'

Press ENTER to continue...2014-05-24.09:45:45            demo@localhost

-----------

No further log files can be found on the server.

Is there a way to enable further debugging or a better way to troubleshoot this?

Or do you have an idea what possible can be wrong.

Best regards Tomas

[Former Member]

restore from files is working fine, the tape driver is also working fine.

[Former Member]

Anyone has an idea of how to investigate further why the utility_db crashes, as there are no indications in the logfiles; which is strange.

Or where I can find information about needed patches, etc.?