[MCOL-4542] ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed Created: 2021-02-18  Updated: 2023-07-04

Status: Open
Project: MariaDB ColumnStore
Component/s: Storage Manager
Affects Version/s: 5.5.1
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Allen Lee (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

RHEL 7, Virtualized On Prem



 Description   

Customer often hit the following errors during DDL. This system is using S3 storage compatible object storage.

Feb 17 08:00:58 x01tfcdb2a writeengine[17168]: 58.397392 |0|0|0| E 19 CAL0001: ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed
Feb 17 10:09:36 x01tfcdb2a ExeMgr[17145]: 36.976327 |2147483676|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='ofadev_db' and tablename='cs_test6' --columnRIDs/FE; ||
Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.046950 |2147483676|0|0| D 16 CAL0042: End SQL statement
Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.073842 |28|0|0| D 16 CAL0041: Start SQL statement: select * from cs_test6; |ofadev_db|
Feb 17 10:09:37 x01tfcdb2a ExeMgr[17145]: 37.087941 |28|0|0| D 16 CAL0042: End SQL statement
Feb 17 10:22:13 x01tfcdb2a IDBFile[13591]: 13.462810 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: SessionManager Caught Signal 15
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: Shutdown StorageManager...
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: Ownership: releasing ownership of data1
Feb 17 10:22:36 x01tfcdb2a StorageManager[16913]: StorageManager Shutdown Complete.
....
Feb 18 07:32:10 x01tfcdb2a writeengine[15283]: 10.768606 |0|0|0| E 19 CAL0001: ReadThreadFactory::CreateReadThread: read() error InetStreamSocket::readToMagic: Remote is closed
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.920154 |2147483692|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='ofadev_db' and tablename='cs_test8' --columnRIDs/FE; ||
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.941173 |2147483692|0|0| D 16 CAL0042: End SQL statement
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.956631 |44|0|0| D 16 CAL0041: Start SQL statement: select * from cs_test8; |ofadev_db|
Feb 18 09:32:57 x01tfcdb2a ExeMgr[15258]: 57.962278 |44|0|0| D 16 CAL0042: End SQL statement
Feb 18 09:33:43 x01tfcdb2a IDBFile[18424]: 43.610045 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: SessionManager Caught Signal 15
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: Shutdown StorageManager...
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: Ownership: releasing ownership of data1
Feb 18 09:34:07 x01tfcdb2a StorageManager[14788]: StorageManager Shutdown Complete.
Feb 18 09:35:49 x01tfcdb2a StorageManager[19815]: Using the config file found at /etc/columnstore/storagemanager.cnf
Feb 18 09:35:50 x01tfcdb2a StorageManager[19815]: S3Storage: S3 connectivity & permissions are OK

User can make this work again after stopping/starting the cluster, but it seems it is temporary workaround.

More details is the support ticket.


Generated at Thu Feb 08 02:51:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.