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
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 06:23
parent:
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 06:57
parent:
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 07:14
parent:
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 09:40
parent:
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-09 09:08
parent:
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-09 09:25
parent:
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-09 09:39
parent:
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