[
http://tracker.firebirdsql.org/browse/CORE-4860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vlad Khorsun reopened CORE-4860:
--------------------------------
Fix Version/s: 2.5.5
Re-open to backport fix into v2.5
> Online validation fails on WINDOWS if `dbname` argument contains forward
> slash ('/') and concurrent attachment which also uses '/' exists.
> ------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: CORE-4860
> URL: http://tracker.firebirdsql.org/browse/CORE-4860
> Project: Firebird Core
> Issue Type: Bug
> Affects Versions: 2.5.4, 3.0 Beta 2
> Environment: Windows XP
> Reporter: Pavel Zotov
> Assignee: Vlad Khorsun
> Priority: Minor
> Fix For: 3.0 RC 1, 2.5.5
>
>
> On Windows one may specify FORWARD slash ('/', ascii_char = 47) as subfolders
> separator in the path to database file, and it works OK:
> C:\FBTESTING\qa\fbt-repo>isql
> localhost/3333:C:/FBTESTING/qa/fbt-repo/tmp/E30.fdb
> Database: localhost/3333:C:/FBTESTING/qa/fbt-repo/tmp/E30.fdb
> But if we do following:
> 1) make ISQL connection using this separator (forward slash),
> 2) try to perform online validation using also this separator ('/') in the
> path to validated database
> -- then we get:
> ===
> fbsvcmgr.exe localhost/3333:service_mgr user SYSDBA password masterkey
> action_validate dbname C:/FBTESTING/qa/fbt-repo/tmp/E30.fdb val_lock_timeout 1
> I/O error during "CreateFile (open)" operation for file
> "C:/FBTESTING/qa/fbt-repo/tmp/E30.fdb"
> -Error while trying to open file
> -The process can not access the file because the file is in use by another
> process.
> ===
> If we change separator in ISQL window to default for Windows ("\") than
> validation works fine.
> If we change separator in fbsvcmgr command line to '\' (but leave '/' in
> ISQL) than validation also works fine.
> So, the trouble exists only when forward slash is specified both in ISQL
> connection string and in validation DB path argument.
> BTW: error in FBSVCMGR will not appear for other actions, with forward slash
> as path separator, e.g.:
> fbsvcmgr.exe localhost/3333:service_mgr user SYSDBA password masterkey
> action_db_stats dbname C:/FBTESTING/qa/fbt-repo/tmp/E30.fdb sts_hdr_pages
> -- works OK and produces standard output of DB header info.
> This bug prevent from creating test which tries to validate database online:
> fbtest engine has $(DATABASE_LOCATION) macro which contains PATH of currently
> used database. But this macro uses exactly FORWARD slash bot on Linux and
> Windows as path separator, so one may NOT to do this:
> runProgram('fbsvcmgr',['localhost:service_mgr','user','SYSDBA','password','masterkey','action_validate','dbname','$(DATABASE_LOCATION)bugs.core_4707.fdb','val_lock_timeout','1'])
> -- it will fail with error that is shown above ("process can not access the
> file because the file is in use by another process").
--
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
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
