Search Postgresql Archives

currval of sequence xxx_seq is not yet defined in this session?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



HI,everybody:

recently i found some errors in pg_log when i do some pressure testing,looks
like

 "2013-01-05 21:48:29.870
CST,"postgres","wedding",15850,"172.25.10.28:37100",50e82f2d.3dea,1,"SELECT",2013-01-05
21:48:29 CST,19/80509,0,ERROR,55000,"currval of sequence
""t_wedding_wedding_id_seq"" is not yet defined in this session"
,,,,,,"    SELECT currval('t_wedding_wedding_id_seq')as weddingId         
",,,""
2013-01-05 21:48:29.984
CST,"postgres","wedding",15856,"172.25.10.28:37123",50e82f2d.3df0,1,"SELECT",2013-01-05
21:48:29 CST,25/91770,0,ERROR,55000,"currval of sequence
""t_wedding_wedding_id_seq"" is not yet defined in this session"
,,,,,,"    SELECT currval('t_wedding_wedding_id_seq')as weddingId      "


the code is 

begin;
		insert into t_wedding(wedding_id,share_id,share_type,user_id,wedding_time)
		select nextval('t_wedding_wedding_id_seq')
		,#ShareId#,#shareType#,#userId#,#weddingTime#
		<selectKey resultClass="int" keyProperty="weddingId">
			SELECT currval('t_wedding_wedding_id_seq')as weddingId 
        </selectKey>
		;
		COMMIT;

the column wedding_id type is serial + primary key, and i set the sequence
cache from 1 to 50,errors still exists,but reduced。

I use ibatis,but it seems not support returning wedding_id !!!

MY environment:
Postgres 9.1.2
ibatis
pgbouncer ( Transaction mode )
Postgres-9.1-901.jdbc4.jar  as my drive

As i used *begin *  to wrapped it as a transaction, then why zhe errors
still occurs ?





--
View this message in context: http://postgresql.1045698.n5.nabble.com/currval-of-sequence-xxx-seq-is-not-yet-defined-in-this-session-tp5738893.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux