Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error in mysql restart after dropped and created partitioned table

keydbasMar 4 2020

I have dropped partitioned table and then created again with another partition key

as it is dropped but still in restart it shows earlier partiions' ibd files which no exists any more

200304  8:05:05  InnoDB: Error: trying to open a table, but could not

InnoDB: open the tablespace file './labrules/file_rule_hit_log#P#SEP@002d1@002d2018.ibd'!

InnoDB: Have you moved InnoDB .ibd files around without using the

InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?

InnoDB: It is also possible that this is a temporary table #sql...,

InnoDB: and MySQL removed the .ibd file for this.

InnoDB: Please refer to

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html

InnoDB: for how to resolve the issue.

200304  8:05:05  InnoDB: Operating system error number 2 in a file operation.

InnoDB: The error means the system cannot find the path specified.

InnoDB: If you are installing InnoDB, remember that you must create

InnoDB: directories yourself, InnoDB does not create them.

200304  8:05:05  InnoDB: Error: trying to open a table, but could not

InnoDB: open the tablespace file './labrules/file_rule_hit_log#P#SEP@002d1@002d2019.ibd'!

InnoDB: Have you moved InnoDB .ibd files around without using the

InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?

InnoDB: It is also possible that this is a temporary table #sql...,

InnoDB: and MySQL removed the .ibd file for this.

InnoDB: Please refer to

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html

InnoDB: for how to resolve the issue.

200304  8:05:05  InnoDB: Operating system error number 2 in a file operation.

InnoDB: The error means the system cannot find the path specified.

InnoDB: If you are installing InnoDB, remember that you must create

InnoDB: directories yourself, InnoDB does not create them.

200304  8:05:05  InnoDB: Error: trying to open a table, but could not

InnoDB: open the tablespace file './labrules/file_rule_hit_log#P#UPPER_CATCHALL.ibd'!

InnoDB: Have you moved InnoDB .ibd files around without using the

InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE?

InnoDB: It is also possible that this is a temporary table #sql...,

InnoDB: and MySQL removed the .ibd file for this.

Comments

HAJMEL

Hi
You can add mail.smtps.ssl.protocols property (not specified in API) but its referenced implementation.

User_UW1FS

Hi,
Thank you for your reply. Will that property works for javamail1.4.2?
Thanks,
Juni.

HAJMEL

Hi,
I don't know the complete context of your project but Only tests can confirm this.
I suggest also upgrading to Javamail1.6 that already support TLS1.2.
A

HAJMEL

Hi
this worked ?

User_UW1FS

I can't use javamail 1.6. Must stay with javamail1.4.x to be compatible with EE6.
That is why I am asking if you know if there is javamail1.4.x that works.

HAJMEL

I'll give a try and come back !

HAJMEL
look here
https://stackoverflow.com/questions/411331/using-javamail-with-tls
Kristof Neirynck's answer ( on the bottom)
User_UW1FS

I took a look that link but not seeing any information of what javamail version of 1.4 that I can use with TLSv1.2.
I am trying to find out what javamail1.4.x version that support/work with TLSv1.2 as I have to stay with javamail1.4.x
Try to figure out the x. I know javamail1.4.2 does not work with TLSv1.2.

HAJMEL

There no explicit and official documentation of support of TLS1.2+ by javamail 1.4.x but 1.5.x does.
Java SE 6 Advanced (0 Bytes)Path 1 : Workaround: can you use an alternative JCE implementation (Bouncy Castle)
INFO: If your application runs on Java 1.6 prior to update 111, or earlier, TLS 1.1 and 1.2 are not supported.
Q: any error or debug information to help spot it?
Warning: EE6 is full of vulnerabilities, I hope your app is not exposed.

1 - 9

Post Details

Added on Mar 4 2020
0 comments
255 views