while upgrading sentry selfhosted from 24.4.2 to 24.5.0 we got the error Error in install/upgrade-clickhouse.sh:23.

[balaG4046]

Environment

self-hosted (https://develop.sentry.dev/self-hosted/)

Steps to Reproduce

Hi Team,

while upgrading sentry selfhosted from 24.4.2 to 24.5.0 we got the error Error in install/upgrade-clickhouse.sh:23.

Kindly help us to provide some solution to fix the issue @hubertdeng123

Thanks!

Expected Result

it should upgrade to 24.5.0 without any issue.

Actual Result

Product Area

Releases

Link

No response

DSN

No response

Version

24.5.0

[getsantry]

Assigning to @getsentry/support for routing ⏲️

[hubertdeng123]

Could you provide the docker compose version you are using? I am pretty surprised to see this error. Do you have a modified docker compose file that does not include the service clickhouse?

[balaG4046]

Hi @hubertdeng123
Thanks for your response, our docker-compose version is 1.29.0, build 07737305 no we haven't modified our docker compose file so far and cloud see that clickhouse service is included as well.

Thanks!

[aldy505]

Is there any chance you can upgrade your Docker and remove the docker-compose script? The new Docker Compose shouldn't be using that old docker-compose script anymore, instead you should install a package named docker-compose-plugin from your package registry.

If you're using Debian, check the step 2: https://docs.docker.com/engine/install/debian/#install-using-the-repository
If you're using CentOS, check the step 1: https://docs.docker.com/engine/install/centos/#install-using-the-repository
For any other Linux distros, I believe there's an exact package named "docker-compose-plugin".

[balaG4046]

Hi @aldy505
Sorry my bad, below version is our current version of docker compose -

Thanks!

[HomoSapiens]

I have the same error while upgrading.

# docker compose version
Docker Compose version v2.18.1

Also I have a lot of errors in clickhouse log:

0. Poco::Net::SocketImpl::error(int, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x13c4ee8e in /usr/bin/clickhouse
1. Poco::Net::SocketImpl::peerAddress() @ 0x13c510d6 in /usr/bin/clickhouse   
2. DB::HTTPServerRequest::HTTPServerRequest(std::__1::shared_ptr<DB::Context const>, DB::HTTPServerResponse&, Poco::Net::HTTPServerSession&) @ 0x110e6f0b in /usr/bin/clickhouse                           
3. DB::HTTPServerConnection::run() @ 0x110e5d6e in /usr/bin/clickhouse                               
4. Poco::Net::TCPServerConnection::start() @ 0x13c5614f in /usr/bin/clickhouse                       
5. Poco::Net::TCPServerDispatcher::run() @ 0x13c57bda in /usr/bin/clickhouse                                                                                                                               
6. Poco::PooledThread::run() @ 0x13d89e59 in /usr/bin/clickhouse           
7. Poco::ThreadImpl::runnableEntry(void*) @ 0x13d860ea in /usr/bin/clickhouse                                                                                                                              
8. start_thread @ 0x9609 in /usr/lib/x86_64-linux-gnu/libpthread-2.31.so                                                                                                                                   
9. clone @ 0x122293 in /usr/lib/x86_64-linux-gnu/libc-2.31.so         
 (version 21.8.13.1.altinitystable (altinity build))                          
2024.05.23 04:31:01.763884 [ 17521 ] {} <Error> ServerErrorHandler: Poco::Exception. Code: 1000, e.code() = 107, e.displayText() = Net Exception: Socket is not connected, Stack trace (when copying this m
essage, always include the lines below):                                                             

0. Poco::Net::SocketImpl::error(int, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x13c4ee8e in /usr/bin/clickhouse
1. Poco::Net::SocketImpl::peerAddress() @ 0x13c510d6 in /usr/bin/clickhouse
2. DB::ReadBufferFromPocoSocket::ReadBufferFromPocoSocket(Poco::Net::Socket&, unsigned long) @ 0x101540cd in /usr/bin/clickhouse
3. DB::HTTPServerRequest::HTTPServerRequest(std::__1::shared_ptr<DB::Context const>, DB::HTTPServerResponse&, Poco::Net::HTTPServerSession&) @ 0x110e6fd5 in /usr/bin/clickhouse
4. DB::HTTPServerConnection::run() @ 0x110e5d6e in /usr/bin/clickhouse
5. Poco::Net::TCPServerConnection::start() @ 0x13c5614f in /usr/bin/clickhouse
6. Poco::Net::TCPServerDispatcher::run() @ 0x13c57bda in /usr/bin/clickhouse
7. Poco::PooledThread::run() @ 0x13d89e59 in /usr/bin/clickhouse
8. Poco::ThreadImpl::runnableEntry(void*) @ 0x13d860ea in /usr/bin/clickhouse
9. start_thread @ 0x9609 in /usr/lib/x86_64-linux-gnu/libpthread-2.31.so
10. clone @ 0x122293 in /usr/lib/x86_64-linux-gnu/libc-2.31.so
 (version 21.8.13.1.altinitystable (altinity build))
2024.05.23 04:31:01.880105 [ 16994 ] {} <Error> ServerErrorHandler: Poco::Exception. Code: 1000, e.code() = 107, e.displayText() = Net Exception: Socket is not connected, Stack trace (when copying this m
essage, always include the lines below):

0. Poco::Net::SocketImpl::error(int, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x13c4ee8e in /usr/bin/clickhouse
1. Poco::Net::SocketImpl::peerAddress() @ 0x13c510d6 in /usr/bin/clickhouse
2. DB::ReadBufferFromPocoSocket::ReadBufferFromPocoSocket(Poco::Net::Socket&, unsigned long) @ 0x101540cd in /usr/bin/clickhouse
3. DB::HTTPServerRequest::HTTPServerRequest(std::__1::shared_ptr<DB::Context const>, DB::HTTPServerResponse&, Poco::Net::HTTPServerSession&) @ 0x110e6fd5 in /usr/bin/clickhouse
4. DB::HTTPServerConnection::run() @ 0x110e5d6e in /usr/bin/clickhouse
5. Poco::Net::TCPServerConnection::start() @ 0x13c5614f in /usr/bin/clickhouse
6. Poco::Net::TCPServerDispatcher::run() @ 0x13c57bda in /usr/bin/clickhouse
7. Poco::PooledThread::run() @ 0x13d89e59 in /usr/bin/clickhouse
8. Poco::ThreadImpl::runnableEntry(void*) @ 0x13d860ea in /usr/bin/clickhouse
9. start_thread @ 0x9609 in /usr/lib/x86_64-linux-gnu/libpthread-2.31.so
10. clone @ 0x122293 in /usr/lib/x86_64-linux-gnu/libc-2.31.so
 (version 21.8.13.1.altinitystable (altinity build))
2024.05.23 04:31:01.953308 [ 17564 ] {} <Error> ServerErrorHandler: Poco::Exception. Code: 1000, e.code() = 107, e.displayText() = Net Exception: Socket is not connected, Stack trace (when copying this m
essage, always include the lines below):

but container looks healthy:

# docker ps | grep click
c5d4429fe059   clickhouse-self-hosted-local             "/entrypoint.sh"         6 days ago   Up 6 days (healthy)   8123/tcp, 9000/tcp, 9009/tcp   sentry-clickhouse-1

[Mandalavandalz]

+1

[gianbot]

Hi all,
i have experienced the same problem. We need to use compose >= 2.19.0
https://docs.docker.com/compose/release-notes/#2190

Introduced the ability to select a single service to be stopped by compose down.

I hope it helps you

[davidflypei]

Can confirm upgrading compose > 2.19.0 fixed this issue. We were at 2.16.0 and were getting this error. Upgraded to 2.27.0 it had no issues.

[victornavorskie]

1+

[azaslavsky]

We'll bump this version before the next release - sorry about the churn here folks!

[balaG4046]

Hi All,

Kindly confirm us we are getting the error in clickhouse in install.sh file now we are in docker composer version 2.16.0, if we are upgrading to latest compose version whether issue will get fixed ?

Thanks!

[JannKleen]

I had the same issue and added a PR for this #3078

[balaG4046]

Hi All,

once after we upgraded our docker compose version to 2.19.1 version, now upgrade is successful.

Thanks!