Hello,
I have a problem with my DB backup. In many servers on distributed project it stopped working. Automatic backup is set every day at 6 am. In Backup Panel, it gives a status: "WCCOAtoolMedia stopped unexpected". On media there is still a lot of free space.
Here is a log:
WCCILdata (0), 2015.12.02 06:15:00.159, SYS, INFO, 0, , DataManager, stopBgMgr, Stopping WCCILdatabg
WCCILdata (0), 2015.12.02 06:15:00.163, SYS, INFO, 181, Closing connection to (SYS: 3 Data -num 1 CONN: 1)
WCCILdatabg (1), 2015.12.02 06:15:00.269, SYS, INFO, 39, Connection lost, MAN: (SYS: 3 Data -num 0 CONN: 1), Connection closed
WCCILdata (0), 2015.12.02 06:15:00.367, SYS, INFO, 39, Connection lost, MAN: (SYS: 3 Data -num 1 CONN: 1), Connection closed
WCCILdatabg (1), 2015.12.02 06:15:00.377, SYS, SEVERE, 39, Connection lost, (SYS: 3 Data -num 0 CONN: 1), exiting ...
WCCILdatabg (1), 2015.12.02 06:15:02.411, SYS, INFO, 2, Manager Stop
WCCILdata (0), 2015.12.02 06:15:02.531, SYS, INFO, 0, , Loading DpIdentification
WCCILdata (0), 2015.12.02 06:15:02.652, PARAM,INFO, 113, Online-Backup of database, Entering backup mode, functionality will be restricted
WCCILdata (0), 2015.12.02 06:16:00.182, SYS, SEVERE, 113, Online-Backup of database, DataManDpInternSup, refreshBckupStatus, Could not open output file from WCCOAtoolMedia
WCCILdata (0), 2015.12.02 06:16:00.182, SYS, INFO, 0, , (Re)Opening databases in multi user mode without transaction logging.
WCCILdata (0), 2015.12.02 06:16:00.321, SYS, INFO, 0, , Loading DpIdentification
WCCILdata (0), 2015.12.02 06:16:00.321, SYS, INFO, 0, , (Re)Opening databases in multi user mode without transaction logging.
WCCILdata (0), 2015.12.02 06:16:00.344, SYS, INFO, 0, , DataManager, startBgMgr, (Re)starting WCCILdatabg
WCCILdata (0), 2015.12.02 06:16:00.360, PARAM,INFO, 113, Online-Backup of database, Leaving backup mode, now processing cached messages...
WCCILdatabg (1), 2015.12.02 06:16:00.817, SYS, INFO, 1, Manager Start, PROJ, SysVijenac, V 3.12 - 3.12 platform Linux x86_64 linked at Apr 1 2015 22:06:01
WCCILdatabg (1), 2015.12.02 06:16:00.818, SYS, INFO, 3, Trying to connect to, (SYS: 0 Data -num 0 CONN: 1) @ scada-vijenac1-1:4897,scada-vijenac1-2:4897
WCCILdatabg (1), 2015.12.02 06:16:00.818, SYS, INFO, 4, Connected to, (SYS: 0 Data -num 0 CONN: 1) @ localhost (127.0.0.1)
WCCILdata (0), 2015.12.02 06:16:00.818, SYS, INFO, 4, Connected to, (SYS: 3 Data -num 1 CONN: 1) @ localhost (::ffff:127.0.0.1)
WCCILdata (0), 2015.12.02 06:16:00.821, SYS, INFO, 0, , Manager (SYS: 3 Data -num 1 CONN: 1) initialised
WCCILdatabg (1), 2015.12.02 06:16:00.852, SYS, INFO, 6, Initialization by Data Manager finished
Thanks in advance,
Vedad
DB Backup stopped
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: DB Backup stopped
Hello,
when looking at the log-messsage you can see that it takes about one hour and the backup is not finished then. Maybe too much data needs to be copied and therefore it lasts to long. Normally a backup shall be finished in a short period of time. As long as the backup is running the functionality is restricted and the system is buffering data.
Please check the settings for the online backup (time range, devivce) and the read/write performance for the used devices (project directory, backup device).
Best Regards
Leopold Knipp
Senior Support Specialist
when looking at the log-messsage you can see that it takes about one hour and the backup is not finished then. Maybe too much data needs to be copied and therefore it lasts to long. Normally a backup shall be finished in a short period of time. As long as the backup is running the functionality is restricted and the system is buffering data.
Please check the settings for the online backup (time range, devivce) and the read/write performance for the used devices (project directory, backup device).
Best Regards
Leopold Knipp
Senior Support Specialist
- vedadramovic
- Posts:121
- Joined: Mon Apr 07, 2014 10:36 am
Re: DB Backup stopped
Hello,
When i manually start DB backup, it takes just a minute to stop it and gives a message "WCCOAtoolMedia stopped unexpected" and info says "Not possible to initialize data media" and error code is (-4). It looks like that the problem is in the line that says:
Could not open output file from WCCOAtoolMedia
In configuration of Backup Panel I set last parameters 0, 58 and 0 respectively.
I hope these informations will give you better review in my problem.
Thanks.
When i manually start DB backup, it takes just a minute to stop it and gives a message "WCCOAtoolMedia stopped unexpected" and info says "Not possible to initialize data media" and error code is (-4). It looks like that the problem is in the line that says:
Could not open output file from WCCOAtoolMedia
In configuration of Backup Panel I set last parameters 0, 58 and 0 respectively.
I hope these informations will give you better review in my problem.
Thanks.