Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Firebird 3.0.7 (x64) Installer is missing the employee.fdb database [CORE6424] #6662

Closed
firebird-automations opened this issue Oct 20, 2020 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @luronumen

Attachments:
ERROR.png

ACTUAL RESULT
- Firebird 3.0.7 Installer is missing the employee.fdb database

EXPECTED RESULT
- Firebird 3.0.7 Installer should include the employee.fdb database on C:\Program Files\Firebird\Firebird_3_0\examples\empbuild folder once the employee.fdb database is the first step to setup the Firebird user accounts

STEPS TO REPRODUCE THE ISSUE
1- Go to https://firebirdsql.org/en/firebird-3-0/ and download the Firebird 3.0.7 (x64) and install it;

2- Make sure that the FirebirdSQL 3.0 service is NOT running:
net stop FirebirdServerDefaultInstance

3- Run the following command to create or update the SYSDBA user using the SRP plugin:
ECHO CREATE OR ALTER USER SYSDBA SET PASSWORD 'SYSDBAPWD' USING PLUGIN SRP;COMMIT; | "C:\Program Files\Firebird\Firebird_3_0\isql.exe" -user SYSDBA "EMPLOYEE" -quiet >NUL

=======================
Statement failed, SQLSTATE = 08001
I/O error during "CreateFile (open)" operation for file "EMPLOYEE"
-Error while trying to open file
-The system cannot find the file specified.

IMPORTANT NOTES:
This issue does not happen with Firebird 3.0.6 version

Commits: 8a7357d 122a553

====== Test Details ======

See: functional\basic\build\snapshot-files-check-list.fbt
(not only employee.fdb but all other files are checked for presence in FB home and its sub-folders; list of expected files must be adjusted from time to time for each major FB version)

@firebird-automations
Copy link
Collaborator Author

Modified by: @luronumen

Attachment: ERROR.png [ 13502 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @luronumen

the employee.fdb database is also missing on https://github.com/FirebirdSQL/firebird/releases/download/R3_0_7/Firebird-3.0.7.33374-0_x64.zip file

This issue is NOT reproducible on Firebird 3.0.7 (x32) version: See https://github.com/FirebirdSQL/firebird/releases/download/R3_0_7/Firebird-3.0.7.33374-0_Win32.zip

@firebird-automations
Copy link
Collaborator Author

Modified by: @reevespaul

assignee: Paul Reeves [ paul_reeves ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @reevespaul

I've looked at the build history and it seems the problem is with the way we build the employee database. For some unknown and bizarre reason the build of the employee database failed for x64. It didn't fail for x32 and it didn't fail for an unofficial build of 3.0.7 that I did later that day.

I can see that the empbuild.unsuccessfulbuild file was not removed. The real, underlying bug here is why the build did not fail at that point. It just carried on as if there was no problem.

Anyway, the immediate problem is easily remedied. I'll just rebuild and bump the package number from 0 to 1.

Thanks for reporting this.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.7 [ 10940 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Fixed packages have just been re-uploaded.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Covered by another test(s)

Test Details: See: functional\basic\build\snapshot-files-check-list.fbt
(not only employee.fdb but all other files are checked for presence in FB home and its sub-folders; list of expected files must be adjusted from time to time for each major FB version)

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants