Can't start my Sybase ASE server: kernel dopen error & Error 822 !!
Patrick Tahiri
(Platform: AIX 5 & Sybase 12.5)
I tried to start my Sybase ASE server with the command: ./startserver -f
RUN_servername
But the server fails to start and when I'm looking in my error log I've
found:
1. a kernel dopen: open '/dev/rboprod_temp_d2 ', No such file or
directory
----------------------------------------------------------------------------
--
Activating disk 'tempdbdev2'. 00:00000:00001:2005/05/28 15:49:41.10 kernel
Initializing virtual device 14, '/dev/rboprod_temp_d2 '
00:00000:00001:2005/05/28 15:49:41.11
kernel dopen: open '/dev/rboprod_temp_d2 ', No such file or directory
00:00000:00001:2005/05/28 15:49:41.11
kernel udactivate: error starting virtual disk 14 00:00000:00001:2005/05/28
15:49:41.13
2. and an "Error 822".
----------------------
Error: 822, Severity: 20, State: 2 00:00000:00001:2005/05/28 15:49:44.67
server Could not start I/O for request BLKIO flags = 0x12, size = 2048,
errcode = 0x0, BUF pointer = '0x8e73a02c', MASS pointer = '0x8e73a02c',
(Buf#: '0'), page ptr = '0x8a524800', dbid = '2', Mass virtpage =
'234881026', Buffer page = '0', Mass status = '0x908', Buffer status =
'0x1', size = '2048', cache (id: 0) = 'default data cache'.
00:00000:00001:2005/05/28 15:49:44.67 server SQL Server's default sort
order is: 00:00000:00001:2005/05/28 15:49:44.67
...
Clearing temp db 00:00000:00001:2005/05/28 15:49:44.67 kernel udstartio:
vdn 14 has not been set up 00:00000:00001:2005/05/28 15:49:44.67 server
...
Shutdown with nowait detected - SQL Server process level execution bindings
will be cleared on startup. 01:00000:00001:2005/05/28 15:50:12.70
server SQL Server shutdown by request. 01:00000:00001:2005/05/28
15:50:12.70 kernel ueshutdown: exiting
I've done some research and I found these 2 links about these errors:
Error 822:
1) I've checked if the path/directory structure '/dev/rboprod_temp_d2 '
exists on my host machine and it does.
2) I've checked ig the writes/reads permissions are correctly set and it
does.
3) I've checked if the ownership is ok and it is (sybase owner).
4) I've checked if the path '/dev/rboprod_temp_d2 ' is correctly set in the
RUN_server_name file and it is (I think... which is the correct setting in
the RUN_server file?).
QUESTION: disk 'tempdbdev2' & kernel dopen: open '/dev/rboprod_temp_d2
', No such file or directory
----------------------------------------------------------------------------
-----------------------------------
5) My unique way is maybe now a restore/recovery BUT how do I recover a
tempdb ? It's common to not take backup of the temporary database! So how
can I restore and recover from my backups a temporary database? It's a
tempdbdev2 ('/dev/rboprod_temp_d2 ') device which is problematic...
How can I restore to be able to start my Sybase ASE 12.5 server and access
my databases?
Thank you in advance for your help!
Best regards,
Patrick.
Navneet Chola
1) You need not take the backup of tempdb as it is recreated from the model
database everytime ASE is started .
2) I think there is some problem with your run_servername file . It should not
contain a entry for tempdb device. ( According to information provided by you ).
Could you paste the contain of the RUN_server file and send us.
3) You can RUN the ASE with -T 3608 --- Recovery Master only mode nand gather
the useful information about the layout of the ASE devices .
But before all the things you should send the RUN_servername output to us.
we can let you know about the next steps with looking into the RUN_server file
and the ASE errorlog .
by the way do you have a good copy of master database ? if you have one you can
always build your ASE again .
Regards
Navneet
On 29 May 2005 07:19:43 -0700,
in sybase.public.ase.administration
>....
>Clearing temp db 00:00000:00001:2005/05/28 15:49:44.67 kernel udstartio:
>vdn 14 has not been set up 00:00000:00001:2005/05/28 15:49:44.67 server
>....