JVM crash when select count(*) on large table through JDBC

Поиск
Список
Период
Сортировка
От Kai Ruhl
Тема JVM crash when select count(*) on large table through JDBC
Дата
Msg-id EA13934D0B77D048A9BFD95BDA9D5C7D1DFC05@ariane5.etamax.site
обсуждение исходный текст
Ответы Re: JVM crash when select count(*) on large table through JDBC  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Hello,

I have a curious problem, which I would like to know whether somebody
can reproduce this: From a JVM using JDBC, I issue

    select count(*) from big_table

where big table has more than 20 million entries (timestamps and
numbers). Upon PreparedStatement.executeQuery(), the VM quits, without
any message.

Java VM: 1.4.2-16 (latest one)
Pg-Jdbc: JDBC3 Postgresql Driver, Version 8.3-603
Server:  PostgreSQL 8.1.11 (on Debian etch)

The most surprising thing is the lack of any error message (I had
expected a TimeOutException, or OutOfMemoryError, or the like), as if
someone had called System.exit().

The same commando, when executed through pgAdmin III, works.

As suggested on the website (http://jdbc.postgresql.org/lists.html), I
have searched the mailing lists, to no avail so far.

I would highly appreciate any reproduction of these results, or
suggestions for remedy.

Kind regards,

  Kai Ruhl


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: UTF8 should be accepted as UNICODE
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: UTF8 should be accepted as UNICODE