agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] Errors running pljava test
8+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Errors running pljava test
@ 2005-09-08 04:22 
  2005-09-08 06:23 ` [Pljava-dev] Errors running pljava test 
  2005-09-08 06:57 ` [Pljava-dev] Errors running pljava test 
  0 siblings, 2 replies; 8+ messages in thread

From:  @ 2005-09-08 04:22 UTC (permalink / raw)

Hi,

I was running pljava test.  The test hung in the middle and I found the 
following errors in postgresql.log file.

What else have I missed?

Thank you so much for help.

Regards,
Kong


==================================================================
LOG:  Exception
LOG:  in thread "main"
java.lang.SecurityException: write on /tmp/pljava25013.test
        at 
org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
        at java.io.File.checkAndCreate(File.java:1306)
        at java.io.File.createTempFile(File.java:1402)
        at java.io.File.createTempFile(File.java:1439)
        at 
org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
ERROR:  java.lang.SecurityException: write on /tmp/pljava25013.test
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
LOG:  Exception
LOG:  in thread "main"
java.lang.SecurityException: write on /tmp/pljava25015.test
        at 
org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
        at java.io.File.checkAndCreate(File.java:1306)
        at java.io.File.createTempFile(File.java:1402)
        at java.io.File.createTempFile(File.java:1439)
        at 
org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
ERROR:  java.lang.SecurityException: write on /tmp/pljava25015.test
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
LOG:  Exception
LOG:  in thread "main"
java.lang.SecurityException: write on /tmp/pljava25017.test
        at 
org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
        at java.io.File.checkAndCreate(File.java:1306)
        at java.io.File.createTempFile(File.java:1402)
        at java.io.File.createTempFile(File.java:1439)
        at 
org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
ERROR:  java.lang.SecurityException: write on /tmp/pljava25017.test
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
LOG:  Exception
LOG:  in thread "main"
java.lang.SecurityException: write on /tmp/pljava25019.test
        at 
org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128)
        at 
org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106)
        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
        at java.io.File.checkAndCreate(File.java:1306)
        at java.io.File.createTempFile(File.java:1402)
        at java.io.File.createTempFile(File.java:1439)
        at 
org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
ERROR:  java.lang.SecurityException: write on /tmp/pljava25019.test
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: getAttributes
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTables
LOG:  Exception
LOG:  in thread "main"
java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
        at 
org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
        at 
org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22)
ERROR:  java.sql.SQLException: 
org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
supported: DatabaseMetaData.getSuperTypes
ERROR:  invalid regular expression: quantifier operand invalid





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
@ 2005-09-08 06:23 ` 
  1 sibling, 0 replies; 8+ messages in thread

From:  @ 2005-09-08 06:23 UTC (permalink / raw)

The first test you run tests the security. The error you get is proof 
that the security works. Other tests are jogging the meta-data feature 
and some features are not yet implemented. The output you see is to be 
expected when running the tests. It shouldn't hang though. Are you sure 
it does? Some tests take a long time to run.

I see you got past the previous problem? Was it a problem with the JDBC 
driver?

Regards,
Thomas Hallgren

kstian wrote:

> Hi,
>
> I was running pljava test.  The test hung in the middle and I found 
> the following errors in postgresql.log file.
>
> What else have I missed?
>
> Thank you so much for help.
>
> Regards,
> Kong
>
>
> ==================================================================
> LOG:  Exception
> LOG:  in thread "main"
> java.lang.SecurityException: write on /tmp/pljava25013.test
>        at 
> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>
>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>        at java.io.File.checkAndCreate(File.java:1306)
>        at java.io.File.createTempFile(File.java:1402)
>        at java.io.File.createTempFile(File.java:1439)
>        at 
> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
> ERROR:  java.lang.SecurityException: write on /tmp/pljava25013.test
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
> LOG:  Exception
> LOG:  in thread "main"
> java.lang.SecurityException: write on /tmp/pljava25015.test
>        at 
> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>
>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>        at java.io.File.checkAndCreate(File.java:1306)
>        at java.io.File.createTempFile(File.java:1402)
>        at java.io.File.createTempFile(File.java:1439)
>        at 
> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
> ERROR:  java.lang.SecurityException: write on /tmp/pljava25015.test
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
> LOG:  Exception
> LOG:  in thread "main"
> java.lang.SecurityException: write on /tmp/pljava25017.test
>        at 
> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>
>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>        at java.io.File.checkAndCreate(File.java:1306)
>        at java.io.File.createTempFile(File.java:1402)
>        at java.io.File.createTempFile(File.java:1439)
>        at 
> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
> ERROR:  java.lang.SecurityException: write on /tmp/pljava25017.test
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
> LOG:  Exception
> LOG:  in thread "main"
> java.lang.SecurityException: write on /tmp/pljava25019.test
>        at 
> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>
>        at 
> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>
>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>        at java.io.File.checkAndCreate(File.java:1306)
>        at java.io.File.createTempFile(File.java:1402)
>        at java.io.File.createTempFile(File.java:1439)
>        at 
> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
> ERROR:  java.lang.SecurityException: write on /tmp/pljava25019.test
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: getAttributes
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTables
> LOG:  Exception
> LOG:  in thread "main"
> java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
>        at 
> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>        at 
> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>
> ERROR:  java.sql.SQLException: 
> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
> supported: DatabaseMetaData.getSuperTypes
> ERROR:  invalid regular expression: quantifier operand invalid
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev







^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
@ 2005-09-08 06:57 ` 
  2005-09-08 07:14   ` [Pljava-dev] Errors running pljava test 
  2005-09-08 09:40   ` [Pljava-dev] Errors running pljava test 
  1 sibling, 2 replies; 8+ messages in thread

