Exception thrown executing "reorg rebuild"
"Jeffrey Zelt" <[email protected]> Fri, 28 Aug 2009 15:15:51 +0200
| Newsgroups | gmane.comp.python.sybase |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============3449846231146392833==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01CA27E1.AB3F3A83"
This is a multi-part message in MIME format.
------_=_NextPart_001_01CA27E1.AB3F3A83
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I would like to execute "reorg rebuild" on the server. Whenever I do
this, python-sybase throws a Sybase.DatabaseError exception as shown
here:
=20
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') =20
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 =3D 2) is being rebuilt.
=20
Does anyone know how this can be avoided?
=20
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". =20
=20
The same exception was also thrown _before_ I patched python-sybase to
use ASE 15.x capabilities.
=20
Does anyone know if this exception can be avoided somehow? Thanks in
advance.
=20
Regards,
Jeffrey=20
------_=_NextPart_001_01CA27E1.AB3F3A83
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spreadsheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal>I would like to execute “reorg rebuild” =
on the
server. Whenever I do this, python-sybase throws a =
Sybase.DatabaseError
exception as shown here:<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'>Traceback =
(most
recent call last):<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'> =
File
"/home/jeffreyz/workspace-3.5/sybase-tests/src/connection_tests.py&q=
uot;,
line 41, in <module><o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier =
New"'>
cursor.execute('reorg rebuild
Client') =
<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'> =
File
"build/bdist.linux-i686/egg/Sybase.py", line 546, in =
execute<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'> =
File
"build/bdist.linux-i686/egg/Sybase.py", line 695, in =
_start<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'> =
File
"build/bdist.linux-i686/egg/Sybase.py", line 709, in =
_mainloop<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'> =
File
"build/bdist.linux-i686/egg/Sybase.py", line 753, in =
_raise_error<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier =
New"'>Sybase.DatabaseError:
Msg 11932, Level 10, State 1, Line 1<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'>Beginning =
REORG
REBUILD of table 'Client'.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier New"'>Msg 1918, =
Level 10,
State 1, Line 1<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-family:"Courier =
New"'>Non-clustered index
(index id =3D 2) is being rebuilt.<o:p></o:p></span></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Does anyone know how this can be =
avoided?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>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”. <o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>The same exception was also thrown _<i>before</i>_ =
I patched
python-sybase to use ASE 15.x capabilities.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Does anyone know if this exception can be avoided =
somehow?
Thanks in advance.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Regards,<o:p></o:p></p>
<p class=3DMsoNormal>Jeffrey <o:p></o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01CA27E1.AB3F3A83--
--===============3449846231146392833==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
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
--===============3449846231146392833==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Python-sybase-misc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/python-sybase-misc
--===============3449846231146392833==--