Solved: Assertion failed: Unable to load database SID duri...

Former Member · ‎03-17-2014

Hi Supports,

I am using sapinst homogeneous system copy in Linux on sybase.

I stuck on the the step 27/49 "create Database".

I checked Firewall is off.

i got points in my sapinst_dev.log that "

1)The log segment in the target database 'SID' is too small (9216 MB) to accommodate the log segment from the dumped database (10240 MB)"

and

2)"Can't change the owner of the master, model, tempdb or sybsystemprocs database"

Do i need to increase "sybase/SID/saplog_1" ? because my "saplog_1" is 49 mb now.

if it is ! how do i increase in this stage.

can any one know about this error???

Thanks,

Aziz.

Former Member · ‎03-19-2014

Hi Siva,

last some lines of sapinst_dev.log is,

=================================

account user="sybib1" uid="1015" exists with parameter gid="1001"

TRACE 2014-03-18 18:38:21.988 [syuxcuser.cpp:634]

PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

lib=syslib module=syslib

account user="sybib1" uid="1015" exists with parameter gid="1001"

TRACE 2014-03-18 18:38:21.992 [syuxcuser.cpp:634]

PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

lib=syslib module=syslib

account user="sybib1" uid="1015" exists with parameter gid="1001"

TRACE 2014-03-18 18:38:21.996 [syuxcuser.cpp:634]

PSyGroupImpl CSyUserImpl::getPrimaryGroup()const

lib=syslib module=syslib

account user="sybib1" uid="1015" exists with parameter gid="1001"

TRACE 2014-03-18 18:38:22.21 [syuxctask.cpp:237]

CChildApplicationImpl::doStart() lib=syslib module=syslib

A child process has been started. Pid = 25114

INFO 2014-03-18 18:38:22.030

CJSlibModule::writeInfo_impl()

Output of isql -e -w999 -Usa -Sibssrv02:7905 is written to the logfile isql.log.

TRACE 2014-03-18 18:52:16.385 [syuxctask.cpp:600]

CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int option

lib=syslib module=syslib

Child process 25114 returned 0

INFO 2014-03-18 18:52:16.387

CJSlibModule::writeInfo_impl()

Execution of the command "isql -e -w999 -Usa -Sibssrv02:7905" finished with retu

Password:

1> use master

1> load database IB1

2> from '/IBS_BACKUP/anthia/DOA_BACKUP.dmp'

Backup Server session id is: 7. Use this value when executing the 'sp_volchangedver.

Backup Server: 6.28.1.1: Dumpfile name 'DOA1405712DB6 ' section number 1 moun

