Обсуждение: Postgres Server Jdbc driver error

We get error with the following query where the paramater is 'att', the query return result if the parameter is different than 'att'.

Probably a bug.

the postgresql log is:

2011-08-04 10:44:56 CEST [28741]: [59238-1] LOG: execute S_1: BEGIN
2011-08-04 10:44:56 CEST [28741]: [59239-1] LOG: duration: 0.019 ms
2011-08-04 10:44:56 CEST [28741]: [59240-1] LOG: duration: 0.099 ms
2011-08-04 10:44:56 CEST [28741]: [59241-1] LOG: duration: 1.774 ms
2011-08-04 10:44:56 CEST [28741]: [59242-1] LOG: execute <unnamed>: select this_.trouble_ticket_id as y0_ from helpdesk.batch_sequences this_ where (this_.comment ilike $1 or this_.tech_note ilike $2)
2011-08-04 10:44:56 CEST [28741]: [59243-1] DETAIL: parameters: $1 = '%att%', $2 = '%att%'
2011-08-04 10:44:57 CEST [28741]: [59244-1] LOG: duration: 896.461 ms
2011-08-04 10:44:57 CEST [28741]: [59245-1] LOG: incomplete message from client
2011-08-04 10:44:57 CEST [28741]: [59246-1] LOG: disconnection: session time: 21:43:01.890 user=j01t02 database=webtng host=jblade01.sdb.it port=38173

On the Tomcat side we get followin message:


Caused by: java.io.IOException: Tried to send an out-of-range integer as a 2-byte value: 34027
at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201)
at org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:1236)
at org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1508)
at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1097)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)


Any comment higly appreciated

-- 
Silvio Brandani

2011/8/4 Silvio Brandani <silvio.brandani@tech.sdb.it>:

> On the Tomcat side we get followin message:
>
>
> Caused by: java.io.IOException: Tried to send an out-of-range integer as a
> 2-byte value: 34027
> at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201)
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:1236)
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1508)
> at
> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1097)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

What is the query that triggers this exception? (Not the one logged on
the server side, it is the next query that's the problem)
Taking the exception at face value implies that your query has 34,027
parameters, which seems somewhat unlikely (!!) unless you have a badly
garbled query string.

Oliver

Il 04/08/2011 13.00, Oliver Jowett ha scritto:
> 2011/8/4 Silvio Brandani<silvio.brandani@tech.sdb.it>:
>
>> On the Tomcat side we get followin message:
>>
>>
>> Caused by: java.io.IOException: Tried to send an out-of-range integer as a
>> 2-byte value: 34027
>> at org.postgresql.core.PGStream.SendInteger2(PGStream.java:201)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:1236)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1508)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:1097)
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> What is the query that triggers this exception? (Not the one logged on
> the server side, it is the next query that's the problem)
> Taking the exception at face value implies that your query has 34,027
> parameters, which seems somewhat unlikely (!!) unless you have a badly
> garbled query string.
>
> Oliver
>
thanks for the support, we find the bug in the application , we will
limt the number of parameters.



--
Silvio Brandani


---






Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche
quandoli comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi
diritti,sono riportate alla pagina http://www.savinodelbene.com/privacy.html 
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli
eventualiallegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html 
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei
all'attivitàlavorativa o contrari a norme. 
--