isql process in non-interactive session sometimes never ends
------------------------------------------------------------
Key: CORE-6172
URL: http://tracker.firebirdsql.org/browse/CORE-6172
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0.3
Environment: Windows, Java (for installation program)
Reporter: A Drouard
Priority: Blocker
Firebird server is deployed with it's own port for each instance of our
application.
We have about 150 Firebird instances on the same machine.
We run isql in order to create Firebird users with a random generated password
with the following command :
<absolute_path_to_firebird_dir>\isql.exe -b -m -o
"<absolute_path_to_firebird_dir>\init-users.log" -user sysdba -input
"<absolute_path_to_firebird_dir>\init-users.sql" employee
Sometimes, isql.exe process is blocked. In such case, users are not created and
init-users.log file is empty.
The init-users.sql file is generated like this :
create user user1 password 'randompassword1';
create user user2 password 'randompassword2';
create user user3 password 'randompassword3';
grant create database to user user1;
grant create database to user user2;
commit;
quit;
The installation program executes the following actions :
1) Unzip Firebird server binaries
2) Run isql to create users
3) Configure RemoteServicePort in firebird.conf
4) Register Firebird as Windows service
As isql need exclusive access to Firebird engine, we run it before registering
service.
May be, isql.exe is disturbed by other Firebid instances ?
How can I ensure that isql will not block ?
How can I have more logs ?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
