Re: transaction and insert

Thanks for your advice.

But question is that it is working in first 30 or 50 tests. After that, I
have this problem. I have also increased the memory but it is not working.

It is the same as PostgreSQL version 10.

Regards,

Jack

On Thu, Jul 18, 2019 at 4:37 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> aOn Wed, Jul 17, 2019 at 11:24 AM jack chen <jackchen88(at)gmail(dot)com> wrote:
>
>> Can anyone help me? It looks like that it is real bug.
>>
>
> Mostly likely but its your application's bug, not PostgreSQL's.
>
>
>
>> When I use the PostgreSQL 10, it happen to me. After that, I have
>> upgraded my PostgreSQL to version 11 with new JDBC. It is the same as
>> before,
>>
>
> Expected...
>
>
>> eg. I have a transaction block with sql select and insert statements. At
>> the beginning, eg. it is working fine at first 30 or 50 tests. After that,
>> I have unusual error, eg. when I comment out the transaction statements
>> (begin and commit), it works fine again.
>>
>
> Doubtful, you probably still have an error you are probably just ignoring
> it when you forgo transactions.
>
> Can anyone tell me how to debug this? Or how to output more error
>> information?
>>
>
> Focus on debugging and instrumenting your application until it sees the
> error and then dump out the data the application is sending to the server.
>
>
>> Or anyone can give a clue what is the problem. Is it memory not enough or
>> cache not enough? I also have run vacuum and restart the PostgreSQL, the
>> error still exists.
>>
>
> Given the error message below your problem is happening during data
> ingestion and does not likely pertain to any data already existing in
> tables or indexes. Vaccum/memory/cache have nothing to do with it.
>
> The error is : ERROR: invalid input syntax for integer:
>>
>
> Server log for PostgreSQL or, probably more usefully, the application log
> of the problem that sending what appears to be an empty string and
> expecting the server to convert that into an integer. The empty string
> cannot be cast to integer, only numbers and NULL can be.
>
> David J.
>
>