Backup Server: 4.188.1.1: Database IB1: 2332534 kilobytes (1%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 4641256 kilobytes (2%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 6936426 kilobytes (3%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 9248366 kilobytes (4%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 11565036 kilobytes (5%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 13857906 kilobytes (6%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 16169338 kilobytes (7%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 18471038 kilobytes (8%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 20767610 kilobytes (9%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 23081760 kilobytes (10%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 25378052 kilobytes (11%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 27688896 kilobytes (12%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 29994066 kilobytes (13%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 32300380 kilobytes (14%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 34609850 kilobytes (15%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 36926744 kilobytes (16%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 39219058 kilobytes (17%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 41541706 kilobytes (18%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 43842848 kilobytes (19%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 46140662 kilobytes (20%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 48463310 kilobytes (21%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 50768550 kilobytes (22%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 53062524 kilobytes (23%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 55385172 kilobytes (24%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 57686314 kilobytes (25%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 59987456 kilobytes (26%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 62288598 kilobytes (27%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 64611246 kilobytes (28%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 66912388 kilobytes (29%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 69213530 kilobytes (30%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 71514672 kilobytes (31%) LOADED.

Backup Server: 4.188.1.1: Database IB1: 73837320 kilobytes (32%) LOADED.

Msg 7223, Level 16, State 7:

Server 'IB1', Line 1:

Cannot read from site 'SYB_BACKUP'.

Msg 7212, Level 11, State 2:

Server 'IB1', Line 1:

Can't close connection 2 on site 'SYB_BACKUP' because it is not active.

1> online database IB1

Msg 930, Level 14, State 1:

Server 'IB1', Line 1:

Database 'IB1' cannot be opened because either an earlier system termination lefatabase or contact a user with System Administrator (SA) role.

1> EXEC sp_dboption IB1, 'ddl in tran', true

Database option 'ddl in tran' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'ddl in tran' to take effect.

(return status = 0)

1> EXEC sp_dboption IB1, 'allow nulls by default', true

Database option 'allow nulls by default' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'allow nulls by default' to take

(return status = 0)

1> EXEC sp_dboption IB1, 'abort tran on log full', true

Database option 'abort tran on log full' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'abort tran on log full' to take

(return status = 0)

1> EXEC sp_dboption IB1, 'allow wide dol rows', true

Database option 'allow wide dol rows' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'allow wide dol rows' to take ef

(return status = 0)

1> EXEC sp_dboption IB1, 'trunc log on chkpt', true

Database option 'trunc log on chkpt' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'trunc log on chkpt' to take eff

(return status = 0)

1> EXEC sp_dboption IB1, 'allow incremental dumps', true

Database option 'allow incremental dumps' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'allow incremental dumps' to tak

(return status = 0)

1> EXEC sp_dboption IB1, 'full logging for all', true

Database option 'full logging for all' turned ON for database 'IB1'.

Running CHECKPOINT on database 'IB1' for option 'full logging for all' to take e

(return status = 0)

1> use IB1

Msg 930, Level 14, State 1:

Server 'IB1', Line 1:

Database 'IB1' cannot be opened because either an earlier system termination lefatabase or contact a user with System Administrator (SA) role.

1> EXEC sp_changedbowner sapsa

Msg 17361, Level 16, State 1:

Server 'IB1', Procedure 'sp_changedbowner', Line 124:

Can't change the owner of the master, model, tempdb or sybsystemprocs database.

(return status = 1)

ERROR 2014-03-18 18:52:16.388 [iaxxinscbk.cpp:224]

CJS-00030 Assertion failed: Unable to load database IB1. Refer to trace file sa

TRACE 2014-03-18 18:52:16.406 [EJSController.cpp:351]

EJS_ControllerImpl::getExtension(EJS::Exception)

unqualified name is Exception

TRACE 2014-03-18 18:52:16.407 [JSExtension.hpp:128]

JSExceptionHandler::setJSException()

Member function 'Installer.abortInstallation()' has thrown ESAPinstException. Co

TRACE 2014-03-18 18:52:16.407

Function setMessageIdOfExceptionMessage: modlib.jslib.caughtException

ERROR 2014-03-18 18:52:16.408

CJSlibModule::writeError_impl()

MUT-03025 Caught ESAPinstException in module call: .

TRACE 2014-03-18 18:52:16.413 [JSExtension.hpp:879]

CallFunctionBase::call()

Member function 'Installer.invokeModuleCall() has thrown unknown exception. Reth

TRACE 2014-03-18 18:52:16.673 [syuxctask.cpp:237]

CChildApplicationImpl::doStart() lib=syslib module=syslib

A child process has been started. Pid = 25610

TRACE 2014-03-18 18:52:17.761 [syuxctask.cpp:600]

CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int option

lib=syslib module=syslib

Child process 25610 returned 0

TRACE 2014-03-18 18:52:17.816 [syuxctask.cpp:237]

CChildApplicationImpl::doStart() lib=syslib module=syslib

A child process has been started. Pid = 25611

TRACE 2014-03-18 18:52:18.648 [syuxctask.cpp:600]

CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int option

lib=syslib module=syslib

Child process 25611 returned 0

ERROR 2014-03-18 18:52:18.683 [sixxcstepexecute.cpp:901]

FCO-00011 The step syb_step_load_database with step key |NW_ABAP_OneHost|ind|in|ind|createdbandload|0|NW_CreateDB|ind|ind|ind|ind|createdb|0|NW_SYB_DB|ind|ind|ror reported by the step: Assertion failed: Unable to load database IB1. Refer t

TRACE 2014-03-18 18:52:18.749 [kdxxctaco.cpp:100]

CKdbTableContainerImpl::syncToContainerFile lib=iakdblib

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE 2014-03-18 18:52:20.805 [kdxxctaco.cpp:129]

CKdbTableContainerImpl::syncToContainerFile lib=iakdblib

after creating out stream for /tmp/sapinst_instdir/BS2013/BS2013/ERP607/SYB/SYB

TRACE 2014-03-18 18:52:22.958 [kdxxctaco.cpp:163]

CKdbTableContainerImpl::syncToContainerFile lib=iakdblib

CKdbTableContainerImpl::syncToContainerFile stop ...

INFO 2014-03-18 18:52:22.968 [syuxcpath.cpp:447]

CSyPath::createFile() lib=syslib module=syslib

Creating file /tmp/sapinst_instdir/BS2013/BS2013/ERP607/SYB/SYB/COPY/SYB/SYSTEM/

TRACE 2014-03-18 18:52:22.992 [syuxctask.cpp:237]

CChildApplicationImpl::doStart() lib=syslib module=syslib

A child process has been started. Pid = 25612

TRACE 2014-03-18 18:52:23.296 [syuxctask.cpp:600]

CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int option

lib=syslib module=syslib

Child process 25612 returned 0

TRACE 2014-03-18 18:52:23.340 [syuxctask.cpp:237]

CChildApplicationImpl::doStart() lib=syslib module=syslib

A child process has been started. Pid = 25613

TRACE 2014-03-18 18:52:23.527 [syuxctask.cpp:600]

CUnixProcessManager::sap_waitpid(pid_t pid, int * pStatus, int option

lib=syslib module=syslib

Child process 25613 returned 0

TRACE 2014-03-18 18:52:28.661

SAPInst calls the LogInquirer. The output of the LogInquirer can be found in fil

TRACE 2014-03-18 18:52:55.106 [iaxxgenimp.cpp:660]

CGuiEngineImp::showMessageBox

<html> <head> </head> <body> An error occurred while processing option SArget System > Standard System > Based on AS ABAP > Standard System( Last error rsapinst_dev.log for further information.). You can now: <ul> <li> Choose information about the error. </li> <li> Stop the option and continue with it lERP607/SYB/SYB/COPY/SYB/SYSTEM/STD/AS-ABAP/</code>. </body></html>

TRACE 2014-03-18 18:52:55.115 [iaxxgenimp.cpp:1137]

CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

Former Member · ‎03-21-2014

Hi,

When i seen SID.log file so its showing deadlock and checkpoint occurring,

Is any solution ???

Is this because of networks?

we had 2 servers on this same IP. but i stopped one server and one is still running.

please find my SID.log file and revert back if any soltion.

==========================================================

=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.03.21 12:12:31 =~=~=~=~=~=~=~=~=~=~=~=

ibssrv02:/sybase/IB1/ASE-15_0/install #

ibssrv02:/sybase/IB1/ASE-15_0/install # lscd ASE-15_0/install/lscd IB1lscd /IB1sybase/df -hexitsu - sybib1lscd IB1ls

IB1.log IB1_BS.log IB1_JSAGENT.log RUN_IB1 RUN_IB1_BS auditinit setperm_all showserver startserver sybhauser veritas

ibssrv02:/sybase/IB1/ASE-15_0/install # more IB1.log

00:0000:00000:00000:2014/03/21 11:03:36.98 kernel SySAM: Using licenses from: /sybase/IB1/SYSAM-2_0/licenses/SYBASE.lic:/sybase/IB1/SYSAM-2_0/licenses/SYBASE_ASE_DE.li

c:/sybase/IB1/SYSAM-2_0/licenses/SYBASE_ASE_XE.lic

00:0000:00000:00000:2014/03/21 11:03:37.00 kernel SySAM: Checked out license for 6 ASE_CORE (2014.1231/permanent/1296 8FE3 0A83 A167).

00:0000:00000:00000:2014/03/21 11:03:37.00 kernel This product is licensed to: SAP, for use with SAP Business Applications.

00:0000:00000:00000:2014/03/21 11:03:37.00 kernel Checked out license ASE_CORE

00:0000:00000:00000:2014/03/21 11:03:37.00 kernel Adaptive Server Enterprise (Enterprise Edition)

00:0000:00000:00000:2014/03/21 11:03:37.00 kernel Performing space allocation for device '/sybase/IB1/sybsystem/master.dat' (0.39 Gb). This may take some time.

00:0000:00000:00000:2014/03/21 11:03:38.32 kernel Finished initialization.

00:0000:00000:00000:2014/03/21 11:03:38.32 kernel Using config area from primary master device.

00:0000:00000:00000:2014/03/21 11:03:38.32 server Configuration Error: Configuration file, '/sybase/IB1/IB1.cfg', does not exist.

00:0000:00000:00000:2014/03/21 11:03:38.32 kernel Warning: A configuration file was not specified or the default file '/sybase/IB1/IB1.cfg' does not exist. ASE creates

the default file.

00:0000:00000:00000:2014/03/21 11:03:38.32 kernel Warning: Using default file '/sybase/IB1/IB1.cfg' since a configuration file was not specified. Specify a configurati

on file name in the RUNSERVER file to avoid this message.

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Could not allocate memory using Huge Pages. Allocated using regular pages. For better performance, reboot the server

after configuring enough Huge Pages.

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Internal run-time model set for Linux - Native

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Adaptive Server is using the threaded kernel mode.

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Using 4096 file descriptors.

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Adaptive Server Enterprise/15.7/EBF 21341 SMP SP101 /P/x86_64/Enterprise Linux/ase157sp101/3439/64-bit/FBO/Thu Jun 6

16:08:18 2013

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Confidential property of Sybase, Inc.

00:0000:00000:00000:2014/03/21 11:03:38.33 kernel Unpublished rights reserved under U.S. c 1702]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'master': beginning upgrade step [ID 1718]: executing SQL statement ("update master.dbo.sysusages set loc..

.")

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'master': beginning upgrade step [ID 1719]: executing SQL statement ("update sysattributes set object_inf..

.")

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'master': beginning upgrade step [ID 1720]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'master': beginning upgrade step [ID 1730]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'master': beginning upgrade step [ID 1731]: executing SQL statement ("begin declare @val int select @val=..

.")

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'master': beginning upgrade step [ID 1740]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'model' does not exist. ASE will create it.

--More--(11%)

00:0006:00000:00001:2014/03/21 11:03:39.77 server Database 'model': beginning upgrade step [ID 1]: Initialize disk and create empty allocation units on master devi

ce.

00:0006:00000:00001:2014/03/21 11:03:39.79 server Database 'model': beginning upgrade step [ID 2]: Bootstrap basic system catalogs in database.

00:0006:00000:00001:2014/03/21 11:03:39.79 server Database 'model': beginning upgrade step [ID 6]: creating index (table syspartitions, index ncsyspartitions)

00:0006:00000:00001:2014/03/21 11:03:39.80 server Database 'model': beginning upgrade step [ID 8]: creating index (table systypes, index ncsystypes)

00:0006:00000:00001:2014/03/21 11:03:39.80 server Database 'model': beginning upgrade step [ID 10]: creating index (table sysobjects, index ncsysobjects)

00:0006:00000:00001:2014/03/21 11:03:39.80 server Database 'model': beginning upgrade step [ID 13]: creating table (table systabstats)

00:0006:00000:00001:2014/03/21 11:03:39.80 server Database 'model': beginning upgrade step [ID 26]: creating table (table sysprocedures)

00:0006:00000:00001:2014/03/21 11:03:39.80 server Database 'model': beginning upgrade step [ID 27]: creating table (table syscomments)

00:0006:00000:00001:2014/03/21 11:03:39.80 server Database 'model': beginning upgrade step [ID 28]: creating table (table syssegments)

00:0006:00000:00001:2014/03/21 11:03:39.81 server Database 'model': beginning upgrade step [ID 29]: creating table (table sysprotects)

00:0006:00000:00001:2014/03/21 11:03:39.81 server Database 'model': beginning upgrade step [ID 30]: creating table (table sysusers)

00:0006:00000:00001:2014/03/21 11:03:39.81 server Database 'model': beginning upgrade step [ID 31]: creating table (table sysalternates)

00:0006:00000:00001:2014/03/21 11:03:39.81 server Database 'model': beginning upgrade step [ID 32]: creating table (table sysdepends)

00:0006:00000:00001:2014/03/21 11:03:39.81 server Database 'model': beginning upgrade step [ID 33]: creating table (table syskeys)

00:0006:00000:00001:2014/03/21 11:03:39.82 server Database 'model': beginning upgrade step [ID 47]: creating table (table syspartitionkeys)

00:0006:00000:00001:2014/03/21 11:03:39.82 server Database 'model': beginning upgrade step [ID 51]: creating table (table sysreferences)

00:0006:00000:00001:2014/03/21 11:03:39.82 server Database 'model': beginning upgrade step [ID 52]: creating table (table sysconstraints)

00:0006:00000:00001:2014/03/21 11:03:39.83 server Database 'model': beginning upgrade step [ID 53]: creating table (table sysusermessages)

00:0006:00000:00001:2014/03/21 11:03:39.83 server Database 'model': beginning upgrade step [ID 54]: creating table (table systhresholds)

00:0006:00000:00001:2014/03/21 11:03:39.83 server Database 'model': beginning upgrade step [ID 55]: creating table (table sysroles)

00:0006:00000:00001:2014/03/21 11:03:39.83 server Database 'model': beginning upgrade step [ID 56]: creating table (table sysslices)

00:0006:00000:00001:2014/03/21 11:03:39.83 server Database 'model': beginning upgrade step [ID 60]: creating table (table sysstatistics)

00:0006:00000:00001:2014/03/21 11:03:39.84 server Database 'model': beginning upgrade step [ID 61]: creating table (table sysxtypes)

00:0006:00000:00001:2014/03/21 11:03:39.84 server Database 'model': beginning upgrade step [ID 62]: creating table (table sysjars)

00:0006:00000:00001:2014/03/21 11:03:39.84 server Database 'model': beginning upgrade step [ID 65]: creating table (table sysqueryplans)

00:0006:00000:00001:2014/03/21 11:03:39.85 server Database 'model': beginning upgrade step [ID 68]: creating table (table sysencryptkeys)

00:0006:00000:00001:2014/03/21 11:03:39.85 server Database 'model': beginning upgrade step [ID 73]: executing SQL statement ("update sysobjects set sysstat = sys...

")

00:0006:00000:00001:2014/03/21 11:03:39.85 server Database 'model': beginning upgrade step [ID 74]: executing SQL statement ("update syscolumns set type=66, user...

")

00:0006:00000:00001:2014/03/21 11:03:39.85 server Database 'model': beginning upgrade step [ID 80]: creating table (table sysattributes)

00:0006:00000:00001:2014/03/21 11:03:39.86 server Database 'model': beginning upgrade step [ID 82]: creating table (table sysdams)

00:0006:00000:00001:2014/03/21 11:03:39.86 server Database 'model': beginning upgrade step [ID 90]: insert basic data into bootstrap system tables

00:0006:00000:00001:2014/03/21 11:03:39.89 server Database 'model': beginning upgrade step [ID 91]: executing SQL statement ("update systypes set length=@@maxpag...

")

00:0006:00000:00001:2014/03/21 11:03:39.89 server Database 'model': beginning upgrade step [ID 245]: Update system roles in system tables.

00:0006:00000:00001:2014/03/21 11:03:39.89 server Database 'model': beginning upgrade step [ID 248]: update system catalog protection data

00:0006:00000:00001:2014/03/21 11:03:39.90 server Database 'model': beginning upgrade step [ID 606]: executing SQL statement ("select lct_admin('lastchance', db_i...

")

00:0006:00000:00001:2014/03/21 11:03:39.90 server Database 'model': beginning upgrade step [ID 1126]: Initialize systabstats with valid statistics

00:0006:00000:00001:2014/03/21 11:03:39.90 server Database 'model': beginning upgrade step [ID 1131]: Creating/Updating the last chance threshold for logsegment.

00:0006:00000:00001:2014/03/21 11:03:39.90 server Database 'model': beginning upgrade step [ID 1274]: executing SQL statement ("declare @dummy int")

--More--(13%)

00:0006:00000:00001:2014/03/21 11:03:39.91 server Database 'model': beginning upgrade step [ID 1241]: executing SQL statement ("insert into sysattributes (class, a...

")

00:0006:00000:00001:2014/03/21 11:03:39.91 server Database 'model': beginning upgrade step [ID 1400]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.91 server Database 'model': beginning upgrade step [ID 1411]: executing SQL statement ("if not exists (select 1 from master...

")

00:0006:00000:00001:2014/03/21 11:03:39.91 server Database 'model': beginning upgrade step [ID 1416]: executing SQL statement ("update sysroles set id=11 from sysu...

")

00:0006:00000:00001:2014/03/21 11:03:39.91 server Database 'model': beginning upgrade step [ID 1502]: executing SQL statement ("if exists (select 1 from sysobjects...

")

00:0006:00000:00001:2014/03/21 11:03:39.91 server Database 'model': beginning upgrade step [ID 1503]: executing SQL statement ("create view sysquerymetrics (uid, g...

")

00:0006:00000:00001:2014/03/21 11:03:39.92 server Database 'model': beginning upgrade step [ID 1505]: executing SQL statement ("update sysattributes set char_value...

")

00:0006:00000:00001:2014/03/21 11:03:39.92 server Database 'model': beginning upgrade step [ID 1550]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.92 server Database 'model': beginning upgrade step [ID 1554]: upgrade simulated statistics

00:0006:00000:00001:2014/03/21 11:03:39.92 server Database 'model': beginning upgrade step [ID 1564]: executing SQL statement ("declare @dbid int select @dbid = db...

")

00:0006:00000:00001:2014/03/21 11:03:39.93 server Database 'model': beginning upgrade step [ID 1650]: executing SQL statement ("dbcc upgd_grantrev_sysrole_perms('g...

")

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1651]: updating builtin permissions

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1652]: adding generic user 'usedb_user' to sysusers

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1653]: updating DBCC command permissions

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1702]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1719]: executing SQL statement ("update sysattributes set object_inf...

")

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1720]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1730]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.97 server Database 'model': beginning upgrade step [ID 1740]: noting the present database upgrade level

00:0006:00000:00001:2014/03/21 11:03:39.97 server CREATE DATABASE: allocating 1536 logical pages (24.0 megabytes) on disk 'master' (1536 logical pages requested).

00:0006:00000:00001:2014/03/21 11:03:39.97 server Warning: The database 'sybsystemdb' is using an unsafe virtual device 'master'. The recovery of this database can not

be guaranteed.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Timestamp for database 'sybsystemdb' is (0x0000, 0x000013b4).

00:0006:00000:00001:2014/03/21 11:03:39.99 server Database 'sybsystemdb' is now online.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Database sybsystemdb successfully created.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Recovering database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Started estimating recovery log boundaries for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Database 'sybsystemdb', checkpoint=(864, 64), first=(864, 64), last=(864, 150).

00:0006:00000:00001:2014/03/21 11:03:39.99 server Completed estimating recovery log boundaries for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Started ANALYSIS pass for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Completed ANALYSIS pass for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Log contains all committed transactions until 2014/03/21 11:03:39.33 for database sybsystemdb.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 86.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Redo pass of recovery has processed 2 committed and 0 aborted transactions.

--More--(15%)

00:0006:00000:00001:2014/03/21 11:03:39.99 server Completed REDO pass for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Timestamp for database 'sybsystemdb' is (0x0000, 0x00001416).

00:0006:00000:00001:2014/03/21 11:03:39.99 server Recovery of database 'sybsystemdb' will undo incomplete nested top actions.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Started recovery checkpoint for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Completed recovery checkpoint for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Started filling free space info for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:39.99 server Completed filling free space info for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:40.00 server Started cleaning up the default data cache for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:40.00 server Completed cleaning up the default data cache for database 'sybsystemdb'.

00:0006:00000:00001:2014/03/21 11:03:40.00 server Boot Count: 1

00:0006:00000:00001:2014/03/21 11:03:40.00 server Checking external objects.

00:0006:00000:00001:2014/03/21 11:03:40.00 server Database 'sybsystemdb' is now online.

00:0006:00000:00001:2014/03/21 11:03:40.00 server Now loading ASE's new default sort order and character set

00:0006:00000:00001:2014/03/21 11:03:40.00 server Checking table 'sysobjects' (object ID 1): Logical page size is 16384 bytes.