From:  @ 2005-09-08 06:57 UTC (permalink / raw)

Hi Thomas,

Thanks a lot for clarifying.  The previous problem was indeed due to 
JDBC driver.  I downloaded jdbc3 and I also needed to add an overloaded 
sqlj.replace_jar (CREATE FUNCTION sqlj.replace_jar(BYTEA, VARCHAR, 
BOOLEAN) RETURNS void")) in Deployer.java in order to build the test.

There is one other thing I observed while running pljava test:

- Before running pljava test, postgresql \z command listed all tables in 
my DB: username_test, mdt, employees1, and employees2.
- After running pljava test, postgresql \z command DID NOT list any of 
these tables, and I could not access to these tables.

pljava test did hang.  I had been waiting for 10 minutes.  The following 
is the on-screeen output while running pljava test:

=============================================================
java org.postgresql.pljava.test.Tester -database kstiandb -user postgres
*** testTimestamp()
Timestamp = 2005-09-08 14:51:41.226, Timestamptz = 2005-09-08 14:51:41.226
*** testInt()
54 + 2 = 56
nullOnEven(1) = 1
nullOnEven(2) = null
*** testInsertUsernameTrigger()
Name = "nothing", username = "thomas"
Name = "null", username = "postgres"
Name = "empty string", username = ""
Name = "space", username = " "
Name = "tab", username = "      "
Name = "name", username = "name"
*** testModdatetimeTrigger()
Id = "1", idesc = "first", moddate = "2005-09-08 14:51:40.852818"
Id = "2", idesc = "second", moddate = "2005-09-08 14:51:40.854792"
Id = "3", idesc = "third", moddate = "2005-09-08 14:51:40.856547"
Id = "4", idesc = "first", moddate = "2005-09-08 14:51:41.724"
Id = "5", idesc = "second", moddate = "2005-09-08 14:51:41.78"
Id = "6", idesc = "third", moddate = "2005-09-08 14:51:41.788"
*** testSPIActions()
Id = "3", name = "Rebecka Shawn", salary = "30000"
Id = "4", name = "Priscilla Johnson", salary = "25000"
*** testComplexReturn()
Base = "1", incbase = "6", ctime = "2005-09-08 14:51:41.1"
*** testSetReturn()
Base = "1", incbase = "1", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "6", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "11", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "16", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "21", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "26", ctime = "2005-09-08 14:51:41.108"
Base = "1", incbase = "31", ctime = "2005-09-08 14:51:41.158"
Base = "1", incbase = "36", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "41", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "46", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "51", ctime = "2005-09-08 14:51:41.16"
Base = "1", incbase = "56", ctime = "2005-09-08 14:51:41.16"
*** testCallInCall()
Max = "10"
*** testCurrentDir()
Server directory = /var/lib/postgresql/data/base/102676
*** testUsingProperties()
Name = "first.example.property", value = "1"
Name = "third.example.property", value = ""Hmm, take a guess. Could it 
be three?""
Name = "second.example.property", value = "two"
*** testUsingScalarProperties()
first.example.property = 1
third.example.property = "Hmm, take a guess. Could it be three?"
second.example.property = two
*** testUsingResultSetProperties()
Name = "first.example.property", value = "1"
Name = "third.example.property", value = ""Hmm, take a guess. Could it 
be three?""
Name = "second.example.property", value = "two"
*** testSavepointSanity()
Savepoint sanity = 1
*** testTrustedSecurity()
OK, creation of temp file was *unsuccessful* as it should be
*** testUntrustedSecurity()
Name of created temp file = /tmp/pljava23491.test
*** testBinaryColumns()

============================================================

There was no more printout after "*** testBinaryColumns()".

Thank yo so much for help to resolve this.

Regards,
Kong

Thomas Hallgren wrote:

> The first test you run tests the security. The error you get is proof 
> that the security works. Other tests are jogging the meta-data feature 
> and some features are not yet implemented. The output you see is to be 
> expected when running the tests. It shouldn't hang though. Are you 
> sure it does? Some tests take a long time to run.
>
> I see you got past the previous problem? Was it a problem with the 
> JDBC driver?
>
> Regards,
> Thomas Hallgren
>
> kstian wrote:
>
>> Hi,
>>
>> I was running pljava test.  The test hung in the middle and I found 
>> the following errors in postgresql.log file.
>>
>> What else have I missed?
>>
>> Thank you so much for help.
>>
>> Regards,
>> Kong
>>
>>
>> ==================================================================
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25013.test
>>        at 
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>>
>>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>>        at java.io.File.checkAndCreate(File.java:1306)
>>        at java.io.File.createTempFile(File.java:1402)
>>        at java.io.File.createTempFile(File.java:1439)
>>        at 
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR:  java.lang.SecurityException: write on /tmp/pljava25013.test
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25015.test
>>        at 
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>>
>>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>>        at java.io.File.checkAndCreate(File.java:1306)
>>        at java.io.File.createTempFile(File.java:1402)
>>        at java.io.File.createTempFile(File.java:1439)
>>        at 
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR:  java.lang.SecurityException: write on /tmp/pljava25015.test
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25017.test
>>        at 
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>>
>>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>>        at java.io.File.checkAndCreate(File.java:1306)
>>        at java.io.File.createTempFile(File.java:1402)
>>        at java.io.File.createTempFile(File.java:1439)
>>        at 
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR:  java.lang.SecurityException: write on /tmp/pljava25017.test
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.lang.SecurityException: write on /tmp/pljava25019.test
>>        at 
>> org.postgresql.pljava.internal.Backend$2.assertPermission(Backend.java:187) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.nonRecursiveCheck(Backend.java:128) 
>>
>>        at 
>> org.postgresql.pljava.internal.Backend$PLJavaSecurityManager.checkPermission(Backend.java:106) 
>>
>>        at java.lang.SecurityManager.checkWrite(SecurityManager.java:954)
>>        at java.io.File.checkAndCreate(File.java:1306)
>>        at java.io.File.createTempFile(File.java:1402)
>>        at java.io.File.createTempFile(File.java:1439)
>>        at 
>> org.postgresql.pljava.example.Security.createTempFile(Security.java:26)
>> ERROR:  java.lang.SecurityException: write on /tmp/pljava25019.test
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: getAttributes
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTables
>> LOG:  Exception
>> LOG:  in thread "main"
>> java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.<init>(MetaDataTest.java:101)
>>        at 
>> org.postgresql.pljava.example.MetaDataTest.callMetaDataMethod(MetaDataTest.java:22) 
>>
>> ERROR:  java.sql.SQLException: 
>> org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature not 
>> supported: DatabaseMetaData.getSuperTypes
>> ERROR:  invalid regular expression: quantifier operand invalid
>>
>> _______________________________________________
>> Pljava-dev mailing list
>> Pljava-dev at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>
>
>
>
>





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
  2005-09-08 06:57 ` [Pljava-dev] Errors running pljava test 
@ 2005-09-08 07:14   ` 
  1 sibling, 0 replies; 8+ messages in thread

From:  @ 2005-09-08 07:14 UTC (permalink / raw)

kstian wrote:

> Hi Thomas,
>
> Thanks a lot for clarifying.  The previous problem was indeed due to 
> JDBC driver.  I downloaded jdbc3 and I also needed to add an 
> overloaded sqlj.replace_jar (CREATE FUNCTION sqlj.replace_jar(BYTEA, 
> VARCHAR, BOOLEAN) RETURNS void")) in Deployer.java in order to build 
> the test.

Ouch. I've been using the src/sql/install.sql script lately and forgot 
to add the BYTEA variants to the deployer. I'll fix that.

> There is one other thing I observed while running pljava test:
>
> - Before running pljava test, postgresql \z command listed all tables 
> in my DB: username_test, mdt, employees1, and employees2.
> - After running pljava test, postgresql \z command DID NOT list any of 
> these tables, and I could not access to these tables.

The tables (and functions) are all installed when the examples.jar is 
loaded and removed when you issue a remove_jar call on the examples.jar. 
The creation and removal are handled by the deployment descriptor inside 
that jar (see src/java/examples/deployment/examples.ddr.

> pljava test did hang.  I had been waiting for 10 minutes.  The 
> following is the on-screeen output while running pljava test:

What JVM are you using?

Regards,
Thomas Hallgren






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
  2005-09-08 06:57 ` [Pljava-dev] Errors running pljava test 
@ 2005-09-08 09:40   ` 
  2005-09-09 09:08     ` [Pljava-dev] Errors running pljava test 
  1 sibling, 1 reply; 8+ messages in thread

From:  @ 2005-09-08 09:40 UTC (permalink / raw)

I am using Blackdown jvm that comes with my gentoo system.  I will try 
Sun's and see if that makes a difference.

Thanks again for help.

Regards,
Kong

Thomas Hallgren wrote:

> kstian wrote:
>
>> Hi Thomas,
>>
>> Thanks a lot for clarifying.  The previous problem was indeed due to 
>> JDBC driver.  I downloaded jdbc3 and I also needed to add an 
>> overloaded sqlj.replace_jar (CREATE FUNCTION sqlj.replace_jar(BYTEA, 
>> VARCHAR, BOOLEAN) RETURNS void")) in Deployer.java in order to build 
>> the test.
>
>
> Ouch. I've been using the src/sql/install.sql script lately and forgot 
> to add the BYTEA variants to the deployer. I'll fix that.
>
>> There is one other thing I observed while running pljava test:
>>
>> - Before running pljava test, postgresql \z command listed all tables 
>> in my DB: username_test, mdt, employees1, and employees2.
>> - After running pljava test, postgresql \z command DID NOT list any 
>> of these tables, and I could not access to these tables.
>
>
> The tables (and functions) are all installed when the examples.jar is 
> loaded and removed when you issue a remove_jar call on the 
> examples.jar. The creation and removal are handled by the deployment 
> descriptor inside that jar (see 
> src/java/examples/deployment/examples.ddr.
>
>> pljava test did hang.  I had been waiting for 10 minutes.  The 
>> following is the on-screeen output while running pljava test:
>
>
> What JVM are you using?
>
> Regards,
> Thomas Hallgren
>
>
>
>





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
  2005-09-08 06:57 ` [Pljava-dev] Errors running pljava test 
  2005-09-08 09:40   ` [Pljava-dev] Errors running pljava test 
@ 2005-09-09 09:08     ` 
  2005-09-09 09:25       ` [Pljava-dev] Errors running pljava test 
  2005-09-09 09:39       ` [Pljava-dev] Errors running pljava test 
  0 siblings, 2 replies; 8+ messages in thread

From:  @ 2005-09-09 09:08 UTC (permalink / raw)

Hi Thomas,

I have switched to using Sun-jdk-1.4.2.08.  The pljava test is still 
hanging in the middle. Sometimes, it hung at "*** testBinaryColumns()", 
sometimes, it also hung at "*** DatabaseMetaData 'int' functions:"

Is there anything I can try?

Thank you again for help.

Regards,
Kong

kstian wrote:

> I am using Blackdown jvm that comes with my gentoo system.  I will try 
> Sun's and see if that makes a difference.
>
> Thanks again for help.
>
> Regards,
> Kong
>
> Thomas Hallgren wrote:
>
>> kstian wrote:
>>
>>> Hi Thomas,
>>>
>>> Thanks a lot for clarifying.  The previous problem was indeed due to 
>>> JDBC driver.  I downloaded jdbc3 and I also needed to add an 
>>> overloaded sqlj.replace_jar (CREATE FUNCTION sqlj.replace_jar(BYTEA, 
>>> VARCHAR, BOOLEAN) RETURNS void")) in Deployer.java in order to build 
>>> the test.
>>
>>
>>
>> Ouch. I've been using the src/sql/install.sql script lately and 
>> forgot to add the BYTEA variants to the deployer. I'll fix that.
>>
>>> There is one other thing I observed while running pljava test:
>>>
>>> - Before running pljava test, postgresql \z command listed all 
>>> tables in my DB: username_test, mdt, employees1, and employees2.
>>> - After running pljava test, postgresql \z command DID NOT list any 
>>> of these tables, and I could not access to these tables.
>>
>>
>>
>> The tables (and functions) are all installed when the examples.jar is 
>> loaded and removed when you issue a remove_jar call on the 
>> examples.jar. The creation and removal are handled by the deployment 
>> descriptor inside that jar (see 
>> src/java/examples/deployment/examples.ddr.
>>
>>> pljava test did hang.  I had been waiting for 10 minutes.  The 
>>> following is the on-screeen output while running pljava test:
>>
>>
>>
>> What JVM are you using?
>>
>> Regards,
>> Thomas Hallgren
>>
>>
>>
>>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
>





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
  2005-09-08 06:57 ` [Pljava-dev] Errors running pljava test 
  2005-09-08 09:40   ` [Pljava-dev] Errors running pljava test 
  2005-09-09 09:08     ` [Pljava-dev] Errors running pljava test 
@ 2005-09-09 09:25       ` 
  1 sibling, 0 replies; 8+ messages in thread

From:  @ 2005-09-09 09:25 UTC (permalink / raw)

kstian wrote:

> Hi Thomas,
>
> I have switched to using Sun-jdk-1.4.2.08.  The pljava test is still 
> hanging in the middle. Sometimes, it hung at "*** 
> testBinaryColumns()", sometimes, it also hung at "*** DatabaseMetaData 
> 'int' functions:"
>
> Is there anything I can try?

That depends on how much time you have :-) I don't have your environment 
and I'm not able to reproduce the hanging so it would be very helpful if 
you could try two things. The first one is simple. Just change the 
log_min_messages setting in the postgresql.conf file to debug1 and run 
again. The log will be somewhat more verbose and perhaps that can give 
me a better idea of what's happening. The second thing requires a bit 
more work:

a. Compile PostgreSQL configured with --enable-debug
b. Compile PL/Java with MAKE CFLAGS=-g
c. Run the tests again. Once it hangs, attach to the backend process 
(the postgres that represents your sessoin) with GDB and print a stack 
backtrace. That should say a lot about where it hangs.

Regards,
Thomas Hallgren






^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* [Pljava-dev] Errors running pljava test
  2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
  2005-09-08 06:57 ` [Pljava-dev] Errors running pljava test 
  2005-09-08 09:40   ` [Pljava-dev] Errors running pljava test 
  2005-09-09 09:08     ` [Pljava-dev] Errors running pljava test 
@ 2005-09-09 09:39       ` 
  1 sibling, 0 replies; 8+ messages in thread

From:  @ 2005-09-09 09:39 UTC (permalink / raw)

Hi Thomas,

I just tried the first option.  Enclosed is the debug info in 
postgresql.log in case you can spot something quick (since I can't).  
Otherwise, I will try second option and see how much I can do.

Thank you so much again.

Regards,
Kong

Thomas Hallgren wrote:

> kstian wrote:
>
>> Hi Thomas,
>>
>> I have switched to using Sun-jdk-1.4.2.08.  The pljava test is still 
>> hanging in the middle. Sometimes, it hung at "*** 
>> testBinaryColumns()", sometimes, it also hung at "*** 
>> DatabaseMetaData 'int' functions:"
>>
>> Is there anything I can try?
>
>
> That depends on how much time you have :-) I don't have your 
> environment and I'm not able to reproduce the hanging so it would be 
> very helpful if you could try two things. The first one is simple. 
> Just change the log_min_messages setting in the postgresql.conf file 
> to debug1 and run again. The log will be somewhat more verbose and 
> perhaps that can give me a better idea of what's happening. The second 
> thing requires a bit more work:
>
> a. Compile PostgreSQL configured with --enable-debug
> b. Compile PL/Java with MAKE CFLAGS=-g
> c. Run the tests again. Once it hangs, attach to the backend process 
> (the postgres that represents your sessoin) with GDB and print a stack 
> backtrace. That should say a lot about where it hangs.
>
> Regards,
> Thomas Hallgren
>
>
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: postgresql.log
Type: text/x-log
Size: 13542 bytes
Desc: not available
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050909/c74cb405/attachment.bin;



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

end of thread, other threads:[~2005-09-09 09:39 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-08 04:22 [Pljava-dev] Errors running pljava test 
2005-09-08 06:23 ` 
2005-09-08 06:57 ` 
2005-09-08 07:14   ` 
2005-09-08 09:40   ` 
2005-09-09 09:08     ` 
2005-09-09 09:25       ` 
2005-09-09 09:39       ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox