Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
Original Message:
Sent: Tue February 21, 2023 02:17 AM
From: Suresh Goud B
Subject: unable to select, delete the data and unable to drop the table, response says Long transaction detected
Here is the response of given commands
------------------------------
Suresh Goud B
Original Message:
Sent: Mon February 20, 2023 01:19 PM
From: Art Kagel
Subject: unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help.
Arr
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Mon February 20, 2023 11:31 AM
From: Suresh Goud B
Subject: unable to select, delete the data and unable to drop the table, response says Long transaction detected
Art,
I have come across this issue, The table is filled with so much of data(log). When I am trying to delete/drop it says "Long transaction detected". even I am unable to select the same.
I dont have idea about this table. I am thinking its timeseries log.
Could you please help me to delete the data in it. So that it releases lot of space on the disk.
My goal is to the release the memory.
------------------------------
Suresh Goud B
Original Message:
Sent: Mon February 20, 2023 10:00 AM
From: Art Kagel
Subject: unable to select, delete the data and unable to drop the table, response says Long transaction detected
Suresh:
You do not have enough logical logs defined. Any transaction or combination of transactions that span more than the percent of logical log space documented in the LTXHWM parameter in your ONCONFIG file will trigger the oldest of the open transactions to roll back with a Long Transaction error.
In addition, you appear to:
- either not have sufficient memory on the system to add more to the server to process concurrent requests, or
- you are using a memory limited "Edition" of Informix (such as the Innovator-C Edition which is limited to 2GB of memory or Developer Edition which is limited to 16GB)
- you have SHMTOTAL set to a positive value that is too low to allow additional memory to be allocated
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Mon February 20, 2023 05:27 AM
From: Suresh Goud B
Subject: unable to select, delete the data and unable to drop the table, response says Long transaction detected
Hi,
I am unable to delete the data and unable to drop the table as well. Every time it says Long transaction aborted. Please help on this
------------------------------
Suresh Goud B
------------------------------