Weird pause when running statements
От | Grant Quimby |
---|---|
Тема | Weird pause when running statements |
Дата | |
Msg-id | 1816F2D2ACB8AB469D3FFA6819ADC23B154A8F720C@bnemxbox01.dialoggroup.internal обсуждение исходный текст |
Ответы |
Re: Weird pause when running statements
|
Список | pgsql-jdbc |
Hi, I've done some research and this appears to be a unique problem. During an ETL process using the 8.3-603 JDBC3 driver with Pentaho Data Integration the transactions and everything stopsprocessing. No disk access, No process activity, Nothing. The Postgres processes are still present. After reloading the server configuration the processes just start off where they stopped and continue normally. Sometimesthey stop again, the same workaround sets the process running again. However trying to deploy this process to aserver means that those pauses are unacceptable. This appears to be a problem with the driver and/or the server. Anybodyhave any suggestions? I'd rather not have to port everything to another DBMS. Thanks in advance. Regards, Grant Quimby Consultant Dialog Information Technology Ph: +61 2 6209 2600 Fx: +61 2 6209 2602 grant_quimby@dialog.com.au
В списке pgsql-jdbc по дате отправления: