Backup Database to GDrive not working

aaP_furkan1500

There is a crontab and it needs to upload the database backup to Gdrive. It was working before but I noticed that it is not working after the latest gdrive plugin updates.
Log:

/www/server/panel/plugin/gdrive/gdrive_main.py:249: SyntaxWarning: invalid escape sequence '\c'
public.ExecShell('\cp -rp {} /root/gdrive_token.json'.format(self.__config_path))
/www/server/panel/plugin/gdrive/gdrive_main.py:316: SyntaxWarning: invalid escape sequence '\d'
file_regx = prefix_dict.get(data_type) + "(.+)20\d+\d+(?:.|)"
/www/server/panel/plugin/gdrive/gdrive_main.py:406: SyntaxWarning: invalid escape sequence '\s'
c_type = str(re.findall("SET\s+([\w\d-]+)\s",tmp[0][1])[0])
/www/server/panel/plugin/gdrive/gdrive_main.py:553: SyntaxWarning: invalid escape sequence '['

rep = "[mysqldump]\nuser=root"

|-Start backup[2024-08-17 12:45:03]

|-Backup database:mydatabase
|-Database size: 2.37 GB
|-Database character set: utf8
|-Partition / available disk space is: 15.28 GB, available Inode is: 2280865
|-Start exporting database: 2024-08-17 12:45:03
|-Compression completed, took 88.35 seconds, compressed package size: 374.48 MB
|-Uploading to Google Drive, please wait ...
|-Message sent successfully.

|-Notification has been sent

|-Error：Database mydatabase does not exist

aaP_furkan1500

The problem with not backing up was that the Drive storage was full. But the first error is still there.

aaPanel_Kern

Hello, prompt |-Error: Database mydatabase does not exist, indicating that the database does not exist. It is recommended that you check whether it exists from the Databases interface
These messages are warnings and will not affect actual use.

aaP_furkan1500

aaP_furkan1500 However, this error appears at the beginning of every backup. @aaPanel_Kern

aaP_furkan1500

aaPanel_Kern No, the database exists. Backup successful but Gdrive upload was failing. This was because the drive was full. When I freed up space on the drive storage, the problem was fixed, but instead of saying "database not found", the error message should have said "drive storage full" or "drive load failed".

aaPanel_Kern

It is recommended that you clean up useless files and reserve a certain amount of backup space.

aaP_furkan1500

The backup file is 700mb and the free space in Gdrive storage is 90GB. The error message comes at the beginning of the backup. So it is not related to gdrive storage. It seems like a character problem.

aaP_furkan1500

It doesn't seem to be a bug preventing it from working right now. I just wanted to let you know, it can be fixed.

aaPanel_Kern

aaP_furkan1500
Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:

No post link will not be able to know which user's information is, and the problem will not be processed

aaP_furkan1500

aaPanel_Kern
I can't do this, I can only share these details:

Only MySQL 5.7.37 and Google Drive 2.4 plugins are installed on the server.
Mysql is running in slave mode.
Crontab task type section is backup database and only the database I want is selected in the Backup Database section.

The resulting log is as follows:

rep = "[mysqldump]\nuser=root"

|-Start backup[2024-08-19 14:30:03]

|-Backup database:mydatabase
|-Database size: 2.39 GB
|-Database character set: utf8
|-Partition / available disk space is: 15.42 GB, available Inode is: 2280833
|-Start exporting database: 2024-08-19 14:30:03
|-Compression completed, took 91.14 seconds, compressed package size: 376.18 MB
|-Uploading to Google Drive, please wait ...
Upload Success ,File ID: 19I2JbtW15**************-
|-Successfully uploaded to Google Drive
|-Database has been backed up to: /www/backup/database/db_mydatabase_20240819_143003.sql.gz
|-User settings do not retain local backups, deleted /www/backup/database/db_mydatabase_20240819_143003.sql.gz
|-Keep the latest number of backups: 10 copies
|-----------------------------------------------------------------------------------------
delete ok

|-Expired backup files have been cleaned from Google Drive: db_mydatabase_20240819_120003.sql.gz

|-Backup completed[2024-08-19 14:31:46]