Re: error 458: Long transaction aborted
Peter Hamm wrote:
> This is a multi-part message in MIME format.
> --------------88F5FE3A5AA227DDCC18A803
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hello
>
> Does anybody know what is wrong with INFORMIX-Universal Server 9.12 for
> UNIX.
> If I do a query like this
>
> INSET INTO tab_2(oid_1, oid_2)
> SELECT a1.oid_1, a2.oid_2
> FROM tab_1 t1, tab_1 t2
> WHERE t1.oid_1 <> t2.oid_1 AND
> t1.incom < 6000;>
> I get always an error 458: Long Transaction aborted.
>
> The tabe tab_1 has only 2048 rows, so it could be a maximum of 2 mil.
> rows in tab_2.
>
> I did the statement, but seperated into smaler peaces and I received
> 150000 rows in tab_2.
>
> I already toled my database administrator and he increases the physical
> and logical log space, but it didn't help.
> Does anybody know what to do?
Maybe you need not only more espace for this operation , so you can
incrase the number of physical and logical log , lets say from 10 to 40 ,
it cut be, just remember the implacations of this kind of solution, i use
to have this problem and with the increase of space and number of the
logs solve it
>
>
> Thank you very much.
> Peter, University of Munich
>
> --------------88F5FE3A5AA227DDCC18A803
> Content-Type: text/x-vcard; charset=us-ascii;
> name="hamm.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Peter Hamm
> Content-Disposition: attachment;
> filename="hamm.vcf"
>
> begin:vcard
> n:Hamm;Peter
> tel;cell:+49 171 / 8 98 48 00
> tel;fax:+49 89 / 48 00 24 21
> tel;home:+49 89 / 48 00 24 20
> x-mozilla-html:TRUE
> org:University of Munich;Computer Science
> adr:;;Comeniusstrasse 3 / Rgb;Munich;Bavaria;81667;Germany
> version:2.1
> email;internet:hamm@dbs.informatik.uni-muenchen.de
> x-mozilla-cpt:;2336
> fn:Peter Hamm
> end:vcard
>
> --------------88F5FE3A5AA227DDCC18A803--