我的sybase不知道哪里出了问题?

jacquiyan 2002-11-14 10:00:31
我的数据库是建在服务器端的sybase上的,然后我在另一台win2000的机器上也安装了sybase,作为客户端,
我用win2000的sybase center for java(已经用补丁覆盖了,可以正常操作)来建库,我建了17个表后,不知道怎么回事,再建表,但保存时,就死在那了。我把sybase服务器重新启动,在建第18个表,然后保存。我看到服务器的sybase.log出现这样的提示:
(1)server Space available in the log segment has fallen critically low in database 'Tianhe'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
(2)server 1 task(s) are sleeping waiting for space to become available in the log segment for database Tianhe.
(3)server 1 task(s) are sleeping waiting for space to become available in the log segment for database Tianhe.
(4)server 1 task(s) are sleeping waiting for space to become available in the log segment for database Tianhe.
(5)kernel Cannot send, host process disconnected: spid: 10
(6)Error: 1608, Severity: 18, State: 4
(7)server A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
(8)server Error: 2812, Severity: 16, State: 5
(9)server Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

而win2000的sybase center java editor的dos控制台,在我打开“tianhe”这个数据库是就抛了以下这些信息,这是我还没有开始建立第18个表。

java.lang.NumberFormatException: 12.5.0.1
at java.lang.Double.valueOf(Double.java:121)
at sybase.scp.ase.so.ASConnection.getServerVersion(ASConnection.java:866
)
at sybase.scp.ase.so.DatabaseRSO.open(DatabaseRSO.java:177)
at sybase.scf.so.VSOBaseContainer.open(VSOBaseContainer.java)
at sybase.scp.ase.bo.DatabaseBO.Open(Compiled Code)
at sybase.scf.bo.sctBaseContainer.onOpen(sctBaseContainer.java)
at sybase.scf.jviewer.ScjTreeView.openContainer(Compiled Code)
at sybase.scf.jviewer.ScjTreeView.treeExpanded(ScjTreeView.java)
at javax.swing.JTree.fireTreeExpanded(Compiled Code)
at javax.swing.JTree.setExpandedState(Compiled Code)
at javax.swing.JTree.expandPath(JTree.java:1467)
at javax.swing.plaf.basic.BasicTreeUI.toggleExpandState(BasicTreeUI.java
:1910)
at javax.swing.plaf.basic.BasicTreeUI.handleExpandControlClick(BasicTree
UI.java:1897)
at javax.swing.plaf.basic.BasicTreeUI.checkForClickInExpandControl(Basic
TreeUI.java:1858)
at javax.swing.plaf.basic.BasicTreeUI$MouseHandler.mousePressed(BasicTre
eUI.java:2540)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:21
8)
at java.awt.Component.processMouseEvent(Compiled Code)
at java.awt.Component.processEvent(Compiled Code)
at java.awt.Container.processEvent(Compiled Code)
at java.awt.Component.dispatchEventImpl(Compiled Code)
at java.awt.Container.dispatchEventImpl(Compiled Code)
at java.awt.Component.dispatchEvent(Compiled Code)
at java.awt.LightweightDispatcher.retargetMouseEvent(Compiled Code)
at java.awt.LightweightDispatcher.processMouseEvent(Compiled Code)
at java.awt.LightweightDispatcher.dispatchEvent(Compiled Code)
at java.awt.Container.dispatchEventImpl(Compiled Code)
at java.awt.Window.dispatchEventImpl(Compiled Code)
at java.awt.Component.dispatchEvent(Compiled Code)
at java.awt.EventDispatchThread.run(Compiled Code)


请问这是怎么回事呢?
服务器端的sybase server的配置如下:
type = 1
server_name = sybase
server_page_size = 2k
master_device_physical_name = /dev/sdb2
master_device_size = 517
master_database_size = 200
sybsystemprocs_device_physical_name = /dev/sdb3
sybsystemprocs_device_size = 133
sybsystemprocs_database_size = 133
errorlog = /opt/sybase-12.5/ASE/install/sybase.log
configfile = /opt/sybase-12.5/ASE/sybase.cfg
sybsystemdb_device_physical_name = /opt/sybase-12.5/data/sybsystemdb.dat
sybsystemdb_device_size = 25
sybsystemdb_database_size = 25
shmem = /opt/sybase-12.5/ASE
default_backup_server = sybase_back

...全文
188 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
mnlsdyl 2002-11-14
  • 打赏
  • 举报
回复
扩充日志段(500M左右)
在检查上截断日志
wanghai 2002-11-14
  • 打赏
  • 举报
回复
日志满了,dump tran databasename with truncate-only
扩充日志段要先DISK INIT 设备,然后添加新建设备到数据库上
设置dboption trun log at checkpoint 为true
jacquiyan 2002-11-14
  • 打赏
  • 举报
回复
请问如何扩充日志段,在检查上截断日志?
我怀疑是win2000 的sybase center的问题,我现在打算换个win32的。请问哪里有下载呢?

2,596

社区成员

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