firewalld.service: Start operation timed out. Terminating.

If you are getting the error below:

systemd[1]: firewalld.service: Start operation timed out. Terminating.
systemd[1]: Failed to start firewalld – dynamic firewall daemon.

It may be due to the fact that the process is stuck somehow. Just run the following command to solve the issue:

Terminate the process

pkill -f firewalld

Start firewalld

firewall-cmd --state
systemctl start firewalld
firewall-cmd --state

Bulk insert from File SQL Server

For CSVs

bulk insert
ycsoftware.dbo.ycsoftware 
from '\\192.168.1.1\c$\ycsoftware\files\data.txt'
WITH 
(
FIRSTROW = 2,
FIELDTERMINATOR = '\t',  
ROWTERMINATOR = '\n', 
TABLOCK
)

For TSVs

bulk insert
ycsoftware.dbo.ycsoftware 
from '\\192.168.1.1\c$\ycsoftware\files\data.txt'
WITH 
(
FIRSTROW = 2,
FIELDTERMINATOR = ',',  
ROWTERMINATOR = '\n', 
TABLOCK
)

Issues:
Skipping Auto-increment Column
It is highly suggested that you bulk insert into a temporary table first before you move the data into a production table.
IF the query is run outside the server via SQL Management Studio as an example then you use UNC path for the file name.
Bulk insert runs on the server.

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql