[Saleem]

Hi Guys,

Changing the table type is not an option in the production environment.

I had the 7.02 version from my friend, uninstalled the existing version and installed the old version. Configured everything and everything is working fine. sja takes the backup of those dbs in 1 minute.

Conclusion: Old version works, new version does not.

Any details?

[Saleem]

Hi nithin,

Please find the attached screenshots taken at same time. This time sja was frozen while taking a wordpress blog's db backup and stuck at wp_redirection_modules table and the command for that process in the process list shows sleep!! 🙁

See the attached screenshots. I have masked the IPs and DB names. The server and the desktop taking backup are within the LAN.

I think we are making progress here, so the backup process is not taking backup, but sleeping. How to wake it up?

Regards..

'nithin' wrote on '23:

Saleem,

We need to know which query is slow on server.

So please recreate the situation and follow the steps explained below, when it is in waiting state for “Exporting ….”

– Open another SQLyog and connect to same server

– Open Tools->Show->Processlist. It lists all active processes of the server. Click on 'Refresh' button in dialog, and you can find which process is for the Scheduled-backup.

To identify the process, please check the columns 'Command'(which would be “Query”) and 'State' (which would be “Sending data”, or “Writing”) of the table displayed. Please see the attached screen-shot.

– Once you identified the row (process) that refer to the Scheduled-backup thread, copy the 'Info' column (that contains the query executing) and send to us.

– You can also provide the other column status also by sending screen-shot of 'process list' dialog and mark the particular row.

For privacy you could create ticket using below link

http://webyog.com/support/

Regards

[Saleem]

Hi Mahesh,

I am really sorry, but I didn't get the clearance to upload the .sql file.

But the mysql database is just filled with multiple instances of bugzilla's databases used by the testing team, development team, etc for development of various applications developed by the organization.

It normally gets stuck at the table “bugs” in the bugzilla's database. May be this will help you to re-produce the problem at your end.

Regards…

'Mahesh' wrote on '19:

This looks weird, can you attach a .SQL file created using “Backup as SQLdump” option (zip and attach).

Also You can create a support ticket from here for privacy of data:

http://webyog.com/support/

Thanks for the information.

[Saleem]

Yes Mahesh,

It works like a charm and completed the table export in not less than 2 minutes, where as the sja backup is still running for almost 3 and half days now.

Regards..

'Mahesh' wrote on '19:

Are you able to backup successfully particular table using “Backup table as SQL dump..” ?

Select a table from Object browser — > Right Click –> Export –> “Backup table as SQL dump”

[Saleem]

1. Tried exporting this particular table with SQLYog and MySQL Administrator, it works fine and takes 2 minutes to complete. Not only on this database, few other tables on another db is also freezing like this. Without zipping the .sql file size of this db is 91.7MB.

I have attached the show global variable command's output and the my.cnf. Unfortunately I am waiting for authorisation from the higher level to upload the .sql dump as .zip file.

2. I have another server with same configuration [including OS and mysql version] and import works, export with sja gives problem as described.

3. Zipped the backup.xml and attached the backup.zip [as the forum does not allow attaching .xml files] with the credentials and other important info with the word “censored”

4. 3 days 🙂 I just let it to complete on it's own and as of now it is still backing up that table. I have attached the screenshot with the db names scrambled.

5. Direct MySQL connection. The server and the machines all are connected on a Gigabit switch with managed L3 switches.

Please do let me know if I can help any further.

Regards..

'peterlaursen' wrote on '19:

1) Could you try exporting this particular table alone (with SQLyog or another tool).  How big is a .zip of such dump? If you can post the .zip to our ticket system we could try in our environment. There may be server-side settings involved and it is not sure that it is reproducible in our environment, though. But we need to try it. The output from “SHOW GLOBAKL VARIABLES” and/or the my.cnf may also be useful.

2) Also you could try to import such dump to another server and check if problem is the same.  

3) Also we will need the jobfile to see your settings for the job.  You can obscure details about the server, password etc.

4) What is 'very long time'? How long did you wait? 

5) How do you connect? direct, SSH-tunnel, HTTP-tunnel?

I suspect (but it is a guess only, of course) that this table may have a very long TEXT/BLOB column with a description-field or similar and some buffer setting (server-side or client-side) is not optimal.  

[Author]

Posts