Hello
list,
since I switched from a AMD Athlon based 32bit single core machine to a
64bit quad-core, a cannot run my Postgresql Java
programs.
I do everything using Debian testing. The new machine was installed from
scratch.
Here is the output of "uname
-a":
Linux pcwolfgang 2.6.30-2-amd64 #1 SMP Mon Dec 7 05:21:45 UTC 2009
x86_64
GNU/Linux
I migrated using pg_dump / psql -i without
problems.
On the old machine I had postgresql 8.3, now I have 8.4. Details
below.
The old jdbc driver was called postgresql-8.3-603.jdbc4.jar, currently I
have
postgresql-8.4-701.jdbc4.jar.
I can see and modify my data through psql (through socket as well as
tcp/ip
access).
But running a java program gives me an exception
crash.
Now for the details. I have put the statements between lines of equal
signs, their output directly
following.
================================================================
postgres@pcwolfgang:/root
$ /usr/lib/postgresql/8.4/bin/pg_controldata
================================================================
pg_control-Versionsnummer:
843
Katalogversionsnummer:
200904091
Datenbanksystemidentifikation:
5420760379678260442
Datenbank-Cluster-Status: im
Produktionsmodus
pg_control zuletzt geändert: Mo 25 Jan 2010 18:04:48
CET
Position des letzten Checkpoints:
0/9B91F8
Position des vorletzten Checkpoints:
0/9B91B0
REDO-Position des letzten Checkpoints:
0/9B91F8
TimeLineID des letzten Checkpoints:
1
NextXID des letzten Checkpoints:
0/17583
NextOID des letzten Checkpoints:
16545
NextMultiXactId des letzten Checkpoints:
1
NextMultiOffset des letzten Checkpoints:
0
Zeit des letzten Checkpoints: So 24 Jan 2010 23:35:16
CET
Minimaler Wiederherstellungsendpunkt:
0/0
Maximale Datenausrichtung (Alignment):
8
Datenbankblockgröße:
8192
Blöcke pro Segment:
131072
WAL-Blockgröße:
8192
Bytes pro WAL-Segment:
16777216
Maximale Bezeichnerlänge:
64
Maximale Spalten in einem Index:
32
Maximale Größe eines Stücks TOAST:
1996
Speicherung von Datum/Zeit-Typen:
64-Bit-Ganzzahlen
Übergabe von Float4-Argumenten:
Wert
Übergabe von Float8-Argumenten:
Wert
================================================================
wolfgang@pcwolfgang:~$ pg_lsclusters
================================================================
Version Cluster Port Status Owner Data directory
Log file
8.4 main 5432 online
postgres /var/lib/postgresql/8.4/main /var/log/postgresql/postgresql-8.4-main.log
================================================================
postgres@pcwolfgang:/root$ ps aux | grep -i post
================================================================
postgres 2115 0.0 0.3 102320 6428 ? S 18:04
0:01 /usr/lib/postgresql/8.4/bin/postgres
-D /var/lib/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf
postgres 2120 0.0 0.0 102320 1688 ? Ss 18:04 0:00
postgres: writer
process
postgres 2121 0.0 0.0 102320 1484 ? Ss 18:04 0:00
postgres: wal writer
process
postgres 2122 0.0 0.1 102600 1920 ? Ss 18:04 0:00
postgres: autovacuum launcher
process
postgres 2123 0.0 0.0 74012 1588 ? Ss 18:04 0:00
postgres: stats collector
process
postgres 3731 0.0 0.0 49356 1568 pts/0 S 18:34 0:00 su
postgres
postgres 3739 0.0 0.1 18964 1932 pts/0 S 18:34 0:00
bash
postgres 3748 0.0 0.0 16072 1116 pts/0 R+ 18:35 0:00 ps
aux
postgres 3749 0.0 0.0 9348 936 pts/0 R+ 18:35 0:00 grep -i
post
This is the call to a little example java program. Its code follows
below.
Translation of the phrase in German "Der Verbindungsversuch schlug
fehl." would be "The connection attempt failed."
================================================================
wolfgang@pcwolfgang:~/programming/java/lotto$ java
jdbc_002_driverinfo
================================================================
18:13:26.852 (1) PostgreSQL 8.4 JDBC4 (build
701)
18:13:26.878 (1) Trying to establish a protocol version 3 connection to
127.0.0.1:5432
org.postgresql.util.PSQLException: Der Verbindungsversuch schlug
fehl.
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
at
org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at
org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.access
$100(Driver.java:47)
at org.postgresql.Driver
$ConnectThread.run(Driver.java:308)
at
java.lang.Thread.run(Thread.java:619)
SQLException:
SQLState(08001)
getConnection failed: org.postgresql.util.PSQLException: Der
Verbindungsversuch schlug
fehl.
Exception in thread "main" org.postgresql.util.PSQLException: Der
Verbindungsversuch schlug
fehl.
at org.postgresql.Driver
$ConnectThread.getResult(Driver.java:348)
at
org.postgresql.Driver.connect(Driver.java:271)
at
java.sql.DriverManager.getConnection(DriverManager.java:582)
at
java.sql.DriverManager.getConnection(DriverManager.java:154)
at
jdbc_002_driverinfo.main(jdbc_002_driverinfo.java:19)
Caused by: java.net.SocketException: Network is
unreachable
at java.net.PlainSocketImpl.socketConnect(Native
Method)
at
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at
java.net.Socket.connect(Socket.java:525)
at
java.net.Socket.connect(Socket.java:475)
at
java.net.Socket.<init>(Socket.java:372)
at
java.net.Socket.<init>(Socket.java:186)
at
org.postgresql.core.PGStream.<init>(PGStream.java:62)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at
org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
at
org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at
org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.access
$100(Driver.java:47)
at org.postgresql.Driver
$ConnectThread.run(Driver.java:308)
at
java.lang.Thread.run(Thread.java:619)
This is my little example java program. I have tried all commented-out
versions you will see in the code.
One astounding thing is that I get the same exceptions thrown when
postmaster is not running.
To me it seems that the jdbc driver does not see the database *at
all*.
How this can be, is a complete mystery to
me.
My setup, which did not do any harm on the previous environment, may be
flawed.
But one way or the other, I do not know how to
proceed.
================================================================
wolfgang@pcwolfgang:~/programming/java/lotto$ cat
jdbc_002_driverinfo.java
================================================================
import
java.sql.*;
import
java.util.*;
public class
jdbc_002_driverinfo
{
public static void main( String args[] ) throws
Exception
{
Class.forName( "org.postgresql.Driver" );
//Connection conn =
DriverManager.getConnection( "jdbc:postgresql:lotto", "wolfgang",
"null" );
//Connection conn =
DriverManager.getConnection( "jdbc:postgresql://127.0.0.1:5432/lotto",
"wolfgang", "" );
//String url = "jdbc:postgresql://localhost:5432/lotto";
String url = "jdbc:postgresql://127.0.0.1:5432/lotto";
Properties props = new Properties();
props.setProperty("user","wolfgang");
props.setProperty("password","");
props.setProperty("loglevel","2");
props.setProperty("socketTimeout","10");
props.setProperty("loginTimeout","10");
props.setProperty("tcpKeepAlive","true");
Connection conn = DriverManager.getConnection(url, props);
DatabaseMetaData meta = conn.getMetaData();
System.out.println( "Produkt: " + meta.getDatabaseProductName() );
System.out.println( "Version: " +
meta.getDatabaseProductVersion() );
System.out.println( "Anzahl erlaubter Verbindungen: " +
meta.getMaxConnections() );
System.out.println( "Version des DB-Treibers : " +
meta.getDriverVersion() );
System.out.println( "Update im Batchbetrieb : " +
meta.supportsBatchUpdates() );
System.out.println( "Gespeicherte Prozeduren : " +
meta.supportsStoredProcedures() );
conn.close ();
}
}
Last, here is the extract of my postgresql configuration. Pretty much
standard.
================================================================
pcwolfgang:~# grep ^[[:alpha:]] /etc/postgresql/8.4/main/postgresql.conf
| cut -d"#" -f 1
================================================================
data_directory = '/var/lib/postgresql/8.4/main'
hba_file = '/etc/postgresql/8.4/main/pg_hba.conf'
ident_file = '/etc/postgresql/8.4/main/pg_ident.conf'
external_pid_file = '/var/run/postgresql/8.4-main.pid'
listen_addresses = 'localhost, 127.0.0.1'
port = 5432
max_connections = 100
unix_socket_directory = '/var/run/postgresql'
ssl = false
shared_buffers = 24MB
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
client_min_messages = log
log_min_messages = info
log_min_error_statement = info
log_line_prefix = '%t '
datestyle = 'iso, dmy'
lc_messages = 'de_DE.UTF-8'
lc_monetary = 'de_DE.UTF-8'
lc_numeric = 'de_DE.UTF-8'
lc_time = 'de_DE.UTF-8'
default_text_search_config = 'pg_catalog.german'
The database and all clients accessing it are strictly local.
So, basically I have no access restrictions.
================================================================
pcwolfgang:~# grep -v ^$ /etc/postgresql/8.4/main/pg_hba.conf | grep -v
^#
================================================================
local postgres postgres trust
local all postgres ident
local all wolfgang trust
host all wolfgang 127.0.0.1/32 trust
host all wolfgang ::1/128 trust
Any help is very much appreciated.
Regards,
Wolfgang Rinnert
