search

njcuk9999 / apero-drs

A PipelinE to Reduce Observations - The DRS for SPIRou (CFHT)
MIT License
12 stars 1 forks source link

error with reject database #749

Closed andrescarmona closed 8 months ago

andrescarmona commented 8 months ago

10:29:16.745-!!|PROC| 10:29:16.621-|DatabaseError|E[00-002-00032] <class 10:29:16.745-!!|PROC| 'mysql.connector.errors.DatabaseError'>: 1030 (HY000): Got error 168 "Unknown 10:29:16.745-!!|PROC| (generic) error from engine" from storage engine InnoDB 10:29:16.746-!!|PROC| Command: DROP TABLE reject_full_v07288_db 10:29:16.747-!!|PROC| path: /home/external/acarmona/.apero/acarmona_at_clusterdb 10:29:16.747-!!|PROC| Function: apero.base.drs_db.py.Database.execute() 10:29:16.914-|PROC| * 10:29:16.947-@!|PROC| W[40-003-00005]: Recipe apero_processing has NOT been successfully completed 10:29:16.993-*|PROC|

It was solved not updating the reject database. Ideas?

njcuk9999 commented 8 months ago

No idea with "Unknown (generic) error from engine"

Can you access the reject database via mysql? Seems to be a problem removing the table (the command that was used was "DROP TABLE reject_full_v07288_db")

Did you try again?

andrescarmona commented 8 months ago

Hello Neil,

I did launch the reduction without updating the reject database.

Launched again and same problem.

As this is the reduction of a new run, I will just go on until i am up to date on the reduction without updating the reject database :-)

Andres

On 4 Mar 2024, at 15:49, Neil Cook @.***> wrote:

No idea with "Unknown (generic) error from engine"

Can you access the reject database via mysql? Seems to be a problem removing the table (the command that was used was "DROP TABLE reject_full_v07288_db")

Did you try again?

— Reply to this email directly, view it on GitHub https://github.com/njcuk9999/apero-drs/issues/749#issuecomment-1976755093, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJO43RTVDRP23ZOJB6O6JD3YWSCZLAVCNFSM6AAAAABEE6JOQOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZWG42TKMBZGM. You are receiving this because you authored the thread.

njcuk9999 commented 8 months ago

Okay but we should fix the problem at some point.

Once you are ready to try, I need you to:

  1. Try to access the reject database from mysql
  2. Backup the table (there are mysql commands to duplicate the table) then try dropping the table in mysql

If both of those work I'm not sure what could cause this. If there is an error in any of these maybe the error can help us.

njcuk9999 commented 8 months ago

@andrescarmona given your email about running out of space for the mysql database, this issue may be directly linked to that!

andrescarmona commented 8 months ago

I hope, I can not run APERO at all now..

andrescarmona commented 8 months ago

APERO went back to operations. The solution was: 1) liberate disk space, we moved from 94% to 77% 2) reboot the database server

andrescarmona commented 8 months ago

the actualisation of the reject database worked too.