Skip to Content
0
Former Member
Sep 30, 2016 at 07:47 PM

Invalid column length on TEMPDB syslogs

53 Views

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