Invalid column length on TEMPDB syslogs
Hi
On one ASE15.7 SP62 database (with traceflag T2779) on Solaris10, I am getting the following error message in the ASE log:
00:0002:00000:00066:2016/09/29 15:26:57.82 server Invalid column length: 6. Value must be between 0 and 4 at offset 0 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200131, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.84 server Invalid column length: 250. Value must be between 0 and 4 at offset 6 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200131, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.85 server Invalid column length: 207. Value must be between 0 and 4 at offset 49 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200131, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.86 server Invalid column length: 241. Value must be between 0 and 150 at offset 628 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200131, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.87 server Invalid column length: 248. Value must be between 0 and 4 at offset 8 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200131, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.89 server Invalid column length: 15. Value must be between 0 and 1 at offset 0 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200131, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.90 server Invalid column length: 254. Value must be between 0 and 4 at offset 101 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200132, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.91 server Invalid column length: 243. Value must be between 0 and 4 at offset 118 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200132, dbid=2
00:0002:00000:00066:2016/09/29 15:26:57.92 server Invalid column length: 11. Value must be between 0 and 1 at offset 105 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000ed06f08) sdes_next=0x1000ed074e8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200132, dbid=2
00:0002:00000:00202:2016/09/29 15:26:58.85 server Invalid column length: 214. Value must be between 0 and 4 at offset 256 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000fa47808) sdes_next=0x1000fa47de8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200165, dbid=2
00:0002:00000:00202:2016/09/29 15:26:58.86 server Invalid column length: 115. Value must be between 0 and 4 at offset 470 for 'all-pages' row with minimum row length of 2.
SDES: (at 0x1000fa47808) sdes_next=0x1000fa47de8 sdesp=0x1000adf0610 objuid=1 objid=8 objname=syslogs scurpage=200165, dbid=2
00:0002:00000:00202:2016/09/29 15:26:58.87 server Invalid column length: 241. Value must be between 0 and 4 at offset 271 for 'all-pages' row with minimum row length of 2.
....
In the past, on other servers, I had managed to fix the issue by running dbcc checkcatalog against the faulty database.
However this time, the error is reported on syslogs of TEMPDB (dbid=2).
master.1> dbcc checkcatalog(tempdb);
Checking tempdb: Logical pagesize is 2048 bytes
The following segments have been defined for database 2 (database name tempdb).
virtual device number virtual start addr size (logical pages) segments
--------------------- -------------------- ---------------------- --------------------
0 8196 2048
0
1
2
2 0 256000
0
1
2
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
master.1> dbcc checkcatalog(tempdb,fix);
Checking tempdb: Logical pagesize is 2048 bytes
Msg 2595, Level 16, State 5
Server 'snap01', Line 1
Database 'tempdb' must be set to single-user mode before executing this command.
Of course I was unsuccessful to put the tempdb in "single user" mode and start the server with "-m" did not help either.
master.1> sp_dboption tempdb, "single user", true;
Warning: Attempting to change database options for a temporary database. Database options must be kept consistent across all temporary databases.
Msg 17436, Level 16, State 1
Server 'snap01', Procedure 'sp_dboption', Line 707
You cannot set the 'single user' option for a temporary database.
Any ideas?
Thanks,
Vincent