8:44 p.m.
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Chorus");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:44 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Andriy Rokhmanov updated TEIID-1609:
------------------------------------
Description:
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
was:
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Chorus");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:14 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1609:
---------------------------------------
So this works with the delay, but fails without it?
Is there more to the stacktrace, such as something that indicates the vdb is inactive?
Even in 7.3 we did not explicitly wait for a vdb to become active before rejecting a
connection. Is there something about your vdb, such as a long running translator metadata
load that would cause activation to be delayed?
Alternatively are you expecting connections to wait for a vdb to become active before
throwing an exception?
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:08 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Andriy Rokhmanov updated TEIID-1609:
------------------------------------
Attachment: error.txt
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
Attachments: error.txt
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:08 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Andriy Rokhmanov commented on TEIID-1609:
-----------------------------------------
Yes, sorry, the complete exception trace says that connection cannot be created because
vdb is not active.
The only one change we have is the new version of Teiid. Looks like for 7.3 such delay in
our code is not needed. We have a workaround - request connection again after catch(), so
this is not a high priority issue.
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
Attachments: error.txt
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:19 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1609:
-------------------------------------
you can call "admin.getVDB(name)", then check if returned anything or check the
status to make sure it is active before making the connection.
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
Attachments: error.txt
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:15 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Andriy Rokhmanov commented on TEIID-1609:
-----------------------------------------
Yes Ramesh, this is another alternative, thank you.
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
Attachments: error.txt
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:37 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-1609.
---------------------------------
Resolution: Rejected
Based the comments, this is just user activity, so rejected
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
Attachments: error.txt
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:14 p.m.
New subject: [JBoss JIRA] (TEIID-1609) Delay required when get connection to admin deployed VDB
[
https://issues.jboss.org/browse/TEIID-1609?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1609.
---------------------------------
Delay required when get connection to admin deployed VDB
--------------------------------------------------------
Key: TEIID-1609
URL: https://issues.jboss.org/browse/TEIID-1609
Project: Teiid
Issue Type: Bug
Affects Versions: 7.4
Environment: Windows 7, JBoss 5.1.0
Reporter: Andriy Rokhmanov
Assignee: Steven Hawkins
Priority: Minor
Attachments: error.txt
//Steps to reproduce (pseudo-code):
final AdminFactory adminFactory = AdminFactory.getInstance();
final Admin teiidAdmin = adminFactory.createAdmin("####",
"####".toCharArray(),"mms://127.0.0.1:31443"));
teiidAdmin.deployVDB("test-vdb.xml",
ByteStreams.newInputStreamSupplier(vdbString.getBytes()).getInput());
teiidAdmin.close();
// Thread.sleep(500);
final TeiidDataSource teiidDataSource = new TeiidDataSource();
teiidDataSource.setDatabaseName("Test");
teiidDataSource.setUser("****");
teiidDataSource.setPassword("****");
// The next line causes exception:
Connection conn = teiidDataSource.getConnection();
CDT SEVERE [org.teiid.jdbc] (pool-6-thread-1) Could not create connection
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)
at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:58)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:234)
at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:215)
...
// Please note that the same code works fine in Teiid 7.3
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4503
days inactive
4777
days old
8 comments
3 participants
participants (3)
-
Andriy Rokhmanov (JIRA) -
Ramesh Reddy (JIRA)
-
Steven Hawkins (JIRA)