-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Sequoia version: 2.10.10 Postgres version: 8.2 Postgres JDBC: 8.2-509 I need some help. I cannot understand the problem. The think is, for testing I setup one controller with one backend (really i have two controllers with one backend each, but one controller is shutdown) So, I load the sequioa sql console, and execute: SELECT * FROM table1 LIMIT 1 OK SELECT * FROM view1 LIMIT 1 OK SELECT * FROM table2 LIMIT 1 Always when I try to get some data from one especified table (it is always the same table) top command shows postgres at 70%-80% If you try to know witch SQLs is being executed in postgres, executing: echo 'SELECT current_query FROM pg_stat_activity;' | /usr/local/pgsql/bin/psql vacadb -p 5432 It shows: - ------ SELECT def.adsrc FROM pg_catalog.pg_class c JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid) LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum) WHERE c.oid = $1 and a.attnum = $2 AND def.adsrc LIKE '%nextval(%' SELECT current_query FROM pg_stat_activity; - ------- If you get the controller log, you have a message that is repeating all the time: [...] 16:06:03,221 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:04,365 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:04,856 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:05,683 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:06,989 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:07,642 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:08,300 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:08,789 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) 16:06:09,277 WARN virtualdatabase.VirtualDatabaseWorkerThread.vvacadb Client (login:vaca,host:192.168.12.8 closed connection with server) [...] ... and go on, until I disable backend. I have no idea what's going on. Any advise would be really appreciated. Thanks in advance -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJSmg9Io1XmbAXRboRAonmAJ9JJq18cNcrgAZk1RyBArGiBCC3kgCdEeSQ hKAcWU+6Y+p0SVNcEu+RbSc= =0k8/ -----END PGP SIGNATURE-----
begin:vcard fn:Ruben Rubio n:Rubio;Ruben org:Rentalia Holidays S.L adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain email;internet:[email protected] tel;work:+34915233104 url:http://www.rentalia.com version:2.1 end:vcard
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
