View Issue Details

IDProjectCategoryView StatusLast Update
0008461VALENTINA SERVEREvent Shcedulerpublic2019-01-23 13:40
ReporterChris ZakrewskyAssigned ToIvan Smahin 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformALLOSALLOS VersionALL
Product Version 
Target Version9.0.xFixed in Version9.0.x 
Summary0008461: VServer v8.7.2 - inconsistent handling of BACKUP DATABASE
DescriptionHi,

Assuming SQL:

   BACKUP DATABASE WITH DIAGNOSE;

Assuming following definitions in vserver.ini:

   SYSTEMCATALOG = C:\path\to\Database_dir
   SYSTEMBACKUPCATALOG = C:\path\to\Backup_dir


Following happens:

1. When this SQL is issued from anything but an event the backup is created in:

    C:\path\to\Backup_dir\YYYYMMDD_HHMMSS

2. When this SQL is issued from an event the backup is created in:

    C:\path\to\Database_dir\Backups\YYYYMMDD_HHMMSS

3. The only way to force backup creation in SYSTEMBACKUPCATALOG from an event in above scenario is issuing following SQL (that is strictly contradictory to documentation which implies that SYSTEMBACKUPCATALOG has precedence over given path and that this argument is ignored alltogether - apparently not):

    BACKUP DATABASE TO 'C:\path\to\Backup_dir' WITH DIAGNOSE;

Above is reproducible both in Windows and Linux.
This worked previously. Backtracing when this was changed give some time around August 2018.

4. Furthermore the parser acts funny on this SQL when one attempt to provide a variable instead of hardcoded path. Following is rejected by parser:

    SET @MyPath = 'C:\path\to\Backup_dir';
    BACKUP DATABASE TO @MyPath WITH DIAGNOSE;

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-01-22 13:10 Chris Zakrewsky New Issue
2019-01-23 13:39 Ruslan Zasukhin Target Version => 9.0.x
2019-01-23 13:40 Ruslan Zasukhin Assigned To => Ivan Smahin
2019-01-23 13:40 Ruslan Zasukhin Status new => assigned
2019-01-23 13:40 Ruslan Zasukhin Status assigned => resolved
2019-01-23 13:40 Ruslan Zasukhin Fixed in Version => 9.0.x
2019-01-23 13:40 Ruslan Zasukhin Resolution open => fixed