DB 를 잘 쓰다가 갑자기 에러가 나더군요

찾아보니 log 때문에 에러가 난 거 같구요

log 사이즈를 늘려주거나 버리던지 하라고 하는거 같은데 방법을 모르겠습니다.

여기 나오는 trunc 명령도 써보고 체크도 했는데도 같은 오류만 뜨네요

디바이스 사이즈를 늘려주거나 하려하면 그냥 바로 멈춰버립니다.

어떤 사이즈 조정이나 디비 삭제등을 하려고 해도 바로 멈춰버립니다.

SQL Advantage 에서 디비 삭제 명령어를 써도 full log 메시지가 나오면서 멈춰버리네요

어떻게 해야 하는지 꼭 답변 부탁드립니다. 할게 많거든요 ㅠ.ㅠ

아래에는 에러메시지 써 봤습니다.

Can't allocate space for object 'syslogs' in database 'master' 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 or sp_extendsegment to increase size of the segment.

com.sybase.jdbc2.jdbc.SybSQLException: Can't allocate space for object 'syslogs' in database 'master' 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 or sp_extendsegment to increase size of the segment.

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)

at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2126)

at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)

at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)

at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)

at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1578)

at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1563)

at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)

at com.sybase.aseplugin.sql.ASResultSet.open(ASResultSet.java:152)

at com.sybase.aseplugin.so.ServerSO.isEJBEnabled(ServerSO.java:98)

at com.sybase.aseplugin.bo.ServerBO.open(ServerBO.java:208)

at com.sybase.aseplugin.bo.ASEBaseContainer2.open(ASEBaseContainer2.java:232)

at com.sybase.central.viewer.ViewerContainer.open(ViewerContainer.java)

at com.sybase.central.viewer.ScopePane.selectTreeItem(ScopePane.java)

at com.sybase.central.viewer.ScopePane.valueChanged(ScopePane.java)

at javax.swing.JTree.fireValueChanged(Unknown Source)

at javax.swing.JTree$TreeSelectionRedirector.valueChanged(Unknown Source)

at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(Unknown Source)

at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(Unknown Source)

at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(Unknown Source)

at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(Unknown Source)

at javax.swing.JTree.setSelectionPath(Unknown Source)

at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(Unknown Source)

at javax.swing.plaf.basic.BasicTreeUI$MouseHandler.mousePressed(Unknown Source)

at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)

at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)

at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)

at java.awt.Component.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Window.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)