Re: [Python-sybase-misc] Exception thrown executing "reorg rebuild"

[Sébastien S. <sa...@us...>]

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