Re: idle in transaction problem

["Oilid Adsi" <Oilid(dot)Adsi(at)freenet-ag(dot)de>]

Symantec Mail Security replaced Message Body with this text message.  The original file was unscannable and was quarantined.

ID:FNHH-SVMEXFE002::SYQ1dc46acaa

15:31:05.990 (1) PostgreSQL 8.3devel JDBC3 with SSL (build 600)
15:31:05.998 (1) Trying to establish a protocol version 3 connection to 194.97.110.106:5432
15:31:06.007 (1)  FE=> StartupPacket(user=whitelabel_service, database=vitrado, client_encoding=UNICODE, DateStyle=ISO)
15:31:06.009 (1)  <=BE AuthenticationReqMD5(salt=53855318)
15:31:06.010 (1)  FE=> Password(md5digest=md5dc90b78c11e3b15462bffbaa05687497)
15:31:06.014 (1)  <=BE AuthenticationOk
15:31:06.029 (1)  <=BE ParameterStatus(client_encoding = UNICODE)
15:31:06.029 (1)  <=BE ParameterStatus(DateStyle = ISO, DMY)
15:31:06.029 (1)  <=BE ParameterStatus(integer_datetimes = on)
15:31:06.029 (1)  <=BE ParameterStatus(is_superuser = off)
15:31:06.029 (1)  <=BE ParameterStatus(server_encoding = UTF8)
15:31:06.029 (1)  <=BE ParameterStatus(server_version = 8.1.4)
15:31:06.029 (1)  <=BE ParameterStatus(session_authorization = whitelabel_service)
15:31:06.030 (1)  <=BE ParameterStatus(standard_conforming_strings = off)
15:31:06.030 (1)  <=BE ParameterStatus(TimeZone = Europe/Berlin)
15:31:06.030 (1)  <=BE BackendKeyData(pid=5503,ckey=1736595556)
15:31:06.030 (1)  <=BE ReadyForQuery(I)
15:31:06.030 (1)     compatible = 8.3
15:31:06.030 (1)     loglevel = 2
15:31:06.030 (1)     prepare threshold = 5
getConnection returning driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)1f21c50]
15:31:06.075 (1) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)11c5c88, maxRows=0, fetchSize=0, flags=17
15:31:06.075 (1)  FE=> Parse(stmt=null,query="SHOW TRANSACTION ISOLATION LEVEL",oids={})
15:31:06.075 (1)  FE=> Bind(stmt=null,portal=null)
15:31:06.075 (1)  FE=> Describe(portal=null)
15:31:06.075 (1)  FE=> Execute(portal=null,limit=0)
15:31:06.075 (1)  FE=> Sync
15:31:06.076 (1)  <=BE ParseComplete [null]
15:31:06.076 (1)  <=BE BindComplete [null]
15:31:06.077 (1)  <=BE RowDescription(1)
15:31:06.078 (1)  <=BE DataRow
15:31:06.078 (1)  <=BE CommandStatus(SHOW)
15:31:06.093 (1)  <=BE ReadyForQuery(I)
15:31:06.093 (1) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)3e8ad1, maxRows=0, fetchSize=0, flags=23
15:31:06.093 (1)  FE=> Parse(stmt=null,query="SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE",oids={})
15:31:06.093 (1)  FE=> Bind(stmt=null,portal=null)
15:31:06.094 (1)  FE=> Execute(portal=null,limit=1)
15:31:06.094 (1)  FE=> Sync
15:31:06.096 (1)  <=BE ParseComplete [null]
15:31:06.096 (1)  <=BE BindComplete [null]
15:31:06.096 (1)  <=BE CommandStatus(SET)
15:31:06.096 (1)  <=BE ReadyForQuery(I)
15:31:06.135 (1) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)a53564, maxRows=0, fetchSize=0, flags=1
15:31:06.136 (1)  FE=> Parse(stmt=S_1,query="BEGIN",oids={})
15:31:06.136 (1)  FE=> Bind(stmt=S_1,portal=null)
15:31:06.136 (1)  FE=> Execute(portal=null,limit=0)
15:31:06.137 (1)  FE=> Parse(stmt=null,query="SELECT t0.angelegt, t0.bezeichnung, t0.nochange_allowed, t0.partner_aktiv, t0.partner_id, t0.produktanbieter_akt
iv, t0.produkte_id, t0.werbearten_id, t0.id FROM public.tracking t0 LIMIT 2",oids={})
15:31:06.137 (1)  FE=> Bind(stmt=null,portal=null)
15:31:06.137 (1)  FE=> Describe(portal=null)
15:31:06.137 (1)  FE=> Execute(portal=null,limit=0)
15:31:06.137 (1)  FE=> Sync
15:31:06.141 (1)  <=BE ParseComplete [S_1]
15:31:06.141 (1)  <=BE BindComplete [null]
15:31:06.141 (1)  <=BE CommandStatus(BEGIN)
15:31:06.142 (1)  <=BE ParseComplete [null]
15:31:06.142 (1)  <=BE BindComplete [null]
15:31:06.142 (1)  <=BE RowDescription(9)
15:31:06.142 (1)  <=BE DataRow
15:31:06.142 (1)  <=BE DataRow
15:31:06.142 (1)  <=BE CommandStatus(SELECT)
15:31:06.142 (1)  <=BE ReadyForQuery(T)


15:33:08.244 (2) PostgreSQL 8.3devel JDBC3 with SSL (build 600)
15:33:08.244 (2) Trying to establish a protocol version 3 connection to 194.97.110.106:5432
15:33:08.245 (2)  FE=> StartupPacket(user=whitelabel_service, database=vitrado, client_encoding=UNICODE, DateStyle=ISO)
15:33:08.248 (2)  <=BE AuthenticationReqMD5(salt=5578a668)
15:33:08.248 (2)  FE=> Password(md5digest=md543adaaf299bbf604a883c13f60adb698)
15:33:08.255 (2)  <=BE AuthenticationOk
15:33:08.256 (2)  <=BE ParameterStatus(client_encoding = UNICODE)
15:33:08.256 (2)  <=BE ParameterStatus(DateStyle = ISO, DMY)
15:33:08.256 (2)  <=BE ParameterStatus(integer_datetimes = on)
15:33:08.256 (2)  <=BE ParameterStatus(is_superuser = off)
15:33:08.256 (2)  <=BE ParameterStatus(server_encoding = UTF8)
15:33:08.256 (2)  <=BE ParameterStatus(server_version = 8.1.4)
15:33:08.256 (2)  <=BE ParameterStatus(session_authorization = whitelabel_service)
15:33:08.257 (2)  <=BE ParameterStatus(standard_conforming_strings = off)
15:33:08.257 (2)  <=BE ParameterStatus(TimeZone = Europe/Berlin)
15:33:08.257 (2)  <=BE BackendKeyData(pid=5850,ckey=143834877)
15:33:08.257 (2)  <=BE ReadyForQuery(I)
15:33:08.257 (2)     compatible = 8.3
15:33:08.257 (2)     loglevel = 2
15:33:08.257 (2)     prepare threshold = 5
getConnection returning driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)1f21c50]
15:33:08.258 (2) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)37b90c, maxRows=0, fetchSize=0, flags=17
15:33:08.258 (2)  FE=> Parse(stmt=null,query="SHOW TRANSACTION ISOLATION LEVEL",oids={})
15:33:08.258 (2)  FE=> Bind(stmt=null,portal=null)
15:33:08.258 (2)  FE=> Describe(portal=null)
15:33:08.258 (2)  FE=> Execute(portal=null,limit=0)
15:33:08.258 (2)  FE=> Sync
15:33:08.259 (2)  <=BE ParseComplete [null]
15:33:08.259 (2)  <=BE BindComplete [null]
15:33:08.259 (2)  <=BE RowDescription(1)
15:33:08.260 (2)  <=BE DataRow
15:33:08.260 (2)  <=BE CommandStatus(SHOW)
15:33:08.260 (2)  <=BE ReadyForQuery(I)
15:33:08.260 (2) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)55cf3f, maxRows=0, fetchSize=0, flags=23
15:33:08.260 (2)  FE=> Parse(stmt=null,query="SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE",oids={})
15:33:08.260 (2)  FE=> Bind(stmt=null,portal=null)
15:33:08.260 (2)  FE=> Execute(portal=null,limit=1)
15:33:08.260 (2)  FE=> Sync
15:33:08.261 (2)  <=BE ParseComplete [null]
15:33:08.261 (2)  <=BE BindComplete [null]
15:33:08.261 (2)  <=BE CommandStatus(SET)
15:33:08.261 (2)  <=BE ReadyForQuery(I)
15:33:08.267 (2) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)1707653, maxRows=0, fetchSize=0, flags=1
15:33:08.267 (2)  FE=> Parse(stmt=S_1,query="BEGIN",oids={})
15:33:08.268 (2)  FE=> Bind(stmt=S_1,portal=null)
15:33:08.268 (2)  FE=> Execute(portal=null,limit=0)
15:33:08.268 (2)  FE=> Parse(stmt=null,query="SELECT wm.views, wm.clicks, datum FROM (
   SELECT sum(prepare.views) AS views, sum(prepare.clicks) AS clicks,  prepare.datum AS datum       FROM (
      SELECT      tracking_id, summe_views AS views, summe_clicks AS clicks, datum FROM        statistik_partner_tag WHERE       partner_id = 783028 AND
   (werbearten_id = 3 OR 0 = 3) AND         date_trunc('MONTH', datum) = date_trunc('MONTH', 'Sat Sep 30 01:00:00 CEST 2006'::date)
   ) AS prepare       GROUP BY  prepare.datum
) AS wm ORDER BY datum",oids={})
15:33:08.268 (2)  FE=> Bind(stmt=null,portal=null)
15:33:08.268 (2)  FE=> Describe(portal=null)
15:33:08.268 (2)  FE=> Execute(portal=null,limit=0)
15:33:08.268 (2)  FE=> Sync
15:33:28.451 (2)  <=BE ParseComplete [S_1]
15:33:28.451 (2)  <=BE BindComplete [null]
15:33:28.451 (2)  <=BE CommandStatus(BEGIN)
15:33:28.452 (2)  <=BE ParseComplete [null]
15:33:28.452 (2)  <=BE BindComplete [null]
15:33:28.452 (2)  <=BE RowDescription(3)
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.452 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.453 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE DataRow
15:33:28.454 (2)  <=BE CommandStatus(SELECT)
15:33:28.454 (2)  <=BE ReadyForQuery(T)
15:33:28.461 (2) simple execute, handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Connection$TransactionCommandHandler(at)267b76, maxRows=0, fetchSize=0, flags=22
15:33:28.461 (2)  FE=> Parse(stmt=S_2,query="COMMIT",oids={})
15:33:28.461 (2)  FE=> Bind(stmt=S_2,portal=null)
15:33:28.461 (2)  FE=> Execute(portal=null,limit=1)
15:33:28.461 (2)  FE=> Sync
15:33:28.462 (2)  <=BE ParseComplete [S_2]
15:33:28.462 (2)  <=BE BindComplete [null]
15:33:28.462 (2)  <=BE CommandStatus(COMMIT)
15:33:28.462 (2)  <=BE ReadyForQuery(I)