View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0008461 | VALENTINA SERVER | Event Shceduler | public | 2019-01-22 13:10 | 2019-01-23 13:40 |
| Reporter | Chris Zakrewsky | Assigned To | Ivan Smahin | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | ALL | OS | ALL | OS Version | ALL |
| Product Version | |||||
| Target Version | 9.0.x | Fixed in Version | 9.0.x | ||
| Summary | 0008461: VServer v8.7.2 - inconsistent handling of BACKUP DATABASE | ||||
| Description | Hi, 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; | ||||
| Tags | No tags attached. | ||||
| 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 |
