Sybase Error: 1105, Severity: 17, State: 4

[Former Member]

Hi Experts,

My ASE log shows following error message ...

00:0002:00000:00081:2014/10/30 16:14:55.83 server Can't allocate space for object 'syslogs' in database 'PCD' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.

Help please ....

[former_member414726]

You need to expand the log segment for database "PCD".

Syntax:

Alter databae PCD log on <device_name>=<size>

Note, the device must be used as log device before or a new created device with enough space.

[Former Member]

Hi De-Li Xu,

Thanks for your quick response.What is device name ? i tried to execute sp_helpdevices in isql and found PCD_data_001.dat along with  PCD_log_001 and other devices names (master,tempdb..etc)

After i giving above command this shows ..

Please help..

Regards,

Anoop

[former_member414726]

You must execute the "alter databse" command in master database:

use master

go

Looks like "PCD_log_001" is used for log space, check if it has more space availble by:

sp_helpdevice PCD_log_001

If have then use it, if no, you might need to create new device.

BTW, 8K is too small, at least for "M" level.

[Former Member]

Hey ,

I think that issue still persist.Help