Hi,
This is the wrong mailing list but I don't sent it to pgsql-bugs with
success.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings 4 2324
On Thu, Oct 09, 2003 at 04:42:18PM +0200, Thierry Missimilly wrote: I don't know if it is really link to Postgres and ECPG but if you modifiy pgbch.pgc in the way that the transaction is limited to "BEGIN; END; ", it will never hang.
Do you mean it only hangs if you do automatic transaction starting? I
mean if you use PGSQL implicit transactions and explicit BEGIN...END
blocks it works well, but if you let libecpg start the transaction and
just do a COMMIT every once in a while it is not?
Well, i'm not an expert in Linux multi-thread, but it seems the thread
Neither am I, so I have no idea where to look.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: me****@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
I am going to see if I can reproduce the hang.
---------------------------------------------------------------------------
Michael Meskes wrote: On Thu, Oct 09, 2003 at 04:42:18PM +0200, Thierry Missimilly wrote: I don't know if it is really link to Postgres and ECPG but if you modifiy pgbch.pgc in the way that the transaction is limited to "BEGIN; END; ", it will never hang.
Do you mean it only hangs if you do automatic transaction starting? I mean if you use PGSQL implicit transactions and explicit BEGIN...END blocks it works well, but if you let libecpg start the transaction and just do a COMMIT every once in a while it is not?
Well, i'm not an expert in Linux multi-thread, but it seems the thread
Neither am I, so I have no idea where to look.
Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: me****@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
Michael Meskes wrote: On Thu, Oct 09, 2003 at 04:42:18PM +0200, Thierry Missimilly wrote: I don't know if it is really link to Postgres and ECPG but if you modifiy pgbch.pgc in the way that the transaction is limited to "BEGIN; END; ", it will never hang. Do you mean it only hangs if you do automatic transaction starting? I mean if you use PGSQL implicit transactions and explicit BEGIN...END blocks it works well, but if you let libecpg start the transaction and just do a COMMIT every once in a while it is not?
Well, i'm wrong.
A pgbch (pgbench) transcation limited to :
BEGIN;
END;
Will hang too (with the same gdb stack trace), but i need to increase the
number of client to see it.
But, when the doOne() function is just doing :
for (j = 0; j < 1000000; j++) { }
pgbch never hang.
In that case, except doConnect() the lib ecpg is not used at all by the
threads. Well, i'm not an expert in Linux multi-thread, but it seems the thread
Neither am I, so I have no idea where to look.
Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: me****@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
Thierry Missimilly wrote: Please enter a FULL description of your problem: ------------------------------------------------ I think i have a Thread-safe problem. PostgreSQL developpers will find a test program to reproduce it on their lab.
I have, already sent this to pgsql-general and pgsql-hacker, but get back not answers. But neve mind.
I've built Postgresql with the option --enable-thread-safety --with-tcl.
And now run a pgbench like program call pgbch.pgc (attached with this mail).
The main differences of pgbch.pgc are : 1) Pro*c code 2) Multi-threaded 3) Some specific code for Oracle 4) Some specific dynamic trace for debug
I have worked with this user and found they were using EXEC SQL from
different threads, but were not using the "AT" clause to force the
threads to use their own private connection, so there was no threading
bug in our code.
--
Bruce Momjian | http://candle.pha.pa.us pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Slava Gorski |
last post by:
Hi all,
It seems that get diagnostics is not supported by ecpg in postgresql
7.3, I always get the following error when trying to use it:
ERROR: parse error at or near "diagnostics"
For...
|
by: Carmen Gloria Sepulveda Dedes |
last post by:
Hello.
I have a problem with ecpg precompiler.
In a code like:
****
main()
{
.... some calls to EXEC SQL
|
by: Lynn.Tilby |
last post by:
The following program produces the output below...
It is built with:
vrfy_prob: vrfy_prob.cpg
/usr/local/pgsql/bin/ecpg -I/usr/local/pgsql/include -o vrfy_prob.c vrfy_prob.cpg
gcc -g${DEBUG}...
|
by: Lynn.Tilby |
last post by:
I am running 7.1.3... The docs for ecpg in 7.1.3 don't have the -e
option in them!
YET, ecpg -e WORKS!!! for solving the vacuum problem.
Just WHAT does the -e option in ecpg do????
Thanks...
|
by: Lynn.Tilby |
last post by:
I am running 7.1.3 at the moment and upgrading in the
near future.
I am noticing that some cursor declare statements are
commented out in the .c after running the ecpg
pre-processor with no...
|
by: George Gensure |
last post by:
I wanted to ask this on here before going any further.
I've got functions that return rowsets, which from the psql shell require
me to write selects with AS TBL( ... ) to define the return types....
|
by: Christian Rank |
last post by:
Today I ran into problems when combining a C program with SQL statements
with the ECPG interface of PostgreSQL:
According to the documentation, it should be possible with
EXEC SQL WHENEVER NOT...
|
by: Valerie Schneider DSI/DEV |
last post by:
Hi,
I have a set of libraries and C/C++ programs with embedded access to
a PG database. I'm using ecpg. I'm working on a Linux RedHat9 platform.
Until now I was in PG 7.4.2 :
$ ecpg --version...
|
by: Richard Connamacher |
last post by:
I was looking through the docs, ECPG looks like a great tool for developing client
applications.
Anyone know if it's possible to set it up for use with Objective C in XCode on Mac OS X?
XCode...
|
by: jao |
last post by:
My company has a product in beta which uses Postgres 7.4.3. We expect
to have a code freeze for our 1.0 product in March 2005. I'd really
like to use Postgres 8.x in our 1.0 product. We're...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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...
| |