Hi:
After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we
are having intermitent issues with certain online PHP transactions,
returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted,
commands ignored until end of transaction block"
Half the times we run the query we get the error, the other half it works.
Any ideas? Thanks.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org 2 4923
On Tue, Oct 05, 2004 at 07:54:23AM +0200, ruben wrote: After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we are having intermitent issues with certain online PHP transactions, returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block"
Some previous query in this transaction has failed. Are there other
error messages before this one? What queries preceded the one that
gives this error?
Half the times we run the query we get the error, the other half it works.
By "half" do you mean exactly 50% of the time, or are you approximating?
Can you identify anything common to the successful transactions that's
different from the failed transactions?
--
Michael Fuhr http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hi Michael:
Michael Fuhr wrote: After upgrading 7.4.2 to 7.4.5 quite smoothly in a Red Hat 8.0 box, we are having intermitent issues with certain online PHP transactions, returning this error:
"Warning: pg_exec() query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block"
Some previous query in this transaction has failed. Are there other error messages before this one? What queries preceded the one that gives this error?
Yes, there is some incompatibility between 7.4.2 and 7.4.5 with INT type
comparisons, not allowing (7.4.5) something like "WHERE int_field = ''",
so the same transaction failed before the error reported with this one:
Warning: pg_exec() query failed: ERROR: invalid input syntax for integer: "" Half the times we run the query we get the error, the other half it works.
By "half" do you mean exactly 50% of the time, or are you approximating? Can you identify anything common to the successful transactions that's different from the failed transactions?
I was approximating. The transaction is exactly the same, I just click
on "UPDATE" button on the web browser and sometimes it worked and
sometimes not.
Thanks a lot.
Ruben.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Abdul-Wahid Paterson |
last post by:
Hi,
I have had a site working for the last 2 years and have had no problems
until at the weekend I replace my database server with a newer one. The
database migration went like a dream and I had the whole db changed over
in 1 hour.
Since the upgrade I have been getting the following error message
sporadically.
|
by: Chris Ochs |
last post by:
I want to do a series of inserts within a single transaction block, but with
postgresql if one insert fails, the whole block is aborted. Is there any
way to get around this behavior so that postgresql won't abort the entire
transaction if a single insert returns an error?
Chris
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
by: Nayt Grochowski |
last post by:
Does anyone see any problem with the loading a SqlConnection into the
System.Web.HttpContextCurrent.Items collection in a Page's Constructor. Then
Closing and Disposing of it the OnUnload method?
Connection would not be "Opened" until it was actually used (this is handled
by a common "Helper" class - similar to Microsoft's SqlHelper Application
Block), Ie:
public class MyPage : Page {
public MyPage() {
|
by: yashgt |
last post by:
Hi,
We have created a SQL server 2000 database. We observe that the
transaction log keeps growing over time. We are now about to run out of
space. We have been periodically shrinking the database. Nevertheless
the size has increased. I would imagine that a transaction log can be
eliminated if we stop the database. Can that be done? Is there a way to
completely wipe off the transaction log?
Thanks,
|
by: subhashree |
last post by:
hi,
i am getting the following error in postgres.can anybody help me?
PrivSubCategoryEntity-getSubCategories:sqlorg.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of
transaction block
PrivSubCategoryProcess-getSubCategories: objReturnTUVClasses.tuvhelper.ErrorObject@3f136e
PrivSubCategoryProcess-getSubCategories: exjava.lang.ClassCastException: TUVClasses.tuvhelper.ErrorObject
| |
by: Ryan Liu |
last post by:
Hi,
I have few db write and read to execute, so I use transaction.
Is that a problem or is that a regular way that I only use transaction on
some cmds only, and other cmds I do not use trasaction, esp those read
actions, or even use another dbconnection to read?
BTW, what does "open table" menas? Is that table only be "open" when someone
read or write it. Once all user finish read or write the db table, the
|
by: =?Utf-8?B?TWloYWx5?= |
last post by:
How can I known if an SqlConnection has or not a transaction opened? I want
some code like this:
private SqlConnection conn;
private void Methode1()
{
SqlConnection conn = new SqlConnection(connectionText);
conn.Open();
SqlCommand cmd = new SqlCommand(commandText, conn);
|
by: ntech |
last post by:
hi,
This is the error that we are getting on postgresql. The error is as follows:
current transaction is aborted. queries ignored until end of the transaction block.
What might be the real cause of the problem and how do we rectify it?
Any suggestions will be appreciable.
|
by: BobRoyAce |
last post by:
Let's say that I am performing a bunch of insert/update queries within
a transaction that is created as follows:
Dim cnn As New
SqlClient.SqlConnection(My.Settings.GRPConnectionString)
cnn.Open()
Dim trx As SqlClient.SqlTransaction = cnn.BeginTransaction()
Further suppose that, in the middle of all of the insert/update
queries, I want to execute a SELECT query against one of the tables
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |