Hi Jeffrey,
According to the following page:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/77787;pt=62077/*
"""This is an informational message. Unless otherwise specified, no
action is required. Contact your System Administrator about any warning
issued in the message."""
So I think the following patch should correct your problem:
Index: Sybase.py
===================================================================
--- Sybase.py (révision 443)
+++ Sybase.py (copie de travail)
@@ -258,13 +258,15 @@
raise IntegrityError(msg)
elif mn == 2812: ## Procedure not found
raise StoredProcedureError(msg)
- elif mn in (0, 5701, 5703, 5704) or ((mn >= 6200) and (mn < 6300)):
+ elif mn in (0, 1918, 5701, 5703, 5704, 11932) or ((mn >= 6200) and
(mn < 6300)):
# Non-errors:
# 0 PRINT
+ # 1918 Non-clustered index is being rebuilt.
# 5701 Changed db context
# 5703 Changed language
# 5704 Changed character set (Sybase)
# 6200-6299 SHOWPLAN output (Sybase)
+ # 11932 Beginning REORG REBUILD of table
hook = _output_hooks.get(conn)
if hook:
hook(conn, msg)
regards
--
Sébastien Sablé
Jeffrey Zelt a écrit :
> I would like to execute “reorg rebuild” on the server. Whenever I do
> this, python-sybase throws a Sybase.DatabaseError exception as shown here:
>
>
>
> Traceback (most recent call last):
>
> File
> "/home/jeffreyz/workspace-3.5/sybase-tests/src/connection_tests.py",
> line 41, in <module>
>
> cursor.execute('reorg rebuild Client')
>
> File "build/bdist.linux-i686/egg/Sybase.py", line 546, in execute
>
> File "build/bdist.linux-i686/egg/Sybase.py", line 695, in _start
>
> File "build/bdist.linux-i686/egg/Sybase.py", line 709, in _mainloop
>
> File "build/bdist.linux-i686/egg/Sybase.py", line 753, in _raise_error
>
> Sybase.DatabaseError: Msg 11932, Level 10, State 1, Line 1
>
> Beginning REORG REBUILD of table 'Client'.
>
> Msg 1918, Level 10, State 1, Line 1
>
> Non-clustered index (index id = 2) is being rebuilt.
>
>
>
> Does anyone know how this can be avoided?
>
>
>
> I have just patched python-sybase to use ASE 15.x capabilities (to allow
> identifiers longer than 30 characters). However, I still throw the
> Sybase.DatabaseError exception shown above when executing “reorg rebuild”.
>
>
>
> The same exception was also thrown _/before/_ I patched python-sybase to
> use ASE 15.x capabilities.
>
>
>
> Does anyone know if this exception can be avoided somehow? Thanks in
> advance.
>
>
>
> Regards,
>
> Jeffrey
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Python-sybase-misc mailing list
> Pyt...@li...
> https://lists.sourceforge.net/lists/listinfo/python-sybase-misc
|
