Programmiererforum

pymysql.err.OperationalError: (2006, "MySQL server has gone away (ConnectionAbortedError(10053, 'An established connection was aborted by the software in your host machine', None, 10053, None))")
< /code>
Ich habe den MySQL -Serverstatus, untersuchte Fehlerprotokolle und überprüfte Verbindungsparameter bereits überprüft, aber das [url=viewtopic.php?t=26065]Problem[/url] bleibt bestehen. Der Fehler tritt während der Methode Audio_Processor.save_audio_File_to_db auf, die mit der MySQL -Datenbank mit SQLAlchemy interagiert.    def save_audio_file_to_db(self, user_id: str, audio_file: UploadFile) -> str:
log.info("Inside save_audio_file_to_db")
try:
# Generate a unique ID for the audio file
audio_id = str(uuid4())

# Create user-specific and audio-specific folders
user_folder = f"user_{user_id}"
audio_folder = os.path.join(COMMON_AUDIO_FOLDER, user_folder, audio_id)
os.makedirs(audio_folder, exist_ok=True)

# Save the uploaded audio file to the specified path
audio_path = os.path.join(audio_folder, audio_file.filename)
with open(audio_path, "wb") as audio_file_object:
shutil.copyfileobj(audio_file.file, audio_file_object)

# Call remove_silence function to remove silence from the audio before saving it to the path
remove_silence(audio_path)

# Calculate audio length using pydub
audio = AudioSegment.from_file(audio_path)
audio_length_in_seconds = len(audio) / 1000.0  # Convert milliseconds to seconds

# Get current UTC time and convert it to Sri Lankan time
utc_now = datetime.now(pytz.utc)
sri_lankan_timezone = pytz.timezone('Asia/Colombo')
lk_now = utc_now.astimezone(sri_lankan_timezone)

# Metadata for the audio file
metadata = {
"size": os.path.getsize(audio_path),
"utc_date": str(utc_now),
"lk_date": str(lk_now),
"audio_length_seconds": audio_length_in_seconds,
}

# Log metadata information to a file
log_path = os.path.join(audio_folder, "metadata_log.txt")
with open(log_path, "w") as log_file:
for key, value in metadata.items():
log_file.write(f"{key}: {value}\n")

# Create an instance of the Audio model
audio_instance = Audio(
id=audio_id,
user_id=user_id,
path=audio_path,
utc_date_created=metadata["utc_date"],
lk_date_created=metadata["lk_date"],
audio_length_seconds=metadata["audio_length_seconds"]
)
# Add the audio instance to the database and commit the changes
self.db.add(audio_instance)
self.db.commit()
log.info("Save Audio in Db audio_id: "+audio_id)
return audio_id```

Ich begegne ein [url=viewtopic.php?t=26065]Problem[/url] beim Hochladen von Audiodateien mit Fastapi und SQLalchemy in meiner Python -Anwendung. Der Code ist so konzipiert, dass die Benutzerauthentifizierung verarbeitet, Benutzer -IDs validiert und Metadat in einer MySQL -Datenbank gespeichert wird. Ich erhalte jedoch konsequent das folgende OperationalError: < /p>
[code]pymysql.err.OperationalError: (2006, "MySQL server has gone away (ConnectionAbortedError(10053, 'An established connection was aborted by the software in your host machine', None, 10053, None))")
< /code>
Ich habe den MySQL -Serverstatus, untersuchte Fehlerprotokolle und überprüfte Verbindungsparameter bereits überprüft, aber das [url=viewtopic.php?t=26065]Problem[/url] bleibt bestehen. Der Fehler tritt während der Methode Audio_Processor.save_audio_File_to_db auf, die mit der MySQL -Datenbank mit SQLAlchemy interagiert. def save_audio_file_to_db(self, user_id: str, audio_file: UploadFile) -> str:
log.info("Inside save_audio_file_to_db")
try:
# Generate a unique ID for the audio file
audio_id = str(uuid4())

# Create user-specific and audio-specific folders
user_folder = f"user_{user_id}"
audio_folder = os.path.join(COMMON_AUDIO_FOLDER, user_folder, audio_id)
os.makedirs(audio_folder, exist_ok=True)

# Save the uploaded audio file to the specified path
audio_path = os.path.join(audio_folder, audio_file.filename)
with open(audio_path, "wb") as audio_file_object:
shutil.copyfileobj(audio_file.file, audio_file_object)

# Call remove_silence function to remove silence from the audio before saving it to the path
remove_silence(audio_path)

# Calculate audio length using pydub
audio = AudioSegment.from_file(audio_path)
audio_length_in_seconds = len(audio) / 1000.0 # Convert milliseconds to seconds

# Get current UTC time and convert it to Sri Lankan time
utc_now = datetime.now(pytz.utc)
sri_lankan_timezone = pytz.timezone('Asia/Colombo')
lk_now = utc_now.astimezone(sri_lankan_timezone)

# Metadata for the audio file
metadata = {
"size": os.path.getsize(audio_path),
"utc_date": str(utc_now),
"lk_date": str(lk_now),
"audio_length_seconds": audio_length_in_seconds,
}

# Log metadata information to a file
log_path = os.path.join(audio_folder, "metadata_log.txt")
with open(log_path, "w") as log_file:
for key, value in metadata.items():
log_file.write(f"{key}: {value}\n")

# Create an instance of the Audio model
audio_instance = Audio(
id=audio_id,
user_id=user_id,
path=audio_path,
utc_date_created=metadata["utc_date"],
lk_date_created=metadata["lk_date"],
audio_length_seconds=metadata["audio_length_seconds"]
)
# Add the audio instance to the database and commit the changes
self.db.add(audio_instance)
self.db.commit()
log.info("Save Audio in Db audio_id: "+audio_id)
return audio_id```
[/code]